Home / user-127070

trejder's questions

Martin Hope
trejder
Asked: 2023-10-21 01:43:42 +0800 CST
  • 6

About 5-6 days after each fresh installation of (the newest) XAMPP 8.2.4 on Windows 11 Pro (10.0.22621 Build 22621), MariaDB 10.4.28 on-board it starts to fail during every run:

Sometimes I am getting an error directly in XAMPP:

Attempting to start MySQL app...
Status change detected: running
Status change detected: stopped
Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies, 
improper privileges, a crash, or a shutdown by another method.

I am a total newbie, but I think there isn't anything "unusual" in mysql_error.log:

[Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 20488
[Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
[Note] InnoDB: Uses event mutexes
[Note] InnoDB: Compressed tables use zlib 1.2.12
[Note] InnoDB: Number of pools: 1
[Note] InnoDB: Using SSE2 crc32 instructions
[Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
[Note] InnoDB: Completed initialization of buffer pool
[Note] InnoDB: 128 out of 128 rollback segments are active.
[Note] InnoDB: Creating shared tablespace for temporary tables
[Note] InnoDB: Setting file 'C:\XAMPP\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[Note] InnoDB: File 'C:\XAMPP\mysql\data\ibtmp1' size is now 12 MB.
[Note] InnoDB: 10.4.28 started; log sequence number 1972203; transaction id 2830
[Note] InnoDB: Loading buffer pool(s) from C:\XAMPP\mysql\data\ib_buffer_pool
[Note] Plugin 'FEEDBACK' is disabled.
[Note] Server socket created on IP: '::'.

But the Windows Event Log has seriously puzzling entries.

For each run I am getting either only this:

Aborting
Fatal error: Can't open and lock privilege tables: Incorrect file format 'db'

Or the above followed by:

mysqld.exe: Aria engine: checkpoint failed
mysqld.exe: Can't sync file 'C:\XAMPP\mysql\data\aria_log.00000001' to disk (Errcode: 9 "Bad file descriptor")
mysqld.exe: Error writing file 'C:\XAMPP\mysql\data\aria_log.00000001' (Errcode: 9 "Bad file descriptor")

The "Bad file descriptor" is something that rings the "broken disk" bell in my head, but Windows say no:

enter image description here

(...)
0 bad file records processed.
Phase duration (Bad file record checking): 1.61 milliseconds.
(...)
Windows has scanned the file system and found no problems.
No further action is required.

I tried the "idiot" way of simply deleting the aria_log.00000001. All I achieved was:

  • One time startup of MariaDB
  • Adding extra line to log that aria_log.00000001 was not found
  • Creating and using aria_log.00000002, aria_log.00000003 etc.

But that was just a "virtual" run. All the clients could see that MariaDB is running (XAMPP having Status change detected: running as the last log line and no error), but in fact it was some kind of a weird "lock" that clients cannot detect this fact and hangs without timeout forever:

enter image description here

The same goes for browsers, which shows "circling circle" forever, until I manually kill db.

After that everything goes back to "normal" meaning Error: MySQL shutdown unexpectedly. on each and every run.

I haven't tried the "bruteforce mode" (here). When the serie of "unexpected shutdowns" starts, I am simply:

  • Uninstalling XAMPP (backing up data)
  • Deleting the whole C:\XAMPP folder
  • Doing fresh-install of XAMPP 8.2.4

After this, I am always "good for the next couple of days". Usually five to six.

I've been using XAMPP for Windows for 10+ years, on Windows versions starting XP and never experienced any problems. Until now.

Is there anything that I can do, except for getting rid of XAMPP forever and trying some other LAMP (since re-install doesn't bring anything)?

EDIT: There was no update neither to Maria DB nor the whole server-like system (Apache/XAMPP). Everything sticks on XAMPP 8.2.4 and MariaDB 10.4.28strong text for at least half of year. The only "updates" are my constant sequences of uninstall-install back (did so right now).

EDIT: This is Windows 11 Pro (10.0.22621 Build 22621), so underlying storage system is a single SSD drive (KBG50ZNS512G NVMe KIOXIA 512 GB; 475 GB true capacity). This is a brand new laptop, so the disk has been running for 2,5 weeks so far.

windows
Martin Hope
trejder
Asked: 2014-05-19 04:18:27 +0800 CST
  • 0

Following are set and confirmed:

  • I've set $cfg['Servers'][$i]['LoginCookieValidity'] = 259200; in config.inc.php,
  • I've set session.gc_maxlifetime = 259200 in php.ini,
  • I see value 259200 in Settings > Features > General tab, in Login cookie validity field, in phpMyAdmin.

And even so, my phpMyAdmin logs-off automatically, with message, that there was no action for past 1440 seconds (default pMA's value) and re-login is required. So, it still ignores my setting of 259200 seconds (three days).

What other settings or factors may influence this behavior?

EDIT: I'm using XAMPP for Windows, and I've observed this behavior only on one of my computers, though I'm using exactly the same settings set (entire XAMPP unpacked from common .zip file) on my every machine (other computers keeps pMA session for 3 days. This makes case even more suspicious.

php.ini