Bug 317293 - error message: "failed to fetch the resource collection
Summary: error message: "failed to fetch the resource collection
Status: RESOLVED UNMAINTAINED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: libakonadi (show other bugs)
Version: 4.10
Platform: Fedora RPMs Linux
: NOR critical
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-24 21:02 UTC by jmaldrich
Modified: 2018-02-01 09:49 UTC (History)
6 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description jmaldrich 2013-03-24 21:02:13 UTC
Launching Akonadictl from a console window, I see a whole bunch of error messages stating "Failed to fetch the resource collection." This is for everything from "special collections" to "maildir resource." When I then try to launch KMail I get the error message "The Email program encountered a fatal error and will terminate now. The error was: Failed to fetch the resource collection."

I upgraded my Fedora 17 this morning and started having problems with SMTP, so I rebooted and tried again and started getting this error, so I upgraded to Fedora 18 and am STILL getting this error.

Reproducible: Always

Steps to Reproduce:
1. Open Konsole
2. type "akonadictl start"
3. watch the error messages fly by!
Actual Results:  
Error messages above

Expected Results:  
Akonadi should load and then I should be able to load KMail and send/receive emails.

I started having this problem after upgrading to KMail 4.9.5 this morning and am still having it after upgrading to KMail 4.10.1-1.fc18.x86_64
Comment 1 Steven P. Ulrick 2013-03-25 13:03:55 UTC
I just did a fresh install of Fedora 18.  I was (trying) to run the KMail that is the current version for Fedora 18 (from the official Fedora repo.)  I got the same error that the reporter got.
Comment 2 jmaldrich 2013-03-25 15:50:29 UTC
Quoting "Steven P. Ulrick" <meow8282@gmail.com>:

> https://bugs.kde.org/show_bug.cgi?id=317293
>
> Steven P. Ulrick <meow8282@gmail.com> changed:
>
>            What    |Removed                     |Added
> ----------------------------------------------------------------------------
>                  CC|                            |meow8282@gmail.com
>
> --- Comment #1 from Steven P. Ulrick <meow8282@gmail.com> ---
> I just did a fresh install of Fedora 18.  I was (trying) to run the   
> KMail that
> is the current version for Fedora 18 (from the official Fedora repo.)  I got
> the same error that the reporter got.
>
> --
> You are receiving this mail because:
> You voted for the bug.
> You are on the CC list for the bug.
> You reported the bug.
>
Good to know I'm not the only one and that it happens on a fresh  
install as well as an upgrade!
Comment 3 András Manţia 2013-03-29 07:28:10 UTC
Please post the whole log about starting akonadi.
Comment 4 jmaldrich 2013-03-29 10:37:34 UTC
Here's the console output. If you want more, I'll need some instructions on how to get what you want.

akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[john@slave1 ~]$ search paths:  ("/usr/lib64/qt-3.3/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/home/john/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
Nepomuk Query Server not available
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
search paths:  ("/usr/lib64/qt-3.3/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/local/sbin", "/usr/sbin", "/home/john/bin") 
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
reading configurations from ~/.fonts.conf is deprecated.
reading configurations from ~/.fonts.conf is deprecated.
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
reading configurations from ~/.fonts.conf is deprecated.
reading configurations from ~/.fonts.conf is deprecated.
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
Fontconfig warning: "/etc/fonts/conf.d/50-user.conf", line 9: reading configurations from ~/.fonts.conf is deprecated.
search paths:  ("/usr/lib64/kde4/plugins", "/usr/lib/kde4/plugins", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/john/.kde/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/usr/lib64/kde4/plugins", "/usr/lib/kde4/plugins", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/john/.kde/lib64/kde4/", "/usr/lib64/kde4/") 
search paths:  ("/usr/lib64/kde4/plugins", "/usr/lib/kde4/plugins", "/usr/lib64/qt4/plugins", "/usr/bin", "/home/john/.kde/lib64/kde4/", "/usr/lib64/kde4/") 
akonadi_kabc_resource_3(27199)/kio (KDirWatch) KDirWatchPrivate::removeEntry: doesn't know "/home/john/.kde/share/apps/kabc" 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202) OutboxQueue::Private::localFoldersRequestResult: Failed to get outbox folder. Retrying in:  5000 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_2" : "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_2" : "Failed to fetch the resource collection." 
akonadi_kabc_resource_4(27200)/kio (KDirWatch) KDirWatchPrivate::removeEntry: doesn't know "/home/john/.kde/share/apps/kabc" 
akonadi_nepomuk_feeder(27204) FeederPluginloader::feederPluginsForMimeType: No feeder for type  "inode/directory"  found 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202) OutboxQueue::Private::localFoldersRequestResult: Failed to get outbox folder. Retrying in:  10000 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_2" : "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_2" : "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202) OutboxQueue::Private::localFoldersRequestResult: Failed to get outbox folder. Retrying in:  15000 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_2" : "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_2" : "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202) OutboxQueue::Private::localFoldersRequestResult: Failed to get outbox folder. Giving up. 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_2" : "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
akonadi_maildispatcher_agent(27202)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_2" : "Failed to fetch the resource collection."
Comment 5 András Manţia 2013-03-29 11:15:13 UTC
Please provide the output for akonadictl restart. It should include also lines about how the database is set up.
Comment 6 jmaldrich 2013-03-30 15:31:31 UTC
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadilog.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ less akonadictl.txt 
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
[john@slave1 ~]$ tail akonadictl.txt 
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Comment 7 jmaldrich 2013-03-30 15:33:24 UTC
Akonadi Server Self-Test Report
===============================

Test 1:  SUCCESS
--------

Database driver found.
Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server configuration and was found on your system.

File content of '/home/john/.config/akonadi/akonadiserverrc':
[%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

[QMYSQL]
Name=akonadi
User=
Password=
Options="UNIX_SOCKET=/home/john/.local/share/akonadi/socket-slave1.aldrich/mysql.socket"
ServerPath=/usr/libexec/mysqld
StartServer=true
Host=

[Debug]
Tracer=null

[QPSQL]
Name=akonadi
Host=
User=
Password=
Port=5432
StartServer=true

[SQLITE]
Name=akonadi


Test 2:  SUCCESS
--------

Akonadi is not running as root
Details: Akonadi is not running as a root/administrator user, which is the recommended setup for a secure system.

Test 3:  SUCCESS
--------

MySQL server found.
Details: You have currently configured Akonadi to use the MySQL server '/usr/libexec/mysqld'.
Make sure you have the MySQL server installed, set the correct path and ensure you have the necessary read and execution rights on the server executable. The server executable is typically called 'mysqld'; its location varies depending on the distribution.

Test 4:  SUCCESS
--------

MySQL server is executable.
Details: MySQL server found: /usr/libexec/mysqld  Ver 5.5.30 for Linux on x86_64 (MySQL Community Server (GPL))


Test 5:  SUCCESS
--------

MySQL server log contains no errors.
Details: The MySQL server log file &apos;<a href='/home/john/.local/share/akonadi/db_data/mysql.err'>/home/john/.local/share/akonadi/db_data/mysql.err</a>&apos; does not contain any errors or warnings.

File content of '/home/john/.local/share/akonadi/db_data/mysql.err':
130330 11:32:09 [Note] Plugin 'FEDERATED' is disabled.
130330 11:32:09 InnoDB: The InnoDB memory heap is disabled
130330 11:32:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130330 11:32:09 InnoDB: Compressed tables use zlib 1.2.7
130330 11:32:09 InnoDB: Using Linux native AIO
130330 11:32:09 InnoDB: Initializing buffer pool, size = 8.0M
130330 11:32:09 InnoDB: Completed initialization of buffer pool
130330 11:32:09 InnoDB: highest supported file format is Barracuda.
130330 11:32:09  InnoDB: Waiting for the background threads to start
130330 11:32:10 InnoDB: 5.5.30 started; log sequence number 36457852428
130330 11:32:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.30'  socket: '/home/john/.local/share/akonadi/socket-slave1.aldrich/mysql.socket'  port: 0  MySQL Community Server (GPL)


Test 6:  SUCCESS
--------

MySQL server default configuration found.
Details: The default configuration for the MySQL server was found and is readable at <a href='/etc/akonadi/mysql-global.conf'>/etc/akonadi/mysql-global.conf</a>.

File content of '/etc/akonadi/mysql-global.conf':
#
# Global Akonadi MySQL server settings,
# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
#
# Based on advice by Kris Köhntopp <kris@mysql.com>
#
[mysqld]

# strict query parsing/interpretation
# TODO: make Akonadi work with those settings enabled
# sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
# sql_mode=strict_trans_tables

# DEBUGGING:
# log all queries, useful for debugging but generates an enormous amount of data
# log=mysql.full
# log queries slower than n seconds, log file name relative to datadir (for debugging only)
# log_slow_queries=mysql.slow
# long_query_time=1
# log queries not using indices, debug only, disable for production use
# log_queries_not_using_indexes=1
#
# mesure database size and adjust innodb_buffer_pool_size
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");

# NOTES:
# Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)

#expire_logs_days=3

#sync_bin_log=0

# Use UTF-8 encoding for tables
character_set_server=utf8
collation_server=utf8_general_ci

# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb

# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:1M)
innodb_additional_mem_pool_size=1M

# memory buffer InnoDB uses to cache data and indexes of its tables (default:128M)
# Larger values means less I/O
innodb_buffer_pool_size=8M

# Create a .ibd file for each table (default:0)
innodb_file_per_table=1

# Write out the log buffer to the log file at each commit (default:1)
innodb_flush_log_at_trx_commit=2

# Buffer size used to write to the log files on disk (default:1M for builtin, 8M for plugin)
# larger values means less I/O
innodb_log_buffer_size=1M

# Size of each log file in a log group (default:5M) larger means less I/O but more time for recovery.
innodb_log_file_size=2M

# # error log file name, relative to datadir (default:hostname.err)
log_error=mysql.err

# print warnings and connection errors (default:1)
log_warnings=2

# Convert table named to lowercase
lower_case_table_names=1

# Maximum size of one packet or any generated/intermediate string. (default:1M)
max_allowed_packet=32M

# Maximum simultaneous connections allowed (default:100)
max_connections=256

# The two options below make no sense with prepared statements and/or transactions
# (make sense when having the same query multiple times)

# Memory allocated for caching query results (default:0 (disabled))
query_cache_size=0

# Do not cache results (default:1)
query_cache_type=0

# Do not use the privileges mechanisms
skip_grant_tables

# Do not listen for TCP/IP connections at all
skip_networking

# The number of open tables for all threads. (default:64)
table_cache=200

# How many threads the server should cache for reuse (default:0)
thread_cache_size=3

# wait 365d before dropping the DB connection (default:8h)
wait_timeout=31536000

[client]
default-character-set=utf8


Test 7:  SUCCESS
--------

MySQL server custom configuration found.
Details: The custom configuration for the MySQL server was found and is readable at <a href='/etc/akonadi/mysql-local.conf'>/etc/akonadi/mysql-local.conf</a>

File content of '/etc/akonadi/mysql-local.conf':


Test 8:  SUCCESS
--------

MySQL server configuration is usable.
Details: The MySQL server configuration was found at <a href='/home/john/.local/share/akonadi/mysql.conf'>/home/john/.local/share/akonadi/mysql.conf</a> and is readable.

File content of '/home/john/.local/share/akonadi/mysql.conf':
#
# Global Akonadi MySQL server settings,
# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
#
# Based on advice by Kris Köhntopp <kris@mysql.com>
#
[mysqld]
skip_grant_tables
skip_networking

# strict query parsing/interpretation
# TODO: make Akonadi work with those settings enabled
#sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
#sql_mode=strict_trans_tables

# use InnoDB for transactions and better crash recovery
default_storage_engine=innodb
# case-insensitive table names, avoids trouble on windows
lower_case_table_names=1
character_set_server=utf8
collation_server=utf8_general_ci
table_cache=200
thread_cache_size=3
#log_bin=mysql-bin
#expire_logs_days=3
#sync_bin_log=0
# error log file name, relative to datadir
log_error=mysql.err
log_warnings=2
# log all queries, useful for debugging but generates an enormous amount of data
#log=mysql.full
# log queries slower than n seconds, log file name relative to datadir (for debugging only)
#log_slow_queries=mysql.slow
#long_query_time=1
# log queries not using indices, debug only, disable for production use
#log_queries_not_using_indexes=1
# maximum blob size
max_allowed_packet=32M
max_connections=256
# makes sense when having the same query multiple times
# makes no sense with prepared statements and/or transactions
query_cache_type=0
query_cache_size=0

innodb_file_per_table=1
innodb_log_buffer_size=1M
innodb_additional_mem_pool_size=1M
# messure database size and adjust
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
innodb_buffer_pool_size=8M
# size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
innodb_log_file_size=2M
innodb_flush_log_at_trx_commit=2

# Do not drop the connection to the DB after 8 hours of inactivity
wait_timeout=31536000

[client]
default-character-set=utf8


Test 9:  SUCCESS
--------

akonadictl found and usable
Details: The program '/usr/bin/akonadictl' to control the Akonadi server was found and could be executed successfully.
Result:
Akonadi 1.9.1


Test 10:  SUCCESS
--------

Akonadi control process registered at D-Bus.
Details: The Akonadi control process is registered at D-Bus which typically indicates it is operational.

Test 11:  SUCCESS
--------

Akonadi server process registered at D-Bus.
Details: The Akonadi server process is registered at D-Bus which typically indicates it is operational.

Test 12:  ERROR
--------

Nepomuk search service not registered at D-Bus.
Details: The Nepomuk search service is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 13:  SKIP
--------

Protocol version check not possible.
Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.

Test 14:  SUCCESS
--------

Resource agents found.
Details: At least one resource agent has been found.

Directory listing of '/usr/share/akonadi/agents':
akonadinepomukfeederagent.desktop
akonotesresource.desktop
archivemailagent.desktop
birthdaysresource.desktop
contactsresource.desktop
davgroupwareresource.desktop
googlecalendarresource.desktop
googlecontactsresource.desktop
icaldirresource.desktop
icalresource.desktop
imapresource.desktop
invitationsagent.desktop
kabcresource.desktop
kalarmdirresource.desktop
kalarmresource.desktop
kcalresource.desktop
kdeaccountsresource.desktop
knutresource.desktop
kolabproxyresource.desktop
localbookmarksresource.desktop
maildirresource.desktop
maildispatcheragent.desktop
mailfilteragent.desktop
mboxresource.desktop
microblog.desktop
mixedmaildirresource.desktop
mtdummyresource.desktop
nepomuktagresource.desktop
nntpresource.desktop
notesresource.desktop
openxchangeresource.desktop
pop3resource.desktop
vcarddirresource.desktop
vcardresource.desktop

Environment variable XDG_DATA_DIRS is set to ''

Test 15:  ERROR
--------

Current Akonadi server error log found.
Details: The Akonadi server reported errors during its current startup. The log can be found in <a href='/home/john/.local/share/akonadi/akonadiserver.error'>/home/john/.local/share/akonadi/akonadiserver.error</a>.

File content of '/home/john/.local/share/akonadi/akonadiserver.error':
Nepomuk Query Server not available 


Test 16:  ERROR
--------

Previous Akonadi server error log found.
Details: The Akonadi server reported errors during its previous startup. The log can be found in <a href='/home/john/.local/share/akonadi/akonadiserver.error.old'>/home/john/.local/share/akonadi/akonadiserver.error.old</a>.

File content of '/home/john/.local/share/akonadi/akonadiserver.error.old':
Nepomuk Query Server not available 


Test 17:  SUCCESS
--------

No current Akonadi control error log found.
Details: The Akonadi control process did not report any errors during its current startup.

Test 18:  ERROR
--------

Previous Akonadi control error log found.
Details: The Akonadi control process reported errors during its previous startup. The log can be found in <a href='/home/john/.local/share/akonadi/akonadi_control.error.old'>/home/john/.local/share/akonadi/akonadi_control.error.old</a>.

File content of '/home/john/.local/share/akonadi/akonadi_control.error.old':
ProcessControl: Application /usr/bin/akonadi_imap_resource stopped unexpectedly ( "Process crashed" ) 
ProcessControl: Application /usr/bin/akonadi_imap_resource stopped unexpectedly ( "Process crashed" )
Comment 8 András Manţia 2013-04-04 06:54:08 UTC
Seems your imap resource is crashing (but you refer to maildir originally, so might be not related). Anyway, can you do a "ps uax | grep akonadi" to see what akonadi processes are running?
Comment 9 jmaldrich 2013-04-04 11:13:44 UTC
Quoting András Manţia  <amantia@kde.org>:

> https://bugs.kde.org/show_bug.cgi?id=317293
>
> --- Comment #8 from András Manţia <amantia@kde.org> ---
> Seems your imap resource is crashing (but you refer to maildir originally, so
> might be not related). Anyway, can you do a "ps uax | grep akonadi"   
> to see what
> akonadi processes are running?
>
Sure... and IMAP only crashes when I shut down Akonadi. The rest of  
the time (mostly) it works fine. IMAP *is* buggy, but in this case, I  
think it's a red herring, so to speak.

Here's the list:
john      9686  0.4  0.1 250036  5440 ?        Sl   07:10   0:00  
/usr/bin/akonadi_control
john      9688  2.0  0.3 1393460 15484 ?       Sl   07:10   0:02 akonadiserver
john      9690  2.8  0.8 1206900 31996 ?       Sl   07:10   0:03  
/usr/libexec/mysqld  
--defaults-file=/home/john/.local/share/akonadi/mysql.conf  
--datadir=/home/john/.local/share/akonadi/db_data/  
--socket=/home/john/.local/share/akonadi/socket-slave1.aldrich/mysql.socket
john      9721  0.4  0.6 700884 25456 ?        S    07:10   0:00  
/usr/bin/akonadi_archivemail_agent --identifier  
akonadi_archivemail_agent
john      9722  0.2  0.5 437060 19656 ?        Sl   07:10   0:00  
/usr/bin/akonadi_agent_launcher akonadi_contacts_resource  
akonadi_contacts_resource_1
john      9723  0.4  0.6 699868 24756 ?        Sl   07:10   0:00  
/usr/bin/akonadi_imap_resource --identifier akonadi_imap_resource_4
john      9724  1.2  0.8 707820 31804 ?        Sl   07:10   0:01  
/usr/bin/akonadi_imap_resource --identifier akonadi_imap_resource_7
john      9725  0.2  0.4 445872 18828 ?        S    07:10   0:00  
/usr/bin/akonadi_kabc_resource --identifier akonadi_kabc_resource_3
john      9726  0.2  0.4 513112 18232 ?        Sl   07:10   0:00  
/usr/bin/akonadi_kabc_resource --identifier akonadi_kabc_resource_4
john      9727  0.2  0.5 443456 19976 ?        Sl   07:10   0:00  
/usr/bin/akonadi_agent_launcher akonadi_maildir_resource  
akonadi_maildir_resource_2
john      9728  0.3  0.4 483976 18088 ?        S    07:10   0:00  
/usr/bin/akonadi_maildispatcher_agent --identifier  
akonadi_maildispatcher_agent
john      9729  1.2  0.7 705988 29728 ?        S    07:10   0:01  
/usr/bin/akonadi_mailfilter_agent --identifier akonadi_mailfilter_agent
john      9730  2.7  1.3 561836 52700 ?        Sl   07:10   0:03  
/usr/bin/akonadi_nepomuk_feeder --identifier akonadi_nepomuk_feeder
john      9731  0.2  0.4 443952 17400 ?        S    07:10   0:00  
/usr/bin/akonadi_pop3_resource --identifier akonadi_pop3_resource_6
john      9732  0.2  0.4 443828 17416 ?        S    07:10   0:00  
/usr/bin/akonadi_pop3_resource --identifier akonadi_pop3_resource_7
john      9733  0.2  0.4 443828 17412 ?        S    07:10   0:00  
/usr/bin/akonadi_pop3_resource --identifier akonadi_pop3_resource_9
john      9734  0.2  0.5 437120 19932 ?        Sl   07:10   0:00  
/usr/bin/akonadi_agent_launcher akonadi_vcard_resource  
akonadi_vcard_resource_0
john      9845  0.0  0.0 109184   848 pts/1    S+   07:12   0:00 grep  
--color=auto akonadi

Anything else you need, let me know.
Comment 10 jmaldrich 2013-05-16 00:14:08 UTC
Well, I'm not sure what it was, but some recent update seems to have fixed KMail. I'm now using kdepim-4.10.2-3.fc18.x86_64, akonadi-1.9.1-1.fc18.x86_64, akonadi-mysql-1.9.1-1.fc18.x86_64 and mysql-5.5.31-1.fc18.x86_64.
Comment 11 EMR_Kde 2014-04-08 13:27:46 UTC
getting the same problem in kmail. had to disable akonadi/nepomuk/virtuoso due to CPU usage on my laptop... after restarting the machine, I got this error "Failed to fetch the resource collection." Back to thunderbird for now - am too busy.
Comment 12 Roknrol 2015-04-29 20:28:38 UTC
Getting the same error following a distribution upgrade.  Have tried multiple fixes from various sources (KDE Forums suggested mariaDB updates, various other forums and boards have suggested deleting all of the .kde data...I have followed some of their directions, but nothing has worked).

Launching kmail or kontact from CLI produces the following errors:

kontact:

~$ kontact
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
Hspell: can't open /usr/share/hspell/hebrew.wgz.sizes.
~$ kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kontact(2567) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kontact(2567) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kontact(2567) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kontact(2567) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kontact(2567) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kontact(2567) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kontact(2567)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
Bus::open: Can not get ibus-daemon's address. 
IBusInputContext::createInputContext: no connection to ibus-daemon 


kmail:
~$ kmail
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
QDBusConnection: session D-Bus connection created before QCoreApplication. Application may misbehave.
Hspell: can't open /usr/share/hspell/hebrew.wgz.sizes.
~$ Bus::open: Can not get ibus-daemon's address. 
IBusInputContext::createInputContext: no connection to ibus-daemon 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kmail2(2606) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kmail2(2606) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kmail2(2606) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kmail2(2606) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kmail2(2606) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJob::slotResult: Failed SpecialCollectionsRequestJob::slotResult "Failed to fetch the resource collection." 
kmail2(2606) MailCommon::Kernel::emergencyExit: "The Email program encountered a fatal error and will terminate now.
The error was:
Failed to fetch the resource collection." 
kmail2(2606)/libakonadi Akonadi::SpecialCollectionsRequestJobPrivate::resourceScanResult: Failed to request resource "akonadi_maildir_resource_0" : "Failed to fetch the resource collection." 
 ~StorageServiceJobConfigPrivate  

Like the last poster, I've already invested quite a lot of time troubleshooting this.  Unlike the last poster, however, Thunderbird isn't really an option because it's a piece of crap.
Comment 13 Roknrol 2015-04-29 21:45:24 UTC
Update - I think KMail managed to fight through the issue.  Posting here for other folks to give it a shot.

I believe the issue was coming from my Local Folders, as when I would load KMail I could see my usual email account in the accounts list, however my local folders were titled "akonadi_maildir_resource_0" (which is the resource that kmail was telling me I was missing).

I tried clicking on my account information expecting that the error popup would prevent me from doing so, however I was allowed to click the resources specifically and see what was going on.  I didn't see anything there, but tried to see if my account settings were accessible as well figuring that maybe I could just disable stuff until I figured out what was going on.

While I was looking at my settings, the "Accounts" window hung - at about this time, I saw a popup stating that I had a bunch of "new" emails in my local folders (this had not happened previously).

I closed the accounts window and clicked the error message, after which kmail closed (as expected).

When I relaunched kmail I did not get any error messages and everything seems to be loading correctly (although the title of my Local folders seems to be borked, that's a minor issue)

I have not fully tested Kmail yet, but since I'm able to actually open it and get my email I'd consider my issue resolved.
Comment 14 Denis Kurz 2017-06-23 20:02:48 UTC
This bug has never been confirmed for a KDE PIM version that is based on KDE Frameworks (5.x). Those versions differ significantly from the old 4.x series. Therefore, I plan to close it in around two or three months. In the meantime, it is set to WAITINGFORINFO to give reporters the oportunity to check if it is still valid. As soon as someone confirms it for a recent version (at least 5.1, ideally even more recent), I'll gladly reopen it.

Please understand that we lack the manpower to triage bugs reported for versions almost two years beyond their end of life.
Comment 15 Denis Kurz 2018-02-01 09:49:04 UTC
Just as announced in my last comment, I close this bug. If you encounter it again in a recent version (at least 5.1 aka 15.12; preferably much more recent), please open a new one unless it already exists. Thank you for all your input.