Re: [Sqlgrey-users] concatenation errors

[Regan Y. <reg...@gm...>]

On 13/11/2013, at 7:26 am, Dan Faerch <da...@ha...> wrote:

> Regan Yelcich wrote:
>> Hi Anyone,
>> I'm not sure what has changed? But my install of sqlgrey is logging these
>> errors....
>> 
>> Nov 12 14:59:10 admin-sql-0 sqlgrey: warning: Use of uninitialized value
>> $DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey line
>> 241.
>> 
> 
> So, i assume that i was right in my last reply and DBI was missing? If so,
> my next guess is that this new error is most likely the lack of
> DBD::mysql.
> 
> Regards
> - Dan


Hi Dan,

No, all of the dependencies were installed.

I solved the initial DBIx::DBCluster issue by compiling it from source. Initially I installed using "apt-get install sqlgrey" which I now know isn't/wasn't compiled with cluster support. :|

Just figured out the error (above) was caused the MySQL Master having read_only = 1 after an automated failover. Found that after running the trailing sql command by hand. Slightly ambiguous error from sqlgrey. :)

Last problem to solve... (hopefully).... consistently after X amount of time I'm getting a "database error" email immediately followed by the "recovered DB" email. So it appears to fail, and then immediately retries and makes a successful connection.

Any ideas on this one? I read about changing the database type to ascii so I've done that and re-created it. Still the same error.

Regan

>>>>>>>>>>>

Nov 13 07:42:38 mta-0 sqlgrey: warning: Use of uninitialized value $DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey line 387.
Nov 13 07:42:38 mta-0 sqlgrey: dbaccess: error: couldn't get now() from DB: 
Nov 13 07:42:38 mta-0 sqlgrey: dbaccess: Using DBIx:DBCluster

>>>>>>>>>>>

SQLgrey database error
SQLgrey encountered an SQL error and triggered a reconnection to: DBI:mysql:database=sqlgrey;host=10.189.254.22;port=3306

>>>>>>>>>>>

SQLgrey recovered DB
SQLgrey established connection to: DBI:mysql:database=sqlgrey;host=10.189.254.22;port=3306