since around 10 days I try to recover my crashed forum. It consists of around a million posts (in sum 3GB). I use a Debian 10 server on the command line.
Restoring via "mysql -u dbadmin -p < dump.sql" results in an intended crash of the database due to a high semaphore wait.
I could figure out that it crashes when trying to insert further posting to the phpbb_posts table.
INSERT INTO `phpbb_posts` VALUES (2471499,303816,265,14758,0, [...]
These inserts seem to push a whole thread at once into the database (a single insert line is around 1023kB big). Also extracting one insert and doing it by hand results in the same crash. Also using a different insert results in the same, so it should be a problem with a single insert line. Looks like the phpbb_posts is full in some way. Disk space is just half used.
Is there a way to check further things? I attach the latest output for the mysql syslog part. I really really would appreciate any hints, since I am now at the end of my knowledge (although I'd say I'm quite experienced with Linux, doing this for over 20 years).
Rolf
Code: Select all
Aug 19 08:12:06 lena mysqld[13983]: --------
Aug 19 08:12:06 lena mysqld[13983]: FILE I/O
Aug 19 08:12:06 lena mysqld[13983]: --------
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 1 state: waiting for completed aio requests (log thread)
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 2 state: waiting for completed aio requests (read thread)
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 3 state: waiting for completed aio requests (read thread)
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 4 state: waiting for completed aio requests (read thread)
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 5 state: waiting for completed aio requests (read thread)
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 6 state: waiting for completed aio requests (write thread)
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 7 state: waiting for completed aio requests (write thread)
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 8 state: waiting for completed aio requests (write thread)
Aug 19 08:12:06 lena mysqld[13983]: I/O thread 9 state: waiting for completed aio requests (write thread)
Aug 19 08:12:06 lena mysqld[13983]: Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
Aug 19 08:12:06 lena mysqld[13983]: ibuf aio reads:, log i/o's:, sync i/o's:
Aug 19 08:12:06 lena mysqld[13983]: Pending flushes (fsync) log: 0; buffer pool: 0
Aug 19 08:12:06 lena mysqld[13983]: 62480 OS file reads, 52942 OS file writes, 9221 OS fsyncs
Aug 19 08:12:06 lena mysqld[13983]: 0 pending reads, 2 pending writes
Aug 19 08:12:06 lena mysqld[13983]: 19.55 reads/s, 16384 avg bytes/read, 23.65 writes/s, 5.60 fsyncs/s
Aug 19 08:12:06 lena mysqld[13983]: -------------------------------------
Aug 19 08:12:06 lena mysqld[13983]: INSERT BUFFER AND ADAPTIVE HASH INDEX
Aug 19 08:12:06 lena mysqld[13983]: -------------------------------------
Aug 19 08:12:06 lena mysqld[13983]: Ibuf: size 1, free list len 1078, seg size 1080, 237 merges
Aug 19 08:12:06 lena mysqld[13983]: merged operations:
Aug 19 08:12:06 lena mysqld[13983]: insert 337, delete mark 0, delete 0
Aug 19 08:12:06 lena mysqld[13983]: discarded operations:
Aug 19 08:12:06 lena mysqld[13983]: insert 0, delete mark 0, delete 0
Aug 19 08:12:06 lena mysqld[13983]: 0.00 hash searches/s, 289.54 non-hash searches/s
Aug 19 08:12:06 lena mysqld[13983]: ---
Aug 19 08:12:06 lena mysqld[13983]: LOG
Aug 19 08:12:06 lena mysqld[13983]: ---
Aug 19 08:12:06 lena mysqld[13983]: Log sequence number 141221000331
Aug 19 08:12:06 lena mysqld[13983]: Log flushed up to 141221000331
Aug 19 08:12:06 lena mysqld[13983]: Pages flushed up to 141209595271
Aug 19 08:12:06 lena mysqld[13983]: Last checkpoint at 141209595271
Aug 19 08:12:06 lena mysqld[13983]: 0 pending log flushes, 0 pending chkp writes
Aug 19 08:12:06 lena mysqld[13983]: 2033 log i/o's done, 1.50 log i/o's/second
Aug 19 08:12:06 lena mysqld[13983]: ----------------------
Aug 19 08:12:06 lena mysqld[13983]: BUFFER POOL AND MEMORY
Aug 19 08:12:06 lena mysqld[13983]: ----------------------
Aug 19 08:12:06 lena mysqld[13983]: Total large memory allocated 169541632
Aug 19 08:12:06 lena mysqld[13983]: Dictionary memory allocated 26496
Aug 19 08:12:06 lena mysqld[13983]: Buffer pool size 8192
Aug 19 08:12:06 lena mysqld[13983]: Free buffers 0
Aug 19 08:12:06 lena mysqld[13983]: Database pages 8192
Aug 19 08:12:06 lena mysqld[13983]: Old database pages 3004
Aug 19 08:12:06 lena mysqld[13983]: Modified db pages 2980
Aug 19 08:12:06 lena mysqld[13983]: Percent of dirty pages(LRU & free pages): 36.373
Aug 19 08:12:06 lena mysqld[13983]: Max dirty pages percent: 75.000
Aug 19 08:12:06 lena mysqld[13983]: Pending reads 0
Aug 19 08:12:06 lena mysqld[13983]: Pending writes: LRU 0, flush list 121, single page 1
Aug 19 08:12:06 lena mysqld[13983]: Pages made young 1522, not young 1855263
Aug 19 08:12:06 lena mysqld[13983]: 0.05 youngs/s, 292.29 non-youngs/s
Aug 19 08:12:06 lena mysqld[13983]: Pages read 62224, created 4585, written 47370
Aug 19 08:12:06 lena mysqld[13983]: 19.55 reads/s, 3.85 creates/s, 20.25 writes/s
Aug 19 08:12:06 lena mysqld[13983]: Buffer pool hit rate 983 / 1000, young-making rate 0 / 1000 not 242 / 1000
Aug 19 08:12:06 lena mysqld[13983]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
Aug 19 08:12:06 lena mysqld[13983]: LRU len: 8192, unzip_LRU len: 0
Aug 19 08:12:06 lena mysqld[13983]: I/O sum[25670]:cur[385], unzip sum[0]:cur[0]
Aug 19 08:12:06 lena mysqld[13983]: --------------
Aug 19 08:12:06 lena mysqld[13983]: ROW OPERATIONS
Aug 19 08:12:06 lena mysqld[13983]: --------------
Aug 19 08:12:06 lena mysqld[13983]: 0 queries inside InnoDB, 0 queries in queue
Aug 19 08:12:06 lena mysqld[13983]: 0 read views open inside InnoDB
Aug 19 08:12:06 lena mysqld[13983]: Process ID=13983, Main thread ID=1979710272, state: sleeping
Aug 19 08:12:06 lena mysqld[13983]: Number of rows inserted 1773, updated 0, deleted 0, read 0
Aug 19 08:12:06 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:12:06 lena mysqld[13983]: Number of system rows inserted 0, updated 0, deleted 0, read 0
Aug 19 08:12:06 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:12:06 lena mysqld[13983]: ----------------------------
Aug 19 08:12:06 lena mysqld[13983]: END OF INNODB MONITOR OUTPUT
Aug 19 08:12:06 lena mysqld[13983]: ============================
Aug 19 08:12:24 lena mysqld[13983]: InnoDB: ###### Diagnostic info printed to the standard error stream
Aug 19 08:12:25 lena mysqld[13983]: 2021-08-19 8:12:25 0 [Warning] InnoDB: A long semaphore wait:
Aug 19 08:12:25 lena mysqld[13983]: --Thread 2141190976 has waited at fts0fts.cc line 3523 for 892.00 seconds the semaphore:
Aug 19 08:12:25 lena mysqld[13983]: X-lock on RW-latch at 0x328e408 created in file fts0fts.cc line 616
Aug 19 08:12:25 lena mysqld[13983]: a writer (thread id 1994373952) has reserved it in mode exclusive
Aug 19 08:12:25 lena mysqld[13983]: number of readers 0, waiters flag 1, lock_word: 0
Aug 19 08:12:25 lena mysqld[13983]: Last time write locked in file fts0fts.cc line 4278
Aug 19 08:12:25 lena mysqld[13983]: 2021-08-19 8:12:25 0 [Note] InnoDB: A semaphore wait:
Aug 19 08:12:25 lena mysqld[13983]: --Thread 2141190976 has waited at fts0fts.cc line 3523 for 892.00 seconds the semaphore:
Aug 19 08:12:25 lena mysqld[13983]: X-lock on RW-latch at 0x328e408 created in file fts0fts.cc line 616
Aug 19 08:12:25 lena mysqld[13983]: a writer (thread id 1994373952) has reserved it in mode exclusive
Aug 19 08:12:25 lena mysqld[13983]: number of readers 0, waiters flag 1, lock_word: 0
Aug 19 08:12:25 lena mysqld[13983]: Last time write locked in file fts0fts.cc line 4278
Aug 19 08:12:25 lena mysqld[13983]: InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
Aug 19 08:12:25 lena mysqld[13983]: InnoDB: Pending reads 0, writes 2
Aug 19 08:12:26 lena mysqld[13983]: =====================================
Aug 19 08:12:26 lena mysqld[13983]: 2021-08-19 08:12:26 0x77dfdb40 INNODB MONITOR OUTPUT
Aug 19 08:12:26 lena mysqld[13983]: =====================================
Aug 19 08:12:26 lena mysqld[13983]: Per second averages calculated from the last 20 seconds
Aug 19 08:12:26 lena mysqld[13983]: -----------------
Aug 19 08:12:26 lena mysqld[13983]: BACKGROUND THREAD
Aug 19 08:12:26 lena mysqld[13983]: -----------------
Aug 19 08:12:26 lena mysqld[13983]: srv_master_thread loops: 336 srv_active, 0 srv_shutdown, 50155 srv_idle
Aug 19 08:12:26 lena mysqld[13983]: srv_master_thread log flush and writes: 50472
Aug 19 08:12:26 lena mysqld[13983]: ----------
Aug 19 08:12:26 lena mysqld[13983]: SEMAPHORES
Aug 19 08:12:26 lena mysqld[13983]: ----------
Aug 19 08:12:26 lena mysqld[13983]: OS WAIT ARRAY INFO: reservation count 9172
Aug 19 08:12:26 lena mysqld[13983]: --Thread 2141190976 has waited at fts0fts.cc line 3523 for 893.00 seconds the semaphore:
Aug 19 08:12:26 lena mysqld[13983]: X-lock on RW-latch at 0x328e408 created in file fts0fts.cc line 616
Aug 19 08:12:26 lena mysqld[13983]: a writer (thread id 1994373952) has reserved it in mode exclusive
Aug 19 08:12:26 lena mysqld[13983]: number of readers 0, waiters flag 1, lock_word: 0
Aug 19 08:12:26 lena mysqld[13983]: Last time write locked in file fts0fts.cc line 4278
Aug 19 08:12:26 lena mysqld[13983]: OS WAIT ARRAY INFO: signal count 9205
Aug 19 08:12:26 lena mysqld[13983]: RW-shared spins 11067, rounds 303179, OS waits 8414
Aug 19 08:12:26 lena mysqld[13983]: RW-excl spins 11094, rounds 26262, OS waits 163
Aug 19 08:12:26 lena mysqld[13983]: RW-sx spins 21, rounds 630, OS waits 21
Aug 19 08:12:26 lena mysqld[13983]: Spin rounds per wait: 27.39 RW-shared, 2.37 RW-excl, 30.00 RW-sx
Aug 19 08:12:26 lena mysqld[13983]: ------------
Aug 19 08:12:26 lena mysqld[13983]: TRANSACTIONS
Aug 19 08:12:26 lena mysqld[13983]: ------------
Aug 19 08:12:26 lena mysqld[13983]: Trx id counter 72059950460843817
Aug 19 08:12:26 lena mysqld[13983]: Purge done for trx's n:o < 72059950460843747 undo n:o < 0 state: running but idle
Aug 19 08:12:26 lena mysqld[13983]: History list length 54
Aug 19 08:12:26 lena mysqld[13983]: LIST OF TRANSACTIONS FOR EACH SESSION:
Aug 19 08:12:26 lena mysqld[13983]: ---TRANSACTION 72059950460843816, ACTIVE 893 sec doing SYNC index
Aug 19 08:12:26 lena mysqld[13983]: 4 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 321464
Aug 19 08:12:26 lena mysqld[13983]: ---TRANSACTION 72059950460843815, ACTIVE 893 sec
Aug 19 08:12:26 lena mysqld[13983]: 0 lock struct(s), heap size 1080, 0 row lock(s)
Aug 19 08:12:26 lena mysqld[13983]: ---TRANSACTION 72059950460843814, ACTIVE 893 sec committing
Aug 19 08:12:26 lena mysqld[13983]: mysql tables in use 1, locked 1
Aug 19 08:12:26 lena mysqld[13983]: 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1773
Aug 19 08:12:26 lena mysqld[13983]: MySQL thread id 379, OS thread handle 2141190976, query id 811 localhost root Commit
Aug 19 08:12:26 lena mysqld[13983]: INSERT INTO `phpbb_posts` VALUES (2831604,341776,220,13332,0,'94.211.53.136',1393408041,0,1,1,1,0,'Blueshark','AW: Ankerblech vorne 2er scirocco','<r><QUOTE author=\"Black Thunder\"><s>[quote=\"Black Thunder\"]</s>Kleiner Nachtrag zu den <B><s>[b]</s>hinteren<e>[/b]</e></B> Ankerplatten: die scheinen tatsächlich auch am Polo zu passen. Und nicht nur dass:<br/>\n<br/>\n <B><s>[b]</s>6N0 609 425 A<e>[/b]</e></B><br/>\n <I><s>[i]</s>Bremsankerplatte hinten links<br/>\n für Trommelbremse / Belag 180 x 30 mm<br/>\n VW Golf I 4/82 - 7/83 (ab 17-C-694 102 >)<br/>\n VW Jet
Aug 19 08:12:26 lena mysqld[13983]: --------
Aug 19 08:12:26 lena mysqld[13983]: FILE I/O
Aug 19 08:12:26 lena mysqld[13983]: --------
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 1 state: waiting for completed aio requests (log thread)
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 2 state: waiting for completed aio requests (read thread)
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 3 state: waiting for completed aio requests (read thread)
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 4 state: waiting for completed aio requests (read thread)
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 5 state: waiting for completed aio requests (read thread)
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 6 state: waiting for completed aio requests (write thread)
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 7 state: waiting for completed aio requests (write thread)
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 8 state: waiting for completed aio requests (write thread)
Aug 19 08:12:26 lena mysqld[13983]: I/O thread 9 state: waiting for completed aio requests (write thread)
Aug 19 08:12:26 lena mysqld[13983]: Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
Aug 19 08:12:26 lena mysqld[13983]: ibuf aio reads:, log i/o's:, sync i/o's:
Aug 19 08:12:26 lena mysqld[13983]: Pending flushes (fsync) log: 0; buffer pool: 0
Aug 19 08:12:26 lena mysqld[13983]: 62824 OS file reads, 53457 OS file writes, 9346 OS fsyncs
Aug 19 08:12:26 lena mysqld[13983]: 0 pending reads, 2 pending writes
Aug 19 08:12:26 lena mysqld[13983]: 17.20 reads/s, 16384 avg bytes/read, 25.75 writes/s, 6.25 fsyncs/s
Aug 19 08:12:26 lena mysqld[13983]: -------------------------------------
Aug 19 08:12:26 lena mysqld[13983]: INSERT BUFFER AND ADAPTIVE HASH INDEX
Aug 19 08:12:26 lena mysqld[13983]: -------------------------------------
Aug 19 08:12:26 lena mysqld[13983]: Ibuf: size 1, free list len 1078, seg size 1080, 237 merges
Aug 19 08:12:26 lena mysqld[13983]: merged operations:
Aug 19 08:12:26 lena mysqld[13983]: insert 337, delete mark 0, delete 0
Aug 19 08:12:26 lena mysqld[13983]: discarded operations:
Aug 19 08:12:26 lena mysqld[13983]: insert 0, delete mark 0, delete 0
Aug 19 08:12:26 lena mysqld[13983]: 0.00 hash searches/s, 252.74 non-hash searches/s
Aug 19 08:12:26 lena mysqld[13983]: ---
Aug 19 08:12:26 lena mysqld[13983]: LOG
Aug 19 08:12:26 lena mysqld[13983]: ---
Aug 19 08:12:26 lena mysqld[13983]: Log sequence number 141222591149
Aug 19 08:12:26 lena mysqld[13983]: Log flushed up to 141222591149
Aug 19 08:12:26 lena mysqld[13983]: Pages flushed up to 141211950947
Aug 19 08:12:26 lena mysqld[13983]: Last checkpoint at 141211950947
Aug 19 08:12:26 lena mysqld[13983]: 0 pending log flushes, 0 pending chkp writes
Aug 19 08:12:26 lena mysqld[13983]: 2065 log i/o's done, 1.60 log i/o's/second
Aug 19 08:12:26 lena mysqld[13983]: ----------------------
Aug 19 08:12:26 lena mysqld[13983]: BUFFER POOL AND MEMORY
Aug 19 08:12:26 lena mysqld[13983]: ----------------------
Aug 19 08:12:26 lena mysqld[13983]: Total large memory allocated 169541632
Aug 19 08:12:26 lena mysqld[13983]: Dictionary memory allocated 26496
Aug 19 08:12:26 lena mysqld[13983]: Buffer pool size 8192
Aug 19 08:12:26 lena mysqld[13983]: Free buffers 0
Aug 19 08:12:26 lena mysqld[13983]: Database pages 8192
Aug 19 08:12:26 lena mysqld[13983]: Old database pages 3004
Aug 19 08:12:26 lena mysqld[13983]: Modified db pages 2959
Aug 19 08:12:26 lena mysqld[13983]: Percent of dirty pages(LRU & free pages): 36.116
Aug 19 08:12:26 lena mysqld[13983]: Max dirty pages percent: 75.000
Aug 19 08:12:26 lena mysqld[13983]: Pending reads 0
Aug 19 08:12:26 lena mysqld[13983]: Pending writes: LRU 0, flush list 121, single page 1
Aug 19 08:12:26 lena mysqld[13983]: Pages made young 1528, not young 1860314
Aug 19 08:12:26 lena mysqld[13983]: 0.30 youngs/s, 252.54 non-youngs/s
Aug 19 08:12:26 lena mysqld[13983]: Pages read 62568, created 4671, written 47807
Aug 19 08:12:26 lena mysqld[13983]: 17.20 reads/s, 4.30 creates/s, 21.85 writes/s
Aug 19 08:12:26 lena mysqld[13983]: Buffer pool hit rate 983 / 1000, young-making rate 0 / 1000 not 238 / 1000
Aug 19 08:12:26 lena mysqld[13983]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
Aug 19 08:12:26 lena mysqld[13983]: LRU len: 8192, unzip_LRU len: 0
Aug 19 08:12:26 lena mysqld[13983]: I/O sum[26680]:cur[0], unzip sum[0]:cur[0]
Aug 19 08:12:26 lena mysqld[13983]: --------------
Aug 19 08:12:26 lena mysqld[13983]: ROW OPERATIONS
Aug 19 08:12:26 lena mysqld[13983]: --------------
Aug 19 08:12:26 lena mysqld[13983]: 0 queries inside InnoDB, 0 queries in queue
Aug 19 08:12:26 lena mysqld[13983]: 0 read views open inside InnoDB
Aug 19 08:12:26 lena mysqld[13983]: Process ID=13983, Main thread ID=1979710272, state: sleeping
Aug 19 08:12:26 lena mysqld[13983]: Number of rows inserted 1773, updated 0, deleted 0, read 0
Aug 19 08:12:26 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:12:26 lena mysqld[13983]: Number of system rows inserted 0, updated 0, deleted 0, read 0
Aug 19 08:12:26 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:12:26 lena mysqld[13983]: ----------------------------
Aug 19 08:12:26 lena mysqld[13983]: END OF INNODB MONITOR OUTPUT
Aug 19 08:12:26 lena mysqld[13983]: ============================
Aug 19 08:12:46 lena mysqld[13983]: =====================================
Aug 19 08:12:46 lena mysqld[13983]: 2021-08-19 08:12:46 0x77dfdb40 INNODB MONITOR OUTPUT
Aug 19 08:12:46 lena mysqld[13983]: =====================================
Aug 19 08:12:46 lena mysqld[13983]: Per second averages calculated from the last 20 seconds
Aug 19 08:12:46 lena mysqld[13983]: -----------------
Aug 19 08:12:46 lena mysqld[13983]: BACKGROUND THREAD
Aug 19 08:12:46 lena mysqld[13983]: -----------------
Aug 19 08:12:46 lena mysqld[13983]: srv_master_thread loops: 336 srv_active, 0 srv_shutdown, 50167 srv_idle
Aug 19 08:12:46 lena mysqld[13983]: srv_master_thread log flush and writes: 50484
Aug 19 08:12:46 lena mysqld[13983]: ----------
Aug 19 08:12:46 lena mysqld[13983]: SEMAPHORES
Aug 19 08:12:46 lena mysqld[13983]: ----------
Aug 19 08:12:46 lena mysqld[13983]: OS WAIT ARRAY INFO: reservation count 9234
Aug 19 08:12:46 lena mysqld[13983]: --Thread 2141190976 has waited at fts0fts.cc line 3523 for 913.00 seconds the semaphore:
Aug 19 08:12:46 lena mysqld[13983]: X-lock on RW-latch at 0x328e408 created in file fts0fts.cc line 616
Aug 19 08:12:46 lena mysqld[13983]: a writer (thread id 1994373952) has reserved it in mode exclusive
Aug 19 08:12:46 lena mysqld[13983]: number of readers 0, waiters flag 1, lock_word: 0
Aug 19 08:12:46 lena mysqld[13983]: Last time write locked in file fts0fts.cc line 4278
Aug 19 08:12:46 lena mysqld[13983]: OS WAIT ARRAY INFO: signal count 9266
Aug 19 08:12:46 lena mysqld[13983]: RW-shared spins 11128, rounds 304913, OS waits 8467
Aug 19 08:12:46 lena mysqld[13983]: RW-excl spins 11094, rounds 26262, OS waits 163
Aug 19 08:12:46 lena mysqld[13983]: RW-sx spins 22, rounds 660, OS waits 22
Aug 19 08:12:46 lena mysqld[13983]: Spin rounds per wait: 27.40 RW-shared, 2.37 RW-excl, 30.00 RW-sx
Aug 19 08:12:46 lena mysqld[13983]: ------------
Aug 19 08:12:46 lena mysqld[13983]: TRANSACTIONS
Aug 19 08:12:46 lena mysqld[13983]: ------------
Aug 19 08:12:46 lena mysqld[13983]: Trx id counter 72059950460843817
Aug 19 08:12:46 lena mysqld[13983]: Purge done for trx's n:o < 72059950460843747 undo n:o < 0 state: running but idle
Aug 19 08:12:46 lena mysqld[13983]: History list length 54
Aug 19 08:12:46 lena mysqld[13983]: LIST OF TRANSACTIONS FOR EACH SESSION:
Aug 19 08:12:46 lena mysqld[13983]: ---TRANSACTION 72059950460843816, ACTIVE 913 sec doing SYNC index
Aug 19 08:12:46 lena mysqld[13983]: 4 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 327755
Aug 19 08:12:46 lena mysqld[13983]: ---TRANSACTION 72059950460843815, ACTIVE 913 sec
Aug 19 08:12:46 lena mysqld[13983]: 0 lock struct(s), heap size 1080, 0 row lock(s)
Aug 19 08:12:46 lena mysqld[13983]: ---TRANSACTION 72059950460843814, ACTIVE 913 sec committing
Aug 19 08:12:46 lena mysqld[13983]: mysql tables in use 1, locked 1
Aug 19 08:12:46 lena mysqld[13983]: 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1773
Aug 19 08:12:46 lena mysqld[13983]: MySQL thread id 379, OS thread handle 2141190976, query id 811 localhost root Commit
Aug 19 08:12:46 lena mysqld[13983]: INSERT INTO `phpbb_posts` VALUES (2831604,341776,220,13332,0,'94.211.53.136',1393408041,0,1,1,1,0,'Blueshark','AW: Ankerblech vorne 2er scirocco','<r><QUOTE author=\"Black Thunder\"><s>[quote=\"Black Thunder\"]</s>Kleiner Nachtrag zu den <B><s>[b]</s>hinteren<e>[/b]</e></B> Ankerplatten: die scheinen tatsächlich auch am Polo zu passen. Und nicht nur dass:<br/>\n<br/>\n <B><s>[b]</s>6N0 609 425 A<e>[/b]</e></B><br/>\n <I><s>[i]</s>Bremsankerplatte hinten links<br/>\n für Trommelbremse / Belag 180 x 30 mm<br/>\n VW Golf I 4/82 - 7/83 (ab 17-C-694 102 >)<br/>\n VW Jet
Aug 19 08:12:46 lena mysqld[13983]: --------
Aug 19 08:12:46 lena mysqld[13983]: FILE I/O
Aug 19 08:12:46 lena mysqld[13983]: --------
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 1 state: waiting for completed aio requests (log thread)
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 2 state: waiting for completed aio requests (read thread)
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 3 state: waiting for completed aio requests (read thread)
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 4 state: waiting for completed aio requests (read thread)
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 5 state: waiting for completed aio requests (read thread)
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 6 state: waiting for completed aio requests (write thread)
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 7 state: waiting for completed aio requests (write thread)
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 8 state: waiting for completed aio requests (write thread)
Aug 19 08:12:46 lena mysqld[13983]: I/O thread 9 state: waiting for completed aio requests (write thread)
Aug 19 08:12:46 lena mysqld[13983]: Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
Aug 19 08:12:46 lena mysqld[13983]: ibuf aio reads:, log i/o's:, sync i/o's:
Aug 19 08:12:46 lena mysqld[13983]: Pending flushes (fsync) log: 0; buffer pool: 0
Aug 19 08:12:46 lena mysqld[13983]: 63169 OS file reads, 53969 OS file writes, 9470 OS fsyncs
Aug 19 08:12:46 lena mysqld[13983]: 0 pending reads, 2 pending writes
Aug 19 08:12:46 lena mysqld[13983]: 17.25 reads/s, 16384 avg bytes/read, 25.60 writes/s, 6.20 fsyncs/s
Aug 19 08:12:46 lena mysqld[13983]: -------------------------------------
Aug 19 08:12:46 lena mysqld[13983]: INSERT BUFFER AND ADAPTIVE HASH INDEX
Aug 19 08:12:46 lena mysqld[13983]: -------------------------------------
Aug 19 08:12:46 lena mysqld[13983]: Ibuf: size 1, free list len 1078, seg size 1080, 237 merges
Aug 19 08:12:46 lena mysqld[13983]: merged operations:
Aug 19 08:12:46 lena mysqld[13983]: insert 337, delete mark 0, delete 0
Aug 19 08:12:46 lena mysqld[13983]: discarded operations:
Aug 19 08:12:46 lena mysqld[13983]: insert 0, delete mark 0, delete 0
Aug 19 08:12:46 lena mysqld[13983]: 0.00 hash searches/s, 322.93 non-hash searches/s
Aug 19 08:12:46 lena mysqld[13983]: ---
Aug 19 08:12:46 lena mysqld[13983]: LOG
Aug 19 08:12:46 lena mysqld[13983]: ---
Aug 19 08:12:46 lena mysqld[13983]: Log sequence number 141224688200
Aug 19 08:12:46 lena mysqld[13983]: Log flushed up to 141224688200
Aug 19 08:12:46 lena mysqld[13983]: Pages flushed up to 141213666143
Aug 19 08:12:46 lena mysqld[13983]: Last checkpoint at 141213666143
Aug 19 08:12:46 lena mysqld[13983]: 0 pending log flushes, 0 pending chkp writes
Aug 19 08:12:46 lena mysqld[13983]: 2094 log i/o's done, 1.45 log i/o's/second
Aug 19 08:12:46 lena mysqld[13983]: ----------------------
Aug 19 08:12:46 lena mysqld[13983]: BUFFER POOL AND MEMORY
Aug 19 08:12:46 lena mysqld[13983]: ----------------------
Aug 19 08:12:46 lena mysqld[13983]: Total large memory allocated 169541632
Aug 19 08:12:46 lena mysqld[13983]: Dictionary memory allocated 26496
Aug 19 08:12:46 lena mysqld[13983]: Buffer pool size 8192
Aug 19 08:12:46 lena mysqld[13983]: Free buffers 0
Aug 19 08:12:46 lena mysqld[13983]: Database pages 8192
Aug 19 08:12:46 lena mysqld[13983]: Old database pages 3004
Aug 19 08:12:46 lena mysqld[13983]: Modified db pages 2984
Aug 19 08:12:46 lena mysqld[13983]: Percent of dirty pages(LRU & free pages): 36.421
Aug 19 08:12:46 lena mysqld[13983]: Max dirty pages percent: 75.000
Aug 19 08:12:46 lena mysqld[13983]: Pending reads 0
Aug 19 08:12:46 lena mysqld[13983]: Pending writes: LRU 0, flush list 121, single page 1
Aug 19 08:12:46 lena mysqld[13983]: Pages made young 1534, not young 1867913
Aug 19 08:12:46 lena mysqld[13983]: 0.30 youngs/s, 379.93 non-youngs/s
Aug 19 08:12:46 lena mysqld[13983]: Pages read 62913, created 4797, written 48245
Aug 19 08:12:46 lena mysqld[13983]: 17.25 reads/s, 6.30 creates/s, 21.90 writes/s
Aug 19 08:12:46 lena mysqld[13983]: Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 280 / 1000
Aug 19 08:12:46 lena mysqld[13983]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
Aug 19 08:12:46 lena mysqld[13983]: LRU len: 8192, unzip_LRU len: 0
Aug 19 08:12:46 lena mysqld[13983]: I/O sum[26680]:cur[731], unzip sum[0]:cur[0]
Aug 19 08:12:46 lena mysqld[13983]: --------------
Aug 19 08:12:46 lena mysqld[13983]: ROW OPERATIONS
Aug 19 08:12:46 lena mysqld[13983]: --------------
Aug 19 08:12:46 lena mysqld[13983]: 0 queries inside InnoDB, 0 queries in queue
Aug 19 08:12:46 lena mysqld[13983]: 0 read views open inside InnoDB
Aug 19 08:12:46 lena mysqld[13983]: Process ID=13983, Main thread ID=1979710272, state: sleeping
Aug 19 08:12:46 lena mysqld[13983]: Number of rows inserted 1773, updated 0, deleted 0, read 0
Aug 19 08:12:46 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:12:46 lena mysqld[13983]: Number of system rows inserted 0, updated 0, deleted 0, read 0
Aug 19 08:12:46 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:12:46 lena mysqld[13983]: ----------------------------
Aug 19 08:12:46 lena mysqld[13983]: END OF INNODB MONITOR OUTPUT
Aug 19 08:12:46 lena mysqld[13983]: ============================
Aug 19 08:12:55 lena mysqld[13983]: InnoDB: ###### Diagnostic info printed to the standard error stream
Aug 19 08:12:56 lena mysqld[13983]: 2021-08-19 8:12:56 0 [Warning] InnoDB: A long semaphore wait:
Aug 19 08:12:56 lena mysqld[13983]: --Thread 2141190976 has waited at fts0fts.cc line 3523 for 923.00 seconds the semaphore:
Aug 19 08:12:56 lena mysqld[13983]: X-lock on RW-latch at 0x328e408 created in file fts0fts.cc line 616
Aug 19 08:12:56 lena mysqld[13983]: a writer (thread id 1994373952) has reserved it in mode exclusive
Aug 19 08:12:56 lena mysqld[13983]: number of readers 0, waiters flag 1, lock_word: 0
Aug 19 08:12:56 lena mysqld[13983]: Last time write locked in file fts0fts.cc line 4278
Aug 19 08:12:56 lena mysqld[13983]: 2021-08-19 8:12:56 0 [Note] InnoDB: A semaphore wait:
Aug 19 08:12:56 lena mysqld[13983]: --Thread 2141190976 has waited at fts0fts.cc line 3523 for 923.00 seconds the semaphore:
Aug 19 08:12:56 lena mysqld[13983]: X-lock on RW-latch at 0x328e408 created in file fts0fts.cc line 616
Aug 19 08:12:56 lena mysqld[13983]: a writer (thread id 1994373952) has reserved it in mode exclusive
Aug 19 08:12:56 lena mysqld[13983]: number of readers 0, waiters flag 1, lock_word: 0
Aug 19 08:12:56 lena mysqld[13983]: Last time write locked in file fts0fts.cc line 4278
Aug 19 08:12:56 lena mysqld[13983]: InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
Aug 19 08:12:56 lena mysqld[13983]: InnoDB: Pending reads 0, writes 0
Aug 19 08:13:06 lena mysqld[13983]: =====================================
Aug 19 08:13:06 lena mysqld[13983]: 2021-08-19 08:13:06 0x77dfdb40 INNODB MONITOR OUTPUT
Aug 19 08:13:06 lena mysqld[13983]: =====================================
Aug 19 08:13:06 lena mysqld[13983]: Per second averages calculated from the last 20 seconds
Aug 19 08:13:06 lena mysqld[13983]: -----------------
Aug 19 08:13:06 lena mysqld[13983]: BACKGROUND THREAD
Aug 19 08:13:06 lena mysqld[13983]: -----------------
Aug 19 08:13:06 lena mysqld[13983]: srv_master_thread loops: 336 srv_active, 0 srv_shutdown, 50180 srv_idle
Aug 19 08:13:06 lena mysqld[13983]: srv_master_thread log flush and writes: 50497
Aug 19 08:13:06 lena mysqld[13983]: ----------
Aug 19 08:13:06 lena mysqld[13983]: SEMAPHORES
Aug 19 08:13:06 lena mysqld[13983]: ----------
Aug 19 08:13:06 lena mysqld[13983]: OS WAIT ARRAY INFO: reservation count 9316
Aug 19 08:13:06 lena mysqld[13983]: --Thread 2141190976 has waited at fts0fts.cc line 3523 for 933.00 seconds the semaphore:
Aug 19 08:13:06 lena mysqld[13983]: X-lock on RW-latch at 0x328e408 created in file fts0fts.cc line 616
Aug 19 08:13:06 lena mysqld[13983]: a writer (thread id 1994373952) has reserved it in mode exclusive
Aug 19 08:13:06 lena mysqld[13983]: number of readers 0, waiters flag 1, lock_word: 0
Aug 19 08:13:06 lena mysqld[13983]: Last time write locked in file fts0fts.cc line 4278
Aug 19 08:13:06 lena mysqld[13983]: OS WAIT ARRAY INFO: signal count 9346
Aug 19 08:13:06 lena mysqld[13983]: RW-shared spins 11206, rounds 307218, OS waits 8542
Aug 19 08:13:06 lena mysqld[13983]: RW-excl spins 11094, rounds 26262, OS waits 163
Aug 19 08:13:06 lena mysqld[13983]: RW-sx spins 22, rounds 660, OS waits 22
Aug 19 08:13:06 lena mysqld[13983]: Spin rounds per wait: 27.42 RW-shared, 2.37 RW-excl, 30.00 RW-sx
Aug 19 08:13:06 lena mysqld[13983]: ------------
Aug 19 08:13:06 lena mysqld[13983]: TRANSACTIONS
Aug 19 08:13:06 lena mysqld[13983]: ------------
Aug 19 08:13:06 lena mysqld[13983]: Trx id counter 72059950460843817
Aug 19 08:13:06 lena mysqld[13983]: Purge done for trx's n:o < 72059950460843747 undo n:o < 0 state: running but idle
Aug 19 08:13:06 lena mysqld[13983]: History list length 54
Aug 19 08:13:06 lena mysqld[13983]: LIST OF TRANSACTIONS FOR EACH SESSION:
Aug 19 08:13:06 lena mysqld[13983]: ---TRANSACTION 72059950460843816, ACTIVE 933 sec doing SYNC index
Aug 19 08:13:06 lena mysqld[13983]: 4 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 334421
Aug 19 08:13:06 lena mysqld[13983]: ---TRANSACTION 72059950460843815, ACTIVE 933 sec
Aug 19 08:13:06 lena mysqld[13983]: 0 lock struct(s), heap size 1080, 0 row lock(s)
Aug 19 08:13:06 lena mysqld[13983]: ---TRANSACTION 72059950460843814, ACTIVE 933 sec committing
Aug 19 08:13:06 lena mysqld[13983]: mysql tables in use 1, locked 1
Aug 19 08:13:06 lena mysqld[13983]: 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1773
Aug 19 08:13:06 lena mysqld[13983]: MySQL thread id 379, OS thread handle 2141190976, query id 811 localhost root Commit
Aug 19 08:13:06 lena mysqld[13983]: INSERT INTO `phpbb_posts` VALUES (2831604,341776,220,13332,0,'94.211.53.136',1393408041,0,1,1,1,0,'Blueshark','AW: Ankerblech vorne 2er scirocco','<r><QUOTE author=\"Black Thunder\"><s>[quote=\"Black Thunder\"]</s>Kleiner Nachtrag zu den <B><s>[b]</s>hinteren<e>[/b]</e></B> Ankerplatten: die scheinen tatsächlich auch am Polo zu passen. Und nicht nur dass:<br/>\n<br/>\n <B><s>[b]</s>6N0 609 425 A<e>[/b]</e></B><br/>\n <I><s>[i]</s>Bremsankerplatte hinten links<br/>\n für Trommelbremse / Belag 180 x 30 mm<br/>\n VW Golf I 4/82 - 7/83 (ab 17-C-694 102 >)<br/>\n VW Jet
Aug 19 08:13:06 lena mysqld[13983]: --------
Aug 19 08:13:06 lena mysqld[13983]: FILE I/O
Aug 19 08:13:06 lena mysqld[13983]: --------
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 1 state: waiting for completed aio requests (log thread)
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 2 state: waiting for completed aio requests (read thread)
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 3 state: waiting for completed aio requests (read thread)
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 4 state: waiting for completed aio requests (read thread)
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 5 state: waiting for completed aio requests (read thread)
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 6 state: waiting for completed aio requests (write thread)
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 7 state: waiting for completed aio requests (write thread)
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 8 state: waiting for completed aio requests (write thread)
Aug 19 08:13:06 lena mysqld[13983]: I/O thread 9 state: waiting for completed aio requests (write thread)
Aug 19 08:13:06 lena mysqld[13983]: Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
Aug 19 08:13:06 lena mysqld[13983]: ibuf aio reads:, log i/o's:, sync i/o's:
Aug 19 08:13:06 lena mysqld[13983]: Pending flushes (fsync) log: 0; buffer pool: 0
Aug 19 08:13:06 lena mysqld[13983]: 63604 OS file reads, 54612 OS file writes, 9600 OS fsyncs
Aug 19 08:13:06 lena mysqld[13983]: 0 pending reads, 2 pending writes
Aug 19 08:13:06 lena mysqld[13983]: 21.75 reads/s, 16384 avg bytes/read, 32.15 writes/s, 6.50 fsyncs/s
Aug 19 08:13:06 lena mysqld[13983]: -------------------------------------
Aug 19 08:13:06 lena mysqld[13983]: INSERT BUFFER AND ADAPTIVE HASH INDEX
Aug 19 08:13:06 lena mysqld[13983]: -------------------------------------
Aug 19 08:13:06 lena mysqld[13983]: Ibuf: size 1, free list len 1078, seg size 1080, 237 merges
Aug 19 08:13:06 lena mysqld[13983]: merged operations:
Aug 19 08:13:06 lena mysqld[13983]: insert 337, delete mark 0, delete 0
Aug 19 08:13:06 lena mysqld[13983]: discarded operations:
Aug 19 08:13:06 lena mysqld[13983]: insert 0, delete mark 0, delete 0
Aug 19 08:13:06 lena mysqld[13983]: 0.00 hash searches/s, 342.48 non-hash searches/s
Aug 19 08:13:06 lena mysqld[13983]: ---
Aug 19 08:13:06 lena mysqld[13983]: LOG
Aug 19 08:13:06 lena mysqld[13983]: ---
Aug 19 08:13:06 lena mysqld[13983]: Log sequence number 141226852616
Aug 19 08:13:06 lena mysqld[13983]: Log flushed up to 141226617787
Aug 19 08:13:06 lena mysqld[13983]: Pages flushed up to 141215769810
Aug 19 08:13:06 lena mysqld[13983]: Last checkpoint at 141215671905
Aug 19 08:13:06 lena mysqld[13983]: 0 pending log flushes, 0 pending chkp writes
Aug 19 08:13:06 lena mysqld[13983]: 2119 log i/o's done, 1.25 log i/o's/second
Aug 19 08:13:06 lena mysqld[13983]: ----------------------
Aug 19 08:13:06 lena mysqld[13983]: BUFFER POOL AND MEMORY
Aug 19 08:13:06 lena mysqld[13983]: ----------------------
Aug 19 08:13:06 lena mysqld[13983]: Total large memory allocated 169541632
Aug 19 08:13:06 lena mysqld[13983]: Dictionary memory allocated 26496
Aug 19 08:13:06 lena mysqld[13983]: Buffer pool size 8192
Aug 19 08:13:06 lena mysqld[13983]: Free buffers 0
Aug 19 08:13:06 lena mysqld[13983]: Database pages 8192
Aug 19 08:13:06 lena mysqld[13983]: Old database pages 3004
Aug 19 08:13:06 lena mysqld[13983]: Modified db pages 2969
Aug 19 08:13:06 lena mysqld[13983]: Percent of dirty pages(LRU & free pages): 36.238
Aug 19 08:13:06 lena mysqld[13983]: Max dirty pages percent: 75.000
Aug 19 08:13:06 lena mysqld[13983]: Pending reads 0
Aug 19 08:13:06 lena mysqld[13983]: Pending writes: LRU 0, flush list 80, single page 1
Aug 19 08:13:06 lena mysqld[13983]: Pages made young 1539, not young 1875044
Aug 19 08:13:06 lena mysqld[13983]: 0.25 youngs/s, 356.53 non-youngs/s
Aug 19 08:13:06 lena mysqld[13983]: Pages read 63348, created 4924, written 48809
Aug 19 08:13:06 lena mysqld[13983]: 21.75 reads/s, 6.35 creates/s, 28.20 writes/s
Aug 19 08:13:06 lena mysqld[13983]: Buffer pool hit rate 984 / 1000, young-making rate 0 / 1000 not 248 / 1000
Aug 19 08:13:06 lena mysqld[13983]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
Aug 19 08:13:06 lena mysqld[13983]: LRU len: 8192, unzip_LRU len: 0
Aug 19 08:13:06 lena mysqld[13983]: I/O sum[27758]:cur[539], unzip sum[0]:cur[0]
Aug 19 08:13:06 lena mysqld[13983]: --------------
Aug 19 08:13:06 lena mysqld[13983]: ROW OPERATIONS
Aug 19 08:13:06 lena mysqld[13983]: --------------
Aug 19 08:13:06 lena mysqld[13983]: 0 queries inside InnoDB, 0 queries in queue
Aug 19 08:13:06 lena mysqld[13983]: 0 read views open inside InnoDB
Aug 19 08:13:06 lena mysqld[13983]: Process ID=13983, Main thread ID=1979710272, state: sleeping
Aug 19 08:13:06 lena mysqld[13983]: Number of rows inserted 1773, updated 0, deleted 0, read 0
Aug 19 08:13:06 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:13:06 lena mysqld[13983]: Number of system rows inserted 0, updated 0, deleted 0, read 0
Aug 19 08:13:06 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:13:06 lena mysqld[13983]: ----------------------------
Aug 19 08:13:06 lena mysqld[13983]: END OF INNODB MONITOR OUTPUT
Aug 19 08:13:06 lena mysqld[13983]: ============================
Aug 19 08:13:26 lena mysqld[13983]: =====================================
Aug 19 08:13:26 lena mysqld[13983]: 2021-08-19 08:13:26 0x77dfdb40 INNODB MONITOR OUTPUT
Aug 19 08:13:26 lena mysqld[13983]: =====================================
Aug 19 08:13:26 lena mysqld[13983]: Per second averages calculated from the last 20 seconds
Aug 19 08:13:26 lena mysqld[13983]: -----------------
Aug 19 08:13:26 lena mysqld[13983]: BACKGROUND THREAD
Aug 19 08:13:26 lena mysqld[13983]: -----------------
Aug 19 08:13:26 lena mysqld[13983]: srv_master_thread loops: 336 srv_active, 0 srv_shutdown, 50193 srv_idle
Aug 19 08:13:26 lena mysqld[13983]: srv_master_thread log flush and writes: 50510
Aug 19 08:13:26 lena mysqld[13983]: ----------
Aug 19 08:13:26 lena mysqld[13983]: SEMAPHORES
Aug 19 08:13:26 lena mysqld[13983]: ----------
Aug 19 08:13:26 lena mysqld[13983]: OS WAIT ARRAY INFO: reservation count 9387
Aug 19 08:13:26 lena mysqld[13983]: --Thread 2141190976 has waited at fts0fts.cc line 3523 for 953.00 seconds the semaphore:
Aug 19 08:13:26 lena mysqld[13983]: X-lock on RW-latch at 0x328e408 created in file fts0fts.cc line 616
Aug 19 08:13:26 lena mysqld[13983]: a writer (thread id 1994373952) has reserved it in mode exclusive
Aug 19 08:13:26 lena mysqld[13983]: number of readers 0, waiters flag 1, lock_word: 0
Aug 19 08:13:26 lena mysqld[13983]: Last time write locked in file fts0fts.cc line 4278
Aug 19 08:13:26 lena mysqld[13983]: OS WAIT ARRAY INFO: signal count 9416
Aug 19 08:13:26 lena mysqld[13983]: RW-shared spins 11281, rounds 309316, OS waits 8606
Aug 19 08:13:26 lena mysqld[13983]: RW-excl spins 11095, rounds 26292, OS waits 164
Aug 19 08:13:26 lena mysqld[13983]: RW-sx spins 22, rounds 660, OS waits 22
Aug 19 08:13:26 lena mysqld[13983]: Spin rounds per wait: 27.42 RW-shared, 2.37 RW-excl, 30.00 RW-sx
Aug 19 08:13:26 lena mysqld[13983]: ------------
Aug 19 08:13:26 lena mysqld[13983]: TRANSACTIONS
Aug 19 08:13:26 lena mysqld[13983]: ------------
Aug 19 08:13:26 lena mysqld[13983]: Trx id counter 72059950460843817
Aug 19 08:13:26 lena mysqld[13983]: Purge done for trx's n:o < 72059950460843747 undo n:o < 0 state: running but idle
Aug 19 08:13:26 lena mysqld[13983]: History list length 54
Aug 19 08:13:26 lena mysqld[13983]: LIST OF TRANSACTIONS FOR EACH SESSION:
Aug 19 08:13:26 lena mysqld[13983]: ---TRANSACTION 72059950460843816, ACTIVE 953 sec doing SYNC index
Aug 19 08:13:26 lena mysqld[13983]: 4 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 341586
Aug 19 08:13:26 lena mysqld[13983]: ---TRANSACTION 72059950460843815, ACTIVE 953 sec
Aug 19 08:13:26 lena mysqld[13983]: 0 lock struct(s), heap size 1080, 0 row lock(s)
Aug 19 08:13:26 lena mysqld[13983]: ---TRANSACTION 72059950460843814, ACTIVE 953 sec committing
Aug 19 08:13:26 lena mysqld[13983]: mysql tables in use 1, locked 1
Aug 19 08:13:26 lena mysqld[13983]: 1 lock struct(s), heap size 1080, 0 row lock(s), undo log entries 1773
Aug 19 08:13:26 lena mysqld[13983]: MySQL thread id 379, OS thread handle 2141190976, query id 811 localhost root Commit
Aug 19 08:13:26 lena mysqld[13983]: INSERT INTO `phpbb_posts` VALUES (2831604,341776,220,13332,0,'94.211.53.136',1393408041,0,1,1,1,0,'Blueshark','AW: Ankerblech vorne 2er scirocco','<r><QUOTE author=\"Black Thunder\"><s>[quote=\"Black Thunder\"]</s>Kleiner Nachtrag zu den <B><s>[b]</s>hinteren<e>[/b]</e></B> Ankerplatten: die scheinen tatsächlich auch am Polo zu passen. Und nicht nur dass:<br/>\n<br/>\n <B><s>[b]</s>6N0 609 425 A<e>[/b]</e></B><br/>\n <I><s>[i]</s>Bremsankerplatte hinten links<br/>\n für Trommelbremse / Belag 180 x 30 mm<br/>\n VW Golf I 4/82 - 7/83 (ab 17-C-694 102 >)<br/>\n VW Jet
Aug 19 08:13:26 lena mysqld[13983]: --------
Aug 19 08:13:26 lena mysqld[13983]: FILE I/O
Aug 19 08:13:26 lena mysqld[13983]: --------
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 1 state: waiting for completed aio requests (log thread)
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 2 state: waiting for completed aio requests (read thread)
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 3 state: waiting for completed aio requests (read thread)
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 4 state: waiting for completed aio requests (read thread)
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 5 state: waiting for completed aio requests (read thread)
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 6 state: waiting for completed aio requests (write thread)
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 7 state: waiting for completed aio requests (write thread)
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 8 state: waiting for completed aio requests (write thread)
Aug 19 08:13:26 lena mysqld[13983]: I/O thread 9 state: waiting for completed aio requests (write thread)
Aug 19 08:13:26 lena mysqld[13983]: Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
Aug 19 08:13:26 lena mysqld[13983]: ibuf aio reads:, log i/o's:, sync i/o's:
Aug 19 08:13:26 lena mysqld[13983]: Pending flushes (fsync) log: 0; buffer pool: 0
Aug 19 08:13:26 lena mysqld[13983]: 64065 OS file reads, 55251 OS file writes, 9769 OS fsyncs
Aug 19 08:13:26 lena mysqld[13983]: 0 pending reads, 2 pending writes
Aug 19 08:13:26 lena mysqld[13983]: 23.05 reads/s, 16384 avg bytes/read, 31.95 writes/s, 8.45 fsyncs/s
Aug 19 08:13:26 lena mysqld[13983]: -------------------------------------
Aug 19 08:13:26 lena mysqld[13983]: INSERT BUFFER AND ADAPTIVE HASH INDEX
Aug 19 08:13:26 lena mysqld[13983]: -------------------------------------
Aug 19 08:13:26 lena mysqld[13983]: Ibuf: size 1, free list len 1078, seg size 1080, 237 merges
Aug 19 08:13:26 lena mysqld[13983]: merged operations:
Aug 19 08:13:26 lena mysqld[13983]: insert 337, delete mark 0, delete 0
Aug 19 08:13:26 lena mysqld[13983]: discarded operations:
Aug 19 08:13:26 lena mysqld[13983]: insert 0, delete mark 0, delete 0
Aug 19 08:13:26 lena mysqld[13983]: 0.00 hash searches/s, 364.93 non-hash searches/s
Aug 19 08:13:26 lena mysqld[13983]: ---
Aug 19 08:13:26 lena mysqld[13983]: LOG
Aug 19 08:13:26 lena mysqld[13983]: ---
Aug 19 08:13:26 lena mysqld[13983]: Log sequence number 141228556858
Aug 19 08:13:26 lena mysqld[13983]: Log flushed up to 141228450917
Aug 19 08:13:26 lena mysqld[13983]: Pages flushed up to 141217508627
Aug 19 08:13:26 lena mysqld[13983]: Last checkpoint at 141217508627
Aug 19 08:13:26 lena mysqld[13983]: 0 pending log flushes, 0 pending chkp writes
Aug 19 08:13:26 lena mysqld[13983]: 2155 log i/o's done, 1.80 log i/o's/second
Aug 19 08:13:26 lena mysqld[13983]: ----------------------
Aug 19 08:13:26 lena mysqld[13983]: BUFFER POOL AND MEMORY
Aug 19 08:13:26 lena mysqld[13983]: ----------------------
Aug 19 08:13:26 lena mysqld[13983]: Total large memory allocated 169541632
Aug 19 08:13:26 lena mysqld[13983]: Dictionary memory allocated 26496
Aug 19 08:13:26 lena mysqld[13983]: Buffer pool size 8192
Aug 19 08:13:26 lena mysqld[13983]: Free buffers 0
Aug 19 08:13:26 lena mysqld[13983]: Database pages 8192
Aug 19 08:13:26 lena mysqld[13983]: Old database pages 3004
Aug 19 08:13:26 lena mysqld[13983]: Modified db pages 2968
Aug 19 08:13:26 lena mysqld[13983]: Percent of dirty pages(LRU & free pages): 36.226
Aug 19 08:13:26 lena mysqld[13983]: Max dirty pages percent: 75.000
Aug 19 08:13:26 lena mysqld[13983]: Pending reads 0
Aug 19 08:13:26 lena mysqld[13983]: Pending writes: LRU 0, flush list 121, single page 1
Aug 19 08:13:26 lena mysqld[13983]: Pages made young 1542, not young 1882078
Aug 19 08:13:26 lena mysqld[13983]: 0.15 youngs/s, 351.68 non-youngs/s
Aug 19 08:13:26 lena mysqld[13983]: Pages read 63809, created 5007, written 49345
Aug 19 08:13:26 lena mysqld[13983]: 23.05 reads/s, 4.15 creates/s, 26.80 writes/s
Aug 19 08:13:26 lena mysqld[13983]: Buffer pool hit rate 984 / 1000, young-making rate 0 / 1000 not 232 / 1000
Aug 19 08:13:26 lena mysqld[13983]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
Aug 19 08:13:26 lena mysqld[13983]: LRU len: 8192, unzip_LRU len: 0
Aug 19 08:13:26 lena mysqld[13983]: I/O sum[27758]:cur[1507], unzip sum[0]:cur[0]
Aug 19 08:13:26 lena mysqld[13983]: --------------
Aug 19 08:13:26 lena mysqld[13983]: ROW OPERATIONS
Aug 19 08:13:26 lena mysqld[13983]: --------------
Aug 19 08:13:26 lena mysqld[13983]: 0 queries inside InnoDB, 0 queries in queue
Aug 19 08:13:26 lena mysqld[13983]: 0 read views open inside InnoDB
Aug 19 08:13:26 lena mysqld[13983]: Process ID=13983, Main thread ID=1979710272, state: sleeping
Aug 19 08:13:26 lena mysqld[13983]: Number of rows inserted 1773, updated 0, deleted 0, read 0
Aug 19 08:13:26 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:13:26 lena mysqld[13983]: Number of system rows inserted 0, updated 0, deleted 0, read 0
Aug 19 08:13:26 lena mysqld[13983]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Aug 19 08:13:26 lena mysqld[13983]: ----------------------------
Aug 19 08:13:26 lena mysqld[13983]: END OF INNODB MONITOR OUTPUT
Aug 19 08:13:26 lena mysqld[13983]: ============================
Aug 19 08:13:26 lena mysqld[13983]: InnoDB: ###### Diagnostic info printed to the standard error stream
Aug 19 08:13:26 lena mysqld[13983]: 2021-08-19 8:13:26 0 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.
Aug 19 08:13:26 lena mysqld[13983]: 210819 8:13:26 [ERROR] mysqld got signal 6 ;
Aug 19 08:13:26 lena mysqld[13983]: This could be because you hit a bug. It is also possible that this binary
Aug 19 08:13:26 lena mysqld[13983]: or one of the libraries it was linked against is corrupt, improperly built,
Aug 19 08:13:26 lena mysqld[13983]: or misconfigured. This error can also be caused by malfunctioning hardware.
Aug 19 08:13:26 lena mysqld[13983]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Aug 19 08:13:26 lena mysqld[13983]: We will try our best to scrape up some info that will hopefully help
Aug 19 08:13:26 lena mysqld[13983]: diagnose the problem, but since we have already crashed,
Aug 19 08:13:26 lena mysqld[13983]: something is definitely wrong and this may fail.
Aug 19 08:13:26 lena mysqld[13983]: Server version: 10.3.29-MariaDB-0+deb10u1
Aug 19 08:13:26 lena mysqld[13983]: key_buffer_size=67108864
Aug 19 08:13:26 lena mysqld[13983]: read_buffer_size=131072
Aug 19 08:13:26 lena mysqld[13983]: max_used_connections=1
Aug 19 08:13:26 lena mysqld[13983]: max_threads=2502
Aug 19 08:13:26 lena mysqld[13983]: thread_count=6
Aug 19 08:13:26 lena mysqld[13983]: It is possible that mysqld could use up to
Aug 19 08:13:26 lena mysqld[13983]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1351487 K bytes of memory
Aug 19 08:13:26 lena mysqld[13983]: Hope that's ok; if not, decrease some variables in the equation.
Aug 19 08:13:26 lena mysqld[13983]: Thread pointer: 0x0
Aug 19 08:13:26 lena mysqld[13983]: Attempting backtrace. You can use the following information to find out
Aug 19 08:13:26 lena mysqld[13983]: where mysqld died. If you see no messages after this, something went
Aug 19 08:13:26 lena mysqld[13983]: terribly wrong...
Aug 19 08:13:26 lena mysqld[13983]: stack_bottom = 0x0 thread_stack 0x20000
Aug 19 08:13:26 lena mysqld[13983]: /usr/sbin/mysqld(my_print_stacktrace+0x28)[0xeea678]
Aug 19 08:13:26 lena mysqld[13983]: /usr/sbin/mysqld(handle_fatal_signal+0x557)[0x9cd427]
Aug 19 08:13:26 lena mysqld[13983]: addr2line: 'linux-gate.so.1': No such file
Aug 19 08:13:26 lena mysqld[13983]: linux-gate.so.1(__kernel_sigreturn+0x0)[0xb7f36d6c]
Aug 19 08:13:26 lena mysqld[13983]: linux-gate.so.1(__kernel_vsyscall+0x9)[0xb7f36d61]
Aug 19 08:13:26 lena mysqld[13983]: /lib/i386-linux-gnu/libc.so.6(gsignal+0xc2)[0xb7910382]
Aug 19 08:13:26 lena mysqld[13983]: /lib/i386-linux-gnu/libc.so.6(abort+0xf0)[0xb78fa2b6]
Aug 19 08:13:26 lena mysqld[13983]: /usr/sbin/mysqld(+0x2a7b35)[0x6dab35]
Aug 19 08:13:26 lena mysqld[13983]: /usr/sbin/mysqld(+0x29b521)[0x6ce521]
Aug 19 08:13:26 lena mysqld[13983]: /lib/i386-linux-gnu/libpthread.so.0(+0x6fd2)[0xb7ac5fd2]
Aug 19 08:13:26 lena mysqld[13983]: /lib/i386-linux-gnu/libc.so.6(clone+0x66)[0xb79db6d6]
Aug 19 08:13:26 lena mysqld[13983]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
Aug 19 08:13:26 lena mysqld[13983]: information that should help you find out what is causing the crash.
Aug 19 08:13:26 lena mysqld[13983]: Writing a core file...
Aug 19 08:13:26 lena mysqld[13983]: Working directory at /var/lib/mysql
Aug 19 08:13:26 lena mysqld[13983]: Resource Limits:
Aug 19 08:13:26 lena mysqld[13983]: Fatal signal 11 while backtracing
Aug 19 08:13:26 lena kernel: [34445718.492847] mysqld[14001]: segfault at 0 ip 00ee7b3a sp 785fc8b0 error 6 in mysqld[69b000+89c000]
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Warning] option 'max_allowed_packet': unsigned value 2147483648 adjusted to 1073741824
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] /usr/sbin/mysqld (mysqld 10.3.29-MariaDB-0+deb10u1) starting as process 31907 ...
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 34539)
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead.
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Using Linux native AIO
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Uses event mutexes
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Number of pools: 1
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Using generic crc32 instructions
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Completed initialization of buffer pool
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=141228450836
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Trying to recover page [page id: space=3288, page number=12263] from the doublewrite buffer.
Aug 19 08:13:32 lena mysqld[31907]: 2021-08-19 8:13:32 0 [Note] InnoDB: Recovered page [page id: space=3288, page number=12263] from the doublewrite buffer.
Aug 19 08:13:33 lena mysqld[31907]: 2021-08-19 8:13:33 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 343116 row operations to undo
Aug 19 08:13:33 lena mysqld[31907]: 2021-08-19 8:13:33 0 [Note] InnoDB: Trx id counter is 72059950460843817
Aug 19 08:13:33 lena mysqld[31907]: 2021-08-19 8:13:33 0 [Note] InnoDB: Starting final batch to recover 2861 pages from redo log.
Aug 19 08:13:33 lena mysqld[31907]: 2021-08-19 8:13:33 0 [Note] InnoDB: Last binlog file '/var/log/mysql/mysql-bin.000567', position 79
Aug 19 08:13:34 lena mysqld[31907]: 2021-08-19 8:13:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
Aug 19 08:13:34 lena mysqld[31907]: 2021-08-19 8:13:34 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
Aug 19 08:13:34 lena mysqld[31907]: 2021-08-19 8:13:34 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Aug 19 08:13:34 lena mysqld[31907]: 2021-08-19 8:13:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Aug 19 08:13:34 lena mysqld[31907]: 2021-08-19 8:13:34 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Aug 19 08:13:35 lena mysqld[31907]: 2021-08-19 8:13:35 0 [Note] InnoDB: Rolled back recovered transaction 72059950460843814
Aug 19 08:13:44 lena mysqld[31907]: 2021-08-19 8:13:44 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Aug 19 08:13:48 lena mysqld[31907]: 2021-08-19 8:13:48 0 [Note] InnoDB: To roll back: 1 transactions, 256025 rows
Aug 19 08:13:51 lena mysqld[31907]: 2021-08-19 8:13:51 0 [Note] InnoDB: 10.3.29 started; log sequence number 141228473394; transaction id 72059950460843819
Aug 19 08:13:51 lena mysqld[31907]: 2021-08-19 8:13:51 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
Aug 19 08:13:51 lena mysqld[31907]: 2021-08-19 8:13:51 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Aug 19 08:13:51 lena mysqld[31907]: 2021-08-19 8:13:51 0 [Note] Plugin 'FEEDBACK' is disabled.
Aug 19 08:13:51 lena mysqld[31907]: 2021-08-19 8:13:51 0 [Note] Recovering after a crash using tc.log
Aug 19 08:13:51 lena mysqld[31907]: 2021-08-19 8:13:51 0 [Note] Starting crash recovery...
Aug 19 08:13:51 lena mysqld[31907]: 2021-08-19 8:13:51 0 [Note] Crash recovery finished.
Aug 19 08:13:51 lena mysqld[31907]: 2021-08-19 8:13:51 0 [Note] Server socket created on IP: '127.0.0.1'.
Aug 19 08:13:53 lena mysqld[31907]: 2021-08-19 8:13:53 0 [Note] Reading of all Master_info entries succeeded
Aug 19 08:13:53 lena mysqld[31907]: 2021-08-19 8:13:53 0 [Note] Added new Master_info '' to hash table
Aug 19 08:13:53 lena mysqld[31907]: 2021-08-19 8:13:53 0 [Note] /usr/sbin/mysqld: ready for connections.
Aug 19 08:13:53 lena mysqld[31907]: Version: '10.3.29-MariaDB-0+deb10u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian 10
Aug 19 08:13:53 lena /etc/mysql/debian-start[31944]: Upgrading MySQL tables if necessary.
Aug 19 08:13:53 lena /etc/mysql/debian-start[31947]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug 19 08:13:53 lena /etc/mysql/debian-start[31947]: Looking for 'mysql' as: /usr/bin/mysql
Aug 19 08:13:53 lena /etc/mysql/debian-start[31947]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Aug 19 08:13:53 lena /etc/mysql/debian-start[31947]: This installation of MySQL is already upgraded to 10.3.29-MariaDB, use --force if you still need to run mysql_upgrade
Aug 19 08:13:53 lena /etc/mysql/debian-start[31955]: Checking for insecure root accounts.
Aug 19 08:13:53 lena /etc/mysql/debian-start[31960]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Aug 19 08:14:05 lena mysqld[31907]: 2021-08-19 8:14:05 0 [Note] InnoDB: To roll back: 1 transactions, 254374 rows
Aug 19 08:14:20 lena mysqld[31907]: 2021-08-19 8:14:20 0 [Note] InnoDB: To roll back: 1 transactions, 254110 rows
Aug 19 08:14:35 lena mysqld[31907]: 2021-08-19 8:14:35 0 [Note] InnoDB: To roll back: 1 transactions, 253909 rows
Aug 19 08:14:51 lena mysqld[31907]: 2021-08-19 8:14:51 0 [Note] InnoDB: To roll back: 1 transactions, 253005 rows
Aug 19 08:15:06 lena mysqld[31907]: 2021-08-19 8:15:06 0 [Note] InnoDB: To roll back: 1 transactions, 252357 rows
Aug 19 08:15:21 lena mysqld[31907]: 2021-08-19 8:15:21 0 [Note] InnoDB: To roll back: 1 transactions, 251983 rows
Aug 19 08:15:37 lena mysqld[31907]: 2021-08-19 8:15:37 0 [Note] InnoDB: To roll back: 1 transactions, 249895 rows
Aug 19 08:15:38 lena mysqld[31907]: 2021-08-19 8:15:38 0 [Note] InnoDB: Buffer pool(s) load completed at 210819 8:15:38
Aug 19 08:15:52 lena mysqld[31907]: 2021-08-19 8:15:52 0 [Note] InnoDB: To roll back: 1 transactions, 210259 rows
Aug 19 08:16:07 lena mysqld[31907]: 2021-08-19 8:16:07 0 [Note] InnoDB: To roll back: 1 transactions, 196080 rows
Aug 19 08:16:22 lena mysqld[31907]: 2021-08-19 8:16:22 0 [Note] InnoDB: To roll back: 1 transactions, 190453 rows
Aug 19 08:16:38 lena mysqld[31907]: 2021-08-19 8:16:38 0 [Note] InnoDB: To roll back: 1 transactions, 186337 rows
Aug 19 08:16:57 lena mysqld[31907]: 2021-08-19 8:16:57 0 [Note] InnoDB: To roll back: 1 transactions, 182787 rows
Aug 19 08:17:12 lena mysqld[31907]: 2021-08-19 8:17:12 0 [Note] InnoDB: To roll back: 1 transactions, 178386 rows
Aug 19 08:17:28 lena mysqld[31907]: 2021-08-19 8:17:28 0 [Note] InnoDB: To roll back: 1 transactions, 174221 rows
Aug 19 08:17:46 lena mysqld[31907]: 2021-08-19 8:17:46 0 [Note] InnoDB: To roll back: 1 transactions, 169055 rows
Aug 19 08:18:02 lena mysqld[31907]: 2021-08-19 8:18:02 0 [Note] InnoDB: To roll back: 1 transactions, 163820 rows
Aug 19 08:18:17 lena mysqld[31907]: 2021-08-19 8:18:17 0 [Note] InnoDB: To roll back: 1 transactions, 158071 rows
Aug 19 08:18:32 lena mysqld[31907]: 2021-08-19 8:18:32 0 [Note] InnoDB: To roll back: 1 transactions, 150174 rows
Aug 19 08:18:47 lena mysqld[31907]: 2021-08-19 8:18:47 0 [Note] InnoDB: To roll back: 1 transactions, 146994 rows
Aug 19 08:19:02 lena mysqld[31907]: 2021-08-19 8:19:02 0 [Note] InnoDB: To roll back: 1 transactions, 141719 rows
Aug 19 08:19:19 lena mysqld[31907]: 2021-08-19 8:19:19 0 [Note] InnoDB: To roll back: 1 transactions, 139711 rows
Aug 19 08:19:34 lena mysqld[31907]: 2021-08-19 8:19:34 0 [Note] InnoDB: To roll back: 1 transactions, 136623 rows
Aug 19 08:19:49 lena mysqld[31907]: 2021-08-19 8:19:49 0 [Note] InnoDB: To roll back: 1 transactions, 130390 rows
Aug 19 08:20:04 lena mysqld[31907]: 2021-08-19 8:20:04 0 [Note] InnoDB: To roll back: 1 transactions, 127314 rows
Aug 19 08:20:23 lena mysqld[31907]: 2021-08-19 8:20:23 0 [Note] InnoDB: To roll back: 1 transactions, 123799 rows
Aug 19 08:20:38 lena mysqld[31907]: 2021-08-19 8:20:38 0 [Note] InnoDB: To roll back: 1 transactions, 117419 rows
Aug 19 08:20:53 lena mysqld[31907]: 2021-08-19 8:20:53 0 [Note] InnoDB: To roll back: 1 transactions, 110840 rows
Aug 19 08:21:08 lena mysqld[31907]: 2021-08-19 8:21:08 0 [Note] InnoDB: To roll back: 1 transactions, 105426 rows
Aug 19 08:21:24 lena mysqld[31907]: 2021-08-19 8:21:24 0 [Note] InnoDB: To roll back: 1 transactions, 102393 rows
Aug 19 08:21:40 lena mysqld[31907]: 2021-08-19 8:21:40 0 [Note] InnoDB: To roll back: 1 transactions, 98722 rows
Aug 19 08:21:55 lena mysqld[31907]: 2021-08-19 8:21:55 0 [Note] InnoDB: To roll back: 1 transactions, 92964 rows
Aug 19 08:22:10 lena mysqld[31907]: 2021-08-19 8:22:10 0 [Note] InnoDB: To roll back: 1 transactions, 87255 rows
Aug 19 08:22:25 lena mysqld[31907]: 2021-08-19 8:22:25 0 [Note] InnoDB: To roll back: 1 transactions, 81123 rows
Aug 19 08:22:40 lena mysqld[31907]: 2021-08-19 8:22:40 0 [Note] InnoDB: To roll back: 1 transactions, 74278 rows
Aug 19 08:22:55 lena mysqld[31907]: 2021-08-19 8:22:55 0 [Note] InnoDB: To roll back: 1 transactions, 72025 rows
Aug 19 08:23:10 lena mysqld[31907]: 2021-08-19 8:23:10 0 [Note] InnoDB: To roll back: 1 transactions, 65483 rows
Aug 19 08:23:27 lena mysqld[31907]: 2021-08-19 8:23:27 0 [Note] InnoDB: To roll back: 1 transactions, 61570 rows
Aug 19 08:23:42 lena mysqld[31907]: 2021-08-19 8:23:42 0 [Note] InnoDB: To roll back: 1 transactions, 58577 rows
Aug 19 08:24:01 lena mysqld[31907]: 2021-08-19 8:24:01 0 [Note] InnoDB: To roll back: 1 transactions, 53349 rows
Aug 19 08:24:18 lena mysqld[31907]: 2021-08-19 8:24:18 0 [Note] InnoDB: To roll back: 1 transactions, 50166 rows
Aug 19 08:24:33 lena mysqld[31907]: 2021-08-19 8:24:33 0 [Note] InnoDB: To roll back: 1 transactions, 47880 rows
Aug 19 08:24:49 lena mysqld[31907]: 2021-08-19 8:24:49 0 [Note] InnoDB: To roll back: 1 transactions, 43287 rows
Aug 19 08:25:06 lena mysqld[31907]: 2021-08-19 8:25:06 0 [Note] InnoDB: To roll back: 1 transactions, 34630 rows
Aug 19 08:25:22 lena mysqld[31907]: 2021-08-19 8:25:22 0 [Note] InnoDB: To roll back: 1 transactions, 24765 rows
Aug 19 08:25:38 lena mysqld[31907]: 2021-08-19 8:25:38 0 [Note] InnoDB: To roll back: 1 transactions, 12291 rows
Aug 19 08:25:55 lena mysqld[31907]: 2021-08-19 8:25:55 0 [Note] InnoDB: To roll back: 1 transactions, 9569 rows
Aug 19 08:26:10 lena mysqld[31907]: 2021-08-19 8:26:10 0 [Note] InnoDB: To roll back: 1 transactions, 6113 rows
Aug 19 08:26:25 lena mysqld[31907]: 2021-08-19 8:26:25 0 [Note] InnoDB: To roll back: 1 transactions, 4429 rows
Aug 19 08:26:39 lena mysqld[31907]: 2021-08-19 8:26:39 0 [Note] InnoDB: Rolled back recovered transaction 72059950460843816
Aug 19 08:26:39 lena mysqld[31907]: 2021-08-19 8:26:39 0 [Note] InnoDB: Rollback of non-prepared transactions completed