Bug #70290 Exception Populated : Unknown system variable 'transaction'
Submitted: 11 Sep 2013 3:35 Modified: 11 Sep 2013 7:43
Reporter: Xavier Liao Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Severity:S1 (Critical)
Version:5.1.26 OS:Microsoft Windows
Assigned to: Alexander Soklakov CPU Architecture:Any

[11 Sep 2013 3:35] Xavier Liao
Description:
When Try to connenct to mysql server and do a simpler insert operations. exception populated . The version of mysql server is '6.0.11-alpha-community'. And the driver is Connector/J mysql-connector-java-5.1.26-bin.jar .

When the readOnly is not set the exception is like :
---------------------------------------------------------------------
SQLException: Could not retrieve transation read-only status server
SQLState: S1000
VendorError: 0
java.sql.SQLException: Could not retrieve transation read-only status server
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)
	at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3939)
	at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3910)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:757)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
	at razorcaseeditor.migration.MysqlMigrator.main(MysqlMigrator.java:42)
Caused by: java.sql.SQLException: Unknown system variable 'tx_read_only'
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2761)
	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
	at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3933)
	... 4 more
Picked up JAVA_TOOL_OPTIONS: -agentlib:jvmhook
Picked up _JAVA_OPTIONS: -Xrunjvmhook -Xbootclasspath/a:"C:\Program Files\HP\Unified Functional Testing\bin\java_shared\classes";"C:\Program Files\HP\Unified Functional Testing\\bin\java_shared\classes\jasmine.jar"

when set ReadOnly to false; the exception is changed to 
-----------------------------------------------------------------------------
SQLException: Unknown system variable 'transaction'
SQLState: HY000
java.sql.SQLException: Unknown system variable 'transaction'
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812)
	at com.mysql.jdbc.ConnectionImpl.setReadOnlyInternal(ConnectionImpl.java:5490)
	at com.mysql.jdbc.ConnectionImpl.setReadOnly(ConnectionImpl.java:5483)
	at razorcaseeditor.migration.MysqlMigrator.main(MysqlMigrator.java:41)
VendorError: 1193
Picked up JAVA_TOOL_OPTIONS: -agentlib:jvmhook
Picked up _JAVA_OPTIONS: -Xrunjvmhook -Xbootclasspath/a:"C:\Program Files\HP\Unified Functional Testing\bin\java_shared\classes";"C:\Program Files\HP\Unified Functional Testing\\bin\java_shared\classes\jasmine.jar"
-------------------------------------------------------------------------

don't know how to continue , please help.

thanks
Xavier 

How to repeat:
Please try code 
-----------------------
public static void main(String[] args) {
                        
                        Connection conn = null;
                        try {
                                    Statement stmt = null;
                        conn =
                        DriverManager.getConnection("jdbc:mysql://10.65.68.132/razortest?" +
                        "user=razortest&password=test123");
                        stmt = conn.createStatement();
                        boolean rs1 = stmt.execute(" insert into rc_test values (\"1\",2,\"3\");");
                        } catch (SQLException ex) {
                        System.out.println("SQLException: " + ex.getMessage());
                        System.out.println("SQLState: " + ex.getSQLState());
                        System.out.println("VendorError: " + ex.getErrorCode());
                        }
            }
---------------------------
DROP TABLE IF EXISTS `razortest`.`rc_test`;
CREATE TABLE  `razortest`.`rc_test` (
  `one` varchar(10) DEFAULT NULL,
  `two` smallint(6) DEFAULT NULL,
  `name` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
---------------------------
CREATE DATABASE `razortest` /*!40100 DEFAULT CHARACTER SET latin1 */;
---------------------------
Connection/J version : mysql-connector-java-5.1.26-bin.jar
Mysql serversion : '6.0.11-alpha-community'

Suggested fix:
Seems issue is in  com.mysql.jdbc.ConnectionImpl using the wrong way to try to get a value from server . I am not sure this is a issue or not.
[11 Sep 2013 6:33] Alexander Soklakov
Hi Xavier,

Thanks for your report.

I'm sorry but the development of MySQL server 6.0 branch is abandoned long time ago and thus it doesn't have these variables. Please use MySQL server 5.6GA.

If you really need to evaluate MySQL server 6.0 with Connector/J the only possible way is to get c/j sources and change them yourself so they meet your needs.
[11 Sep 2013 7:42] Xavier Liao
thanks I will proceed with other version.  -)
[11 Sep 2013 7:42] Xavier Liao
thanks I will proceed with other version.  -)
[11 Sep 2013 7:43] Xavier Liao
close it .