=====================================
2023-02-17 18:10:54 0x7f6ba0db5700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 20 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 85391 srv_active, 0 srv_shutdown, 14706 srv_idle
srv_master_thread log flush and writes: 100088
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 2945688
--Thread 140099858478848 has waited at row0uins.cc line 283 for 794.00 seconds the semaphore:
SX-lock on RW-latch at 0x55f7f4f8a950 created in file dict0dict.cc line 2130
a writer (thread id 140100228564736) has reserved it in mode  SX
number of readers 0, waiters flag 1, lock_word: 10000000
Last time write locked in file dict0stats.cc line 1969
--Thread 140099847419648 has waited at row0undo.cc line 295 for 780.00 seconds the semaphore:
S-lock on RW-latch at 0x55f7eadf7fe0 created in file dict0dict.cc line 920
a writer (thread id 140100211779328) has reserved it in mode  wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffd
Last time write locked in file srv0srv.cc line 2029
--Thread 140100194993920 has waited at btr0cur.cc line 1357 for 794.00 seconds the semaphore:
SX-lock on RW-latch at 0x55f7f4f8a950 created in file dict0dict.cc line 2130
a writer (thread id 140100228564736) has reserved it in mode  SX
number of readers 0, waiters flag 1, lock_word: 10000000
Last time write locked in file dict0stats.cc line 1969
--Thread 140100211779328 has waited at srv0srv.cc line 2029 for 952.00 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x55f7eadf7fe0 created in file dict0dict.cc line 920
a writer (thread id 140100211779328) has reserved it in mode  wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffd
Last time write locked in file srv0srv.cc line 2029
--Thread 140100178208512 has waited at btr0cur.cc line 1357 for 794.00 seconds the semaphore:
SX-lock on RW-latch at 0x55f7f4f8a950 created in file dict0dict.cc line 2130
a writer (thread id 140100228564736) has reserved it in mode  SX
number of readers 0, waiters flag 1, lock_word: 10000000
Last time write locked in file dict0stats.cc line 1969
--Thread 140100203386624 has waited at row0purge.cc line 1065 for 794.00 seconds the semaphore:
S-lock on RW-latch at 0x55f7eadf7fe0 created in file dict0dict.cc line 920
a writer (thread id 140100211779328) has reserved it in mode  wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffd
Last time write locked in file srv0srv.cc line 2029
--Thread 140099860629248 has waited at row0undo.cc line 295 for 694.00 seconds the semaphore:
S-lock on RW-latch at 0x55f7eadf7fe0 created in file dict0dict.cc line 920
a writer (thread id 140100211779328) has reserved it in mode  wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffd
Last time write locked in file srv0srv.cc line 2029
--Thread 140100186601216 has waited at row0purge.cc line 1065 for 794.00 seconds the semaphore:
S-lock on RW-latch at 0x55f7eadf7fe0 created in file dict0dict.cc line 920
a writer (thread id 140100211779328) has reserved it in mode  wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffd
Last time write locked in file srv0srv.cc line 2029
--Thread 140099842504448 has waited at row0undo.cc line 295 for 947.00 seconds the semaphore:
S-lock on RW-latch at 0x55f7eadf7fe0 created in file dict0dict.cc line 920
a writer (thread id 140100211779328) has reserved it in mode  wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffd
Last time write locked in file srv0srv.cc line 2029
OS WAIT ARRAY INFO: signal count 2594878
RW-shared spins 1864761, rounds 13391790, OS waits 171011
RW-excl spins 1597893, rounds 11544944, OS waits 124439
RW-sx spins 132024, rounds 2301264, OS waits 50674
Spin rounds per wait: 7.18 RW-shared, 7.23 RW-excl, 17.43 RW-sx




*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 5551824563
Purge done for trx's n:o < 5551814473 undo n:o < 67395 state: running
History list length 4671
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421582723200560, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723230072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723301744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723225856, ACTIVE 49 sec
0 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 14490, OS thread handle 140099956922112, query id 117667597 XXX.XX.30.50 wtapp 
Trx read view will not see trx with id >= 5551823085, sees < 5551814492
---TRANSACTION 421582723192128, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723335472, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723487248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723440872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723478816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723432440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723318608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723175264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723369200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723512544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723322824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723508328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723504112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723327040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723305960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723204776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723495680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723483032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723196344, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 5551819386, ACTIVE 714 sec rollback
ROLLING BACK 5 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 267
MySQL thread id 14395, OS thread handle 140099860629248, query id 117412633 XXX.YY.20.164 wtapp Init
ROLLBACK
Trx read view will not see trx with id >= 5551819372, sees < 5551814492
---TRANSACTION 421582723297528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 5551818983, ACTIVE 831 sec rollback
ROLLING BACK 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 2
MySQL thread id 14379, OS thread handle 140099847419648, query id 117379426 XXX.YY.20.21 wtapp Init
ROLLBACK
Trx read view will not see trx with id >= 5551818983, sees < 5551814492
---TRANSACTION 421582723284880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723268016, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723242720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 5551817485, ACTIVE 1105 sec rollback
ROLLING BACK 1 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 14346, OS thread handle 140099858478848, query id 117295230 XXX.YYY.195.39 APIREST Reset for next command
Trx read view will not see trx with id >= 5551817485, sees < 5551814492
---TRANSACTION 421582723238504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 5551814492, ACTIVE 1592 sec rollback
ROLLING BACK 3 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 3
MySQL thread id 14252, OS thread handle 140099842504448, query id 117300518 XXX.YY.20.21 wtapp Reset for next command
Trx read view will not see trx with id >= 5551814492, sees < 5551814492
---TRANSACTION 421582723381848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723179480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723310176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723221640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723154184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723171048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723183696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723289096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723276448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723343904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723162616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723386064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723377632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723187912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723499896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723394496, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723208992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723293312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723516760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723390280, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723217424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723360768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723554704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723424008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723158400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723647456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723643240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723259584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723234288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723436656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723364984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723314392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723373416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723533624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723655888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723639024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723634808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723449304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723474600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723149968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723255368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421582723166832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
 ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
19770786 OS file reads, 10511815 OS file writes, 3367378 OS fsyncs
1 pending reads, 0 pending writes
284.49 reads/s, 16384 avg bytes/read, 14.70 writes/s, 13.75 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 128, free list len 10297, seg size 10426, 855929 merges
merged operations:
 insert 1629822, delete mark 753776, delete 22082
discarded operations:
 insert 9, delete mark 0, delete 0
Hash table size 1593833, node heap has 175 buffer(s)
Hash table size 1593833, node heap has 93 buffer(s)
Hash table size 1593833, node heap has 48 buffer(s)
Hash table size 1593833, node heap has 38 buffer(s)
Hash table size 1593833, node heap has 923 buffer(s)
Hash table size 1593833, node heap has 75 buffer(s)
Hash table size 1593833, node heap has 653 buffer(s)
Hash table size 1593833, node heap has 4199 buffer(s)
5563.02 hash searches/s, 1500.37 non-hash searches/s
---
LOG
---
Log sequence number 6054370985131
Log flushed up to   6054370985131
Pages flushed up to 6054370729925
Last checkpoint at  6054346591851
0 pending log flushes, 0 pending chkp writes
498339 log i/o's done, 6.25 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 6846152704
Dictionary memory allocated 1422288
Buffer pool size   393216
Free buffers       3973
Database pages     383039
Old database pages 141378
Modified db pages  563
Percent of dirty pages(LRU & free pages): 0.145
Max dirty pages percent: 75.000
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 8973228, not young 491212031
2.85 youngs/s, 318.83 non-youngs/s
Pages read 19769923, created 406644, written 9289624
284.49 reads/s, 0.40 creates/s, 5.10 writes/s
Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 11 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 383039, unzip_LRU len: 0
I/O sum[1025080]:cur[37336], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   98304
Free buffers       980
Database pages     95771
Old database pages 35355
Modified db pages  246
Percent of dirty pages(LRU & free pages): 0.254
Max dirty pages percent: 75.000
Pending reads 1
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2266905, not young 128461185
0.45 youngs/s, 83.20 non-youngs/s
Pages read 4956281, created 107394, written 2607085
74.90 reads/s, 0.25 creates/s, 1.30 writes/s
Buffer pool hit rate 986 / 1000, young-making rate 0 / 1000 not 14 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 95771, unzip_LRU len: 0
I/O sum[256270]:cur[9334], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   98304
Free buffers       990
Database pages     95744
Old database pages 35340
Modified db pages  87
Percent of dirty pages(LRU & free pages): 0.090
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2283025, not young 125594712
0.75 youngs/s, 75.90 non-youngs/s
Pages read 4934031, created 100195, written 2207152
69.50 reads/s, 0.10 creates/s, 1.30 writes/s
Buffer pool hit rate 991 / 1000, young-making rate 0 / 1000 not 9 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 95744, unzip_LRU len: 0
I/O sum[256270]:cur[9334], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   98304
Free buffers       1002
Database pages     95815
Old database pages 35361
Modified db pages  65
Percent of dirty pages(LRU & free pages): 0.067
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2210209, not young 111553666
0.55 youngs/s, 77.85 non-youngs/s
Pages read 4931251, created 97904, written 2137617
66.30 reads/s, 0.00 creates/s, 1.25 writes/s
Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 12 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 95815, unzip_LRU len: 0
I/O sum[256270]:cur[9334], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   98304
Free buffers       1001
Database pages     95709
Old database pages 35322
Modified db pages  165
Percent of dirty pages(LRU & free pages): 0.171
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2213089, not young 125602468
1.10 youngs/s, 81.90 non-youngs/s
Pages read 4948360, created 101151, written 2337770
73.80 reads/s, 0.05 creates/s, 1.25 writes/s
Buffer pool hit rate 990 / 1000, young-making rate 0 / 1000 not 10 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 95709, unzip_LRU len: 0
I/O sum[256270]:cur[9334], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
5 read views open inside InnoDB
Process ID=31916, Main thread ID=140100211779328, state: enforcing dict cache limit
Number of rows inserted 9252247, updated 5750807, deleted 5984114, read 11479577727
3.90 inserts/s, 41.10 updates/s, 0.50 deletes/s, 19895.81 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
InnoDB: ###### Diagnostic info printed to the standard error stream
2023-02-17 18:10:55 0 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.
230217 18:10:55 [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.3.27-MariaDB-0+deb10u1
key_buffer_size=268435456
read_buffer_size=131072
max_used_connections=157
max_threads=202
thread_count=117
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 706224 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 0x49000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55f7ea60e91e]
/usr/sbin/mysqld(handle_fatal_signal+0x54d)[0x55f7ea13d2ed]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7f6d62f6c730]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x10b)[0x7f6d625297bb]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x121)[0x7f6d62514535]
/usr/sbin/mysqld(+0x4e48c3)[0x55f7e9e818c3]
/usr/sbin/mysqld(+0x4daff0)[0x55f7e9e77ff0]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7fa3)[0x7f6d62f61fa3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f6d625eb4cf]
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 /var/lib/mysql
Resource Limits:
Fatal signal 11 while backtracing
2023-02-17 18:11:02 0 [Note] InnoDB: Using Linux native AIO
2023-02-17 18:11:02 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-02-17 18:11:02 0 [Note] InnoDB: Uses event mutexes
2023-02-17 18:11:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-02-17 18:11:02 0 [Note] InnoDB: Number of pools: 1
2023-02-17 18:11:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-02-17 18:11:03 0 [Note] InnoDB: Initializing buffer pool, total size = 6G, instances = 4, chunk size = 128M
2023-02-17 18:11:03 0 [Note] InnoDB: Completed initialization of buffer pool
2023-02-17 18:11:03 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-02-17 18:11:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6054346973633
2023-02-17 18:11:04 0 [Note] InnoDB: 4 transaction(s) which must be rolled back or cleaned up in total 276 row operations to undo
2023-02-17 18:11:04 0 [Note] InnoDB: Trx id counter is 5551824587
2023-02-17 18:11:04 0 [Note] InnoDB: Starting final batch to recover 7160 pages from redo log.
2023-02-17 18:11:18 0 [Note] InnoDB: To recover: 1764 pages from log
2023-02-17 18:11:22 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2023-02-17 18:11:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-02-17 18:11:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-02-17 18:11:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-02-17 18:11:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-02-17 18:11:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-02-17 18:11:22 0 [Note] InnoDB: 10.3.27 started; log sequence number 6054370990672; transaction id 5551824588
2023-02-17 18:11:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-02-17 18:11:22 0 [Note] Recovering after a crash using tc.log
2023-02-17 18:11:22 0 [Note] Starting crash recovery...
2023-02-17 18:11:22 0 [Note] Crash recovery finished.
2023-02-17 18:11:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-02-17 18:11:22 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-02-17 18:11:22 0 [ERROR] mysqld: Table './mysql/event' is marked as crashed and should be repaired
2023-02-17 18:11:22 0 [Warning] Checking table:   './mysql/event'
2023-02-17 18:11:22 0 [ERROR] mysql.event: 1 client is using or hasn't closed the table properly
2023-02-17 18:11:22 6 [Note] Event Scheduler: scheduler thread started with id 6
2023-02-17 18:11:22 0 [Note] Reading of all Master_info entries succeeded
2023-02-17 18:11:22 0 [Note] Added new Master_info '' to hash table
2023-02-17 18:11:22 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.27-MariaDB-0+deb10u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 10
2023-02-17 18:11:23 10 [Warning] IP address 'XXX.YY.20.21' could not be resolved: Name or service not known
2023-02-17 18:11:23 9 [Warning] IP address 'XXX.YY.20.54' could not be resolved: Name or service not known
2023-02-17 18:11:23 0 [Note] InnoDB: Rolled back recovered transaction 5551814492
2023-02-17 18:11:23 0 [Note] InnoDB: Rolled back recovered transaction 5551818983
2023-02-17 18:11:23 14 [Warning] IP address 'XXX.XX.30.50' could not be resolved: Name or service not known
2023-02-17 18:11:23 11 [ERROR] mysqld: Table './esbodbhq/dump_mapeoimportlin' is marked as crashed and should be repaired
2023-02-17 18:11:23 11 [Warning] Checking table:   './esbodbhq/dump_mapeoimportlin'
2023-02-17 18:11:23 10 [ERROR] mysqld: Table './esbodbhq/dump_controlarchivos' is marked as crashed and should be repaired
2023-02-17 18:11:23 10 [Warning] Checking table:   './esbodbhq/dump_controlarchivos'
2023-02-17 18:11:23 16 [Warning] IP address 'XXX.XX.20.79' could not be resolved: Name or service not known
2023-02-17 18:11:23 17 [Warning] IP address 'XXX.XX.20.81' could not be resolved: Name or service not known
2023-02-17 18:11:24 22 [Warning] IP address 'XXX.XX.20.113' could not be resolved: Name or service not known
2023-02-17 18:11:24 0 [Note] InnoDB: Rolled back recovered transaction 5551819386
2023-02-17 18:11:24 0 [Note] InnoDB: Rolled back recovered transaction 5551817485
2023-02-17 18:11:24 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2023-02-17 18:11:25 26 [Warning] IP address 'XXX.YY.20.119' could not be resolved: Name or service not known
2023-02-17 18:11:25 26 [ERROR] mysqld: Table './esbodbhq/agenciastransporte' is marked as crashed and should be repaired
2023-02-17 18:11:25 26 [Warning] Checking table:   './esbodbhq/agenciastransporte'
2023-02-17 18:11:28 29 [Warning] IP address 'XXX.XX.20.120' could not be resolved: Name or service not known
2023-02-17 18:11:28 17 [ERROR] mysqld: Table './esbodbhq/clientesagencias' is marked as crashed and should be repaired
2023-02-17 18:11:28 17 [Warning] Checking table:   './esbodbhq/clientesagencias'
2023-02-17 18:11:28 31 [Warning] IP address 'XXX.XX.20.121' could not be resolved: Name or service not known
2023-02-17 18:11:29 32 [Warning] IP address 'XXX.XX.20.124' could not be resolved: Name or service not known
2023-02-17 18:11:30 34 [Warning] IP address 'XXX.YY.20.20' could not be resolved: Name or service not known
2023-02-17 18:11:40 40 [Warning] IP address 'XXX.XX.20.123' could not be resolved: Name or service not known
2023-02-17 18:11:43 42 [Warning] IP address 'XXX.XX.20.77' could not be resolved: Name or service not known
2023-02-17 18:11:46 44 [Warning] IP address 'XXX.XX.21.205' could not be resolved: Name or service not known
2023-02-17 18:11:59 40 [ERROR] mysqld: Table './esbodbhq/camionesentrada' is marked as crashed and should be repaired
2023-02-17 18:11:59 40 [Warning] Checking table:   './esbodbhq/camionesentrada'
2023-02-17 18:12:02 48 [ERROR] mysqld: Table './esbodbhq/dump_mapeoexportcab' is marked as crashed and should be repaired
2023-02-17 18:12:02 48 [Warning] Checking table:   './esbodbhq/dump_mapeoexportcab'
2023-02-17 18:12:43 102 [ERROR] mysqld: Table './esbodbhq/destinatarios' is marked as crashed and should be repaired
2023-02-17 18:12:43 102 [Warning] Checking table:   './esbodbhq/destinatarios'
2023-02-17 18:12:50 103 [Warning] IP address 'XXX.YYY.195.39' could not be resolved: Name or service not known
2023-02-17 18:13:14 108 [Warning] IP address 'XXX.YY.20.162' could not be resolved: Name or service not known
2023-02-17 18:13:15 109 [Warning] IP address 'XXX.YY.20.155' could not be resolved: Name or service not known
2023-02-17 18:13:16 124 [ERROR] mysqld: Table './esbodbhq/diarioexotec' is marked as crashed and should be repaired
2023-02-17 18:13:16 124 [Warning] Checking table:   './esbodbhq/diarioexotec'
2023-02-17 18:13:16 129 [ERROR] mysqld: Table './esbodbhq/camionessalida' is marked as crashed and should be repaired
2023-02-17 18:13:16 129 [Warning] Checking table:   './esbodbhq/camionessalida'
2023-02-17 18:13:16 150 [ERROR] mysqld: Table './esbodbhq/camionessalidafiltro' is marked as crashed and should be repaired
2023-02-17 18:13:16 150 [Warning] Checking table:   './esbodbhq/camionessalidafiltro'
2023-02-17 18:13:17 151 [ERROR] mysqld: Table './esbodbhq/diarioreferencias' is marked as crashed and should be repaired
2023-02-17 18:13:17 151 [Warning] Checking table:   './esbodbhq/diarioreferencias'
2023-02-17 18:14:15 155 [Warning] IP address 'XXX.XX.21.127' could not be resolved: Name or service not known
2023-02-17 18:14:38 159 [Warning] IP address 'XXX.XX.20.117' could not be resolved: Name or service not known
2023-02-17 18:14:45 160 [Warning] IP address 'XXX.YY.20.182' could not be resolved: Name or service not known
2023-02-17 18:14:50 161 [Warning] IP address 'XXX.YY.20.169' could not be resolved: Name or service not known
2023-02-17 18:16:21 171 [Warning] IP address 'XXX.YY.20.196' could not be resolved: Name or service not known
2023-02-17 18:16:25 0 [Note] InnoDB: Buffer pool(s) load completed at 230217 18:16:25
2023-02-17 18:18:10 189 [Warning] IP address 'XXX.YY.20.164' could not be resolved: Name or service not known
2023-02-17 18:18:13 191 [Warning] IP address 'XXX.YY.20.8' could not be resolved: Name or service not known
2023-02-17 18:18:46 194 [Warning] IP address 'XXX.YY.20.197' could not be resolved: Name or service not known
2023-02-17 18:18:59 196 [Warning] IP address 'XXX.YY.20.163' could not be resolved: Name or service not known
2023-02-17 18:23:40 216 [Warning] IP address 'XXX.YY.20.180' could not be resolved: Name or service not known
2023-02-17 18:26:45 228 [Warning] IP address 'XXX.JJ.20.138' could not be resolved: Name or service not known
2023-02-17 18:31:50 260 [Warning] IP address 'XXX.YY.20.157' could not be resolved: Name or service not known
2023-02-17 18:32:38 260 [Warning] Aborted connection 260 to db: 'esbodbhq' user: 'wtapp' host: 'XXX.YY.20.157' (Got an error reading communication packets)
2023-02-17 18:33:24 272 [Warning] IP address 'XXX.YY.20.160' could not be resolved: Name or service not known
2023-02-17 18:36:26 279 [Warning] Aborted connection 279 to db: 'esbodbhq' user: 'wtapp' host: 'XXX.XX.20.117' (Got an error reading communication packets)
2023-02-17 18:36:52 289 [Warning] IP address 'XXX.YY.20.179' could not be resolved: Name or service not known
2023-02-17 18:47:44 352 [Warning] IP address 'XXX.YY.20.151' could not be resolved: Name or service not known
2023-02-17 18:50:03 363 [Warning] IP address 'XXX.YY.20.175' could not be resolved: Name or service not known
2023-02-17 18:56:05 410 [Warning] IP address 'XXX.XX.21.64' could not be resolved: Name or service not known
2023-02-17 19:00:23 467 [Warning] Aborted connection 467 to db: 'esbodbhq' user: 'wtapp' host: 'XXX.YY.20.169' (Got an error reading communication packets)
2023-02-17 19:04:02 506 [Warning] IP address 'XXX.YY.20.190' could not be resolved: Name or service not known
2023-02-17 19:10:04 539 [Warning] Aborted connection 539 to db: 'esbodbhq' user: 'wtapp' host: 'XXX.XX.20.117' (Got an error writing communication packets)
2023-02-17 19:22:06 602 [Warning] IP address 'XXX.XX.30.13' could not be resolved: Name or service not known
2023-02-17 19:24:59 611 [Warning] IP address 'XXX.XX.21.36' could not be resolved: Name or service not known
2023-02-17 19:26:19 618 [Warning] IP address 'XXX.XX.30.12' could not be resolved: Name or service not known
2023-02-17 19:45:55 735 [Warning] Aborted connection 735 to db: 'esbodbhq' user: 'wtapp' host: 'XXX.YY.20.151' (Got an error reading communication packets)
2023-02-17 19:55:08 785 [Warning] IP address 'XXX.JJ.20.193' could not be resolved: Name or service not known
2023-02-17 20:04:31 852 [Warning] IP address 'XXX.JJ.20.166' could not be resolved: Name or service not known
2023-02-17 20:05:35 861 [Warning] IP address 'XXX.XX.20.86' could not be resolved: Name or service not known
2023-02-17 20:12:44 898 [Warning] IP address 'XXX.XX.20.72' could not be resolved: Name or service not known
2023-02-17 20:31:22 1003 [Warning] IP address 'XXX.XX.20.15' could not be resolved: Name or service not known
2023-02-17 20:44:35 1064 [Warning] IP address 'XXX.YY.20.186' could not be resolved: Name or service not known
2023-02-17 21:28:28 579 [Warning] Aborted connection 579 to db: 'esbodbhq' user: 'wtapp' host: 'XXX.XX.21.64' (Got timeout reading communication packets)
2023-02-17 21:38:23 1374 [Warning] IP address 'XXX.XX.21.81' could not be resolved: Name or service not known
2023-02-17 22:12:40 1562 [Warning] IP address 'XXX.YY.20.191' could not be resolved: Name or service not known
2023-02-17 22:31:33 916 [Warning] Aborted connection 916 to db: 'esbodbhq' user: 'wtapp' host: 'XXX.JJ.20.193' (Got timeout reading communication packets)
2023-02-17 22:48:45 1008 [Warning] Aborted connection 1008 to db: 'esbodbhq' user: 'wtapp' host: 'XXX.JJ.20.138' (Got timeout reading communication packets)
2023-02-17 23:55:01 1937 [ERROR] Event Scheduler: [root@%][esbodbhq.ejecuta_desasignacionpicking] Can't create/write to file '/usr/clispool/DesasignacionPicking/DESAPICK_20230217235501.csv' (Errcode: 2 "No such file or directory")
2023-02-17 23:55:01 1937 [Note] Event Scheduler: [root@%][esbodbhq.ejecuta_desasignacionpicking] At line 82 in esbodbhq.DESASIGNA_PICKING
2023-02-17 23:55:01 1937 [Note] Event Scheduler: [root@%][esbodbhq.ejecuta_desasignacionpicking] At line 1 in esbodbhq.ejecuta_desasignacionpicking
2023-02-17 23:55:01 1937 [Note] Event Scheduler: [root@%].[esbodbhq.ejecuta_desasignacionpicking] event execution failed.