 |
 |
Just tested. I can run all the commands listed from mysql command line client, but I can not connect from java: SQLException: Qserv error: 'ParseException:ANTLR parse error:unexpected token: /:' Query being executed when exception was thrown: /* mysql-connector-java-5.1.34 ( Revision: [log in to unmask] ) */SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name = 'character_set' OR Variable_name = 'character_set_server' OR Variable_name = 'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name = 'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' OR Variable_name = 'license' OR Variable_name = 'init_connect' It looks like the connector is sending a comment in the beginning of "SHOW VARIABLES" command. (MySQL server supports C style comments.) Sorry, I did not realize that the comment is being sent to the MySQL server too… How hard would it be to strip out comments, like /* … */? Tatiana On Dec 1, 2014, at 10:51 AM, Tatiana Goldina <[log in to unmask]> wrote: > Hi Jacek, > > I am still getting error at "SHOW VARIABLES…"; also not sure if "SELECT @@session.auto_increment_increment" will work. > > SET commands work fine. > > Tatiana > > > On Nov 18, 2014, at 1:44 PM, Jacek Becla <[log in to unmask]> wrote: > >> Tatiana, John, Trey >> >> I tweaked Qserv and it will now successfully process the queries Tatiana posted, so unless there is another class of queries that >> JDBC issues which we haven't seen yet, things should work. >> >> The changes are on tip of Qserv master. I am not sure what >> the best way is for you to grab them. Can you do git pull? >> Don't forget you will need to rebuild qserv, and restart >> services (at minimum mysql proxy). >> >> Good luck :) >> >> Jacek >> >> >> >> On 11/17/2014 02:18 PM, Tatiana Goldina wrote: >>> *SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = >>> 'net_write_timeout' OR Variable_name = 'interactive_timeout' OR >>> Variable_name = 'wait_timeout' OR Variable_name = 'character_set_client' >>> OR Variable_name = 'character_set_connection' OR Variable_name = >>> 'character_set' OR Variable_name = 'character_set_server' OR >>> Variable_name = 'tx_isolation' OR Variable_name = >>> 'transaction_isolation' OR Variable_name = 'character_set_results' OR >>> Variable_name = 'timezone' OR Variable_name = 'time_zone' OR >>> Variable_name = 'system_time_zone' OR Variable_name = >>> 'lower_case_table_names' OR Variable_name = 'max_allowed_packet' OR >>> Variable_name = 'net_buffer_length' OR Variable_name = 'sql_mode' OR >>> Variable_name = 'query_cache_type' OR Variable_name = 'query_cache_size' >>> OR Variable_name = 'license' OR Variable_name = 'init_connect'* >>> >>> 2. duration: 0 ms, connection-id: 1233, statement-id: 1, resultset-id: >>> 2, message: /* mysql-connector-java-5.1.34 ( Revision: >>> [log in to unmask] >>> <mailto:[log in to unmask]> ) >>> */*SELECT @@session.auto_increment_increment* >>> >>> 3. duration: 0 ms, connection-id: 1233, statement-id: 999, >>> resultset-id: 0, message: *SET NAMES latin1* >>> >>> 4. duration: 0 ms, connection-id: 1233, statement-id: 999, resultset-id: >>> 0, message: *SET character_set_results = NULL* >>> >>> 5. duration: 0 ms, connection-id: 1233, statement-id: 999, resultset-id: >>> 0, message: *SET autocommit=1* >>> >>> 6. duration: 0 ms, connection-id: 1233, statement-id: 999, resultset-id: >>> 0, message: *SET sql_mode='STRICT_TRANS_TABLES'* >> >> >> >> -- >> BEGIN-ANTISPAM-VOTING-LINKS >> ------------------------------------------------------ >> >> Teach CanIt if this mail (ID 04Nh9KDKl) is spam: >> Spam: https://canit.ipac.caltech.edu/canit/b.php?i=04Nh9KDKl&m=5296c1b7b0d7&c=s >> Not spam: https://canit.ipac.caltech.edu/canit/b.php?i=04Nh9KDKl&m=5296c1b7b0d7&c=n >> Forget vote: https://canit.ipac.caltech.edu/canit/b.php?i=04Nh9KDKl&m=5296c1b7b0d7&c=f >> ------------------------------------------------------ >> END-ANTISPAM-VOTING-LINKS > ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1