Bug #93545 | MYSQL crashing more frequently. Once or twice a week or some time smore | ||
---|---|---|---|
Submitted: | 10 Dec 2018 15:46 | Modified: | 10 Dec 2018 17:08 |
Reporter: | PAVAN BHANDARI | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | OS: | Windows | |
Assigned to: | CPU Architecture: | x86 |
[10 Dec 2018 15:46]
PAVAN BHANDARI
[10 Dec 2018 15:52]
MySQL Verification Team
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php If you can provide more information, feel free to add it to this bug. Thank you for your interest in MySQL.
[10 Dec 2018 17:08]
PAVAN BHANDARI
We have been using mysql for about 3 years now and never had this issue before. Issue is MYSQL crashed and stops working all of a sudden by itself until I stop and start it again. Once I stop and start it works. I looked the server error logs and got the following message this morning. 1. Timestamp, Thread, Type, Details 2018-12-10 01:13:38, 19228, ERROR, InnoDB: InnoDB: Unable to allocate memory of size 1065016. , , , 2018-12-10 01:13:38 507c InnoDB: Assertion failure in thread 20604 in file ha_innodb.cc line 17303 , , , InnoDB: We intentionally generate a memory trap. , , , InnoDB: Submit a detailed bug report to http://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: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html , , , InnoDB: about forcing recovery. Whevever crash happens I see above message. Some times I see the following below message Timestamp, Thread, Type, Details 2018-12-10 01:13:38, 19228, ERROR, InnoDB: InnoDB: Unable to allocate memory of size 1065016. , , , 2018-12-10 01:13:38 507c InnoDB: Assertion failure in thread 20604 in file ha_innodb.cc line 17303 , , , InnoDB: We intentionally generate a memory trap. , , , InnoDB: Submit a detailed bug report to http://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: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html , , , InnoDB: about forcing recovery.