MySQL crashes when I access localhost

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL crashes when I access localhost

Postby niklaso » 23. September 2019 20:46

I am running Wordpress on a local enviorment and suddenly MySQL crashed, and after that it crashed every time i tried accessing localhost. I added "innodb_flush_method=normal" to my.ini as I saw that may solve it but no luck. I can access http://localhost/phpmyadmin/. This is MySQL crash log with default config.
Code: Select all
InnoDB: using atomic writes.
2019-09-18 21:38:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-18 21:38:52 0 [Note] InnoDB: Uses event mutexes
2019-09-18 21:38:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-18 21:38:52 0 [Note] InnoDB: Number of pools: 1
2019-09-18 21:38:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-18 21:38:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-18 21:38:52 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-18 21:38:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-18 21:38:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-18 21:38:52 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-18 21:38:52 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-18 21:38:52 0 [Note] InnoDB: Waiting for purge to start
2019-09-18 21:38:52 0 [Note] InnoDB: 10.4.6 started; log sequence number 294606; transaction id 138
2019-09-18 21:38:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-18 21:38:52 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-18 21:38:52 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-18 22:41:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-18 22:41:42 0 [Note] InnoDB: Uses event mutexes
2019-09-18 22:41:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-18 22:41:42 0 [Note] InnoDB: Number of pools: 1
2019-09-18 22:41:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-18 22:41:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-18 22:41:42 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-18 22:41:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2936196
2019-09-18 22:41:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-18 22:41:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-18 22:41:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-18 22:41:42 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-18 22:41:42 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-18 22:41:42 0 [Note] InnoDB: Waiting for purge to start
2019-09-18 22:41:42 0 [Note] InnoDB: 10.4.6 started; log sequence number 2936205; transaction id 2472
2019-09-18 22:41:42 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-18 22:41:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-18 22:41:42 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-22 15:50:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-22 15:50:48 0 [Note] InnoDB: Uses event mutexes
2019-09-22 15:50:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-22 15:50:48 0 [Note] InnoDB: Number of pools: 1
2019-09-22 15:50:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-22 15:50:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-22 15:50:48 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-22 15:50:48 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=62890796
2019-09-22 15:50:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-22 15:50:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-22 15:50:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-22 15:50:48 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-22 15:50:48 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-22 15:50:48 0 [Note] InnoDB: Waiting for purge to start
2019-09-22 15:50:48 0 [Note] InnoDB: 10.4.6 started; log sequence number 62890805; transaction id 67156
2019-09-22 15:50:48 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-22 15:50:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-22 15:50:48 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:15:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:15:15 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:15:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:15:15 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:15:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:15:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:15:15 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:15:15 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131145675
2019-09-23 21:15:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:15:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:15:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:15:16 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:15:16 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:15:16 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:15:16 0 [Note] InnoDB: 10.4.6 started; log sequence number 131145684; transaction id 182907
2019-09-23 21:15:16 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:15:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:15:16 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:17:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:17:01 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:17:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:17:01 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:17:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:17:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:17:01 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:17:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131145693
2019-09-23 21:17:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:17:01 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:17:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:17:01 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:17:01 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:17:01 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:17:02 0 [Note] InnoDB: 10.4.6 started; log sequence number 131145702; transaction id 182907
2019-09-23 21:17:02 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:17:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:17:02 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:17:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:17:43 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:17:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:17:43 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:17:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:17:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:17:43 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:17:43 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131145711
2019-09-23 21:17:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:17:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:17:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:17:44 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:17:44 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:17:44 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:17:44 0 [Note] InnoDB: 10.4.6 started; log sequence number 131145720; transaction id 182907
2019-09-23 21:17:44 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:17:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:17:44 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:20:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:20:38 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:20:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:20:38 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:20:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:20:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:20:38 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:20:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131145745
2019-09-23 21:20:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:20:39 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:20:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:20:39 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:20:39 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:20:39 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:20:39 0 [Note] InnoDB: 10.4.6 started; log sequence number 131145754; transaction id 182907
2019-09-23 21:20:39 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:20:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:20:39 0 [Note] Server socket created on IP: '::'.
2019-09-23 21:20:39 0 [Note] InnoDB: Buffer pool(s) load completed at 190923 21:20:39
2019-09-23 21:20:39 0 [Note] Reading of all Master_info entries succeeded
2019-09-23 21:20:39 0 [Note] Added new Master_info '' to hash table
2019-09-23 21:20:39 0 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.6-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2019-09-23 21:22:03 0x3048  InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\btr\btr0cur.cc line 7988
InnoDB: Failing assertion: space_id == page_get_space_id(page)
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
190923 21:22:03 [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 is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.4.6-MariaDB
key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=2
max_threads=65537
thread_count=8
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20285 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x1f76c5bf538
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...
mysqld.exe!my_parameter_handler()
ucrtbase.dll!raise()
ucrtbase.dll!abort()
mysqld.exe!parse_user()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!parse_user()
mysqld.exe!?ha_rnd_next@handler@@QEAAHPEAE@Z()
mysqld.exe!?rr_sequential@@YAHPEAUREAD_RECORD@@@Z()
mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAUst_join_table@@_N@Z()
mysqld.exe!?disjoin@?$List@VItem@@@@QEAAXPEAV1@@Z()
mysqld.exe!?exec_inner@JOIN@@QEAAXXZ()
mysqld.exe!?exec@JOIN@@QEAAXXZ()
mysqld.exe!?mysql_select@@YA_NPEAVTHD@@PEAUTABLE_LIST@@IAEAV?$List@VItem@@@@PEAVItem@@IPEAUst_order@@434_KPEAVselect_result@@PEAVst_select_lex_unit@@PEAVst_select_lex@@@Z()
mysqld.exe!?handle_select@@YA_NPEAVTHD@@PEAULEX@@PEAVselect_result@@K@Z()
mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@@Z()
mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEADIPEAVParser_state@@_N3@Z()
mysqld.exe!?dispatch_command@@YA_NW4enum_server_command@@PEAVTHD@@PEADI_N3@Z()
mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
mysqld.exe!?pool_of_threads_scheduler@@YAXPEAUscheduler_functions@@PEAKPEAI@Z()
mysqld.exe!?tp_callback@@YAXPEAUTP_connection@@@Z()
ntdll.dll!TpReleaseWait()
ntdll.dll!RtlInitializeResource()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x1f76c5c6800): SELECT `option_id`, `option_name`, `option_value`, `autoload` FROM `wordpress`.`wp_options`
Connection ID (thread ID): 29
Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file at D:\xampp\mysql\data\
InnoDB: using atomic writes.
2019-09-23 21:22:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:22:57 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:22:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:22:57 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:22:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:22:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:22:57 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:22:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131146121
2019-09-23 21:22:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:22:57 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:22:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:22:57 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:22:57 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:22:57 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:22:57 0 [Note] InnoDB: 10.4.6 started; log sequence number 131146130; transaction id 182915
2019-09-23 21:22:57 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:22:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:22:57 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:25:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:25:50 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:25:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:25:50 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:25:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:25:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:25:50 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:25:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147417
2019-09-23 21:25:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:25:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:25:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:25:50 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:25:50 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:25:50 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:25:50 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147426; transaction id 182981
2019-09-23 21:25:50 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:25:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:25:50 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:26:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:26:24 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:26:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:26:24 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:26:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:26:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:26:24 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:26:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147435
2019-09-23 21:26:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:26:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:26:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:26:24 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:26:24 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:26:24 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:26:24 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147444; transaction id 182981
2019-09-23 21:26:24 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:26:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:26:24 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:28:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:28:54 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:28:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:28:54 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:28:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:28:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:28:54 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:28:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147453
2019-09-23 21:28:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:28:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:28:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:28:55 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:28:55 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:28:55 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:28:55 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147462; transaction id 182981
2019-09-23 21:28:55 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:28:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:28:55 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:29:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:29:06 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:29:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:29:06 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:29:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:29:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:29:06 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:29:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147471
2019-09-23 21:29:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:29:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:29:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:29:06 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:29:06 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:29:06 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:29:06 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147480; transaction id 182981
2019-09-23 21:29:06 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:29:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:29:06 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:29:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:29:12 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:29:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:29:12 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:29:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:29:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:29:12 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:29:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147489
2019-09-23 21:29:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:29:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:29:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:29:12 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:29:12 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:29:12 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:29:12 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147498; transaction id 182981
2019-09-23 21:29:12 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:29:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:29:12 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:29:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:29:22 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:29:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:29:22 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:29:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:29:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:29:22 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:29:22 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147507
2019-09-23 21:29:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:29:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:29:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:29:22 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:29:22 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:29:22 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:29:22 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147516; transaction id 182981
2019-09-23 21:29:22 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:29:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:29:22 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:30:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:30:16 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:30:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:30:16 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:30:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:30:16 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:30:16 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:30:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147525
2019-09-23 21:30:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:30:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:30:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:30:16 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:30:16 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:30:16 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:30:16 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147534; transaction id 182981
2019-09-23 21:30:16 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:30:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:30:16 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:32:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:32:40 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:32:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:32:40 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:32:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:32:40 0 [Note] InnoDB: Initializing buffer pool, total size = 34M, instances = 1, chunk size = 34M
2019-09-23 21:32:40 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:32:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147543
2019-09-23 21:32:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:32:40 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:32:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:32:40 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:32:40 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:32:40 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:32:40 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147552; transaction id 182981
2019-09-23 21:32:40 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:32:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:32:40 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:32:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:32:49 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:32:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:32:49 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:32:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:32:49 0 [Note] InnoDB: Initializing buffer pool, total size = 120M, instances = 1, chunk size = 120M
2019-09-23 21:32:49 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:32:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147561
2019-09-23 21:32:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:32:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:32:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:32:50 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:32:50 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:32:50 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:32:50 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147570; transaction id 182981
2019-09-23 21:32:50 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:32:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:32:50 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:33:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:33:02 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:33:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:33:02 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:33:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:33:02 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:33:02 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:33:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147579
2019-09-23 21:33:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:33:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:33:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:33:02 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:33:02 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:33:02 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:33:02 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147588; transaction id 182981
2019-09-23 21:33:02 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:33:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:33:02 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:33:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:33:56 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:33:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:33:56 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:33:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:33:56 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:33:56 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:33:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147597
2019-09-23 21:33:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:33:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:33:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:33:56 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:33:56 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:33:56 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147606; transaction id 182981
2019-09-23 21:33:56 0 [Note] InnoDB: !!! innodb_force_recovery is set to 2 !!!
2019-09-23 21:33:56 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:33:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:33:56 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:34:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:34:52 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:34:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:34:52 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:34:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:34:52 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:34:52 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:34:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147597
2019-09-23 21:34:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:34:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:34:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:34:52 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:34:52 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:34:52 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:34:53 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147615; transaction id 182981
2019-09-23 21:34:53 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:34:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:34:53 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:35:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:35:11 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:35:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:35:11 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:35:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:35:11 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:35:11 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:35:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147624
2019-09-23 21:35:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:35:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:35:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:35:11 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:35:11 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:35:11 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:35:11 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147633; transaction id 182981
2019-09-23 21:35:11 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:35:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:35:11 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:35:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:35:20 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:35:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:35:20 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:35:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:35:20 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:35:20 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:35:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147642
2019-09-23 21:35:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:35:20 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:35:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:35:20 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:35:20 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:35:20 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:35:21 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147651; transaction id 182981
2019-09-23 21:35:21 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:35:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:35:21 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:36:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:36:03 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:36:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:36:03 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:36:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:36:03 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:36:03 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:36:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147986
2019-09-23 21:36:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:36:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:36:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:36:03 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:36:03 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:36:03 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:36:03 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147995; transaction id 182989
2019-09-23 21:36:03 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:36:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:36:03 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:42:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:42:39 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:42:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:42:39 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:42:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:42:39 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:42:39 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:42:39 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131148004
2019-09-23 21:42:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:42:39 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:42:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:42:39 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:42:39 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:42:39 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:42:39 0 [Note] InnoDB: 10.4.6 started; log sequence number 131148013; transaction id 182989
2019-09-23 21:42:39 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:42:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:42:39 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:43:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:43:13 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:43:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:43:13 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:43:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:43:13 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:43:13 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:43:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131148022
2019-09-23 21:43:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:43:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:43:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:43:13 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:43:13 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:43:13 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:43:13 0 [Note] InnoDB: 10.4.6 started; log sequence number 131148031; transaction id 182989
2019-09-23 21:43:13 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:43:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:43:13 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:43:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:43:33 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:43:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:43:33 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:43:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:43:33 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:43:33 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:43:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131148040
2019-09-23 21:43:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:43:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:43:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:43:33 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:43:33 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:43:33 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:43:33 0 [Note] InnoDB: 10.4.6 started; log sequence number 131148049; transaction id 182989
2019-09-23 21:43:33 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:43:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:43:33 0 [Note] Server socket created on IP: '::'.
niklaso
 
Posts: 2
Joined: 23. September 2019 20:38
XAMPP version: 3.2.4
Operating System: Windows 10 OS build: 18362.356

Re: MySQL crashes when I access localhost

Postby niklaso » 24. September 2019 07:07

This fixed my problem, https://stackoverflow.com/questions/226172/how-do-i-repair-an-innodb-table.
niklaso
 
Posts: 2
Joined: 23. September 2019 20:38
XAMPP version: 3.2.4
Operating System: Windows 10 OS build: 18362.356


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 79 guests