How to remove DB Lock

Error: The database is in use in multi-user mode. (276) This process is terminated with exit code 2. (8619)

How to prevent: You must not shut down the machine without stopping the stacks gracefully.

What did you do, how was the lock removed?

For each of the databases,

• in portainer, check the log of each database service to see if it said if the database was in use by another process
• if there was a message, access the console of that service
• cd into /workspace/db/<dbname>
• rm *.lk
• exit
• once all db services have been checked, stop the stack
• restart the stack
• check the log of each database service to see if it started ok