[Akonadi] [Bug 353616] New: starting akonadi with external postgresql database doesn't work

[nevyn]

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

            Bug ID: 353616
           Summary: starting akonadi with external postgresql database
                    doesn't work
           Product: Akonadi
           Version: unspecified
          Platform: Archlinux Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: nevyn at hotmail.de

Content of akonadiserver.error:

DATABASE ERROR: 
  Error code: 42601 
  DB error:  "FEHLER:  Syntaxfehler bei \u00BB(\u00AB\nZEILE 1: EXECUTE  (TRUE,
TRUE, 1)\n                  ^\n(42601)" 
  Error text: "FEHLER:  Syntaxfehler bei \u00BB(\u00AB\nZEILE 1: EXECUTE 
(TRUE, TRUE, 1)\n                  ^\n(42601) QPSQL: Es konnte keine Abfrage
erzeugt werden" 
  Query: "SELECT CollectionTable.id, CollectionTable.remoteId,
CollectionTable.remoteRevision, CollectionTable.name, CollectionTable.parentId,
CollectionTable.resourceId, CollectionTable.enabled, CollectionTable.syncPref,
CollectionTable.displayPref, CollectionTable.indexPref,
CollectionTable.referenced, CollectionTable.cachePolicyInherit,
CollectionTable.cachePolicyCheckInterval,
CollectionTable.cachePolicyCacheTimeout,
CollectionTable.cachePolicySyncOnDemand, CollectionTable.cachePolicyLocalParts,
CollectionTable.queryString, CollectionTable.queryAttributes,
CollectionTable.queryCollections, CollectionTable.isVirtual FROM
CollectionTable LEFT JOIN CollectionMimeTypeRelation ON ( Collection_id =
CollectionTable.id ) WHERE ( ( CollectionTable.enabled = :0 OR
CollectionTable.referenced = :1 ) AND MimeType_id IN ( :2 ) ) GROUP BY
CollectionTable.id" 
DATABASE ERROR: 
  Error code: 23505 
  DB error:  "FEHLER:  doppelter Schl\u00FCsselwert verletzt Unique-Constraint
\u00BBcollectiontable_parentandnameindex\u00AB\n(23505)" 
  Error text: "FEHLER:  doppelter Schl\u00FCsselwert verletzt Unique-Constraint
\u00BBcollectiontable_parentandnameindex\u00AB\n(23505) QPSQL: Es konnte keine
Abfrage erzeugt werden" 
  Query: "INSERT INTO CollectionTable (name, parentId, resourceId, queryString,
queryAttributes, queryCollections, isVirtual) VALUES (:0, :1, :2, :3, :4, :5,
:6) RETURNING id" 


I tested the sql script against postgresql with pgadmin, grouping is not
correct. There is no aggregation or something else you need ' group by '
statement for.

Using arch linux x64 with akonadi 15.08,1-1.

Reproducible: Always

Steps to Reproduce:
1. start akonadi server with external postgresql database
(same database does work with kde 14.x)

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