InnoDB: Error: row_search_for_mysql() is called without ha_innobase::external_lock()
Bug #832679 reported by
Anton
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_
Changed in percona-server: | |
status: | New → Confirmed |
importance: | Undecided → Low |
assignee: | nobody → Valentine Gostev (longbow) |
Changed in percona-server: | |
status: | Confirmed → Triaged |
assignee: | Stewart Smith (stewart) → nobody |
Changed in percona-server: | |
status: | Triaged → New |
To post a comment you must log in.
The query affected:
DROP TEMPORARY TABLE IF EXISTS TMP_VIEW;
learn_ primary_ key INT(20),
evaluation _status_ date DATETIME
DROP TABLE IF EXISTS VIEW;
CREATE TEMPORARY TABLE TMP_VIEW (
) 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;