| Bug #47826 | main.partition_innodb fails sometimes with the innodb plugin | ||
|---|---|---|---|
| Submitted: | 5 Oct 2009 8:24 | ||
| Reporter: | Georgi Kodinov | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | Tests: Server | Severity: | S3 (Non-critical) |
| Version: | 5.1-bk | OS: | Any |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.5-u2-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
© 2025, Oracle Corporation and/or its affiliates
Description: The partitioning test suite fails sometimes with the innodb plugin as follows : main.partition_innodb 'InnoDB plugin' w2 [ fail ] Test ended at 2009-10-04 14:43:55 CURRENT_TEST: main.partition_innodb --- /export/home/pb2/test/sb_1-792149-1254659251.83/mysql-5.1.40-solaris10-sparc-test/mysql-test/r/partition_innodb.result 2009-10-04 15:18:00.000000000 +0300 +++ /export/home/pb2/test/sb_1-792149-1254659251.83/mysql-5.1.40-solaris10-sparc-test/mysql-test/r/partition_innodb.reject 2009-10-04 15:43:54.826626000 +0300 @@ -27,11 +27,11 @@ UPDATE t1 SET DATA = data*2 WHERE id = 3; SHOW ENGINE InnoDB STATUS; Type Name Status -InnoDB 2 lock struct(s) 1 row lock(s) +InnoDB 4 lock struct(s) 3 row lock(s) UPDATE t1 SET data = data*2 WHERE data = 2; SHOW ENGINE InnoDB STATUS; Type Name Status -InnoDB 6 lock struct(s) 2 row lock(s) +InnoDB 4 lock struct(s) 3 row lock(s) SET @@session.tx_isolation = @old_tx_isolation; DROP TABLE t1; How to repeat: Run the test enough times Suggested fix: Make sure the test caters for the locking differences between the built-in and the plugin.