[Bug 236538] often does not find resource agents on first start of Kontact
Will Stephenson
wstephenson at kde.org
Wed Jun 16 08:11:15 BST 2010
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?
testuser at gorse:~> rm -rf ~/.local/share/akonadi/db_data/
~/.local/share/akonadi/db_misc/ ~/.local/share/akonadi/file_db_data/
takonadiconsole akonadictl
testuser at gorse:~> akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (backend: Virtuoso)
testuser at 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.
More information about the Kdepim-bugs
mailing list