今天早上我發現MariaDb在從 FreeBSD 10.3 升級到 11.1 的過程中該檔案已從我的伺服器中刪除。重新安裝資料庫引擎並解決不相容的問題後my.cnf，我終於得到了MariaDb工作了 - 只是現在每一個使用者（root 除外）被拒絕存取其資料庫。
我嘗試為隨機用戶重置密碼，但這沒有任何區別。
哪裡有關於這裡出了什麼問題的有用資訊？這是server.err重新啟動資料庫後出現的所有資訊：
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Uses event mutexes
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Number of pools: 1
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Using SSE2 crc32 instructions
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Completed initialization of buffer pool
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-10 11:45:00 34424848384 [Note] InnoDB: 128 out of 128 rollback segments are active.
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-10 11:45:00 34424848384 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-10 11:45:00 34424848384 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-03-10 11:45:00 34424848384 [Note] InnoDB: 5.7.21 started; log sequence number 25246709
2018-03-10 11:45:00 37094309376 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2018-03-10 11:45:00 34424848384 [Note] Plugin 'FEEDBACK' is disabled.
2018-03-10 11:45:00 37094309376 [Note] InnoDB: Buffer pool(s) load completed at 180310 11:45:00
2018-03-10 11:45:00 34424848384 [Note] Server socket created on IP: '::'.
2018-03-10 11:45:00 34424848384 [Note] Reading of all Master_info entries succeded
2018-03-10 11:45:00 34424848384 [Note] Added new Master_info '' to hash table
2018-03-10 11:45:00 34424848384 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '10.2.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD Ports
2018-03-10 11:45:12 37180893952 [Warning] Access denied for user '<username>'@'localhost' (using password: YES)
2018-03-10 11:45:17 37180893952 [Warning] Access denied for user '<username>'@'localhost' (using password: YES)
2018-03-10 11:46:27 37180893952 [Warning] Access denied for user '<username>'@'localhost' (using password: YES)
在我開始升級 FreeBSD 之前，這是一個正在運行的伺服器。我沒有做任何事情來更改任何資料庫或文件的權限，事實上，我唯一做的就是做過改變的是作業系統和資料庫引擎 - 我會預期的數據透明的「升級」！
編輯
我查看了輸出mysql_upgrade，發現有很多與以下內容相關的錯誤系統資料庫.我不知道這些是否相關，或者我可以或應該對它們做什麼：
Phase 3/7: Fixing views from mysql
sys.host_summary
Error : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
status : Operation failed
sys.host_summary_by_file_io
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.host_summary_by_file_io_type
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.host_summary_by_stages
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.host_summary_by_statement_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.host_summary_by_statement_type
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.innodb_buffer_stats_by_schema
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.innodb_buffer_stats_by_table
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.innodb_lock_waits
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.io_by_thread_by_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.io_global_by_file_by_bytes
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.io_global_by_file_by_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.io_global_by_wait_by_bytes
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.io_global_by_wait_by_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.latest_file_io
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.memory_by_host_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error : View 'sys.memory_by_host_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.memory_by_thread_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_thread_by_event_name' doesn't exist
status : Operation failed
sys.memory_by_user_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
status : Operation failed
sys.memory_global_by_current_bytes
Error : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
status : Operation failed
sys.memory_global_total
Error : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error : View 'sys.memory_global_total' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.metrics
Error : Table 'performance_schema.global_status' doesn't exist
status : Operation failed
sys.processlist
Error : Table 'performance_schema.events_transactions_current' doesn't exist
status : Operation failed
sys.ps_check_lost_instrumentation
Error : Table 'performance_schema.global_status' doesn't exist
Error : View 'sys.ps_check_lost_instrumentation' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.schema_index_statistics
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.schema_table_lock_waits
Error : Table 'performance_schema.metadata_locks' doesn't exist
status : Operation failed
sys.schema_table_statistics
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.schema_table_statistics_with_buffer
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.schema_tables_with_full_table_scans
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.session
Error : Table 'performance_schema.events_transactions_current' doesn't exist
Error : View 'sys.session' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.session_ssl_status
Error : Table 'performance_schema.status_by_thread' doesn't exist
status : Operation failed
sys.statement_analysis
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.statements_with_errors_or_warnings
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.statements_with_full_table_scans
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.statements_with_runtimes_in_95th_percentile
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.statements_with_sorting
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.statements_with_temp_tables
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.user_summary
Error : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error : View 'sys.user_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.user_summary_by_file_io
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.user_summary_by_file_io_type
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.user_summary_by_stages
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.user_summary_by_statement_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.user_summary_by_statement_type
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.wait_classes_global_by_avg_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.wait_classes_global_by_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.waits_by_host_by_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.waits_by_user_by_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.waits_global_by_latency
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.x$host_summary
Error : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error : View 'sys.x$host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.x$memory_by_host_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error : View 'sys.x$memory_by_host_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.x$memory_by_thread_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_thread_by_event_name' doesn't exist
Error : View 'sys.x$memory_by_thread_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.x$memory_by_user_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error : View 'sys.x$memory_by_user_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.x$memory_global_by_current_bytes
Error : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error : View 'sys.x$memory_global_by_current_bytes' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.x$memory_global_total
Error : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error : View 'sys.x$memory_global_total' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.x$processlist
Error : Table 'performance_schema.events_transactions_current' doesn't exist
Error : View 'sys.x$processlist' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.x$ps_schema_table_statistics_io
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.x$schema_table_lock_waits
Error : Table 'performance_schema.metadata_locks' doesn't exist
Error : View 'sys.x$schema_table_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.x$schema_table_statistics
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.x$schema_table_statistics_with_buffer
Error : Cannot load from mysql.proc. The table is probably corrupted
Error : Corrupt
sys.x$session
Error : Table 'performance_schema.events_transactions_current' doesn't exist
Error : View 'sys.x$session' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
sys.x$user_summary
Error : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error : View 'sys.x$user_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error : Corrupt
編輯2
注意在這兩次編輯中，「確定」表都被刪除，以縮小問題中文字的大小。
我再次重新運行mysql_upgrade，因為我找到的搜尋結果為“mysql_upgrade 無法從 mysql.proc 載入。該表可能已損壞“所有似乎都表明此類問題可以通過運行來解決mysql_upgrade。（我必須運行，mysql_upgrade -p --force因為沒有--force它剛剛說的參數”此安裝的 MySQL 已升級至 10.2.13-MariaDB”）
現在我有一組不同的錯誤訊息，它們同樣不透明。 （下面每種情況下的序列invalid table(s) ... to use them都可以擴展為invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them- 我必須進行這些替換才能適應 30000 個字元的問題長度限制。）
Phase 3/7: Fixing views
sys.host_summary
Error : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error : View 'sys.host_summary' references invalid table(s) ... to use them
Error : Corrupt
sys.host_summary_by_file_io
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.host_summary_by_file_io' references invalid table(s) ... to use them
Error : Corrupt
sys.host_summary_by_file_io_type
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.host_summary_by_file_io_type' references invalid table(s) ... to use them
Error : Corrupt
sys.host_summary_by_stages
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.host_summary_by_stages' references invalid table(s) ... to use them
Error : Corrupt
sys.host_summary_by_statement_latency
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.host_summary_by_statement_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.host_summary_by_statement_type
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.host_summary_by_statement_type' references invalid table(s) ... to use them
Error : Corrupt
sys.innodb_buffer_stats_by_schema
Error : FUNCTION sys.format_bytes does not exist
Error : View 'sys.innodb_buffer_stats_by_schema' references invalid table(s) ... to use them
Error : Corrupt
sys.innodb_buffer_stats_by_table
Error : FUNCTION sys.format_bytes does not exist
Error : View 'sys.innodb_buffer_stats_by_table' references invalid table(s) ... to use them
Error : Corrupt
sys.innodb_lock_waits
Error : FUNCTION sys.format_statement does not exist
Error : View 'sys.innodb_lock_waits' references invalid table(s) ... to use them
Error : Corrupt
sys.io_by_thread_by_latency
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.io_by_thread_by_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.io_global_by_file_by_bytes
Error : FUNCTION sys.format_path does not exist
Error : View 'sys.io_global_by_file_by_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.io_global_by_file_by_latency
Error : FUNCTION sys.format_path does not exist
Error : View 'sys.io_global_by_file_by_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.io_global_by_wait_by_bytes
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.io_global_by_wait_by_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.io_global_by_wait_by_latency
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.io_global_by_wait_by_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.latest_file_io
Error : FUNCTION sys.format_path does not exist
Error : View 'sys.latest_file_io' references invalid table(s) ... to use them
Error : Corrupt
sys.memory_by_host_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error : View 'sys.memory_by_host_by_current_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.memory_by_thread_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_thread_by_event_name' doesn't exist
Error : View 'sys.memory_by_thread_by_current_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.memory_by_user_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error : View 'sys.memory_by_user_by_current_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.memory_global_by_current_bytes
Error : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error : View 'sys.memory_global_by_current_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.memory_global_total
Error : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error : View 'sys.memory_global_total' references invalid table(s) ... to use them
Error : Corrupt
sys.metrics
Error : Table 'performance_schema.global_status' doesn't exist
Error : View 'sys.metrics' references invalid table(s) ... to use them
Error : Corrupt
sys.processlist
Error : Table 'performance_schema.events_transactions_current' doesn't exist
Error : View 'sys.processlist' references invalid table(s) ... to use them
Error : Corrupt
sys.ps_check_lost_instrumentation
Error : Table 'performance_schema.global_status' doesn't exist
Error : View 'sys.ps_check_lost_instrumentation' references invalid table(s) ... to use them
Error : Corrupt
sys.schema_index_statistics
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.schema_index_statistics' references invalid table(s) ... to use them
Error : Corrupt
sys.schema_table_lock_waits
Error : Table 'performance_schema.metadata_locks' doesn't exist
Error : View 'sys.schema_table_lock_waits' references invalid table(s) ... to use them
Error : Corrupt
sys.schema_table_statistics
Error : FUNCTION sys.extract_schema_from_file_name does not exist
Error : View 'sys.schema_table_statistics' references invalid table(s) ... to use them
Error : Corrupt
sys.schema_table_statistics_with_buffer
Error : FUNCTION sys.extract_schema_from_file_name does not exist
Error : View 'sys.schema_table_statistics_with_buffer' references invalid table(s) ... to use them
Error : Corrupt
sys.schema_tables_with_full_table_scans
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.schema_tables_with_full_table_scans' references invalid table(s) ... to use them
Error : Corrupt
sys.session
Error : Table 'performance_schema.events_transactions_current' doesn't exist
Error : View 'sys.session' references invalid table(s) ... to use them
Error : Corrupt
sys.session_ssl_status
Error : Table 'performance_schema.status_by_thread' doesn't exist
Error : View 'sys.session_ssl_status' references invalid table(s) ... to use them
Error : Corrupt
sys.statement_analysis
Error : FUNCTION sys.format_statement does not exist
Error : View 'sys.statement_analysis' references invalid table(s) ... to use them
Error : Corrupt
sys.statements_with_errors_or_warnings
Error : FUNCTION sys.format_statement does not exist
Error : View 'sys.statements_with_errors_or_warnings' references invalid table(s) ... to use them
Error : Corrupt
sys.statements_with_full_table_scans
Error : FUNCTION sys.format_statement does not exist
Error : View 'sys.statements_with_full_table_scans' references invalid table(s) ... to use them
Error : Corrupt
sys.statements_with_runtimes_in_95th_percentile
Error : FUNCTION sys.format_statement does not exist
Error : View 'sys.statements_with_runtimes_in_95th_percentile' references invalid table(s) ... to use them
Error : Corrupt
sys.statements_with_sorting
Error : FUNCTION sys.format_statement does not exist
Error : View 'sys.statements_with_sorting' references invalid table(s) ... to use them
Error : Corrupt
sys.statements_with_temp_tables
Error : FUNCTION sys.format_statement does not exist
Error : View 'sys.statements_with_temp_tables' references invalid table(s) ... to use them
Error : Corrupt
sys.user_summary
Error : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error : View 'sys.user_summary' references invalid table(s) ... to use them
Error : Corrupt
sys.user_summary_by_file_io
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.user_summary_by_file_io' references invalid table(s) ... to use them
Error : Corrupt
sys.user_summary_by_file_io_type
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.user_summary_by_file_io_type' references invalid table(s) ... to use them
Error : Corrupt
sys.user_summary_by_stages
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.user_summary_by_stages' references invalid table(s) ... to use them
Error : Corrupt
sys.user_summary_by_statement_latency
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.user_summary_by_statement_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.user_summary_by_statement_type
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.user_summary_by_statement_type' references invalid table(s) ... to use them
Error : Corrupt
sys.wait_classes_global_by_avg_latency
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.wait_classes_global_by_avg_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.wait_classes_global_by_latency
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.wait_classes_global_by_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.waits_by_host_by_latency
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.waits_by_host_by_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.waits_by_user_by_latency
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.waits_by_user_by_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.waits_global_by_latency
Error : FUNCTION sys.format_time does not exist
Error : View 'sys.waits_global_by_latency' references invalid table(s) ... to use them
Error : Corrupt
sys.x$host_summary
Error : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error : View 'sys.x$host_summary' references invalid table(s) ... to use them
Error : Corrupt
sys.x$memory_by_host_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error : View 'sys.x$memory_by_host_by_current_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.x$memory_by_thread_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_thread_by_event_name' doesn't exist
Error : View 'sys.x$memory_by_thread_by_current_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.x$memory_by_user_by_current_bytes
Error : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error : View 'sys.x$memory_by_user_by_current_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.x$memory_global_by_current_bytes
Error : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error : View 'sys.x$memory_global_by_current_bytes' references invalid table(s) ... to use them
Error : Corrupt
sys.x$memory_global_total
Error : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
Error : View 'sys.x$memory_global_total' references invalid table(s) ... to use them
Error : Corrupt
sys.x$processlist
Error : Table 'performance_schema.events_transactions_current' doesn't exist
Error : View 'sys.x$processlist' references invalid table(s) ... to use them
Error : Corrupt
sys.x$ps_schema_table_statistics_io
Error : FUNCTION sys.extract_schema_from_file_name does not exist
Error : View 'sys.x$ps_schema_table_statistics_io' references invalid table(s) ... to use them
Error : Corrupt
sys.x$schema_table_lock_waits
Error : Table 'performance_schema.metadata_locks' doesn't exist
Error : View 'sys.x$schema_table_lock_waits' references invalid table(s) ... to use them
Error : Corrupt
sys.x$schema_table_statistics
Error : FUNCTION sys.extract_schema_from_file_name does not exist
Error : View 'sys.x$schema_table_statistics' references invalid table(s) ... to use them
Error : Corrupt
sys.x$schema_table_statistics_with_buffer
Error : FUNCTION sys.extract_schema_from_file_name does not exist
Error : View 'sys.x$schema_table_statistics_with_buffer' references invalid table(s) ... to use them
Error : Corrupt
sys.x$session
Error : Table 'performance_schema.events_transactions_current' doesn't exist
Error : View 'sys.x$session' references invalid table(s) ... to use them
Error : Corrupt
sys.x$user_summary
Error : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
Error : View 'sys.x$user_summary' references invalid table(s) ... to use them
Error : Corrupt
我嘗試跑步mysqlcheck -r sys -p -v，它告訴我
Enter password:
Processing databases
sys
sys.sys_config
Error : Table ' sys.sys_config' doesn't exist in engine
status : Operation failed
這是我問題的根源嗎？如果是這樣，我該如何修復它？