Contenu | Rechercher | Menus

Annonce

Si vous avez des soucis pour rester connecté, déconnectez-vous puis reconnectez-vous depuis ce lien en cochant la case
Me connecter automatiquement lors de mes prochaines visites.

À propos de l'équipe du forum.

Pages : 1

#1 Le 07/03/2014, à 14:55

freekdz

probleme a akonadiserver

j'ai se texte la j'ai rien compris merci de m'aider
akonadictl start
Starting Akonadi Server...
   done.
root@freekdz-OptiPlex-755:~# Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/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"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/freekdz/.local/share/akonadi/mysql.conf", "--datadir=/home/freekdz/.local/share/akonadi/db_data/", "--socket=/home/freekdz/.local/share/akonadi/socket-freekdz-OptiPlex-755/mysql.socket")
stdout: ""
stderr: "140307 14:52:06 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

140307 14:52:06 [ERROR] Aborting

140307 14:52:06 [Note] /usr/sbin/mysqld: Shutdown complete

"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805d566]
1: akonadiserver() [0x805d821]
2: [0x6f9400]
3: [0x6f9416]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0x83a1df]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0x83d825]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0x1b2616]
7: akonadiserver() [0x805f9d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0x25be59]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x112c7d) [0x268c7d]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0x2727ce]
11: akonadiserver() [0x8056b35]
12: akonadiserver() [0x80ea505]
13: akonadiserver() [0x80607c9]
14: akonadiserver() [0x8061f51]
15: akonadiserver() [0x8063716]
16: akonadiserver() [0x8055fe0]
17: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x8254d3]
18: akonadiserver() [0x80569d1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/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"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/freekdz/.local/share/akonadi/mysql.conf", "--datadir=/home/freekdz/.local/share/akonadi/db_data/", "--socket=/home/freekdz/.local/share/akonadi/socket-freekdz-OptiPlex-755/mysql.socket")
stdout: ""
stderr: "140307 14:52:06 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

140307 14:52:06 [ERROR] Aborting

140307 14:52:06 [Note] /usr/sbin/mysqld: Shutdown complete

"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805d566]
1: akonadiserver() [0x805d821]
2: [0x6dc400]
3: [0x6dc416]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0x70b1df]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0x70e825]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0x16c616]
7: akonadiserver() [0x805f9d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0x215e59]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x112c7d) [0x222c7d]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0x22c7ce]
11: akonadiserver() [0x8056b35]
12: akonadiserver() [0x80ea505]
13: akonadiserver() [0x80607c9]
14: akonadiserver() [0x8061f51]
15: akonadiserver() [0x8063716]
16: akonadiserver() [0x8055fe0]
17: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x6f64d3]
18: akonadiserver() [0x80569d1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/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"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/freekdz/.local/share/akonadi/mysql.conf", "--datadir=/home/freekdz/.local/share/akonadi/db_data/", "--socket=/home/freekdz/.local/share/akonadi/socket-freekdz-OptiPlex-755/mysql.socket")
stdout: ""
stderr: "140307 14:52:06 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

140307 14:52:06 [ERROR] Aborting

140307 14:52:06 [Note] /usr/sbin/mysqld: Shutdown complete

"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805d566]
1: akonadiserver() [0x805d821]
2: [0x5a0400]
3: [0x5a0416]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0x9de1df]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0x9e1825]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0x72f616]
7: akonadiserver() [0x805f9d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0x7d8e59]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x112c7d) [0x7e5c7d]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0x7ef7ce]
11: akonadiserver() [0x8056b35]
12: akonadiserver() [0x80ea505]
13: akonadiserver() [0x80607c9]
14: akonadiserver() [0x8061f51]
15: akonadiserver() [0x8063716]
16: akonadiserver() [0x8055fe0]
17: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x9c94d3]
18: akonadiserver() [0x80569d1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/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"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/freekdz/.local/share/akonadi/mysql.conf", "--datadir=/home/freekdz/.local/share/akonadi/db_data/", "--socket=/home/freekdz/.local/share/akonadi/socket-freekdz-OptiPlex-755/mysql.socket")
stdout: ""
stderr: "140307 14:52:06 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

140307 14:52:06 [ERROR] Aborting

140307 14:52:06 [Note] /usr/sbin/mysqld: Shutdown complete

"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805d566]
1: akonadiserver() [0x805d821]
2: [0x88d400]
3: [0x88d416]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xe751df]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xe78825]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0x16c616]
7: akonadiserver() [0x805f9d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0x215e59]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x112c7d) [0x222c7d]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0x22c7ce]
11: akonadiserver() [0x8056b35]
12: akonadiserver() [0x80ea505]
13: akonadiserver() [0x80607c9]
14: akonadiserver() [0x8061f51]
15: akonadiserver() [0x8063716]
16: akonadiserver() [0x8055fe0]
17: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xe604d3]
18: akonadiserver() [0x80569d1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

Hors ligne

#2 Le 07/03/2014, à 15:40

tiramiseb

Re : probleme a akonadiserver

Salut,

Ton problème c'est que tu lances ça en tant que "root" : le serveur MySQL intégré dans KDE, comme n'importe quel serveur MySQL, refuse de démarrer sous ce compte-là.

Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com

Hors ligne

#3 Le 07/03/2014, à 15:45

freekdz

Re : probleme a akonadiserver

meme erreur

freekdz@freekdz-OptiPlex-755:~$ akonadictl start
Starting Akonadi Server...
   done.
freekdz@freekdz-OptiPlex-755:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/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"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/freekdz/.local/share/akonadi/mysql.conf", "--datadir=/home/freekdz/.local/share/akonadi/db_data/", "--socket=/home/freekdz/.local/share/akonadi/socket-freekdz-OptiPlex-755/mysql.socket")
stdout: ""
stderr: ""
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805d566]
1: akonadiserver() [0x805d821]
2: [0x56a400]
3: [0x56a416]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0x8891df]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0x88c825]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xa9c616]
7: akonadiserver() [0x805f9d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0xb45e59]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x112c7d) [0xb52c7d]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb5c7ce]
11: akonadiserver() [0x8056b35]
12: akonadiserver() [0x80ea505]
13: akonadiserver() [0x80607c9]
14: akonadiserver() [0x8061f51]
15: akonadiserver() [0x8063716]
16: akonadiserver() [0x8055fe0]
17: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x8744d3]
18: akonadiserver() [0x80569d1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/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"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/freekdz/.local/share/akonadi/mysql.conf", "--datadir=/home/freekdz/.local/share/akonadi/db_data/", "--socket=/home/freekdz/.local/share/akonadi/socket-freekdz-OptiPlex-755/mysql.socket")
stdout: ""
stderr: ""
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805d566]
1: akonadiserver() [0x805d821]
2: [0x7db400]
3: [0x7db416]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0x80a1df]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0x80d825]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xd1a616]
7: akonadiserver() [0x805f9d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0xdc3e59]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x112c7d) [0xdd0c7d]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xdda7ce]
11: akonadiserver() [0x8056b35]
12: akonadiserver() [0x80ea505]
13: akonadiserver() [0x80607c9]
14: akonadiserver() [0x8061f51]
15: akonadiserver() [0x8063716]
16: akonadiserver() [0x8055fe0]
17: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f54d3]
18: akonadiserver() [0x80569d1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/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"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/freekdz/.local/share/akonadi/mysql.conf", "--datadir=/home/freekdz/.local/share/akonadi/db_data/", "--socket=/home/freekdz/.local/share/akonadi/socket-freekdz-OptiPlex-755/mysql.socket")
stdout: ""
stderr: ""
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805d566]
1: akonadiserver() [0x805d821]
2: [0xf60400]
3: [0xf60416]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xf8f1df]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xf92825]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0x70b616]
7: akonadiserver() [0x805f9d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0x7b4e59]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x112c7d) [0x7c1c7d]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0x7cb7ce]
11: akonadiserver() [0x8056b35]
12: akonadiserver() [0x80ea505]
13: akonadiserver() [0x80607c9]
14: akonadiserver() [0x8061f51]
15: akonadiserver() [0x8063716]
16: akonadiserver() [0x8055fe0]
17: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xf7a4d3]
18: akonadiserver() [0x80569d1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/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"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/freekdz/.local/share/akonadi/mysql.conf", "--datadir=/home/freekdz/.local/share/akonadi/db_data/", "--socket=/home/freekdz/.local/share/akonadi/socket-freekdz-OptiPlex-755/mysql.socket")
stdout: ""
stderr: ""
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x805d566]
1: akonadiserver() [0x805d821]
2: [0x467400]
3: [0x467416]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xcba1df]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x175) [0xcbd825]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x136) [0xa0b616]
7: akonadiserver() [0x805f9d8]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc9) [0xab4e59]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x112c7d) [0xac1c7d]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xacb7ce]
11: akonadiserver() [0x8056b35]
12: akonadiserver() [0x80ea505]
13: akonadiserver() [0x80607c9]
14: akonadiserver() [0x8061f51]
15: akonadiserver() [0x8063716]
16: akonadiserver() [0x8055fe0]
17: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0xca54d3]
18: akonadiserver() [0x80569d1]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

Hors ligne

#4 Le 07/03/2014, à 15:51

freekdz

Re : probleme a akonadiserver

je suis sous ubuntu pour info

Hors ligne

#5 Le 07/03/2014, à 16:10

tiramiseb

Re : probleme a akonadiserver

meme erreur

Ben non, ce n'est pas la même erreur...

Avant tu avais « [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! » sur stderr, maintenant il y a juste une chaîne vide...

Voyons voir le répertoire où les données sont censées être stockées... Que donne la commande suivante ?

ls -lh ~/.local/share/akonadi ~/.local/share/akonadi/db_data

PS : mets les retours de commandes entra balises "[ code ]", obtenues en cliquant sur bt_pre.png.

Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com

Hors ligne

#6 Le 07/03/2014, à 16:13

freekdz

Re : probleme a akonadiserver

freekdz@freekdz-OptiPlex-755:~$ ls -lh ~/.local/share/akonadi ~/.local/share/akonadi/db_data
/home/freekdz/.local/share/akonadi:
total 32K
-rw-rw-r-- 1 freekdz freekdz  901 mars   7 14:32 akonadi_agent_server.error
-rw-rw-r-- 1 freekdz freekdz  904 mars   7 14:30 akonadi_agent_server.error.old
-rw-rw-r-- 1 freekdz freekdz 1,3K mars   7 15:53 akonadiserver.error
-rw-rw-r-- 1 freekdz freekdz 1,3K mars   7 15:53 akonadiserver.error.old
drwxrwxr-x 5 freekdz freekdz 4,0K mars   7 15:53 db_data
drwxrwxr-x 2 freekdz freekdz 4,0K mars   7 13:51 db_misc
drwxrwxr-x 2 freekdz freekdz 4,0K mars   7 13:51 file_db_data
-rw-rw-r-- 1 freekdz freekdz 3,3K mars   7 13:51 mysql.conf
lrwxrwxrwx 1 freekdz freekdz   27 mars   7 15:53 socket-freekdz-OptiPlex-755 -> /tmp/akonadi-freekdz.Y0X2m5

/home/freekdz/.local/share/akonadi/db_data:
total 49M
-rw-rw---- 1 freekdz freekdz  10M mars   7 13:51 ibdata1
-rw-rw---- 1 freekdz freekdz  38M mars   7 13:51 ib_logfile0
drwx------ 2 freekdz freekdz 4,0K mars   7 13:51 mysql
-rw-rw---- 1 freekdz freekdz 1,3K mars   7 15:53 mysql.err
-rw-rw-r-- 1 freekdz freekdz  62K mars   7 15:53 mysql.err.old
drwx------ 2 freekdz freekdz 4,0K mars   7 13:51 performance_schema
drwx------ 2 freekdz freekdz 4,0K mars   7 13:51 test

Hors ligne

#7 Le 07/03/2014, à 16:19

tiramiseb

Re : probleme a akonadiserver

Et la commande suivante ?

tail -n30 /home/freekdz/.local/share/akonadi/db_data/mysql.err

Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com

Hors ligne

#8 Le 07/03/2014, à 16:20

freekdz

Re : probleme a akonadiserver

freekdz@freekdz-OptiPlex-755:~$ tail -n30 /home/freekdz/.local/share/akonadi/db_data/mysql.err
140307 15:53:16 [Note] Plugin 'FEDERATED' is disabled.
140307 15:53:16 InnoDB: The InnoDB memory heap is disabled
140307 15:53:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140307 15:53:16 InnoDB: Compressed tables use zlib 1.2.3.4
140307 15:53:16 InnoDB: Initializing buffer pool, size = 80.0M
140307 15:53:16 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
140307 15:53:16 InnoDB: Could not open or create data files.
140307 15:53:16 InnoDB: If you tried to add new data files, and it failed here,
140307 15:53:16 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140307 15:53:16 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140307 15:53:16 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140307 15:53:16 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140307 15:53:16 InnoDB: remove old data files which contain your precious data!
140307 15:53:16 [ERROR] Plugin 'InnoDB' init function returned error.
140307 15:53:16 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140307 15:53:16 [ERROR] Unknown/unsupported storage engine: innodb
140307 15:53:16 [ERROR] Aborting

140307 15:53:16 [Note] /usr/sbin/mysqld: Shutdown complete

Hors ligne

#9 Le 07/03/2014, à 18:20

tiramiseb

Re : probleme a akonadiserver

Je pense que l'erreur principale est celle-ci :

InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1

As-tu des données importantes au niveau d'Akonadi ? Ou alors est-ce la première fois que tu le lances ?

Si c'est la première fois, tu peux essayer d'effacer tout ça pour réinitialiser.

rm -fr /home/freekdz/.local/share/akonadi

Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com

Hors ligne

#10 Le 08/03/2014, à 10:04

freekdz

Re : probleme a akonadiserver

voila ce que ça donne je croix que c regler?
si c le cas merci bcp mon ami

freekdz@freekdz-OptiPlex-755:~$ rm -fr /home/freekdz/.local/share/akonadi
freekdz@freekdz-OptiPlex-755:~$ akonadictl startStarting Akonadi Server...
   done.
freekdz@freekdz-OptiPlex-755:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/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" 
Installing MySQL system tables...
Could not open required defaults file: /etc/akonadi/mysql-global.conf
Fatal error in defaults handling. Program aborted

Installation of system tables failed!  Examine the logs in
/home/freekdz/.local/share/akonadi/db_data/ for more information.

You can try to start the mysqld daemon with:

    shell> /usr/sbin/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /home/freekdz/.local/share/akonadi/db_data/ that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!

Failed to use database "akonadi" 
Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query" 
Database error: "Can't connect to local MySQL server through socket '/home/freekdz/.local/share/akonadi/socket-freekdz-OptiPlex-755/mysql.socket' (2) QMYSQL: Unable to connect" 
Trying to create database now... 
Database "akonadi" opened using driver "QMYSQL" 
DbInitializer::run() 
checking table  "SchemaVersionTable" 
"CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL DEFAULT 0)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
"INSERT INTO SchemaVersionTable (version) VALUES (20)" 
checking table  "ResourceTable" 
"CREATE TABLE ResourceTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL UNIQUE, isVirtual BOOL DEFAULT false)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
"INSERT INTO ResourceTable (name,isVirtual) VALUES ('akonadi_search_resource',true)" 
checking table  "CollectionTable" 
"CREATE TABLE CollectionTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, remoteId VARBINARY(255), remoteRevision VARBINARY(255), name VARBINARY(255) NOT NULL, parentId BIGINT, resourceId BIGINT NOT NULL, 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 VARBINARY(255), queryString VARBINARY(1024), queryLanguage VARBINARY(255), FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (resourceId) REFERENCES ResourceTable(id) ON DELETE CASCADE ON UPDATE CASCADE)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
adding index "CREATE UNIQUE INDEX CollectionTable_parentAndNameIndex ON CollectionTable (parentId,name)" 
"INSERT INTO CollectionTable (resourceId,name,parentId) VALUES (1,'Search',NULL)" 
checking table  "MimeTypeTable" 
"CREATE TABLE MimeTypeTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL UNIQUE)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
"INSERT INTO MimeTypeTable (name) VALUES ('application/octet-stream')" 
"INSERT INTO MimeTypeTable (name) VALUES ('message/rfc822')" 
"INSERT INTO MimeTypeTable (name) VALUES ('text/calendar')" 
"INSERT INTO MimeTypeTable (name) VALUES ('text/vcard')" 
"INSERT INTO MimeTypeTable (name) VALUES ('inode/directory')" 
checking table  "PimItemTable" 
"CREATE TABLE PimItemTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, rev INTEGER NOT NULL DEFAULT 0, remoteId VARBINARY(255), remoteRevision VARBINARY(255), collectionId BIGINT, mimeTypeId BIGINT, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP, dirty BOOL, size BIGINT NOT NULL DEFAULT 0, FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (mimeTypeId) REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE CASCADE)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
adding index "CREATE  INDEX PimItemTable_collectionIndex ON PimItemTable (collectionId)" 
checking table  "FlagTable" 
"CREATE TABLE FlagTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARBINARY(255) NOT NULL UNIQUE)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
"INSERT INTO FlagTable (name) VALUES ('important')" 
"INSERT INTO FlagTable (name) VALUES ('has_attachment')" 
"INSERT INTO FlagTable (name) VALUES ('spam')" 
"INSERT INTO FlagTable (name) VALUES ('\\ANSWERED')" 
"INSERT INTO FlagTable (name) VALUES ('\\FLAGGED')" 
"INSERT INTO FlagTable (name) VALUES ('\\DELETED')" 
"INSERT INTO FlagTable (name) VALUES ('\\SEEN')" 
"INSERT INTO FlagTable (name) VALUES ('\\DRAFT')" 
checking table  "PartTable" 
"CREATE TABLE PartTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, pimItemId BIGINT NOT NULL, name VARBINARY(255) NOT NULL, data LONGBLOB, datasize BIGINT NOT NULL, version INTEGER DEFAULT 0, external BOOL DEFAULT false, FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON DELETE CASCADE ON UPDATE CASCADE)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
adding index "CREATE UNIQUE INDEX PartTable_pimItemIdNameIndex ON PartTable (pimItemId,name)" 
adding index "CREATE  INDEX PartTable_pimItemNameIndex ON PartTable (name)" 
checking table  "CollectionAttributeTable" 
"CREATE TABLE CollectionAttributeTable (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, collectionId BIGINT NOT NULL, type LONGBLOB NOT NULL, value LONGBLOB, FOREIGN KEY (collectionId) REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE)  COLLATE=utf8_general_ci DEFAULT CHARSET=utf8" 
adding index "CREATE  INDEX CollectionAttributeTable_collectionIndex ON CollectionAttributeTable (collectionId)" 
checking relation  "PimItemFlagRelation" 
"CREATE TABLE PimItemFlagRelation (PimItem_id INTEGER REFERENCES PimItemTable(id), Flag_id INTEGER REFERENCES FlagTable(id), PRIMARY KEY (PimItem_id, Flag_id))" 
checking relation  "CollectionMimeTypeRelation" 
"CREATE TABLE CollectionMimeTypeRelation (Collection_id INTEGER REFERENCES CollectionTable(id), MimeType_id INTEGER REFERENCES MimeTypeTable(id), PRIMARY KEY (Collection_id, MimeType_id))" 
checking relation  "CollectionPimItemRelation" 
"CREATE TABLE CollectionPimItemRelation (Collection_id INTEGER REFERENCES CollectionTable(id), PimItem_id INTEGER REFERENCES PimItemTable(id), PRIMARY KEY (Collection_id, PimItem_id))" 
DbInitializer::run() done 
skipping update 2 
skipping update 3 
skipping update 4 
skipping update 8 
skipping update 10 
skipping update 12 
skipping update 13 
skipping update 14 
skipping update 15 
skipping update 16 
skipping update 17 
skipping update 18 
skipping update 19 
skipping update 20 
Nepomuk Query Server not available 
DataStore::unhideAllPimItems() 
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Database "akonadi" opened using driver "QMYSQL" 
Database "akonadi" opened using driver "QMYSQL" 
Database "akonadi" opened using driver "QMYSQL" 
PLUGINS:  "/usr/share/akonadi/agents" 
PLUGINS:  ("akonadinepomukfeederagent.desktop", "akonotesresource.desktop", "birthdaysresource.desktop", "calendarsearchagent.desktop", "contactsresource.desktop", "davgroupwareresource.desktop", "icalresource.desktop", "imapresource.desktop", "invitationsagent.desktop", "kabcresource.desktop", "kalarmdirresource.desktop", "kalarmresource.desktop", "kcalresource.desktop", "kdeaccountsresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "maildispatcheragent.desktop", "mailfilteragent.desktop", "mboxresource.desktop", "microblog.desktop", "mixedmaildirresource.desktop", "mtdummyresource.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "openxchangeresource.desktop", "pop3resource.desktop", "vcarddirresource.desktop", "vcardresource.desktop") 
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games") 
PLUGINS inserting:  "akonadi_nepomuk_feeder" 0 ("Unique", "Autostart", "NoConfig") 
PLUGINS inserting:  "akonadi_akonotes_resource" 0 ("Resource", "Notes") 
PLUGINS inserting:  "akonadi_birthdays_resource" 0 ("Resource", "Unique") 
PLUGINS inserting:  "akonadi_calendarsearch_agent" 0 ("Unique", "NoConfig") 
PLUGINS inserting:  "akonadi_contacts_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_davgroupware_resource" 0 ("Resource", "FreeBusyProvider") 
PLUGINS inserting:  "akonadi_ical_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_imap_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_invitations_agent" 0 ("NoConfig") 
PLUGINS inserting:  "akonadi_kabc_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_kalarm_dir_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_kalarm_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_kcal_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_kdeaccounts_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_knut_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_kolabproxy_resource" 0 ("Resource", "Unique") 
PLUGINS inserting:  "akonadi_localbookmarks_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_maildir_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_maildispatcher_agent" 0 ("Unique", "Autostart") 
PLUGINS inserting:  "akonadi_mailfilter_agent" 0 ("Unique", "Autostart") 
PLUGINS inserting:  "akonadi_mbox_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_microblog_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_mixedmaildir_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_mailtransport_dummy_resource" 0 ("Resource", "MailTransport") 
PLUGINS inserting:  "akonadi_nepomuktag_resource" 0 ("Resource", "Virtual", "Unique", "NoConfig") 
PLUGINS inserting:  "akonadi_nntp_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_notes_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_openxchange_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_pop3_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_vcarddir_resource" 0 ("Resource") 
PLUGINS inserting:  "akonadi_vcard_resource" 0 ("Resource") 
Akonadi server is now operational. 
"/usr/bin/akonadi_nepomuk_feeder(26656)" Soprano: "QLocalSocket::connectToServer: Invalid name"
"/usr/bin/akonadi_nepomuk_feeder(26656)" Soprano: "QLocalSocket::connectToServer: Invalid name"
"/usr/bin/akonadi_nepomuk_feeder(26656)" Soprano: "QLocalSocket::connectToServer: Invalid name"
Known subscriber "akonadi_nepomuk_feeder" subscribes again 
Known subscriber "akonadi_maildispatcher_agent" subscribes again 
Known subscriber "akonadi_maildispatcher_agent" subscribes again 
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
Database "akonadi" opened using driver "QMYSQL" 
Known subscriber "akonadi_maildispatcher_agent" subscribes again 
Database "akonadi" opened using driver "QMYSQL" 
Known subscriber "akonadi_mailfilter_agent" subscribes again 
Known subscriber "akonadi_mailfilter_agent" subscribes again 
Known subscriber "akonadi_mailfilter_agent" subscribes again 
Database "akonadi" opened using driver "QMYSQL" 
Database "akonadi" opened using driver "QMYSQL" 
search paths:  ("/usr/lib", "/usr/lib/qt4/plugins/", "/usr/lib/kde4/", "/usr/lib/kde4/plugins/", "/usr/lib/qt4/plugins/", "/usr/lib/kde4/plugins", "/usr/lib/i386-linux-gnu/qt4/plugins", "/usr/lib/qt4/plugins", "/usr/bin", "/home/freekdz/.kde/lib/kde4/") 
Agent instance created in separate process. 
Known subscriber "AkonadiAgentServer" subscribes again 
Database "akonadi" opened using driver "QMYSQL" 
AkonadiAgentServer(26676)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
AkonadiAgentServer(26676)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
akonadi_maildispatcher_agent(26657)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
AkonadiAgentServer(26676) MaildirResource::maildirForCollection: Got incomplete ancestor chain: Collection ID: 3    remote ID: "" 
   name: "outbox" 
   url: KUrl("akonadi:?collection=3") 
   parent: 2 "/home/freekdz/.local/share/local-mail" 
   resource: "akonadi_maildir_resource_0" 
   rights: QFlags(0x1|0x2|0x4|0x8|0x10|0x20) 
   contents mime type: ("message/rfc822", "inode/directory") 
    CachePolicy:  
   inherit: true 
   interval: -1 
   timeout: 1 
   sync on demand: true 
   local parts: ("ENVELOPE") 
    CollectionStatistics: 
   count: -1 
   unread count: -1 
   size: -1 
[/usr/bin/nepomukservicestub] Using Virtuoso Version: "6.1.4.3127-pthreads"
[/usr/bin/nepomukservicestub] Using Virtuoso Version: "6.1.4.3127-pthreads"
[/usr/bin/nepomukservicestub] void Soprano::VirtuosoController::writeConfigFile(const QString&, const BackendSettings&) "/tmp/virtuoso_X26678.ini"
[/usr/bin/nepomukservicestub] Starting Virtuoso server: "/usr/bin/virtuoso-t" ("+foreground", "+configfile", "/tmp/virtuoso_X26678.ini", "+wait")
[/usr/bin/nepomukservicestub] "
"
[/usr/bin/nepomukservicestub] "		Sat Mar 08 2014
"
[/usr/bin/nepomukservicestub] "09:55:03 OpenLink Virtuoso Universal Server
"
[/usr/bin/nepomukservicestub] "09:55:03 Version 06.01.3127-pthreads for Linux as of Feb 15 2012
"
[/usr/bin/nepomukservicestub] "09:55:03 uses parts of OpenSSL, PCRE, Html Tidy
"
[/usr/bin/nepomukservicestub] "09:55:03 Entering Lite Mode
"
[/usr/bin/nepomukservicestub] "09:55:03 SQL Optimizer enabled (max 1000 layouts)
"
[/usr/bin/nepomukservicestub] "09:55:04 Compiler unit is timed at 0.003814 msec
"
[/usr/bin/nepomukservicestub] "09:55:04 Checkpoint started
"
[/usr/bin/nepomukservicestub] "09:55:04 Roll forward started
"
[/usr/bin/nepomukservicestub] "09:55:04 Roll forward complete
"
[/usr/bin/nepomukservicestub] "09:55:05 Checkpoint started
"
[/usr/bin/nepomukservicestub] "09:55:05 Checkpoint finished, log reused
"
[/usr/bin/nepomukservicestub] "09:55:07 Server online at 1111 (pid 26695)
"
[/usr/bin/nepomukservicestub] Virtuoso started: 26695
[/usr/bin/nepomukservicestub] Soprano::ODBC::ConnectionPool::ConnectionPool(const QString&, const QStringList&, QObject*) "host=localhost:1111;uid=dba;pwd=dba;driver=/usr/lib/odbc/virtodbc_r.so"
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x91a5aa8)
[/usr/bin/nepomukservicestub] virtual Soprano::ODBC::Connection::~Connection() QThread(0x91a5aa8)
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() Nepomuk::GraphMaintainer(0x939d9c8)
[/usr/bin/nepomukservicestub] virtual Soprano::ODBC::Connection::~Connection() Nepomuk::GraphMaintainer(0x939d9c8)
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x91a5aa8)
[/usr/bin/nepomukservicestub] void Soprano::VirtuosoController::writeConfigFile(const QString&, const BackendSettings&) "/tmp/virtuoso_h26678.ini"
[/usr/bin/nepomukservicestub] Starting Virtuoso server: "/usr/bin/virtuoso-t" ("+foreground", "+configfile", "/tmp/virtuoso_h26678.ini", "+wait")
[/usr/bin/nepomukservicestub] "
"
[/usr/bin/nepomukservicestub] "		Sat Mar 08 2014
"
[/usr/bin/nepomukservicestub] "09:55:07 OpenLink Virtuoso Universal Server
"
[/usr/bin/nepomukservicestub] "09:55:07 Version 06.01.3127-pthreads for Linux as of Feb 15 2012
"
[/usr/bin/nepomukservicestub] "09:55:07 uses parts of OpenSSL, PCRE, Html Tidy
"
[/usr/bin/nepomukservicestub] "09:55:08 Entering Lite Mode
"
[/usr/bin/nepomukservicestub] "09:55:08 SQL Optimizer enabled (max 1000 layouts)
"
[/usr/bin/nepomukservicestub] "09:55:08 Compiler unit is timed at 0.005235 msec
"
[/usr/bin/nepomukservicestub] "09:55:09 Checkpoint started
"
[/usr/bin/nepomukservicestub] "09:55:09 Roll forward started
"
[/usr/bin/nepomukservicestub] "09:55:09 Roll forward complete
"
[/usr/bin/nepomukservicestub] "09:55:09 Checkpoint started
"
[/usr/bin/nepomukservicestub] "09:55:09 Checkpoint finished, log reused
"
[/usr/bin/nepomukservicestub] "09:55:11 Server online at 1112 (pid 26701)
"
[/usr/bin/nepomukservicestub] Virtuoso started: 26701
[/usr/bin/nepomukservicestub] Soprano::ODBC::ConnectionPool::ConnectionPool(const QString&, const QStringList&, QObject*) "host=localhost:1112;uid=dba;pwd=dba;driver=/usr/lib/odbc/virtodbc_r.so"
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x91a5aa8)
[/usr/bin/nepomukservicestub] virtual Soprano::ODBC::Connection::~Connection() QThread(0x91a5aa8)
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x91a5aa8)
[/usr/bin/nepomukservicestub] virtual Soprano::ODBC::Connection::~Connection() QThread(0x91a5aa8)
[/usr/bin/nepomukservicestub] Shutting down virtuoso instance 26701
[/usr/bin/nepomukservicestub] Virtuoso server stopped: 0
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] (Soprano::Redland::BackendPlugin) creating model of type "hashes" with options "hash-type='memory',contexts='yes'"
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x9616fc0)
[/usr/bin/nepomukservicestub] virtual void Soprano::Server::LocalServer::incomingConnection(quintptr)
[/usr/bin/nepomukservicestub] void Soprano::Server::ServerCorePrivate::addConnection(Soprano::Server::ServerConnection*) New connection. New count: 1
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() Soprano::Server::ServerConnection(0x9854200)
akonadi_nepomuk_feeder(26656) FeederPluginloader::feederPluginsForMimeType: No feeder for type  "inode/directory"  found 
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x982c800, name = "Thread (pooled)")
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x95926a8, name = "Thread (pooled)")
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() QThread(0x96c9fa0, name = "Thread (pooled)")
[/usr/bin/nepomukservicestub] QObject::connect: Cannot queue arguments of type 'Soprano::Statement'
(Make sure 'Soprano::Statement' is registered using qRegisterMetaType().)
Akonadi::NepomukSearchEngine(0x831f6b0) QDBusServiceWatcher(0x837bbd8) 
[/usr/bin/nepomukservicestub] virtual void Soprano::Server::LocalServer::incomingConnection(quintptr)
[/usr/bin/nepomukservicestub] void Soprano::Server::ServerCorePrivate::addConnection(Soprano::Server::ServerConnection*) New connection. New count: 2
[/usr/bin/nepomukservicestub] virtual void Soprano::Server::LocalServer::incomingConnection(quintptr)
[/usr/bin/nepomukservicestub] void Soprano::Server::ServerCorePrivate::addConnection(Soprano::Server::ServerConnection*) New connection. New count: 3
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() Soprano::Server::ServerConnection(0x9835d10)
[/usr/bin/nepomukservicestub] virtual void Soprano::Server::LocalServer::incomingConnection(quintptr)
[/usr/bin/nepomukservicestub] void Soprano::Server::ServerCorePrivate::addConnection(Soprano::Server::ServerConnection*) New connection. New count: 4
[/usr/bin/nepomukservicestub] virtual void Soprano::Server::LocalServer::incomingConnection(quintptr)
[/usr/bin/nepomukservicestub] void Soprano::Server::ServerCorePrivate::addConnection(Soprano::Server::ServerConnection*) New connection. New count: 5
[/usr/bin/nepomukservicestub] Soprano::ODBC::Connection::Connection() Soprano::Server::ServerConnection(0x96bb290)
[/usr/bin/nepomukservicestub] virtual void Soprano::Server::ServerConnection::run() thread done.
[/usr/bin/nepomukservicestub] virtual Soprano::ODBC::Connection::~Connection() Soprano::Server::ServerConnection(0x96bb290)
[/usr/bin/nepomukservicestub] void Soprano::Server::ServerCore::serverConnectionFinished()
[/usr/bin/nepomukservicestub] virtual Soprano::Server::ServerConnection::~ServerConnection() Removing connection
[/usr/bin/nepomukservicestub] void Soprano::Server::ServerCore::serverConnectionFinished() Connection removed. Current count: 4
[/usr/bin/nepomukservicestub] virtual Soprano::ODBC::Connection::~Connection() QThread(0x9616fc0)

Hors ligne

#11 Le 08/03/2014, à 12:31

tiramiseb

Re : probleme a akonadiserver

Ça ressemble à quelque chose qui fonctionne, oui...

Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com

Hors ligne

#12 Le 24/04/2014, à 15:58

abecidofugy

Re : probleme a akonadiserver

Si le problème est résolu, merci d'éditer le premier message et le signaler.

Hors ligne

#13 Le 26/04/2014, à 19:42

xabilon

Re : probleme a akonadiserver

Salut

En fait c'est la mise à jour de la BDD d'Akonadi qui est buguée. Pour ceux qui ont déjà fait la mise à niveau vers Kubuntu 14.04, il y a une solution pour finit cette mise à jour : http://bugs.kde.org/show_bug.cgi?id=331867

Démarrer akonadi :

akonadictl start

Il essaye de faire la mise à jour et ça plante, c'est normal.
Ensuite, toujours en Konsole :

mysql --socket=/tmp/akonadi-[user].xxxxxx/mysql.socket
mysql> use akonadi
mysql> DELETE FROM PartTable WHERE name = 'GID';
mysql> quit
akonadictl start

Le chemin vers le fichier mysql.socket est différent sur chaque oridinateur, il suffit de regarder dans le dossier /tmp pour le connaître.

Dernière modification par xabilon (Le 28/04/2014, à 11:23)

Pour passer un sujet en résolu : modifiez le premier message et ajoutez [Résolu] au titre.

Hors ligne

#14 Le 27/04/2014, à 15:51

abecidofugy

Re : probleme a akonadiserver

@xabilon : salut. On sait que ça marche quand à la fin on a : $ akonadictl start
Akonadi is already running.

?

Hors ligne

#15 Le 27/04/2014, à 22:05

xabilon

Re : probleme a akonadiserver

Ça dépend... en tout cas Akonadi marche oui, mais étais-tu touché par le problème décrit dans cette discussion ?
Cette solution est destinée à ceux qui ont fait la mise à niveau Kubuntu 13.10 --> 14.04 et se retrouvent avec Akonadi qui ne démarre pas pour cause de mise à jour de la BDD bloquée à cause d'un champ de la table.

Dernière modification par xabilon (Le 27/04/2014, à 22:07)

Pour passer un sujet en résolu : modifiez le premier message et ajoutez [Résolu] au titre.

Hors ligne

#16 Le 28/04/2014, à 10:06

abecidofugy

Re : probleme a akonadiserver

Ah, je n'avais rien noté de particulier avec Akonadi. J'ai appliqué tes lignes en pensant que tout le monde devait le faire ^^

J'ai bien fait la mise à jour à partir de la 13.10

Hors ligne

#17 Le 28/04/2014, à 10:24

xabilon

Re : probleme a akonadiserver

Tu es du genre à taper des lignes de code sans les comprendre et sans avoir aucun problème ? Fais attention big_smile

Curieusement chez certains la mise à jour se passe bien... ça dépend peut-être de l'ancienneté de la BDD d'Akonadi. Dans mon cas, lors du démarrage d'Akonadi après les opérations SQL, il s'est lancé dans une mise à jour de la base qui a pris plusieurs minutes (créations de tables, suppressions de tables, etc...).

Pour passer un sujet en résolu : modifiez le premier message et ajoutez [Résolu] au titre.

Hors ligne

#18 Le 28/04/2014, à 10:42

abecidofugy

Re : probleme a akonadiserver

xabilon a écrit :

En fait c'est la mise à jour de la BDD d'Akonadi qui est buguée. Pour ceux qui ont déjà fait la mise à niveau vers Kubuntu 14.04, il y a une solution pour finit cette mise à jour

En fait, c'est de la façon dont tu avais rédigé ton post qui m'a induit en erreur. Tu laisses supposer que la maj est buguée pour ceux qui ont fait l'upgrade. C'est ce que je comprends smile

Hors ligne

#19 Le 28/04/2014, à 10:45

tiramiseb

Re : probleme a akonadiserver

Tu laisses supposer que la maj est buguée pour ceux qui ont fait l'upgrade

J'ai compris la même chose. Cela dit, cette commande ne semble pas faire grand mal... Donc pas grave si tu l'as exécutée alors que ça marchait, à mon avis...
Mais je peux me tromper.

Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com

Hors ligne

#20 Le 28/04/2014, à 11:04

jajaX

Re : probleme a akonadiserver

salut,

ce n'est pas la maj 13.10 vers 14.04 qui pose problème mais la maj KDE SC 4.12 vers la 4.13. j'ai la maj sous ma 13.10 et ça merdouille aussi. la solution proposée ne marche pas chez moi =>

jajax@portable:~$ akonadictl start
Starting Akonadi Server... 
   done. 
jajax@portable:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/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" 
akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.parttypetable                              OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.pimitemtagrelation                         OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
MySQL version OK (required "5.1" , available "5.5" ) 
Database "akonadi" opened using driver "QMYSQL" 
DbInitializer::run() 
checking table  "SchemaVersionTable" 
checking table  "ResourceTable" 
checking table  "CollectionTable" 
checking table  "MimeTypeTable" 
checking table  "PimItemTable" 
checking table  "FlagTable" 
checking table  "PartTypeTable" 
checking table  "PartTable" 
checking table  "CollectionAttributeTable" 
checking table  "TagTable" 
checking table  "TagAttributeTable" 
checking table  "TagRemoteIdResourceRelationTable" 
checking table  "PimItemFlagRelation" 
checking table  "PimItemTagRelation" 
checking table  "CollectionMimeTypeRelation" 
checking table  "CollectionPimItemRelation" 
DbInitializer::run() done 
skipping update 2 
skipping update 3 
skipping update 4 
skipping update 8 
skipping update 10 
skipping update 12 
skipping update 13 
skipping update 14 
skipping update 15 
skipping update 16 
skipping update 17 
skipping update 18 
skipping update 19 
skipping update 20 
skipping update 21 
skipping update 22 
skipping update 23 
skipping update 24 
skipping update 25 
skipping update 26 
Adding new foreign key constraints 
"ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE" 
Updating index failed:  
Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-a49_f`, CONSTRAINT `#sql-a49_f_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE 
""
Unable to initialize database.
"[
0: akonadiserver() [0x805d455]
1: akonadiserver() [0x805d6e1]
2: [0xb7711400]
3: [0xb7711424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6daeaff]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6db2083]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb745dd53]
7: akonadiserver() [0x805f524]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7502488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb751284e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb751bf45]
11: akonadiserver() [0x8062da2]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb758c89a]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75946eb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb757b030]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb757b094]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb757ae3a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb757e6fd]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb757ec0c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb75ab1de]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6c8783e]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6c87be8]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6c87ca8]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb75aa9cf]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb7579813]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb7579b39]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb757f8ee]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6d99905]
29: akonadiserver() [0x8058372]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/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" 
akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.parttypetable                              OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.pimitemtagrelation                         OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
MySQL version OK (required "5.1" , available "5.5" ) 
Database "akonadi" opened using driver "QMYSQL" 
DbInitializer::run() 
checking table  "SchemaVersionTable" 
checking table  "ResourceTable" 
checking table  "CollectionTable" 
checking table  "MimeTypeTable" 
checking table  "PimItemTable" 
checking table  "FlagTable" 
checking table  "PartTypeTable" 
checking table  "PartTable" 
checking table  "CollectionAttributeTable" 
checking table  "TagTable" 
checking table  "TagAttributeTable" 
checking table  "TagRemoteIdResourceRelationTable" 
checking table  "PimItemFlagRelation" 
checking table  "PimItemTagRelation" 
checking table  "CollectionMimeTypeRelation" 
checking table  "CollectionPimItemRelation" 
DbInitializer::run() done 
skipping update 2 
skipping update 3 
skipping update 4 
skipping update 8 
skipping update 10 
skipping update 12 
skipping update 13 
skipping update 14 
skipping update 15 
skipping update 16 
skipping update 17 
skipping update 18 
skipping update 19 
skipping update 20 
skipping update 21 
skipping update 22 
skipping update 23 
skipping update 24 
skipping update 25 
skipping update 26 
Adding new foreign key constraints 
"ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE" 
Updating index failed:  
Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-a49_12`, CONSTRAINT `#sql-a49_12_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE 
""
Unable to initialize database.
"[
0: akonadiserver() [0x805d455]
1: akonadiserver() [0x805d6e1]
2: [0xb7770400]
3: [0xb7770424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e0daff]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e11083]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74bcd53]
7: akonadiserver() [0x805f524]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7561488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb757184e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb757af45]
11: akonadiserver() [0x8062da2]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75eb89a]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75f36eb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75da030]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75da094]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75d9e3a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75dd6fd]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75ddc0c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb760a1de]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6ce683e]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6ce6be8]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6ce6ca8]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb76099cf]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75d8813]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75d8b39]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75de8ee]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6df8905]
29: akonadiserver() [0x8058372]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/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" 
akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.parttypetable                              OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.pimitemtagrelation                         OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
MySQL version OK (required "5.1" , available "5.5" ) 
Database "akonadi" opened using driver "QMYSQL" 
DbInitializer::run() 
checking table  "SchemaVersionTable" 
checking table  "ResourceTable" 
checking table  "CollectionTable" 
checking table  "MimeTypeTable" 
checking table  "PimItemTable" 
checking table  "FlagTable" 
checking table  "PartTypeTable" 
checking table  "PartTable" 
checking table  "CollectionAttributeTable" 
checking table  "TagTable" 
checking table  "TagAttributeTable" 
checking table  "TagRemoteIdResourceRelationTable" 
checking table  "PimItemFlagRelation" 
checking table  "PimItemTagRelation" 
checking table  "CollectionMimeTypeRelation" 
checking table  "CollectionPimItemRelation" 
DbInitializer::run() done 
skipping update 2 
skipping update 3 
skipping update 4 
skipping update 8 
skipping update 10 
skipping update 12 
skipping update 13 
skipping update 14 
skipping update 15 
skipping update 16 
skipping update 17 
skipping update 18 
skipping update 19 
skipping update 20 
skipping update 21 
skipping update 22 
skipping update 23 
skipping update 24 
skipping update 25 
skipping update 26 
Adding new foreign key constraints 
"ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE" 
Updating index failed:  
Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-a49_15`, CONSTRAINT `#sql-a49_15_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE 
""
Unable to initialize database.
"[
0: akonadiserver() [0x805d455]
1: akonadiserver() [0x805d6e1]
2: [0xb7766400]
3: [0xb7766424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e03aff]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e07083]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74b2d53]
7: akonadiserver() [0x805f524]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7557488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb756784e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb7570f45]
11: akonadiserver() [0x8062da2]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75e189a]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75e96eb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75d0030]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75d0094]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75cfe3a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75d36fd]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75d3c0c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb76001de]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6cdc83e]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6cdcbe8]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6cdcca8]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb75ff9cf]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75ce813]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75ceb39]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75d48ee]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6dee905]
29: akonadiserver() [0x8058372]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
search paths:  ("/usr/lib/lightdm/lightdm", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/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" 
akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.parttypetable                              OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.pimitemtagrelation                         OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
MySQL version OK (required "5.1" , available "5.5" ) 
Database "akonadi" opened using driver "QMYSQL" 
DbInitializer::run() 
checking table  "SchemaVersionTable" 
checking table  "ResourceTable" 
checking table  "CollectionTable" 
checking table  "MimeTypeTable" 
checking table  "PimItemTable" 
checking table  "FlagTable" 
checking table  "PartTypeTable" 
checking table  "PartTable" 
checking table  "CollectionAttributeTable" 
checking table  "TagTable" 
checking table  "TagAttributeTable" 
checking table  "TagRemoteIdResourceRelationTable" 
checking table  "PimItemFlagRelation" 
checking table  "PimItemTagRelation" 
checking table  "CollectionMimeTypeRelation" 
checking table  "CollectionPimItemRelation" 
DbInitializer::run() done 
skipping update 2 
skipping update 3 
skipping update 4 
skipping update 8 
skipping update 10 
skipping update 12 
skipping update 13 
skipping update 14 
skipping update 15 
skipping update 16 
skipping update 17 
skipping update 18 
skipping update 19 
skipping update 20 
skipping update 21 
skipping update 22 
skipping update 23 
skipping update 24 
skipping update 25 
skipping update 26 
Adding new foreign key constraints 
"ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE" 
Updating index failed:  
Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-a49_18`, CONSTRAINT `#sql-a49_18_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CASCADE 
""
Unable to initialize database.
"[
0: akonadiserver() [0x805d455]
1: akonadiserver() [0x805d6e1]
2: [0xb7779400]
3: [0xb7779424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e16aff]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e1a083]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x123) [0xb74c5d53]
7: akonadiserver() [0x805f524]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb756a488]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x11084e) [0xb757a84e]
10: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb7583f45]
11: akonadiserver() [0x8062da2]
12: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75f489a]
13: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75fc6eb]
14: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75e3030]
15: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75e3094]
16: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75e2e3a]
17: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1dd) [0xb75e66fd]
18: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75e6c0c]
19: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x1a91de) [0xb76131de]
20: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6cef83e]
21: /lib/i386-linux-gnu/libglib-2.0.so.0(+0x46be8) [0xb6cefbe8]
22: /lib/i386-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6cefca8]
23: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb76129cf]
24: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75e1813]
25: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75e1b39]
26: /usr/lib/i386-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75e78ee]
27: akonadiserver() [0x8057849]
28: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6e01905]
29: akonadiserver() [0x8058372]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

Dernière modification par jajaX (Le 28/04/2014, à 11:05)

@+
jajaX
Asus X93SM-YZ157V / Asus X93SM-YZ065V sous KDE Neon
ASUS K95VB sous Kubuntu 22.04 Jammy Jellyfish (64 bits) / ACER Aspire 5612 WLMI sous Kubuntu 18.04 Bionic Beaver (32 bits)

Hors ligne

#21 Le 28/04/2014, à 11:32

xabilon

Re : probleme a akonadiserver

J'avais oublié un retour à la ligne dans la suite de commandes MySql...
Ton problème a l'air d'avoir la même origine : l'update des tables d'Akonadi plante, mais peut-être pas au même endroit. Mais je n'en sais pas plus, le fonctionnement d'Akonadi a toujours été un peu opaque pour moi, la solution que j'ai donnée je l'ai trouvée sur le site de KDE, j'aurai jamais pondu ça tout seul smile
D'ailleurs j'y ai trouvé ça : http://forum.kde.org/viewtopic.php?f=215&t=120673
Il y est préconisé de supprimer les dossiers de config d'akonadi... un peu radical, non sad ?

Pour passer un sujet en résolu : modifiez le premier message et ajoutez [Résolu] au titre.

Hors ligne

#22 Le 28/04/2014, à 12:20

jajaX

Re : probleme a akonadiserver

c'est clair que c'est radical et je n'en ai pas du tout envie !!! et si on lit bien son texte, il vire aussi sa base de données situé dans ~/.local/share/akonadi. c'est clair que ça marche sûrement mieux avec plus rien mais on perd tout...

pour ton retour à la ligne, c'est bon pour moi, j'avais appliqué la méthode via le rapport de bug.

sinon ben je suis rade pour le moment.... comme quoi, j'ai bien fait de tester cette maj sur mon pc pro ou je me suis sert pas trop de kmail et consort. le pc perso va attendre du coup !

@+
jajaX
Asus X93SM-YZ157V / Asus X93SM-YZ065V sous KDE Neon
ASUS K95VB sous Kubuntu 22.04 Jammy Jellyfish (64 bits) / ACER Aspire 5612 WLMI sous Kubuntu 18.04 Bionic Beaver (32 bits)

Hors ligne

#23 Le 28/04/2014, à 13:47

xabilon

Re : probleme a akonadiserver

L'erreur est ici :

Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-a49_12`, CONSTRAINT `#sql-a49_12_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `collectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query

Ce n'est donc pas le problème du "GID" (qui est résolu dans Akonadi 1.12-2). C'est ce qu'ils t'ont dit dans le rapport de bug smile

Pour passer un sujet en résolu : modifiez le premier message et ajoutez [Résolu] au titre.

Hors ligne

#24 Le 29/04/2014, à 13:54

jajaX

Re : probleme a akonadiserver

ok merci wink

j'ai posté un rapport de bug ici et il faut que je teste la longue réponse de Daniel !!

je vous tiens au courant dès que j'ai le temps de le faire.

Dernière modification par jajaX (Le 29/04/2014, à 13:54)

@+
jajaX
Asus X93SM-YZ157V / Asus X93SM-YZ065V sous KDE Neon
ASUS K95VB sous Kubuntu 22.04 Jammy Jellyfish (64 bits) / ACER Aspire 5612 WLMI sous Kubuntu 18.04 Bionic Beaver (32 bits)

Hors ligne

Pages : 1