Re: [Sqlgrey-users] Frequent disconnect/reconnect issues

[Alex <mys...@gm...>]

Hi guys,

I sent the message below a few days ago, and haven't received any
responses. I'm still having difficulty with this and really don't know
how to resolve it. It appears to happen to all three systems, two of
which are on the same gigabit network, and the other is on a remote
cable connection (which is the one that least frequently fails).

Would rebuilding the database help? I haven't even been able to find
an error in the logs related to this, only the email that is sent
every time it happens.

Thanks,
Alex


On Tue, Aug 11, 2015 at 7:13 PM, Alex <mys...@gm...> wrote:
> Hi,
>
> I've been running sqlgrey on fedora for quite a while, set up to use
> DB_Cluster with a single master set up with mysql (mariadb). Recently,
> I've started to receive a large number of "sqlgrey encountered an SQL
> error and triggered a reconnection" messages, followed immediately by
> a reconnection message.
>
> It seems to happen at all times during the day, not just when the
> network or server is congested or busy.
>
> There are three read_hosts, including the master itself, but one of
> the hosts has multiple DNS names, so it may be listed twice.
>
> I don't exactly remember how the database schema was set up, which is
> kind of a problem if I ever had to set it up again.
>
> I've included the sqlgrey.conf config below, in hopes someone had some
> ideas how to troubleshoot this. This is the config that's been working
> fine for more than a year.
>
> # cat sqlgrey.conf |grep '^[a-z|A-Z]'
> loglevel = 3
> log_override = whitelist:1,grey:3,spam:2
> reconnect_delay = 5
> awl_age = 31
> group_domain_level = 10
> db_type = mysql
> db_name = sqlgrey
> db_host = ns1.example.com;mysql_connect_timeout=1
> db_port = default
> db_user = sqlgrey
> db_pass = mypass
> db_cleanup_hostname=ns1.example.com
> db_cleandelay = 1800
> clean_method = sync
> db_cluster = on
> read_hosts=localhost,ns1.example.com,mail02.example.com,mail03.example.com,mail01.example.com
> prepend = 1
> admin_mail = 212...@me...
>
> Thanks,
> Alex