[Sqlgrey-users] concatenation errors

[Regan Yelcich]

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.
Nov 12 14:59:10 admin-sql-0 sqlgrey: dbaccess: warning: couldn't do query:#012UPDATE config SET value = '1384221550' WHERE parameter = 'last_dbclean' AND value = '1383601636':#012, reconnecting to DB

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.
Nov 12 14:59:10 admin-sql-0 sqlgrey: dbaccess: warning: couldn't do query:#012UPDATE from_awl SET last_seen = NOW(), first_seen = first_seen WHERE sender_name = 'XXXXXXXX' AND sender_domain = 'gmail.com' AND src = '209.85.192':#012, reconnecting to DB

Any idea how to fix this one?

Regan

[Karl O. Pinc]

Post by Regan Yelcich
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.
Nov 12 14:59:10 admin-sql-0 sqlgrey: dbaccess: warning: couldn't do
query:#012UPDATE config SET value = '1384221550' WHERE parameter =
'last_dbclean' AND value = '1383601636':#012, reconnecting to DB
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.
Nov 12 14:59:10 admin-sql-0 sqlgrey: dbaccess: warning: couldn't do
query:#012UPDATE from_awl SET last_seen = NOW(), first_seen =
first_seen WHERE sender_name = 'XXXXXXXX' AND sender_domain =
'gmail.com' AND src = '209.85.192':#012, reconnecting to DB
Any idea how to fix this one?

No, but if $DBI::error string is uninitialized that suggests
that something (DBI-ish?) is not installed on your system.
Check that you've all the prerequisites installed.



Karl <***@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

[Dan Faerch]

Post by Regan Yelcich
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

[Regan Yelcich]

Post by Dan Faerch

Post by Regan Yelcich
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