Help with a crash
am 22.01.2010 15:17:53 von ProemialRunning 5.1.34 on XP
Box has been working for form some time, however last night it
asserted out. I've attached the log output, below. I've taken the
query, that is listed, and run it without any trouble -- its only
issue being that it could use some rewriting.
I'd greatly appreciate any help in determining what went wrong, and
hopefully how to avoid it in future.
thanks!
Martin
--------
Version: '5.1.34-community-log' socket: '' port: 3306 MySQL
Community Server (GPL)
InnoDB: Error: MySQL is trying to perform a consistent read
InnoDB: but the read view is not assigned!
TRANSACTION 0 465024216, ACTIVE 0 sec, OS thread id 6108 starting
index read, thread declared inside InnoDB 0
mysql tables in use 8, locked 4
MySQL thread id 590766, query id 42766839 dt-capitalmkts3.cppib.ca
192.168.3.160 PriceWriter Sending data
SELECT orders.orderno, a.alias, orders.size, currency_list.code,
MIN(orders_timestamps.time)
FROM orders
INNER JOIN assetlibrary.asset_alias_list a
ON a.assetid = orders.assetid
AND a.sourceid = (SELECT sourceid FROM assetlibrary.data_source_list
WHERE name = 'SEDOL')
INNER JOIN trading.currency_list
ON currency_list.currencyid = orders.currencyid
INNER JOIN orders_timestamps
ON orders_timestamps.orderno = orders.orderno
AND orders_timestamps.timestampid IN (SELECT timestampid FROM
timestamp_list WHERE name IN ('Order Start','Email Date'))
WHERE NOT EXISTS(SELECT * FROM ord
100121 19:11:10 InnoDB: Assertion failure in thread 6108 in file
..\row\row0sel.c line 3647
InnoDB: Failing assertion: 0
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.1/en/forcing-recovery.html
InnoDB: about forcing recovery.
InnoDB: Thread 896 stopped in file .\handler\ha_innodb.cc line 4509
100121 19:11:10 - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=57
max_threads=100
threads_connected=21
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 170103 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd: 0xcab8018
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
006BC818 mysqld.exe!row_search_for_mysql()[row0sel.c:3647]
006A9AF0 mysqld.exe!ha_innobase::index_read()[ha_innodb.cc:4412]
0043AB09 mysqld.exe!handler::index_read_map()[handler.h:1390]
0057AD5E mysqld.exe!join_read_always_key()[sql_select.cc:11661]
0057A7C5 mysqld.exe!sub_select()[sql_select.cc:11109]
0057431D mysqld.exe!evaluate_join_record()[sql_select.cc:11224]
0057A7DE mysqld.exe!sub_select()[sql_select.cc:11115]
0057431D mysqld.exe!evaluate_join_record()[sql_select.cc:11224]
0057A7DE mysqld.exe!sub_select()[sql_select.cc:11115]
0058E7F0 mysqld.exe!do_select()[sql_select.cc:10865]
0058EE1B mysqld.exe!JOIN::exec()[sql_select.cc:1799]
0058FFA3 mysqld.exe!mysql_select()[sql_select.cc:2380]
005903DB mysqld.exe!handle_select()[sql_select.cc:268]
005539B4 mysqld.exe!execute_sqlcom_select()[sql_parse.cc:4982]
00554AF6 mysqld.exe!mysql_execute_command()[sql_parse.cc:2204]
00636614 mysqld.exe!init_available_charsets()[charset.c:447]
00636988 mysqld.exe!get_charset_by_csname()[charset.c:580]
005E85AA mysqld.exe!MYSQLparse()[sql_yacc.cc:15681]
00551F6C mysqld.exe!parse_sql()[sql_parse.cc:7770]
0055A0B6 mysqld.exe!mysql_parse()[sql_parse.cc:5867]
0055AC23 mysqld.exe!dispatch_command()[sql_parse.cc:1218]
0055BA27 mysqld.exe!do_command()[sql_parse.cc:861]
005DEC81 mysqld.exe!handle_one_connection()[sql_connect.cc:1115]
00644D1B mysqld.exe!pthread_start()[my_winthread.c:85]
0072A1A3 mysqld.exe!_callthreadstart()[thread.c:293]
FC8FE900
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0CA15FF8=SELECT orders.orderno, a.alias, orders.size,
currency_list.code, MIN(orders_timestamps.time)
FROM orders
INNER JOIN assetlibrary.asset_alias_list a
ON a.assetid = orders.assetid
AND a.sourceid = (SELECT sourceid FROM assetlibrary.data_source_list
WHERE name = 'SEDOL')
INNER JOIN trading.currency_list
ON currency_list.currencyid = orders.currencyid
INNER JOIN orders_timestamps
ON orders_timestamps.orderno = orders.orderno
AND orders_timestamps.timestampid IN (SELECT timestampid FROM
timestamp_list WHERE name IN ('Order Start','Email Date'))
WHERE NOT EXISTS(SELECT * FROM orders_pretrade_cost c WHERE c.orderno
= orders.orderno AND c.model = 'ACE(0.3)')
AND NOT EXISTS(SELECT * FROM orders_pretrade_errors e WHERE e.orderno
= orders.orderno)
GROUP BY orders.orderno, a.alias, orders.size, currency_list.code
LIMIT 100
thd->thread_id=590766
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2116 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 2120 stopped in file .\sync\sync0arr.c line 337
InnoDB: Thread 1532 stopped in file .\sync\sync0arr.c line 337
InnoDB: Thread 5980 stopped in file .\handler\ha_innodb.cc line 2229
InnoDB: Thread 896 stopped in file .\handler\ha_innodb.cc line 4473
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 2116 stopped in file .\os\os0sync.c line 579
InnoDB: Thread 2120 stopped in file .\sync\sync0arr.c line 338
InnoDB: Thread 1532 stopped in file .\sync\sync0arr.c line 338
InnoDB: Thread 5980 stopped in file .\sync\sync0arr.c line 337
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\handler\ha_innodb.cc line 4177
InnoDB: Thread 2116 stopped in file .\os\os0sync.c line 582
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 1532 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 5980 stopped in file .\sync\sync0arr.c line 338
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 896 stopped in file .\handler\ha_innodb.cc line 4360
InnoDB: Thread 2116 stopped in file .\os\os0sync.c line 600
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 5980 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\row\row0sel.c line 2257
InnoDB: Thread 2116 stopped in file .\os\os0sync.c line 602
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 896 stopped in file .\row\row0sel.c line 2387
InnoDB: Thread 2116 stopped in file .\os\os0sync.c line 606
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 579
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\buf\buf0buf.c line 1217
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 582
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 896 stopped in file
G:\mysql-5.1.34-winbuild\mysql-community-nt-5.1.34-build\sto rage\innobase\include\buf0buf.ic
line 558
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2120 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\buf\buf0buf.c line 1217
InnoDB: Thread 2120 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 896 stopped in file
G:\mysql-5.1.34-winbuild\mysql-community-nt-5.1.34-build\sto rage\innobase\include\sync0rw.ic
line 364
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 600
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\lock\lock0lock.c line 3598
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 602
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 337
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 606
InnoDB: Thread 1532 stopped in file .\os\os0sync.c line 579
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 338
InnoDB: Thread 1532 stopped in file .\os\os0sync.c line 582
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 896 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 1532 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 2120 stopped in file .\sync\sync0arr.c line 404
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 1532 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 235
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 1532 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 236
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 1532 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2112 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 1532 stopped in file .\os\os0sync.c line 600
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 1532 stopped in file .\os\os0sync.c line 602
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 1532 stopped in file .\os\os0sync.c line 606
InnoDB: Thread 5980 stopped in file .\os\os0sync.c line 579
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 5980 stopped in file .\os\os0sync.c line 582
InnoDB: Thread 1532 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 1532 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 5980 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 5980 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 1532 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 5980 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 5980 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 5980 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 5980 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 5980 stopped in file .\os\os0sync.c line 600
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 5980 stopped in file .\os\os0sync.c line 602
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 5980 stopped in file .\os\os0sync.c line 606
InnoDB: Thread 896 stopped in file .\os\os0sync.c line 579
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\os\os0sync.c line 582
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 5980 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 5980 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 5980 stopped in file .\sync\sync0arr.c line 404
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 5980 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2324 stopped in file .\dict\dict0dict.c line 313
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 896 stopped in file .\os\os0sync.c line 600
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 896 stopped in file .\os\os0sync.c line 602
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 896 stopped in file .\os\os0sync.c line 606
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 579
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 582
InnoDB: Thread 896 stopped in file .\os\os0sync.c line 271
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 896 stopped in file .\os\os0sync.c line 273
InnoDB: Thread 2120 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2120 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 896 stopped in file .\sync\sync0arr.c line 404
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 896 stopped in file .\os\os0sync.c line 574
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2120 stopped in file .\sync\sync0arr.c line 410
InnoDB: Thread 2324 stopped in file .\mem\mem0pool.c line 529
InnoDB: Thread 2120 stopped in file .\sync\sync0arr.c line 411
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 139
InnoDB: Thread 2324 stopped in file .\mem\mem0mem.c line 496
InnoDB: Thread 2116 stopped in file .\sync\sync0arr.c line 140
InnoDB: Thread 2120 stopped in file .\os\os0sync.c line 600
100122 8:25:0
--
---
This is a signature.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org