Script started on Sat Jun 5 10:50:51 2021 ]0;mysql@t2-bitsx-db304:~[?1034h]2;mysql@ Acceptance Environment !!!mysql@:~$ source ~/.bash_profile ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ mysqld_  --verbose --version mysqld Ver 10.4.12-MariaDB-log for Linux on x86_64 (Source distribution) 2021-06-05 10:51:22 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1_10.4.12/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:22 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1_10.4.12/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:22 0 [Note] Plugin 'FEEDBACK' is disabled. ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ mysqld_safe --defaults-file=/etc/my.cnf & [1] 28208 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ 210605 10:51:42 mysqld_safe Logging to '/opt/maria10.1/log/alert_TMBITX30.log'. 210605 10:51:42 mysqld_safe Starting mysqld daemon with databases from /opt/maria10.1/data/db ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ cat /opt/maria10.1/log/alert_TMBITX30.log 2021-06-05 10:46:02 140567540861120 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Uses event mutexes 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Compressed tables use zlib 1.2.3 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Number of pools: 1 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:46:03 140559221229312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Highest supported file format is Barracuda. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 5.7.21 started; log sequence number 1036344014318 2021-06-05 10:46:06 140559566923520 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:46:06 140567540861120 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:46:06 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:46:06 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 210605 10:46:06 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:46:06 140567540861120 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:46:06 140567540861120 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:46:06 140567540861120 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:46:08 140559566923520 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:46:08 2021-06-05 10:46:51 140559526283008 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:48:10 140559526889216 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:48:10 140559526889216 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:48:10 140559583708928 [Note] InnoDB: FTS optimize thread exiting. 2021-06-05 10:48:11 140559526889216 [Note] unregister_replicator OK 210605 10:48:10 server_audit: STOPPED 2021-06-05 10:48:11 140559526889216 [Note] InnoDB: Starting shutdown... 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:48:11 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Shutdown completed; log sequence number 1036344014362 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:48:12 140559526889216 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019 2021-06-05 10:51:43 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:51:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:51:43 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:51:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:51:43 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:51:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:51:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:51:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:51:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:51:44 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:51:46 0 [Note] InnoDB: Upgrading redo log: 2*1073741824 bytes; LSN=1036344015507 2021-06-05 10:51:46 0 [Note] InnoDB: Starting to delete and rewrite log files. 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-06-05 10:51:46 0 [Note] InnoDB: New log files created, LSN=1036344015507 2021-06-05 10:51:47 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:51:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:51:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:51:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:51:47 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:51:47 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344015507; transaction id 469502467 2021-06-05 10:51:47 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:51:47 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:51:47 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:51:47 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:51:47 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:51:47 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU 2021-06-05 10:51:47 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2021-06-05 10:51:47 0 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:51:47 0 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.4.12-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:51:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:51:50 2021-06-05 10:51:51 6 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ mysql_upgrade --defaults-file=/etc/my.cnf -r uroot -p Enter password: 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.gtid_slave_pos OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host 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.user OK Phase 2/7: Installing used storage engines... Skipped Phase 3/7: Fixing views sakila.actor_info OK sakila.customer_list OK sakila.film_list Error : 'sakila.film.title' isn't in GROUP BY error : Corrupt sakila.nicer_but_slower_film_list Error : 'sakila.film.title' isn't in GROUP BY error : Corrupt sakila.sales_by_film_category OK sakila.sales_by_store Error : 'sakila.c.city' isn't in GROUP BY error : Corrupt sakila.staff_list OK sys.host_summary Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.host_summary_by_file_io Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.host_summary_by_file_io_type Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.host_summary_by_stages Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.host_summary_by_statement_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.host_summary_by_statement_type Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.innodb_buffer_stats_by_schema Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.innodb_buffer_stats_by_table Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.innodb_lock_waits Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.io_by_thread_by_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.io_global_by_file_by_bytes Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.io_global_by_file_by_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.io_global_by_wait_by_bytes Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.io_global_by_wait_by_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.latest_file_io Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.metrics OK sys.processlist Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.ps_check_lost_instrumentation OK sys.schema_auto_increment_columns OK sys.schema_health_check OK sys.schema_index_check OK sys.schema_index_statistics Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.schema_lock_mdl_info OK sys.schema_object_all OK sys.schema_object_overview OK sys.schema_redundant_indexes OK sys.schema_table_statistics Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.schema_table_statistics_with_buffer Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.schema_tables_with_full_table_scans Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.schema_unused_indexes OK sys.session Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.statement_analysis Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.statements_with_errors_or_warnings Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.statements_with_full_table_scans Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.statements_with_runtimes_in_95th_percentile Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.statements_with_sorting Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.statements_with_temp_tables Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.user_role_privileges OK sys.user_summary Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.user_summary_by_file_io Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.user_summary_by_file_io_type Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.user_summary_by_stages Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.user_summary_by_statement_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.user_summary_by_statement_type Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.version OK sys.wait_classes_global_by_avg_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.wait_classes_global_by_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.waits_by_host_by_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.waits_by_user_by_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.waits_global_by_latency Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt 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$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 Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.x$schema_flattened_keys OK sys.x$schema_index_statistics OK sys.x$schema_table_statistics Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt sys.x$schema_table_statistics_with_buffer Error : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error error : Corrupt 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' Phase 5/7: Fixing table and database names Phase 6/7: Checking and upgrading tables Processing databases information_schema jnxdba jnxdba.auditlog OK jnxdba.l1_parameters OK jnxdba.lepus_service_alerts OK jnxdba.lepus_service_alerts_pending OK jnxdba.lepus_service_master OK jnxdba.table_size_stat OK performance_schema sakila sakila.actor OK sakila.address OK sakila.category OK sakila.city OK sakila.country OK sakila.customer OK sakila.film OK sakila.film_actor OK sakila.film_category OK sakila.film_text OK sakila.inventory OK sakila.language OK sakila.payment OK sakila.rental OK sakila.staff OK sakila.store OK sbtest sbtest.jjtest OK sbtest.ray OK sbtest.t0119 OK sbtest.t0119_2 OK sbtest.t0119_3 OK sbtest.t0120_1 OK sbtest.t0120_10 OK sbtest.t0120_11 OK sbtest.t0120_12 OK sbtest.t0120_13 OK sbtest.t0120_14 OK sbtest.t0120_15 OK sbtest.t0120_16 OK sbtest.t0120_17 OK sbtest.t0120_18 OK sbtest.t0120_19 OK sbtest.t0120_2 OK sbtest.t0120_20 OK sbtest.t0120_21 OK sbtest.t0120_3 OK sbtest.t0120_4 OK sbtest.t0120_5 OK sbtest.t0120_6 OK sbtest.t0120_7 OK sbtest.t0120_8 OK sbtest.t0120_9 OK sbtest.t0121_1 OK sbtest.t0121_2 OK sbtest.t0125 OK sbtest.t0907 OK sbtest.t1230 OK sbtest.t_datatype OK sbtest.t_datetime OK sbtest.t_timezone OK sbtest.t_tmp1 OK sbtest.test OK sbtest.test_kewei OK sbtest.test_table OK sbtest.test_table2 OK sbtest.tk0424 OK sbtest.tk0425 OK sys sys.sys_config OK Phase 7/7: Running 'FLUSH PRIVILEGES' OK ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ myq sql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 Server version: 5.5.5-10.4.12-MariaDB-log Source distribution Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. (root@localhost) [(none)] 10:52:39> select verion(); +---------------------+ | version() | +---------------------+ | 10.4.12-MariaDB-log | +---------------------+ 1 row in set (0.00 sec) (root@localhost) [(none)] 10:52:51> shutdown; Query OK, 0 rows affected (0.00 sec) (root@localhost) [(none)] 10:53:02> quit Bye ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ ]0;mysql@t2-bitsx-db304:~[1]+ Done mysqld_safe --defaults-file=/etc/my.cnf ]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ cat /opt/maria10.1/log/alert_TMBITX30.log 2021-06-05 10:46:02 140567540861120 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Uses event mutexes 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Compressed tables use zlib 1.2.3 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Number of pools: 1 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:46:03 140559221229312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Highest supported file format is Barracuda. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 5.7.21 started; log sequence number 1036344014318 2021-06-05 10:46:06 140559566923520 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:46:06 140567540861120 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:46:06 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:46:06 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 210605 10:46:06 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:46:06 140567540861120 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:46:06 140567540861120 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:46:06 140567540861120 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:46:08 140559566923520 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:46:08 2021-06-05 10:46:51 140559526283008 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:48:10 140559526889216 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:48:10 140559526889216 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:48:10 140559583708928 [Note] InnoDB: FTS optimize thread exiting. 2021-06-05 10:48:11 140559526889216 [Note] unregister_replicator OK 210605 10:48:10 server_audit: STOPPED 2021-06-05 10:48:11 140559526889216 [Note] InnoDB: Starting shutdown... 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:48:11 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Shutdown completed; log sequence number 1036344014362 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:48:12 140559526889216 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019 2021-06-05 10:51:43 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:51:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:51:43 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:51:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:51:43 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:51:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:51:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:51:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:51:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:51:44 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:51:46 0 [Note] InnoDB: Upgrading redo log: 2*1073741824 bytes; LSN=1036344015507 2021-06-05 10:51:46 0 [Note] InnoDB: Starting to delete and rewrite log files. 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-06-05 10:51:46 0 [Note] InnoDB: New log files created, LSN=1036344015507 2021-06-05 10:51:47 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:51:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:51:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:51:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:51:47 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:51:47 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344015507; transaction id 469502467 2021-06-05 10:51:47 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:51:47 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:51:47 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:51:47 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:51:47 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:51:47 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU 2021-06-05 10:51:47 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2021-06-05 10:51:47 0 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:51:47 0 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.4.12-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:51:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:51:50 2021-06-05 10:51:51 6 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:53:02 0 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:53:02 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:53:02 0 [Note] InnoDB: FTS optimize thread exiting. 210605 10:53:02 server_audit: STOPPED 2021-06-05 10:53:02 0 [Note] InnoDB: Starting shutdown... 2021-06-05 10:53:02 0 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:53:02 2021-06-05 10:53:04 0 [Note] InnoDB: Shutdown completed; log sequence number 1036344109477; transaction id 469502564 2021-06-05 10:53:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:53:04 0 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ cat /opt/maria10.1/log/alert_TMBITX30.logmysql -uroot -p[36@_upgrade --defaults-file=/etc/my.cnf -uroot -pcat /opt/maria10.1/log/alert_TMBITX30.logmysql_upgrade --defaults-file=/etc/my.cnf -uroot -p -uroot -p[36@_upgrade --defaults-file=/etc/my.cnf -uroot -pcat /opt/maria10.1/log/alert_TMBITX30.logmysqld_safe --defaults-file=/etc/my.cnf & --verbose --version_safe --defaults-file=/etc/my.cnf & [1] 28835 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ 210605 10:53:44 mysqld_safe Logging to '/opt/maria10.1/log/alert_TMBITX30.log'. 210605 10:53:44 mysqld_safe Starting mysqld daemon with databases from /opt/maria10.1/data/db ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ cat /opt/maria10.1/log/alert_TMBITX30.log 2021-06-05 10:46:02 140567540861120 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Uses event mutexes 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Compressed tables use zlib 1.2.3 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Number of pools: 1 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:46:03 140559221229312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Highest supported file format is Barracuda. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 5.7.21 started; log sequence number 1036344014318 2021-06-05 10:46:06 140559566923520 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:46:06 140567540861120 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:46:06 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:46:06 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 210605 10:46:06 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:46:06 140567540861120 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:46:06 140567540861120 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:46:06 140567540861120 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:46:08 140559566923520 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:46:08 2021-06-05 10:46:51 140559526283008 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:48:10 140559526889216 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:48:10 140559526889216 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:48:10 140559583708928 [Note] InnoDB: FTS optimize thread exiting. 2021-06-05 10:48:11 140559526889216 [Note] unregister_replicator OK 210605 10:48:10 server_audit: STOPPED 2021-06-05 10:48:11 140559526889216 [Note] InnoDB: Starting shutdown... 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:48:11 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Shutdown completed; log sequence number 1036344014362 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:48:12 140559526889216 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019 2021-06-05 10:51:43 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:51:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:51:43 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:51:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:51:43 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:51:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:51:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:51:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:51:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:51:44 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:51:46 0 [Note] InnoDB: Upgrading redo log: 2*1073741824 bytes; LSN=1036344015507 2021-06-05 10:51:46 0 [Note] InnoDB: Starting to delete and rewrite log files. 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-06-05 10:51:46 0 [Note] InnoDB: New log files created, LSN=1036344015507 2021-06-05 10:51:47 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:51:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:51:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:51:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:51:47 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:51:47 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344015507; transaction id 469502467 2021-06-05 10:51:47 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:51:47 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:51:47 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:51:47 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:51:47 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:51:47 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU 2021-06-05 10:51:47 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2021-06-05 10:51:47 0 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:51:47 0 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.4.12-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:51:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:51:50 2021-06-05 10:51:51 6 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:53:02 0 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:53:02 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:53:02 0 [Note] InnoDB: FTS optimize thread exiting. 210605 10:53:02 server_audit: STOPPED 2021-06-05 10:53:02 0 [Note] InnoDB: Starting shutdown... 2021-06-05 10:53:02 0 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:53:02 2021-06-05 10:53:04 0 [Note] InnoDB: Shutdown completed; log sequence number 1036344109477; transaction id 469502564 2021-06-05 10:53:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:53:04 0 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:53:45 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:53:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:53:45 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:53:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:53:45 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:53:45 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:53:45 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:53:46 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:53:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:53:46 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:53:49 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:53:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:53:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:53:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:53:49 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:53:49 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344109477; transaction id 469502516 2021-06-05 10:53:49 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:49 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:53:49 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:53:49 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:53:49 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:53:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:53:52 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ cat /opt/maria10.1/log/alert_TMBITX30.log 2021-06-05 10:46:02 140567540861120 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Uses event mutexes 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Compressed tables use zlib 1.2.3 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Number of pools: 1 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:46:03 140559221229312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Highest supported file format is Barracuda. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 5.7.21 started; log sequence number 1036344014318 2021-06-05 10:46:06 140559566923520 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:46:06 140567540861120 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:46:06 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:46:06 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 210605 10:46:06 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:46:06 140567540861120 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:46:06 140567540861120 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:46:06 140567540861120 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:46:08 140559566923520 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:46:08 2021-06-05 10:46:51 140559526283008 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:48:10 140559526889216 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:48:10 140559526889216 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:48:10 140559583708928 [Note] InnoDB: FTS optimize thread exiting. 2021-06-05 10:48:11 140559526889216 [Note] unregister_replicator OK 210605 10:48:10 server_audit: STOPPED 2021-06-05 10:48:11 140559526889216 [Note] InnoDB: Starting shutdown... 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:48:11 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Shutdown completed; log sequence number 1036344014362 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:48:12 140559526889216 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019 2021-06-05 10:51:43 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:51:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:51:43 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:51:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:51:43 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:51:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:51:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:51:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:51:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:51:44 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:51:46 0 [Note] InnoDB: Upgrading redo log: 2*1073741824 bytes; LSN=1036344015507 2021-06-05 10:51:46 0 [Note] InnoDB: Starting to delete and rewrite log files. 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-06-05 10:51:46 0 [Note] InnoDB: New log files created, LSN=1036344015507 2021-06-05 10:51:47 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:51:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:51:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:51:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:51:47 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:51:47 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344015507; transaction id 469502467 2021-06-05 10:51:47 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:51:47 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:51:47 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:51:47 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:51:47 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:51:47 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU 2021-06-05 10:51:47 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2021-06-05 10:51:47 0 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:51:47 0 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.4.12-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:51:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:51:50 2021-06-05 10:51:51 6 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:53:02 0 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:53:02 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:53:02 0 [Note] InnoDB: FTS optimize thread exiting. 210605 10:53:02 server_audit: STOPPED 2021-06-05 10:53:02 0 [Note] InnoDB: Starting shutdown... 2021-06-05 10:53:02 0 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:53:02 2021-06-05 10:53:04 0 [Note] InnoDB: Shutdown completed; log sequence number 1036344109477; transaction id 469502564 2021-06-05 10:53:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:53:04 0 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:53:45 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:53:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:53:45 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:53:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:53:45 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:53:45 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:53:45 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:53:46 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:53:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:53:46 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:53:49 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:53:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:53:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:53:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:53:49 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:53:49 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344109477; transaction id 469502516 2021-06-05 10:53:49 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:49 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:53:49 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:53:49 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:53:49 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:53:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:53:52 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 4 On-line CPU(s) list: 0-3 Thread(s) per core: 1 Core(s) per socket: 1 Socket(s): 4 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family: 6 Model: 42 Model name: Intel Xeon E312xx (Sandy Bridge) Stepping: 1 CPU MHz: 2299.996 BogoMIPS: 4599.99 Hypervisor vendor: KVM Virtualization type: full L1d cache: 32K L1i cache: 32K L2 cache: 4096K L3 cache: 16384K NUMA node0 CPU(s): 0-3 Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx rdtscp lm constant_tsc rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx hypervisor lahf_lm xsaveopt arat ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ lsb-re   _release -a LSB Version: :core-4.1-amd64:core-4.1-noarch Distributor ID: CentOS Description: CentOS Linux release 7.4.1708 (Core) Release: 7.4.1708 Codename: Core ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ lsb_release -acpucat /opt/maria10.1/log/alert_TMBITX30.log 2021-06-05 10:46:02 140567540861120 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Uses event mutexes 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Compressed tables use zlib 1.2.3 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Number of pools: 1 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:46:03 140559221229312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Highest supported file format is Barracuda. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 5.7.21 started; log sequence number 1036344014318 2021-06-05 10:46:06 140559566923520 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:46:06 140567540861120 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:46:06 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:46:06 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 210605 10:46:06 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:46:06 140567540861120 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:46:06 140567540861120 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:46:06 140567540861120 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:46:08 140559566923520 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:46:08 2021-06-05 10:46:51 140559526283008 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:48:10 140559526889216 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:48:10 140559526889216 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:48:10 140559583708928 [Note] InnoDB: FTS optimize thread exiting. 2021-06-05 10:48:11 140559526889216 [Note] unregister_replicator OK 210605 10:48:10 server_audit: STOPPED 2021-06-05 10:48:11 140559526889216 [Note] InnoDB: Starting shutdown... 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:48:11 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Shutdown completed; log sequence number 1036344014362 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:48:12 140559526889216 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019 2021-06-05 10:51:43 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:51:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:51:43 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:51:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:51:43 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:51:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:51:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:51:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:51:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:51:44 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:51:46 0 [Note] InnoDB: Upgrading redo log: 2*1073741824 bytes; LSN=1036344015507 2021-06-05 10:51:46 0 [Note] InnoDB: Starting to delete and rewrite log files. 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-06-05 10:51:46 0 [Note] InnoDB: New log files created, LSN=1036344015507 2021-06-05 10:51:47 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:51:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:51:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:51:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:51:47 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:51:47 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344015507; transaction id 469502467 2021-06-05 10:51:47 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:51:47 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:51:47 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:51:47 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:51:47 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:51:47 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU 2021-06-05 10:51:47 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2021-06-05 10:51:47 0 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:51:47 0 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.4.12-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:51:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:51:50 2021-06-05 10:51:51 6 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:53:02 0 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:53:02 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:53:02 0 [Note] InnoDB: FTS optimize thread exiting. 210605 10:53:02 server_audit: STOPPED 2021-06-05 10:53:02 0 [Note] InnoDB: Starting shutdown... 2021-06-05 10:53:02 0 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:53:02 2021-06-05 10:53:04 0 [Note] InnoDB: Shutdown completed; log sequence number 1036344109477; transaction id 469502564 2021-06-05 10:53:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:53:04 0 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:53:45 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:53:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:53:45 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:53:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:53:45 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:53:45 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:53:45 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:53:46 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:53:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:53:46 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:53:49 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:53:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:53:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:53:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:53:49 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:53:49 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344109477; transaction id 469502516 2021-06-05 10:53:49 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:49 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:53:49 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:53:49 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:53:49 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:53:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:53:52 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ date Sat Jun 5 10:54:40 JST 2021 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ date Sat Jun 5 10:57:57 JST 2021 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ cat /opt/maria10.1/log/alert_TMBITX30.log 2021-06-05 10:46:02 140567540861120 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Uses event mutexes 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Compressed tables use zlib 1.2.3 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Number of pools: 1 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:46:03 140559221229312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Highest supported file format is Barracuda. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 5.7.21 started; log sequence number 1036344014318 2021-06-05 10:46:06 140559566923520 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:46:06 140567540861120 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:46:06 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:46:06 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 210605 10:46:06 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:46:06 140567540861120 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:46:06 140567540861120 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:46:06 140567540861120 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:46:08 140559566923520 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:46:08 2021-06-05 10:46:51 140559526283008 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:48:10 140559526889216 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:48:10 140559526889216 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:48:10 140559583708928 [Note] InnoDB: FTS optimize thread exiting. 2021-06-05 10:48:11 140559526889216 [Note] unregister_replicator OK 210605 10:48:10 server_audit: STOPPED 2021-06-05 10:48:11 140559526889216 [Note] InnoDB: Starting shutdown... 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:48:11 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Shutdown completed; log sequence number 1036344014362 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:48:12 140559526889216 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019 2021-06-05 10:51:43 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:51:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:51:43 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:51:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:51:43 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:51:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:51:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:51:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:51:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:51:44 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:51:46 0 [Note] InnoDB: Upgrading redo log: 2*1073741824 bytes; LSN=1036344015507 2021-06-05 10:51:46 0 [Note] InnoDB: Starting to delete and rewrite log files. 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-06-05 10:51:46 0 [Note] InnoDB: New log files created, LSN=1036344015507 2021-06-05 10:51:47 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:51:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:51:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:51:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:51:47 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:51:47 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344015507; transaction id 469502467 2021-06-05 10:51:47 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:51:47 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:51:47 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:51:47 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:51:47 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:51:47 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU 2021-06-05 10:51:47 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2021-06-05 10:51:47 0 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:51:47 0 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.4.12-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:51:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:51:50 2021-06-05 10:51:51 6 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:53:02 0 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:53:02 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:53:02 0 [Note] InnoDB: FTS optimize thread exiting. 210605 10:53:02 server_audit: STOPPED 2021-06-05 10:53:02 0 [Note] InnoDB: Starting shutdown... 2021-06-05 10:53:02 0 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:53:02 2021-06-05 10:53:04 0 [Note] InnoDB: Shutdown completed; log sequence number 1036344109477; transaction id 469502564 2021-06-05 10:53:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:53:04 0 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:53:45 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:53:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:53:45 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:53:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:53:45 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:53:45 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:53:45 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:53:46 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:53:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:53:46 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:53:49 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:53:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:53:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:53:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:53:49 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:53:49 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344109477; transaction id 469502516 2021-06-05 10:53:49 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:49 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:53:49 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:53:49 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:53:49 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:53:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:53:52 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ cat /opt/maria10.1/log/alert_TMBITX30.log 2021-06-05 10:46:02 140567540861120 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Uses event mutexes 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Compressed tables use zlib 1.2.3 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Number of pools: 1 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:46:03 140559221229312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Highest supported file format is Barracuda. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 5.7.21 started; log sequence number 1036344014318 2021-06-05 10:46:06 140559566923520 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:46:06 140567540861120 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:46:06 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:46:06 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 210605 10:46:06 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:46:06 140567540861120 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:46:06 140567540861120 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:46:06 140567540861120 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:46:08 140559566923520 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:46:08 2021-06-05 10:46:51 140559526283008 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:48:10 140559526889216 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:48:10 140559526889216 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:48:10 140559583708928 [Note] InnoDB: FTS optimize thread exiting. 2021-06-05 10:48:11 140559526889216 [Note] unregister_replicator OK 210605 10:48:10 server_audit: STOPPED 2021-06-05 10:48:11 140559526889216 [Note] InnoDB: Starting shutdown... 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:48:11 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Shutdown completed; log sequence number 1036344014362 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:48:12 140559526889216 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019 2021-06-05 10:51:43 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:51:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:51:43 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:51:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:51:43 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:51:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:51:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:51:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:51:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:51:44 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:51:46 0 [Note] InnoDB: Upgrading redo log: 2*1073741824 bytes; LSN=1036344015507 2021-06-05 10:51:46 0 [Note] InnoDB: Starting to delete and rewrite log files. 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-06-05 10:51:46 0 [Note] InnoDB: New log files created, LSN=1036344015507 2021-06-05 10:51:47 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:51:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:51:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:51:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:51:47 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:51:47 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344015507; transaction id 469502467 2021-06-05 10:51:47 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:51:47 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:51:47 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:51:47 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:51:47 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:51:47 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU 2021-06-05 10:51:47 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2021-06-05 10:51:47 0 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:51:47 0 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.4.12-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:51:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:51:50 2021-06-05 10:51:51 6 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:53:02 0 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:53:02 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:53:02 0 [Note] InnoDB: FTS optimize thread exiting. 210605 10:53:02 server_audit: STOPPED 2021-06-05 10:53:02 0 [Note] InnoDB: Starting shutdown... 2021-06-05 10:53:02 0 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:53:02 2021-06-05 10:53:04 0 [Note] InnoDB: Shutdown completed; log sequence number 1036344109477; transaction id 469502564 2021-06-05 10:53:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:53:04 0 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:53:45 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:53:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:53:45 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:53:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:53:45 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:53:45 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:53:45 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:53:46 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:53:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:53:46 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:53:49 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:53:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:53:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:53:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:53:49 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:53:49 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344109477; transaction id 469502516 2021-06-05 10:53:49 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:49 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:53:49 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:53:49 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:53:49 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:53:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:53:52 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ date Sat Jun 5 11:10:32 JST 2021 Script done, file is typescript ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ cat /opt/maria10.1/log/alert- _TMBITX30.log 2021-06-05 10:46:02 140567540861120 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Uses event mutexes 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Compressed tables use zlib 1.2.3 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Number of pools: 1 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:46:03 140559221229312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Highest supported file format is Barracuda. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 5.7.21 started; log sequence number 1036344014318 2021-06-05 10:46:06 140559566923520 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:46:06 140567540861120 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:46:06 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:46:06 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 210605 10:46:06 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:46:06 140567540861120 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:46:06 140567540861120 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:46:06 140567540861120 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:46:08 140559566923520 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:46:08 2021-06-05 10:46:51 140559526283008 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:48:10 140559526889216 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:48:10 140559526889216 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:48:10 140559583708928 [Note] InnoDB: FTS optimize thread exiting. 2021-06-05 10:48:11 140559526889216 [Note] unregister_replicator OK 210605 10:48:10 server_audit: STOPPED 2021-06-05 10:48:11 140559526889216 [Note] InnoDB: Starting shutdown... 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:48:11 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Shutdown completed; log sequence number 1036344014362 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:48:12 140559526889216 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019 2021-06-05 10:51:43 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:51:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:51:43 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:51:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:51:43 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:51:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:51:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:51:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:51:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:51:44 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:51:46 0 [Note] InnoDB: Upgrading redo log: 2*1073741824 bytes; LSN=1036344015507 2021-06-05 10:51:46 0 [Note] InnoDB: Starting to delete and rewrite log files. 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-06-05 10:51:46 0 [Note] InnoDB: New log files created, LSN=1036344015507 2021-06-05 10:51:47 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:51:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:51:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:51:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:51:47 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:51:47 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344015507; transaction id 469502467 2021-06-05 10:51:47 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:51:47 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:51:47 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:51:47 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:51:47 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:51:47 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU 2021-06-05 10:51:47 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2021-06-05 10:51:47 0 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:51:47 0 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.4.12-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:51:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:51:50 2021-06-05 10:51:51 6 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:53:02 0 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:53:02 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:53:02 0 [Note] InnoDB: FTS optimize thread exiting. 210605 10:53:02 server_audit: STOPPED 2021-06-05 10:53:02 0 [Note] InnoDB: Starting shutdown... 2021-06-05 10:53:02 0 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:53:02 2021-06-05 10:53:04 0 [Note] InnoDB: Shutdown completed; log sequence number 1036344109477; transaction id 469502564 2021-06-05 10:53:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:53:04 0 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:53:45 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:53:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:53:45 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:53:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:53:45 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:53:45 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:53:45 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:53:46 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:53:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:53:46 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:53:49 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:53:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:53:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:53:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:53:49 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:53:49 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344109477; transaction id 469502516 2021-06-05 10:53:49 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:49 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:53:49 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:53:49 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:53:49 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:53:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:53:52 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ date Sat Jun 5 11:16:57 JST 2021 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ cat /opt/maria10.1/log/alert_TMBITX30.log 2021-06-05 10:46:02 140567540861120 [Note] CONNECT: Version 1.06.0007 March 11, 2018 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Uses event mutexes 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Compressed tables use zlib 1.2.3 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Number of pools: 1 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:46:02 140567540861120 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:46:03 140559221229312 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:46:03 140567540861120 [Note] InnoDB: Highest supported file format is Barracuda. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:46:06 140567540861120 [Note] InnoDB: 5.7.21 started; log sequence number 1036344014318 2021-06-05 10:46:06 140559566923520 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:46:06 140567540861120 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:46:06 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:46:06 server_audit: MariaDB Audit Plugin version 1.4.3 STARTED. 210605 10:46:06 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:46:06 140567540861120 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:46:06 140567540861120 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:46:06 140567540861120 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.2.14-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:46:08 140559566923520 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:46:08 2021-06-05 10:46:51 140559526283008 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:48:10 140559526889216 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:48:10 140559526889216 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:48:10 140559583708928 [Note] InnoDB: FTS optimize thread exiting. 2021-06-05 10:48:11 140559526889216 [Note] unregister_replicator OK 210605 10:48:10 server_audit: STOPPED 2021-06-05 10:48:11 140559526889216 [Note] InnoDB: Starting shutdown... 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:48:11 140559566923520 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:48:11 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Shutdown completed; log sequence number 1036344014362 2021-06-05 10:48:12 140559526889216 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:48:12 140559526889216 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_master.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [ERROR] mysqld: Can't open shared library '/opt/maria10.1/lib/plugin/semisync_slave.so' (errno: 0, cannot open shared object file: No such file or directory) 2021-06-05 10:51:43 0 [Note] CONNECT: Version 1.07.0001 November 12, 2019 2021-06-05 10:51:43 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:51:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:51:43 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:51:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:51:43 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:51:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:51:43 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:51:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:51:44 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:51:44 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:51:46 0 [Note] InnoDB: Upgrading redo log: 2*1073741824 bytes; LSN=1036344015507 2021-06-05 10:51:46 0 [Note] InnoDB: Starting to delete and rewrite log files. 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1073741824 bytes 2021-06-05 10:51:46 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-06-05 10:51:46 0 [Note] InnoDB: New log files created, LSN=1036344015507 2021-06-05 10:51:47 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:51:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:51:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:51:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:51:47 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:51:47 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344015507; transaction id 469502467 2021-06-05 10:51:47 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:51:47 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:51:47 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:51:47 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:51:47 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 3 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:51:47 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-05 10:51:47 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALU 2021-06-05 10:51:47 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2021-06-05 10:51:47 0 [Warning] Recovery from master pos 403 and file BINLOG.007450. 2021-06-05 10:51:47 0 [Note] /opt/maria10.1/bin/mysqld: ready for connections. Version: '10.4.12-MariaDB-log' socket: '/opt/maria10.1/data/mysql.sock' port: 3306 Source distribution 2021-06-05 10:51:50 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:51:50 2021-06-05 10:51:51 6 [Warning] IP address '10.172.89.39' could not be resolved: Name or service not known 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:19 13 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100214, now running 100412. Please use mysql_upgrade to fix this error 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:52:21 14 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2021-06-05 10:53:02 0 [Note] /opt/maria10.1/bin/mysqld (initiated by: root[root] @ localhost []): Normal shutdown 2021-06-05 10:53:02 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-06-05 10:53:02 0 [Note] InnoDB: FTS optimize thread exiting. 210605 10:53:02 server_audit: STOPPED 2021-06-05 10:53:02 0 [Note] InnoDB: Starting shutdown... 2021-06-05 10:53:02 0 [Note] InnoDB: Dumping buffer pool(s) to /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 210605 10:53:02 2021-06-05 10:53:04 0 [Note] InnoDB: Shutdown completed; log sequence number 1036344109477; transaction id 469502564 2021-06-05 10:53:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-05 10:53:04 0 [Note] /opt/maria10.1/bin/mysqld: Shutdown complete 2021-06-05 10:53:45 0 [Note] InnoDB: Using Linux native AIO 2021-06-05 10:53:45 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-06-05 10:53:45 0 [Note] InnoDB: Uses event mutexes 2021-06-05 10:53:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-05 10:53:45 0 [Note] InnoDB: Number of pools: 1 2021-06-05 10:53:45 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-05 10:53:45 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 2, chunk size = 128M 2021-06-05 10:53:46 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-05 10:53:46 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-06-05 10:53:46 0 [Note] InnoDB: Opened 4 undo tablespaces 2021-06-05 10:53:49 0 [Note] InnoDB: 128 out of 128 rollback segments in 4 undo tablespaces are active. 2021-06-05 10:53:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-05 10:53:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-05 10:53:49 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-06-05 10:53:49 0 [Note] InnoDB: Waiting for purge to start 2021-06-05 10:53:49 0 [Note] InnoDB: 10.4.12 started; log sequence number 1036344109477; transaction id 469502516 2021-06-05 10:53:49 0 [Note] InnoDB: Loading buffer pool(s) from /TMBITX30/datadg/db.bak20210602/ib_buffer_pool 2021-06-05 10:53:49 0 [Note] Plugin 'FEEDBACK' is disabled. 210605 10:53:49 server_audit: server_audit_excl_users set to 'event_scheduler'. 210605 10:53:49 server_audit: MariaDB Audit Plugin version 1.4.8 STARTED. 210605 10:53:49 server_audit: logging started to the file /opt/maria10.1/log/server_audit.log. 2021-06-05 10:53:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210605 10:53:52 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ date Sun Jun 6 20:29:33 JST 2021 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ lsof -i:3306 ]0;mysql@t2-bitsx-db304:~]2;mysql@t2-bitsx-db304 Acceptance Environment !!!mysql@t2-bitsx-db304:~$ exit exit Script done on Sun Jun 6 20:29:44 2021