https://bugs.kde.org/show_bug.cgi?id=236538
--- Comment #21 from Will Stephenson <wstephenson kde org> 2010-06-16 09:11:09 --- Look where the "Could not start/stop Akonadi! " debug from Akonadi::Control appears in the following log. This is where the selftestdialog appears. About 2 seconds later the database setup proceeds. This confirms that database setup takes longer than the 10s allowed by the self test dialog. This is on average hardware (core2 1.8Ghz, 5400rpm HD) so either the delay before MySQL allows the DB connection is erroneous, or the safety timeout is too aggressive in the first run case. If 2., can we detect first run early and set a longer safety timeout in this case? testu...@gorse:~> rm -rf ~/.local/share/akonadi/db_data/ ~/.local/share/akonadi/db_misc/ ~/.local/share/akonadi/file_db_data/ takonadiconsole akonadictl testu...@gorse:~> akonadictl status Akonadi Control: stopped Akonadi Server: stopped Akonadi Server Search Support: available (backend: Virtuoso) testu...@gorse:~> akonadiconsole Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [akonadiserver] search paths: ("/usr/lib/mpi/gcc/openmpi/bin", "/home/testuser/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/usr/lib/jvm/jre/bin", "/usr/lib/mit/bin", "/usr/lib/mit/sbin", ".", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin") [akonadiserver] Found mysql_install_db: "/usr/bin/mysql_install_db" [akonadiserver] Found mysql_upgrade: "/usr/bin/mysql_upgrade" "akonadiserver" [out] "Installing MySQL system tables... " "akonadiserver" [out] "OK " "akonadiserver" [out] "Filling help tables... " "akonadiserver" [out] "OK " "akonadiserver" [out] " " "akonadiserver" [out] "PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! " "akonadiserver" [out] "To do so, start the server, then issue the following commands: " "akonadiserver" [out] " " "akonadiserver" [out] "/usr/bin/mysqladmin -u root password 'new-password' " "akonadiserver" [out] "/usr/bin/mysqladmin -u root -h gorse password 'new-password' " "akonadiserver" [out] " " "akonadiserver" [out] "Alternatively you can run: " "akonadiserver" [out] "/usr/bin/mysql_secure_installation " "akonadiserver" [out] " " "akonadiserver" [out] "which will also give you the option of removing the test " "akonadiserver" [out] "databases and anonymous user created by default. This is " "akonadiserver" [out] "strongly recommended for production servers. " "akonadiserver" [out] " " "akonadiserver" [out] "See the manual for more instructions. " "akonadiserver" [out] " " "akonadiserver" [out] "You can start the MySQL daemon with: " "akonadiserver" [out] "rcmysql start " "akonadiserver" [out] " " "akonadiserver" [out] "You can test the MySQL daemon with mysql-test package " "akonadiserver" [out] " " "akonadiserver" [out] "Please report any problems with the /usr/bin/mysqlbug script! " "akonadiserver" [out] " " "akonadiserver" [out] "Looking for 'mysql' as: /usr/bin/mysql " "akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck " "akonadiserver" [out] "Running 'mysqlcheck' with connection arguments: '--socket=/home/testuser/.local/share/akonadi/db_misc/mysql.socket' " [akonadiserver] /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/home/testuser/.local/share/akonadi/db_misc/mysql.socket' (2) when trying to connect [akonadiserver] FATAL ERROR: Upgrade failed akonadiconsole(2295)/libakonadi Akonadi::Control::Private::exec: Could not start/stop Akonadi! [akonadiserver] Failed to use database "akonadi" [akonadiserver] Query error: "Unknown database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: "Can't connect to local MySQL server through socket '/home/testuser/.local/share/akonadi/db_misc/mysql.socket' (2) QMYSQL: Unable to connect" [akonadiserver] Trying to create database now... [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] DbInitializer::run() [akonadiserver] checking table "SchemaVersionTable" [akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);" [akonadiserver] checking table "ResourceTable" [akonadiserver] "CREATE TABLE ResourceTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) BINARY NOT NULL UNIQUE, isVirtual BOOL DEFAULT false);" [akonadiserver] checking table "CollectionTable" [akonadiserver] "CREATE TABLE CollectionTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, remoteId TEXT , name VARCHAR(255) BINARY character set utf8 collate utf8_bin NOT NULL, parentId BIGINT DEFAULT NULL REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, resourceId BIGINT NOT NULL REFERENCES ResourceTable(id) ON DELETE CASCADE ON UPDATE CASCADE, subscribed BOOL NOT NULL DEFAULT true, cachePolicyInherit BOOL NOT NULL DEFAULT true, cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1, cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1, cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false, cachePolicyLocalParts TEXT );" [akonadiserver] adding index "CREATE UNIQUE INDEX CollectionTable_parentAndNameIndex ON CollectionTable (parentId,name);" [akonadiserver] checking table "MimeTypeTable" [akonadiserver] "CREATE TABLE MimeTypeTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL UNIQUE);" [akonadiserver] checking table "PimItemTable" [akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, mimeTypeId BIGINT REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE CASCADE, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty BOOL , size BIGINT NOT NULL DEFAULT 0);" [akonadiserver] adding index "CREATE INDEX PimItemTable_collectionIndex ON PimItemTable (collectionId);" [akonadiserver] checking table "FlagTable" [akonadiserver] "CREATE TABLE FlagTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL UNIQUE);" [akonadiserver] checking table "PartTable" [akonadiserver] "CREATE TABLE PartTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, pimItemId BIGINT NOT NULL REFERENCES PimItemTable(id) ON DELETE CASCADE ON UPDATE CASCADE, name VARCHAR(255) NOT NULL, data LONGBLOB , datasize BIGINT NOT NULL, version INTEGER DEFAULT 0, external BOOL , FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON DELETE CASCADE ON UPDATE CASCADE);" [akonadiserver] adding index "CREATE UNIQUE INDEX PartTable_pimItemIdNameIndex ON PartTable (pimItemId,name);" [akonadiserver] checking table "CollectionAttributeTable" [akonadiserver] "CREATE TABLE CollectionAttributeTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, collectionId BIGINT NOT NULL REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, type LONGBLOB NOT NULL, value LONGBLOB );" [akonadiserver] adding index "CREATE INDEX CollectionAttributeTable_collectionIndex ON CollectionAttributeTable (collectionId);" [akonadiserver] checking relation "PimItemFlagRelation" [akonadiserver] "CREATE TABLE PimItemFlagRelation (PimItem_id INTEGER REFERENCES PimItemTable(id) , Flag_id INTEGER REFERENCES FlagTable(id) , PRIMARY KEY (PimItem_id, Flag_id));" [akonadiserver] checking relation "CollectionMimeTypeRelation" [akonadiserver] "CREATE TABLE CollectionMimeTypeRelation (Collection_id INTEGER REFERENCES CollectionTable(id) , MimeType_id INTEGER REFERENCES MimeTypeTable(id) , PRIMARY KEY (Collection_id, MimeType_id));" [akonadiserver] checking relation "CollectionPimItemRelation" [akonadiserver] "CREATE TABLE CollectionPimItemRelation (Collection_id INTEGER REFERENCES CollectionTable(id) , PimItem_id INTEGER REFERENCES PimItemTable(id) , PRIMARY KEY (Collection_id, PimItem_id));" [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] skipping update 13 [akonadiserver] skipping update 14 [akonadiserver] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] DataStore::unhideAllPimItems() [akonadiserver] Database "akonadi" opened using driver "QMYSQL" PLUGINS: "/usr/share/akonadi/agents" PLUGINS: ("birthdaysresource.desktop", "contactsresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "maildispatcheragent.desktop", "mboxresource.desktop", "microblog.desktop", "mtdummyresource.desktop", "nepomukcalendarfeeder.desktop", "nepomukcontactfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "pop3resource.desktop", "vcarddirresource.desktop", "vcardresource.desktop") search paths: ("/usr/lib/mpi/gcc/openmpi/bin", "/home/testuser/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/usr/lib/jvm/jre/bin", "/usr/lib/mit/bin", "/usr/lib/mit/sbin", ".") PLUGINS inserting: "akonadi_birthdays_resource" 0 ("Resource") PLUGINS inserting: "akonadi_contacts_resource" 0 ("Resource") PLUGINS inserting: "akonadi_ical_resource" 0 ("Resource") PLUGINS inserting: "akonadi_imap_resource" 0 ("Resource") PLUGINS inserting: "akonadi_kabc_resource" 0 ("Resource") PLUGINS inserting: "akonadi_kcal_resource" 0 ("Resource") PLUGINS inserting: "akonadi_kolabproxy_resource" 0 ("Resource", "Unique", "NoConfig") PLUGINS inserting: "akonadi_localbookmarks_resource" 0 ("Resource") PLUGINS inserting: "akonadi_maildir_resource" 1 ("Resource") PLUGINS inserting: "akonadi_maildispatcher_agent" 0 ("Unique", "Autostart", "NoConfig") PLUGINS inserting: "akonadi_mbox_resource" 0 ("Resource") PLUGINS inserting: "akonadi_microblog_resource" 0 ("Resource") PLUGINS inserting: "akonadi_mailtransport_dummy_resource" 0 ("Resource", "MailTransport") PLUGINS inserting: "akonadi_nepomuk_calendar_feeder" 0 ("Unique", "NoConfig") PLUGINS inserting: "akonadi_nepomuk_contact_feeder" 0 ("Unique", "Autostart", "NoConfig") PLUGINS inserting: "akonadi_nepomuktag_resource" 0 ("Resource", "Virtual", "Unique", "NoConfig") PLUGINS inserting: "akonadi_nntp_resource" 0 ("Resource") PLUGINS inserting: "akonadi_notes_resource" 0 ("Resource") PLUGINS inserting: "akonadi_pop3_resource" 0 ("Resource") PLUGINS inserting: "akonadi_vcarddir_resource" 0 ("Resource") PLUGINS inserting: "akonadi_vcard_resource" 0 ("Resource") [/usr/bin/akonadi_nepomuk_contact_feeder] Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [akonadiserver] Database "akonadi" opened using driver "QMYSQL" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(2379)/libakonadi Akonadi::DefaultResourceJob::slotResult: "Unknown resource" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(2379)/libakonadi Akonadi::ResourceScanJob::Private::fetchResult: "Unknown resource" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(2379)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Unknown error. (Unknown resource)" [/usr/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(2379) OutboxQueue::Private::localFoldersRequestResult: Failed to get outbox folder. [akonadiserver] Database "akonadi" opened using driver "QMYSQL" -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs