Details
Minor
Description
The error is noticed on rhel5 rpms x86_64 Percona versions 5.1.54, 5.1.57 and 5.1.58
The SQL script itself runs without errors or warnings but .err file is loaded with error messages
InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock()
Gliffy Diagrams
Attachments
Issue Links
- links to
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock()
Linked branch has updated mysql-test.diff with percona_misc_row_search_error test
main.percona_misc_row_search_error [ fail ] Found warnings/errors in server log file!
Test ended at 2011-08-26 05:41:06
line
InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock()
^ Found warnings in /root/5.1/Percona-Server-5.1.58-rel12.9/mysql-test/var/log/mysqld.1.err
ok
Re: InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock()
Affects MariaDB 5.2.7-101 from the ourdelta repo
Launchpad bug id: 832679
Re: InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock()
The query affected:
DROP TEMPORARY TABLE IF EXISTS TMP_VIEW;
DROP TABLE IF EXISTS VIEW;
CREATE TEMPORARY TABLE TMP_VIEW (
learn_primary_key INT(20),
evaluation_status_date DATETIME
) TYPE = InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE TABLE VIEW (
learn_primary_key INT(20),
evaluation_status_date DATETIME
) TYPE = InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;
LOCK TABLES VIEW WRITE;
DELETE FROM VIEW;
INSERT INTO VIEW SELECT * FROM TMP_VIEW;
UNLOCK TABLES;