Bug 1014562 - BPEL/RTGov tables are created multiple times
Summary: BPEL/RTGov tables are created multiple times
Keywords:
Status: CLOSED DUPLICATE of bug 1029007
Alias: None
Product: JBoss Fuse Service Works 6
Classification: JBoss
Component: Configuration
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
: ---
Assignee: Steve Johnson
QA Contact: Len DiMaggio
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-10-02 10:58 UTC by Jiri Pechanec
Modified: 2013-11-15 13:16 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-11-14 16:50:58 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)
DB log file (84.65 KB, text/x-log)
2013-10-02 10:59 UTC, Jiri Pechanec 		no flags Details
View All

Description Jiri Pechanec 2013-10-02 10:58:22 UTC 
See attached log file, RTGOV_* tables are dropped/created twice. The problem is probably cause by having the same tables process both by 
overlord-rtgov-epn.overlord-rtgov-epn.*
overlord-rtgov.overlord-rtgov-activity.*
Comment 1 Jiri Pechanec 2013-10-02 10:59:15 UTC 
Created attachment 806379 [details]
DB log file
Comment 2 Jiri Pechanec 2013-10-02 11:11:33 UTC 
The issue is present also for BPEL - 4 times
Comment 3 Julian Coleman 2013-10-02 11:31:01 UTC 
The problem occurs because the schema for each project has to be created at project build time.  This means that if two projects reference the same set of classes, then multiple copies of the tables for those appear when these projects are combined.

The solution is probably to post-process the created schema for all the combined projects, and to remove the duplicates.  This will involve creating a tool/plugin to do this.
Comment 4 Len DiMaggio 2013-10-02 14:01:26 UTC 
Is this only a blocking issue for PostgreSQL?
Comment 5 Steve Johnson 2013-11-13 18:28:41 UTC 
The work being carried out on https://bugzilla.redhat.com/show_bug.cgi?id=1029007 is aimed at resolving this issue.

The tool cannot resolve into one big schema (or one sql file) as the installer chooses what projects it needs to install and its associated tables.

Therefore, the build time hibernate plugin is being updated to post process each project sql and add guards to the table creation to stop it trying to recreate tables that already exist.

Any superfluous drop statements will also be removed.
Comment 6 Julian Coleman 2013-11-14 16:50:58 UTC 

*** This bug has been marked as a duplicate of bug 1029007 ***
Note You need to log in before you can comment on or make changes to this bug.