Bug 331995 - akonadi 4.13 beta 1 postgresql crash when starting
Summary: akonadi 4.13 beta 1 postgresql crash when starting
Status: RESOLVED FIXED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: server (show other bugs)
Version: GIT (master)
Platform: openSUSE Linux
: NOR grave
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-10 20:32 UTC by Bruno Friedmann
Modified: 2014-03-12 13:51 UTC (History)
2 users (show)

See Also:
Latest Commit: http://commits.kde.org/akonadi/85df6620848ed4d1222fb068b3aad1a3dcc2b1d3
Version Fixed In: 1.12.0

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Bruno Friedmann 2014-03-10 20:32:27 UTC 
Working 4.12.3 installation with akonadi + postgresql (central server) 
After the upgrade to 4.13.0b1 akonadi refuse to start.


Reproducible: Always

Steps to Reproduce:
1. start kde
2. try to start akonadi 
3. akonadi refuse to start 
Actual Results:  
trying for example to run akonadiconsole
akonadiconsole
akonadiconsole(19798)/libakonadi Akonadi::AgentManagerPrivate::createDBusInterface: AgentManager failed to get a valid AgentManager DBus interface. Error is: 1 "org.freedesktop.DBus.Error.NameHasNoOwner" "Could not get owner of name 'org.freedesktop.Akonadi.Control': no such name" 
akonadiconsole(19798)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Invalid name" 
akonadiconsole(19798)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket::connectToServer: Invalid name" 
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
akonadiconsole(19798) KDirWatch::removeDir: doesn't know "/home/bruno/.kde4/share/apps/messageviewer/themes/" 
akonadiconsole(19798) KDirWatch::removeDir: doesn't know "/usr/share/kde4/apps/messageviewer/themes/" 
NOTICE:  CREATE TABLE will create implicit sequence "parttable_new_id_seq" for serial column "parttable_new.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parttable_new_pkey" for table "parttable_new"
akonadiconsole(19798)/libakonadi RawSocketConsole::connectClicked: Akonadi Client Session: connection config file ' akonadi/akonadiconnectionrc cannot be found in ' "/home/bruno/.config" ' nor in any of  ("/etc/xdg", "/etc") 
QSqlQuery::exec: database not open
QLayout: Attempting to add QLayout "" to JobTrackerWidget "", which already has a layout
QLayout: Attempting to add QLayout "" to JobTrackerWidget "", which already has a layout
QLayout: Attempting to add QLayout "" to NotificationMonitor "", which already has a layout
"ERROR:  function encode(text, unknown) does not exist
LINE 1: ...N PartTypeTable ON        PartTable.name = CONCAT(encode(Par...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
(42883) QPSQL: Unable to create query"
Update failed
Failed to commit transaction for database update
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x466cf7]
1: akonadiserver() [0x466f52]
2: /lib64/libc.so.6(+0x358d0) [0x7faad98748d0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7faad9874849]
4: /lib64/libc.so.6(abort+0x148) [0x7faad9875cd8]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7faadb078204]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x468e4d]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7faadb112830]
8: /usr/lib64/libQtCore.so.4(+0x11ec2d) [0x7faadb11fc2d]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7faadb128813]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5fa) [0x46bc0a]
11: /usr/lib64/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7faadb19a11e]
12: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7faadb1820ad]
13: /usr/lib64/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ef) [0x7faadb1850ff]
14: /usr/lib64/libQtCore.so.4(+0x1ae493) [0x7faadb1af493]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7faad8f4f316]
16: /usr/lib64/libglib-2.0.so.0(+0x4b668) [0x7faad8f4f668]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7faad8f4f70c]
18: /usr/lib64/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x65) [0x7faadb1aed55]
19: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7faadb180d0f]
20: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7faadb181005]
21: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8b) [0x7faadb18613b]
22: akonadiserver(main+0x1bf) [0x46075f]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7faad9860be5]
24: akonadiserver() [0x460e69]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
NOTICE:  CREATE TABLE will create implicit sequence "parttable_new_id_seq" for serial column "parttable_new.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parttable_new_pkey" for table "parttable_new"
akonadiconsole(19798) MonitorItem::MonitorItem: "Invalid object path: /subscriber/The name org.freedesktop.Akonadi was not provided by any .service files" 
"ERROR:  function encode(text, unknown) does not exist
LINE 1: ...N PartTypeTable ON        PartTable.name = CONCAT(encode(Par...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
(42883) QPSQL: Unable to create query"
Update failed
Failed to commit transaction for database update
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x466cf7]
1: akonadiserver() [0x466f52]
2: /lib64/libc.so.6(+0x358d0) [0x7f64c1faf8d0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7f64c1faf849]
4: /lib64/libc.so.6(abort+0x148) [0x7f64c1fb0cd8]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7f64c37b3204]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x468e4d]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7f64c384d830]
8: /usr/lib64/libQtCore.so.4(+0x11ec2d) [0x7f64c385ac2d]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7f64c3863813]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5fa) [0x46bc0a]
11: /usr/lib64/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7f64c38d511e]
12: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7f64c38bd0ad]
13: /usr/lib64/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ef) [0x7f64c38c00ff]
14: /usr/lib64/libQtCore.so.4(+0x1ae493) [0x7f64c38ea493]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7f64c168a316]
16: /usr/lib64/libglib-2.0.so.0(+0x4b668) [0x7f64c168a668]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f64c168a70c]
18: /usr/lib64/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x65) [0x7f64c38e9d55]
19: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f64c38bbd0f]
20: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7f64c38bc005]
21: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8b) [0x7f64c38c113b]
22: akonadiserver(main+0x1bf) [0x46075f]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f64c1f9bbe5]
24: akonadiserver() [0x460e69]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
NOTICE:  CREATE TABLE will create implicit sequence "parttable_new_id_seq" for serial column "parttable_new.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parttable_new_pkey" for table "parttable_new"
"ERROR:  function encode(text, unknown) does not exist
LINE 1: ...N PartTypeTable ON        PartTable.name = CONCAT(encode(Par...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
(42883) QPSQL: Unable to create query"
Update failed
Failed to commit transaction for database update
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x466cf7]
1: akonadiserver() [0x466f52]
2: /lib64/libc.so.6(+0x358d0) [0x7f1f8d5a08d0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7f1f8d5a0849]
4: /lib64/libc.so.6(abort+0x148) [0x7f1f8d5a1cd8]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7f1f8eda4204]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x468e4d]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7f1f8ee3e830]
8: /usr/lib64/libQtCore.so.4(+0x11ec2d) [0x7f1f8ee4bc2d]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7f1f8ee54813]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5fa) [0x46bc0a]
11: /usr/lib64/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7f1f8eec611e]
12: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7f1f8eeae0ad]
13: /usr/lib64/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ef) [0x7f1f8eeb10ff]
14: /usr/lib64/libQtCore.so.4(+0x1ae493) [0x7f1f8eedb493]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7f1f8cc7b316]
16: /usr/lib64/libglib-2.0.so.0(+0x4b668) [0x7f1f8cc7b668]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f1f8cc7b70c]
18: /usr/lib64/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x65) [0x7f1f8eedad55]
19: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f1f8eeacd0f]
20: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7f1f8eead005]
21: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8b) [0x7f1f8eeb213b]
22: akonadiserver(main+0x1bf) [0x46075f]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f1f8d58cbe5]
24: akonadiserver() [0x460e69]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
NOTICE:  CREATE TABLE will create implicit sequence "parttable_new_id_seq" for serial column "parttable_new.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "parttable_new_pkey" for table "parttable_new"
"ERROR:  function encode(text, unknown) does not exist
LINE 1: ...N PartTypeTable ON        PartTable.name = CONCAT(encode(Par...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
(42883) QPSQL: Unable to create query"
Update failed
Failed to commit transaction for database update
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x466cf7]
1: akonadiserver() [0x466f52]
2: /lib64/libc.so.6(+0x358d0) [0x7fe5172b68d0]
3: /lib64/libc.so.6(gsignal+0x39) [0x7fe5172b6849]
4: /lib64/libc.so.6(abort+0x148) [0x7fe5172b7cd8]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7fe518aba204]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x468e4d]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7fe518b54830]
8: /usr/lib64/libQtCore.so.4(+0x11ec2d) [0x7fe518b61c2d]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x33) [0x7fe518b6a813]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5fa) [0x46bc0a]
11: /usr/lib64/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7fe518bdc11e]
12: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7fe518bc40ad]
13: /usr/lib64/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ef) [0x7fe518bc70ff]
14: /usr/lib64/libQtCore.so.4(+0x1ae493) [0x7fe518bf1493]
15: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x146) [0x7fe516991316]
16: /usr/lib64/libglib-2.0.so.0(+0x4b668) [0x7fe516991668]
17: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fe51699170c]
18: /usr/lib64/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x65) [0x7fe518bf0d55]
19: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fe518bc2d0f]
20: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7fe518bc3005]
21: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8b) [0x7fe518bc813b]
22: akonadiserver(main+0x1bf) [0x46075f]
23: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fe5172a2be5]
24: akonadiserver() [0x460e69]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!



Expected Results:  
working akonadi pim


postgresql log 

Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19805]: [2-1] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi ERROR:  relation "parttable_old" does not exist
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19805]: [2-2] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi STATEMENT:  ALTER TABLE PartTable_old RENAME TO PartTable
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19811]: [2-1] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi ERROR:  syntax error at end of input at character 9
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19811]: [2-2] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi STATEMENT:  EXECUTE
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19805]: [3-1] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi ERROR:  function encode(text, unknown) does not exist at character 304
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19805]: [3-2] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19805]: [3-3] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi STATEMENT:  INSERT INTO PartTable_new (id, pimItemId, partTypeId, data, datasize, version, external) SELECT PartTable.id, PartTable.pimItemId, PartTypeTable.id, PartTable.data,        PartTable.datasize, PartTable.version, PartTable.external FROM PartTable LEFT JOIN PartTypeTable ON        PartTable.name = CONCAT(encode(PartTypeTable.ns, 'escape'), ':', encode(PartTypeTable.name, 'escape'))
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19814]: [2-1] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi ERROR:  relation "parttable_old" does not exist
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19814]: [2-2] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi STATEMENT:  ALTER TABLE PartTable_old RENAME TO PartTable
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19814]: [3-1] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi ERROR:  function encode(text, unknown) does not exist at character 304
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19814]: [3-2] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19814]: [3-3] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi STATEMENT:  INSERT INTO PartTable_new (id, pimItemId, partTypeId, data, datasize, version, external) SELECT PartTable.id, PartTable.pimItemId, PartTypeTable.id, PartTable.data,        PartTable.datasize, PartTable.version, PartTable.external FROM PartTable LEFT JOIN PartTypeTable ON        PartTable.name = CONCAT(encode(PartTypeTable.ns, 'escape'), ':', encode(PartTypeTable.name, 'escape'))
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19821]: [2-1] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi ERROR:  relation "parttable_old" does not exist
Mar 10 21:17:18 c-3po.labaroche.ioda.net postgres[19821]: [2-2] 2014-03-10 21:17:18 CET bf_akonadi bf_akonadi STATEMENT:  ALTER TABLE PartTable_old RENAME TO PartTable
Mar 10 21:17:19 c-3po.labaroche.ioda.net postgres[19821]: [3-1] 2014-03-10 21:17:19 CET bf_akonadi bf_akonadi ERROR:  function encode(text, unknown) does not exist at character 304
Mar 10 21:17:19 c-3po.labaroche.ioda.net postgres[19821]: [3-2] 2014-03-10 21:17:19 CET bf_akonadi bf_akonadi HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Mar 10 21:17:19 c-3po.labaroche.ioda.net postgres[19821]: [3-3] 2014-03-10 21:17:19 CET bf_akonadi bf_akonadi STATEMENT:  INSERT INTO PartTable_new (id, pimItemId, partTypeId, data, datasize, version, external) SELECT PartTable.id, PartTable.pimItemId, PartTypeTable.id, PartTable.data,        PartTable.datasize, PartTable.version, PartTable.external FROM PartTable LEFT JOIN PartTypeTable ON        PartTable.name = CONCAT(encode(PartTypeTable.ns, 'escape'), ':', encode(PartTypeTable.name, 'escape'))
Mar 10 21:17:19 c-3po.labaroche.ioda.net postgres[19824]: [2-1] 2014-03-10 21:17:19 CET bf_akonadi bf_akonadi ERROR:  relation "parttable_old" does not exist
Mar 10 21:17:19 c-3po.labaroche.ioda.net postgres[19824]: [2-2] 2014-03-10 21:17:19 CET bf_akonadi bf_akonadi STATEMENT:  ALTER TABLE PartTable_old RENAME TO PartTable
Mar 10 21:17:19 c-3po.labaroche.ioda.net postgres[19824]: [3-1] 2014-03-10 21:17:19 CET bf_akonadi bf_akonadi ERROR:  function encode(text, unknown) does not exist at character 304
Mar 10 21:17:19 c-3po.labaroche.ioda.net postgres[19824]: [3-2] 2014-03-10 21:17:19 CET bf_akonadi bf_akonadi HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Mar 10 21:17:19 c-3po.labaroche.ioda.net postgres[19824]: [3-3] 2014-03-10 21:17:19 CET bf_akonadi bf_akonadi STATEMENT:  INSERT INTO PartTable_new (id, pimItemId, partTypeId, data, datasize, version, external) SELECT PartTable.id, PartTable.pimItemId, PartTypeTable.id, PartTable.data,        PartTable.datasize, PartTable.version, PartTable.external FROM PartTable LEFT JOIN PartTypeTable ON        PartTable.name = CONCAT(encode(PartTypeTable.ns, 'escape'), ':', encode(PartTypeTable.name, 'escape'))
Comment 1 Daniel Vrátil 2014-03-11 09:58:49 UTC 
From what version of Akonadi are you updating?
Comment 2 NightSky 2014-03-11 14:15:08 UTC 
Same here, after update from akonadi-server-1.11.0  to 1.11.80.
Comment 3 Daniel Vrátil 2014-03-11 17:49:31 UTC 
NightSky, what is version of your PostgreSQL database server? If you can connect to the server without Akonadi running, can you please check what's in akonadi.schema_version table? Thanks.
Comment 4 NightSky 2014-03-11 20:14:13 UTC 
(In reply to comment #3)
PostgreSQL version is 9.3.3, contens of the "schemaversiontable" are:
 version
---------
      24
(1 row)

Creating a new database resolved the problem (at least for me).
"schemaversiontable" in the new database is:
 version
---------
      26
(1 row)

Thanks for pointig to the right direction.
Comment 5 Daniel Vrátil 2014-03-12 13:24:32 UTC 
NightSky, thanks for the info. Purging Akonadi database is rarely the right direction, fixing Akonadi is usually the right one :-D

Just one question that was not clear to me from your comments: do you also use external PostgreSQL server, or an internal one (started by Akonadi)?
Comment 6 NightSky 2014-03-12 13:48:18 UTC 
I'm using the external PostgreSQL server.
Comment 7 Daniel Vrátil 2014-03-12 13:51:52 UTC 
Git commit 85df6620848ed4d1222fb068b3aad1a3dcc2b1d3 by Dan Vrátil.
Committed on 12/03/2014 at 13:49.
Pushed by dvratil into branch '1.12'.

Fix PostgreSQL query in database update 25

The columns are already TEXT and not bytea, so we can't use encode()
on them. This was probably written before we migrated our string columns
in PostgreSQL to TEXT. The conversion from bytea to TEXT happens in
update 24, so before this one.
FIXED-IN: 1.12.0

M  +1    -1    server/src/storage/dbupdater.cpp

http://commits.kde.org/akonadi/85df6620848ed4d1222fb068b3aad1a3dcc2b1d3