Getting a timeout on lock
I am having a problem when trying to do an alter table.
I am consistently getting the same error:
Internal error (system details [Vertica][VJDBC](5157) ERROR: Unavailable: [Txn 0xb00000000000d6] O lock table - timeout error Timed out O locking Table:public.TABLE_NAME. T held by [user <unknown> (Mergeout: (Table: public.TABLE_NAME) (Projection: public.TABLE_NAME_PERFORMANCE_2_b1_v1_0))]. Your current transaction isolation level is SERIALIZABLE)
Does this mean that a mergeout is in progress on that table ?
If yes, this does not make sense, because when running "
SELECT node_name, operation_status, projection_name, plan_type FROM TUPLE_MOVER_OPERATIONS;"
does not report ANY mergeout running on this table.
What can I do to proceed with my changes ?
Thanks for helping