https://bugs.kde.org/show_bug.cgi?id=468992
Bug ID: 468992
Summary: Cannot start akonadi, FATAL ERROR: Upgrade failed
Classification: Frameworks and Libraries
Product: Akonadi
Version: unspecified
Platform: Other
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: libakonadi
Assignee: kdepim-b...@kde.org
Reporter: ge...@electron.me.uk
CC: c...@carlschwan.eu
Target Milestone: ---
Created attachment 158441
--> https://bugs.kde.org/attachment.cgi?id=158441&action=edit
Self Test Output
SUMMARY
Cannot start akonadi, first noticed when kmail refused to work because akonadi
isn't running.
OBSERVED RESULT
Note that I have deleted ~/.local/share/akonadi to help in finding this bug, so
the info below is from a clean database. Also, I have attached the output of
the self test.
$ akonadictl start
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl: done.
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: mysqld for Akonadi is already running, trying to
connect to it.
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.global_priv OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats 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.transaction_registry OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
mysql.user OK
sys.host_summary OK
sys.host_summary_by_file_io OK
sys.host_summary_by_file_io_type OK
sys.host_summary_by_stages OK
sys.host_summary_by_statement_latency OK
sys.host_summary_by_statement_type OK
sys.innodb_buffer_stats_by_schema OK
sys.innodb_buffer_stats_by_table OK
sys.innodb_lock_waits OK
sys.io_by_thread_by_latency OK
sys.io_global_by_file_by_bytes OK
sys.io_global_by_file_by_latency OK
sys.io_global_by_wait_by_bytes OK
sys.io_global_by_wait_by_latency OK
sys.latest_file_io OK
sys.memory_by_host_by_current_bytes OK
sys.memory_by_thread_by_current_bytes OK
sys.memory_by_user_by_current_bytes OK
sys.memory_global_by_current_bytes OK
sys.memory_global_total OK
sys.metrics OK
sys.processlist OK
sys.ps_check_lost_instrumentation OK
sys.schema_auto_increment_columns OK
sys.schema_index_statistics OK
sys.schema_object_overview OK
sys.schema_redundant_indexes OK
sys.schema_table_lock_waits OK
sys.schema_table_statistics OK
sys.schema_table_statistics_with_buffer OK
sys.schema_tables_with_full_table_scans OK
sys.schema_unused_indexes OK
sys.session OK
sys.session_ssl_status OK
sys.statement_analysis OK
sys.statements_with_errors_or_warnings OK
sys.statements_with_full_table_scans OK
sys.statements_with_runtimes_in_95th_percentile OK
sys.statements_with_sorting OK
sys.statements_with_temp_tables OK
sys.user_summary OK
sys.user_summary_by_file_io OK
sys.user_summary_by_file_io_type OK
sys.user_summary_by_stages OK
sys.user_summary_by_statement_latency OK
sys.user_summary_by_statement_type OK
sys.version OK
sys.wait_classes_global_by_avg_latency OK
sys.wait_classes_global_by_latency OK
sys.waits_by_host_by_latency OK
sys.waits_by_user_by_latency OK
sys.waits_global_by_latency OK
sys.x$host_summary OK
sys.x$host_summary_by_file_io OK
sys.x$host_summary_by_file_io_type OK
sys.x$host_summary_by_stages OK
sys.x$host_summary_by_statement_latency OK
sys.x$host_summary_by_statement_type OK
sys.x$innodb_buffer_stats_by_schema OK
sys.x$innodb_buffer_stats_by_table OK
sys.x$innodb_lock_waits OK
sys.x$io_by_thread_by_latency OK
sys.x$io_global_by_file_by_bytes OK
sys.x$io_global_by_file_by_latency OK
sys.x$io_global_by_wait_by_bytes OK
sys.x$io_global_by_wait_by_latency OK
sys.x$latest_file_io OK
sys.x$memory_by_host_by_current_bytes OK
sys.x$memory_by_thread_by_current_bytes OK
sys.x$memory_by_user_by_current_bytes OK
sys.x$memory_global_by_current_bytes OK
sys.x$memory_global_total OK
sys.x$processlist OK
sys.x$ps_digest_95th_percentile_by_avg_us OK
sys.x$ps_digest_avg_latency_distribution OK
sys.x$ps_schema_table_statistics_io OK
sys.x$schema_flattened_keys OK
sys.x$schema_index_statistics OK
sys.x$schema_table_lock_waits OK
sys.x$schema_table_statistics OK
sys.x$schema_table_statistics_with_buffer OK
sys.x$schema_tables_with_full_table_scans OK
sys.x$session OK
sys.x$statement_analysis OK
sys.x$statements_with_errors_or_warnings OK
sys.x$statements_with_full_table_scans OK
sys.x$statements_with_runtimes_in_95th_percentile OK
sys.x$statements_with_sorting OK
sys.x$statements_with_temp_tables OK
sys.x$user_summary OK
sys.x$user_summary_by_file_io OK
sys.x$user_summary_by_file_io_type OK
sys.x$user_summary_by_stages OK
sys.x$user_summary_by_statement_latency OK
sys.x$user_summary_by_statement_type OK
sys.x$wait_classes_global_by_avg_latency OK
sys.x$wait_classes_global_by_latency OK
sys.x$waits_by_host_by_latency OK
sys.x$waits_by_user_by_latency OK
sys.x$waits_global_by_latency OK
Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 1 (HY000) at line 9: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 10: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 11: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 12: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 13: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 14: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 15: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 16: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 17: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 18: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 19: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 20: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 21: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 22: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 23: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 24: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 25: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 26: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 27: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 28: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 29: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 30: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 31: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 53: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 72: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 141: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 159: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 194: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 232: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 246: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 294: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
ERROR 1 (HY000) at line 361: Can't create/write to file
'/home/geoff/.local/share/akonadi/db_data/mysql/#sql-alter-41e4-4f.MAI'
(Errcode: 2 "No such file or directory")
FATAL ERROR: Upgrade failed
org.kde.pim.akonadiserver: Failed to create database
org.kde.pim.akonadiserver: Query error: "Access denied for user ''@'localhost'
to database 'akonadi' QMYSQL: Unable to execute query"
org.kde.pim.akonadiserver: Database error: ""
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited
normally...
SOFTWARE/OS VERSIONS
Operating System: KDE neon 5.27
KDE Plasma Version: 5.27.4
KDE Frameworks Version: 5.105.0
Qt Version: 5.15.9
Kernel Version: 5.19.0-41-generic (64-bit)
Graphics Platform: X11
Processors: 8 × Intel® Core™ i7-6700K CPU @ 4.00GHz
Memory: 15.6 GiB of RAM
Graphics Processor: NVIDIA GeForce GTX 1050 Ti/PCIe/SSE2
--
You are receiving this mail because:
You are watching all bug changes.
