Thank you! I can now connect with mysql-connector-java-5.1.34-bin.jar JDBC driver.
On Dec 4, 2014, at 10:14 AM, Serge Monkewitz <[log in to unmask]> wrote:
> I updated the IPAC install.
>
> On Dec 3, 2014, at 2:40 PM, Jacek Becla <[log in to unmask]> wrote:
>
>> The fix is at the tip of the qserv master.
>>
>> Jacek
>>
>>
>>
>> On 12/03/2014 01:54 PM, Tatiana Goldina wrote:
>>> Indeed, mysql-proxy-lua.log shows that the queries coming from mysql client (first 2 entries) do not have the comment, while the queries coming from JDBC driver (last entry) do:
>>>
>>> *******************
>>> Intercepted: select @@version_comment limit 1
>>> Processing locally
>>>
>>> *******************
>>> Intercepted: 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'
>>> Processing locally
>>>
>>> *******************
>>> Intercepted: /* 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'
>>> proxy.connection.server.thread_id: 151
>>> Passing query: /* 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'
>>> Passing hints: "client_dst_name" "134.4.53.236:4040" "server_thread_id" "151" "db" "LSST"
>>> Sendresult -4110
>>> ERROR 4110: Qserv error: 'ParseException:ANTLR parse error:unexpected token: /:'
>>>
>>>
>>> On Dec 3, 2014, at 1:46 PM, Jacek Becla <[log in to unmask]> wrote:
>>>
>>>> I think we understand it, so apparently, mysql client 4.1 and higher
>>>> is stripping out comments (and jdbc does not). The fix that went in
>>>> so far was for cleaning up some left over white spaces that were
>>>> confusing proxy/lua code.
>>>>
>>>> I'll fix that.
>>>>
>>>> Jacek
>>>>
>>>>
>>>>
>>>> On 12/03/2014 12:12 PM, Tatiana Goldina wrote:
>>>>> Here is a test program I am using. It is similar to the one John sent
>>>>> before. The configuration options to the driver are hardcoded in the URL.
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>>
>>>>> 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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> It requires MySQL JDBC driver, which can be downloaded from here:
>>>>> http://dev.mysql.com/downloads/connector/j/
>>>>>
>>>>> To compile and run:
>>>>> javac TestQserv.java
>>>>> java -cp
>>>>> .:mysql-connector-java-5.1.34/mysql-connector-java-5.1.34-bin.jar TestQserv
>>>>>
>>>>> The options to the driver are here:
>>>>> http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html
>>>>>
>>>>> Both URL formats
>>>>> "jdbc:mysql://address=(protocol=tcp)(host=lsst-db1.ipac.caltech.edu
>>>>> <http://lsst-db1.ipac.caltech.edu>)(port=4040)(user=qsmaster)/LSST?dumpQueriesOnException=true"
>>>>> and
>>>>> "jdbc:mysql://lsst-db1.ipac.caltech.edu
>>>>> <http://lsst-db1.ipac.caltech.edu>:4040/LSST?user=qsmaster&dumpQueriesOnException=true"
>>>>> produce the same error (Qserv error: 'ParseException:ANTLR parse
>>>>> error:unexpected token: /:') when getting the connection.
>>>>>
>>>>> Thank you very much for your help!
>>>>>
>>>>> Tatiana
>>>>>
>>>>>
>>>>> P.S. No problem executing this command with mysql command line client:
>>>>>
>>>>>>> mysql -h lsst-db1.ipac.caltech.edu
>>>>> <http://lsst-db1.ipac.caltech.edu> -u qsmaster -P 4040 -D
>>>>> LSST --protocol tcp -e "/* 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'"
>>>>> +--------------------------+---------------------------------------------------------------+
>>>>> | Variable_name | Value
>>>>> |
>>>>> +--------------------------+---------------------------------------------------------------+
>>>>> | character_set_client | latin1
>>>>> |
>>>>> | character_set_connection | latin1
>>>>> |
>>>>> | character_set_results | latin1
>>>>> |
>>>>> | character_set_server | latin1
>>>>> |
>>>>> | init_connect |
>>>>> |
>>>>> | interactive_timeout | 28800
>>>>> |
>>>>> | language |
>>>>> /home/lsstadm/stack/Linux64/mysql/5.1.65/share/mysql/english/ |
>>>>> | lower_case_table_names | 0
>>>>> |
>>>>> | max_allowed_packet | 1048576
>>>>> |
>>>>> | net_buffer_length | 16384
>>>>> |
>>>>> | net_write_timeout | 60
>>>>> |
>>>>> | query_cache_size | 0
>>>>> |
>>>>> | query_cache_type | ON
>>>>> |
>>>>> | sql_mode |
>>>>> |
>>>>> | system_time_zone | PST
>>>>> |
>>>>> | time_zone | SYSTEM
>>>>> |
>>>>> | tx_isolation | REPEATABLE-READ
>>>>> |
>>>>> | wait_timeout | 28800
>>>>> |
>>>>> +--------------------------+---------------------------------------------------------------+
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Dec 3, 2014, at 10:07 AM, Serge Monkewitz <[log in to unmask]
>>>>> <mailto:[log in to unmask]>> wrote:
>>>>>
>>>>>> Monkewitz <[log in to unmask] <mailto:[log in to unmask]>> 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
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>
>>
>
> ########################################################################
> 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
>
>
> --
> BEGIN-ANTISPAM-VOTING-LINKS
> ------------------------------------------------------
>
> Teach CanIt if this mail (ID 04NnuglUB) is spam:
> Spam: https://canit.ipac.caltech.edu/canit/b.php?i=04NnuglUB&m=bb436dded771&c=s
> Not spam: https://canit.ipac.caltech.edu/canit/b.php?i=04NnuglUB&m=bb436dded771&c=n
> Forget vote: https://canit.ipac.caltech.edu/canit/b.php?i=04NnuglUB&m=bb436dded771&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
|