Bug #10443 Embedded Server: "mysql_client_test" test failure
Submitted: 7 May 2005 23:28 Modified: 10 Aug 2005 19:39
Reporter: Lenz Grimmer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.12-pre OS:Linux (Linux/x86)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[7 May 2005 23:28] Lenz Grimmer
Description:
This bug actually appears on more platforms that this. When running "./mysql-test-run --embedded-server mysql_client_test", the test fails with the following output (as seen on HPUX 11.00 for example):

15972: myisam                         [ pass ]   
15973: mysql_client_test              [ fail ]
15974: 
15975: Errors are (from /home/mysqldev/hp3750/test/mysql-debug-4.1.12-hp-hpux11.00-hppa2.0w/mysql-test/var/log/mysqltest-time) :
15976: InnoDB: The first specified data file /home/mysqldev/hp3750/test/mysql-debug-4.1.12-hp-hpux11.00-hppa2.0w/mysql-test/var/slave-data/ibdata1 did not exist:
15977: InnoDB: a new database to be created!
15978: 050506  3:21:34  InnoDB: Setting file /home/mysqldev/hp3750/test/mysql-debug-4.1.12-hp-hpux11.00-hppa2.0w/mysql-test/var/slave-data/ibdata1 size to 10 MB
15979: InnoDB: Database physically writes the file full: wait...
15980: 050506  3:21:35  InnoDB: Log file /home/mysqldev/hp3750/test/mysql-debug-4.1.12-hp-hpux11.00-hppa2.0w/mysql-test/var/slave-data/ib_logfile0 did not exist: new to be created
15981: InnoDB: Setting log file /home/mysqldev/hp3750/test/mysql-debug-4.1.12-hp-hpux11.00-hppa2.0w/mysql-test/var/slave-data/ib_logfile0 size to 5 MB
15982: InnoDB: Database physically writes the file full: wait...
15983: 050506  3:21:35  InnoDB: Log file /home/mysqldev/hp3750/test/mysql-debug-4.1.12-hp-hpux11.00-hppa2.0w/mysql-test/var/slave-data/ib_logfile1 did not exist: new to be created
15984: InnoDB: Setting log file /home/mysqldev/hp3750/test/mysql-debug-4.1.12-hp-hpux11.00-hppa2.0w/mysql-test/var/slave-data/ib_logfile1 size to 5 MB
15985: InnoDB: Database physically writes the file full: wait...
15986: InnoDB: Doublewrite buffer not found: creating new
15987: InnoDB: Doublewrite buffer created
15988: InnoDB: Creating foreign key constraint system tables
15989: InnoDB: Foreign key constraint system tables created
15990: mysql_client_test.c:1396: check failed: 'real_data == o_real_data'
15991: sh: 7685 Abort(coredump)
15992: mysql_embedded: command "$MYSQL_CLIENT_TEST" failed
15993: (the last lines may be the most important ones)
15994: 
15995: Resuming Tests
15996: 
15997: mysql_protocols                [ skipped ]

On Linux, it looks like this:

10462: mysql_client_test              [ fail ]
10463: 
10464: Errors are (from /build/mysqldev/build/test/mysql-debug-4.1.12-pc-linux-gnu-i686/mysql-test/var/log/mysqltest-time) :
10465: mysqltest returned unexpected code 143, it has probably crashed
10466: (the last lines may be the most important ones)
10467: 
10468: Resuming Tests

How to repeat:
Run the mysql_client_test using the embedded server
[14 Jul 2005 11:34] Lenz Grimmer
Assigning to Ramil, as he already fixed this failure in the 5.0 tree (BUG#11808). Please backport this fix to 4.1 as well, thanks!
[14 Jul 2005 12:02] Lenz Grimmer
Correction, this is not a duplicate of BUG#11808 - sorry about that.
[15 Jul 2005 1:09] 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/internals/27117
[3 Aug 2005 20:22] Mike Hillyer
Reverting to patch pending because of missing information as per Paul.
[10 Aug 2005 19:36] Paul DuBois
"Fix handling of floats and doubles when using prepared statements
 API in the embedded server."

Fixed in 4.1.12.
[10 Aug 2005 19:39] Paul DuBois
Noted in 4.1.12 changelog.