Skip to main content
Question

Duplicate Query is exists in the query_requests system table

  • Sep 1, 2020 5:50 AM UTC
  • 3 replies
  • 17 views

HyeontaeJu
Forum|alt.badge.img+2

hello, These days, we are using vertica db and make a system.
today, i'm testing the vertica db, and i found something wrong in the query_requests.
Almost 90% of queries have different transaction IDs, which occur twice in the query_requests.

Why Almost 90% of queries occur twice in the query_requests.
Example

3 replies

LenoyJ
Forum|alt.badge.img+1
  • Participating Frequently
  • Sep 10, 2020 5:58 AM UTC

Check if the queries are retrying (maybe a join spill). If so, one of the queries will have success=true and the other will not.


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • Oct 14, 2020 1:32 AM UTC

@Hibiki but,, the query is select query in the screenshot.


HyeontaeJu
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • Oct 15, 2020 1:34 AM UTC

@Hibiki
Sorry. I'm busy yesterday, so I'll send you a late reply.
Oh, sorry, I'm confused. The program calls the query twice.