[kde-freebsd] Akonadi/mysqld problems

[Dwayne MacKinnon]

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