Query end timestamp is NULL - is this a bug?

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

Comments

  • Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert

    Hi,

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

  • abtsantosbentenabtsantosbenten Registered User

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

  • Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file