MYSQL Error MySQL Server wont start - Solved
Posted by: Mrwilson (---.hsd1.tn.comcast.net)
Date: November 16, 2022 08:37PM

PLEASE DELETE

Wampserver today would not start the MySQL server. Apache and PHP seem to be running, I can open the localhost page and any projects that do not use the database. How can I fix this without losing all of my projects? The problem appears to be confined to the family database. I cannot open MySQL to work on the issue, or even delete the database. Wampserver icon appears orange. I do have backups if I need to delete the Family database
Thank you for your consideration.

I have found the following information:
Win 10

Wampserver V 3.2.7 64bit
phpMyAdmin 4.8.5
php 7.3.5
Apache 2.4.39

MYSQL V 5.7.26
--- File cleaned up by Wampserver ---
--- on 2022-11-16 14:01
2022-11-16T14:02:06.554057Z 0 [ERROR] InnoDB: Space ID in fsp header is 2047597277, but in the page header it is 1417647010.
2022-11-16T14:02:06.555472Z 0 [ERROR] [FATAL] InnoDB: Tablespace id is 419 in the data dictionary but in file .\family\vanc.ibd it is 18446744073709551615!
2022-11-16 09:02:06 0x1164 InnoDB: Assertion failure in thread 4452 in file ut0ut.cc line 942

14:02:06 UTC - mysqld got exception 0x80000003 ;

7ff771093782 mysqld.exe!my_sigabrt_handler()[my_thr_init.c:449]
7ffac85fec9d MSVCR120.dll!raise()
7ffac8604874 MSVCR120.dll!abort()
7ff7711afdd4 mysqld.exe!ut_dbg_assertion_failed()[ut0dbg.cc:67]
7ff7711affb1 mysqld.exe!ib::fatal::~fatal()[ut0ut.cc:942]
7ff7711d324d mysqld.exe!fil_node_open_file()[fil0fil.cc:802]
7ff7711d3b7c mysqld.exe!fil_node_prepare_for_io()[fil0fil.cc:5356]
7ff7711d0a9e mysqld.exe!fil_io()[fil0fil.cc:5660]
7ff77130b8c8 mysqld.exe!buf_read_page_low()[buf0rea.cc:195]
7ff77130b4de mysqld.exe!buf_read_page_background()[buf0rea.cc:494]
7ff771223657 mysqld.exe!buf_load()[buf0dump.cc:681]
7ff771223e4b mysqld.exe!buf_dump_thread()[buf0dump.cc:780]
7ffb00d074b4 KERNEL32.DLL!BaseThreadInitThunk()
7ffb010026a1 ntdll.dll!RtlUserThreadStart()

key_buffer_size=268435456
read_buffer_size=2097152
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0



Edited 5 time(s). Last edit at 11/18/2022 04:56AM by Mrwilson.

Options: ReplyQuote


Sorry, only registered users may post in this forum.