Skip to main content

Query end timestamp is NULL - is this a bug?

  • June 10, 2019
  • 3 replies
  • 4 views

abtsantosbenten
Forum|alt.badge.img+1

Attached screenshot shows a query that is not executing, but the end timestamp is NULL.
is this a bug?

Vertica: 9.0
From table: V_MONITOR.QUERY_REQUESTS

3 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • June 10, 2019

Hi,

Is it showing up as a CURRENT_STATEMENT in the SESSIONS system table?


abtsantosbenten
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 14, 2019

I found out that it takes a while for vertica to update the fields when the transaction is done. It was eventually populated.


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • June 14, 2019

What was the request (i.e. SQL) in the QUERY_REQUESTS table?