MariaDB:Why running 2 years = 20 spontaneous stops?

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MariaDB:Why running 2 years = 20 spontaneous stops?

Postby Viking75 » 16. July 2021 12:29

Hello,
Firstly, I would like to say I love XAMPP. Thanks a lot to the people who works effortless on this project.

So, my current XAMPP installation is about 2 years old.
I run a virtual machine with Win 10 pro.
Maria DB: 10.3.16
XAMPP. XAMPP for Windows 7.3.7
Wordpress: WordPress 5.2.11

Out of knowwhere MariaDB breakes down, for a long time I could just start it againg, via XAMPP control panel.
But lately, more serious work was required to get it back up:

2021-07-08: I had to edit My.ini file, and insclude under [mysqld] "-skip-grant-tables"
2021-07-15: It would not start, and I had to empty content of multi-master.info i xampp/mysql/data.

So, can anybody give a diagnosis to why it since the begining has performed periodic instantaious unprovoked turned-off/breakdowns?


Below is my mysqlerrorfile is truncated, so most old posts not includede since messageboard only allows 60000 characters:

2019-07-15 9:50:41 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-15 9:50:41 0 [Note] InnoDB: Uses event mutexes
2019-07-15 9:50:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-15 9:50:41 0 [Note] InnoDB: Number of pools: 1
2019-07-15 9:50:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-15 9:50:41 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-15 9:50:41 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-15 9:50:41 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1791378
2019-07-15 9:50:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-15 9:50:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-15 9:50:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-15 9:50:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-15 9:50:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-15 9:50:42 0 [Note] InnoDB: Waiting for purge to start
2019-07-15 9:50:42 0 [Note] InnoDB: 10.3.16 started; log sequence number 1791387; transaction id 163
2019-07-15 9:50:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-15 9:50:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-15 9:50:42 0 [Note] Server socket created on IP: '::'.
2019-07-15 10:09:12 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:12 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:12 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-15 10:09:12 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-15 10:09:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-15 10:09:12 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-15 10:09:12 0 [ERROR] Aborting

2019-07-15 10:09:12 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:12 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:12 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-15 10:09:12 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-15 10:09:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-15 10:09:12 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-15 10:09:12 0 [ERROR] Aborting

2019-07-15 10:09:14 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:14 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:14 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-15 10:09:14 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-15 10:09:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-15 10:09:14 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-15 10:09:14 0 [ERROR] Aborting

2019-07-15 10:09:15 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:15 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:15 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-15 10:09:15 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-15 10:09:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-15 10:09:15 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-15 10:09:15 0 [ERROR] Aborting

2019-07-15 10:09:15 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:15 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-15 10:09:15 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-15 10:09:15 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-15 10:09:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-15 10:09:15 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-15 10:09:15 0 [ERROR] Aborting

2019-07-15 15:38:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-15 15:38:20 0 [Note] InnoDB: Uses event mutexes
2019-07-15 15:38:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-15 15:38:20 0 [Note] InnoDB: Number of pools: 1
2019-07-15 15:38:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-15 15:38:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-15 15:38:20 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-15 15:38:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3487391
2019-07-15 15:38:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-15 15:38:21 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-15 15:38:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-15 15:38:21 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-15 15:38:21 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-15 15:38:21 0 [Note] InnoDB: Waiting for purge to start
2019-07-15 15:38:21 0 [Note] InnoDB: 10.3.16 started; log sequence number 3487400; transaction id 1074
2019-07-15 15:38:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-15 15:38:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-15 15:38:21 0 [Note] Server socket created on IP: '::'.
2019-07-15 15:40:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-15 15:40:32 0 [Note] InnoDB: Uses event mutexes
2019-07-15 15:40:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-15 15:40:32 0 [Note] InnoDB: Number of pools: 1
2019-07-15 15:40:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-15 15:40:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-15 15:40:32 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-15 15:40:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3487723
2019-07-15 15:40:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-15 15:40:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-15 15:40:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-15 15:40:32 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-15 15:40:32 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-15 15:40:32 0 [Note] InnoDB: Waiting for purge to start
2019-07-15 15:40:32 0 [Note] InnoDB: 10.3.16 started; log sequence number 3487732; transaction id 1085
2019-07-15 15:40:32 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-15 15:40:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-15 15:40:32 0 [Note] Server socket created on IP: '::'.
2019-07-22 8:40:45 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-22 8:40:45 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-07-22 8:40:45 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-22 8:40:45 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-22 8:40:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-22 8:40:45 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-07-22 8:40:45 0 [ERROR] Aborting

2019-07-22 9:17:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-22 9:17:49 0 [Note] InnoDB: Uses event mutexes
2019-07-22 9:17:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-22 9:17:49 0 [Note] InnoDB: Number of pools: 1
2019-07-22 9:17:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-22 9:17:49 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-22 9:17:49 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-22 9:17:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7122969
2019-07-22 9:17:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-22 9:17:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-22 9:17:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-22 9:17:50 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-22 9:17:50 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-22 9:17:50 0 [Note] InnoDB: Waiting for purge to start
2019-07-22 9:17:50 0 [Note] InnoDB: 10.3.16 started; log sequence number 7122978; transaction id 3784
2019-07-22 9:17:50 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-22 9:17:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-22 9:17:50 0 [Note] Server socket created on IP: '::'.
2019-09-27 8:26:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-27 8:26:36 0 [Note] InnoDB: Uses event mutexes
2019-09-27 8:26:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-27 8:26:36 0 [Note] InnoDB: Number of pools: 1
2019-09-27 8:26:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-27 8:26:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-27 8:26:36 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-27 8:26:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=20586205
2019-09-27 8:26:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-27 8:26:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-27 8:26:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-27 8:26:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...



TRUNCATED (was onlt notes, as above from please wait.. to please wait section)


2020-01-16 8:51:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-01-16 8:51:28 0 [Note] InnoDB: Waiting for purge to start
2020-01-16 8:51:28 0 [Note] InnoDB: 10.3.16 started; log sequence number 199071394; transaction id 138721
2020-01-16 8:51:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-01-16 8:51:28 0 [Note] InnoDB: Buffer pool(s) load completed at 200116 8:51:28
2020-01-16 8:51:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-01-16 8:51:28 0 [Note] Server socket created on IP: '::'.
2020-01-16 8:51:28 0 [Warning] 'db' entry 's 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.16-MariaDB

key_buffer_size=16777216

read_buffer_siz@91122 8:28:07 [ERROR] mysqld got exception 0x80000003 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against i' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
2020-01-16 8:51:28 0 [Warning] 'db' entry ' 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...

@nnections=0

max_threads=65537

thread_count=6

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20117 K bytes of' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
2020-01-16 8:51:29 0 [Note] Reading of all Master_info entries succeeded
2020-01-16 8:51:29 0 [Note] Added new Master_info '' to hash table
2020-01-16 8:51:29 0 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.3.16-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2020-01-16 9:08:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-01-16 9:08:35 0 [Note] InnoDB: Uses event mutexes
2020-01-16 9:08:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-01-16 9:08:35 0 [Note] InnoDB: Number of pools: 1
2020-01-16 9:08:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-01-16 9:08:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-01-16 9:08:35 0 [Note] InnoDB: Completed initialization of buffer pool
2020-01-16 9:08:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=199599247
2020-01-16 9:08:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-01-16 9:08:35 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-01-16 9:08:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-01-16 9:08:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-01-16 9:08:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-01-16 9:08:35 0 [Note] InnoDB: 10.3.16 started; log sequence number 199599256; transaction id 138834
2020-01-16 9:08:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-01-16 9:08:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-01-16 9:08:35 0 [Note] Server socket created on IP: '::'.
2020-02-13 14:24:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-02-13 14:24:33 0 [Note] InnoDB: Uses event mutexes
2020-02-13 14:24:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-02-13 14:24:33 0 [Note] InnoDB: Number of pools: 1
2020-02-13 14:24:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-02-13 14:24:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-02-13 14:24:33 0 [Note] InnoDB: Completed initialization of buffer pool
2020-02-13 14:24:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=237988188
2020-02-13 14:24:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-02-13 14:24:34 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-02-13 14:24:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-02-13 14:24:34 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-02-13 14:24:34 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-02-13 14:24:34 0 [Note] InnoDB: Waiting for purge to start
2020-02-13 14:24:34 0 [Note] InnoDB: 10.3.16 started; log sequence number 237988197; transaction id 170044
2020-02-13 14:24:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-02-13 14:24:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-13 14:24:34 0 [Note] InnoDB: Buffer pool(s) load completed at 200213 14:24:34
2020-02-13 14:24:34 0 [Note] Server socket created on IP: '::'.
2020-03-12 10:44:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-12 10:44:53 0 [Note] InnoDB: Uses event mutexes
2020-03-12 10:44:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-12 10:44:53 0 [Note] InnoDB: Number of pools: 1
2020-03-12 10:44:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-12 10:44:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-12 10:44:53 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-12 10:44:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=301688433
2020-03-12 10:44:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-12 10:44:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-12 10:44:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-12 10:44:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-12 10:44:53 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-12 10:44:53 0 [Note] InnoDB: Waiting for purge to start
2020-03-12 10:44:53 0 [Note] InnoDB: 10.3.16 started; log sequence number 301688442; transaction id 204775
2020-03-12 10:44:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-03-12 10:44:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-12 10:44:54 0 [Note] InnoDB: Buffer pool(s) load completed at 200312 10:44:54
2020-03-12 10:44:54 0 [Note] Server socket created on IP: '::'.
2020-03-12 22:10:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-12 22:10:45 0 [Note] InnoDB: Uses event mutexes
2020-03-12 22:10:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-12 22:10:45 0 [Note] InnoDB: Number of pools: 1
2020-03-12 22:10:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-12 22:10:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-12 22:10:45 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-12 22:10:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=312698018
2020-03-12 22:10:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-12 22:10:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-12 22:10:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-12 22:10:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-12 22:10:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-12 22:10:47 0 [Note] InnoDB: Waiting for purge to start
2020-03-12 22:10:47 0 [Note] InnoDB: 10.3.16 started; log sequence number 312698027; transaction id 209133
2020-03-12 22:10:47 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-03-12 22:10:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-12 22:10:47 0 [Note] Server socket created on IP: '::'.
2020-04-10 22:09:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-10 22:09:12 0 [Note] InnoDB: Uses event mutexes
2020-04-10 22:09:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-10 22:09:12 0 [Note] InnoDB: Number of pools: 1
2020-04-10 22:09:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-10 22:09:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-10 22:09:12 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-10 22:09:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=400537156
2020-04-10 22:09:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-10 22:09:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-10 22:09:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-10 22:09:13 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-10 8:39:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-03-10 8:39:49 0 [Note] InnoDB: Uses event mutexes
2021-03-10 8:39:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-10 8:39:49 0 [Note] InnoDB: Number of pools: 1
2021-03-10 8:39:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-03-10 8:39:49 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-03-10 8:39:49 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-10 8:39:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1034577858
2021-03-10 8:39:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-03-10 8:39:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-03-10 8:39:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-03-10 8:39:51 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-03-10 8:39:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-03-10 8:39:51 0 [Note] InnoDB: Waiting for purge to start
2021-03-10 8:39:51 0 [Note] InnoDB: 10.3.16 started; log sequence number 1034577867; transaction id 684698
2021-03-10 8:39:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-03-10 8:39:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-03-10 8:39:51 0 [Note] Server socket created on IP: '::'.
2021-04-15 9:19:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-04-15 9:19:26 0 [Note] InnoDB: Uses event mutexes
2021-04-15 9:19:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-15 9:19:26 0 [Note] InnoDB: Number of pools: 1
2021-04-15 9:19:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-04-15 9:19:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-04-15 9:19:26 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-15 9:19:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1114273734
2021-04-15 9:19:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-04-15 9:19:27 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-04-15 9:19:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-15 9:19:27 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-04-15 9:19:27 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-04-15 9:19:27 0 [Note] InnoDB: Waiting for purge to start
2021-04-15 9:19:27 0 [Note] InnoDB: 10.3.16 started; log sequence number 1114273743; transaction id 717607
2021-04-15 9:19:27 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-04-15 9:19:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-04-15 9:19:27 0 [Note] Server socket created on IP: '::'.
2021-05-12 8:53:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-12 8:53:16 0 [Note] InnoDB: Uses event mutexes
2021-05-12 8:53:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-12 8:53:16 0 [Note] InnoDB: Number of pools: 1
2021-05-12 8:53:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-12 8:53:16 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-12 8:53:16 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-12 8:53:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1182885585
2021-05-12 8:53:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-12 8:53:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-05-12 8:53:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-12 8:53:17 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-12 8:53:17 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-12 8:53:17 0 [Note] InnoDB: Waiting for purge to start
2021-05-12 8:53:17 0 [Note] InnoDB: 10.3.16 started; log sequence number 1182885594; transaction id 742898
2021-05-12 8:53:17 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-05-12 8:53:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-12 8:53:17 0 [Note] Server socket created on IP: '::'.
2021-06-10 8:23:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-06-10 8:23:53 0 [Note] InnoDB: Uses event mutexes
2021-06-10 8:23:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-10 8:23:53 0 [Note] InnoDB: Number of pools: 1
2021-06-10 8:23:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-06-10 8:23:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-06-10 8:23:53 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-10 8:23:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1538051822
2021-06-10 8:23:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-06-10 8:23:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-06-10 8:23:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-06-10 8:23:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-06-10 8:23:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-06-10 8:23:55 0 [Note] InnoDB: Waiting for purge to start
2021-06-10 8:23:55 0 [Note] InnoDB: 10.3.16 started; log sequence number 1538051831; transaction id 778720
2021-06-10 8:23:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-06-10 8:23:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-10 8:23:55 0 [Note] Server socket created on IP: '::'.
2021-07-01 15:30:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-01 15:30:12 0 [Note] InnoDB: Uses event mutexes
2021-07-01 15:30:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-01 15:30:12 0 [Note] InnoDB: Number of pools: 1
2021-07-01 15:30:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-01 15:30:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-01 15:30:12 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-01 15:30:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1626887284
2021-07-01 15:30:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-01 15:30:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-01 15:30:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-01 15:30:13 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-01 15:30:13 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-01 15:30:13 0 [Note] InnoDB: Waiting for purge to start
2021-07-01 15:30:13 0 [Note] InnoDB: 10.3.16 started; log sequence number 1626887293; transaction id 802400
2021-07-01 15:30:13 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-01 15:30:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-01 15:30:13 0 [Note] Server socket created on IP: '::'.
2021-07-02 11:53:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-02 11:53:29 0 [Note] InnoDB: Uses event mutexes
2021-07-02 11:53:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-02 11:53:29 0 [Note] InnoDB: Number of pools: 1
2021-07-02 11:53:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-02 11:53:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-02 11:53:29 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-02 11:53:29 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1630078063
2021-07-02 11:53:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-02 11:53:29 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-02 11:53:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-02 11:53:29 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-02 11:53:29 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-02 11:53:29 0 [Note] InnoDB: Waiting for purge to start
2021-07-02 11:53:29 0 [Note] InnoDB: 10.3.16 started; log sequence number 1630078072; transaction id 802908
2021-07-02 11:53:29 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-02 11:53:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-02 11:53:29 0 [Note] Server socket created on IP: '::'.
2021-07-02 12:04:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-02 12:04:48 0 [Note] InnoDB: Uses event mutexes
2021-07-02 12:04:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-02 12:04:48 0 [Note] InnoDB: Number of pools: 1
2021-07-02 12:04:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-02 12:04:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-02 12:04:48 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-02 12:04:48 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1630078081
2021-07-02 12:04:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-02 12:04:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-02 12:04:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-02 12:04:48 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-02 12:04:48 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-02 12:04:48 0 [Note] InnoDB: 10.3.16 started; log sequence number 1630078090; transaction id 802908
2021-07-02 12:04:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-02 12:04:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-02 12:04:48 0 [Note] Server socket created on IP: '::'.
2021-07-02 13:06:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-02 13:06:06 0 [Note] InnoDB: Uses event mutexes
2021-07-02 13:06:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-02 13:06:06 0 [Note] InnoDB: Number of pools: 1
2021-07-02 13:06:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-02 13:06:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-02 13:06:06 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-02 13:06:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1630160473
2021-07-02 13:06:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-02 13:06:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-02 13:06:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-02 13:06:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-02 13:06:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-02 13:06:07 0 [Note] InnoDB: Waiting for purge to start
2021-07-02 13:06:07 0 [Note] InnoDB: 10.3.16 started; log sequence number 1630160482; transaction id 802982
2021-07-02 13:06:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-02 13:06:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-02 13:06:07 0 [Note] Server socket created on IP: '::'.
2021-07-02 13:23:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-02 13:23:50 0 [Note] InnoDB: Uses event mutexes
2021-07-02 13:23:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-02 13:23:50 0 [Note] InnoDB: Number of pools: 1
2021-07-02 13:23:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-02 13:23:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-02 13:23:50 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-02 13:23:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1635434764
2021-07-02 13:23:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-02 13:23:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-02 13:23:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-02 13:23:50 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-02 13:23:50 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-02 13:23:50 0 [Note] InnoDB: 10.3.16 started; log sequence number 1635434773; transaction id 803545
2021-07-02 13:23:50 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-02 13:23:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-02 13:23:50 0 [Note] Server socket created on IP: '::'.
2021-07-07 8:25:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-07 8:25:56 0 [Note] InnoDB: Uses event mutexes
2021-07-07 8:25:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-07 8:25:56 0 [Note] InnoDB: Number of pools: 1
2021-07-07 8:25:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-07 8:25:56 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-07 8:25:56 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-07 8:25:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266141
2021-07-07 8:25:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-07 8:25:57 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-07 8:25:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-07 8:25:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-07 8:25:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-07 8:25:57 0 [Note] InnoDB: Waiting for purge to start
2021-07-07 8:25:57 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266150; transaction id 815100
2021-07-07 8:25:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-07 8:25:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-07 8:25:57 0 [Note] Server socket created on IP: '::'.
2021-07-07 11:16:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-07 11:16:05 0 [Note] InnoDB: Uses event mutexes
2021-07-07 11:16:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-07 11:16:05 0 [Note] InnoDB: Number of pools: 1
2021-07-07 11:16:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-07 11:16:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-07 11:16:05 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-07 11:16:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266159
2021-07-07 11:16:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-07 11:16:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-07 11:16:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-07 11:16:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-07 11:16:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-07 11:16:07 0 [Note] InnoDB: Waiting for purge to start
2021-07-07 11:16:07 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266168; transaction id 815100
2021-07-07 11:16:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-07 11:16:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-07 11:16:07 0 [Note] Server socket created on IP: '::'.
2021-07-07 15:25:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-07 15:25:10 0 [Note] InnoDB: Uses event mutexes
2021-07-07 15:25:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-07 15:25:10 0 [Note] InnoDB: Number of pools: 1
2021-07-07 15:25:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-07 15:25:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-07 15:25:10 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-07 15:25:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266177
2021-07-07 15:25:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-07 15:25:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-07 15:25:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-07 15:25:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-07 15:25:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-07 15:25:11 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266186; transaction id 815100
2021-07-07 15:25:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-07 15:25:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-07 15:25:11 0 [Note] Server socket created on IP: '::'.
2021-07-07 15:56:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-07 15:56:02 0 [Note] InnoDB: Uses event mutexes
2021-07-07 15:56:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-07 15:56:02 0 [Note] InnoDB: Number of pools: 1
2021-07-07 15:56:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-07 15:56:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-07 15:56:02 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-07 15:56:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266195
2021-07-07 15:56:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-07 15:56:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-07 15:56:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-07 15:56:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-07 15:56:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-07 15:56:03 0 [Note] InnoDB: Waiting for purge to start
2021-07-07 15:56:03 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266204; transaction id 815100
2021-07-07 15:56:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-07 15:56:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-07 15:56:03 0 [Note] Server socket created on IP: '::'.
2021-07-08 9:01:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-08 9:01:36 0 [Note] InnoDB: Uses event mutexes
2021-07-08 9:01:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-08 9:01:36 0 [Note] InnoDB: Number of pools: 1
2021-07-08 9:01:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-08 9:01:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-08 9:01:36 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-08 9:01:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266213
2021-07-08 9:01:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-08 9:01:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-08 9:01:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-08 9:01:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-08 9:01:37 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-08 9:01:37 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266222; transaction id 815100
2021-07-08 9:01:37 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-08 9:01:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-08 9:01:37 0 [Note] Server socket created on IP: '::'.
2021-07-08 12:23:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-08 12:23:36 0 [Note] InnoDB: Uses event mutexes
2021-07-08 12:23:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-08 12:23:36 0 [Note] InnoDB: Number of pools: 1
2021-07-08 12:23:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-08 12:23:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-08 12:23:36 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-08 12:23:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266256
2021-07-08 12:23:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-08 12:23:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-08 12:23:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-08 12:23:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-08 12:23:37 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-08 12:23:37 0 [Note] InnoDB: Waiting for purge to start
2021-07-08 12:23:37 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266265; transaction id 815100
2021-07-08 12:23:37 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-08 12:23:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-08 12:23:37 0 [Note] Server socket created on IP: '::'.
2021-07-08 12:30:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-08 12:30:25 0 [Note] InnoDB: Uses event mutexes
2021-07-08 12:30:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-08 12:30:25 0 [Note] InnoDB: Number of pools: 1
2021-07-08 12:30:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-08 12:30:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-08 12:30:25 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-08 12:30:25 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266274
2021-07-08 12:30:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-08 12:30:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-08 12:30:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-08 12:30:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-08 12:30:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-08 12:30:26 0 [Note] InnoDB: Waiting for purge to start
2021-07-08 12:30:26 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266283; transaction id 815100
2021-07-08 12:30:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-08 12:30:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-08 12:30:26 0 [Note] Server socket created on IP: '::'.
2021-07-08 13:12:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-08 13:12:49 0 [Note] InnoDB: Uses event mutexes
2021-07-08 13:12:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-08 13:12:49 0 [Note] InnoDB: Number of pools: 1
2021-07-08 13:12:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-08 13:12:49 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-08 13:12:49 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-08 13:12:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266292
2021-07-08 13:12:49 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-08 13:12:49 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-08 13:12:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-08 13:12:49 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-08 13:12:49 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-08 13:12:49 0 [Note] InnoDB: Waiting for purge to start
2021-07-08 13:12:49 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266301; transaction id 815100
2021-07-08 13:12:49 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-08 13:12:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-08 13:12:49 0 [Note] Server socket created on IP: '::'.
2021-07-08 13:18:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-08 13:18:05 0 [Note] InnoDB: Uses event mutexes
2021-07-08 13:18:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-08 13:18:05 0 [Note] InnoDB: Number of pools: 1
2021-07-08 13:18:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-08 13:18:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-08 13:18:05 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-08 13:18:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266310
2021-07-08 13:18:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-08 13:18:05 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-08 13:18:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-08 13:18:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-08 13:18:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-08 13:18:05 0 [Note] InnoDB: Waiting for purge to start
2021-07-08 13:18:05 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266319; transaction id 815100
2021-07-08 13:18:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-08 13:18:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-08 13:18:05 0 [Note] Server socket created on IP: '::'.
2021-07-08 13:28:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-08 13:28:30 0 [Note] InnoDB: Uses event mutexes
2021-07-08 13:28:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-08 13:28:30 0 [Note] InnoDB: Number of pools: 1
2021-07-08 13:28:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-08 13:28:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-08 13:28:30 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-08 13:28:30 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266328
2021-07-08 13:28:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-08 13:28:30 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-08 13:28:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-08 13:28:30 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-08 13:28:30 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-08 13:28:30 0 [Note] InnoDB: Waiting for purge to start
2021-07-08 13:28:30 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266337; transaction id 815100
2021-07-08 13:28:30 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-08 13:28:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-08 13:28:30 0 [Note] Server socket created on IP: '::'.
2021-07-08 16:36:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-08 16:36:59 0 [Note] InnoDB: Uses event mutexes
2021-07-08 16:36:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-08 16:36:59 0 [Note] InnoDB: Number of pools: 1
2021-07-08 16:36:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-08 16:36:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-08 16:36:59 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-08 16:36:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1696266346
2021-07-08 16:36:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-08 16:36:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-08 16:36:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-08 16:36:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-08 16:36:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-08 16:36:59 0 [Note] InnoDB: Waiting for purge to start
2021-07-08 16:36:59 0 [Note] InnoDB: 10.3.16 started; log sequence number 1696266355; transaction id 815100
2021-07-08 16:36:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-08 16:36:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-08 16:36:59 0 [Note] Server socket created on IP: '::'.
2021-07-15 14:08:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-15 14:08:54 0 [Note] InnoDB: Uses event mutexes
2021-07-15 14:08:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-15 14:08:54 0 [Note] InnoDB: Number of pools: 1
2021-07-15 14:08:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-15 14:08:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-15 14:08:54 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-15 14:08:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1823398145
2021-07-15 14:08:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-15 14:08:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-15 14:08:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-15 14:08:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-15 14:08:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-15 14:08:55 0 [Note] InnoDB: Waiting for purge to start
2021-07-15 14:08:55 0 [Note] InnoDB: 10.3.16 started; log sequence number 1823398154; transaction id 831976
2021-07-15 14:08:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-15 14:08:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-15 14:08:55 0 [Note] Server socket created on IP: '::'.
2021-07-15 14:09:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-15 14:09:55 0 [Note] InnoDB: Uses event mutexes
2021-07-15 14:09:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-15 14:09:55 0 [Note] InnoDB: Number of pools: 1
2021-07-15 14:09:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-15 14:09:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-15 14:09:55 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-15 14:09:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-15 14:09:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-15 14:09:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-15 14:09:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-15 14:09:55 0 [Note] InnoDB: Waiting for purge to start
2021-07-15 14:09:55 0 [Note] InnoDB: 10.3.16 started; log sequence number 1823398163; transaction id 831976
2021-07-15 14:09:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-15 14:09:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-15 14:09:55 0 [Note] Server socket created on IP: '::'.
2021-07-15 14:24:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-15 14:24:56 0 [Note] InnoDB: Uses event mutexes
2021-07-15 14:24:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-15 14:24:56 0 [Note] InnoDB: Number of pools: 1
2021-07-15 14:24:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-15 14:24:56 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-15 14:24:56 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-15 14:24:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-15 14:24:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-15 14:24:56 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-15 14:24:56 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-15 14:24:56 0 [Note] InnoDB: Waiting for purge to start
2021-07-15 14:24:56 0 [Note] InnoDB: 10.3.16 started; log sequence number 1823398172; transaction id 831976
2021-07-15 14:24:56 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-15 14:24:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-15 14:24:56 0 [Note] InnoDB: Buffer pool(s) load completed at 210715 14:24:56
2021-07-15 14:24:57 0 [Note] Server socket created on IP: '::'.
2021-07-15 16:01:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-15 16:01:45 0 [Note] InnoDB: Uses event mutexes
2021-07-15 16:01:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-15 16:01:45 0 [Note] InnoDB: Number of pools: 1
2021-07-15 16:01:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-15 16:01:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-15 16:01:45 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-15 16:01:45 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-15 16:01:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-15 16:01:45 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-15 16:01:45 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-15 16:01:45 0 [Note] InnoDB: Waiting for purge to start
2021-07-15 16:01:45 0 [Note] InnoDB: 10.3.16 started; log sequence number 1823398199; transaction id 831976
2021-07-15 16:01:45 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-15 16:01:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-15 16:01:45 0 [Note] Server socket created on IP: '::'.
2021-07-15 16:13:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-15 16:13:44 0 [Note] InnoDB: Uses event mutexes
2021-07-15 16:13:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-15 16:13:44 0 [Note] InnoDB: Number of pools: 1
2021-07-15 16:13:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-15 16:13:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-15 16:13:44 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-15 16:13:44 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1823546288
2021-07-15 16:13:45 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-15 16:13:45 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-15 16:13:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-15 16:13:45 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-15 16:13:45 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-07-15 16:13:45 0 [Note] InnoDB: Waiting for purge to start
2021-07-15 16:13:45 0 [Note] InnoDB: 10.3.16 started; log sequence number 1823546297; transaction id 832080
2021-07-15 16:13:45 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-07-15 16:13:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-15 16:13:45 0 [Note] Server socket created on IP: '::'.

Thanks in advance,
Viking
Viking75
 
Posts: 5
Joined: 15. July 2021 14:35
XAMPP version: 3.2.4
Operating System: Windows 10 Pro

Re: MariaDB:Why running 2 years = 20 spontaneous stops?

Postby Viking75 » 03. August 2021 14:04

Hi,
Am I suffering from a bug in MariaDB, and should I upgrade to the newest version of MariaDB 10.3.xx? (I can see 10.3 i supported for a few years more)

I got found some info from the Windows event viewer logs:

Got error 126 when reading table '.\mysql\user'

mysqld.exe: Index for table '.\mysql\user.MYI' is corrupt; try to repair it

Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593

Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.

Failed to initialize multi master structures

mysqld.exe: Error in indexfile for table 'user': Try to repair it.

Reading of some Master_info entries failed


Failed to open the relay log '.\mysql-relay-bin-2021@002d07@002d02@002011@003a53@003a29@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000001' (relay_log_pos 4)

Could not find target log during relay log initialization

Initialized Master_info from 'master-2021@002d07@002d02@002011@003a53@003a29@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed.


If anybody can help, it would be great.

Best regards,
Viking
Viking75
 
Posts: 5
Joined: 15. July 2021 14:35
XAMPP version: 3.2.4
Operating System: Windows 10 Pro

Re: MariaDB:Why running 2 years = 20 spontaneous stops?

Postby Viking75 » 03. August 2021 14:10

Hi again,
More info, now from my PhpMyAdmin (XAMPP):

Warning in .\libraries\classes\Dbi\DbiMysqli.php#213
mysqli_query(): (HY000/126): Index for table '.\mysql\user.MYI' is corrupt; try to repair it

Backtrace

.\libraries\classes\Dbi\DbiMysqli.php#213: mysqli_query(
,
string 'SELECT 1 FROM mysql.user LIMIT 1',
integer 0,
)
.\libraries\classes\DatabaseInterface.php#319: PhpMyAdmin\Dbi\DbiMysqli->realQuery(
string 'SELECT 1 FROM mysql.user LIMIT 1',
,
integer 1,
)
.\libraries\classes\DatabaseInterface.php#2286: PhpMyAdmin\DatabaseInterface->tryQuery(
string 'SELECT 1 FROM mysql.user LIMIT 1',
integer 256,
integer 1,
)
.\libraries\classes\DatabaseInterface.php#2228: PhpMyAdmin\DatabaseInterface->isUserType(string 'super')
.\libraries\server_common.inc.php#41: PhpMyAdmin\DatabaseInterface->isSuperuser()
.\index.php#169: include(.\libraries\server_common.inc.php)

Hope it helps to give an overview of the problem
Best regards,
Viking
Viking75
 
Posts: 5
Joined: 15. July 2021 14:35
XAMPP version: 3.2.4
Operating System: Windows 10 Pro

Re: MariaDB:Why running 2 years = 20 spontaneous stops?

Postby Viking75 » 03. August 2021 16:56

Hi again,

I now did mysqlcheck of all databases in MariaDB. mysql db had 4 errors, all other databases were OK.

Setting environment for using XAMPP for Windows.
Iso-service@SERV-ISO c:\xampp
# mysqlcheck test

Iso-service@SERV-ISO c:\xampp
# mysqlcheck mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db
warning : Size of datafile is: 5444 Should be: 3165
error : got error: 137 when reading datafile at record: 8
error : Corrupt

mysql.event OK
mysql.func OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host
warning : Size of indexfile is: 13783 Should be: 2048
warning : Size of datafile is: 2306 Should be: 0
error : got error: 137 when reading datafile at record: 5
error : Corrupt

mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv
warning : Size of datafile is: 14218 Should be: 2538
error : got error: 137 when reading datafile at record: 11
error : Corrupt

mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv
warning : Size of indexfile is: 12429 Should be: 4096
status : OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name
warning : Size of datafile is: 87 Should be: 0
error : got error: 137 when reading datafile at record: 0
error : Corrupt

mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry OK
mysql.user
warning : Size of indexfile is: 13965 Should be: 4096
warning : Size of datafile is: 13832 Should be: 552
error : Can't read indexpage from filepos: 2048
Error : Index for table '.\mysql\user.MYI' is corrupt; try to repair it
error : Corrupt


Now I will start to repair mysql.user table with mysqlcheck command.
Best regards,
Viking75
Viking75
 
Posts: 5
Joined: 15. July 2021 14:35
XAMPP version: 3.2.4
Operating System: Windows 10 Pro

Re: MariaDB:Why running 2 years = 20 spontaneous stops?

Postby Viking75 » 03. August 2021 17:10

hi,
Found this great link. Explained how to repair the mysql database, which I did. And now alle tables are OK. Remains to be seen, if stabililty has arrived to my MariaDB, or other issues remain to be fixed?
( I have some

https://stackoverflow.com/questions/57128891/how-repair-corrupt-xampp-mysql-user-table


Iso-service@SERV-ISO c:\xampp
# mysqlcheck mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry OK
mysql.user OK

Iso-service@SERV-ISO c:\xampp
#

Best regards
Viking75
Viking75
 
Posts: 5
Joined: 15. July 2021 14:35
XAMPP version: 3.2.4
Operating System: Windows 10 Pro


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 27 guests