| Bug #70073 | Crash after some query | ||
|---|---|---|---|
| Submitted: | 18 Aug 2013 16:14 | Modified: | 4 Feb 2014 21:22 |
| Reporter: | Jorge Bastos | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S1 (Critical) |
| Version: | 5.6.13 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
[18 Aug 2013 16:14]
Jorge Bastos
[18 Aug 2013 17:27]
MySQL Verification Team
Hi! Please compress and upload the entire mysql error log. Also, check how many innodb tables you really have: SELECT table_schema,table_name,table_rows from information_schema.tables where engine='innodb';
[18 Aug 2013 17:57]
Jorge Bastos
Hi, can't give you the information the the query, it crashed when I execute: SELECT table_schema,table_name,table_rows from information_schema.tables where engine='innodb'; full .err with the error of the previous query you sent: win7, x64 2013-08-18 18:55:30 3244 [Note] Plugin 'FEDERATED' is disabled. 2013-08-18 18:55:30 3244 [Note] InnoDB: The InnoDB memory heap is disabled 2013-08-18 18:55:30 3244 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2013-08-18 18:55:30 3244 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-08-18 18:55:30 3244 [Note] InnoDB: Not using CPU crc32 instructions 2013-08-18 18:55:30 3244 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2013-08-18 18:55:30 3244 [Note] InnoDB: Completed initialization of buffer pool 2013-08-18 18:55:30 3244 [Note] InnoDB: Highest supported file format is Barracuda. 2013-08-18 18:55:30 3244 [Note] InnoDB: The log sequence numbers 4327037 and 4327037 in ibdata files do not match the log sequence number 4333147 in the ib_logfiles! 2013-08-18 18:55:30 3244 [Note] InnoDB: Database was not shutdown normally! 2013-08-18 18:55:30 3244 [Note] InnoDB: Starting crash recovery. 2013-08-18 18:55:30 3244 [Note] InnoDB: Reading tablespace information from the .ibd files... 2013-08-18 18:55:30 3244 [Note] InnoDB: Restoring possible half-written data pages 2013-08-18 18:55:30 3244 [Note] InnoDB: from the doublewrite buffer... 2013-08-18 18:55:31 3244 [Note] InnoDB: 128 rollback segment(s) are active. 2013-08-18 18:55:31 3244 [Note] InnoDB: Waiting for purge to start 2013-08-18 18:55:31 3244 [Note] InnoDB: 5.6.13 started; log sequence number 4333147 2013-08-18 18:55:31 3244 [Note] Server hostname (bind-address): '*'; port: 3306 2013-08-18 18:55:31 3244 [Note] IPv6 is available. 2013-08-18 18:55:31 3244 [Note] - '::' resolves to '::'; 2013-08-18 18:55:31 3244 [Note] Server socket created on IP: '::'. 2013-08-18 18:55:31 3244 [Note] Event Scheduler: Loaded 0 events 2013-08-18 18:55:31 3244 [Note] MySQL: ready for connections. Version: '5.6.13' socket: '' port: 3306 MySQL Community Server (GPL) 2013-08-18 18:55:42 3244 [ERROR] Invalid (old?) table or database name 'bombeiros_agd_renumerado_14-04-2013' 2013-08-18 18:55:42 3244 [ERROR] Invalid (old?) table or database name 'comercial_vd_05-05-2008' 2013-08-18 18:55:42 3244 [ERROR] Invalid (old?) table or database name 'comercial_vd_10-04-2008' 2013-08-18 18:55:42 3244 [ERROR] Invalid (old?) table or database name 'comercial_vd_25-05-2009_antes_del' 2013-08-18 18:55:42 3244 [ERROR] Invalid (old?) table or database name 'comercial_vd_28-05-2008' 2013-08-18 18:55:42 3244 [ERROR] InnoDB: InnoDB: Unable to allocate memory of size 4294955752. 2013-08-18 18:55:42 1b34 InnoDB: Assertion failure in thread 6964 in file ha_innodb.cc line 16865 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.
[18 Aug 2013 18:11]
MySQL Verification Team
I don't know why innodb is trying to allocate 4G of ram at once. That is unusual indeed. As a start, you could try see if any particular table triggers the problem? SHOW DATABASES; .. for each database in the list. SHOW TABLES; .. for each table in the list, SELECT * FROM table LIMIT 1; Be sure to use mysql command line client and not some GUI tool. Can you upload my.ini file to this bug?
[18 Aug 2013 18:24]
Jorge Bastos
My.ini 5.6.13
Attachment: my.ini (application/octet-stream, text), 4.90 KiB.
[18 Aug 2013 19:36]
Jorge Bastos
Using Console I can see the result of your query, what do you need more?
---
mysql> SELECT table_schema,table_name,table_rows from information_schema.tables
where engine='innodb';
+-----------------+----------------------+------------+
| table_schema | table_name | table_rows |
+-----------------+----------------------+------------+
| decimalfire_gin | tmpx | 0 |
| mysql | innodb_index_stats | 9 |
| mysql | innodb_table_stats | 3 |
| mysql | slave_master_info | 0 |
| mysql | slave_relay_log_info | 0 |
| mysql | slave_worker_info | 0 |
+-----------------+----------------------+------------+
6 rows in set, 309 warnings (29.84 sec)
mysql> show warnings;
+---------+------+--------------------------------------------------------------
-----------------+
| Level | Code | Message
|
+---------+------+--------------------------------------------------------------
-----------------+
| Warning | 1366 | Incorrect string value: '\xE1rios/...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xEDdicas' for column 'TABLE_COMMENT
' at row 1 |
| Warning | 1366 | Incorrect string value: '\xF5es' for column 'TABLE_COMMENT' a
t row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es' for column 'TABLE_COMMEN
T' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es n...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es n...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7a' for column 'TABLE_COMMENT' at
row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o' for column 'TABLE_COMMENT
' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7alho;...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o (s...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o Au...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o Au...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o Au...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o Au...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o Au...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o Au...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o Au...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o Au...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o Au...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o de...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es d...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es d...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE2metro...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es d...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7os pr...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7os pr...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es C...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7os pr...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7oes p...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7oes p...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7a' for column 'TABLE_COMMENT' at
row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es d...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7a' for column 'TABLE_COMMENT' at
row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es d...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE2metro...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xE3o de...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE1rios/...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xEDdicas' for column 'TABLE_COMMENT
' at row 1 |
| Warning | 1366 | Incorrect string value: '\xF5es' for column 'TABLE_COMMENT' a
t row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es' for column 'TABLE_COMMEN
T' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es n...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es n...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7a' for column 'TABLE_COMMENT' at
row 1 |
| Warning | 1366 | Incorrect string value: '\xE7a' for column 'TABLE_COMMENT' at
row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es d...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es d...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE2metro...' for column 'TABLE_COMM
ENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xF3dulos' for column 'TABLE_COMMENT
' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7a' for column 'TABLE_COMMENT' at
row 1 |
| Warning | 1366 | Incorrect string value: '\xE7a' for column 'TABLE_COMMENT' at
row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es d...' for column 'TABLE_C
OMMENT' at row 1 |
| Warning | 1366 | Incorrect string value: '\xE7\xF5es d...' for column 'TABLE_C
OMMENT' at row 1 |
+---------+------+--------------------------------------------------------------
-----------------+
64 rows in set (0.00 sec)
mysql>
[18 Aug 2013 19:47]
MySQL Verification Team
Is it possible you can put "core-file" into the [mysqld] section of my.ini and restart instance. When a crash occurs, a file called mysqld.dmp will be written to the datadir.. If you compress that and upload it this can be useful. If it is too large, put it onto ftp.oracle.com ...
[18 Aug 2013 20:09]
Jorge Bastos
Requested core file
Attachment: mysqld.dmp (application/octet-stream, text), 134.13 KiB.
[19 Aug 2013 4:54]
MySQL Verification Team
!analyze -vvvv from the mysqld.dmp
Attachment: bug70073_minidump_analysis.txt (text/plain), 10.99 KiB.
[19 Aug 2013 5:17]
MySQL Verification Team
Some ideas: Try putting into my.ini this line: innodb-stats-persistent=0 Then restart and attempt to remove the existing stats: SELECT * FROM mysql.innodb_index_stats; SELECT * FROM mysql.innodb_table_stats; DELETE FROM mysql.innodb_index_stats; DELETE FROM mysql.innodb_table_stats; Not sure why persistent stats would need to allocate all that RAM.
[19 Aug 2013 19:29]
Jorge Bastos
Hi, after the DELETE query's, it doesn't crash now.
