Bug 1175304
| Summary: | Database Logging: Problems with DB2 | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Jan Stastny <jstastny> | ||||
| Component: | Teiid | Assignee: | Van Halbert <vhalbert> | ||||
| Status: | CLOSED NOTABUG | QA Contact: | |||||
| Severity: | unspecified | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 6.1.0 | CC: | atangrin | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2014-12-19 06:12:33 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
Jan Stastny <jstastny> updated the status of jira TEIID-3262 to Closed |
Created attachment 970106 [details] stacktrace When during installation I chose to install DB2 driver and enable db logging, installation completed fine. When I attempted to start the server an error occurs when deploying dashboard builder war: 13:02:15,237 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 56) HHH000389: Unsuccessful: create table commandlog (id bigint not null, applicationname varchar(255), executionid varchar(50), modelname varchar(255), principal varchar(50), queryplan blob(255), requestid varchar(50), row_count integer, sessionid varchar(50), sourcecommand smallint, sourcerequestid bigint, sqlcmd varchar(8196), eventtype varchar(10), logtime timestamp, transactionid varchar(256), translatorname varchar(50), vdbname varchar(255), vdbversion integer, primary key (id)) 13:02:15,238 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 56) DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;DBALLO00, DRIVER=4.12.55 Furthermore, when command logging is turned on, with each query on a vdb, a long stacktrace is produced. The snippet of the stacktrace is in the attached file.