Apache Friends Support Forum

Hello,

I’ve had this error since today and i don't know why..
Can someone help me ?

logs

Code: Select all

2020-02-21 17:41:28 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2020-02-21 17:41:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-02-21 17:41:28 0 [Note] InnoDB: Uses event mutexes
2020-02-21 17:41:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-02-21 17:41:28 0 [Note] InnoDB: Number of pools: 1
2020-02-21 17:41:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-02-21 17:41:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-02-21 17:41:28 0 [Note] InnoDB: Completed initialization of buffer pool
2020-02-21 17:41:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2020-02-21 17:41:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibdata1' size is now 10 MB.
2020-02-21 17:41:28 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2020-02-21 17:41:28 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2020-02-21 17:41:28 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2020-02-21 17:41:28 0 [Note] InnoDB: New log files created, LSN=11452
2020-02-21 17:41:28 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-02-21 17:41:28 0 [Note] InnoDB: Doublewrite buffer created
2020-02-21 17:41:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-02-21 17:41:28 0 [Note] InnoDB: Creating foreign key constraint system tables.
2020-02-21 17:41:28 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-02-21 17:41:28 0 [Note] InnoDB: Creating sys_virtual system tables.
2020-02-21 17:41:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-02-21 17:41:29 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-02-21 17:41:29 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-02-21 17:41:29 0 [Note] InnoDB: Waiting for purge to start
2020-02-21 17:41:29 0 [Note] InnoDB: 10.4.11 started; log sequence number 0; transaction id 7
2020-02-21 17:41:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-21 17:41:29 0 [Note] Server socket created on IP: '::'.

Yes I have suddenly got this, anyone any ideas?

I was on the latest 7.4.2 , I have gone back to 7.4.1 and it is ok.

I have the same problem. This morning it worked, I shut down the pc, and 4 hours later restarted and the MYsql fails to load.
Is 7.4.2 really stable, maybe after a few days it will also stop.

Really appreciate this problem being treated as a matter of urgency.

Regards
Drachsi

Drachsi wrote:Really appreciate this problem being treated as a matter of urgency.

Then you really *should* provide that info to the MariaDB development, not to Bitnami. You must not forget, Bitnami does not do any software development, they "only" build packages of programs. The development and bug fixes are done by the development teams (i.e. https://mariadb.org/).

Hi, really appreciate the info. Did not know. Hopefully they also see these posts?

Regards
Northampton

Drachsi wrote: Hopefully they also see these posts?

No, definately NOT! This is only one of many many many distributions which distributes MariaDB. Therefore i told you, its ON YOU to provide your problems directly to MariaDB team. Only "hoping" is by far not enough.

Maybe as a number of the latest versions of Xampp all use MariaDB 10.4.11, it is not the DB at all? only the result.

Drachsi

I am facing the same error. seems it is not my case only

Hi, I test with the following steps and this work for me:

1. Installing a second Xampp and rename the folder of installation to: xampp2, them you can installing all.

2. copy and paste to the new installation folder of xampp2 the following folders: mysql, htdocs from the other xampp folder that is fail, and close all Xampp folder. After you can start the xampp again but you need go to the new folder xampp2 and execute the xamp-control-panel of new xampp2 folder and the mysql work again.

3. take a backup of your databases for the future.