Results 1 to 4 of 4

Thread: Problems with akonadi on opensuse 13.1

  1. #1

    Default Problems with akonadi on opensuse 13.1

    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:

    Code:
    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

  2. #2
    Join Date
    May 2010
    Location
    Space Colony Lagrange Point 22° à, 77° Ƅ, 56° ɤ, 99° ɜ
    Posts
    3,166

    Default Re: Problems with akonadi on opensuse 13.1

    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

  3. #3

    Default Re: Problems with akonadi on opensuse 13.1

    Quote Originally Posted by skylendar View Post
    Any idea ?
    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.

  4. #4

    Default Re: Problems with akonadi on opensuse 13.1

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •