The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

Comments

  • SruthiASruthiA Vertica Employee Employee

    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.

    https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/ConceptsGuide/Components/Locks/LockModes.htm

  • 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.

  • Hi Sruthia, THnaks for your reply,

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

    Br,

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

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file