Bug #1360 Packets out of order
Submitted: 20 Sep 2003 16:11 Modified: 21 Nov 2003 16:40
Reporter: Brian O'Kelley Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.0-alpha OS:Linux (Gentoo Linux)
Assigned to: CPU Architecture:Any

[20 Sep 2003 16:11] Brian O'Kelley
Description:
Packets out of order (Found: 2, expected: 1)

How to repeat:
The code:
    char query[] = "INSERT INTO LOG_IMP (session_id, ad_id, section_id, "
                   "site_id, access_time, in_ad_sum, in_site_sum) VALUES ("
                   "?, ?, ?, ?, ?, 1, 1)" ;

    MYSQL_STMT *stmt = mysql_prepare(db, query, strlen(query)) ;
    if (stmt == NULL) STMT_ERROR("Prepare", query, stmt) ;

The table:

mysql> describe LOG_IMP
    -> ;
+-------------+----------------------+-------------------+------+-----+---------------------+-------+
| Field       | Type                 | Collation         | Null | Key | Default             | Extra |
+-------------+----------------------+-------------------+------+-----+---------------------+-------+
| access_time | datetime             | latin1_swedish_ci |      |     | 0000-00-00 00:00:00 |       |
| ad_id       | int(8) unsigned      | binary            |      |     | 0                   |       |
| section_id  | smallint(5) unsigned | binary            |      |     | 0                   |       |
| site_id     | smallint(5) unsigned | binary            |      |     | 0                   |       |
| network_id  | smallint(5) unsigned | binary            |      |     | 0                   |       |
| session_id  | char(9)              | latin1_swedish_ci |      |     |                     |       |
| in_ad_sum   | tinyint(1)           | binary            |      |     | 0                   |       |
| in_site_sum | tinyint(1)           | binary            |      |     | 0                   |       |
+-------------+----------------------+-------------------+------+-----+---------------------+-------+
8 rows in set (0.02 sec)
[21 Oct 2003 16:40] Dean Ellis
I am unable to duplicate this behaviour on either 4.1.0-alpha (official binary) or the latest 4.1.1 (compiled from BitKeeper sources) on Gentoo Linux with the snippet of code provided.

If you can provide a more complete code sample perhaps the problem can be identified.  Post it here if fairly short, otherwise you can submit the sample to

ftp://support.mysql.com/pub/mysql/secret

Thank you
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".