Hi,

I can't get akonadi running due to errors in mysql.err, I guess the following dbus errors are because of the missing connections.

It seems to me that this comes from problems building the LocationTable, but I don't know what to do.

I removed everything as mentioned in another forum post:
frisco@linux:~$ killall mysqld & killall akonadictl & killall akonadi_control & killall akonadiserver & rm -rf ~/.config/akonadi/ & rm -rf ~/.local/share/akonadi

restarted mysql as root, then did (as user again):
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);"
[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: [0xb8043400]
[akonadiserver] 3: [0xb8043424]
[akonadiserver] 4: /lib/i686/cmov/libc.so.6(gsignal+0x50) [0xb7995680]
[akonadiserver] 5: /lib/i686/cmov/libc.so.6(abort+0x188) [0xb7998d68]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8d) [0xb7d054cd]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053154]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0xb7d98b4e]
[akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb7da5d0e]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0xb7da6028]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804dc74]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x62e) [0xb7f4976e]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56) [0xb7f4a2d6]
[akonadiserver] 14: akonadiserver(main+0x398) [0x804d018]
[akonadiserver] 15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb7980775]
[akonadiserver] 16: akonadiserver [0x804cbb1]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)

Please find the self-test here: http://pastebin.com/m7796457a


Any clues?
Cheers
Frisco

Not sure why you start mysqld as root (maybe you are using the central instance for another application?), but make sure there is only one mysqld running as the user (the mysql error log seems to indicate that more than one mysqld process tries to access the data files).

What distribution are you on?
Is this Akonadi from the distributor's packagers or a manually built one?

Cheers,
_

Dear anda_skoa,

I run mysqld as I have a LAMP-Server running here localy. MySQL is used by a lot of applications (mail servers etc.), normally this is no problem, as it is a client server application, but I'm sure you're pretty aware of that

Only mysqld_safe and logger are run by root, the mysqld processes are running as user mysql, which is default behaviour:

|-mysqld_safe-+-logger
| `-mysqld---15*[{mysqld}]

That's a Debian Testing/Unstable, Akonadi is from Debian:

lost+found# dpkg -l akonadi*
Gewünscht=Unbekannt/Installieren/R=Entfernen/P=Vollständig Löschen/Halten
| Status=Nicht/Installiert/Config/U=Entpackt/Fehlgeschl. Konfiguration/
Halb installiert/Trigger erWartet/Trigger anhängig
|/ Fehler?=(kein)/Halten/R=Neuinst notw/X=beide (Status, Fehler: GROSS=schlecht)
||/ Name Version Beschreibung
+++-=======================-=======================-==============================================================
ii akonadi-kde 4:4.2.2-1 akonadi resources for KDE
ii akonadi-server 1.1.2-1+b1 Akonadi PIM storage service

Any more information I can provide you with?

Cheers
Frisco

Try disabling the "Start own MySQL process" option in System Settings > Advanced > Akonadi configuration, and filling in the appropriate details. You will need to create the appropriate user/database however it will then use the system wide MySQL instance.

Dear bcooksley,

thank you, I tried this. The option is named "Use internal MySQL server" here, I disabled it and filled in the details for "External MySQL Server" below (dababase name, host, user, pwd). The option field had the value "UNIX_SOCKET=/home/frisco/.local/share/akonadi/db_misc/mysql.socket", I tried it with and without this - no success (I guess the option field should be empty, right?).

When I start Akonadi via this gui, it says: http://pastebin.com/m26101419 (with option field set)

So it now complains about dbus and missing resource agents, but I don't know whether this is right or due to mysql problems before.

When I start Akonadi from bash via akonadi_ctl (after deleting ~/.config/akonadi/ & ~/.local/share/akonadi

it says:

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);"
[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: [0xb80a9400]
[akonadiserver] 3: [0xb80a9424]
[akonadiserver] 4: /lib/i686/cmov/libc.so.6(gsignal+0x50) [0xb79fb680]
[akonadiserver] 5: /lib/i686/cmov/libc.so.6(abort+0x188) [0xb79fed68]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8d) [0xb7d6b4cd]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053154]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0xb7dfeb4e]
[akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb7e0bd0e]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0xb7e0c028]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804dc74]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x62e) [0xb7faf76e]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56) [0xb7fb02d6]
[akonadiserver] 14: akonadiserver(main+0x398) [0x804d018]
[akonadiserver] 15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb79e6775]
[akonadiserver] 16: akonadiserver [0x804cbb1]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)

When I look up the database manually, I see:

ResourceTable 1 MyISAM latin1_swedish_ci 4,0 KB
SchemaVersionTable 1 MyISAM latin1_swedish_ci 1,0 KB

So there seem to be problems creating LocationTable indeed.

Any more clues?

Cheers
Frisco

You need to clear the configuration files, then change the settings in System Settings again. The MySQL socket should be pointing to your system wide socket for MySQL ( usually somewhere under /var )

Ok, I did:

rm -rf ~/.config/akonadi/
rm -rf ~/.local/share/akonadi

That should clear all configs, or do I have to remove more?

all akonadi*-processes stopped.

I edited akonadi-config via system settings and filled the option field with:
UNIX_SOCKET=/var/run/mysqld/mysqld.sock

Strange enough, the dialog had "Use internal MySQL server" enabled again - does that come from removing .config/akonadi/ and .local/share/akonadi?

Nevertheless, I filled in the database details again, with UNIX_SOCKET as I said above.

I applied the changes, then clicked Start, got the progress bar, and after that messages about problems with dbus again http://pastebin.com/m24358ee4

Should I start akonadi via the gui or via akonadictl from bash?

Frisco

Correct, removing those directories clears the Akonadi configuration.
This is looking better. In bash please stop then start Akonadi ( using akonadictl ) and post the logs from the start run here. No need to reset the configuration again.

Ok,

$ akonadictl stop
frisco@linux:~$ psgrep akonadi
...
root 6062 0.0 0.0 3044 1304 pts/4 S 08:54 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 6099 0.0 0.5 119760 24552 pts/4 Sl 08:54 0:01 \_ /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 6100 0.0 0.0 2120 620 pts/4 S 08:54 0:00 \_ logger -p daemon.err -t mysqld_safe -i -t mysqld
frisco 8749 0.0 0.4 170912 20076 ? Sl 09:30 0:01 /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


Should I kill 8749? I did not(!), but I think something could be wrong here, as socket should now point to /var/...

Then as you requested:

frisco@linux:~$ akonadictl start
Starting Akonadi Server...
done.
frisco@linux:~$ [akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);"
[akonadiserver] "Unable to create entire table."
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z10kBacktracev+0x35) [0x8051f65]
[akonadiserver] 1: akonadiserver [0x8052446]
[akonadiserver] 2: [0xb8079400]
[akonadiserver] 3: [0xb8079424]
[akonadiserver] 4: /lib/i686/cmov/libc.so.6(gsignal+0x50) [0xb79cb680]
[akonadiserver] 5: /lib/i686/cmov/libc.so.6(abort+0x188) [0xb79ced68]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8d) [0xb7d3b4cd]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053154]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0xb7dceb4e]
[akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb7ddbd0e]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0xb7ddc028]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804dc74]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x62e) [0xb7f7f76e]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56) [0xb7f802d6]
[akonadiserver] 14: akonadiserver(main+0x398) [0x804d018]
[akonadiserver] 15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb79b6775]
[akonadiserver] 16: akonadiserver [0x804cbb1]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);"
[akonadiserver] "Unable to create entire table."
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z10kBacktracev+0x35) [0x8051f65]
[akonadiserver] 1: akonadiserver [0x8052446]
[akonadiserver] 2: [0xb7fe2400]
[akonadiserver] 3: [0xb7fe2424]
[akonadiserver] 4: /lib/i686/cmov/libc.so.6(gsignal+0x50) [0xb7934680]
[akonadiserver] 5: /lib/i686/cmov/libc.so.6(abort+0x188) [0xb7937d68]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8d) [0xb7ca44cd]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053154]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0xb7d37b4e]
[akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb7d44d0e]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0xb7d45028]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804dc74]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x62e) [0xb7ee876e]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56) [0xb7ee92d6]
[akonadiserver] 14: akonadiserver(main+0x398) [0x804d018]
[akonadiserver] 15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb791f775]
[akonadiserver] 16: akonadiserver [0x804cbb1]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);"
[akonadiserver] "Unable to create entire table."
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z10kBacktracev+0x35) [0x8051f65]
[akonadiserver] 1: akonadiserver [0x8052446]
[akonadiserver] 2: [0xb7efa400]
[akonadiserver] 3: [0xb7efa424]
[akonadiserver] 4: /lib/i686/cmov/libc.so.6(gsignal+0x50) [0xb784c680]
[akonadiserver] 5: /lib/i686/cmov/libc.so.6(abort+0x188) [0xb784fd68]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8d) [0xb7bbc4cd]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053154]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0xb7c4fb4e]
[akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb7c5cd0e]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0xb7c5d028]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804dc74]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x62e) [0xb7e0076e]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56) [0xb7e012d6]
[akonadiserver] 14: akonadiserver(main+0x398) [0x804d018]
[akonadiserver] 15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb7837775]
[akonadiserver] 16: akonadiserver [0x804cbb1]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);"
[akonadiserver] "Unable to create entire table."
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z10kBacktracev+0x35) [0x8051f65]
[akonadiserver] 1: akonadiserver [0x8052446]
[akonadiserver] 2: [0xb8078400]
[akonadiserver] 3: [0xb8078424]
[akonadiserver] 4: /lib/i686/cmov/libc.so.6(gsignal+0x50) [0xb79ca680]
[akonadiserver] 5: /lib/i686/cmov/libc.so.6(abort+0x188) [0xb79cdd68]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8d) [0xb7d3a4cd]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053154]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0xb7dcdb4e]
[akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb7ddad0e]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0xb7ddb028]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804dc74]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x62e) [0xb7f7e76e]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56) [0xb7f7f2d6]
[akonadiserver] 14: akonadiserver(main+0x398) [0x804d018]
[akonadiserver] 15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb79b5775]
[akonadiserver] 16: akonadiserver [0x804cbb1]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

One run with killing 8749 (all akonadi processes now terminated), then starting it:

frisco@linux:~$ akonadictl start
Starting Akonadi Server...
done.
frisco@linux:~$ [akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);"
[akonadiserver] "Unable to create entire table."
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z10kBacktracev+0x35) [0x8051f65]
[akonadiserver] 1: akonadiserver [0x8052446]
[akonadiserver] 2: [0xb7f63400]
[akonadiserver] 3: [0xb7f63424]
[akonadiserver] 4: /lib/i686/cmov/libc.so.6(gsignal+0x50) [0xb78b5680]
[akonadiserver] 5: /lib/i686/cmov/libc.so.6(abort+0x188) [0xb78b8d68]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8d) [0xb7c254cd]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053154]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9e) [0xb7cb8b4e]
[akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb7cc5d0e]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0xb7cc6028]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x44) [0x804dc74]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x62e) [0xb7e6976e]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x56) [0xb7e6a2d6]
[akonadiserver] 14: akonadiserver(main+0x398) [0x804d018]
[akonadiserver] 15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb78a0775]
[akonadiserver] 16: akonadiserver [0x804cbb1]
[akonadiserver] ]
...
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

Frisco

Unfortunately I do not know what could be the cause of this issue. Please ensure your system has adequate free space however, and try deleting the tables it is trying to create from its database, then trying again.

Hm, unfortunatly it remains the same.

Tables ResourceTable and SchemaVersionTable are built again and filled with one entry, LocationTable fails:

[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."

When I put the SQL code in the database by hand, I get the following error:

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 DEFAULTtrue,
cachePolicyInherit BOOL NOT NULL DEFAULTtrue,
cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1,
cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1,
cachePolicySyncOnDemand BOOL NOT NULL DEFAULTfalse,
cachePolicyLocalParts TEXT
);

MySQL says:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character set utf8 collate utf8_bin NOT NULL, parentId BIGINT DEFAULT 0 REFERENC' at line 1

Could it be about utf8 as character set and collation?

The two tables which work have latin1_swedish_ci as collation, maybe there's something wrong?

Frisco

Interesting, seems to be a problem in the MySQL usage.

What is your system locale, maybe it is somehow incompatible?

@bcooksley: any specific reason why you suggested a system database approach rather than the user local one enabled by default?
A different user without database knowlegde would get into troubles trying to make it work.

Cheers,
_

Dear anda_skoa,

frisco@linux:/etc$ echo $LANG
de_DE@euro

Is it that what you mean?

I guess bcooksley suggested the db approach because of possible conflicts of simultanous database connections.

Cheers
Frisco

I suggested using the System Wide database to check if it was a multiple instances issue. Also, running multiple instances uses more system resources ( I rarely run Akonadi because the combined use of memory is approximately 10% for mysql, akonadicontrol, akonadiserver, and the agents )

Hm, is there any workaround to sync kadressbook (or even kontact) with a palm (treo 680)?

Cheers
Frisco