ERROR: Unavailable: lock table for query

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