On June 14, 2012 01:10:05 PM Alberto Villa wrote: > On Thursday 14 June 2012 09:59:26 Alberto Villa wrote: > > Found the problem. I was suspecting some kind of overflow, and in fact the > > working limit for wait_timeout here is 21474836, which is (2^31 - 1) / > > 100. > > I'm in contact with ale@, MySQL maintainer, and his tests return a different > value, so would you guys - and anyone with some free time - please test the > number above and report if it works? I'm especially interested in > differences between i386 and amd64.
Hi Alberto, It didn't help me at all. I changed the value, commented out my net_read_timeout (to force the 30 second default) and started KDE. After a few minutes doing other stuff, I went to check my email. Wouldn't work. I suppose I should mention that my email is two imap accounts. Here's the mysql.err file from .local/share/akonadi/db_data/ 120614 9:20:39 InnoDB: The InnoDB memory heap is disabled 120614 9:20:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120614 9:20:39 InnoDB: Compressed tables use zlib 1.2.5 120614 9:20:39 InnoDB: Initializing buffer pool, size = 80.0M 120614 9:20:39 InnoDB: Completed initialization of buffer pool 120614 9:20:39 InnoDB: highest supported file format is Barracuda. 120614 9:20:39 InnoDB: Waiting for the background threads to start 120614 9:20:40 InnoDB: 1.1.8 started; log sequence number 21775976 120614 9:20:41 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.5.25' socket: '/home/dwayne/.local/share/akonadi/socket- hudson.private.lan/mysql.socket' port: 0 Source distribution 120614 9:21:11 [Warning] Aborted connection 5 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) 120614 9:21:11 [Warning] Aborted connection 4 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) 120614 9:21:11 [Warning] Aborted connection 6 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) 120614 9:21:12 [Warning] Aborted connection 8 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) 120614 9:21:13 [Warning] Aborted connection 7 to db: 'akonadi' user: 'dwayne' host: '' (Got timeout reading communication packets) Notice the Aborted connection stuff started exactly 30 seconds after mysqld was ready to accecpt connections. And the akonadiserver.error file: Database error: DataStore::beginTransaction Last driver error: "QMYSQL: Unable to begin transaction" Last database error: "MySQL server has gone away" Database error: DataStore::beginTransaction Last driver error: "QMYSQL: Unable to begin transaction" Last database error: "MySQL server has gone away" Database error: DataStore::beginTransaction Last driver error: "QMYSQL: Unable to begin transaction" Last database error: "MySQL server has gone away" I have both a i386 and amd64 box. Same behaviour on both. Cheers, DMK _______________________________________________ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
