| Summary: | Failed to upload ontology - unexpected (and unknown) error was sent by the S-RAMP repository when PostgreSQL is used | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Fuse Service Works 6 | Reporter: | Pavol Srna <psrna> | ||||||
| Component: | Installer | Assignee: | Thomas Hauser <thauser> | ||||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Stefan Bunciak <sbunciak> | ||||||
| Severity: | urgent | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 6.0.0 GA | CC: | jsedlace, psrna, soa-p-jira | ||||||
| Target Milestone: | ER7 | ||||||||
| Target Release: | 6.0.0 | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | Type: | Bug | |||||||
| Regression: | --- | Mount Type: | --- | ||||||
| Documentation: | --- | CRM: | |||||||
| Verified Versions: | Category: | --- | |||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||
| Attachments: |
|
||||||||
Created attachment 815353 [details]
screenshot
Looking at the log, this is the root cause:
13:15:32,551 ERROR [org.infinispan.loaders.jdbc.TableManipulation] (http-localhost/127.0.0.1:8080-2) ISPN008011: Error while creating table; used DDL statement: 'CREATE TABLE "ispn_bucket_sramp"(id VARCHAR(500) NOT NULL, datum VARBINARY(60000), version BIGINT, PRIMARY KEY (id))': org.postgresql.util.PSQLException: ERROR: type "varbinary" does not exist
I believe that there are new scripts to help take care of this in post-beta builds. The new scripts contain correct data types for each individual database in the infinispan definition for S-RAMP. Relevant portion of the standalone.xml below:
<cache-container name="modeshape">
<local-cache name="sramp">
<locking isolation="NONE"/>
<transaction mode="NON_XA"/>
<string-keyed-jdbc-store datasource="java:jboss/datasources/srampDS" passivation="false" purge="false">
<string-keyed-table prefix="ispn_bucket">
<id-column name="id" type="VARCHAR(500)"/>
<data-column name="datum" type="VARBINARY(60000)"/>
<timestamp-column name="version" type="BIGINT"/>
</string-keyed-table>
</string-keyed-jdbc-store>
</local-cache>
</cache-container>
This infinispan definition requires different types on a per-vendor basis.
The new infinispan definitions will be available in ER7. Verified in ER7. |
Created attachment 815350 [details] logs Description of problem: Failed to upload ontology - unexpected (and unknown) error was sent by the S-RAMP repository. Happens with postgresql. Please see screenshot and logs attached.