Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 484572 - app-office/akonadi-server and dev-db/postgresql-server-9.3.0 - ERROR: duplicate key value violates unique constraint "mimetypetable_name_key"
Summary: app-office/akonadi-server and dev-db/postgresql-server-9.3.0 - ERROR: duplica...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] KDE (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Gentoo KDE team
URL: https://bugs.kde.org/show_bug.cgi?id=...
Whiteboard: fixed in 1.10.3
Keywords:
Depends on:
Blocks:
 
Reported: 2013-09-11 13:24 UTC by Denis I. Polukarov
Modified: 2013-10-09 20:39 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Denis I. Polukarov 2013-09-11 13:24:03 UTC
akonadi server isn't work with postgresql-server-9.3.0.
Errors like this:
xxx@devdb ~/temp/2 $ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.7.3", "/usr/bin", "/usr/sbin", "/usr/local/sbin", "/usr/lib/postgresql/8.4/bin", "/usr/lib/postgresql/9.0/bin", "/usr/lib/postgresql/9.1/bin") 
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/opt/bin", "/usr/x86_64-pc-linux-gnu/gcc-bin/4.7.3") 
Error during executing query "INSERT INTO MimeTypeTable (name) VALUES (:0) RETURNING id" :  "ERROR:  duplicate key value violates unique constraint "mimetypetable_name_key"
ПОДРОБНОСТИ:  Key (name)=(\x6170706c69636174696f6e2f782d766e642e616b6f6e6164692e63616c656e6461722e746f646f) already exists.
(23505) QPSQL: Unable to create query"
search paths:  ("/usr/lib64/kde4/plugins", "/home/neo/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/neo/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/usr/lib64/kde4/plugins", "/home/neo/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/neo/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/usr/lib64/kde4/plugins", "/home/neo/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/neo/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/usr/lib64/kde4/plugins", "/home/neo/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/neo/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled 
akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled 
akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled 
akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled 
akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled 
akonadi_imap_resource_0(13541)/kdeui (Wallet): The kwalletd service has been disabled 
Error during executing query "SELECT id, name FROM FlagTable WHERE ( name = ( :0 ) )" :  "ERROR:  invalid input syntax for type bytea
СТРОКА 1: EXECUTE qpsqlpstmt_48 ('\SEEN')
etc...
Comment 1 Michael Palimaka (kensington) gentoo-dev 2013-09-11 16:04:19 UTC
Was it working previously with an older version, or it this the first time you are using akonadi?
Comment 2 Denis I. Polukarov 2013-09-16 06:47:23 UTC
With postgresql-server-9.2.4 was all fine.
Comment 3 Andreas Sturmlechner gentoo-dev 2013-10-06 16:32:06 UTC
By chance, what version of qtsql are you running?

This could be solved by the recently released but yet-to-be-version-bumped akonadi-server-1.10.3.
Comment 4 Andreas Sturmlechner gentoo-dev 2013-10-06 16:47:10 UTC
You could try this patch instead of waiting for 1.10.3: https://bugs.kde.org/show_bug.cgi?id=252120#c9
Comment 5 Denis I. Polukarov 2013-10-09 07:07:42 UTC
Uncomment line standard_conforming_strings = on in postgresql.conf seems solved my problem.
Comment 6 Johannes Huber (RETIRED) gentoo-dev 2013-10-09 20:39:18 UTC
Thanks you all. This is fixed in cvs now. Please sync in some hours to get the changes.

+
+  09 Oct 2013; Johannes Huber <johu@gentoo.org> +akonadi-server-1.10.3.ebuild,
+  -akonadi-server-1.10.2-r1.ebuild,
+  -files/akonadi-server-1.10.2-datastore_query_fix.patch:
+  Version bump fixes bug #484572. Remove old.
+