My first reaction is: are you positive you are using the qserv
with the latest fixes?
I just run this:
mysql --port 4040 --protocol TCP LSST "/* mysql-connector-java-5.1.6 (
Revision: xxx ) */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 = 'init_connect'"
and it worked just fine.
Tatiana, can you maybe run what I just run (see above) by hand
and let me know if it worked or not?
I guess we have to come up with something with jdbc in the loop
locally here to reproduce it.
Jacek
On 12/03/2014 09:47 AM, Serge Monkewitz wrote:
> Tatiana: forwarding to qserv-l, since I am taking today off to deal with
> family matters. I’ll take a look tomorrow if no-one else has any ideas.
>
> For context - connecting to qserv via JDBC still fails, even after
> Jacek’s show variables fix (and fix for the fix).
>
> Begin forwarded message:
>
>> *From: *Tatiana Goldina <[log in to unmask]
>> <mailto:[log in to unmask]>>
>> *Subject: **Re: rebuilding QSERV*
>> *Date: *December 2, 2014 at 4:02:08 PM PST
>> *To: *Serge Monkewitz <[log in to unmask] <mailto:[log in to unmask]>>
>>
>> I am out of clues. I am still getting the same error when connecting
>> through the JDBC driver.
>>
>> jdbc:mysql://lsst-db1.ipac.caltech.edu
>> <http://lsst-db1.ipac.caltech.edu>:4040/LSST?user=qsmaster&dumpQueriesOnException=true&traceProtocol=true
>>
>> trace is attached. I don't know how to debug it further.
>>
>
> ------------------------------------------------------------------------
>
> 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
>
>
>
>>
>>
>> The query works, if I enter it directly into mysql command line client…
>
>
> ------------------------------------------------------------------------
>
> 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
>
########################################################################
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
|