[MDEV-629] LP:832679 - InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock() Created: 2011-09-07  Updated: 2017-11-05  Resolved: 2017-11-05

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 5.1.67, 5.2.14, 5.3.12
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Anton (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 0
Labels: Launchpad, xtradb

Attachments: XML File LPexportBug832679.xml    

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

 Comments   
Comment by Anton (Inactive) [ 2011-08-24 ]

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;

Comment by Rasmus Johansson (Inactive) [ 2011-08-26 ]

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

Comment by Joe Julian (Inactive) [ 2011-09-07 ]

Re: InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock()
Affects MariaDB 5.2.7-101 from the ourdelta repo

Comment by Rasmus Johansson (Inactive) [ 2012-06-25 ]

Launchpad bug id: 832679

Comment by Elena Stepanova [ 2017-11-05 ]

Closing as there is no evidence it was observed in 5.5+, and previous versions are EOL-ed.

Generated at Thu Feb 08 06:30:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.