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

Bug #832679 reported by Anton on 2011-08-24
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
MariaDB
New
Undecided
Unassigned
OurDelta
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()

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)
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)
Joe Julian (joe.julian) wrote :

Affects MariaDB 5.2.7-101 from the ourdelta repo

Stewart Smith (stewart) on 2012-06-25
Changed in percona-server:
status: Confirmed → Triaged
assignee: Stewart Smith (stewart) → nobody
Changed in percona-server:
status: Triaged → New

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  Edit
Everyone can see this information.

Other bug subscribers