Bug #45864 insert on one connection, immediate query on another produces no result

• Submitted: 30 Jun 2009 20:20
• Modified: 1 Jul 2009 6:16
• Reporter: Jess Balint
• Status: Duplicate
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.1.35, 5.1 bzr
• OS: Any
• CPU Architecture: Any
• Tags: regression

[30 Jun 2009 20:20] Jess Balint

Description:
If I insert a row on one connection, then immediately try to select it from a separate connection, periodically no row is returned. The test program waits for the acknowledgment of the insert before issuing the query.

How to repeat:
I will attach a program. The test seems to fail faster and more often run against a local server than remote (I guess a timing issue).

* edit line 6 of TestX.java to provide your connection information
* javac TestX.java
* java -cp .:mysql-connector-java-5.1.7-bin.jar TestX

Eventually will return:
Exception in thread "main" java.sql.SQLException: Illegal operation on empty result set.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:835)
        at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5571)
        at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5491)
        at TestX.test(TestX.java:30)
        at TestX.main(TestX.java:13)

[30 Jun 2009 20:21] Jess Balint

test program

Attachment: TestX.java (text/x-java), 1.05 KiB.

[1 Jul 2009 6:06] Sveta Smirnova

Thank you for the report.

Verified as described. Version 5.0 is not affected.

[1 Jul 2009 6:10] Sveta Smirnova

Really duplicate of bug #36618

[4 Aug 2010 7:50] Bugs System

Pushed into mysql-trunk 5.5.6-m3 (revid:[e-mail]-20100731131027-1n61gseejyxsqk5d) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 7:55] Bugs System

Pushed into mysql-trunk 5.5.6-m3 (revid:[e-mail]-20100731131027-1n61gseejyxsqk5d) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 7:56] Bugs System

Pushed into mysql-trunk 5.5.6-m3 (revid:[e-mail]-20100731131027-1n61gseejyxsqk5d) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 7:57] Bugs System

Pushed into mysql-trunk 5.5.6-m3 (revid:[e-mail]-20100731131027-1n61gseejyxsqk5d) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 7:58] Bugs System

Pushed into mysql-trunk 5.5.6-m3 (revid:[e-mail]-20100731131027-1n61gseejyxsqk5d) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 7:59] Bugs System

Pushed into mysql-trunk 5.5.6-m3 (revid:[e-mail]-20100731131027-1n61gseejyxsqk5d) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 8:00] Bugs System

Pushed into mysql-trunk 5.5.6-m3 (revid:[e-mail]-20100731131027-1n61gseejyxsqk5d) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 8:08] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 8:13] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 8:14] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 8:15] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 8:16] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 8:17] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 8:24] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:18)

[4 Aug 2010 9:00] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (merge vers: 5.1.49) (pib:20)

[4 Aug 2010 9:03] Bugs System

Pushed into mysql-next-mr (revid:alik@ibmvm-20100804081630-ntapn8bf9pko9vj3) (version source revid:[e-mail]-20100621094008-o9fa153s3f09merw) (pib:20)