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'*
########################################################################
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
|