wampserver MySQL service not working
Posted by: thilina_25c@yahoo.com (124.43.92.---)
Date: May 22, 2019 06:13AM

I'm getting error, and i can't start the MySQL service. This server i have using since 3 years without any issue. Please see the below MySQL error log.


2019-05-21 14:41:39 6796 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave. Statement: INSERT INTO student (program_id, batch_id,counselor_id,center_id,

center_code,program_code,title, sex, full_name, first_name, last_name,

name_with_initials, name_to_be_appear,

contact_number_mobile, contact_number_home, contact_number_office,

email, fax, address, NIC_number, passport_number, nationality, religion, date_of_birth, photo,

status,registration_number, password,payment_option_id,discount,discount_reason,inquiry_id, added_date, added_by,module_exempted_status)

SELECT program_id, batch_id, counselor_id, center_id,


InnoDB: Error: trying to access page number 4294958335 in space 0,
InnoDB: space name .\ibdata1,
InnoDB: which is outside the tablespace bounds.
InnoDB: Byte offset 0, len 16384, i/o type 10.
InnoDB: If you get this error at mysqld startup, please check that
InnoDB: your my.cnf matches the ibdata files that you have in the
InnoDB: MySQL server.
2019-05-21 14:41:39 1b2c InnoDB: Assertion failure in thread 6956 in file fil0fil.cc line 5591
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to [bugs.mysql.com].
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: [dev.mysql.com]
InnoDB: about forcing recovery.

Options: ReplyQuote
Re: wampserver MySQL service not working
Posted by: RiggsFolly (Moderator)
Date: May 22, 2019 09:52AM

Hi,


This is not a WAMPServer issue it is purely MySQL related and specifically to do with Database Replication.

Can I suggest you read the following Answer on StackOverflow Mysql Warning Code 1592 Unsafe statement written to the binary log using statement format

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: wampserver MySQL service not working
Posted by: thilina_25c@yahoo.com (182.161.20.---)
Date: May 26, 2019 02:32PM

Thanks, It really helped.

Options: ReplyQuote


Sorry, only registered users may post in this forum.