Bug 1284755 - Installer DDL scripts are not tolerant for pre-existing tables
Summary: Installer DDL scripts are not tolerant for pre-existing tables
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: Installer
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: CR2
: 6.2.0
Assignee: Miroslav Sochurek
QA Contact: Dominik Hanak
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-11-24 07:11 UTC by Dominik Hanak
Modified: 2020-03-27 20:04 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-03-27 20:04:20 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)

Description Dominik Hanak 2015-11-24 07:11:46 UTC 
Description of problem:
DDL scripts used by installer don't tolerate pre-exisiting DB tables.
Therefore the installation will fail if DB specified for Quartz already has them created.

Version-Release number of selected component (if applicable):
6.2.0.CR1

How reproducible:
always

Steps to Reproduce:
1. Run Installer
2. Proceed to Advanced configuration
3. Select Install with cluster configuration
4. Use databse with pre-exisiting tables (use old db with qrtz tables)
5. Finish

Actual results:
Installation fails

Expected results:
Installation succeed. it would also be nice to inform user that he 
has the tables already created.

Additional info:
Comment 2 Dominik Hanak 2015-11-24 08:40:29 UTC 
Additional info:
Also, when installation fails this way. There is no message displayed to user
stating what was the cause and I am also unable to find any hint in InstallationLogs.
Comment 3 Thomas Hauser 2015-11-27 15:51:38 UTC 
I've modified the job to tolerate failures, and also improved the logging. Here's the new output:

Success: http://pastebin.test.redhat.com/331289
Failures: http://pastebin.test.redhat.com/331288
Comment 4 Dominik Hanak 2015-12-02 07:21:58 UTC 
Verified in 6.2.0.CR2.
Note You need to log in before you can comment on or make changes to this bug.