Skip to main content
Question

Vertica 8.1 : ConnectionLoadBalance=true in URL disables logging to query_requests table

  • May 17, 2017
  • 1 reply
  • 14 views
nygenomer

I am trying to migrate from Vertica 7.2.3 to 8.1 and during the process I noticed that my queries are not being logged into query_requests table, and hence nothing showed in MC query monitoring either. My application connects to Vertica through URL which has in its query string a parameter ConnectionLoadBalance=true.

I discovered this through experimentation and wonder what may I do on my side to assure that I can both retain the above mentioned load-balancing parameter in the URL and have the queries logged/entered into the query_requests table.

Thanks!
NYgenomer

    1 reply

    nygenomer
    • nygenomer
    • Author
    • New Participant
    • May 18, 2017

    Similarly, the same happens if connection does not go through JDBC, but using vsql.

    When I run the following:

    echo "SELECT count(*) from mySchema.tableName" | ./vsql -h -U -w -d -C --enable-connection-load-balance

    and then look into latest queries in table query_requests I don’t see that the above query being logged.

    However, if I omit the option for load balancing and use the following, the query is logged.

    echo "SELECT count(*) from mySchema.tableName" | ./vsql -h -U -w -d

    To my knowledge and according to the documentation, load balancing requires to be “enabled” both on server and client side, hence whether we use --enable-connection-load-balance in vsql or ConnectionLoadBalance=true in JDBC it is required for proper load balancing. However, queries are not logged into query_requests table when load balancing is fully enabled.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement