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
$ 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)
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 d/usr.sbin. mysqld- akonadi to complain mode.
Setting /etc/apparmor.
$ sudo /etc/init. d/apparmor reload d/disable: usr.bin.firefox d/disable: usr.bin.firefox-3.7 d/force- complain, forcing complain mode d/force- complain, forcing complain mode d/force- complain, forcing complain mode
* Reloading AppArmor profiles Skipping profile in /etc/apparmor.
Skipping profile in /etc/apparmor.
Warning: found usr.bin.freshclam in /etc/apparmor.
Warning: found usr.sbin.mysqld in /etc/apparmor.
Warning: found usr.sbin.ntpd in /etc/apparmor.
$ akonadictl restart mysql_upgrade" /var/run/ mysqld/ mysqld. sock' '--socket= /home/gerhard/ .local/ share/akonadi/ db_misc/ mysql.socket' 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 :run()
[...]
[akonadiserver] Found mysql_upgrade: "/usr/bin/
"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=
"
[akonadiserver] /usr/bin/
[akonadiserver] FATAL ERROR: Upgrade failed
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer:
[...]
$ mysqlcheck --port=3306 --socket= /var/run/ mysqld/ mysqld. sock --socket= /home/gerhard/ .local/ share/akonadi/ db_misc/ mysql.socket -g -a --auto-repair akonadi collectionattri butetable OK collectionmimet yperelation OK collectionpimit emrelation OK collectiontable OK mimetypetable OK pimitemflagrela tion OK pimitemtable OK resourcetable OK schemaversionta ble OK
akonadi.
akonadi.
akonadi.
akonadi.
akonadi.flagtable OK
akonadi.
akonadi.parttable OK
akonadi.
akonadi.
akonadi.
akonadi.
$ cat $HOME/. local/share/ akonadi/ db_data/ mysql.err mysqld- akonadi: ready for connections. 3ubuntu11- log' socket: '/home/ gerhard/ .local/ share/akonadi/ db_misc/ mysql.socket' port: 0 (Ubuntu)
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/
Version: '5.1.41-
$ grep -i ERR $HOME/. local/share/ akonadi/ db_data/ mysql.err. old|sort -u dev.mysql. com/doc/ refman/ 5.1/en/ operating- system- error-codes. html
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://
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 .local/ share/akonadi/ db_data/ ibdata1
-rw-rw---- 1 gerhard gerhard 10485760 2010-07-17 13:59 /home/gerhard/
$ file /home/gerhard/ .local/ share/akonadi/ db_data/ ibdata1 .local/ share/akonadi/ db_data/ ibdata1: data
/home/gerhard/
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: local/share/ akonadi/ db_data/ ib_logfile0 $HOME/. local/share/ akonadi/ db_data/ _ib_logfile0 local/share/ akonadi/ db_data/ ib_logfile1 $HOME/. local/share/ akonadi/ db_data/ _ib_logfile1
$ mv $HOME/.
$ mv $HOME/.
What I didn't tried yet: share/akonadi .local/ share/akonadi. bak
1. Stop akonadi and close kontact
2. mv .local/
3. sudo aa-complain mysqld-akonadi
4. start akonadi (akonadictl start)