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