 |
 |
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