Errors on fresh DA install with mariadb

Richard G

Richard G

Verified User
Joined
Jul 6, 2008
Messages
13,684
Location
Maastricht
For a friend I'm installing a VPS with DA.

Fresh installation done. The editted the options.conf and changed mariadb to 10.2 and mysql_inst to mariadb.
Then did ./build update and the ./build update_versions command.

It looked fine in the beginning but then:
Code: 
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    : Cannot load from mysql.proc. 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    : 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$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

Bunch of errors. I know I can probably ignore the "performance_scheme" errors.
But what about the users? user_summary and "sys.x$session" and stuff?
Cannot load mysql.proc?

Is this a bug or can this be ignored or why is this happening?
P.s. it's a personal license, but this should not be a problem correct?
 
I guess you’re trying to downgrade MySQL 5.7 to MariaDB 10.2?
 
Downgrade? Last time I was told that mysql 5.7 should be converted to MariaDB 10.2. So it's not a downgrade but a conversion, correct? How would this be a downgrade?

Mysql 5.7 is installed by default on a fresh installation. I did nothing else yet and just want to change this to MariaDB 10.2. So I tried this way. Worked last time.
Should this be done anoter way then on fresh installations?
 
If it’s a new install, try stoping mysql, renaming data directory and running “./build mariadb” then.
 
Hmmz. I thought in a support ticket last year you told me that you had adjusted the conversion so msyql would be stopped when converting, especially for people with memory leaks like me. :)

Stopped now first and it looks fine, except for this:
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Restarting MySQL.
Installation completed.
Click to expand...

I presume this can be ignored because I can access with the password in /usr/local/directadmin/conf/my.cnf as root?

Just for feature references, the installation script only asked me for apache, php and mod_ruid. Is there an easy way to just intall Mariadb from scratch of the installation?
Or do I have to push the N for No in the beginning and select everything then?
 
Richard G said:
Hmmz. I thought in a support ticket last year you told me that you had adjusted the conversion so msyql would be stopped when converting, especially for people with memory leaks like me. :)

Stopped now first and it looks fine, except for this:


I presume this can be ignored because I can access with the password in /usr/local/directadmin/conf/my.cnf as root?

Just for feature references, the installation script only asked me for apache, php and mod_ruid. Is there an easy way to just intall Mariadb from scratch of the installation?
Or do I have to push the N for No in the beginning and select everything then?
Click to expand...

How to choose MariaDB and PHP versions for fresh DA install?

When I install DA on a new server, I've done both ways - manual choosing the CustomBuild option in Setup, and the "auto" parameter for an easy DA setup. What are the steps to choose the specific versions of the software you want the first time you install DA? For example, I want to install...
forum.directadmin.com forum.directadmin.com

Recommends editing the config mid-install prompt.
 
Richard G said:
Or do I have to push the N for No in the beginning and select everything then?
Click to expand...

I would just do this. Few months ago when I setup two new CentOS 8 servers, I was given choise to install MariaDB, so I did not need to change it afterwards. Much better to select everything, then you have much more control from the beginning.

By the way, I don't like that DirectAdmin has changed the default to be MySQL, but I guess they did it because of all the cPanel admins wich still was running MySQL. I think DirectAdmin should set MariaDB back to be the default selected in the installer, and with that support the true open source database solution, and not the big capitalistic Oracle wich operate in the grey zone of the open source market.
 
Last edited:
I pushed then N in the past, worked great, but I got a bit confused because mariadb was default and in the short list only apache/php7.2/modruid2 was mentioned. Thought I might get the mysql choice later on.

ditto said:
I don't like that DirectAdmin has changed the default to be MySQL,
Click to expand...
That was for a very short time indeed, because the default always was Mysql before. Could indeed be put back to Mysql for the cPanel admins.
Might indeed be better to put it back to MariaDB again.
 
Still the same problem here in 2021, on a fresh auto install with MySQL 5.7 if you upgrade to MariaDB 10.2 as suggested on:

https://docs.directadmin.com/other-...to-upgrade-mysql--mariadb-with-custombuild-20

You'll still get the same errors:

Code: 
# ./build mariadb
    Dumping database admin_nextcloud 
    Dumping database da_roundcube 
    Dumping database mysql 
    Dumping database sys 
--2021-04-12 15:35:56--  https://files-fr.directadmin.com/services/all/mariadb/10.2/10.2.37/mariadb-10.2.37-linux-glibc_214-x86_64.tar.gz
Resolving files-fr.directadmin.com (files-fr.directadmin.com)... 2001:41d0:8:4a71::5, 92.222.207.19
Connecting to files-fr.directadmin.com (files-fr.directadmin.com)|2001:41d0:8:4a71::5|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 814365135 (777M) [application/octet-stream]
Saving to: ‘mariadb-10.2.37-linux-glibc_214-x86_64.tar.gz’

mariadb-10.2.37-linux-glibc_214-x86_64.tar.gz     100%[=============================================================================================================>] 776.64M  16.7MB/s    in 41s     

2021-04-12 15:36:38 (18.7 MB/s) - ‘mariadb-10.2.37-linux-glibc_214-x86_64.tar.gz’ saved [814365135/814365135]

mv: 'mariadb-10.2.37-linux-glibc_214-x86_64.tar.gz' and '/usr/local/mariadb-10.2.37-linux-glibc_214-x86_64.tar.gz' are the same file
Stopping mysqld ...
Linking /usr/local/mysql/bin/aria_chk -> /usr/local/bin/aria_chk...
Linking /usr/local/mysql/bin/aria_dump_log -> /usr/local/bin/aria_dump_log...
Linking /usr/local/mysql/bin/aria_ftdump -> /usr/local/bin/aria_ftdump...
Linking /usr/local/mysql/bin/aria_pack -> /usr/local/bin/aria_pack...
Linking /usr/local/mysql/bin/aria_read_log -> /usr/local/bin/aria_read_log...
Linking /usr/local/mysql/bin/garbd -> /usr/local/bin/garbd...
Linking /usr/local/mysql/bin/mariabackup -> /usr/local/bin/mariabackup...
Linking /usr/local/mysql/bin/mariadb_config -> /usr/local/bin/mariadb_config...
Linking /usr/local/mysql/bin/mbstream -> /usr/local/bin/mbstream...
Linking /usr/local/mysql/bin/msql2mysql -> /usr/local/bin/msql2mysql...
Linking /usr/local/mysql/bin/myrocks_hotbackup -> /usr/local/bin/myrocks_hotbackup...
Linking /usr/local/mysql/bin/mysql_client_test -> /usr/local/bin/mysql_client_test...
Linking /usr/local/mysql/bin/mysql_client_test_embedded -> /usr/local/bin/mysql_client_test_embedded...
Linking /usr/local/mysql/bin/mysql_convert_table_format -> /usr/local/bin/mysql_convert_table_format...
Linking /usr/local/mysql/bin/mysql_find_rows -> /usr/local/bin/mysql_find_rows...
Linking /usr/local/mysql/bin/mysql_fix_extensions -> /usr/local/bin/mysql_fix_extensions...
Linking /usr/local/mysql/bin/mysql_ldb -> /usr/local/bin/mysql_ldb...
Linking /usr/local/mysql/bin/mysql_setpermission -> /usr/local/bin/mysql_setpermission...
Linking /usr/local/mysql/bin/mysql_waitpid -> /usr/local/bin/mysql_waitpid...
Linking /usr/local/mysql/bin/mysqlaccess -> /usr/local/bin/mysqlaccess...
Linking /usr/local/mysql/bin/mysqld_safe_helper -> /usr/local/bin/mysqld_safe_helper...
Linking /usr/local/mysql/bin/mysqlhotcopy -> /usr/local/bin/mysqlhotcopy...
Linking /usr/local/mysql/bin/mysqltest -> /usr/local/bin/mysqltest...
Linking /usr/local/mysql/bin/mysqltest_embedded -> /usr/local/bin/mysqltest_embedded...
Linking /usr/local/mysql/bin/mytop -> /usr/local/bin/mytop...
Linking /usr/local/mysql/bin/sst_dump -> /usr/local/bin/sst_dump...
Linking /usr/local/mysql/bin/tokuft_logprint -> /usr/local/bin/tokuft_logprint...
Linking /usr/local/mysql/bin/tokuftdump -> /usr/local/bin/tokuftdump...
Linking /usr/local/mysql/bin/wsrep_sst_common -> /usr/local/bin/wsrep_sst_common...
Linking /usr/local/mysql/bin/wsrep_sst_mariabackup -> /usr/local/bin/wsrep_sst_mariabackup...
Linking /usr/local/mysql/bin/wsrep_sst_mysqldump -> /usr/local/bin/wsrep_sst_mysqldump...
Linking /usr/local/mysql/bin/wsrep_sst_rsync -> /usr/local/bin/wsrep_sst_rsync...
Linking /usr/local/mysql/bin/wsrep_sst_rsync_wan -> /usr/local/bin/wsrep_sst_rsync_wan...
Linking /usr/local/mysql/bin/wsrep_sst_xtrabackup -> /usr/local/bin/wsrep_sst_xtrabackup...
Linking /usr/local/mysql/bin/wsrep_sst_xtrabackup-v2 -> /usr/local/bin/wsrep_sst_xtrabackup-v2...
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
Giving mysqld a another few seconds to start up...
Giving mysqld last 20 seconds to start up...
sys.host_summary
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
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
sys.memory_by_user_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
sys.memory_global_by_current_bytes
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
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
sys.processlist
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
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
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
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
Restarting MySQL.
Installation completed.
 
Last edited:
tristan said:
Still the same problem here in 2021, on a fresh auto install with MySQL 5.7 if you upgrade to MariaDB 10.2 as suggested on:

https://docs.directadmin.com/other-...to-upgrade-mysql--mariadb-with-custombuild-20

You'll still get the same errors:

Code: 
Giving mysqld a few seconds to start up...
Giving mysqld a another few seconds to start up...
Giving mysqld last 20 seconds to start up...
sys.host_summary
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
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
sys.memory_by_user_by_current_bytes
Error    : Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist
sys.memory_global_by_current_bytes
Error    : Table 'performance_schema.memory_summary_global_by_event_name' doesn't exist
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
sys.processlist
Error    : Table 'performance_schema.events_transactions_current' doesn't exist
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
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
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
Restarting MySQL.
Installation completed.
Click to expand...
if it's a clean server - just drop mysql and install again needed version, without upgrade.
always better to have new working, than repair old broken - it ill save a lot of time/money.
 
Yup, I agree completely with you. Just weird this bug is still there after all this time. If migrating from MySQL to MariaDB obviously still doesn't work it should probably be removed from CB (and docs) or implemented in a more basic way with CB dumping all the databases, removing MySQL completely, building MariaDB and just import all the databases again.
 
tristan said:
If migrating from MySQL to MariaDB obviously still doesn't work
Click to expand...
It does work. I converted a couple of times. But you have to stop mysql first. Do it via DA otherwise DA will detect it's down and start it again.
First backup full mysql.

Then stop mysql, copy /var/lib/mysql (so the data directory) to another place for backup too.
Then change to MariaDB 10.2 in options.conf and build MariaDB.

So in the cases I encountered, it was because mysql was still or again (da started it again) running during conversion.

However, if people know how to dump and import all tables after conversion, it might indeed be easier to do it that way.
 
Yes I would think so. Especially since a lot of ex cPanel customers are coming over. And since lots of them are spoiled by cP (read: not real console admin knowledge, nicely said), it would be good to have some extended kind of manual on things/options.

And ofcourse also for newbie admins which start with the personal license.
 
Or just add the stopping of MySQL to the CB script since it already knows it's migrating MySQL to MariaDB anyway so why not stop MySQL first as well?
 
The stopping of MySQL should be present in the script, because of my stupid failure to forget stopping it, SMtalk added it as a foolproof option.
However, I'm not sure how it was stopped and if was taken care of that DA would nog start it again.

I like to think he did. However I don't know if anything changed since then.
 
Ah yes, just noticed CB did stop MySQL so that isn't the solution I'm afraid. Added the complete output of the ./build mariadb command in my post to clarify.
 
tristan said:
till the same problem here in 2021, on a fresh auto install with MySQL 5.7
Click to expand...
Just another question. How do you get a fresh auto install with mysql 5.7? Because nowadays new installes are with MariaDB 10.4 if I'm not mistaken.

tristan said:
just noticed CB did stop MySQL
Click to expand...
I'm a little bit tired on the eyes (just been gaming) but I dont'see any stopping Mysql in your log output. I presume that was done before?
 
Richard G said:
Just another question. How do you get a fresh auto install with mysql 5.7? Because nowadays new installes are with MariaDB 10.4 if I'm not mistaken.
Click to expand...
It's still MySQL by default, their reasoning is it's possible to migrate from MySQL to MariaDB but not as easy the other way around.

Richard G said:
I'm a little bit tired on the eyes (just been gaming) but I dont'see any stopping Mysql in your log output. I presume that was done before?
Click to expand...
Code: 
mv: 'mariadb-10.2.37-linux-glibc_214-x86_64.tar.gz' and '/usr/local/mariadb-10.2.37-linux-glibc_214-x86_64.tar.gz' are the same file
Stopping mysqld ...
Linking /usr/local/mysql/bin/aria_chk -> /usr/local/bin/aria_chk...
 
tristan said:
It's still MySQL by default, their reasoning is it's possible to migrate from MySQL to MariaDB but not as easy the other way around.
Click to expand...
Oke, hmm.... I might have a memory leak then, I thought I didn't fill in anything in february during our latest install and it automatically installed MariaDB, but I'm not sure anymore. Maybe I did have choice between Mysql and Mariadb.

Ahyeah there is is... stopping mysqld... I knew it must be in there, just didn't see it. :)
 
You must log in or register to reply here.
Back
Top