Deadlock issues happened on Oracle (https://bugzilla.redhat.com/show_bug.cgi?id=854612) due to missing index on column InstanceId in EventTypes table. Initial solution to add a missing index by using hibernate xml script proved to be a bad idea. It's hard to manage database specific problems by this file. Documentation should be updated with information about all unindexed columns in database schema and should contain recommendation to add indexes to destined columns before using the database for production use.
Hi Jiri, Thanks for reporting. Who's the best person to provide the steps that need to be taken to resolve this issue? We're well past the point at which the docs team can create new content for this release; however, if this is a fairly critical issue and somebody can provide the information in a step by step form that users can follow we'll add to the admin guide. (I've also asked for info in the related email thread). Thanks Lee
Alessandro and Marco have provided the content by email. I have updated the doc and will post a link as soon as it is available on the internal doc stage. Thanks Lee
Hi Lee, thank you for fixing the typos and creating a separate section for database indexes, I think it's better this way. Regarding to hbm2ddl property - don't delete that from other parts of the documentation as it well serves for demonstration purposes. Text from section 2.6 was deleted because of incorrect description for creating indexes. I think that current fixes are sufficient and no other changes are necessary. Verified.
Thanks, Jiri!
Thanks you, Toshiya. I've corrected the typo and will publish the updated guide.
*** Bug 857192 has been marked as a duplicate of this bug. ***