Bug 883412

Summary:	Document what needs to be updated in database schema created by BRMS for production use
Product:	[JBoss] JBoss Enterprise BRMS Platform 5	Reporter:	Jiri Svitak <jsvitak>
Component:	doc-BRMS_Administrator_Guide	Assignee:	lcarlon <lcarlon>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Jiri Svitak <jsvitak>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	BRMS 5.3.1	CC:	alazarot, dhoffman, mbaluch, mrietvel, tkobayas
Target Milestone:	---	Keywords:	Documentation
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2013-01-21 03:33:16 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Jiri Svitak 2012-12-04 14:35:10 UTC

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.

Comment 1 lcarlon 2012-12-05 00:57:38 UTC

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

Comment 2 lcarlon 2012-12-05 01:01:12 UTC

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

Comment 3 lcarlon 2012-12-06 03:18:21 UTC

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

Comment 9 Jiri Svitak 2012-12-07 14:04:10 UTC

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.

Comment 10 lcarlon 2012-12-10 01:22:51 UTC

Thanks, Jiri!

Comment 12 lcarlon 2012-12-20 00:17:31 UTC

Thanks you, Toshiya.

I've corrected the typo and will publish the updated guide.

Comment 13 lcarlon 2013-01-21 03:32:13 UTC

*** Bug 857192 has been marked as a duplicate of this bug. ***