Application: akonadiconsole (0.99) KDE Platform Version: 4.4.4 (KDE 4.4.4) Qt Version: 4.6.3 Operating System: Linux 2.6.31.12-0.2-desktop i686 Distribution: "openSUSE 11.2 (i586)" -- Information about the crash: at start PC i get Xserver crash at user profile loading and after that, akonadiserver can't start (probably i need restart PC - not tested yet) 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/alex/.config/akonadi/akonadiserverrc': [%General] Driver=QMYSQL SizeThreshold=4096 ExternalPayload=false [QMYSQL] Name=akonadi User= Password= Options="UNIX_SOCKET=/home/alex/.local/share/akonadi/db_misc/mysql.socket" ServerPath=/usr/sbin/mysqld StartServer=true Host= [Debug] Tracer=null [QPSQL] Name=akonadi Host= User= Password= Port=5432 Test 2: SUCCESS -------- MySQL server found. Details: You currently have configured Akonadi to use the MySQL server '/usr/sbin/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 locations varies depending on the distribution. Test 3: SUCCESS -------- MySQL server is executable. Details: MySQL server found: /usr/sbin/mysqld Ver 5.1.36 for suse-linux-gnu on i686 (SUSE MySQL RPM) Test 4: ERROR -------- MySQL server log contains errors. Details: The MySQL server error log file '<a href='/home/alex/.local/share/akonadi/db_data/mysql.err'>/home/alex/.local/share/akonadi/db_data/mysql.err</a>' contains errors. File content of '/home/alex/.local/share/akonadi/db_data/mysql.err': 100625 15:16:46 [Note] Plugin 'ndbcluster' is disabled. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 100625 15:16:46 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 100625 15:18:26 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 100625 15:18:26 InnoDB: Operating system error number 11 in a file operation. InnoDB: Error number 11 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! 100625 15:18:26 [ERROR] Plugin 'InnoDB' init function returned error. 100625 15:18:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 100625 15:18:26 [ERROR] Unknown/unsupported table type: innodb 100625 15:18:26 [ERROR] Aborting 100625 15:18:26 [Warning] Forcing shutdown of 1 plugins 100625 15:18:26 [Note] /usr/sbin/mysqld: Shutdown complete Test 5: 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] 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=latin1 collation_server=latin1_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=80M # 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=64M innodb_flush_log_at_trx_commit=2 # Do not drop the connection to the DB after 8 hours of inactivity wait_timeout=1296000 Test 6: SKIP -------- MySQL server custom configuration not available. Details: The custom configuration for the MySQL server was not found but is optional. Test 7: SUCCESS -------- MySQL server configuration is usable. Details: The MySQL server configuration was found at <a href='/home/alex/.local/share/akonadi/mysql.conf'>/home/alex/.local/share/akonadi/mysql.conf</a> and is readable. File content of '/home/alex/.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=latin1 collation_server=latin1_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=80M # 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=64M innodb_flush_log_at_trx_commit=2 # Do not drop the connection to the DB after 8 hours of inactivity wait_timeout=1296000 Test 8: 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.3.1 Test 9: ERROR -------- Akonadi control process not registered at D-Bus. Details: The Akonadi control process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup. Test 10: ERROR -------- Akonadi server process not registered at D-Bus. Details: The Akonadi server process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup. Test 11: 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 12: 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 13: ERROR -------- No resource agents found. Details: No resource agents have been found, Akonadi is not usable without at least one. This usually means that no resource agents are installed or that there is a setup problem. The following paths have been searched: '/usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to '/usr/local/share:/usr/share:/etc/opt/kde3/share:/opt/gnome/share:/opt/kde3/share', make sure this includes all paths where Akonadi agents are installed to. Directory listing of '/usr/share/akonadi/agents': birthdaysresource.desktop contactsresource.desktop gcalresource.desktop googledataresource.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 Environment variable XDG_DATA_DIRS is set to '/usr/local/share:/usr/share:/etc/opt/kde3/share:/opt/gnome/share:/opt/kde3/share' Test 14: ERROR -------- Current Akonadi server error log found. Details: The Akonadi server did report error during startup into <a href='/home/alex/.local/share/akonadi/akonadiserver.error'>/home/alex/.local/share/akonadi/akonadiserver.error</a>. File content of '/home/alex/.local/share/akonadi/akonadiserver.error': "[ 0: akonadiserver(_Z11akBacktracev+0x35) [0x80524d5] 1: akonadiserver [0x8052a6c] 2: [0xffffe400] 3: [0xffffe424] 4: /lib/libc.so.6(gsignal+0x4f) [0xb6fe90cf] 5: /lib/libc.so.6(abort+0x187) [0xb6fea9e7] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x94) [0xb737fe04] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8053aa8] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9b) [0xb741c00b] 9: /usr/lib/libQtCore.so.4 [0xb742b7bd] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb742ce1e] 11: /usr/lib/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x52) [0xb75e4642] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x438b) [0xb75f24db] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x287) [0xb75f36f7] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x83) [0xb75f3973] 15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb75f4e18] 16: akonadiserver(main+0x2d8) [0x804d0c8] 17: /lib/libc.so.6(__libc_start_main+0xfe) [0xb6fd4ace] 18: akonadiserver [0x804cd21] ] " Test 15: ERROR -------- Previous Akonadi server error log found. Details: The Akonadi server did report error during its previous startup into <a href='/home/alex/.local/share/akonadi/akonadiserver.error.old'>/home/alex/.local/share/akonadi/akonadiserver.error.old</a>. File content of '/home/alex/.local/share/akonadi/akonadiserver.error.old': "[ 0: akonadiserver(_Z11akBacktracev+0x35) [0x80524d5] 1: akonadiserver [0x8052a6c] 2: [0xffffe400] 3: [0xffffe424] 4: /lib/libc.so.6(gsignal+0x4f) [0xb704e0cf] 5: /lib/libc.so.6(abort+0x187) [0xb704f9e7] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x94) [0xb73e4e04] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8053aa8] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9b) [0xb748100b] 9: /usr/lib/libQtCore.so.4 [0xb74907bd] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb7491e1e] 11: /usr/lib/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x52) [0xb7649642] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x438b) [0xb76574db] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x287) [0xb76586f7] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x83) [0xb7658973] 15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb7659e18] 16: akonadiserver(main+0x2d8) [0x804d0c8] 17: /lib/libc.so.6(__libc_start_main+0xfe) [0xb7039ace] 18: akonadiserver [0x804cd21] ] " Test 16: SUCCESS -------- No current Akonadi control error log found. Details: The Akonadi control process did not report any errors during its current startup. Test 17: SUCCESS -------- No previous Akonadi control error log found. Details: The Akonadi control process did not report any errors during its previous startup. The crash can be reproduced every time. -- Backtrace: Application: Akonadi Console (akonadiconsole), signal: Segmentation fault [KCrash Handler] #6 0xb02a7012 in mysql_get_server_version () from /usr/lib/libmysqlclient_r.so.16 #7 0xb04adb35 in QMYSQLDriver::tables(QSql::TableType) const () from /usr/lib/qt4/plugins/sqldrivers/libqsqlmysql.so #8 0xb6f9a875 in QSqlDatabase::tables(QSql::TableType) const () from /usr/lib/libQtSql.so.4 #9 0x080777c9 in DbBrowser::DbBrowser (this=0x82b5578, parent=0x0) at /usr/src/debug/kdepim-4.4.4/akonadiconsole/dbbrowser.cpp:32 #10 0x0807c49c in MainWidget::MainWidget (this=0x81ada18, parent=0x81d6c80) at /usr/src/debug/kdepim-4.4.4/akonadiconsole/mainwidget.cpp:62 #11 0x0807e215 in MainWindow::MainWindow (this=0x81d6c80, parent=0x0, __in_chrg=<value optimized out>, __vtt_parm=<value optimized out>) at /usr/src/debug/kdepim-4.4.4/akonadiconsole/mainwindow.cpp:41 #12 0x0807bcae in main (argc=1, argv=0xbff49ac4) at /usr/src/debug/kdepim-4.4.4/akonadiconsole/main.cpp:45 This bug may be a duplicate of or related to bug 236593. Possible duplicates by query: bug 236593. Reported using DrKonqi
restart don't help
akonadictl start Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) Starting Akonadi Server... Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) done. alex@sled:/data/linux_home> [akonadiserver] search paths: ("/opt/ecomorph/bin", "/opt/ecomorph/sbin", "/usr/lib/mpi/gcc/openmpi/bin", "/home/alex/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/kde3/bin", "/opt/cross/bin", "/opt/brlcad/bin", "/usr/lib/mit/bin", "/usr/lib/mit/sbin", "/usr/NX/bin", "/opt/gnome/bin", ".", "/usr/lib/qt3/bin", "/usr/sbin+", "~/bin+", "~/bin", "/usr/sbin+", "~/bin+", "~/bin", "/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] "Looking for 'mysql' as: /usr/bin/mysql " "akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck " "akonadiserver" [out] "This installation of MySQL is already upgraded to 5.1.36, use --force if you still need to run mysql_upgrade " [akonadiserver] Failed to use database "akonadi" [akonadiserver] Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: " " [akonadiserver] Trying to create database now... [akonadiserver] Failed to create database [akonadiserver] Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: " " [akonadiserver] "[ [akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x80524d5] [akonadiserver] 1: akonadiserver [0x8052a6c] [akonadiserver] 2: [0xffffe400] [akonadiserver] 3: [0xffffe424] [akonadiserver] 4: /lib/libc.so.6(gsignal+0x4f) [0xb6f6c0cf] [akonadiserver] 5: /lib/libc.so.6(abort+0x187) [0xb6f6d9e7] [akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x94) [0xb7302e04] [akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8053aa8] [akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9b) [0xb739f00b] [akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb73ae7bd] [akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb73afe1e] [akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x52) [0xb7567642] [akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x438b) [0xb75754db] [akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x287) [0xb75766f7] [akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x83) [0xb7576973] [akonadiserver] 15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb7577e18] [akonadiserver] 16: akonadiserver(main+0x2d8) [0x804d0c8] [akonadiserver] 17: /lib/libc.so.6(__libc_start_main+0xfe) [0xb6f57ace] [akonadiserver] 18: akonadiserver [0x804cd21] [akonadiserver] ] [akonadiserver] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) [akonadiserver] search paths: ("/opt/ecomorph/bin", "/opt/ecomorph/sbin", "/usr/lib/mpi/gcc/openmpi/bin", "/home/alex/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/kde3/bin", "/opt/cross/bin", "/opt/brlcad/bin", "/usr/lib/mit/bin", "/usr/lib/mit/sbin", "/usr/NX/bin", "/opt/gnome/bin", ".", "/usr/lib/qt3/bin", "/usr/sbin+", "~/bin+", "~/bin", "/usr/sbin+", "~/bin+", "~/bin", "/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] "Looking for 'mysql' as: /usr/bin/mysql " "akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck " "akonadiserver" [out] "This installation of MySQL is already upgraded to 5.1.36, use --force if you still need to run mysql_upgrade " [akonadiserver] Failed to use database "akonadi" [akonadiserver] Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: " " [akonadiserver] Trying to create database now... [akonadiserver] Failed to create database [akonadiserver] Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: " " [akonadiserver] "[ [akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x80524d5] [akonadiserver] 1: akonadiserver [0x8052a6c] [akonadiserver] 2: [0xffffe400] [akonadiserver] 3: [0xffffe424] [akonadiserver] 4: /lib/libc.so.6(gsignal+0x4f) [0xb70940cf] [akonadiserver] 5: /lib/libc.so.6(abort+0x187) [0xb70959e7] [akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x94) [0xb742ae04] [akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8053aa8] [akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9b) [0xb74c700b] [akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb74d67bd] [akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb74d7e1e] [akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x52) [0xb768f642] [akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x438b) [0xb769d4db] [akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x287) [0xb769e6f7] [akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x83) [0xb769e973] [akonadiserver] 15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb769fe18] [akonadiserver] 16: akonadiserver(main+0x2d8) [0x804d0c8] [akonadiserver] 17: /lib/libc.so.6(__libc_start_main+0xfe) [0xb707face] [akonadiserver] 18: akonadiserver [0x804cd21] [akonadiserver] ] [akonadiserver] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) [akonadiserver] search paths: ("/opt/ecomorph/bin", "/opt/ecomorph/sbin", "/usr/lib/mpi/gcc/openmpi/bin", "/home/alex/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/kde3/bin", "/opt/cross/bin", "/opt/brlcad/bin", "/usr/lib/mit/bin", "/usr/lib/mit/sbin", "/usr/NX/bin", "/opt/gnome/bin", ".", "/usr/lib/qt3/bin", "/usr/sbin+", "~/bin+", "~/bin", "/usr/sbin+", "~/bin+", "~/bin", "/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] "Looking for 'mysql' as: /usr/bin/mysql " "akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck " "akonadiserver" [out] "This installation of MySQL is already upgraded to 5.1.36, use --force if you still need to run mysql_upgrade " [akonadiserver] Failed to use database "akonadi" [akonadiserver] Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: " " [akonadiserver] Trying to create database now... [akonadiserver] Failed to create database [akonadiserver] Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: " " [akonadiserver] "[ [akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x80524d5] [akonadiserver] 1: akonadiserver [0x8052a6c] [akonadiserver] 2: [0xffffe400] [akonadiserver] 3: [0xffffe424] [akonadiserver] 4: /lib/libc.so.6(gsignal+0x4f) [0xb70d50cf] [akonadiserver] 5: /lib/libc.so.6(abort+0x187) [0xb70d69e7] [akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x94) [0xb746be04] [akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8053aa8] [akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9b) [0xb750800b] [akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb75177bd] [akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb7518e1e] [akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x52) [0xb76d0642] [akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x438b) [0xb76de4db] [akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x287) [0xb76df6f7] [akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x83) [0xb76df973] [akonadiserver] 15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb76e0e18] [akonadiserver] 16: akonadiserver(main+0x2d8) [0x804d0c8] [akonadiserver] 17: /lib/libc.so.6(__libc_start_main+0xfe) [0xb70c0ace] [akonadiserver] 18: akonadiserver [0x804cd21] [akonadiserver] ] [akonadiserver] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) [akonadiserver] search paths: ("/opt/ecomorph/bin", "/opt/ecomorph/sbin", "/usr/lib/mpi/gcc/openmpi/bin", "/home/alex/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/kde3/bin", "/opt/cross/bin", "/opt/brlcad/bin", "/usr/lib/mit/bin", "/usr/lib/mit/sbin", "/usr/NX/bin", "/opt/gnome/bin", ".", "/usr/lib/qt3/bin", "/usr/sbin+", "~/bin+", "~/bin", "/usr/sbin+", "~/bin+", "~/bin", "/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] "Looking for 'mysql' as: /usr/bin/mysql " "akonadiserver" [out] "Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck " "akonadiserver" [out] "This installation of MySQL is already upgraded to 5.1.36, use --force if you still need to run mysql_upgrade " [akonadiserver] Failed to use database "akonadi" [akonadiserver] Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: " " [akonadiserver] Trying to create database now... [akonadiserver] Failed to create database [akonadiserver] Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query" [akonadiserver] Database error: " " [akonadiserver] "[ [akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x80524d5] [akonadiserver] 1: akonadiserver [0x8052a6c] [akonadiserver] 2: [0xffffe400] [akonadiserver] 3: [0xffffe424] [akonadiserver] 4: /lib/libc.so.6(gsignal+0x4f) [0xb6f780cf] [akonadiserver] 5: /lib/libc.so.6(abort+0x187) [0xb6f799e7] [akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x94) [0xb730ee04] [akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x8053aa8] [akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x9b) [0xb73ab00b] [akonadiserver] 9: /usr/lib/libQtCore.so.4 [0xb73ba7bd] [akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb73bbe1e] [akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x52) [0xb7573642] [akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer25startMysqlDatabaseProcessEv+0x438b) [0xb75814db] [akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x287) [0xb75826f7] [akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x83) [0xb7582973] [akonadiserver] 15: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb7583e18] [akonadiserver] 16: akonadiserver(main+0x2d8) [0x804d0c8] [akonadiserver] 17: /lib/libc.so.6(__libc_start_main+0xfe) [0xb6f63ace] [akonadiserver] 18: akonadiserver [0x804cd21] [akonadiserver] ] [akonadiserver] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) "akonadiserver" crashed too often and will not be restarted!
If run /usr/sbin/mysqld --defaults-file=/home/alex/.local/share/akonadi//mysql.conf --datadir=/home/alex/.local/share/akonadi/db_data/ before akonadictl start - it work! 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/alex/.config/akonadi/akonadiserverrc': [%General] Driver=QMYSQL SizeThreshold=4096 ExternalPayload=false [QMYSQL] Name=akonadi User= Password= Options="UNIX_SOCKET=/home/alex/.local/share/akonadi/db_misc/mysql.socket" ServerPath=/usr/sbin/mysqld StartServer=true Host= [Debug] Tracer=null [QPSQL] Name=akonadi Host= User= Password= Port=5432 Test 2: SUCCESS -------- MySQL server found. Details: You currently have configured Akonadi to use the MySQL server '/usr/sbin/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 locations varies depending on the distribution. Test 3: SUCCESS -------- MySQL server is executable. Details: MySQL server found: /usr/sbin/mysqld Ver 5.1.36 for suse-linux-gnu on i686 (SUSE MySQL RPM) Test 4: ERROR -------- MySQL server log contains errors. Details: The MySQL server error log file '<a href='/home/alex/.local/share/akonadi/db_data/mysql.err'>/home/alex/.local/share/akonadi/db_data/mysql.err</a>' contains errors. File content of '/home/alex/.local/share/akonadi/db_data/mysql.err': 100625 23:59:53 [Note] Plugin 'ndbcluster' is disabled. 100625 23:59:53 InnoDB: Started; log sequence number 0 340495 100625 23:59:53 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=sled-relay-bin' to avoid this problem. 100625 23:59:54 [Note] Slave I/O thread: connected to master 'alex@localhost:3306',replication started in log 'FIRST' at position 4 100625 23:59:54 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.36-log' socket: '/home/alex/.local/share/akonadi/db_misc/mysql.socket' port: 0 SUSE MySQL RPM 100625 23:59:54 [ERROR] Slave I/O: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it). Error_code: 1593 100625 23:59:54 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 100625 23:59:54 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './sled-relay-bin.000056' position: 4 Test 5: 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] 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=latin1 collation_server=latin1_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=80M # 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=64M innodb_flush_log_at_trx_commit=2 # Do not drop the connection to the DB after 8 hours of inactivity wait_timeout=1296000 Test 6: SKIP -------- MySQL server custom configuration not available. Details: The custom configuration for the MySQL server was not found but is optional. Test 7: SUCCESS -------- MySQL server configuration is usable. Details: The MySQL server configuration was found at <a href='/home/alex/.local/share/akonadi/mysql.conf'>/home/alex/.local/share/akonadi/mysql.conf</a> and is readable. File content of '/home/alex/.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=latin1 collation_server=latin1_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=80M # 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=64M innodb_flush_log_at_trx_commit=2 # Do not drop the connection to the DB after 8 hours of inactivity wait_timeout=1296000 Test 8: 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.3.1 Test 9: 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 10: 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 11: 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 12: SUCCESS -------- Server protocol version is recent enough. Details: The server Protocol version is 23, which equal or newer than the required version 23. Test 13: SUCCESS -------- Resource agents found. Details: At least one resource agent has been found. Directory listing of '/usr/share/akonadi/agents': birthdaysresource.desktop contactsresource.desktop gcalresource.desktop googledataresource.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 Environment variable XDG_DATA_DIRS is set to '/usr/local/share:/usr/share:/etc/opt/kde3/share:/opt/gnome/share:/opt/kde3/share' Test 14: SUCCESS -------- No current Akonadi server error log found. Details: The Akonadi server did not report any errors during its current startup. Test 15: SUCCESS -------- No previous Akonadi server error log found. Details: The Akonadi server did not report any errors during its previous startup. Test 16: SUCCESS -------- No current Akonadi control error log found. Details: The Akonadi control process did not report any errors during its current startup. Test 17: SUCCESS -------- No previous Akonadi control error log found. Details: The Akonadi control process did not report any errors during its previous startup.
Hej Alex, it looks like another mysqld instance is still running while you try to start Akonadi (which brings up its own mysqld instance). So shutdown Akonadi, kill all running mysqld processes (killall -9 mysqld), wait until all mysqld processes have really quit (ps ux | grep mysqld) and then start Akonadi again. It might also be helpful to update to KDE 4.4.5, we fixed several startup related bugs in that version. I'll close the bug for now, feel free to reopen it if you can still reproduce the bug with KDE 4.4.5. Ciao, Tobias