2021-11-19T09:16:05.000+02:00

Copy
2021-11-19  7:16:05 127619 [ERROR] [FATAL] InnoDB: Page old data size 12625 new data size 12066, page old max ins size 3459 new max ins size 4018
2021-11-19 7:16:05 127619 [ERROR] [FATAL] InnoDB: Page old data size 12625 new data size 12066, page old max ins size 3459 new max ins size 4018

2021-11-19T09:16:05.000+02:00

Copy
211119  7:16:05 [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.12-MariaDB-log
key_buffer_size=67108864
read_buffer_size=262144
max_used_connections=12
max_threads=258
thread_count=11
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: 0x2ae0ce212418
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 = 0x2ad5beec1578 thread_stack 0x40000
/rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x55be08624c5e]
/rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x51a)[0x55be07dd676a]
sigaction.c:0(__restore_rt)[0x2ad4ac023100]
:0(__GI_raise)[0x2ad4ac2655f7]
:0(__GI_abort)[0x2ad4ac266ce8]
211119 7:16:05 [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.12-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=12 max_threads=258 thread_count=11 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: 0x2ae0ce212418 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 = 0x2ad5beec1578 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x55be08624c5e] /rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x51a)[0x55be07dd676a] sigaction.c:0(__restore_rt)[0x2ad4ac023100] :0(__GI_raise)[0x2ad4ac2655f7] :0(__GI_abort)[0x2ad4ac266ce8]

2021-11-19T09:16:05.000+02:00

Copy
2021-11-19  7:16:05 127619 [ERROR] [FATAL] InnoDB: Page old data size 12625 new data size 12066, page old max ins size 3459 new max ins size 4018
2021-11-19 7:16:05 127619 [ERROR] [FATAL] InnoDB: Page old data size 12625 new data size 12066, page old max ins size 3459 new max ins size 4018

2021-11-19T09:16:05.000+02:00

Copy
211119  7:16:05 [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.12-MariaDB-log
key_buffer_size=67108864
read_buffer_size=262144
max_used_connections=12
max_threads=258
thread_count=11
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: 0x2ae0ce212418
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 = 0x2ad5beec1578 thread_stack 0x40000
/rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x55be08624c5e]
/rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x51a)[0x55be07dd676a]
sigaction.c:0(__restore_rt)[0x2ad4ac023100]
:0(__GI_raise)[0x2ad4ac2655f7]
:0(__GI_abort)[0x2ad4ac266ce8]
/rdsdbbin/mysql/bin/mysqld(+0x10b87d1)[0x55be084787d1]
:0(ib::fatal::~fatal())[0x55be0847e246]
btr/btr0btr.cc:1484(btr_page_reorganize_low)[0x55be0847e617]
btr/btr0btr.cc:1646(btr_page_reorganize(page_cur_t*, dict_index_t*, mtr_t*))[0x55be0849a93e]
btr/btr0cur.cc:3585(btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0x55be083dca98]
row/row0ins.cc:3093(row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*))[0x55be083e293b]
row/row0ins.cc:3297(row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool))[0x55be083e2de6]
row/row0ins.cc:3669(row_ins)[0x55be083f5ac2]
row/row0mysql.cc:1423(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*, ins_mode_t))[0x55be08334cff]
handler/ha_innodb.cc:7674(ha_innobase::write_row(unsigned char const*))[0x55be07de18f4]
sql/handler.cc:7168(handler::ha_write_row(unsigned char const*))[0x55be07bbafe9]
sql/sql_insert.cc:1816(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x55be07bc1ce6]
sql/sql_insert.cc:1119(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x55be07bee13c]
sql/sql_parse.cc:4660(mysql_execute_command(THD*))[0x55be07bf1f00]
sql/sql_parse.cc:8224(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55be07be9237]
sql/sql_parse.cc:1966(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55be07be7a4d]
sql/sql_parse.cc:1378(do_command(THD*))[0x55be07cd5ca6]
sql/sql_connect.cc:1461(do_handle_one_connection(CONNECT*, bool))[0x55be07cd6014]
sql/sql_connect.cc:1359(handle_one_connection)[0x55be082a669c]
pthread_create.c:0(start_thread)[0x2ad4ac01bdc5]
??:0(__clone)[0x2ad4ac326c9d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x2ae0ce2491b0): INSERT INTO ProductStockHistory (stockID,productID,warehouseID,amountInStock,amountReserved,averagePurchasePrice,averageCost,date,clientCode,added,lastModified) VALUES (<list_of_removed_values>) ON DUPLICATE KEY UPDATE stockID=VALUES(stockID),productID=VALUES(productID),warehouseID=VALUES(warehouseID),amountInStock=VALUES(amountInStock),amountReserved=VALUES(amountReserved),averagePurchasePrice=VALUES(averagePurchasePrice),averageCost=VALUES(averageCost),date=VALUES(date),clientCode=VALUES(clientCode),added=VALUES(added),lastModified=VALUES(lastModified)
Connection ID (thread ID): 127619
Status: NOT_KILLED
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
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       254459               254459               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
211119 7:16:05 [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.12-MariaDB-log key_buffer_size=67108864 read_buffer_size=262144 max_used_connections=12 max_threads=258 thread_count=11 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: 0x2ae0ce212418 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 = 0x2ad5beec1578 thread_stack 0x40000 /rdsdbbin/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x55be08624c5e] /rdsdbbin/mysql/bin/mysqld(handle_fatal_signal+0x51a)[0x55be07dd676a] sigaction.c:0(__restore_rt)[0x2ad4ac023100] :0(__GI_raise)[0x2ad4ac2655f7] :0(__GI_abort)[0x2ad4ac266ce8] /rdsdbbin/mysql/bin/mysqld(+0x10b87d1)[0x55be084787d1] :0(ib::fatal::~fatal())[0x55be0847e246] btr/btr0btr.cc:1484(btr_page_reorganize_low)[0x55be0847e617] btr/btr0btr.cc:1646(btr_page_reorganize(page_cur_t*, dict_index_t*, mtr_t*))[0x55be0849a93e] btr/btr0cur.cc:3585(btr_cur_optimistic_insert(unsigned long, btr_cur_t*, unsigned short**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0x55be083dca98] row/row0ins.cc:3093(row_ins_sec_index_entry_low(unsigned long, unsigned long, dict_index_t*, mem_block_info_t*, mem_block_info_t*, dtuple_t*, unsigned long, que_thr_t*))[0x55be083e293b] row/row0ins.cc:3297(row_ins_sec_index_entry(dict_index_t*, dtuple_t*, que_thr_t*, bool))[0x55be083e2de6] row/row0ins.cc:3669(row_ins)[0x55be083f5ac2] row/row0mysql.cc:1423(row_insert_for_mysql(unsigned char const*, row_prebuilt_t*, ins_mode_t))[0x55be08334cff] handler/ha_innodb.cc:7674(ha_innobase::write_row(unsigned char const*))[0x55be07de18f4] sql/handler.cc:7168(handler::ha_write_row(unsigned char const*))[0x55be07bbafe9] sql/sql_insert.cc:1816(write_record(THD*, TABLE*, st_copy_info*, select_result*))[0x55be07bc1ce6] sql/sql_insert.cc:1119(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x55be07bee13c] sql/sql_parse.cc:4660(mysql_execute_command(THD*))[0x55be07bf1f00] sql/sql_parse.cc:8224(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55be07be9237] sql/sql_parse.cc:1966(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55be07be7a4d] sql/sql_parse.cc:1378(do_command(THD*))[0x55be07cd5ca6] sql/sql_connect.cc:1461(do_handle_one_connection(CONNECT*, bool))[0x55be07cd6014] sql/sql_connect.cc:1359(handle_one_connection)[0x55be082a669c] pthread_create.c:0(start_thread)[0x2ad4ac01bdc5] ??:0(__clone)[0x2ad4ac326c9d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x2ae0ce2491b0): INSERT INTO ProductStockHistory (stockID,productID,warehouseID,amountInStock,amountReserved,averagePurchasePrice,averageCost,date,clientCode,added,lastModified) VALUES ('W177000000001D1637280000P342','342','177000000001','41.000000','0','2.3725','2.3725','2021-11-18','1477','1637280000','1637306161') ON DUPLICATE KEY UPDATE stockID=VALUES(stockID),productID=VALUES(productID),warehouseID=VALUES(warehouseID),amountInStock=VALUES(amountInStock),amountReserved=VALUES(amountReserved),averagePurchasePrice=VALUES(averagePurchasePrice),averageCost=VALUES(averageCost),date=VALUES(date),clientCode=VALUES(clientCode),added=VALUES(added),lastModified=VALUES(lastModified) Connection ID (thread ID): 127619 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off 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 254459 254459 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-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Uses event mutexes

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Number of pools: 1

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Using Linux native AIO

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Uses event mutexes

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Number of pools: 1

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Using Linux native AIO

2021-11-19T09:16:33.000+02:00	2021-11-19 7:16:33 0 [Note] InnoDB: Initializing buffer pool, total size = 49392123904, chunk size = 134217728

2021-11-19T09:16:34.000+02:00	2021-11-19 7:16:34 0 [Note] InnoDB: Completed initialization of buffer pool

2021-11-19T09:16:34.000+02:00	2021-11-19 7:16:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16083462248501,16083469129135

2021-11-19T09:16:34.000+02:00	2021-11-19 7:16:34 0 [Note] InnoDB: Completed initialization of buffer pool

2021-11-19T09:16:34.000+02:00	2021-11-19 7:16:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=16083462248501,16083469129135

2021-11-19T09:16:35.000+02:00	2021-11-19 7:16:35 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 236 row operations to undo

2021-11-19T09:16:35.000+02:00	2021-11-19 7:16:35 0 [Note] InnoDB: Trx id counter is 158831434

2021-11-19T09:16:35.000+02:00	2021-11-19 7:16:35 0 [Note] InnoDB: Starting final batch to recover 46576 pages from redo log.

2021-11-19T09:16:35.000+02:00	2021-11-19 7:16:35 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 236 row operations to undo

2021-11-19T09:16:35.000+02:00	2021-11-19 7:16:35 0 [Note] InnoDB: Trx id counter is 158831434

2021-11-19T09:16:35.000+02:00	2021-11-19 7:16:35 0 [Note] InnoDB: Starting final batch to recover 46576 pages from redo log.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.128812', position 8183837

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: 128 rollback segments are active.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: To roll back: 1 transactions, 236 rows

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables

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

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

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: 10.5.12 started; log sequence number 16083587393123; transaction id 158831435

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-11-19T09:16:54.000+02:00	211119 7:16:54 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-11-19T09:16:54.000+02:00	211119 7:16:54 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Starting crash recovery...

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Crash recovery finished.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Server socket created on IP: '::'.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Reading of all Master_info entries succeeded

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Added new Master_info '' to hash table

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Warning] Recovery from master pos 1230991 and file p2-cds-db-1a-db01.329696.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.12-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Rolled back recovered transaction 158831433

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Rollback of non-prepared transactions completed

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Last binlog file '/rdsdbdata/log/binlog/mysql-bin-changelog.128812', position 8183837

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: 128 rollback segments are active.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Starting in background the rollback of recovered transactions

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: To roll back: 1 transactions, 236 rows

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables

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

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

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: 10.5.12 started; log sequence number 16083587393123; transaction id 158831435

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Loading buffer pool(s) from /rdsdbdata/db/innodb/ib_buffer_pool

2021-11-19T09:16:54.000+02:00	211119 7:16:54 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED.

2021-11-19T09:16:54.000+02:00	211119 7:16:54 server_audit: logging started to the file /rdsdbdata/log/audit/server_audit.log.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Recovering after a crash using /rdsdbdata/log/binlog/mysql-bin-changelog

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Starting crash recovery...

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Crash recovery finished.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Server socket created on IP: '::'.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Warning] 'proxies_priv' entry '@% root@ip-10-36-139-116' ignored in --skip-name-resolve mode.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 2 [Note] Event Scheduler: scheduler thread started with id 2

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Reading of all Master_info entries succeeded

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] Added new Master_info '' to hash table

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Warning] Recovery from master pos 1230991 and file p2-cds-db-1a-db01.329696.

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] /rdsdbbin/mysql/bin/mysqld: ready for connections. Version: '10.5.12-MariaDB-log' socket: '/tmp/mysql.sock' port: 13336 managed by https://aws.amazon.com/rds/

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Rolled back recovered transaction 158831433

2021-11-19T09:16:54.000+02:00	2021-11-19 7:16:54 0 [Note] InnoDB: Rollback of non-prepared transactions completed

2021-11-19T09:17:00.000+02:00	2021-11-19 7:17:00 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error reading communication packets)

2021-11-19T09:17:00.000+02:00	2021-11-19 7:17:00 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error reading communication packets)

2021-11-19T09:25:38.000+02:00	2021-11-19 7:25:38 0 [Note] InnoDB: Buffer pool(s) load completed at 211119 7:25:38

2021-11-19T09:25:38.000+02:00	2021-11-19 7:25:38 0 [Note] InnoDB: Buffer pool(s) load completed at 211119 7:25:38