Bug #45496 | Performance schema: assertion fails in ha_perfschema::rnd_init:223 | ||
---|---|---|---|
Submitted: | 15 Jun 2009 10:50 | Modified: | 14 Jan 2010 18:07 |
Reporter: | Jørgen Austvik | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Performance Schema | Severity: | S2 (Serious) |
Version: | azalea-perfschema | OS: | Any |
Assigned to: | Marc ALFF | CPU Architecture: | Any |
[15 Jun 2009 10:50]
Jørgen Austvik
[2 Jul 2009 0:25]
MySQL Verification Team
To repeat this issue just run the query in fresh database?. Thanks in advance. c:\mysql>bin\mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 6.0.12-alpha-Win X64-debug Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SELECT EVENT_ID FROM performance_schema.EVENTS_WAITS_CURRENT -> WHERE THREAD_ID IN -> (SELECT THREAD_ID FROM performance_schema.PROCESSLIST) -> AND EVENT_NAME IN -> (SELECT NAME FROM performance_schema.SETUP_INSTRUMENTS -> WHERE NAME LIKE "wait/synch/%") -> LIMIT 1; Empty set (0.08 sec) mysql>
[2 Jul 2009 7:58]
Jørgen Austvik
You would have to do something like this first to get some data for the query: UPDATE performance_schema.SETUP_INSTRUMENTS SET enabled = 'YES', timed = 'YES'; --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 (id INT PRIMARY KEY, b CHAR(100) DEFAULT 'initial value') ENGINE=MyISAM; INSERT INTO t1 (id) VALUES (1), (2), (3), (4), (5), (6), (7), (8); But you are right: it seems to work now: mysql> SELECT EVENT_ID FROM performance_schema.EVENTS_WAITS_CURRENT -> WHERE THREAD_ID IN -> (SELECT THREAD_ID FROM performance_schema.PROCESSLIST) -> AND EVENT_NAME IN -> (SELECT NAME FROM performance_schema.SETUP_INSTRUMENTS -> WHERE NAME LIKE "wait/synch/%") -> LIMIT 1; +----------+ | EVENT_ID | +----------+ | 984 | +----------+ 1 row in set (0.00 sec) This report can probably be closed now?
[2 Jul 2009 23:48]
MySQL Verification Team
Thank you for the feedback. Closing as can`t repeat.
[4 Aug 2009 8:33]
Philip Stoev
This is still repeatable, but with even simpler queries such as: SELECT * FROM `information_schema` .`COLUMNS` JOIN `performance_schema` .`PROCESSLIST`; assertion: mysqld: ha_perfschema.cc:248: virtual int ha_perfschema::rnd_init(bool): Assertion `m_table == __null' failed. backtrace: ha_perfschema::rnd_init(bool)+0xa7) [0xa02dc9] handler::ha_rnd_init(bool)+0x83) [0x589d4b] init_read_record(READ_RECORD*, THD*, TABLE*, SQL_SELECT*, int, bool, bool)+0x581) [0x7d1d04] join_init_read_record(st_join_table*)+0xae) [0x705c57] JOIN_CACHE_BNL::join_matching_records(bool)+0x172) [0x6d5d68] JOIN_CACHE::join_records(bool)+0x83) [0x6d42f3] sub_select_cache(JOIN*, st_join_table*, bool)+0x6a) [0x7096d7] sub_select(JOIN*, st_join_table*, bool)+0x47) [0x709362] /build/bzr/azalea-perfschema/sql/mysqld [0x716f94] JOIN::exec()+0x2421) [0x7312eb] mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x318) [0x72bd72] handle_select(THD*, LEX*, select_result*, unsigned long)+0x1de) [0x73160a] /build/bzr/azalea-perfschema/sql/mysqld [0x689e54] mysql_execute_command(THD*)+0x9d6) [0x68b96d] mysql_parse(THD*, char const*, unsigned int, char const**)+0x276) [0x694407] dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xa84) [0x695022] do_command(THD*)+0x22b) [0x69653d] do_handle_one_connection(THD*)+0x12c) [0x682b87] handle_one_connection+0x2d) [0x682c56]
[4 Aug 2009 8:34]
Philip Stoev
1. Start server $ MTR_VERSION=1 perl mysql-test-run.pl --start-and-exit 1st; 2. Clone test-extra-6.0 and populate database $ cd mysql-test/gentest $ perl gendata-old.pl 3. Run query: SELECT * FROM `information_schema` .`COLUMNS` JOIN `performance_schema` .`PROCESSLIST`;
[4 Aug 2009 18:17]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/80077 2848 Marc Alff 2009-08-04 Bug#45496 Performance schema: assertion fails in ha_perfschema::rnd_init:223 Implemented review comments for rnd_init(), which also resolves bug 45496 added: mysql-test/suite/perfschema/r/misc.result mysql-test/suite/perfschema/t/misc.test modified: storage/perfschema/ha_perfschema.cc
[4 Nov 2009 18:21]
Marc ALFF
Already pushed in mysql-trunk-perfschema
[14 Jan 2010 10:04]
Marc ALFF
Merged in: - mysql-next-mr (Celosia / 5.5.99-m3) - mysql-6.0-codebase (6.0.14)
[14 Jan 2010 18:07]
Paul DuBois
Not in any released version. No changelog entry needed.