Bug 1022485 - Failed to upload ontology - unexpected (and unknown) error was sent by the S-RAMP repository when PostgreSQL is used
Summary: Failed to upload ontology - unexpected (and unknown) error was sent by the S-...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Fuse Service Works 6
Classification: JBoss
Component: Installer
Version: 6.0.0 GA
Hardware: Unspecified
OS: Unspecified
unspecified
urgent
Target Milestone: ER7
: 6.0.0
Assignee: Thomas Hauser
QA Contact: Stefan Bunciak
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-10-23 11:49 UTC by Pavol Srna
Modified: 2014-02-06 15:32 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:
Type: Bug

Attachments (Terms of Use)
logs (42.62 KB, application/zip)
2013-10-23 11:49 UTC, Pavol Srna 		no flags Details
screenshot (134.45 KB, image/png)
2013-10-23 11:50 UTC, Pavol Srna 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Description Pavol Srna 2013-10-23 11:49:31 UTC 
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.
Comment 1 Pavol Srna 2013-10-23 11:50:32 UTC 
Created attachment 815353 [details]
screenshot
Comment 3 Thomas Hauser 2013-10-23 13:33:06 UTC 
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.
Comment 4 Thomas Hauser 2013-11-13 16:56:07 UTC 
The new infinispan definitions will be available in ER7.
Comment 5 Pavol Srna 2013-12-13 13:50:49 UTC 
Verified in ER7.
Note You need to log in before you can comment on or make changes to this bug.