2021-12-02T08:55:02.000+02:00	2021-12-02 6:55:02 53908 [Warning] Aborted connection 53908 to db: 'cds_db' user: 'cds_sync08' host: '3.96.218.246' (Got timeout reading communication packets)

2021-12-02T08:55:02.000+02:00	2021-12-02 6:55:02 53908 [Warning] Aborted connection 53908 to db: 'cds_db' user: 'cds_sync08' host: '3.96.218.246' (Got timeout reading communication packets)

2021-12-02T09:00:37.000+02:00	2021-12-02 7:00:37 55639 [ERROR] [FATAL] InnoDB: Page old data size 11187 new data size 11171, page old max ins size 4913 new max ins size 4929

2021-12-02T09:00:37.000+02:00	211202 7:00:37 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=9 max_threads=258 thread_count=10 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x14ae96206dd8 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 = 0x14baa9743558 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x560cba268dae] /rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x51b)[0x560cb9a157fb]

2021-12-02T09:01:06.000+02:00	2021-12-02 7:01:06 0 [Note] mysqld: Aria engine: starting recovery tables to flush: 1 0 (0.0 seconds);

2021-12-02T09:01:06.000+02:00	2021-12-02 7:01:06 0 [Note] mysqld: Aria engine: recovery done

2021-12-02T09:01:06.000+02:00	2021-12-02 7:01:06 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:01:06.000+02:00	2021-12-02 7:01:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:01:06.000+02:00	2021-12-02 7:01:06 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:01:06.000+02:00	2021-12-02 7:01:06 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:01:06.000+02:00	2021-12-02 7:01:06 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:01:06.000+02:00	2021-12-02 7:01:06 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:01:07.000+02:00	2021-12-02 7:01:07 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:01:07.000+02:00	2021-12-02 7:01:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882233775898

2021-12-02T09:01:09.000+02:00	2021-12-02 7:01:09 0 [Note] InnoDB: Transaction 164662212 was in the XA prepared state.

2021-12-02T09:01:09.000+02:00	2021-12-02 7:01:09 0 [Note] InnoDB: 3 transaction(s) which must be rolled back or cleaned up in total 3453 row operations to undo

2021-12-02T09:01:09.000+02:00	2021-12-02 7:01:09 0 [Note] InnoDB: Trx id counter is 164662213

2021-12-02T09:01:09.000+02:00	2021-12-02 7:01:09 0 [Note] InnoDB: Starting final batch to recover 19183 pages from redo log.

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004727', position 66231692

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882817052208; transaction id 164662214

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:01:13.000+02:00	211202 7:01:13 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:01:13.000+02:00	211202 7:01:13 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] Starting crash recovery...

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Starting recovery for XA transactions...

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Transaction 164662212 in prepared state after recovery

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Transaction contains changes to 1 rows

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: 1 transactions in prepared state after recovery

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] Found 1 prepared transaction(s) in InnoDB

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] Crash recovery finished.

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] Server socket created on IP: '::'.

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] Reading of all Master_info entries succeeded

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] Added new Master_info '' to hash table

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/

2021-12-02T09:01:13.000+02:00	2021-12-02 7:01:13 0 [Note] InnoDB: Rolled back recovered transaction 164662114

2021-12-02T09:01:18.000+02:00	2021-12-02 7:01:18 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80000000; asc ;; 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc W105000000001D1637020800P;;

2021-12-02T09:01:18.000+02:00	2021-12-02 7:01:18 0 [Note] InnoDB: n_owned: 0; heap_no: 213; next rec: 8021 PHYSICAL RECORD: n_fields 3; compact format; info bits 16 0: len 4; hex 8000051e; asc ;; 1: len 26; hex 5731303030303030303030314431353335353837323030503130; asc W10000000001D1535587200P10;; 2: len 4; hex 00c5c017; asc ;;

2021-12-02T09:01:18.000+02:00	2021-12-02 7:01:18 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 166

2021-12-02T09:01:18.000+02:00	2021-12-02 7:01:18 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery. Then dump + drop + reimport.

2021-12-02T09:01:18.000+02:00	211202 7:01:18 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=2 max_threads=258 thread_count=4 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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 = 0x0 thread_stack 0x40000

2021-12-02T09:01:18.000+02:00	2021-12-02 7:01:18 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error reading communication packets) mysys/stacktrace.c:213(my_print_stacktrace)[0x55ac47602dae] sql/signal_handler.cc:222(handle_fatal_signal)[0x55ac46daf7fb] sigaction.c:0(__restore_rt)[0x14d920a807e0] :0(__GI_raise)[0x14d9206f7c20] :0(__GI_abort)[0x14d9206f90c8] :0(ib::fatal::~fatal())[0x55ac47456301] btr/btr0btr.cc:857(btr_page_get_father_node_ptr_func(unsigned short*, mem_block_info_t*, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*) [clone .constprop.69])[0x55ac4745ae77] btr/btr0btr.cc:914(btr_page_get_father_block)[0x55ac47460752] btr/btr0cur.cc:5470(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*))[0x55ac47470a56] btr/btr0cur.cc:5910(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0x55ac4747ba4e] row/row0uins.cc:289(row_undo_ins_remove_sec_low(unsigned long, dict_index_t*, dtuple_t*, que_thr_t*))[0x55ac4755c169] row/row0uins.cc:335(row_undo_ins_remove_sec)[0x55ac4755c683] row/row0undo.cc:420(row_undo)[0x55ac473f2e2a] que/que0que.cc:944(que_thr_step)[0x55ac47398e60] trx/trx0roll.cc:631(trx_rollback_active(trx_t*))[0x55ac474300c0] trx/trx0roll.cc:784(trx_rollback_recovered(bool))[0x55ac4743078f] trx/trx0roll.cc:838(trx_rollback_all_recovered)[0x55ac47430e9a] pthread_create.c:0(start_thread)[0x14d920a7640b] :0(__GI___clone)[0x14d9207b109f] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /rdsdbdata/db Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size unlimited unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes unlimited unlimited processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 254367 254367 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: /rdsdbdata/tmp/core-%e-%p

2021-12-02T09:01:36.000+02:00	2021-12-02 7:01:36 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:01:36.000+02:00	2021-12-02 7:01:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:01:36.000+02:00	2021-12-02 7:01:36 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:01:36.000+02:00	2021-12-02 7:01:36 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:01:36.000+02:00	2021-12-02 7:01:36 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:01:36.000+02:00	2021-12-02 7:01:36 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:01:37.000+02:00	2021-12-02 7:01:37 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:01:37.000+02:00	2021-12-02 7:01:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882231688520

2021-12-02T09:01:39.000+02:00	2021-12-02 7:01:39 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 144 row operations to undo

2021-12-02T09:01:39.000+02:00	2021-12-02 7:01:39 0 [Note] InnoDB: Trx id counter is 164662217

2021-12-02T09:01:39.000+02:00	2021-12-02 7:01:39 0 [Note] InnoDB: Starting final batch to recover 19473 pages from redo log.

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004725', position 68507614

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882823391480; transaction id 164662218

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:01:42.000+02:00	211202 7:01:42 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:01:42.000+02:00	211202 7:01:42 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] Starting crash recovery...

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] Crash recovery finished.

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80000000; asc ;; 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc W105000000001D1637020800P;;

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: n_owned: 0; heap_no: 213; next rec: 8021 PHYSICAL RECORD: n_fields 3; compact format; info bits 16 0: len 4; hex 8000051e; asc ;; 1: len 26; hex 5731303030303030303030314431353335353837323030503130; asc W10000000001D1535587200P10;; 2: len 4; hex 00c5c017; asc ;;

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 166

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery. Then dump + drop + reimport.

2021-12-02T09:01:42.000+02:00	211202 7:01:42 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=0 max_threads=258 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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 = 0x0 thread_stack 0x40000

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] Server socket created on IP: '::'.

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] Reading of all Master_info entries succeeded

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] Added new Master_info '' to hash table

2021-12-02T09:01:42.000+02:00	2021-12-02 7:01:42 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/ mysys/stacktrace.c:213(my_print_stacktrace)[0x5636f026edae] sql/signal_handler.cc:222(handle_fatal_signal)[0x5636efa1b7fb] sigaction.c:0(__restore_rt)[0x147dc1e537e0] :0(__GI_raise)[0x147dc1acac20] :0(__GI_abort)[0x147dc1acc0c8] :0(ib::fatal::~fatal())[0x5636f00c2301] btr/btr0btr.cc:857(btr_page_get_father_node_ptr_func(unsigned short*, mem_block_info_t*, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*) [clone .constprop.69])[0x5636f00c6e77] btr/btr0btr.cc:914(btr_page_get_father_block)[0x5636f00cc752] btr/btr0cur.cc:5470(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*))[0x5636f00dca56] btr/btr0cur.cc:5910(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0x5636f00e7a4e] row/row0uins.cc:289(row_undo_ins_remove_sec_low(unsigned long, dict_index_t*, dtuple_t*, que_thr_t*))[0x5636f01c8169] row/row0uins.cc:335(row_undo_ins_remove_sec)[0x5636f01c8683] row/row0undo.cc:420(row_undo)[0x5636f005ee2a] que/que0que.cc:944(que_thr_step)[0x5636f0004e60] trx/trx0roll.cc:631(trx_rollback_active(trx_t*))[0x5636f009c0c0] trx/trx0roll.cc:784(trx_rollback_recovered(bool))[0x5636f009c78f] trx/trx0roll.cc:838(trx_rollback_all_recovered)[0x5636f009ce9a] pthread_create.c:0(start_thread)[0x147dc1e4940b] :0(__GI___clone)[0x147dc1b8409f] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /rdsdbdata/db Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size unlimited unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes unlimited unlimited processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 254367 254367 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: /rdsdbdata/tmp/core-%e-%p

2021-12-02T09:02:55.000+02:00	2021-12-02 7:02:55 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:02:55.000+02:00	2021-12-02 7:02:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:02:55.000+02:00	2021-12-02 7:02:55 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:02:55.000+02:00	2021-12-02 7:02:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:02:55.000+02:00	2021-12-02 7:02:55 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:02:55.000+02:00	2021-12-02 7:02:55 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:02:56.000+02:00	2021-12-02 7:02:56 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:02:56.000+02:00	2021-12-02 7:02:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882231688520

2021-12-02T09:02:58.000+02:00	2021-12-02 7:02:58 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 144 row operations to undo

2021-12-02T09:02:58.000+02:00	2021-12-02 7:02:58 0 [Note] InnoDB: Trx id counter is 164662217

2021-12-02T09:02:58.000+02:00	2021-12-02 7:02:58 0 [Note] InnoDB: Starting final batch to recover 19473 pages from redo log.

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004725', position 68507614

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882823391590; transaction id 164662218

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:03:01.000+02:00	211202 7:03:01 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:03:01.000+02:00	211202 7:03:01 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] Starting crash recovery...

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] Crash recovery finished.

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80000000; asc ;; 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc W105000000001D1637020800P;;

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: n_owned: 0; heap_no: 213; next rec: 8021 PHYSICAL RECORD: n_fields 3; compact format; info bits 16 0: len 4; hex 8000051e; asc ;; 1: len 26; hex 5731303030303030303030314431353335353837323030503130; asc W10000000001D1535587200P10;; 2: len 4; hex 00c5c017; asc ;;

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 166

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery. Then dump + drop + reimport.

2021-12-02T09:03:01.000+02:00	211202 7:03:01 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=0 max_threads=258 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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 = 0x0 thread_stack 0x40000

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] Server socket created on IP: '::'.

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] Reading of all Master_info entries succeeded

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] Added new Master_info '' to hash table

2021-12-02T09:03:01.000+02:00	2021-12-02 7:03:01 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/ mysys/stacktrace.c:213(my_print_stacktrace)[0x556a5cf75dae] sql/signal_handler.cc:222(handle_fatal_signal)[0x556a5c7227fb] sigaction.c:0(__restore_rt)[0x149d1bf087e0] :0(__GI_raise)[0x149d1bb7fc20] :0(__GI_abort)[0x149d1bb810c8] :0(ib::fatal::~fatal())[0x556a5cdc9301] btr/btr0btr.cc:857(btr_page_get_father_node_ptr_func(unsigned short*, mem_block_info_t*, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*) [clone .constprop.69])[0x556a5cdcde77] btr/btr0btr.cc:914(btr_page_get_father_block)[0x556a5cdd3752] btr/btr0cur.cc:5470(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*))[0x556a5cde3a56] btr/btr0cur.cc:5910(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0x556a5cdeea4e] row/row0uins.cc:289(row_undo_ins_remove_sec_low(unsigned long, dict_index_t*, dtuple_t*, que_thr_t*))[0x556a5cecf169] row/row0uins.cc:335(row_undo_ins_remove_sec)[0x556a5cecf683] row/row0undo.cc:420(row_undo)[0x556a5cd65e2a] que/que0que.cc:944(que_thr_step)[0x556a5cd0be60] trx/trx0roll.cc:631(trx_rollback_active(trx_t*))[0x556a5cda30c0] trx/trx0roll.cc:784(trx_rollback_recovered(bool))[0x556a5cda378f] trx/trx0roll.cc:838(trx_rollback_all_recovered)[0x556a5cda3e9a] pthread_create.c:0(start_thread)[0x149d1befe40b] :0(__GI___clone)[0x149d1bc3909f] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /rdsdbdata/db Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size unlimited unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes unlimited unlimited processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 254367 254367 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: /rdsdbdata/tmp/core-%e-%p

2021-12-02T09:04:11.000+02:00	2021-12-02 7:04:11 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:04:11.000+02:00	2021-12-02 7:04:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:04:11.000+02:00	2021-12-02 7:04:11 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:04:11.000+02:00	2021-12-02 7:04:11 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:04:11.000+02:00	2021-12-02 7:04:11 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:04:11.000+02:00	2021-12-02 7:04:11 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:04:13.000+02:00	2021-12-02 7:04:13 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:04:13.000+02:00	2021-12-02 7:04:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882231688520

2021-12-02T09:04:14.000+02:00	2021-12-02 7:04:14 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 144 row operations to undo

2021-12-02T09:04:14.000+02:00	2021-12-02 7:04:14 0 [Note] InnoDB: Trx id counter is 164662217

2021-12-02T09:04:14.000+02:00	2021-12-02 7:04:14 0 [Note] InnoDB: Starting final batch to recover 19474 pages from redo log.

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004725', position 68507614

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882823391909; transaction id 164662218

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:04:18.000+02:00	211202 7:04:18 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:04:18.000+02:00	211202 7:04:18 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] Starting crash recovery...

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] Crash recovery finished.

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80000000; asc ;; 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc W105000000001D1637020800P;;

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: n_owned: 0; heap_no: 213; next rec: 8021 PHYSICAL RECORD: n_fields 3; compact format; info bits 16 0: len 4; hex 8000051e; asc ;; 1: len 26; hex 5731303030303030303030314431353335353837323030503130; asc W10000000001D1535587200P10;; 2: len 4; hex 00c5c017; asc ;;

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 166

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery. Then dump + drop + reimport.

2021-12-02T09:04:18.000+02:00	211202 7:04:18 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=0 max_threads=258 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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 = 0x0 thread_stack 0x40000

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] Server socket created on IP: '::'.

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] Reading of all Master_info entries succeeded

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] Added new Master_info '' to hash table

2021-12-02T09:04:18.000+02:00	2021-12-02 7:04:18 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/ mysys/stacktrace.c:213(my_print_stacktrace)[0x55719db29dae] sql/signal_handler.cc:222(handle_fatal_signal)[0x55719d2d67fb] sigaction.c:0(__restore_rt)[0x14f77ca6c7e0] :0(__GI_raise)[0x14f77c6e3c20] :0(__GI_abort)[0x14f77c6e50c8] :0(ib::fatal::~fatal())[0x55719d97d301] btr/btr0btr.cc:857(btr_page_get_father_node_ptr_func(unsigned short*, mem_block_info_t*, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*) [clone .constprop.69])[0x55719d981e77] btr/btr0btr.cc:914(btr_page_get_father_block)[0x55719d987752] btr/btr0cur.cc:5470(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*))[0x55719d997a56] btr/btr0cur.cc:5910(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0x55719d9a2a4e] row/row0uins.cc:289(row_undo_ins_remove_sec_low(unsigned long, dict_index_t*, dtuple_t*, que_thr_t*))[0x55719da83169] row/row0uins.cc:335(row_undo_ins_remove_sec)[0x55719da83683] row/row0undo.cc:420(row_undo)[0x55719d919e2a] que/que0que.cc:944(que_thr_step)[0x55719d8bfe60] trx/trx0roll.cc:631(trx_rollback_active(trx_t*))[0x55719d9570c0] trx/trx0roll.cc:784(trx_rollback_recovered(bool))[0x55719d95778f] trx/trx0roll.cc:838(trx_rollback_all_recovered)[0x55719d957e9a] pthread_create.c:0(start_thread)[0x14f77ca6240b] :0(__GI___clone)[0x14f77c79d09f] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /rdsdbdata/db Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size unlimited unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes unlimited unlimited processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 254367 254367 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: /rdsdbdata/tmp/core-%e-%p

2021-12-02T09:05:28.000+02:00	2021-12-02 7:05:28 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:05:28.000+02:00	2021-12-02 7:05:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:05:28.000+02:00	2021-12-02 7:05:28 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:05:28.000+02:00	2021-12-02 7:05:28 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:05:28.000+02:00	2021-12-02 7:05:28 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:05:28.000+02:00	2021-12-02 7:05:28 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:05:30.000+02:00	2021-12-02 7:05:30 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:05:30.000+02:00	2021-12-02 7:05:30 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882231688520

2021-12-02T09:05:31.000+02:00	2021-12-02 7:05:31 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 144 row operations to undo

2021-12-02T09:05:31.000+02:00	2021-12-02 7:05:31 0 [Note] InnoDB: Trx id counter is 164662217

2021-12-02T09:05:31.000+02:00	2021-12-02 7:05:31 0 [Note] InnoDB: Starting final batch to recover 19474 pages from redo log.

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004725', position 68507614

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882823392019; transaction id 164662218

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:05:35.000+02:00	211202 7:05:35 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:05:35.000+02:00	211202 7:05:35 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] Starting crash recovery...

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] Crash recovery finished.

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80000000; asc ;; 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc W105000000001D1637020800P;;

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: n_owned: 0; heap_no: 213; next rec: 8021 PHYSICAL RECORD: n_fields 3; compact format; info bits 16 0: len 4; hex 8000051e; asc ;; 1: len 26; hex 5731303030303030303030314431353335353837323030503130; asc W10000000001D1535587200P10;; 2: len 4; hex 00c5c017; asc ;;

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 166

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery. Then dump + drop + reimport.

2021-12-02T09:05:35.000+02:00	211202 7:05:35 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=0 max_threads=258 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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 = 0x0 thread_stack 0x40000

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] Server socket created on IP: '::'.

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] Reading of all Master_info entries succeeded

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] Added new Master_info '' to hash table

2021-12-02T09:05:35.000+02:00	2021-12-02 7:05:35 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/ mysys/stacktrace.c:213(my_print_stacktrace)[0x562ff08dadae] sql/signal_handler.cc:222(handle_fatal_signal)[0x562ff00877fb] sigaction.c:0(__restore_rt)[0x154dafa247e0] :0(__GI_raise)[0x154daf69bc20] :0(__GI_abort)[0x154daf69d0c8] :0(ib::fatal::~fatal())[0x562ff072e301] btr/btr0btr.cc:857(btr_page_get_father_node_ptr_func(unsigned short*, mem_block_info_t*, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*) [clone .constprop.69])[0x562ff0732e77] btr/btr0btr.cc:914(btr_page_get_father_block)[0x562ff0738752] btr/btr0cur.cc:5470(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*))[0x562ff0748a56] btr/btr0cur.cc:5910(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0x562ff0753a4e] row/row0uins.cc:289(row_undo_ins_remove_sec_low(unsigned long, dict_index_t*, dtuple_t*, que_thr_t*))[0x562ff0834169] row/row0uins.cc:335(row_undo_ins_remove_sec)[0x562ff0834683] row/row0undo.cc:420(row_undo)[0x562ff06cae2a] que/que0que.cc:944(que_thr_step)[0x562ff0670e60] trx/trx0roll.cc:631(trx_rollback_active(trx_t*))[0x562ff07080c0] trx/trx0roll.cc:784(trx_rollback_recovered(bool))[0x562ff070878f] trx/trx0roll.cc:838(trx_rollback_all_recovered)[0x562ff0708e9a] pthread_create.c:0(start_thread)[0x154dafa1a40b] :0(__GI___clone)[0x154daf75509f] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /rdsdbdata/db Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size unlimited unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes unlimited unlimited processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 254367 254367 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: /rdsdbdata/tmp/core-%e-%p

2021-12-02T09:06:46.000+02:00	2021-12-02 7:06:46 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:06:46.000+02:00	2021-12-02 7:06:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:06:46.000+02:00	2021-12-02 7:06:46 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:06:46.000+02:00	2021-12-02 7:06:46 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:06:46.000+02:00	2021-12-02 7:06:46 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:06:46.000+02:00	2021-12-02 7:06:46 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:06:48.000+02:00	2021-12-02 7:06:48 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:06:48.000+02:00	2021-12-02 7:06:48 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882231688520

2021-12-02T09:06:49.000+02:00	2021-12-02 7:06:49 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 144 row operations to undo

2021-12-02T09:06:49.000+02:00	2021-12-02 7:06:49 0 [Note] InnoDB: Trx id counter is 164662217

2021-12-02T09:06:49.000+02:00	2021-12-02 7:06:49 0 [Note] InnoDB: Starting final batch to recover 19474 pages from redo log.

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004725', position 68507614

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882823392129; transaction id 164662218

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:06:53.000+02:00	211202 7:06:53 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:06:53.000+02:00	211202 7:06:53 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] Starting crash recovery...

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] Crash recovery finished.

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] Server socket created on IP: '::'.

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-12-02T09:06:53.000+02:00

Copy
2021-12-02  7:06:53 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156
PHYSICAL RECORD: n_fields 2; compact format; info bits 0
 0: len 4; hex 80000000; asc     ;;
 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc     W105000000001D1637020800P;;
2021-12-02 7:06:53 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80000000; asc ;; 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc W105000000001D1637020800P;;

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: n_owned: 0; heap_no: 213; next rec: 8021 PHYSICAL RECORD: n_fields 3; compact format; info bits 16 0: len 4; hex 8000051e; asc ;; 1: len 26; hex 5731303030303030303030314431353335353837323030503130; asc W10000000001D1535587200P10;; 2: len 4; hex 00c5c017; asc ;;

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 166

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery. Then dump + drop + reimport.

2021-12-02T09:06:53.000+02:00	211202 7:06:53 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=0 max_threads=258 thread_count=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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 = 0x0 thread_stack 0x40000

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] Reading of all Master_info entries succeeded

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] Added new Master_info '' to hash table

2021-12-02T09:06:53.000+02:00	2021-12-02 7:06:53 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/ mysys/stacktrace.c:213(my_print_stacktrace)[0x5622acb41dae] sql/signal_handler.cc:222(handle_fatal_signal)[0x5622ac2ee7fb] sigaction.c:0(__restore_rt)[0x14bd73df57e0] :0(__GI_raise)[0x14bd73a6cc20] :0(__GI_abort)[0x14bd73a6e0c8] :0(ib::fatal::~fatal())[0x5622ac995301] btr/btr0btr.cc:857(btr_page_get_father_node_ptr_func(unsigned short*, mem_block_info_t*, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*) [clone .constprop.69])[0x5622ac999e77] btr/btr0btr.cc:914(btr_page_get_father_block)[0x5622ac99f752] btr/btr0cur.cc:5470(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*))[0x5622ac9afa56] btr/btr0cur.cc:5910(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0x5622ac9baa4e] row/row0uins.cc:289(row_undo_ins_remove_sec_low(unsigned long, dict_index_t*, dtuple_t*, que_thr_t*))[0x5622aca9b169] row/row0uins.cc:335(row_undo_ins_remove_sec)[0x5622aca9b683] row/row0undo.cc:420(row_undo)[0x5622ac931e2a] que/que0que.cc:944(que_thr_step)[0x5622ac8d7e60] trx/trx0roll.cc:631(trx_rollback_active(trx_t*))[0x5622ac96f0c0] trx/trx0roll.cc:784(trx_rollback_recovered(bool))[0x5622ac96f78f] trx/trx0roll.cc:838(trx_rollback_all_recovered)[0x5622ac96fe9a] pthread_create.c:0(start_thread)[0x14bd73deb40b] :0(__GI___clone)[0x14bd73b2609f] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /rdsdbdata/db Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size unlimited unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes unlimited unlimited processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 254367 254367 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: /rdsdbdata/tmp/core-%e-%p

2021-12-02T09:08:03.000+02:00	2021-12-02 7:08:03 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:08:03.000+02:00	2021-12-02 7:08:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:08:03.000+02:00	2021-12-02 7:08:03 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:08:03.000+02:00	2021-12-02 7:08:03 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:08:03.000+02:00	2021-12-02 7:08:03 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:08:03.000+02:00	2021-12-02 7:08:03 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:08:04.000+02:00	2021-12-02 7:08:04 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:08:04.000+02:00	2021-12-02 7:08:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882231688520

2021-12-02T09:08:06.000+02:00	2021-12-02 7:08:06 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 144 row operations to undo

2021-12-02T09:08:06.000+02:00	2021-12-02 7:08:06 0 [Note] InnoDB: Trx id counter is 164662217

2021-12-02T09:08:06.000+02:00	2021-12-02 7:08:06 0 [Note] InnoDB: Starting final batch to recover 19474 pages from redo log.

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004725', position 68507614

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882823392239; transaction id 164662218

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:08:10.000+02:00	211202 7:08:10 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:08:10.000+02:00	211202 7:08:10 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] Starting crash recovery...

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] Crash recovery finished.

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80000000; asc ;; 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc W105000000001D1637020800P;;

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: n_owned: 0; heap_no: 213; next rec: 8021 PHYSICAL RECORD: n_fields 3; compact format; info bits 16 0: len 4; hex 8000051e; asc ;; 1: len 26; hex 5731303030303030303030314431353335353837323030503130; asc W10000000001D1535587200P10;; 2: len 4; hex 00c5c017; asc ;;

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 166

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery. Then dump + drop + reimport.

2021-12-02T09:08:10.000+02:00	211202 7:08:10 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=0 max_threads=258 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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 = 0x0 thread_stack 0x40000

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] Server socket created on IP: '::'.

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] Reading of all Master_info entries succeeded

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] Added new Master_info '' to hash table

2021-12-02T09:08:10.000+02:00	2021-12-02 7:08:10 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/ mysys/stacktrace.c:213(my_print_stacktrace)[0x55882a325dae] sql/signal_handler.cc:222(handle_fatal_signal)[0x558829ad27fb] sigaction.c:0(__restore_rt)[0x154f5f7d97e0] :0(__GI_raise)[0x154f5f450c20] :0(__GI_abort)[0x154f5f4520c8] :0(ib::fatal::~fatal())[0x55882a179301] btr/btr0btr.cc:857(btr_page_get_father_node_ptr_func(unsigned short*, mem_block_info_t*, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*) [clone .constprop.69])[0x55882a17de77] btr/btr0btr.cc:914(btr_page_get_father_block)[0x55882a183752] btr/btr0cur.cc:5470(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*))[0x55882a193a56] btr/btr0cur.cc:5910(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0x55882a19ea4e] row/row0uins.cc:289(row_undo_ins_remove_sec_low(unsigned long, dict_index_t*, dtuple_t*, que_thr_t*))[0x55882a27f169] row/row0uins.cc:335(row_undo_ins_remove_sec)[0x55882a27f683] row/row0undo.cc:420(row_undo)[0x55882a115e2a] que/que0que.cc:944(que_thr_step)[0x55882a0bbe60] trx/trx0roll.cc:631(trx_rollback_active(trx_t*))[0x55882a1530c0] trx/trx0roll.cc:784(trx_rollback_recovered(bool))[0x55882a15378f] trx/trx0roll.cc:838(trx_rollback_all_recovered)[0x55882a153e9a] pthread_create.c:0(start_thread)[0x154f5f7cf40b] :0(__GI___clone)[0x154f5f50a09f] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /rdsdbdata/db Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size unlimited unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes unlimited unlimited processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 254367 254367 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: /rdsdbdata/tmp/core-%e-%p

2021-12-02T09:09:20.000+02:00	2021-12-02 7:09:20 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:09:20.000+02:00	2021-12-02 7:09:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:09:20.000+02:00	2021-12-02 7:09:20 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:09:20.000+02:00	2021-12-02 7:09:20 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:09:20.000+02:00	2021-12-02 7:09:20 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:09:20.000+02:00	2021-12-02 7:09:20 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:09:21.000+02:00	2021-12-02 7:09:21 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:09:21.000+02:00	2021-12-02 7:09:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882231688520

2021-12-02T09:09:23.000+02:00	2021-12-02 7:09:23 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 144 row operations to undo

2021-12-02T09:09:23.000+02:00	2021-12-02 7:09:23 0 [Note] InnoDB: Trx id counter is 164662217

2021-12-02T09:09:23.000+02:00	2021-12-02 7:09:23 0 [Note] InnoDB: Starting final batch to recover 19474 pages from redo log.

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004725', position 68507614

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882823392365; transaction id 164662218

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:09:27.000+02:00	211202 7:09:27 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:09:27.000+02:00	211202 7:09:27 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] Starting crash recovery...

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] Crash recovery finished.

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80000000; asc ;; 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc W105000000001D1637020800P;;

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: n_owned: 0; heap_no: 213; next rec: 8021 PHYSICAL RECORD: n_fields 3; compact format; info bits 16 0: len 4; hex 8000051e; asc ;; 1: len 26; hex 57312021-12-02 7:09:27 0 [Note] Server socket created on IP: '::'. 303030303030303030314431353335353837323030503130; asc W10000000001D1535587200P10;; 2: len 4; hex 00c5c017; asc ;;

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 166

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery. Then dump + drop + reimport.

2021-12-02T09:09:27.000+02:00	211202 7:09:27 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=0 max_threads=258 thread_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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 = 0x0 thread_stack 0x40000

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] Reading of all Master_info entries succeeded

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] Added new Master_info '' to hash table

2021-12-02T09:09:27.000+02:00	2021-12-02 7:09:27 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/ mysys/stacktrace.c:213(my_print_stacktrace)[0x5631b47a7dae] sql/signal_handler.cc:222(handle_fatal_signal)[0x5631b3f547fb] sigaction.c:0(__restore_rt)[0x14d5c484e7e0] :0(__GI_raise)[0x14d5c44c5c20] :0(__GI_abort)[0x14d5c44c70c8] :0(ib::fatal::~fatal())[0x5631b45fb301] btr/btr0btr.cc:857(btr_page_get_father_node_ptr_func(unsigned short*, mem_block_info_t*, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*) [clone .constprop.69])[0x5631b45ffe77] btr/btr0btr.cc:914(btr_page_get_father_block)[0x5631b4605752] btr/btr0cur.cc:5470(btr_cur_compress_if_useful(btr_cur_t*, unsigned long, mtr_t*))[0x5631b4615a56] btr/btr0cur.cc:5910(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0x5631b4620a4e] row/row0uins.cc:289(row_undo_ins_remove_sec_low(unsigned long, dict_index_t*, dtuple_t*, que_thr_t*))[0x5631b4701169] row/row0uins.cc:335(row_undo_ins_remove_sec)[0x5631b4701683] row/row0undo.cc:420(row_undo)[0x5631b4597e2a] que/que0que.cc:944(que_thr_step)[0x5631b453de60] trx/trx0roll.cc:631(trx_rollback_active(trx_t*))[0x5631b45d50c0] trx/trx0roll.cc:784(trx_rollback_recovered(bool))[0x5631b45d578f] trx/trx0roll.cc:838(trx_rollback_all_recovered)[0x5631b45d5e9a] pthread_create.c:0(start_thread)[0x14d5c484440b] :0(__GI___clone)[0x14d5c457f09f] The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains information that should help you find out what is causing the crash. Writing a core file... Working directory at /rdsdbdata/db Resource Limits: Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size unlimited unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes unlimited unlimited processes Max open files 65535 65535 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 254367 254367 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us Core pattern: /rdsdbdata/tmp/core-%e-%p

2021-12-02T09:10:37.000+02:00	2021-12-02 7:10:37 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:10:37.000+02:00	2021-12-02 7:10:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:10:37.000+02:00	2021-12-02 7:10:37 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:10:37.000+02:00	2021-12-02 7:10:37 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:10:37.000+02:00	2021-12-02 7:10:37 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:10:37.000+02:00	2021-12-02 7:10:37 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:10:38.000+02:00	2021-12-02 7:10:38 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:10:38.000+02:00	2021-12-02 7:10:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882231688520

2021-12-02T09:10:40.000+02:00	2021-12-02 7:10:40 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 144 row operations to undo

2021-12-02T09:10:40.000+02:00	2021-12-02 7:10:40 0 [Note] InnoDB: Trx id counter is 164662217

2021-12-02T09:10:40.000+02:00	2021-12-02 7:10:40 0 [Note] InnoDB: Starting final batch to recover 19474 pages from redo log.

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004725', position 68507614

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882823392475; transaction id 164662218

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:10:44.000+02:00	211202 7:10:44 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:10:44.000+02:00	211202 7:10:44 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] Starting crash recovery...

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] Crash recovery finished.

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] Server socket created on IP: '::'.

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] Reading of all Master_info entries succeeded

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] Added new Master_info '' to hash table

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.13-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [ERROR] InnoDB: Corruption of an index tree: table `cds_db`.`ProductStockHistory` index `clientCode`, father ptr page no 12959767, child page no 14691156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 80000000; asc ;; 1: len 29; hex 000006aa57313035303030303030303031443136333730323038303050; asc W105000000001D1637020800P;;

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: n_owned: 0; heap_no: 213; next rec: 8021 PHYSICAL RECORD: n_fields 3; compact format; info bits 16 0: len 4; hex 8000051e; asc ;; 1: len 26; hex 5731303030303030303030314431353335353837323030503130; asc W10000000001D1535587200P10;; 2: len 4; hex 00c5c017; asc ;;

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [Note] InnoDB: n_owned: 0; heap_no: 2; next rec: 166

2021-12-02T09:10:44.000+02:00	2021-12-02 7:10:44 0 [ERROR] [FATAL] InnoDB: You should dump + drop + reimport the table to fix the corruption. If the crash happens at database startup. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery. Then dump + drop + reimport.

2021-12-02T09:10:44.000+02:00	211202 7:10:44 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.5.13-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=0 max_threads=258 thread_count=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 666127 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 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 = 0x0 thread_stack 0x40000 mysys/stacktrace.c:213(my_print_stacktrace)[0x55765ff48dae] sql/signal_handler.cc:222(handle_fatal_signal)[0x55765f6f57fb] sigaction.c:0(__restore_rt)[0x14c2e53e47e0] :0(__GI_raise)[0x14c2e505bc20] :0(__GI_abort)[0x14c2e505d0c8] :0(ib::fatal::~fatal())[0x55765fd9c301] btr/btr0btr.cc:857(btr_page_get_father_node_ptr_func(unsigned short*, mem_block_info_t*, btr_cur_t*, unsigned long, char const*, unsigned int, mtr_t*) [clone .constprop.69])[0x55765fda0e77] btr/btr0btr.cc:914(btr_page_get_father_block)[0x55765fda6752]

2021-12-02T09:11:55.000+02:00	2021-12-02 7:11:55 0 [Note] InnoDB: Uses event mutexes

2021-12-02T09:11:55.000+02:00	2021-12-02 7:11:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-12-02T09:11:55.000+02:00	2021-12-02 7:11:55 0 [Note] InnoDB: Number of pools: 1

2021-12-02T09:11:55.000+02:00	2021-12-02 7:11:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-12-02T09:11:55.000+02:00	2021-12-02 7:11:55 0 [Note] InnoDB: Using Linux native AIO

2021-12-02T09:11:55.000+02:00	2021-12-02 7:11:55 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-12-02T09:11:56.000+02:00	2021-12-02 7:11:56 0 [Note] InnoDB: Completed initialization of buffer pool

2021-12-02T09:11:56.000+02:00	2021-12-02 7:11:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16882231688520,16882231688520

2021-12-02T09:11:58.000+02:00	2021-12-02 7:11:58 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 144 row operations to undo

2021-12-02T09:11:58.000+02:00	2021-12-02 7:11:58 0 [Note] InnoDB: Trx id counter is 164662217

2021-12-02T09:11:58.000+02:00	2021-12-02 7:11:58 0 [Note] InnoDB: Starting final batch to recover 19474 pages from redo log.

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.004725', position 68507614

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] InnoDB: 128 rollback segments are active.

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] InnoDB: Setting file '/rdsdbdata/db/innodb/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] InnoDB: File '/rdsdbdata/db/innodb/ibtmp1' size is now 12 MB.

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] InnoDB: 10.5.13 started; log sequence number 16882823392585; transaction id 164662218

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-12-02T09:12:02.000+02:00	211202 7:12:02 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-12-02T09:12:02.000+02:00	211202 7:12:02 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-12-02T09:12:02.000+02:00	2021-12-02 7:12:02 0 [Note] Starting crash recovery...