| Bug #42790 | Test 'main.innodb' fails from "InnoDB: Error: in ALTER TABLE" | ||
|---|---|---|---|
| Submitted: | 12 Feb 14:21 | Modified: | 18 Mar 16:52 |
| Reporter: | Kent Boortz | ||
| Status: | Closed | ||
| Category: | Server: InnoDB | Severity: | S3 (Non-critical) |
| Version: | 5.1.32-pre | OS: | Sun Solaris (9 & 10, x86 32-bit) |
| Assigned to: | Narayanan venkateswaran | Target Version: | |
[3 Mar 13: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 10: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 9: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 20: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 1: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 14: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 16:52]
Paul DuBois
Noted in 6.0.11 changelog.
[9 May 18: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 19: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 20: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.