ERROR: Unavailable: lock table for query

Hi All,

can some please help on the below errro why i am getting these error again n again ???

ERROR: Unavailable: lock table for query - Locking failure: Timed out X locking Table:FAS.FCT_FAULT. T held by [user (Mergeout: (Table: FAS.SUMM_HOURLY_NETWORK) (Projection: FAS.SUMM_HOURLY_NETWORK_b0))]. Your current transaction isolation level is SERIALIZABLE


  • Options
    SruthiASruthiA Vertica Employee Administrator

    There is a T lock on table FAS.SUMM_HOURLY_NETWORK, Hence, X lock cannot be granted. T and X lock cannot be used on same object simultaneously. Please check lock compatibility matrix in the below link.


  • Options

    What operation are you doing that is erroring out? It's conflicting with the tuple mover, and for most operations that take table X locks we will interrupt the tuple mover to allow the user operation to proceed.

  • Options

    Hi Sruthia, THnaks for your reply,

    HI Ben, the table are used to summarize the data displayed on my different dashboards.


  • Options

    Let me clarify: what SQL did you send to the database that generated the error? DELETE? drop_partiton()?

  • Options

    2018-07-20 16:10:39,671 ERROR [com.hp.ossa.fault.KafkaConsumer] (pool-group-id-fas-ao-01-thread-2) persistToDB, transient SQL exception occured, message= [ MERGE INTO FCT_FAULT dest USING TMP_FF src ON

    it is merge??

Leave a Comment

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