| Bug #42790 | Test 'main.innodb' fails from "InnoDB: Error: in ALTER TABLE" | ||
|---|---|---|---|
| Submitted: | 12 Feb 2009 13:21 | Modified: | 18 Mar 2009 15:52 |
| Reporter: | Kent Boortz | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.1.32-pre | OS: | Solaris (9 & 10, x86 32-bit) |
| Assigned to: | V Venkateswaran | CPU Architecture: | Any |
[3 Mar 2009 12:41]
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/68107 2832 Narayanan V 2009-03-03 Bug#42790 Test 'main.innodb' fails from "InnoDB: Error: in ALTER TABLE" The problem here seem to be that when mysql is redirecting stderr to a file, stderr becomes buffered, whereas it is unbuffered by definition. The solution is to unbuffer it by setting buffer to null. @ sql/log.cc use setbuf(stderr, NULL) to set the buffer to null. @ sql/mysqld.cc use setbuf(stderr, NULL) to set the buffer to null.
[5 Mar 2009 9:48]
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/68327 2832 Narayanan V 2009-03-05 Bug#42790 Test 'main.innodb' fails from "InnoDB: Error: in ALTER TABLE" The problem here seem to be that when mysql is redirecting stderr to a file, stderr becomes buffered, whereas it is unbuffered by definition. The solution is to unbuffer it by setting buffer to null. @ sql/log.cc use setbuf(stderr, NULL) to set the buffer to null. @ sql/mysqld.cc use setbuf(stderr, NULL) to set the buffer to null.
[9 Mar 2009 8:43]
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/68591 2837 He Zhenxing 2009-03-09 [merge] Auto merge
[13 Mar 2009 19:06]
Bugs System
Pushed into 5.1.33 (revid:joro@sun.com-20090313111355-7bsi1hgkvrg8pdds) (version source revid:zhou.li@sun.com-20090311061050-ihp0g77znonq1tuq) (merge vers: 5.1.33) (pib:6)
[15 Mar 2009 0:09]
Paul DuBois
Noted in 5.1.33 changelog. stderr should be unbuffered, but when the server redirected stderr to a file, it became buffered. Setting report to NDI pending push into 6.0.x.
[18 Mar 2009 13:20]
Bugs System
Pushed into 6.0.11-alpha (revid:joro@sun.com-20090318122208-1b5kvg6zeb4hxwp9) (version source revid:matthias.leich@sun.com-20090310140952-gwtoq87wykhji3zi) (merge vers: 6.0.11-alpha) (pib:6)
[18 Mar 2009 15:52]
Paul DuBois
Noted in 6.0.11 changelog.
[9 May 2009 16:45]
Bugs System
Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (version source revid:jonas@mysql.com-20090508100057-30ote4xggi4nq14v) (merge vers: 5.1.33-ndb-6.2.18) (pib:6)
[9 May 2009 17:41]
Bugs System
Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (version source revid:jonas@mysql.com-20090508175813-s6yele2z3oh6o99z) (merge vers: 5.1.33-ndb-6.3.25) (pib:6)
[9 May 2009 18:39]
Bugs System
Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (version source revid:jonas@mysql.com-20090509073226-09bljakh9eppogec) (merge vers: 5.1.33-ndb-7.0.6) (pib:6)
Description: Test failure looks like main.innodb [ fail ] Found warnings/errors in server log file! Test ended at 2009-02-12 07:03:09 file_name line mysql-test/var/mysqld.1/mysqld.err 090212 9:03:09 InnoDB: Error: in ALTER TABLE ^ Found warnings!! Note that the Solaris 10 x86_64 test run is not completed yet, could be a generic x86 problem. The failure shows in both debug and normal build, means it should not be about optimization level. The new test platform runs the test case two times, fails both, so likely not random. How to repeat: Build and run the test case on the specified platform.