Bug #31465 Running Falcon test suite leads to warnings about temp tables
Submitted: 8 Oct 2007 19:52 Modified: 19 Nov 2007 22:24
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0, 6.0-falcon OS:Linux
Assigned to: CPU Architecture:Any

[8 Oct 2007 19:52] Hakan Küçükyılmaz 
Description:
Running Falcon test suite leads to warnings about temp tables

How to repeat:
Run Falcon test suite:

./mysql-test-run.pl --force --suite=falcon

in 6.0-falcon tree and check warnings:

master.err: falcon.falcon_bug_22089: 071005 20:27:27 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql5ad2_1_0', error: -1
master.err: falcon.falcon_bug_22143: 071005 20:27:27 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql5ad2_2_0', error: -1
master.err: falcon.falcon_bug_22143: 071005 20:27:27 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql5ad2_3_0', error: -1
master.err: falcon.falcon_bug_24079: 071005 20:27:50 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql5ad2_43_0', error: 2
master.err: falcon.falcon_bug_24079: 071005 20:27:50 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql5ad2_43_1', error: 2
master.err: falcon.falcon_bug_24079: 071005 20:27:50 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql5ad2_43_2', error: 2
master.err: falcon.falcon_bug_24079: 071005 20:27:50 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql5ad2_43_3', error: 2
master.err: falcon.falcon_bug_24079: 071005 20:27:50 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql5ad2_43_4', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_1', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_2', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_0', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_3', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_4', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_5', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_6', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_7', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_8', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_9', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_a', error: 2
master.err: falcon.falcon_temporary_alter: 071005 20:31:40 [Warning] Could not remove temporary table: '/dev/shm/pbtmp-falcon-122/#sql7977_b_b', error: 2
[10 Oct 2007 5:44] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/35249

ChangeSet@1.2630, 2007-10-10 07:43:48+02:00, hakank@lu0011.(none) +1 -0
  Fix for Bug#31465 by Kevin.
[19 Nov 2007 22:24] Hakan Küçükyılmaz 
Pushbuild does not show this warning anymore.