InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock()

[Anton]

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()

[Anton (anton-sidorov)]

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;

[Valentine Gostev (longbow)]

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

[Joe Julian (joe.julian)]

Affects MariaDB 5.2.7-101 from the ourdelta repo

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1886