Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.4.32
-
None
-
None
-
windows 11, using XAMPP, Visual Studio Code
Description
This is the mysql_error.log I get from C:\xampp\mysql\data\mysql_error.log:
2024-08-15 13:17:09 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 13164
2024-08-15 13:17:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-08-15 13:17:09 0 [Note] InnoDB: Uses event mutexes
2024-08-15 13:17:09 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-15 13:17:09 0 [Note] InnoDB: Number of pools: 1
2024-08-15 13:17:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-08-15 13:17:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-08-15 13:17:09 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-15 13:17:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-08-15 13:17:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-08-15 13:17:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-15 13:17:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-08-15 13:17:09 0 [Note] InnoDB: 10.4.32 started; log sequence number 6565867; transaction id 11185
2024-08-15 13:17:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-08-15 13:17:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-15 13:17:09 0 [Note] Server socket created on IP: '::'.
2024-08-15 13:17:09 0 [Note] InnoDB: Buffer p2024-08-15 13:17:44 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 12580
2024-08-15 13:17:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-08-15 13:17:44 0 [Note] InnoDB: Uses event mutexes
2024-08-15 13:17:44 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-15 13:17:44 0 [Note] InnoDB: Number of pools: 1
2024-08-15 13:17:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-08-15 13:17:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-08-15 13:17:44 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-15 13:17:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-08-15 13:17:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-08-15 13:17:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-15 13:17:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-08-15 13:17:44 0 [Note] InnoDB: Waiting for purge to start
2024-08-15 13:17:44 0 [Note] InnoDB: 10.4.32 started; log sequence number 6565876; transaction id 11185
2024-08-15 13:17:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-08-15 13:17:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-15 13:17:44 0 [Note] Server socket created on IP: '::'.
2024-08-15 13:17:44 0 [Note] InnoDB: Buffer pool(s) load completed at 240815 2024-08-15 13:17:46 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 14248
2024-08-15 13:17:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-08-15 13:17:46 0 [Note] InnoDB: Uses event mutexes
2024-08-15 13:17:46 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-15 13:17:46 0 [Note] InnoDB: Number of pools: 1
2024-08-15 13:17:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-08-15 13:17:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-08-15 13:17:46 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-15 13:17:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-08-15 13:17:46 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-08-15 13:17:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-08-15 13:17:46 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-15 13:17:46 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-08-15 13:17:46 0 [Note] InnoDB: Waiting for purge to start
2024-08-15 13:17:46 0 [Note] InnoDB: 10.4.32 started; log sequence number 6565876; transaction id 11185
2024-08-15 13:17:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-08-15 13:17:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-15 13:17:46 0 [Note] Server socket created on IP: '::'.
2024-08-15 13:17:53 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 4356
2024-08-15 13:17:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-08-15 13:17:53 0 [Note] InnoDB: Uses event mutexes
2024-08-15 13:17:53 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-15 13:17:53 0 [Note] InnoDB: Number of pools: 1
2024-08-15 13:17:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-08-15 13:17:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-08-15 13:17:53 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-15 13:17:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6565876
2024-08-15 13:17:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-08-15 13:17:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-08-15 13:17:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-08-15 13:17:54 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-15 13:17:54 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-08-15 13:17:54 0 [Note] InnoDB: Waiting for purge to start
2024-08-15 13:17:54 0 [Note] InnoDB: 10.4.32 started; log sequence number 6565901; transaction id 11185
2024-08-15 13:17:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-08-15 13:17:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-15 13:17:54 0 [Note] Server socket created on IP: '::'.
2024-08-15 13:18:01 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 8
2024-08-15 13:18:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-08-15 13:18:01 0 [Note] InnoDB: Uses event mutexes
2024-08-15 13:18:01 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-15 13:18:01 0 [Note] InnoDB: Number of pools: 1
2024-08-15 13:18:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-08-15 13:18:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-08-15 13:18:01 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-15 13:18:01 0 [Note] InnoDB: The log sequence number 6565876 in the system tablespace does not match the log sequence number 6565910 in the ib_logfiles!
2024-08-15 13:18:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-08-15 13:18:01 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-08-15 13:18:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-08-15 13:18:01 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-15 13:18:01 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-08-15 13:18:01 0 [Note] InnoDB: Waiting for purge to start
2024-08-15 13:18:01 0 [Note] InnoDB: 10.4.32 started; log sequence number 6565910; transaction id 11185
2024-08-15 13:18:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-08-15 13:18:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-15 13:18:01 0 [Note] Server socket created on IP: '::'.
2024-08-15 13:18:08 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 2316
2024-08-15 13:18:08 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-08-15 13:18:08 0 [Note] InnoDB: Uses event mutexes
2024-08-15 13:18:08 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-15 13:18:08 0 [Note] InnoDB: Number of pools: 1
2024-08-15 13:18:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-08-15 13:18:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-08-15 13:18:08 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-15 13:18:08 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6565910
2024-08-15 13:18:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-08-15 13:18:09 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-08-15 13:18:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-08-15 13:18:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-15 13:18:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-08-15 13:18:09 0 [Note] InnoDB: Waiting for purge to start
2024-08-15 13:18:09 0 [Note] InnoDB: 10.4.32 started; log sequence number 6565919; transaction id 11185
2024-08-15 13:18:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-08-15 13:18:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-15 13:18:09 0 [Note] Server socket created on IP: '::'.
2024-08-15 13:18:11 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 4716
2024-08-15 13:18:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-08-15 13:18:11 0 [Note] InnoDB: Uses event mutexes
2024-08-15 13:18:11 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-15 13:18:11 0 [Note] InnoDB: Number of pools: 1
2024-08-15 13:18:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-08-15 13:18:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-08-15 13:18:11 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-15 13:18:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-08-15 13:18:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-08-15 13:18:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-15 13:18:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-08-15 13:18:11 0 [Note] InnoDB: Waiting for purge to start
2024-08-15 13:18:12 0 [Note] InnoDB: 10.4.32 started; log sequence number 6565928; transaction id 11185
2024-08-15 13:18:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-08-15 13:18:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-15 13:18:12 0 [Note] InnoDB: Buffer pool(s) load completed at 240815 13:18:12
2024-08-15 13:18:12 0 [Note] Server socket created on IP: '::'.
2024-08-15 13:18:12 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay-log.info'
2024-08-15 13:18:12 7 [Warning] Neither -relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please use 'log-basename=#' or '-relay-log=mysql-relay-bin' to avoid this problem.
2024-08-15 13:18:12 7 [Note] Initialized Master_info from 'master.info'
2024-08-15 13:18:12 7 [Note] Added new Master_info '' to hash table
2024-08-15 13:18:12 8 [Note] Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2024-08-15 13:18:12 7 [Note] Started replication for ''
2024-08-15 13:18:12 9 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin.000081' position: 4
2024-08-15 13:18:12 8 [ERROR] Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2024-08-15 13:18:12 7 [Note] Reading Master_info: 'master-.info' Relay_info:'relay-log-.info'
2024-08-15 13:18:12 8 [Note] Slave I/O thread killed while connecting to master
2024-08-15 13:18:12 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4
2024-08-15 13:18:12 8 [Note] master was :3306
2024-08-15 13:18:12 7 [Note] Initialized Master_info from 'master-.info'
2024-08-15 13:18:12 7 [Note] Added new Master_info ' ' to hash table
2024-08-15 13:18:12 10 [Note] Master ' ': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2024-08-15 13:18:12 7 [Note] Started replication for ' '
2024-08-15 13:18:12 11 [Note] Master ' ': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-.000081' position: 4
2024-08-15 13:18:12 10 [ERROR] Master ' ': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2024-08-15 13:18:12 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay-log.info'
2024-08-15 13:18:12 10 [Note] Master ' ': Slave I/O thread killed while connecting to master
2024-08-15 13:18:12 10 [Note] Master ' ': Slave I/O thread exiting, read up to log 'FIRST', position 4
2024-08-15 13:18:12 10 [Note] Master ' ': master was :3306
2024-08-15 13:18:12 7 [Note] Initialized Master_info from 'master.info'
2024-08-15 13:18:12 7 [ERROR] Connection '' conflicts with existing connection ''
2024-08-15 13:18:12 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay-log.info'
2024-08-15 13:18:12 7 [Note] Initialized Master_info from 'master.info'
2024-08-15 13:18:12 7 [ERROR] Connection '' conflicts with existing connection ''
2024-08-15 13:18:12 7 [Note] Reading Master_info: 'master-.info' Relay_info:'relay-log-.info'
2024-08-15 13:18:12 7 [Note] Initialized Master_info from 'master-.info'
2024-08-15 13:18:12 7 [Note] Added new Master_info ' ' to hash table
2024-08-15 13:18:12 12 [Note] Master ' Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2024-08-15 13:18:12 7 [Note] Started replication for ' '
2024-08-15 13:18:12 13 [Note] Master ' Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-.000085' position: 4
2024-08-15 13:18:12 12 [ERROR] Master ' Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2024-08-15 13:18:12 7 [Note] Reading Master_info: 'master-.info' Relay_info:'relay-log-.info'
2024-08-15 13:18:12 12 [Note] Master ' Slave I/O thread killed while connecting to master
2024-08-15 13:18:12 12 [Note] Master ' Slave I/O thread exiting, read up to log 'FIRST', position 4
2024-08-15 13:18:12 12 [Note] Master ' master was :3306
2024-08-15 13:18:12 7 [Note] Initialized Master_info from 'master-.info'
2024-08-15 13:18:12 7 [Note] Added new Master_info ' ' to hash table
2024-08-15 13:18:12 14 [Note] Master ' ': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2024-08-15 13:18:12 7 [Note] Started replication for ' '
2024-08-15 13:18:12 15 [Note] Master ' ': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-.000085' position: 4
2024-08-15 13:18:12 14 [ERROR] Master ' ': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2024-08-15 13:18:12 14 [Note] Master ' ': Slave I/O thread killed while connecting to master
2024-08-15 13:18:12 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay-log.info'
2024-08-15 13:18:12 14 [Note] Master ' ': Slave I/O thread exiting, read up to log 'FIRST', position 4
2024-08-15 13:18:12 14 [Note] Master ' ': master was :3306
2024-08-15 13:18:12 7 [Note] Initialized Master_info from 'master.info'
2024-08-15 13:18:12 7 [ERROR] Connection '' conflicts with existing connection ''
2024-08-15 13:18:12 7 [Note] Reading Master_info: 'master-.info' Relay_info:'relay-log-.info'
2024-08-15 13:18:12 7 [Note] Initialized Master_info from 'master-.info'
2024-08-15 13:18:12 7 [ERROR] Connection ' ' conflicts with existing connection ' '
2024-08-15 13:18:12 0 [Note] Reading of all Master_info entries succeeded
2024-08-15 13:18:12 0 [ERROR] Adding new entry '' to master_info failed
2024-08-15 13:18:12 0 [ERROR] Aborting
2024-08-15 13:18:13 0 [Warning] InnoDB: Retry attempts for writing partial data failed.
2024-08-15 13:18:13 0 [ERROR] InnoDB: Write to file C:\xampp\mysql\data\ib_logfile1 failed at offset 1186816, 512 bytes should have been written, only 0 were written. Operating system error number 0. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2024-08-15 13:18:13 0x28b4 InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\fil\fil0fil.cc line 4301
InnoDB: Failing assertion: req_type.is_dblwr_recover() || err == DB_SUCCESS
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.
240815 13:18:13 [ERROR] mysqld got exception 0x80000003 ;
Sorry, we probably made a mistake, and this is a bug.
Your assistance in bug reporting will enable us to fix this for the next release.
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.32-MariaDB source revision: c4143f909528e3fab0677a28631d10389354c491
key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=65537
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20304 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
mysqld.exe!my_parameter_handler()
ucrtbase.dll!raise()
ucrtbase.dll!abort()
mysqld.exe!?append@?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@QEAAAEAV12@QEBD_K@Z()
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!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains
information that should help you find out what is causing the crash.
Writing a core file at C:\xampp\mysql\data
Minidump written to C:\xampp\mysql\data\mysqld.dmp