'Re: [Kde-pim] Akonadi MySQL backend: tuning for larger accounts or switching to MariaDB with a diffe'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-pim
Subject:    Re: [Kde-pim] Akonadi MySQL backend: tuning for larger accounts or switching to MariaDB with a diffe
From:       GEO <1g2e3o4 () gmail ! com>
Date:       2014-03-28 20:04:04
Message-ID: 2632774.pYuZRDptj4 () linux-pc
[Download RAW message or body]

On Thursday, March 27, 2014 10:54:16 AM Daniel Vrátil wrote:
> On Wednesday 26 of March 2014 16:58:35 GEO wrote:
> > On Wednesday 26 March 2014 15:04:27 Daniel Vrátil wrote:
> > > MariaDB is a drop-in replacement for MySQL, so it's supported by default
> > > (I've  been using MariaDB instead of MySQL for over year before I
> > > switched
> > > to PSQL)
> > 
> > Just interested: You use the akonadi postgresql backend as your default
> > one?
> Yes, and I'm a happy man now :-)

Are you running using an internal server?
I cannot get it working :-( It cannot connect to the server :-(.
Error log is attached. 

Would be a pleasure if someone could help me.
["akonadi-selftest-report-20140328uu.txt" (akonadi-selftest-report-20140328uu.txt)]

Akonadi Server Self-Test Report
===============================

Test 1:  SUCCESS
--------

Database driver found.
Details: The QtSQL driver 'QPSQL' is required by your current Akonadi server \
configuration and was found on your system.

File content of '/home/user/.config/akonadi/akonadiserverrc':
[QMYSQL]
StartServer=true
ServerPath=
Name=akonadi
Host=
User=
Password=
Options=

[QPSQL]
StartServer=true
Name=akonadi
Host=
User=
Password=
Port=5432
Options=
ServerPath=/usr/lib/postgresql/9.3/bin/pg_ctl
InitDbPath=/usr/lib/postgresql/9.3/bin/initdb

[SQLITE]
Name=akonadi

[%General]
Driver=QPSQL

Test 2:  ERROR
--------

Cannot connect to PostgreSQL server.
Details: FATAL:  role "user" does not exist
QPSQL: Unable to connect

Test 3:  SUCCESS
--------

akonadictl found and usable
Details: The program '/usr/bin/akonadictl' to control the Akonadi server was found \
and could be executed successfully. Result:
Akonadi 1.11.80

Test 4:  ERROR
--------

Akonadi control process not registered at D-Bus.
Details: The Akonadi control process is not registered at D-Bus which typically means \
it was not started or encountered a fatal error during startup.

Test 5:  ERROR
--------

Akonadi server process not registered at D-Bus.
Details: The Akonadi server process is not registered at D-Bus which typically means \
it was not started or encountered a fatal error during startup.

Test 6:  SKIP
--------

Protocol version check not possible.
Details: Without a connection to the server it is not possible to check if the \
protocol version meets the requirements.

Test 7:  ERROR
--------

No resource agents found.
Details: No resource agents have been found, Akonadi is not usable without at least \
one. This usually means that no resource agents are installed or that there is a \
setup problem. The following paths have been searched: '/usr/share/akonadi/agents'. \
The XDG_DATA_DIRS environment variable is set to \
'/usr/share:/usr/share/kde-plasma:/usr/local/share/:/usr/share/'; make sure this \
includes all paths where Akonadi agents are installed.

Directory listing of '/usr/share/akonadi/agents':
akonadibalooindexingagent.desktop
akonadinepomukfeederagent.desktop
akonotesresource.desktop
archivemailagent.desktop
birthdaysresource.desktop
contactsresource.desktop
davgroupwareresource.desktop
facebookresource.desktop
folderarchiveagent.desktop
googlecalendarresource.desktop
googlecontactsresource.desktop
icaldirresource.desktop
icalresource.desktop
imapresource.desktop
invitationsagent.desktop
kabcresource.desktop
kalarmdirresource.desktop
kalarmresource.desktop
kcalresource.desktop
kdeaccountsresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mailfilteragent.desktop
mboxresource.desktop
migrationagent.desktop
mixedmaildirresource.desktop
mtdummyresource.desktop
newmailnotifieragent.desktop
nntpresource.desktop
notesagent.desktop
notesresource.desktop
openxchangeresource.desktop
pop3resource.desktop
sendlateragent.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to \
'/usr/share:/usr/share/kde-plasma:/usr/local/share/:/usr/share/'

Test 8:  ERROR
--------

Current Akonadi server error log found.
Details: The Akonadi server reported errors during its current startup. The log can \
be found in <a href='/home/user/.local/share/akonadi/akonadiserver.error'>/home/user/.local/share/akonadi/akonadiserver.error</a>.

File content of '/home/user/.local/share/akonadi/akonadiserver.error':
Database process exited unexpectedly during initial connection! 
executable: "/usr/lib/postgresql/9.3/bin/pg_ctl" 
arguments: ("start", "-w", "--timeout=10", \
                "--pgdata=/home/user/.local/share/akonadi/db_data", "-o "-k "") 
stdout: "waiting for server to start....LOG:  could not bind IPv4 socket: Address \
                already in use
HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds \
                and retry.
WARNING:  could not create listen socket for "localhost"
FATAL:  could not create any TCP/IP sockets
.... stopped waiting
" 
stderr: "pg_ctl: could not start server
Examine the log output.
" 
exit code: 1 
process error: "Process operation timed out" 
"[
0: akonadiserver() [0x419587]
1: akonadiserver() [0x4197e2]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x36ff0) [0x7ffba29b6ff0]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39) [0x7ffba29b6f79]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7ffba29ba388]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x102) \
                [0x7ffba449ec92]
6: akonadiserver() [0x41b57d]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) \
                [0x7ffba4539470]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ab3d) [0x7ffba4548b3d]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) \
                [0x7ffba4551721]
10: akonadiserver() [0x4a5fb1]
11: akonadiserver() [0x41c117]
12: akonadiserver() [0x41dd35]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) \
                [0x7ffba45c3c1e]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) \
                [0x7ffba45ab4dd]
15: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ed) \
                [0x7ffba45aeb3d]
16: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aaf83) [0x7ffba45d8f83]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x254) \
                [0x7ffba2085e04]
18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49048) [0x7ffba2086048]
19: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) \
                [0x7ffba20860ec]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x71) \
                [0x7ffba45d87a1]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) \
                [0x7ffba45aa0af]
22: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) \
                [0x7ffba45aa3a5]
23: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) \
                [0x7ffba45afb79]
24: akonadiserver() [0x413c17]
25: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7ffba29a1ec5]
26: akonadiserver() [0x414548]
]
" 

Test 9:  ERROR
--------

Previous Akonadi server error log found.
Details: The Akonadi server reported errors during its previous startup. The log can \
be found in <a href='/home/user/.local/share/akonadi/akonadiserver.error.old'>/home/user/.local/share/akonadi/akonadiserver.error.old</a>.

File content of '/home/user/.local/share/akonadi/akonadiserver.error.old':
Database process exited unexpectedly during initial connection! 
executable: "/usr/lib/postgresql/9.3/bin/pg_ctl" 
arguments: ("start", "-w", "--timeout=10", \
                "--pgdata=/home/user/.local/share/akonadi/db_data", "-o "-k "") 
stdout: "waiting for server to start....LOG:  could not bind IPv4 socket: Address \
                already in use
HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds \
                and retry.
WARNING:  could not create listen socket for "localhost"
FATAL:  could not create any TCP/IP sockets
.... stopped waiting
" 
stderr: "pg_ctl: could not start server
Examine the log output.
" 
exit code: 1 
process error: "Process operation timed out" 
"[
0: akonadiserver() [0x419587]
1: akonadiserver() [0x4197e2]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x36ff0) [0x7f4e36e05ff0]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39) [0x7f4e36e05f79]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7f4e36e09388]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x102) \
                [0x7f4e388edc92]
6: akonadiserver() [0x41b57d]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) \
                [0x7f4e38988470]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x11ab3d) [0x7f4e38997b3d]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) \
                [0x7f4e389a0721]
10: akonadiserver() [0x4a5fb1]
11: akonadiserver() [0x41c117]
12: akonadiserver() [0x41dd35]
13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) \
                [0x7f4e38a12c1e]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) \
                [0x7f4e389fa4dd]
15: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ed) \
                [0x7f4e389fdb3d]
16: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aaf83) [0x7f4e38a27f83]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x254) \
                [0x7f4e364d4e04]
18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49048) [0x7f4e364d5048]
19: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) \
                [0x7f4e364d50ec]
20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x71) \
                [0x7f4e38a277a1]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) \
                [0x7f4e389f90af]
22: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) \
                [0x7f4e389f93a5]
23: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) \
                [0x7f4e389feb79]
24: akonadiserver() [0x413c17]
25: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7f4e36df0ec5]
26: akonadiserver() [0x414548]
]
" 

Test 10:  SUCCESS
--------

No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its current \
startup.

Test 11:  SUCCESS
--------

No previous Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its previous \
startup.

_______________________________________________
KDE PIM mailing list kde-pim@kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/

[prev in list] [next in list] [prev in thread] [next in thread] 