How to avoid x-Lock??
HyeontaeJu
Vertica Customer ✭
Table AA is performed INSERT and UPDATE operations every second by the schedule program.
However, if another program accesses table AA and tries to perform an UPDATE operation, an X-Lock message occurs.
How to solve this problem?
0
Answers
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/ConceptsGuide/Components/Locks/AboutVerticaLocks.htm?zoom_highlight=X LOCK
Hope this Helps!