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:
None 
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

[12 Feb 2009 13:21] Kent Boortz
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.
[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)