Re: akonadi error 10

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@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@linux:~$ akonadictl stop 
 

frisco@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@linux:~$ rm -Rf ~/.config/akonadi && rm -Rf 
~/.local/share/akonadi && rm -Rf ~/.kde/share/config/akonadi*rc
frisco@linux:~$ ps x |egrep "akonadi|mysql"
19643 pts/5    S+     0:00 egrep akonadi|mysql
frisco@linux:~$

okay then, now:
frisco@linux:~$ akonadictl start
Starting Akonadi Server...
    done.
frisco@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@linux:~$ akonadictl status
Akonadi Control: running
Akonadi Server: stopped
frisco@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

_______________________________________________
KDE PIM users mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/kdepim-users