[xamp 3.2.4] Error: MySQL shutdown unexpectedly (win10 x64)

[amiens80]

hi,

suddenly this morning, mysql does not want to start at all.
i checked the port 3306 : no conflict
i tested to run with admin priviledge : no solve, still problem
i test to use the "backup" folder instead the data : no solve, still problem

here the last log (today) when i tried :

InnoDB: using atomic writes.
2021-12-02 10:28:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-02 10:28:13 0 [Note] InnoDB: Uses event mutexes
2021-12-02 10:28:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-02 10:28:13 0 [Note] InnoDB: Number of pools: 1
2021-12-02 10:28:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-02 10:28:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-02 10:28:13 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-02 10:28:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-02 10:28:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-02 10:28:13 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-02 10:28:13 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-12-02 10:28:13 0 [Note] InnoDB: Waiting for purge to start
2021-12-02 10:28:13 0 [Note] InnoDB: 10.4.8 started; log sequence number 15669403; transaction id 35411
2021-12-02 10:28:13 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-12-02 10:28:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-02 10:28:13 0 [Note] Server socket created on IP: '::'.

i don't know if it can help, but here is the last GOOD LOG when mysql works fine:

InnoDB: using atomic writes.
2021-11-29 9:10:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-29 9:10:26 0 [Note] InnoDB: Uses event mutexes
2021-11-29 9:10:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-29 9:10:26 0 [Note] InnoDB: Number of pools: 1
2021-11-29 9:10:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-29 9:10:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-29 9:10:26 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-29 9:10:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=15654617
2021-11-29 9:10:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-29 9:10:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-11-29 9:10:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-29 9:10:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-29 9:10:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-29 9:10:26 0 [Note] InnoDB: Waiting for purge to start
2021-11-29 9:10:26 0 [Note] InnoDB: 10.4.8 started; log sequence number 15654626; transaction id 35386
2021-11-29 9:10:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-29 9:10:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-29 9:10:27 0 [Note] InnoDB: Buffer pool(s) load completed at 211129 9:10:27
2021-11-29 9:10:27 0 [Note] Server socket created on IP: '::'.

i hope you can help me to understand and solve the issue.

i remember i closed my laptop without stop the process before, but i closed the phpmyadmin and browser, to i guess there were not any sql query in progress during the shutdown.

thanks for read and help me.

[Altrea]

Hi,

This log does not contain any errors.

Try to start MariaDB as console application in XAMPP Shell with the following command and tell us what it responses.

Code: Select all

mysqld --defaults-file=mysql\bin\my.ini --standalone --console

[amiens80]

thank you for the reply. i just tried this command in the shell and got that result :

# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2021-12-02 11:19:54 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-12-02 11:19:54 0 [Note] mysqld (mysqld 10.4.8-MariaDB) starting as process 11944 ...
InnoDB: using atomic writes.
2021-12-02 11:19:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-02 11:19:54 0 [Note] InnoDB: Uses event mutexes
2021-12-02 11:19:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-02 11:19:54 0 [Note] InnoDB: Number of pools: 1
2021-12-02 11:19:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-02 11:19:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-02 11:19:54 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-02 11:19:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-02 11:19:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-02 11:19:54 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-02 11:19:54 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-12-02 11:19:54 0 [Note] InnoDB: Waiting for purge to start
2021-12-02 11:19:54 0 [Note] InnoDB: 10.4.8 started; log sequence number 15669421; transaction id 35411
2021-12-02 11:19:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-12-02 11:19:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-02 11:19:54 0 [Note] Server socket created on IP: '::'.
2021-12-02 11:19:54 0 [Note] InnoDB: Buffer pool(s) load completed at 211202 11:19:54
2021-12-02 11:19:54 7 [Note] Reading Master_info: 'master-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-12-02 11:19:54 7 [Warning] 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.
2021-12-02 11:19:54 7 [ERROR] log 2021-11-29 9:10:27 7 [Note] Initialized Master_info from 'master-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@00 listed in the index, but failed to stat
2021-12-02 11:19:54 7 [ERROR] Error counting relay log space
2021-12-02 11:19:54 7 [ERROR] Initialized Master_info from 'master-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2021-12-02 11:19:54 7 [Note] Added new Master_info '2021-11-09 9:01:46 0 [Note] Reading of all Master_info entries succ' to hash table
2021-12-02 11:19:54 7 [Note] Reading Master_info: 'master-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2021-12-02 11:19:54 7 [Note] Initialized Master_info from 'master-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table9:54 7 [Note] Added new Master_info '2021-11-09 9:01:46 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4hash table
2021-12-02 11:19:54 7 [Note] Started replication for '2021-11-09 9:01:46 0 [Note] Added new Master_info '' to hash tabl'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000020' position: 4
2021-12-02 11:19:54 7 [Note] Reading Master_info: 'master-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master:46 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Added new Master_info '' to hash table
2021-12-02 11:19:54 7 [Note] Initialized Master_info from 'master-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-12-02 11:19:54 7 [Note] Added new Master_info '2021-11-09 9:01:46 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready fo' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4xe: ready for connections.2021-12-02 11:19:54 10 [ERROR] Master '2021-11-09 9:01:46 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-12-02 11:19:54 7 [Note] Started replication for '2021-11-09 9:01:46 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d11@002d09@0020@00209@003a01@003a46@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000020' position: 4
': Slave I/O thread killed while connecting to master1:46 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.2021-12-02 11:19:54 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' Relay_info:'relay-log-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] c:\xampp\mysql\bin\mysqld.exe: ready for connections.2021-12-02 11:19:54 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-12-02 11:19:54 7 [Note] Added new Master_info 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binar' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4db.org binary distribution2021-12-02 11:19:54 12 [ERROR] Master 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-12-02 11:19:54 7 [Note] Started replication for 'Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org bin'ry distribution
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e8@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000001' position: 4
': Slave I/O thread killed while connecting to master8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution2021-12-02 11:19:54 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread exiting, read up to log 'FIRST', position 4 socket: '' port: 3306 mariadb.org binary distribution2021-12-02 11:19:54 0 [ERROR] Failed to initialize multi master structures
2021-12-02 11:19:54 0 [ERROR] Aborting

[Altrea]

Hi,

Please try the following fix. It already helped lots of users solving the multi-master Problem:

• Open your folder "\xampp\mysql\data"
• Delete the file "multi-master.info"
• Delete all files beginning with "master-"
• Delete all files beginning with "mysql_relay-bin-"
• Delete all files beginning with "relay-log-"
• Delete all files beginning with "ib_logfile"
• Delete all files beginning with "aria_log."

Now try to start mariadb the normal way again.

[amiens80]

i delete the files.
after that, there are now :

ib_buffer_pool
ibdata1
my.ini
mysql_error.log

and of course, the folders for each databases

so, i started again (xamp start button in panel). same error.
i tested fro mthe shell again , and got this log :

# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2021-12-02 11:37:30 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-12-02 11:37:30 0 [Note] mysqld (mysqld 10.4.8-MariaDB) starting as process 17196 ...
InnoDB: using atomic writes.
2021-12-02 11:37:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-02 11:37:30 0 [Note] InnoDB: Uses event mutexes
2021-12-02 11:37:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-02 11:37:30 0 [Note] InnoDB: Number of pools: 1
2021-12-02 11:37:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-02 11:37:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-02 11:37:30 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-02 11:37:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-02 11:37:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-02 11:37:30 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-02 11:37:30 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-12-02 11:37:30 0 [Note] InnoDB: Waiting for purge to start
2021-12-02 11:37:31 0 [Note] InnoDB: 10.4.8 started; log sequence number 15669781; transaction id 35411
2021-12-02 11:37:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-12-02 11:37:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-02 11:37:31 0 [Note] Server socket created on IP: '::'.
2021-12-02 11:37:31 0 [ERROR] mysqld: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2021-12-02 11:37:31 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2021-12-02 11:37:31 0 [ERROR] Aborting

after that, some files re-appear :
aria_log
aria_log_control
ib_logfile0
ib_logfile1

have you an idea if the problem come from a database (one or all) or from mysql server itself ?

[Altrea]

2021-12-02 11:37:31 0 [ERROR] mysqld: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2021-12-02 11:37:31 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2021-12-02 11:37:31 0 [ERROR] Aborting

This is not the same error, this is a different one.

your mysql database needs to be repaired.

To do this please open the XAMPP Shell by clicking the Shell button in your XAMPP Control Panel and execute the following command:

Code: Select all

mysqld --console --skip-grant-tables --skip-external-locking

Leave this black command line window open and click on the Shell button in the Control Panel again to open a second command line window and execute this command:

Code: Select all

mysqlcheck -r --databases mysql --use-frm

After that you Can close both command line Windows and try to start mysql again normally from your XAMPP control panel

[amiens80]

hi,

again, thank for the help.
i done:

Code: Select all

mysqld --console --skip-grant-tables --skip-external-locking

and get:

2021-12-03 9:12:25 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-12-03 9:12:25 0 [Note] mysqld (mysqld 10.4.8-MariaDB) starting as process 12488 ...
InnoDB: using atomic writes.
2021-12-03 9:12:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-03 9:12:25 0 [Note] InnoDB: Uses event mutexes
2021-12-03 9:12:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-03 9:12:25 0 [Note] InnoDB: Number of pools: 1
2021-12-03 9:12:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-03 9:12:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-03 9:12:25 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-03 9:12:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-03 9:12:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-03 9:12:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-03 9:12:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-12-03 9:12:26 0 [Note] InnoDB: Waiting for purge to start
2021-12-03 9:12:26 0 [Note] InnoDB: 10.4.8 started; log sequence number 15669799; transaction id 35411
2021-12-03 9:12:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-12-03 9:12:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-03 9:12:26 0 [Note] Server socket created on IP: '::'.
2021-12-03 9:12:26 0 [Note] InnoDB: Buffer pool(s) load completed at 211203 9:12:26
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone_leap_second'
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone_name'
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone'
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition_type'
2021-12-03 9:12:26 0 [Note] Zerofilling moved table: '.\mysql\time_zone_transition'
2021-12-03 9:12:26 0 [Note] Reading of all Master_info entries succeeded
2021-12-03 9:12:26 0 [Note] Added new Master_info '' to hash table
2021-12-03 9:12:26 0 [Note] mysqld: ready for connections.

then in the other second shell, i done

Code: Select all

mysqlcheck -r --databases mysql --use-frm

and get:

mysql.column_stats OK
mysql.columns_priv OK
mysql.db
info : Wrong CRC on datapage at 1
status : OK
mysql.event OK
mysql.func OK
mysql.global_priv
warning : Number of rows changed from 0 to 4
status : OK
mysql.gtid_slave_pos
note : The storage engine for the table doesn't support repair
mysql.help_category
warning : Number of rows changed from 0 to 48
status : OK
mysql.help_keyword
warning : Number of rows changed from 0 to 37
status : OK
mysql.help_relation
warning : Number of rows changed from 0 to 114
status : OK
mysql.help_topic
warning : Number of rows changed from 0 to 752
status : OK
mysql.index_stats OK
mysql.innodb_index_stats
note : The storage engine for the table doesn't support repair
mysql.innodb_table_stats
note : The storage engine for the table doesn't support repair
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv
warning : Number of rows changed from 0 to 1
status : 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
note : The storage engine for the table doesn't support repair

after the 2nd command line, the first one display have been updated with :

Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2021-12-03 9:13:34 8 [Note] Found 4 of 0 rows when repairing '.\mysql\global_priv'
2021-12-03 9:13:34 8 [Note] Found 48 of 0 rows when repairing '.\mysql\help_category'
2021-12-03 9:13:34 8 [Note] Found 37 of 0 rows when repairing '.\mysql\help_keyword'
2021-12-03 9:13:34 8 [Note] Found 114 of 0 rows when repairing '.\mysql\help_relation'
2021-12-03 9:13:34 8 [Note] Found 752 of 0 rows when repairing '.\mysql\help_topic'
2021-12-03 9:13:34 8 [Note] Found 1 of 0 rows when repairing '.\mysql\proxies_priv'

then, i started mysql by hitting the start button in the panel, and it looks it's running.

after that, i check the error log fro mthis 2 commands line and get that :

InnoDB: using atomic writes.
2021-12-03 9:11:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-03 9:11:23 0 [Note] InnoDB: Uses event mutexes
2021-12-03 9:11:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-03 9:11:23 0 [Note] InnoDB: Number of pools: 1
2021-12-03 9:11:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-03 9:11:23 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-03 9:11:23 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-03 9:11:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-03 9:11:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-03 9:11:23 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-03 9:11:23 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-12-03 9:11:23 0 [Note] InnoDB: Waiting for purge to start
2021-12-03 9:11:23 0 [Note] InnoDB: 10.4.8 started; log sequence number 15669790; transaction id 35411
2021-12-03 9:11:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-12-03 9:11:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-03 9:11:23 0 [Note] InnoDB: Buffer pool(s) load completed at 211203 9:11:23
2021-12-03 9:11:23 0 [Note] Server socket created on IP: '::'.
2021-12-03 9:18:55 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 18% 28% 41% 55% 67% 79% 94% 100% (0.0 seconds); tables to flush: 2 1 0
(0.0 seconds);
2021-12-03 9:18:55 0 [Note] mysqld.exe: Aria engine: recovery done


InnoDB: using atomic writes.
2021-12-03 9:18:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-03 9:18:55 0 [Note] InnoDB: Uses event mutexes
2021-12-03 9:18:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-03 9:18:55 0 [Note] InnoDB: Number of pools: 1
2021-12-03 9:18:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-03 9:18:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-03 9:18:55 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-03 9:18:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=15669799
2021-12-03 9:18:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-03 9:18:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-12-03 9:18:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-03 9:18:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-03 9:18:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-12-03 9:18:55 0 [Note] InnoDB: Waiting for purge to start
2021-12-03 9:18:55 0 [Note] InnoDB: 10.4.8 started; log sequence number 15669808; transaction id 35411
2021-12-03 9:18:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-12-03 9:18:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-03 9:18:55 0 [Note] Zerofilling moved table: '.\mysql\plugin'
2021-12-03 9:18:55 0 [Note] Zerofilling moved table: '.\mysql\servers'
2021-12-03 9:18:55 0 [Note] InnoDB: Buffer pool(s) load completed at 211203 9:18:55
2021-12-03 9:18:55 0 [Note] Server socket created on IP: '::'.

then i will check the databases, i hope none have been "broken".

Thank you again for the help.
by the way, do you have any idea of what was heppened?

Important question :
do you have a documentation of what the folder xamp/mysql/backup should contains ? the periodic backup in there ? because for me, there is only ONE TIME backup there , not everyday. i thought xamp will perform automatic backup in this folder, but i doubt of that now. by judging the dates in xamp/mysql/backup , it only backuped the day i installed the application.

Best regards

[Altrea]

Hi,

again, thank for the help.

You are very welcome
Thanks to the very detailed reply of all the responses. This seems to look good.

by the way, do you have any idea of what was heppened?

Kind of. These two issues are from my point of view problems with either the way XAMPP for Windows is stopping the MariaDB process or with the XAMPP MariaDB default configuration.
I am just a volunteer supporter and not a XAMPP developer, so i cannot be completely sure.

do you have a documentation of what the folder xamp/mysql/backup should contains ? the periodic backup in there ? because for me, there is only ONE TIME backup there , not everyday. i thought xamp will perform automatic backup in this folder, but i doubt of that now. by judging the dates in xamp/mysql/backup , it only backuped the day i installed the application.

The backup folder contains working files by delivery. So you can copy files from there to get to a working MariaDB instance again.
Of cause not every file can get replaced without data loss (ibdata1 file for example). That is why i do only recommend replacing files from there as very very last solution.