[kdepim-users] akonadi error 10
Andre Bischof
a.bischof at gmx.net
Wed Aug 19 22:23:16 BST 2009
Kevin Krammer schrieb:
...
>> frisco 9117 0.1 0.3 134336 12820 ? Sl 16:09 0:00 \_
>> /usr/sbin/mysqld
>> --defaults-file=/home/frisco/.local/share/akonadi//mysql.conf
>> --datadir=/home/frisco/.loca
>> l/share/akonadi/db_data/
>> --socket=/home/frisco/.local/share/akonadi/db_misc/mysql.socket
>> frisco 9099 0.5 0.4 170716 19004 ? Sl 16:09 0:00
>> /usr/sbin/mysqld
>> --defaults-file=/home/frisco/.local/share/akonadi//mysql.conf
>> --datadir=/home/frisco/.local/share/
>> akonadi/db_data/
>> --socket=/home/frisco/.local/share/akonadi/db_misc/mysql.socket
>>
>> Why is mysqld being run twice? Is that supposed to be normal behaviour?
>> There's a doubled slash with the defaults-files, could that be cause of
>> trouble?
>
> Two instances is strange. The double slash should be ok (same here).
> If I do ps wwwauxf |grep mysql I get
ok, so that's maybe one piece of the puzzle.
...
>>> If not, what happens if you run this manually:
>>>
>>> /usr/sbin/mysqld \
>>> --defaults-file=/home/frisco/.local/share/akonadi/mysql.conf \
>>> --datadir=/home/frisco/.local/share/akonadi/db_data/ \
>>> --socket=/home/frisco/.local/share/akonadi/db_misc/mysql.socket
>> I deleted all mysql processes again, then did the command above.
>>
>> frisco at linux$ /usr/sbin/mysqld
>> --defaults-file=/home/frisco/.local/share/akonadi/mysql.conf
>> --datadir=/home/frisco/.local/share/akonadi/db_data/
>> --socket=/home/frisco/.local/share/akonadi/db_misc/mysql.socket
>> 090819 16:22:54 [Warning] Changed limits: max_open_files: 1024
>> max_connections: 256 table_cache: 379
Should the changed limits bother me? But you say it's probably unrelated
to the database, so let's see what the rest will show ...
...
> It seems to be a problem in Akonadi Server, unrelated to the database.
>
>> I started akonaditray from KDE's utility menu, which gives me an entry
>> in the system tray telling "Akonadi is not running". Hm?
>
> Well, the Akonadi service crashed and restarting it didn't work a couple of
> times so the control process gave up.
yes, I know that from former attempts with starting akonadi via
akonadictl, deleting .local/.../akonadi and .config/.../akonadi before
(see first post in thread with pastebin output of akonadictl -> problems
creating one of the database's tables).
> Unfortunately this means we have something totally new here.
> Stop Akonadi like this
>
> % akonadictl stop
>
> then check if there are now Akonadi processes running (e.g.output of 'ps x'
> does not contain any "akonadi" strings).
> Check (or kill) remaining mysql instances.
> Remove ~/.config/akonadi and ~/.local/share/akonadi and
> ~/.kde/share/config/akonadi*rc
>
>
> Check again that Akonadi is not running.
> Try starting it
> % akonadictl start
Belief me or not, but here are strange things going on. Could it be that
akonadi is started by something automatically or in regular intervalls?
I did:
frisco at linux:~$ akonadictl stop
frisco at linux:~$ pstree |more
init-+-akonadi_control-+-akonadiserver-+-mysqld---4*[{mysqld}]
| | `-{akonadiserver}
| `-{akonadi_control}
So it was still running, mysql processes were visible as well.
Some seconds later akonadi_control was not visible in the process list,
but the 9 mysql processes remained.
watch -d -n2 'ps wwwauxf |grep akonadi
told me:
Every 2,0s: ps wwwauxf |grep akonadi
Wed Aug 19 23:11:47 2009
root 18654 0.2 0.0 2492 968 pts/3 R+ 23:07 0:00 | \_
watch -d -n2 ps wwwauxf |grep akonadi
root 19438 0.0 0.0 2492 340 pts/3 R+ 23:11 0:00 |
\_ watch -d -n2 ps wwwauxf |grep akonadi
root 19439 0.0 0.0 3008 1132 pts/3 R+ 23:11 0:00 |
\_ sh -c ps wwwauxf |grep akonadi
frisco 18512 0.0 0.4 170716 19000 ? Sl 23:01 0:00
/usr/sbin/mysqld
--defaults-file=/home/frisco/.local/share/akonadi//mysql.conf
--datadir=/home/frisco/.local/share/
akonadi/db_data/
--socket=/home/frisco/.local/share/akonadi/db_misc/mysql.socket
So it's still running. No killing everthing explicitly:
$ killall -s 9 mysqld
frisco at linux:~$ rm -Rf ~/.config/akonadi && rm -Rf
~/.local/share/akonadi && rm -Rf ~/.kde/share/config/akonadi*rc
frisco at linux:~$ ps x |egrep "akonadi|mysql"
19643 pts/5 S+ 0:00 egrep akonadi|mysql
frisco at linux:~$
okay then, now:
frisco at linux:~$ akonadictl start
Starting Akonadi Server...
done.
frisco at linux:~$ [akonadiserver] Failed to use database "akonadi"
[akonadiserver] Query error: "Unknown database 'akonadi' QMYSQL: Unable
to execute query"
[akonadiserver] Database error: " "
[akonadiserver] Trying to create database now...
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT
NULL);"
i[akonadiserver] checking table "ResourceTable"
[akonadiserver] "CREATE TABLE ResourceTable (id BIGINT NOT NULL PRIMARY
KEY AUTO_INCREMENT, name VARCHAR(255) BINARY NOT NULL UNIQUE);"
[akonadiserver] checking table "LocationTable"
[akonadiserver] "CREATE TABLE LocationTable (id BIGINT NOT NULL PRIMARY
KEY AUTO_INCREMENT, remoteId TEXT , name VARCHAR(255) BINARY character
set utf8 collate utf8_bin NOT NULL, parentId BIGINT DEFAULT 0 REFERENCES
Location(id), resourceId BIGINT NOT NULL REFERENCES Resource(id),
subscribed BOOL NOT NULL DEFAULT true, cachePolicyInherit BOOL NOT NULL
DEFAULT true, cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1,
cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1,
cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false,
cachePolicyLocalParts TEXT );"
[akonadiserver] "Unable to create entire table."
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z10kBacktracev+0x35) [0x8051f65]
[akonadiserver] 1: akonadiserver [0x8052446]
[akonadiserver] 2: [0xb80b5400]
[akonadiserver] 3: [0xb80b5424]
[akonadiserver] 4: /lib/i686/cmov/libc.so.6(gsignal+0x50) [0xb7a103d0]
[akonadiserver] 5: /lib/i686/cmov/libc.so.6(abort+0x185) [0xb7a13a85]
[akonadiserver] 6:
/usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8d)
[0xb7d7c3ed]
[akonadiserver] 7:
akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053154]
[akonadiserver] 8:
/usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0xb7e0ec5e]
[akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb7e1bba5]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68)
[0xb7e1bec8]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804dc74]
[akonadiserver] 12:
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x62e)
[0xb7fbd76e]
[akonadiserver] 13:
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56)
[0xb7fbe2d6]
[akonadiserver] 14: akonadiserver(main+0x398) [0x804d018]
[akonadiserver] 15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5)
[0xb79fb7a5]
[akonadiserver] 16: akonadiserver [0x804cbb1]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
so akonadiserver seems not to be able to create the table LocationTable,
and thus fails to initialize the database.
> then
>
> % akonadictl status
frisco at linux:~$ akonadictl status
Akonadi Control: running
Akonadi Server: stopped
frisco at linux:~$
Full process list for debugging purposes:
# pstree
init-+-akonadi_control-+-akonadiserver-+-mysqld---4*[{mysqld}]
| | `-{akonadiserver}
| `-{akonadi_control}
|-amavisd-new---2*[amavisd-new]
|-apache2---10*[apache2]
|-artsd
|-atd
|-chipcardd4---chipcardd4
|-clamd---{clamd}
|-console-kit-dae---63*[{console-kit-dae}]
|-cron
|-cupsd
|-cyrmaster-+-3*[imapd]
| `-notifyd
|-2*[dbus-daemon]
|-dbus-launch
|-fail2ban-server---6*[{fail2ban-server}]
|-fetchmail
|-gam_server
|-gconfd-2
|-gdm---gdm-+-Xorg
| `-startkde-+-kwrapper4
| `-ssh-agent
|-6*[getty]
|-21*[gnome-keyring-d]
|-gpm
|-hald---hald-runner-+-hald-addon-acpi
| |-hald-addon-inpu
| `-6*[hald-addon-stor]
|-hddtemp
|-inetd
|-iwatch
|-kaccess
|-kded4---{kded4}
|-kdeinit4-+-firefox-bin---8*[{firefox-bin}]
|
|-icedove---run-mozilla.sh---icedove-bin---9*[{icedove-bin}]
| |-kio_file
| |-klauncher
| |-ksmserver-+-kwin
| | `-{ksmserver}
| |-kwrited
| `-smart-notifier
|-kglobalaccel
|-klogd
|-kmix
|-knotify4---3*[{knotify4}]
|-konsole-+-bash
| |-bash---screen
| `-{konsole}
|-krunner
|-master-+-pickup
| `-qmgr
|-mediatomb---8*[{mediatomb}]
|-mysqld---9*[{mysqld}]
|-nepomukserver
|-nmbd
|-nxstat
|-plasma-desktop---{plasma-desktop}
|-portmap
|-postgres---4*[postgres]
|-rpc.mountd
|-rpc.statd
|-screen-+-bash---pstree
| |-5*[bash]
| |-tail
| `-top
|-smartd
|-smbd---smbd
|-sshd
|-syslogd
|-udevd
|-uml_switch
`-xfs
I would be glad to try more, and thanks for your help so far!
Cheers
Frisco
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3544 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20090819/194dffdb/attachment.bin>
-------------- next part --------------
_______________________________________________
KDE PIM users mailing list
kdepim-users at kde.org
https://mail.kde.org/mailman/listinfo/kdepim-users
More information about the kdepim-users
mailing list