The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Vertica 5156 Error.

Hi,
Need help urgently.

I am updating one table and it keeps on showing below error:

"ERROR 5156:  Unavailable: initiator locks for query - Locking failure: Timed out X locking Table:cdr_p.ckm_customer. X held by [user srvc_cdradm (MERGE /*+ direct */ INTO cdr_p.ckm_customer cust"

Well the scenario is there is another table say table b, which takes values from above table and update.. i.e table b depends on ckm table...but at this pt. there r no other tables getting loaded and table b also loaded..thn y not locks r getting released..

Thanks

Comments

  • execute
    select * from locks;
    select * from current_session;
    to see who is taking the locks and what are the current transactions running.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.