Bug 108184
| Summary: | PackageTool doesn't commit transaction when run with -schema | ||
|---|---|---|---|
| Product: | [Retired] Red Hat Web Application Framework | Reporter: | Daniel Berrangé <berrange> |
| Component: | other | Assignee: | ccm-bugs-list |
| Status: | CLOSED RAWHIDE | QA Contact: | Jon Orris <jorris> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | nightly | ||
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2003-11-05 16:15:16 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 106597 | ||
Fixed @37450. |
From Bugzilla Helper: User-Agent: Mozilla/5.0 Galeon/1.2.9 (X11; Linux i686; U;) Gecko/20030314 Description of problem: The JDBC connection returned by Connections.aquire has auto-commit disabled, so explicit calls to Connection#commit are required after doing DB work. The PackageTool never calls 'commit' when run with the '-schema' option, so the DML work is never committed & the DB rolls it back. We are also not cleanly closing the JDBC connection before the program exits, leading to warnings in the DB server logs: Oct 28 13:47:44 hillingdon postgres[12369]: [135] DEBUG: pq_recvbuf: unexpected EOF on client connection NB, there seems to be something special about loading 'ccm-core' since it doesn't exhibit this behaviour. Only ccm-cms & other apps fail with -schema. NB, this also doesn't apply to Oracle, since it is incapable of processing a bunch of DML statements within a transaction :-( Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1. Run 'ccm-pkg load ccm-cms -schema' 2. Launch psql & look for cms_items table 3. Actual Results: cms_items is missing Expected Results: cms_items is present Additional info: