I found "Deadlock found when trying to get lock; try restarting transaction" while
running the pentaho. DB engine is InnoDB. How do I prevent the error.
What should be the setting in mySQl.
What design features that I need to take care when I design the set up?