[Akonadi] [Bug 326924] New: Problems when using Postgresql backend database

[Aaron Williams]

https://bugs.kde.org/show_bug.cgi?id=326924

            Bug ID: 326924
           Summary: Problems when using Postgresql backend database
    Classification: Unclassified
           Product: Akonadi
           Version: 4.11
          Platform: openSUSE RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: aaronw at doofus.org

I am seeing the following errors when starting up Akonadi when using Postgresql
9.2:

DBUpdater: query error: "ERROR:  function convert_from(text, unknown) does not
exist
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
(42883) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE CollectionTable ALTER remoteId TYPE text USING
convert_from(remoteId,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE CollectionTable ALTER remoteRevision TYPE text USING
convert_from(remoteRevision,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE CollectionTable ALTER name TYPE text USING
convert_from(name,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE CollectionTable ALTER cachePolicyLocalParts TYPE text
USING convert_from(cachePolicyLocalParts,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE CollectionTable ALTER queryString TYPE text USING
convert_from(queryString,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE CollectionTable ALTER queryLanguage TYPE text USING
convert_from(queryLanguage,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE FlagTable ALTER name TYPE text USING
convert_from(name,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE MimeTypeTable ALTER name TYPE text USING
convert_from(name,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE PartTable ALTER name TYPE text USING
convert_from(name,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE PimItemTable ALTER remoteId TYPE text USING
convert_from(remoteId,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE PimItemTable ALTER remoteRevision TYPE text USING
convert_from(remoteRevision,'utf8');" 
Target version was:  24 
Mandatory:  false 
DBUpdater: query error: "ERROR:  current transaction is aborted, commands
ignored until end of transaction block
(25P02) QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE ResourceTable ALTER name TYPE text USING
convert_from(name,'utf8');" 
Target version was:  24 
Mandatory:  false 
Failed to commit transaction for database update 
Nepomuk Query Server not available 


Reproducible: Always

Steps to Reproduce:
1. Configure to use system postgresql database server (not internal)
2. Start Akonadi
3.



Running OpenSUSE 12.3 with Postgres 9.2.4.

-- 
You are receiving this mail because:
You are the assignee for the bug.