[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 


      |                 |               `-{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 

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...
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 
i[akonadiserver] checking table  "ResourceTable"
[akonadiserver] "CREATE TABLE ResourceTable (id BIGINT NOT NULL PRIMARY 
[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: 
[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) 
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804dc74]
[akonadiserver] 12: 
[akonadiserver] 13: 
[akonadiserver] 14: akonadiserver(main+0x398) [0x804d018]
[akonadiserver] 15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) 
[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
      |                 |               `-{akonadiserver} 

      |                 `-{akonadi_control} 











      |           `-notifyd 





      |           `-startkde-+-kwrapper4
      |                      `-ssh-agent
      |                    |-hald-addon-inpu
      |                    `-6*[hald-addon-stor]
      |          |-kio_file
      |          |-klauncher
      |          |-ksmserver-+-kwin
      |          |           `-{ksmserver}
      |          |-kwrited
      |          `-smart-notifier
      |         |-bash---screen
      |         `-{konsole}
      |        `-qmgr
      |        |-5*[bash]
      |        |-tail
      |        `-top

I would be glad to try more, and thanks for your help so far!

-------------- 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

More information about the kdepim-users mailing list