2024-08-05T04:29:31.684316Z 17 [ERROR] [MY-011904] [InnoDB] Space id and page number stored in the page read in are [page id: space=256, page number=268468242], should be [page id: space=275, page number=1360896] 2024-08-05T04:29:31.684335Z 17 [ERROR] [MY-011906] [InnoDB] Database page corruption on disk or a failed file read of page [page id: space=275, page number=1360896]. You may have to recover from a backup. InnoDB: End of page dump InnoDB: Page may be a freshly allocated page 2024-08-05T04:29:31.729148Z 17 [ERROR] [MY-011904] [InnoDB] Space id and page number stored in the page read in are [page id: space=256, page number=268468242], should be [page id: space=275, page number=1360896] 2024-08-05T04:29:31.729162Z 17 [ERROR] [MY-011906] [InnoDB] Database page corruption on disk or a failed file read of page [page id: space=275, page number=1360896]. You may have to recover from a backup. 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 InnoDB: End of page dump InnoDB: Page may be a freshly allocated page 2024-08-05T04:29:31.770167Z 17 [ERROR] [MY-011899] [InnoDB] [FATAL] Unable to read page [page id: space=275, page number=1360896] into the buffer pool after 100 attempts. The most probable cause of this error may be that the table has been corrupted. Or, the table was compressed with with an algorithm that is not supported by this instance. If it is not a decompress failure, you can try to fix this problem by using innodb_force_recovery. Please see http://dev.mysql.com/doc/refman/8.0/en/ for more details. Aborting... 2024-08-05T04:29:31.770189Z 17 [ERROR] [MY-013183] [InnoDB] Assertion failure: buf0buf.cc:4054:ib::fatal triggered thread 70391920534928 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/8.0/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 2024-08-05T04:29:31Z UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x400cc5a05000 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 = 4005656b1d10 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2c) [0x136ca8c] /rdsdbbin/mysql/bin/mysqld(print_fatal_signal(int)+0x25c) [0xb35a5c] /rdsdbbin/mysql/bin/mysqld(my_server_abort()+0x80) [0xb35c00] /rdsdbbin/mysql/bin/mysqld(my_abort()+0x14) [0x1366074] /rdsdbbin/mysql/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x150) [0x14e6db0] /rdsdbbin/mysql/bin/mysqld() [0x14f9594] /rdsdbbin/mysql/bin/mysqld() [0x15393e4] /rdsdbbin/mysql/bin/mysqld(Buf_fetch_normal::get(buf_block_t*&)+0x39c) [0x153eb1c] /rdsdbbin/mysql/bin/mysqld(buf_page_get_gen(page_id_t const&, page_size_t const&, unsigned long, buf_block_t*, Page_fetch, ut::Location, mtr_t*, bool)+0x5a8) [0x15427e8] /rdsdbbin/mysql/bin/mysqld(btr_cur_search_to_nth_level(dict_index_t*, unsigned long, dtuple_t const*, page_cur_mode_t, unsigned long, btr_cur_t*, unsigned long, char const*, unsigned long, mtr_t*)+0x330) [0x1522690] /rdsdbbin/mysql/bin/mysqld() [0x1ae3a30] /rdsdbbin/mysql/bin/mysqld(row_ins_check_foreign_constraint(bool, dict_foreign_t*, dict_table_t*, dtuple_t*, que_thr_t*)+0x39c) [0x148631c] /rdsdbbin/mysql/bin/mysqld() [0x1c24064] /rdsdbbin/mysql/bin/mysqld() [0x14b04e0] /rdsdbbin/mysql/bin/mysqld(row_upd_step(que_thr_t*)+0x8fc) [0x14b0e5c] /rdsdbbin/mysql/bin/mysqld() [0x1c2518c] /rdsdbbin/mysql/bin/mysqld(ha_innobase::delete_row(unsigned char const*)+0x1cc) [0x13a0a8c] /rdsdbbin/mysql/bin/mysqld(handler::ha_delete_row(unsigned char const*)+0xc4) [0xc08464] /rdsdbbin/mysql/bin/mysqld() [0xe068b4] /rdsdbbin/mysql/bin/mysqld(Sql_cmd_delete::delete_from_single_table(THD*)+0x978) [0xe191f8] /rdsdbbin/mysql/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x18c) [0xa64f6c] /rdsdbbin/mysql/bin/mysqld(mysql_execute_command(THD*, bool)+0x7a0) [0xa2de80] /rdsdbbin/mysql/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x46c) [0xa30fec] /rdsdbbin/mysql/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x165c) [0xa32bfc] /rdsdbbin/mysql/bin/mysqld(do_command(THD*)+0x170) [0xa33490] /rdsdbbin/mysql/bin/mysqld() [0xb2f8ac] /rdsdbbin/mysql/bin/mysqld() [0x16d8ba0] /lib64/libpthread.so.0(+0x722c) [0x40000335122c] /lib64/libc.so.6(+0xd4a1c) [0x400003545a1c] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (400cc5a6fab0): delete from HFJ_RESOURCE t WHERE t.RES_ID in (800360721,801965379,801969913,801970181,801970334,802025986,802031769,802025938,802025004,802024856,802023196,802031727,802023190,802023200,802023224,802031681,802031450,802024687,802031908,802031826,802023234,802031677,802031599,802026083,802030507,802031628,802027769,802031590,802024685,802025051) Connection ID (thread ID): 17 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2024-08-05T04:29:49.571410Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2024-08-05T04:29:49.571505Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead. 2024-08-05T04:29:49.571524Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release. 2024-08-05T04:29:49.571532Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release. 2024-08-05T04:29:49.571595Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-file' is deprecated and will be removed in a future release. 2024-08-05T04:29:49.571602Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release. 2024-08-05T04:29:49.571631Z 0 [Warning] [MY-011068] [Server] The syntax 'skip_slave_start' is deprecated and will be removed in a future release. Please use skip_replica_start instead. 2024-08-05T04:29:49.571639Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead. 2024-08-05T04:29:49.571651Z 0 [Warning] [MY-011068] [Server] The syntax 'slave_load_tmpdir' is deprecated and will be removed in a future release. Please use replica_load_tmpdir instead. 2024-08-05T04:29:49.572840Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2024-08-05T04:29:49.572858Z 0 [System] [MY-010116] [Server] /rdsdbbin/mysql/bin/mysqld (mysqld 8.0.35) starting as process 820 2024-08-05T04:29:49.581655Z 0 [Warning] [MY-013869] [InnoDB] Ignored deprecated configuration parameter innodb_log_file_size. Used innodb_redo_log_capacity instead. 2024-08-05T04:29:49.581675Z 0 [Warning] [MY-013870] [InnoDB] Ignored deprecated configuration parameter innodb_log_files_in_group. Used innodb_redo_log_capacity instead. 2024-08-05T04:29:49.583103Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-08-05T04:29:49.586487Z 1 [Warning] [MY-012191] [InnoDB] Scan path '/rdsdbdata/db/innodb' is ignored because it is a sub-directory of '/rdsdbdata/db/ 2024-08-05T04:29:53.488125Z 1 [Warning] [MY-011056] [InnoDB] Invalid monitor counter : space_monitor. 2024-08-05T04:29:53.488207Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-08-05T04:29:53.866714Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2024-08-05T04:29:53.873221Z 0 [System] [MY-010232] [Server] XA crash recovery finished. 2024-08-05T04:29:53.985856Z 0 [Warning] [MY-010068] [Server] CA certificate /rdsdbdata/rds-metadata/ca-cert.pem is self signed. 2024-08-05T04:29:53.985888Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2024-08-05T04:29:53.998486Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_enforce_update_everywhere_checks=1'. 2024-08-05T04:29:53.998508Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_single_primary_mode=0'. InnoDB: Progress in percents: 12024-08-05T04:29:54.048134Z 0 [System] [MY-010931] [Server] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '8.0.35' socket: '/tmp/mysql.sock' port: 3306 Source distribution. 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 962024-08-05T04:29:57.550591Z 10 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.550595Z 9 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.552755Z 11 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.563691Z 12 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.565363Z 15 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.565417Z 16 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.565966Z 18 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.567134Z 19 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.567548Z 20 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.572394Z 21 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.572399Z 22 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.576406Z 24 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known 2024-08-05T04:29:57.578860Z 27 [Warning] [MY-010055] [Server] IP address '10.***' could not be resolved: Name or service not known