[Akonadi] [Bug 339850] New: postgres backend: "ERROR: duplicate key value violates unique constraint "mimetypetable_name_key"

[Atanas Zhelev]

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

            Bug ID: 339850
           Summary: postgres backend: "ERROR:  duplicate key value
                    violates unique constraint "mimetypetable_name_key"
           Product: Akonadi
           Version: 1.13.0
          Platform: Archlinux Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: zmeyski at vfemail.net

Hi,

setting up new computer with akonadi 1.13.0, kde 4.14.1, qt 4.8.6, postgresql
9.3.5 running as external server. 
I stoped akonadi server and changed the config to use the external postgresql
server. I got the following error in akonadiserver.error:
DATABASE ERROR: 
  Error code: -1 
  DB error:  "ERROR:  duplicate key value violates unique constraint
"mimetypetable_name_key"
DETAIL:  Key (name)=(application/x-vnd.akonadi.calendar.todo) already exists.
(23505)" 
  Error text: "ERROR:  duplicate key value violates unique constraint
"mimetypetable_name_key"
DETAIL:  Key (name)=(application/x-vnd.akonadi.calendar.todo) already exists.
(23505) QPSQL: Unable to create query" 
  Query: "INSERT INTO MimeTypeTable (name) VALUES (:0) RETURNING id" 

akonadi=# select * from mimetypetable;
 id |                    name                    
----+--------------------------------------------
  1 | application/x-vnd.akonadi.calendar.journal
  2 | application/x-vnd.akonadi.calendar.todo
  4 | application/x-vnd.akonadi.calendar.event
  5 | inode/directory
  6 | text/x-vnd.akonadi.note
  7 | message/rfc822
(6 rows)

Reproducible: Always

Steps to Reproduce:
1. Setup external postgresql server.
2. Stop akonadiserver
3. Change the config to use the external postgresql server and start
akonadiserver

Actual Results:  
Error message about duplicate key value in akonadiserver.error log file

Expected Results:  
No errors in akonadiserver.error log file

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