ERROR: Unavailable: lock table for query

JunaidKhan

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

SruthiA

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

Ben_Vandiver

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.

JunaidKhan

Hi Sruthia, THnaks for your reply,

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

Br,

Ben_Vandiver

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

JunaidKhan

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??