Skip to main content
satheeshrajam0003
August 23, 2022
Question

Lock table to be implemented for the target table also

  • August 23, 2022
  • 2 replies
  • 0 views

I was going through the article,

https://community.appian.com/w/the-appian-playbook/2500/data-migration-to-new-schema

while moving the data from source table to target table getting the below error 

#1100 - Table 'tablename' was not locked with LOCK TABLES

Locking the target tables allowing the code to work smoothly. Please make the correction in the article. 

2 replies

stefanhelzle0001
Brainy
August 23, 2022

OK. What is your question?

satheeshrajam0003
August 23, 2022

Just wanted to put some notes for the people who faces the similar issue and may search in future. So opened the discussion. Thanks for your response.