[Bug 578357] Re: MySql log file problem prevents Akonadi startup

[GerhardGaußling]

I got a similar issue with kontact/akonadi (No resource agents have been
found).

$ sudo aa-complain mysqld
[sudo] password for gerhard: 
Setting /usr/sbin/mysqld to complain mode.

$ sudo aa-complain mysqld-akonadi
Setting /etc/apparmor.d/usr.sbin.mysqld-akonadi to complain mode.

$ sudo /etc/init.d/apparmor reload
 * Reloading AppArmor profiles                                                                                                                                                Skipping profile in /etc/apparmor.d/disable: usr.bin.firefox
Skipping profile in /etc/apparmor.d/disable: usr.bin.firefox-3.7
Warning: found usr.bin.freshclam in /etc/apparmor.d/force-complain, forcing complain mode
Warning: found usr.sbin.mysqld in /etc/apparmor.d/force-complain, forcing complain mode
Warning: found usr.sbin.ntpd in /etc/apparmor.d/force-complain, forcing complain mode


$ akonadictl restart
[...]
[akonadiserver] Found mysql_upgrade:  "/usr/bin/mysql_upgrade"
"akonadiserver" [out] "Looking for 'mysql' as: /usr/bin/mysql
" 
"akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
" 
"akonadiserver" [out] "Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/home/gerhard/.local/share/akonadi/db_misc/mysql.socket' 
" 
[akonadiserver] /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/gerhard/.local/share/akonadi/db_misc/mysql.socket' (2) when trying to connect
[akonadiserver] FATAL ERROR: Upgrade failed
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[...]


$ mysqlcheck --port=3306 --socket=/var/run/mysqld/mysqld.sock --socket=/home/gerhard/.local/share/akonadi/db_misc/mysql.socket -g -a --auto-repair akonadi 
akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK

$ cat $HOME/.local/share/akonadi/db_data/mysql.err
100717 13:59:35 [Note] Plugin 'FEDERATED' is disabled.
100717 13:59:36  InnoDB: Started; log sequence number 0 3093356
100717 13:59:36 [Note] /usr/sbin/mysqld-akonadi: ready for connections.
Version: '5.1.41-3ubuntu11-log'  socket: '/home/gerhard/.local/share/akonadi/db_misc/mysql.socket'  port: 0  (Ubuntu)

$ grep -i ERR $HOME/.local/share/akonadi/db_data/mysql.err.old|sort -u
100608 19:05:39 [ERROR] Aborting
100608 19:05:39 [ERROR] Plugin 'InnoDB' init function returned error.
100608 19:05:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100608 19:05:39 [ERROR] Unknown/unsupported table type: innodb
100608 19:05:39  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error in opening ./ibdata1
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: Some operating system error numbers are described at
InnoDB: Unable to lock ./ibdata1, error: 11

$ ls -l /home/gerhard/.local/share/akonadi/db_data/ibdata1 
-rw-rw---- 1 gerhard gerhard 10485760 2010-07-17 13:59 /home/gerhard/.local/share/akonadi/db_data/ibdata1

$ file /home/gerhard/.local/share/akonadi/db_data/ibdata1
/home/gerhard/.local/share/akonadi/db_data/ibdata1: data

but these InnoDB errors are logged in mysql.err.old

After doing all this Stuff I'm able to open the kontact addressbook, but
restarting aconadi gives still error 2002: Can't connect to local MySQL
server through socket [akonadiserver] FATAL ERROR: Upgrade failed

The error still remain the same after moving the ib_logfiles:
$ mv $HOME/.local/share/akonadi/db_data/ib_logfile0 $HOME/.local/share/akonadi/db_data/_ib_logfile0
$ mv $HOME/.local/share/akonadi/db_data/ib_logfile1 $HOME/.local/share/akonadi/db_data/_ib_logfile1

What I didn't tried yet:
1. Stop akonadi and close kontact
2. mv .local/share/akonadi .local/share/akonadi.bak
3. sudo aa-complain mysqld-akonadi
4. start akonadi (akonadictl start)

-- 
MySql log file problem prevents Akonadi startup
https://bugs.launchpad.net/bugs/578357
You received this bug notification because you are a member of Kubuntu
Bugs, which is subscribed to akonadi in ubuntu.