Problems with akonadi on opensuse 13.1

skylendar · December 2, 2013, 3:19pm

After having updated my opensuse x86_64 from 12.3 to 13.1, I have recreated my akonadi postgres database and restarted akonadi, however akonadi doesn’t index my files anymore and the indexing of my mails is slow.

The database test in the akonadi tray says that the nepomuk search service uses an unappropriated engine (actually virtuoso-t)

When I issue an akonadictl start I get the following output:

Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
cg@alpha:/mnt/gwendo/porn> QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work.
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
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/usr/lib/mit/bin", "/usr/lib/mit/sbin", "/opt/postgres/9.3/bin", "/home/cg/bin") 
search paths:  ("/home/cg/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/usr/lib64/kde4/plugins", "/home/cg/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/home/cg/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/usr/lib64/kde4/plugins", "/home/cg/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/home/cg/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/usr/lib64/kde4/plugins", "/home/cg/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/home/cg/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/usr/lib64/kde4/plugins", "/home/cg/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/home/cg/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/usr/lib64/kde4/plugins", "/home/cg/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/home/cg/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/usr/lib64/kde4/plugins", "/home/cg/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/home/cg/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/usr/lib64/kde4/plugins", "/home/cg/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/home/cg/.kde4/lib64/kde4/plugins/", "/usr/lib64/kde4/plugins/", "/usr/lib64/qt4/plugins", "/usr/bin", "/usr/lib64/kde4/plugins", "/home/cg/.kde4/lib64/kde4/", "/usr/lib64/kde4/") 
AkonadiAgentServer(6158) Akonadi::SingleFileResource<Settings>::readFile: "Aucun fichier n'a été sélectionné." 
AkonadiAgentServer(6159) Akonadi::SingleFileResource<Settings>::readFile: "Aucun fichier n'a été sélectionné." 
akonadi_kabc_resource_0(6161)/kio (KDirWatch) KDirWatchPrivate::removeEntry: doesn't know "/home/cg/.kde4/share/apps/kabc" 
akonadi_kabc_resource_0(6161)/akonadiserializer (addressee) Akonadi::SerializerPluginAddressee::deserialize: Empty addressee object! 
akonadi_kabc_resource_0(6161)/akonadiserializer (addressee) Akonadi::SerializerPluginAddressee::deserialize: Empty addressee object! 
akonadi_kabc_resource_0(6161)/akonadiserializer (addressee) Akonadi::SerializerPluginAddressee::deserialize: Empty addressee object! 
akonadi_kabc_resource_0(6161)/akonadiserializer (addressee) Akonadi::SerializerPluginAddressee::deserialize: Empty addressee object! 
akonadi_kabc_resource_0(6161)/akonadiserializer (addressee) Akonadi::SerializerPluginAddressee::deserialize: Empty addressee object! 
akonadi_kabc_resource_0(6161)/akonadiserializer (addressee) Akonadi::SerializerPluginAddressee::deserialize: Empty addressee object! 
akonadi_kabc_resource_0(6161)/akonadiserializer (addressee) Akonadi::SerializerPuginAddressee::deserialize: Empty addressee object! 
akonadi_kabc_resource_0(6161)/akonadiserializer (addressee) Akonadi::SerializerPuginAddressee::deserialize: Empty addressee object! 
akonadi_nepomuk_feeder(6166) ItemQueue::fetchJobResult: Not all items were fetchd:  0 8 
akonadi_nepomuk_feeder(6166) ItemQueue::fetchJobResult: Not all items were fetchd:  0 100 
akonadi_nepomuk_feeder(6166) ItemQueue::fetchJobResult: Not all items were fetchd:  0 100 
akonadi_nepomuk_feeder(6166) ItemQueue::fetchJobResult: Not all items were fetchd:  0 100 
akonadi_nepomuk_feeder(6166) ItemQueue::fetchJobResult: Not all items were fetchd:  0 100 
akonadi_nepomuk_feeder(6166) ItemQueue::fetchJobResult: Not all items were fetchd:  0 100

Any idea ?

Thx for reading and possibly answering this post

vazhavandan · December 3, 2013, 3:35am

skylendar wrote:
>
> After having updated my opensuse x86_64 from 12.3 to 13.1, I have
> recreated my akonadi postgres database and restarted akonadi, however
> akonadi doesn’t index my files anymore and the indexing of my mails is
> slow.
>
> The database test in the akonadi tray says that the nepomuk search
> service uses an unappropriated engine (actually virtuoso-t)
>
y answering this post
>
>
Have you created a new “user” profile and tested whether akonadi works ?

–
GNOME 3.10.1
openSUSE 13.1 (Bottle) (x86_64) 64-bit
Kernel Linux 3.11.6-4-desktop

wolfi323 · December 3, 2013, 4:21pm

Looks like this bug: https://bugs.kde.org/show_bug.cgi?id=328325

To fix it, do this:

Please open Akonadi console, go to “DB Browser”, select “schemaversiontable”, click “Refresh” and change the value in the field to 24.

Freshly created database is created with revision 23, and Akonadi then tries to upgrade it to 24, by migrating from BYTEA to TEXT, which fails, because the database has already been created with TEXT.

After having updated my opensuse x86_64 from 12.3 to 13.1, I have recreated my akonadi postgres database and restarted akonadi, however akonadi doesn’t index my files anymore and the indexing of my mails is slow.

Akonadi doesn’t index any files.
Do you mean Nepomuk?
Check the settings in “Configure Desktop”->“Desktop Search”. File-indexing is off by default.

skylendar · December 9, 2013, 5:39pm

Thx for the answer. I only answer now cause I thought that nobody would.

I was able to start the indexing with qdbusviewer by running the method updateAllFolders() in session bus org.kde.nepomuk.service.nepomukfileindexer