Am 2014-06-17 16:24, schrieb Charles Marcus: > I'm re-sending this as a new thread, since it is a new issue. > > These occasional errors only started right after I updated to 2.2.5, and > are only happening, once, or yesterday, twice per day. I saw not one of > these in the prior 3 months of using SOGo. > > connect_timeout is set to the default of 10 as it always has. > > Here are the errors in question (these are all of them since we first > started using SOGo in March, as you can see the first one was on 6/12, > right after the 2.2.5 update): > > 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:passw...@myhost.com: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 > > 2014-06-13 03:33:20.201 sogo-tool[6852] ERROR: could not open MySQL4 > connection to database 'sogo': Lost connection to MySQL server at > 'reading authorization packet', system error: 0 > <0x0x1d5f140[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x1c171b0] connection=0x(null)> for URL: > mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder > <0x0x1d5f140[GCSChannelManager]> will prevent opening of this channel > 5 seconds after 2014-06-13 03:33:01 -0400 > 2014-06-13 03:33:20.202 sogo-tool[6852] Can't aquire channel > > 2014-06-14 11:09:19.303 sogo-tool[16644] ERROR: could not open MySQL4 > connection to database 'sogo': Lost connection to MySQL server at > 'reading authorization packet', system error: 0 > <0x0x18c2140[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x177a1b0] connection=0x(null)> for URL: > mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder > <0x0x18c2140[GCSChannelManager]> will prevent opening of this channel > 5 seconds after 2014-06-14 11:09:01 -0400 > 2014-06-14 11:09:19.304 sogo-tool[16644] Can't aquire channel > > 2014-06-14 19:29:16.259 sogo-tool[4321] ERROR: could not open MySQL4 > connection to database 'sogo': Lost connection to MySQL server at > 'reading authorization packet', system error: 0 > <0x0x1ff4140[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x1eac1b0] connection=0x(null)> for URL: > mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder > <0x0x1ff4140[GCSChannelManager]> will prevent opening of this channel 5 > seconds after 2014-06-14 19:29:01 -0400 2014-06-14 19:29:16.260 > sogo-tool[4321] Can't aquire channel > > 2014-06-15 11:36:12.184 sogo-tool[11336] ERROR: could not open MySQL4 > connection to database 'sogo': Lost connection to MySQL server at > 'reading authorization packet', system error: 0 > <0x0x1534410[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x13ec1b0] connection=0x(null)> for URL: > mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder > <0x0x1534410[GCSChannelManager]> will prevent opening of this channel 5 > seconds after 2014-06-15 11:36:02 -0400 2014-06-15 11:36:12.185 > sogo-tool[11336] Can't aquire channel > > 2014-06-16 19:29:17.300 sogo-tool[22163] ERROR: could not open MySQL4 > connection to database 'sogo': Lost connection to MySQL server at > 'reading authorization packet', system error: 0 > <0x0x20a4410[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x1f5c1b0] connection=0x(null)> for URL: > mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder > <0x0x20a4410[GCSChannelManager]> will prevent opening of this channel > 5 seconds after 2014-06-16 19:29:01 -0400 2014-06-16 19:29:17.301 > sogo-tool[22163] Can't aquire channel > > 2014-06-17 03:08:22.791 sogo-tool[24540] ERROR: could not open MySQL4 > connection to database 'sogo': Lost connection to MySQL server at > 'reading authorization packet', system error: 0 > <0x0x282b410[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x26e31b0] connection=0x(null)> for URL: > mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder > <0x0x282b410[GCSChannelManager]> will prevent opening of this channel 5 > seconds after 2014-06-17 03:08:01 -0400 2014-06-17 03:08:22.792 > sogo-tool[24540] Can't aquire channel > > 2014-06-17 03:32:14.985 sogo-tool[24652] ERROR: could not open MySQL4 > connection to database 'sogo': Lost connection to MySQL server at > 'reading authorization packet', system error: 104 > <0x0x172b410[GCSChannelManager]> could not open channel > <MySQL4Channel[0x0x15e31b0] connection=0x(null)> for URL: > mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder > <0x0x172b410[GCSChannelManager]> will prevent opening of this channel 5 > seconds after 2014-06-17 03:32:01 -0400 2014-06-17 03:32:14.988 > sogo-tool[24652] Can't aquire channel > > Anyone have any ideas? Everything seems to be working fine, and like I > said, they only happen once per day (except twice today)... >
We see more connections to the database since SOGo 2.2.4. This error says, you lost a connection in mid transport of data and it can not open a new one. That is a really generic problem. Perhaps your network is busy. Perhaps you run out of port numbers. Perhaps you have not enough file descriptors. Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature