Skip to content

Instantly share code, notes, and snippets.

@pOmelchenko
Created July 8, 2019 16:29
Show Gist options
  • Save pOmelchenko/e376dc1e99060b2b49281567a13f61ed to your computer and use it in GitHub Desktop.
Save pOmelchenko/e376dc1e99060b2b49281567a13f61ed to your computer and use it in GitHub Desktop.
➜ l-application.lo git:(master) ✗ homestead ssh
Welcome to Ubuntu 18.04.2 LTS (GNU/Linux 4.15.0-54-generic x86_64)
Thanks for using
_ _ _
| | | | | |
| |__ ___ _ __ ___ ___ ___| |_ ___ __ _ __| |
| '_ \ / _ \| '_ ` _ \ / _ \/ __| __/ _ \/ _` |/ _` |
| | | | (_) | | | | | | __/\__ \ || __/ (_| | (_| |
|_| |_|\___/|_| |_| |_|\___||___/\__\___|\__,_|\__,_|
* Homestead v9.0.0 released
* Settler v8.0.0 released
20 packages can be updated.
4 updates are security updates.
Last login: Mon Jul 8 16:21:10 2019 from 10.0.2.2
vagrant@homestead:~$ mysql_upgrade --user="root" --password="secret" --verbose --force
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
MariaDB upgrade detected
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info 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
Upgrading from a version before MariaDB-10.1
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views from mysql
Processing databases
#mysql50#lost+found
mysqlcheck: Error: Couldn't get table list for database #mysql50#lost+found: Can't read dir of './lost+found/' (errno: 13 "Permission denied")
homestead
information_schema
mysql
performance_schema
sys
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) or column(s) or function(s) or definer/invoker of view lack rights to use them
error : Corrupt
sys.host_summary_by_file_io
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.host_summary_by_file_io_type
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.host_summary_by_stages
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.host_summary_by_statement_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.host_summary_by_statement_type
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.innodb_buffer_stats_by_schema
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.innodb_buffer_stats_by_table
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.innodb_lock_waits
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.io_by_thread_by_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.io_global_by_file_by_bytes
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.io_global_by_file_by_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.io_global_by_wait_by_bytes
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.io_global_by_wait_by_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.latest_file_io
Error : Column count of mysql.proc is wrong. Expected 21, found 20. 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
Error : View 'sys.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.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) or column(s) or function(s) or definer/invoker of view lack rights 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) or column(s) or function(s) or definer/invoker of view lack rights 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) 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
Error : View 'sys.metrics' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights 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) or column(s) or function(s) or definer/invoker of view lack rights 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) or column(s) or function(s) or definer/invoker of view lack rights to use them
error : Corrupt
sys.schema_auto_increment_columns OK
sys.schema_index_statistics
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.schema_object_overview OK
sys.schema_redundant_indexes OK
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) or column(s) or function(s) or definer/invoker of view lack rights to use them
error : Corrupt
sys.schema_table_statistics
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.schema_table_statistics_with_buffer
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.schema_tables_with_full_table_scans
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.schema_unused_indexes OK
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
Error : View 'sys.session_ssl_status' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
error : Corrupt
sys.statement_analysis
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.statements_with_errors_or_warnings
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.statements_with_full_table_scans
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.statements_with_runtimes_in_95th_percentile
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.statements_with_sorting
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.statements_with_temp_tables
Error : Column count of mysql.proc is wrong. Expected 21, found 20. 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 : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.user_summary_by_file_io_type
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.user_summary_by_stages
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.user_summary_by_statement_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.user_summary_by_statement_type
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.version OK
sys.wait_classes_global_by_avg_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.wait_classes_global_by_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.waits_by_host_by_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.waits_by_user_by_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.waits_global_by_latency
Error : Column count of mysql.proc is wrong. Expected 21, found 20. 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$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
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_digest_95th_percentile_by_avg_us OK
sys.x$ps_digest_avg_latency_distribution OK
sys.x$ps_schema_table_statistics_io
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.x$schema_flattened_keys OK
sys.x$schema_index_statistics OK
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 : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.x$schema_table_statistics_with_buffer
Error : Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted
error : Corrupt
sys.x$schema_tables_with_full_table_scans OK
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$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
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
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'
Phase 5/7: Fixing table and database names
Processing databases
#mysql50#lost+found
#mysql50#lost+found OK
homestead
information_schema
mysql
performance_schema
sys
Phase 6/7: Checking and upgrading tables
Processing databases
#mysql50#lost+found
mysqlcheck: Error: Couldn't get table list for database #mysql50#lost+found: Can't read dir of './lost+found/' (errno: 13 "Permission denied")
homestead
information_schema
lost+found
performance_schema
sys
sys.sys_config OK
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK
Could not create the upgrade info file '/var/lib/mysql/mysql_upgrade_info' in the MariaDB Servers datadir, errno: 13
vagrant@homestead:~$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment