Hi,

yesterday I made a dist-upgrade on my debian SID machine. No I got a error message from akonadi when I want to use my groupdav ressource:

Unknown error. (There is no transaction in progress)

When I'm right, there was a actualisation from mysql components, but I don't see anything with akonadi. But akonadi use the mysql engine,...

Code: Select all

mysql-common ein (5.1.43-1)                                                                                                                                                                                                       
libmysqlclient16 ein (5.1.43-1)

Any suggestion what's wrong?

By

Grefabu

Try checking ~/.xsession-errors for related messages.

If you built the GroupDav resource yourself, you will probably need to rebuild it.

hmm, 'cat .xsession-errors | grep akonadi'

give me:

Code: Select all

[akonadiserver] search paths:  ("/usr/local/bin", "/usr/bin", "/bin", "/usr/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin")
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"                                                                                                                                             
[akonadiserver] DbInitializer::run()                                                                                                                                                                       
[akonadiserver] checking table  "SchemaVersionTable"                                                                                                                                                       
[akonadiserver] checking table  "ResourceTable"                                                                                                                                                             
[akonadiserver] checking table  "CollectionTable"                                                                                                                                                           
[akonadiserver] checking table  "MimeTypeTable"                                                                                                                                                             
[akonadiserver] checking table  "PimItemTable"                                                                                                                                                             
[akonadiserver] checking table  "FlagTable"                                                                                                                                                                 
[akonadiserver] checking table  "PartTable"                                                                                                                                                                 
[akonadiserver] checking table  "CollectionAttributeTable"                                                                                                                                                 
[akonadiserver] checking relation  "PimItemFlagRelation"                                                                                                                                                   
[akonadiserver] checking relation  "CollectionMimeTypeRelation"                                                                                                                                             
[akonadiserver] checking relation  "CollectionPimItemRelation"                                                                                                                                             
[akonadiserver] DbInitializer::run() done                                                                                                                                                                   
[akonadiserver] skipping update 2                                                                                                                                                                           
[akonadiserver] skipping update 3                                                                                                                                                                           
[akonadiserver] skipping update 4                                                                                                                                                                           
[akonadiserver] skipping update 8                                                                                                                                                                           
[akonadiserver] skipping update 10                                                                                                                                                                         
[akonadiserver] skipping update 12                                                                                                                                                                         
[akonadiserver] DbUpdater: update to version: 13  mandatory: true  code: "UPDATE CollectionTable SET parentId = NULL WHERE parentId = 0;                                                                   
[akonadiserver] ALTER TABLE CollectionTable CHANGE parentId parentId BIGINT DEFAULT NULL;"                                                                                                                 
[akonadiserver] DbUpdater: update to version: 14  mandatory: false  code: "UPDATE ResourceTable SET isVirtual = true WHERE name = 'akonadi_nepomuktag_resource';                                           
[akonadiserver] UPDATE ResourceTable SET isVirtual = true WHERE name = 'akonadi_search_resource';"                                                                                                         
[akonadiserver] DataStore::unhideAllPimItems()                                                                                                                                                             
[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file                                                               
[akonadiserver] Database error: Cannot open database.                                                                                                                                                       
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"                                                                                                                                             
[akonadiserver] Last database error: "Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)"                                                                                             
[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
[akonadiserver] Database error: Cannot open database.
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"
[akonadiserver] Last database error: "Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)"
PLUGINS:  "/usr/share/akonadi/agents"
PLUGINS inserting:  "akonadi_birthdays_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_distlist_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_ical_resource" 1 ("Resource")
PLUGINS inserting:  "akonadi_imap_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kabc_resource" 6 ("Resource")
PLUGINS inserting:  "akonadi_kcal_resource" 1 ("Resource")
PLUGINS inserting:  "akonadi_knut_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kolabproxy_resource" 0 ("Resource", "Unique", "NoConfig")
PLUGINS inserting:  "akonadi_localbookmarks_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_maildir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_microblog_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nepomuktag_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nntp_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_notes_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_strigi_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_vcarddir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_vcard_resource" 1 ("Resource")
PLUGINS:  "/usr/share/akonadi/agents"
[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
[akonadiserver] Database error: Cannot open database.
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"
[akonadiserver] Last database error: "Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)"
[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
[akonadiserver] Database error: Cannot open database.
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"
[akonadiserver] Last database error: "Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)"
[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
[akonadiserver] Database error: Cannot open database.
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"
[akonadiserver] Last database error: "Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)"
kdeinit4: preparing to launch /usr/bin/akonadiconsole
[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
[akonadiserver] Database error: Cannot open database.
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"
[akonadiserver] Last database error: "Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)"
[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
[akonadiserver] Database error: Cannot open database.
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"
[akonadiserver] Last database error: "Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)"
[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
[akonadiserver] Database error: Cannot open database.
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"
[akonadiserver] Last database error: "Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)"
[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
[akonadiserver] Database error: Cannot open database.
[akonadiserver] Last driver error: "QMYSQL: Unable to connect"
[akonadiserver] Last database error: "Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)"

But I don't understand.

I haven't build the groupdav resource, it is from the SID reposity,

Grefabu

The following error indicates the issue is with your MySQL packages.

Code: Select all

[akonadiserver] Character set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file                                                               
[akonadiserver] Database error: Cannot open database.

Please contact the appropriate Debian packager for Akonadi so they can request a fix from the MySQL packager.

Hi,

thank you for the hint.

now I install this packeges from trsting:

mysql-client-5.1
mysql-server-5.1
libmysqlclient16

akonadi-server
libakonadiprivate1

now it works again.

Bye

Gregor

I guess problem is in mySQl what is version mySQL you have?
восстановление зренияastigmatism

I am using the version as shipped in openSUSE 11.2.

Code: Select all

mysql  Ver 14.14 Distrib 5.1.36, for suse-linux-gnu (i686) using readline 6.0

Hi i am the new so tell me that which version is best for me?

Hi i am the new so tell me that which version is best for me?how to plan a wedding

thanks i am nembie...another information...best way to get rid of acne

I got too much interesting stuff on your blog. I guess I am not the only one having all the enjoyment here! Keep up the good work
kuttymovies
klwap
rdxhd
9kmovies
isaidub
Jio Rockers
Worldfree4u
yomovies
sdmoviespoint
todaypk