CODEWITHSUNDEEP
windowsmariadbbitnami
Hugo Fernando Maia Milan
Hugo Fernando Maia Milan

Reputation: 1057

xampp windows mariadb not starting

mariaDB is not starting in my windows 10.

I am getting the following in the logs:

Cannot find checkpoint record at LSN (1,0x5c8f)
2019-12-19  9:18:13 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-12-19  9:18:13 0 [ERROR] Plugin 'Aria' init function returned error.
2019-12-19  9:18:13 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2019-12-19  9:18:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-12-19  9:18:13 0 [Note] InnoDB: Uses event mutexes
2019-12-19  9:18:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-19  9:18:13 0 [Note] InnoDB: Number of pools: 1
2019-12-19  9:18:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-12-19  9:18:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-12-19  9:18:13 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-19  9:18:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-12-19  9:18:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-19  9:18:14 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-19  9:18:14 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-12-19  9:18:14 0 [Note] InnoDB: Waiting for purge to start
2019-12-19  9:18:14 0 [Note] InnoDB: 10.4.10 started; log sequence number 42992145; transaction id 110929
2019-12-19  9:18:14 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-12-19  9:18:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-19  9:18:14 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-12-19  9:18:14 0 [Note] InnoDB: Buffer pool(s) load completed at 191219  9:18:14
2019-12-19  9:18:14 0 [ERROR] Failed to initialize plugins.
2019-12-19  9:18:14 0 [ERROR] Aborting

I have searched around and could not find a fix for this issue. Xampp was working fine yesterday but did not start today. So, what I did yesterday was to clone a wordpress website to my pc using xcloner. After I cloned the website, everything was working fine. Then, I stopped mysql and apache and shutdown my pc. This morning, I got that issue.

I had face the same issue other times and I have reinstalled xampp and wordpress (bitnami versions). However, I keep getting that problem.

Any help will be greatly appreciated.

Upvotes: 19

Views: 24211

Answers (4)

HandBlue
HandBlue

Reputation: 31

Simply deleting "xampp\mysql\data\aria_log.#######" was enough for me.

Upvotes: 2

pmaruszczyk
pmaruszczyk

Reputation: 2165

In my case the solution was to delete file multi-master.info in xampp\mysql\data

Solution comes from thread https://stackoverflow.com/a/62957955/269804

Upvotes: 2

Hugo Fernando Maia Milan
Hugo Fernando Maia Milan

Reputation: 1057

With the help of @RiggsFolly, the following solved my issue.

  1. Open cmd.
  2. In cmd, go to xampp/mysql/data folder.
    • In my case, I did the following cd C:\xampp\mysql\data
  3. Run aria_chk -r in that directory for all .MAI tables in the mysql subfolder.
    • In my case, ..\bin\aria_chk -r mysql\*.MAI
  4. Delete all aria_log.######## files. They are present in the C:\xampp\mysql\data folder. I just renamed them for just in case (added old_ in the beginning of their names).
  5. Start xampp again and it should be working.

Upvotes: 62

rompikapo
rompikapo

Reputation: 46

I tried with the solution of answer 1, it look great but in my case from cmd I got an error of permission denied for files xampp\mysql\data\mysql*.mai. Instead I found another solution.

ATTENTION: the drawback is that you lose the users created with database privileges, in my case it is not a big damage because I only had four sites locally, and it was easy for me to recreate the users in phpmyadmin.

The whole tour takes 5 minutes and you work on the folders and files, even without cmd:

  1. delete all xampp\mysql\data\mysql.mai files
  2. copy all .mai files from mysql backup folder: xampp\mysql\backup\mysql*.mai
  3. delete the aria_log.######## files in the xampp\mysql\data folder
  4. restart xampp: It works!
  5. recreate the privileged users of each database in phpmyadmin

Upvotes: 3

Related Questions