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.

locking issue when inserting

It was observed that tables get locked while we are inserting data into them. kindly guide us on how to prevent locking on tables and ensure multi loading on the same table from all three nodes simultaneously.

Comments

  • Hello, Multiloading is possible while running under the default READ COMMITTED isolation level. Check v_monitor.locks table and ensure that your loading transactions do not also perform an update / delete which will extend the I (insert lock) to an X ( exclusive ) lock preventing multiloading. Also, make sure the session is not being set to SERIALIZABLE anytime before the insertion occurs. This isolation mode will allow only one operation to occur at a time on the db.

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.