Options

Query end timestamp is NULL - is this a bug?

abtsantosbentenabtsantosbenten ✭
in General Discussion

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

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator

    Hi,

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

  • Options
    abtsantosbentenabtsantosbenten ✭

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

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...