sqlgrey-users

[Sqlgrey-users] SQLgrey encountered an SQL error

[Len C. <lc...@Go...>]

5.0.77 FreeBSD port: mysql-server-5.0.77_1

freebsd 7.2

latest sqlgrey

on the MX remote from the sql srvr, for 16 hours Wed:

egrep -ic "sqlgrey.*grey: new:" /var/log/maillog
201826

on the MX with the sqlgrey db:

mx6# egrep -ic "sqlgrey.*grey: new:" /var/log/maillog
287840

every few hours, and with immediate recovery, we get this error:

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

the hosts are on the same 1GB switch

It's no very "broken", but is it something that can be fixed?

thanks
Len

Re: [Sqlgrey-users] SQLgrey encountered an SQL error

[Philippe C. <sql...@pa...>]

On 11/18/2009 05:00 PM, Len Conrad wrote:
> every few hours, and with immediate recovery, we get this error:
> 
> SQLgrey encountered an SQL error and triggered a reconnection to:
> DBI:mysql:database=sqlgrey;host=xxx

	Does this occur whenever you get an e-mail with a non-ASCII character
in one of the e-mail addresses?  Which is to say anytime you get an
e-mail from someone with an accent in the from address?

					-- Philippe Chaintreuil

Re: [Sqlgrey-users] SQLgrey encountered an SQL error

[Len C. <LC...@Go...>]

>On 11/18/2009 05:00 PM, Len Conrad wrote:
>> every few hours, and with immediate recovery, we get this error:
>> 
>> SQLgrey encountered an SQL error and triggered a reconnection to:
>> DBI:mysql:database=sqlgrey;host=xxx
>
>        Does this occur whenever you get an e-mail with a non-ASCII character
>in one of the e-mail addresses?  Which is to say anytime you get an
>e-mail from someone with an accent in the from address?

out of 100Ks of msgs, I have no way of knowing which message, if any, 
triggered he error.

btw, sqlgrey on localhost and the remote sqlgrey go over tcp (not localhost socket).


Len

Re: [Sqlgrey-users] SQLgrey encountered an SQL error

[Philippe C. <sql...@pa...>]

On 11/18/09 8:41 PM, Len Conrad wrote:
> out of 100Ks of msgs, I have no way of knowing which message, if any, 
> triggered he error.

	But you said that it's a disconnect followed by an basically immediate
reconnect.  I'm assuming you're not getting 100Ks of msg *per second*.
But, I also just noticed your domain in your e-mail address, if you get
"accents" regularly, but not the disconnects that would disprove the
"accents" possibility I mentioned before.
	More information, just in case: I think we've talked before (a year or
two ago) that the "accent" disconnect is from your DB having the "wrong"
language set as it's backing/collating language.  But I don't recall how
one checks that per database or what the suggested fix was....

   -- Philippe Chaintreuil