[Akonadi] [Bug 339850] New: postgres backend: "ERROR: duplicate key value violates unique constraint "mimetypetable_name_key"
Atanas Zhelev
zmeyski at vfemail.net
Fri Oct 10 18:48:16 BST 2014
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.
More information about the Kdepim-bugs
mailing list