A frequently recurring problem with MySQL.

[Basari]

I have noticed that several forum users have the same problem.

Re-installing XAMPP fixes the error and the databases can be restored manually, but it is quite tedious to do this repeatedly and often.

Has there been a fix for this yet or an idea how to fix it easily without reinstalling? I have tried to find different solutions and tried many different things without success.

XAMPP worked for years without problems, but recently problems have started to appear.

Code: Select all

2023-11-20 17:27:20 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 12264
2023-11-20 17:27:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-20 17:27:20 0 [Note] InnoDB: Uses event mutexes
2023-11-20 17:27:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-20 17:27:20 0 [Note] InnoDB: Number of pools: 1
2023-11-20 17:27:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-20 17:27:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-20 17:27:20 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-20 17:27:20 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2023-11-20 17:27:20 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2023-11-20 17:27:20 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2023-11-20 17:27:20 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\users\users.ibd' OS error: 203
2023-11-20 17:27:20 0 [ERROR] InnoDB: Operating system error number 203 in a file operation.
2023-11-20 17:27:20 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2023-11-20 17:27:20 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``users`.`users``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2023-11-20 17:27:20 0 [Warning] InnoDB: Ignoring tablespace for `users`.`users` because it could not be opened.
2023-11-20 17:27:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-20 17:27:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-20 17:27:20 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-20 17:27:20 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-20 17:27:20 0 [Note] InnoDB: Waiting for purge to start
2023-11-20 17:27:20 0 [Note] InnoDB: 10.4.28 started; log sequence number 21488801; transaction id 51870
2023-11-20 17:27:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-20 17:27:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-20 17:27:20 0 [Note] Server socket created on IP: '::'.

Kind regards
Frustrated

[Nobbie]

Has there been a fix for this yet or an idea how to fix it easily without reinstalling?

Yes.

Configure MySQL (and probably also Apache etc.) as Windows Service. That can easily be done by simply setting a cross in the Xampp Control Panel in the "Service" column (the first one) before the Modules. After then MySQL etc. will be started automatically and shutdown CORRECTLY(!) without crashing your database. Keep in mind that from now on the Module processes will run with a different UserID, not your Windows UserID, instead the SYSTEM User. That might effect file rights etc.

Actually, this fix has been postet very often here.

[Basari]

Ah, thanks for the tip. I'll use it right away!

[dopamina]

Hi. I have configured as indicated but I still have the same problem. I am running XAMPP only locally to do some testing. Any other ideas?