| Summary: | akonadi 4.13 beta 1 postgresql crash when starting | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | Bruno Friedmann <bruno> |
| Component: | server | Assignee: | kdepim bugs <kdepim-bugs> |
| Status: | RESOLVED FIXED | ||
| Severity: | grave | CC: | dvratil, risimi |
| Priority: | NOR | ||
| Version: | GIT (master) | ||
| Target Milestone: | --- | ||
| Platform: | openSUSE | ||
| OS: | Linux | ||
| Latest Commit: | http://commits.kde.org/akonadi/85df6620848ed4d1222fb068b3aad1a3dcc2b1d3 | Version Fixed In: | 1.12.0 |
| Sentry Crash Report: | |||
From what version of Akonadi are you updating? Same here, after update from akonadi-server-1.11.0 to 1.11.80. 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. (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. 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)? I'm using the external PostgreSQL server. 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 |
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'))