← Back to team overview

maria-discuss team mailing list archive

Re: Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

 

Hi, Tanstaafl!

On Jun 18, Tanstaafl wrote:
> Hi all,
> 
> I'm very inexperienced mariadb/mysql/sql user/admin, but not totally 
> clueless, been maintaining a tiny mysql DB for postfixadmin for years, 
> then converted it to mariadb.
> 
> We recently started using SOGo (groupware). I hired the SOGo guys to 
> help with the install/config, and have been using it trouble-free for a 
> few months now (love it for the most part), until now.
> 
> Everything seems to be working fine, but since the upgrade to SOGo 2.2.4 
> on 6/12, which I am told increases the number of connections it uses to 
> the DB, I have been getting very occasional errors like this (the system 
> error is always either 104 or 0):
> 
> 2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4
> connection to database 'sogo': Lost connection to MySQL server at
> 'reading authorization packet', system error: 104
> <0x0x236c140[GCSChannelManager]> could not open channel
> <MySQL4Channel[0x0x22241b0] connection=0x(null)> for URL:
> mysql://user:password@xxxxxxxxxx:3306/sogo/sogo_sessions_folder
> <0x0x236c140[GCSChannelManager]>   will prevent opening of this channel
> 5 seconds after 2014-06-12 03:30:01 -0400
> 2014-06-12 03:30:15.531 sogo-tool[31674] Can't aquire channel
> 
> But it only happened once per day after the upgrade, then once it 
> happened twice (about 12 hours apart), and it happened at times when the 
> load would be the lowest (ie, 3:30am for the one above).

MySQL4 - what does it mean? Using the protocol as it existed in MySQL
version 4.x?

The connector - does SOGo use libmysqlclient of some specific version?
Does it have its own implementation of MySQL protocol?
 
Regards,
Sergei



References