Bug #12698 abnormal program termination running mysql_client_test
Submitted: 21 Aug 2005 3:26 Modified: 20 Oct 2005 10:10
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.13a, 5.0.15 OS:Microsoft Windows (XP Home, fedora)
Assigned to: Magnus Blåudd CPU Architecture:Any

[21 Aug 2005 3:26] [ name withheld ]
Description:
while running mysql_client_test i encounter dialogue box stating:
"Microsoft Visual C++ Debug Library"
"Debug Error ! "
"Program: C:\MySql\bin\mysql_client_test.exe"
"abnormal program termination"
"(Press Retry to debug the application)"
"[Abort] [Retry] [Ignore]"

the dialogue box appears at "77 of (1/1): test_frm_bug"

the final info appearing on my cmd at the time of the program termination is:
"[MySQL-4.1.13a-nt][1051] Unknown table 'test_frm_bug' 
e:mysqldev\build\mysql-4.1.13a-build\mysql-4.1.13a\testsmysql_client_test.c:6923: check failed: 'r == 0' "

How to repeat:
run mysql_client_test
[12 Oct 2005 19:40] Magnus Blåudd
Also appears on Fedora Core 4. when compiled with BUILD/compile-pentium-max
See below:
#####################################
10 of (1/1): test_fetch_str
#####################################

 total parameters in stmt: `7` (expected: `7`)

 SELECT * FROM test_bind_fetch

        +--------+---------+---------+---------+---------+---------+---------+
        | c1     | c2      | c3      | c4      | c5      | c6      | c7      |
        +--------+---------+---------+---------+---------+---------+---------+
        | 196864 | 196611  | 196611  | 196611  | 12      | 25      | 38      |
        | 720896 | 1572864 | 2424832 | 3276800 | 4128768 | 4980736 | 5832704 |
        | 655360 | 1507328 | 2359296 | 3211264 | 4063232 | 4915200 | 5767168 |
        +--------+---------+---------+---------+---------+---------+---------+

        3 rows returned
mysql_client_test.c:3851: check failed: 'rc == 0'
Avbruten (SIGABRT)
[12 Oct 2005 19:47] Magnus Blåudd
Hmm, maybe not exactly the same bug after all, original problem appears on a different line. :)
[12 Oct 2005 20:16] Magnus Blåudd
mysql_client_test terminated because mysql_stmt_fetch unexpectedly returns  MYSQL_DATA_TRUNCATED.
[13 Oct 2005 11:23] Magnus Blåudd
Expected output from test_fetch_str testcase in mysql_client_test
#####################################
1 of (1/1): test_fetch_str
#####################################

 total parameters in stmt: `7` (expected: `7`)

 SELECT * FROM test_bind_fetch

        +------+------+------+------+------+------+------+
        | c1   | c2   | c3   | c4   | c5   | c6   | c7   |
        +------+------+------+------+------+------+------+
        | 12   | 25   | 38   | 51   | 64   | 77   | 90   |
        | 11   | 24   | 37   | 50   | 63   | 76   | 89   |
        | 10   | 23   | 36   | 49   | 62   | 75   | 88   |
        +------+------+------+------+------+------+------+

        3 rows returned

 tiny     : 12(1)
 short    : 25(2)
 int      : 38(4)
 longlong : 51(8)
 float    : 64.000000(4)
 double   : 77(8)
 char     : 90(2)

 tiny     : 11(1)
 short    : 24(2)
 int      : 37(4)
 longlong : 50(8)
 float    : 63.000000(4)
 double   : 76(8)
 char     : 89(2)

 tiny     : 10(1)
 short    : 23(2)
 int      : 36(4)
 longlong : 49(8)
 float    : 62.000000(4)
 double   : 75(8)
 char     : 88(2)
[13 Oct 2005 11:25] Magnus Blåudd
And here is correct output from test_frm_bug testcase
#####################################
1 of (1/1): test_frm_bug
#####################################

 data directory: /home/msvensson/mysql/bug12698/my41-bug12698/mysql-test/var/master-data/
 test_frm: /home/msvensson/mysql/bug12698/my41-bug12698/mysql-test/var/master-data//client_test_db/test_frm_bug.frm

        +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------------------------------------------------------+
        | Name         | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment                                                            |
        +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------------------------------------------------------+
        | test_frm_bug | NULL   | NULL    | NULL       | NULL | NULL           | NULL        | NULL            | NULL         | NULL      | NULL           | NULL        | NULL        | NULL       | NULL      | NULL     | NULL           | Incorrect information in file: './client_test_db/test_frm_bug.frm' |
        +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------------------------------------------------------+

        1 row returned

 Comment: Incorrect information in file: './client_test_db/test_frm_bug.frm'
[13 Oct 2005 11:37] 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/31017
[13 Oct 2005 11:39] Magnus Blåudd
The testcase create a .frm file consisting of "junk". Unfortunately the "junk" wasn't written to the .frm file if mysql_client_test was run with -s option to make it run silent.
This most likely caused the file never to be created on windows, and thus the test case failed.
[13 Oct 2005 17:55] Magnus Blåudd
Aaah, the patch was attached to bug#93 jsut becuase I mentioned it in the comment. We should fix the trigger to send mail to all bugs mentioned or only the first.

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/31028
[20 Oct 2005 10:10] Magnus Blåudd
Pushed to 4.1.16