|
greatsql的docker版本8.0.32-25，操作系统是麒麟V10，目前情况是docker无法正常运行，不停的重启，错误日志如下 2024-08-28T11:55:00.977569+08:00 79773 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T11:55:00.977797+08:00 79773 [Note] [MY-010914] [Server] Aborted connection 79773 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T12:00:32.266620+08:00 79777 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T12:00:32.266794+08:00 79777 [Note] [MY-010914] [Server] Aborted connection 79777 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T12:00:33.782983+08:00 79617 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T12:00:33.783214+08:00 79617 [Note] [MY-010914] [Server] Aborted connection 79617 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T12:00:38.130782+08:00 79784 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T12:00:38.130892+08:00 79784 [Note] [MY-010914] [Server] Aborted connection 79784 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T12:13:43.517515+08:00 79795 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T12:13:43.517664+08:00 79795 [Note] [MY-010914] [Server] Aborted connection 79795 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T12:25:00.839317+08:00 79727 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T12:25:00.839476+08:00 79727 [Note] [MY-010914] [Server] Aborted connection 79727 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T12:44:24.357698+08:00 79837 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T12:44:24.357898+08:00 79837 [Note] [MY-010914] [Server] Aborted connection 79837 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T12:49:58.053199+08:00 79778 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T12:49:58.053363+08:00 79778 [Note] [MY-010914] [Server] Aborted connection 79778 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T12:55:00.709415+08:00 79857 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T12:55:00.709566+08:00 79857 [Note] [MY-010914] [Server] Aborted connection 79857 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T13:10:01.140931+08:00 79876 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T13:10:01.141116+08:00 79876 [Note] [MY-010914] [Server] Aborted connection 79876 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T13:17:16.582473+08:00 79867 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T13:17:16.582685+08:00 79867 [Note] [MY-010914] [Server] Aborted connection 79867 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T13:25:00.119160+08:00 79897 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T13:25:00.119301+08:00 79897 [Note] [MY-010914] [Server] Aborted connection 79897 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T13:30:51.185974+08:00 79902 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T13:30:51.186142+08:00 79902 [Note] [MY-010914] [Server] Aborted connection 79902 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T13:41:27.035603+08:00 79917 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T13:41:27.035759+08:00 79917 [Note] [MY-010914] [Server] Aborted connection 79917 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted 2024-08-28T13:47:48.273419+08:00 79932 [Note] [MY-010914] [Server] Aborted connection 79932 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (Got an error reading communication packets). 2024-08-28T13:47:48.273401+08:00 79945 [Note] [MY-010914] [Server] Aborted connection 79945 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (Got an error reading communication packets). mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted 2024-08-28T13:52:02.108544+08:00 79760 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T13:52:02.108735+08:00 79760 [Note] [MY-010914] [Server] Aborted connection 79760 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted 2024-08-28T13:55:00.423754+08:00 79918 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T13:55:00.423886+08:00 79918 [Note] [MY-010914] [Server] Aborted connection 79918 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T13:55:35.772730+08:00 79846 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T13:55:35.772918+08:00 79846 [Note] [MY-010914] [Server] Aborted connection 79846 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted 2024-08-28T14:06:55.220666+08:00 79939 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T14:06:55.220842+08:00 79939 [Note] [MY-010914] [Server] Aborted connection 79939 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted 2024-08-28T14:10:00.117026+08:00 80104 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T14:10:00.117207+08:00 80104 [Note] [MY-010914] [Server] Aborted connection 80104 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T14:11:17.397739+08:00 80107 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T14:11:17.397925+08:00 80107 [Note] [MY-010914] [Server] Aborted connection 80107 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted 2024-08-28T14:36:06.366288+08:00 80138 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T14:36:06.366466+08:00 80138 [Note] [MY-010914] [Server] Aborted connection 80138 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted 2024-08-28T14:43:55.517251+08:00 80155 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T14:43:55.517384+08:00 80155 [Note] [MY-010914] [Server] Aborted connection 80155 to db: 'oscape_db' user: 'root' host: '172.17.1.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted 2024-08-28T14:55:01.031954+08:00 80124 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T14:55:01.032169+08:00 80124 [Note] [MY-010914] [Server] Aborted connection 80124 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T14:55:55.201022+08:00 80184 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T14:55:55.201153+08:00 80184 [Note] [MY-010914] [Server] Aborted connection 80184 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted 2024-08-28T15:04:24.747900+08:00 80193 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:04:24.748024+08:00 80193 [Note] [MY-010914] [Server] Aborted connection 80193 to db: 'oscape_db' user: 'root' host: '172.17.1.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T15:04:52.316723+08:00 80196 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:04:52.316889+08:00 80196 [Note] [MY-010914] [Server] Aborted connection 80196 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T15:07:40.508518+08:00 80175 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:07:40.508752+08:00 80175 [Note] [MY-010914] [Server] Aborted connection 80175 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T15:10:00.437887+08:00 80208 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:10:00.438011+08:00 80208 [Note] [MY-010914] [Server] Aborted connection 80208 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted 2024-08-28T15:24:00.860033+08:00 80219 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:24:00.860186+08:00 80219 [Note] [MY-010914] [Server] Aborted connection 80219 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted 2024-08-28T15:27:07.420355+08:00 80209 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:27:07.420594+08:00 80209 [Note] [MY-010914] [Server] Aborted connection 80209 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted 2024-08-28T15:37:26.903680+08:00 80195 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:37:26.903858+08:00 80195 [Note] [MY-010914] [Server] Aborted connection 80195 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T15:38:23.335044+08:00 80243 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:38:23.335240+08:00 80243 [Note] [MY-010914] [Server] Aborted connection 80243 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). 2024-08-28T15:40:00.311432+08:00 80226 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:40:00.311669+08:00 80226 [Note] [MY-010914] [Server] Aborted connection 80226 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted mbind: Operation not permitted 2024-08-28T15:49:08.405126+08:00 80200 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:49:08.405291+08:00 80200 [Note] [MY-010914] [Server] Aborted connection 80200 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted 2024-08-28T15:55:00.658739+08:00 80250 [Note] [MY-013730] [Server] 'wait_timeout' period of 600 seconds was exceeded for `root`@`%`. The idle time since last command was too long. 2024-08-28T15:55:00.658906+08:00 80250 [Note] [MY-010914] [Server] Aborted connection 80250 to db: 'oscape_db' user: 'root' host: '127.0.0.1' (The client was disconnected by the server because of inactivity.). mbind: Operation not permitted 2024-08-28T16:04:21.245583+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead. 2024-08-28T16:04:21.245636+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead. 2024-08-28T16:04:21.245645+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release. 2024-08-28T16:04:21.245657+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead. 2024-08-28T16:04:21.245671+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead. 2024-08-28T16:04:21.245682+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead. 2024-08-28T16:04:21.245804+08:00 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-08-28T16:04:21.246353+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2024-08-28T16:04:21.246427+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=bc39de400860a943996e7b04e4952d1d68b3ff6d 2024-08-28T16:04:21.246436+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/. 2024-08-28T16:04:21.246450+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32-25) starting as process 1 2024-08-28T16:04:21.348386+08:00 0 [Warning] [MY-000081] [Server] option 'innodb-autoextend-increment': unsigned value 268435456 adjusted to 1000. 2024-08-28T16:04:21.349749+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2024-08-28T16:04:21.349795+08:00 0 [Note] [MY-012359] [InnoDB] Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2024-08-28T16:04:21.349822+08:00 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity instead. 2024-08-28T16:04:21.350173+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2024-08-28T16:04:21.350262+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled. 2024-08-28T16:04:21.350287+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled. 2024-08-28T16:04:21.350303+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled. 2024-08-28T16:04:21.352429+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-08-28T16:04:21.352480+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2024-08-28T16:04:21.352525+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2024-08-28T16:04:21.352545+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2024-08-28T16:04:21.352556+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2024-08-28T16:04:21.352567+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13 2024-08-28T16:04:21.353792+08:00 1 [Note] [MY-011066] [InnoDB] File purge : set file purge path : /data/GreatSQL/#file_purge 2024-08-28T16:04:21.353883+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication. 2024-08-28T16:04:21.354221+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2024-08-28T16:04:21.354287+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './' 2024-08-28T16:04:21.391572+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:04:21.391678+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:04:21.391694+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:04:21.391709+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:04:21.403632+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:04:21.403705+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:04:21.403742+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:04:21.403755+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:04:25.817319+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 611 files. 2024-08-28T16:04:25.818392+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 512.000000M, instances = 1, chunk size =128.000000M 2024-08-28T16:04:25.835996+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2024-08-28T16:04:25.839450+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority(). 2024-08-28T16:04:25.869871+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:04:25.869982+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:04:25.869999+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:04:25.870014+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:04:25.882000+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:04:25.882101+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:04:25.882114+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:04:25.882128+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:04:25.882511+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2024-08-28T16:04:25.901485+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2024-08-28T16:04:25.982880+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:04:25.982999+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:04:25.983015+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:04:25.983030+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:04:25.995026+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:04:25.995125+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:04:25.995139+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:04:25.995154+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:26.265758+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 50% 2024-08-28T16:28:26.269554+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 60% 2024-08-28T16:28:26.273344+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 70% 2024-08-28T16:28:26.276973+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 80% 2024-08-28T16:28:26.280719+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 90% 2024-08-28T16:28:26.284388+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 100% 2024-08-28T16:28:26.618828+08:00 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: os0file.cc:3036 thread 281458463010688 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/ ... nnodb-recovery.html InnoDB: about forcing recovery. 2024-08-28T08:28:26Z UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=bc39de400860a943996e7b04e4952d1d68b3ff6d Build ID: Not Available Server Version: 8.0.32-25 GreatSQL (GPL), Release 25, Revision 79f57097e3f Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x80000 /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x30) [0x1e9f240] /usr/sbin/mysqld(print_fatal_signal(int)+0x360) [0x1201dc0] /usr/sbin/mysqld(my_server_abort()+0x90) [0x1201fd0] /usr/sbin/mysqld(my_abort()+0x14) [0x1e992c4] /usr/sbin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x26c) [0x213bb1c] /usr/sbin/mysqld() [0x204fac0] /usr/sbin/mysqld(os_file_flush_func(int)+0xc) [0x205306c] /usr/sbin/mysqld(os_file_set_size(char const*, pfs_os_file_t, unsigned long, unsigned long, bool)+0x4dc) [0x205bbfc] /usr/sbin/mysqld(log_create_unused_file(Log_files_context const&, unsigned long, unsigned long)+0xfc) [0x201adcc] /usr/sbin/mysqld() [0x20173cc] /usr/sbin/mysqld(log_files_governor(log_t*)+0xa0) [0x2017610] /usr/sbin/mysqld(std::thread::_State_impl<std::thread::_Invoker<std::tuple<Detached_thread, void (*)(log_t*), log_t*> > >::_M_run()+0xd0) [0x201f1a0] /lib64/libstdc++.so.6(+0xbcd2c) [0xfffc745ecd2c] /lib64/libpthread.so.0(+0x7898) [0xfffc74bd7898] /lib64/libc.so.6(+0xd1ddc) [0xfffc74371ddc] Please help us make Percona Server better by reporting any bugs at https://bugs.percona.com/ You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of the crash. 2024-08-28T16:28:33.768760+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead. 2024-08-28T16:28:33.768807+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead. 2024-08-28T16:28:33.768816+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release. 2024-08-28T16:28:33.768827+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead. 2024-08-28T16:28:33.768839+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead. 2024-08-28T16:28:33.768849+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead. 2024-08-28T16:28:33.768966+08:00 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-08-28T16:28:33.769430+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2024-08-28T16:28:33.769489+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=bc39de400860a943996e7b04e4952d1d68b3ff6d 2024-08-28T16:28:33.769496+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/. 2024-08-28T16:28:33.769508+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32-25) starting as process 1 2024-08-28T16:28:33.793034+08:00 0 [Warning] [MY-000081] [Server] option 'innodb-autoextend-increment': unsigned value 268435456 adjusted to 1000. 2024-08-28T16:28:33.794283+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2024-08-28T16:28:33.794321+08:00 0 [Note] [MY-012359] [InnoDB] Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2024-08-28T16:28:33.794346+08:00 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity instead. 2024-08-28T16:28:33.794684+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2024-08-28T16:28:33.794770+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled. 2024-08-28T16:28:33.794794+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled. 2024-08-28T16:28:33.794810+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled. 2024-08-28T16:28:33.796511+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-08-28T16:28:33.796553+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2024-08-28T16:28:33.796587+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2024-08-28T16:28:33.796605+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2024-08-28T16:28:33.796615+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2024-08-28T16:28:33.796625+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13 2024-08-28T16:28:33.797810+08:00 1 [Note] [MY-011066] [InnoDB] File purge : set file purge path : /data/GreatSQL/#file_purge 2024-08-28T16:28:33.797892+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication. 2024-08-28T16:28:33.798205+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2024-08-28T16:28:33.798253+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './' 2024-08-28T16:28:33.829002+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:33.829037+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:33.829051+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:33.829062+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:33.841178+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:33.841198+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:33.841208+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:33.841218+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:33.851623+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 611 files. 2024-08-28T16:28:33.852332+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 512.000000M, instances = 1, chunk size =128.000000M 2024-08-28T16:28:33.872600+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2024-08-28T16:28:33.875613+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority(). 2024-08-28T16:28:33.900099+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:33.900139+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:33.900153+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:33.900166+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:33.912272+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:33.912292+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:33.912302+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:33.912313+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:33.912603+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2024-08-28T16:28:33.912774+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2024-08-28T16:28:33.941799+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:33.941846+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:33.941860+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:33.941872+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:33.954085+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:33.954108+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:33.954119+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:33.954130+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:33.954416+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2 2024-08-28T16:28:33.954432+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4 2024-08-28T16:28:33.954462+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2024-08-28T16:28:33.954485+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2024-08-28T16:28:34.024952+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 218832230493 in redo log file ./#innodb_redo/#ib_redo940. 2024-08-28T16:28:34.025066+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 218832230417, whereas checkpoint_lsn = 218832230493 and start_lsn = 218832230400 2024-08-28T16:28:34.025085+08:00 1 [Note] [MY-012547] [InnoDB] Log scan progressed past the checkpoint LSN 218832230417. 2024-08-28T16:28:34.025097+08:00 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally! 2024-08-28T16:28:34.025107+08:00 1 [Note] [MY-012552] [InnoDB] Starting crash recovery. 2024-08-28T16:28:34.025227+08:00 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 218832230503 2024-08-28T16:28:34.027354+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2024-08-28T16:28:34.027781+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 1 redo log records ... 2024-08-28T16:28:34.027836+08:00 1 [Note] [MY-012533] [InnoDB] 100% 2024-08-28T16:28:34.027855+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2024-08-28T16:28:34.027887+08:00 0 [Note] [MY-013623] [InnoDB] fallocate() failed with errno 117 - falling back to writing NULLs. 2024-08-28T16:28:34.027969+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2024-08-28T16:28:34.028091+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2024-08-28T16:28:34.028442+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2024-08-28T16:28:34.028510+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 170772187 2024-08-28T16:28:34.031510+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 10% 2024-08-28T16:28:34.034318+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete 2024-08-28T16:28:34.034372+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 5866 ms. 2024-08-28T16:28:34.034564+08:00 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2024-08-28T16:28:34.034582+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2024-08-28T16:28:34.034637+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-08-28T16:28:34.034841+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 20% 2024-08-28T16:28:34.038489+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 30% 2024-08-28T16:28:34.042239+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 40% 2024-08-28T16:28:34.045803+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 50% 2024-08-28T16:28:34.049514+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 60% 2024-08-28T16:28:34.053235+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 70% 2024-08-28T16:28:34.056803+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 80% 2024-08-28T16:28:34.060511+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 90% 2024-08-28T16:28:34.064091+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 100% 2024-08-28T16:28:34.249162+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2024-08-28T16:28:34.249330+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2024-08-28T16:28:34.315182+08:00 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: os0file.cc:3036 thread 281465996111744 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/ ... nnodb-recovery.html InnoDB: about forcing recovery. 2024-08-28T08:28:34Z UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=bc39de400860a943996e7b04e4952d1d68b3ff6d 2024-08-28T16:28:47.858731+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead. 2024-08-28T16:28:47.858778+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead. 2024-08-28T16:28:47.858787+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release. 2024-08-28T16:28:47.858798+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead. 2024-08-28T16:28:47.858811+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead. 2024-08-28T16:28:47.858822+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead. 2024-08-28T16:28:47.858943+08:00 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2024-08-28T16:28:47.859414+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2024-08-28T16:28:47.859472+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=bc39de400860a943996e7b04e4952d1d68b3ff6d 2024-08-28T16:28:47.859480+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/. 2024-08-28T16:28:47.859491+08:00 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32-25) starting as process 1 2024-08-28T16:28:47.882788+08:00 0 [Warning] [MY-000081] [Server] option 'innodb-autoextend-increment': unsigned value 268435456 adjusted to 1000. 2024-08-28T16:28:47.884035+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2024-08-28T16:28:47.884073+08:00 0 [Note] [MY-012359] [InnoDB] Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2024-08-28T16:28:47.884098+08:00 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity instead. 2024-08-28T16:28:47.884439+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2024-08-28T16:28:47.884523+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled. 2024-08-28T16:28:47.884547+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled. 2024-08-28T16:28:47.884562+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled. 2024-08-28T16:28:47.886247+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-08-28T16:28:47.886283+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2024-08-28T16:28:47.886313+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2024-08-28T16:28:47.886331+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2024-08-28T16:28:47.886341+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2024-08-28T16:28:47.886351+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13 2024-08-28T16:28:47.887540+08:00 1 [Note] [MY-011066] [InnoDB] File purge : set file purge path : /data/GreatSQL/#file_purge 2024-08-28T16:28:47.887616+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication. 2024-08-28T16:28:47.887927+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2024-08-28T16:28:47.887973+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './' 2024-08-28T16:28:47.912053+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:47.912086+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:47.912100+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:47.912112+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:47.924215+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:47.924235+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:47.924245+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:47.924259+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:47.934524+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 611 files. 2024-08-28T16:28:47.935206+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 512.000000M, instances = 1, chunk size =128.000000M 2024-08-28T16:28:47.958206+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2024-08-28T16:28:47.961219+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority(). 2024-08-28T16:28:47.985053+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:47.985089+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:47.985103+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:47.985116+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:47.996936+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:47.996957+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:47.996968+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:47.996979+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:47.997263+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2024-08-28T16:28:47.997429+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2024-08-28T16:28:48.026209+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:48.026255+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:48.026268+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:48.026280+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:48.038073+08:00 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 117 in a file operation. 2024-08-28T16:28:48.038092+08:00 1 [ERROR] [MY-012596] [InnoDB] Error number 117 means 'Structure needs cleaning' 2024-08-28T16:28:48.038102+08:00 1 [Note] [MY-012597] [InnoDB] Refer to your operating system documentation for operating system error code information. 2024-08-28T16:28:48.038112+08:00 1 [ERROR] [MY-012646] [InnoDB] File /data/GreatSQL/ib_buffer_pool: 'file_status_posix_stat' returned OS error 217. 2024-08-28T16:28:48.038388+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2 2024-08-28T16:28:48.038404+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4 2024-08-28T16:28:48.038433+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2024-08-28T16:28:48.038455+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2024-08-28T16:28:48.108930+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 218832230493 in redo log file ./#innodb_redo/#ib_redo940. 2024-08-28T16:28:48.109042+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 218832230417, whereas checkpoint_lsn = 218832230493 and start_lsn = 218832230400 2024-08-28T16:28:48.109061+08:00 1 [Note] [MY-012547] [InnoDB] Log scan progressed past the checkpoint LSN 218832230417. 2024-08-28T16:28:48.109072+08:00 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally! 2024-08-28T16:28:48.109089+08:00 1 [Note] [MY-012552] [InnoDB] Starting crash recovery. 2024-08-28T16:28:48.109208+08:00 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 218832230503 2024-08-28T16:28:48.111550+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2024-08-28T16:28:48.111961+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 1 redo log records ... 2024-08-28T16:28:48.112016+08:00 1 [Note] [MY-012533] [InnoDB] 100% 2024-08-28T16:28:48.112034+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2024-08-28T16:28:48.112055+08:00 0 [Note] [MY-013623] [InnoDB] fallocate() failed with errno 117 - falling back to writing NULLs. 2024-08-28T16:28:48.112144+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2024-08-28T16:28:48.112274+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2024-08-28T16:28:48.112622+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2024-08-28T16:28:48.112688+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 170772187 2024-08-28T16:28:48.115568+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 10% 2024-08-28T16:28:48.117947+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete 2024-08-28T16:28:48.117998+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 5314 ms. 2024-08-28T16:28:48.118675+08:00 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2024-08-28T16:28:48.118702+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2024-08-28T16:28:48.118760+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-08-28T16:28:48.118869+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 20% 2024-08-28T16:28:48.122555+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 30% 2024-08-28T16:28:48.126208+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 40% 2024-08-28T16:28:48.129757+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 50% 2024-08-28T16:28:48.133467+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 60% 2024-08-28T16:28:48.137153+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 70% 2024-08-28T16:28:48.140710+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 80% 2024-08-28T16:28:48.144405+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 90% 2024-08-28T16:28:48.147955+08:00 0 [Note] [MY-012887] [InnoDB] Setting file ./#innodb_redo/#ib_redo941_tmp size to 256 MB. Progress : 100% 2024-08-28T16:28:48.367598+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2024-08-28T16:28:48.367760+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2024-08-28T16:28:48.398012+08:00 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: os0file.cc:3036 thread 281463655755648 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/ ... nnodb-recovery.html InnoDB: about forcing recovery. 2024-08-28T08:28:48Z UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=bc39de400860a943996e7b04e4952d1d68b3ff6d 请问下是什么问题？如何解决？谢谢 |
数据库错误1
数据库错误2
数据库错误3
系统错误
数据库错误4
|
|
szy2526
2024-8-29 14:26:26
| |
|
|
yejr
2024-8-29 14:43:00
| |
|
|
szy2526
2024-8-29 14:56:20
| |
|
|
yejr
2024-8-29 15:00:56
| |
|
|
szy2526
2024-8-29 16:19:59
| |
|
|
yejr
2024-8-29 16:44:37
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
