[kdepim-users] akonadi error - fails to start
dirk
dirk.meier at gmx.de
Thu Nov 20 12:57:34 GMT 2014
Am 19.11.2014 00:15, schrieb René J.V. Bertin:
> On Tuesday November 18 2014 23:50:29 dirk wrote:
>
>> dirk at azid:~> ps axlww | fgrep -i mysql
>> 0 1000 5173 1 20 0 338732 31676 - Sl ? 1:10 /usr/sbin/mysqld
>> 0 1004 20637 20635 20 0 1514684 33888 ? Sl ? 0:56 /usr/sbin/mysqld
>>
>> dirk at azid:~> od -x ~/.local/share/akonadi/db_data/ibdata1
>> shows a file looks like something like this:
>>
>> snip
>>
>> 22440120 ffff ffff ffff ffff ffff ffff ffff ffff
>> Does it help?
> Yes, and no :) The ps command was to see if you have 2 mysqld processes running, but of course I should have asked you to do an akonadictl stop first. Was akonadi running when you did the ps command above? If it was NOT, you should try to kill the mysqld process that's yours (pid 5173 I guess), and try to start akonadi, because in that case the error message about not being able to lock the database was correct.
>
> As to the file contents: it shows that your file doesn't consist of only zeroes. However you left out a large chunk from the start. BTW, even if those are octal numbers, they're huge. If I'm not mistaken the part you show starts at about 464Mb into the database ... just how large is it?
>
> R.
> _______________________________________________
> KDE PIM users mailing list
> Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users
>
Well, starting with a freshly rebooted system:
dirk at azid:~> akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (backend: Virtuoso)
ps axlww | fgrep -i mysql
0 1000 5095 1 20 0 338732 28436 - Sl ? 0:00
/usr/sbin/mysqld
--defaults-file=/home/dirk/.local/share/akonadi/mysql.conf
--datadir=/home/dirk/.local/share/akonadi/db_data/
--socket=/home/dirk/.local/share/akonadi/socket-azid/mysql.socket
0 1000 5844 1 20 0 293560 19348 - Sl ? 0:00
/usr/sbin/mysqld
--defaults-file=/home/dirk/.local/share/akonadi/mysql.conf
--datadir=/home/dirk/.local/share/akonadi/db_data/
--socket=/home/dirk/.local/share/akonadi/socket-azid/mysql.socket
0 1000 5858 1 20 0 293560 19344 - Sl ? 0:00
/usr/sbin/mysqld
--defaults-file=/home/dirk/.local/share/akonadi/mysql.conf
--datadir=/home/dirk/.local/share/akonadi/db_data/
--socket=/home/dirk/.local/share/akonadi/socket-azid/mysql.socket
0 1000 5872 1 20 0 293560 19348 - Sl ? 0:00
/usr/sbin/mysqld
--defaults-file=/home/dirk/.local/share/akonadi/mysql.conf
--datadir=/home/dirk/.local/share/akonadi/db_data/
--socket=/home/dirk/.local/share/akonadi/socket-azid/mysql.socket
0 1000 5889 1 20 0 293560 19348 - Sl ? 0:00
/usr/sbin/mysqld
--defaults-file=/home/dirk/.local/share/akonadi/mysql.conf
--datadir=/home/dirk/.local/share/akonadi/db_data/
--socket=/home/dirk/.local/share/akonadi/socket-azid/mysql.socket
0 1000 6252 5662 20 0 7880 864 - R+ pts/1 0:00
fgrep --color=auto -i mysql
dirk at azid:~> ps axlww | fgrep -i mysql
0 1000 6440 5662 20 0 7876 864 - R+ pts/1 0:00
fgrep --color=auto -i mysql
dirk at azid:~> akonadictl start > akonadictl.err 2>&1
dirk at azid:~> less akonadictl.err
Starting Akonadi Server...
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
done.
search paths: ("/home/dirk/bin", "/usr/local/bin", "/usr/bin", "/bin",
"/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/usr/lib/mit/bin",
"/usr/lib/mit/sbin", "/usr/sbin", "/usr/local/sbin",
"/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec",
"/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL3
QMYS%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00
snip
...
snip
00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%00%0
Invalid database object during database server startup
"[
0: akonadiserver(_Z11akBacktracev+0x34) [0x458664]
1: akonadiserver() [0x4589a1]
2: /lib64/libc.so.6(+0x34da0) [0x7fa85158cda0]
3: /lib64/libc.so.6(gsignal+0x35) [0x7fa85158cd25]
4: /lib64/libc.so.6(abort+0x148) [0x7fa85158e1a8]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7fa8530679a4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9b) [0x45a83b]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7fa8531007c4]
8: /usr/lib64/libQtCore.so.4(+0x11b46f) [0x7fa85310b46f]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7fa853113a6b]
10: akonadiserver(_ZN6QDebugD1Ev+0x3f) [0x4524ff]
11: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x2c5c)
[0x4e2dbc]
12:
akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xc7)
[0x45b5e7]
13: akonadiserver(_ZN7Akonadi13AkonadiServerC1EP7QObject+0xac) [0x45cc5c]
14: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x47) [0x45e347]
15: akonadiserver(main+0x10a) [0x451bca]
16: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fa851579455]
17: akonadiserver() [0x452371]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
"akonadiserver" crashed too often and will not be restarted!
dirk at azid:~> od -x ~/.local/share/akonadi/db_data/ibdata1 > od_output.txt
dirk at azid:~> less od_output.txt
0000000 5cd9 be53 0000 0000 0000 0000 0000 0000
0000020 0000 0000 1800 1459 0800 0000 0000 1800
0000040 1b59 0000 0000 0000 0000 0000 0000 0000
0000060 8004 0000 4001 0000 0000 0000 3200 0000
0000100 0000 ffff ffff 0000 ffff ffff 0000 0000
0000120 0100 0000 0000 3e01 0000 0000 3e01 0000
0000140 0200 0000 0000 9e00 0000 0000 1601 0000
0000160 0000 0000 9800 0000 0100 0000 0200 2600
0000200 0000 0200 2600 0000 0100 0000 f300 2600
0000220 0000 f300 2600 0000 0000 0000 0000 ffff
0000240 ffff 0000 0000 0000 1601 0000 0300 aaaa
0000260 aaaa aaaa aaaa aaaa aaaa aaaa aaaa 0000
0000300 0000 0000 0f00 ffff ffff 0000 0000 0000
0000320 ee00 0000 0400 aaaa aaaa aaaa aaaa aaaa
0000340 aaaa aaaa aaaa 0000 0000 0000 0f00 0000
0000360 0000 c600 ffff ffff 0000 0000 0400 aaaa
0000400 aaaa aaaa aaaa aaaa aaaa aaaa aaaa 0000
0000420 0000 0000 0000 0000 0000 9e00 ffff ffff
0000440 0000 0000 0300 aaaa aaaa aaaa aaaa aaaa
0000460 aaaa aaaa aaaa 0000 0000 0000 0000 ffff
0000500 ffff 0000 ffff ffff 0000 0000 0200 aaaa
0000520 aaaa aaaa aaaa aaaa aaaa fffa ffff 0000
0000540 0000 0000 0000 0000 0000 0000 0000 0000
*
0037760 0000 0000 0000 0000 b520 d9a2 1800 1459
0040000 377b 03d8 0000 0100 0000 0000 0000 0000
0040020 0000 0000 1800 914c 0500 0000 0000 0000
0040040 0000 0000 0000 0000 0000 0000 0000 0000
*
0077760 0000 0000 0000 0000 994f 9a3c 1800 914c
snip
...
snip
22740160 0308 0000 7573 7270 6d65 6d75 0000 0000
22740200 0000 0000 0000 0000 0000 0000 0000 0000
*
22777760 0000 0000 7400 6500 cf26 97b6 1800 f44b
23000000 472e 80b8 0000 3001 ffff ffff ffff ffff
23000020 0000 0000 1800 4151 bf45 0000 0000 0000
23000040 0000 0000 0000 0200 7d00 0200 0000 0000
23000060 0000 0500 0000 0000 0000 0000 0000 0000
23000100 0000 0000 0000 0000 0d00 0000 0000 0000
23000120 f300 722f 0000 0000 0000 f300 b22e 0108
23000140 0000 0003 6974 666e 6d69 6d75 0900 0001
23000160 0308 0000 7573 7270 6d65 6d75 0000 0000
23000200 0000 0000 0000 0000 0000 0000 0000 0000
*
23037760 0000 0000 7400 6500 7c30 a2f4 1800 4151
23040000 7a36 ba42 0000 3101 ffff ffff ffff ffff
23040020 0000 0000 1800 1459 bf45 0000 0000 0000
23040040 0000 0000 0000 0200 7d00 0200 0000 0000
23040060 0000 0500 0000 0000 0000 0000 0000 0000
23040100 0000 0000 0000 0000 0e00 0000 0000 0000
23040120 f300 f230 0000 0000 0000 f300 3230 0108
23040140 0000 0003 6974 666e 6d69 6d75 0900 0001
23040160 0308 0000 7573 7270 6d65 6d75 0000 0000
23040200 0000 0000 0000 0000 0000 0000 0000 0000
*
23077760 0000 0000 7400 6500 bf5d 593e 1800 1459
23100000 0000 0000 0000 0000 0000 0000 0000 0000
*
110000000
od_output.txt lines 4924-4953/4953 (END)
file size is:
ls -l od_output.txt
-rw-r--r-- 1 dirk users 194592 20. Nov 13:50 od_output.txt
There is a second user on system with akonadi running.
--
Dirk
_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users
More information about the kdepim-users
mailing list