 |
 |
I fixed it, see DM-1601 for details. The tip of the master contains the fix. Serge, can you pull the change into your local ipac installation? Tatiana, thanks for uncovering this bug! Jacek On 12/01/2014 12:36 PM, Tatiana Goldina wrote: > 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] > <mailto:[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] > <mailto:[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] >> <mailto:[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]> >>>> <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