ib_cursor_truncate commits transaction but doesn't release schema lock

Bug #567646 reported by Stewart Smith
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
HailDB
Confirmed
Low
Stewart Smith

Bug Description

I've found that ib_cursor_truncate currently commits the transaction on success.

from api0api.c:
/* This function currently commits the transaction
on success. */
err = ddl_truncate_table(table, trx);

which isn't documented (except in the source :)

BUT, it doesn't release the schema lock... so unlike other DDL ops on success you have to release the schema lock yourself.

it'd be great if ib_cursor_truncate() was a bit more consistent with the rest of the DDL api and the user called commit (which released the schema lock).

originally reported at: http://forums.innodb.com/read.php?8,1136,1136#msg-1136

Tags: api
Stewart Smith (stewart)
Changed in haildb:
importance: Undecided → Low
status: New → Confirmed
Revision history for this message
Stewart Smith (stewart) wrote :

embedded_innodb Drizzle plugin will need to be fixed when this bug is fixed.

Stewart Smith (stewart)
tags: added: api
Lorenzo De Liso (blackz)
Changed in drizzle:
importance: Undecided → Low
status: New → Triaged
Changed in drizzle:
assignee: nobody → Stewart Smith (stewart-flamingspork)
Changed in haildb:
assignee: nobody → Stewart Smith (stewart-flamingspork)
Stewart Smith (stewart)
Changed in haildb:
milestone: none → baghdad
Changed in drizzle:
milestone: none → 2010-10-25
Stewart Smith (stewart)
Changed in drizzle:
milestone: 2010-10-25 → 2010-11-08
Stewart Smith (stewart)
Changed in haildb:
milestone: baghdad → cairo
Stewart Smith (stewart)
Changed in drizzle:
milestone: 2010-11-08 → 2010-11-22
Stewart Smith (stewart)
Changed in drizzle:
milestone: 2010-11-22 → 2010-12-06
Stewart Smith (stewart)
Changed in drizzle:
milestone: 2010-12-06 → 2010-12-20
Stewart Smith (stewart)
Changed in drizzle:
milestone: 2010-12-20 → 2011-01-03
Stewart Smith (stewart)
Changed in drizzle:
milestone: 2011-01-03 → 2011-01-17
Stewart Smith (stewart)
Changed in drizzle:
milestone: 2011-01-17 → 2011-02-14
Changed in haildb:
milestone: cairo → detroit
Stewart Smith (stewart)
Changed in drizzle:
milestone: 2011-02-14 → 2011-03-14
Stewart Smith (stewart)
Changed in drizzle:
milestone: 2011-03-14 → 2011-04-11
Changed in drizzle:
milestone: 2011-04-11 → 2011-04-25
Changed in drizzle:
milestone: 2011-04-25 → none
Stewart Smith (stewart)
no longer affects: drizzle
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.