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

Bug #832679 reported by Anton
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
MariaDB
New
Undecided
Unassigned
OurDelta
New
Undecided
Unassigned
Percona Server moved to https://jira.percona.com/projects/PS
New
Low
Unassigned

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

Revision history for this message
Anton (anton-sidorov) wrote :

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;

Changed in percona-server:
status: New → Confirmed
importance: Undecided → Low
assignee: nobody → Valentine Gostev (longbow)
Revision history for this message
Valentine Gostev (longbow) wrote :

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

Changed in percona-server:
assignee: Valentine Gostev (longbow) → Stewart Smith (stewart)
Revision history for this message
Joe Julian (joe.julian) wrote :

Affects MariaDB 5.2.7-101 from the ourdelta repo

Stewart Smith (stewart)
Changed in percona-server:
status: Confirmed → Triaged
assignee: Stewart Smith (stewart) → nobody
Changed in percona-server:
status: Triaged → New
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.