| << Back to previous view |
|
[QB-737] Unable to start Quickbuild 1.2.13
|
|
| Status: | Resolved |
| Project: | QuickBuild |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Dave Silk | Assigned To: | Robin Shen |
| Resolution: | Won't Fix | Votes: | 0 |
| Remaining Estimate: | Unknown | Time Spent: | Unknown |
| Original Estimate: | Unknown | ||
| Environment: | Red Hat Enterprise Linux AS release 4 (Nahant Update 4) | ||
| Description |
|
We had a recent hard shutdown of the Quickbuild server and while trying to restart the system, we get the following errors in the tomcat logs:
Nov 15, 2010 12:50:53 PM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on http-8080 Nov 15, 2010 12:50:53 PM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 563 ms Nov 15, 2010 12:50:53 PM org.apache.catalina.core.StandardService start INFO: Starting service Catalina Nov 15, 2010 12:50:53 PM org.apache.catalina.core.StandardEngine start INFO: Starting Servlet Engine: Apache Tomcat/5.0.28 Nov 15, 2010 12:50:53 PM org.apache.catalina.core.StandardHost start INFO: XML validation disabled QuickBuild : --> Context initialization started. QuickBuild : --> Set installation directory as "/local/apps/quickbuild-1.2.13-bugfix". QuickBuild : --> Reading product info... QuickBuild : --> Initializing loggers... QuickBuild : --> Initializing spring... java.lang.IndexOutOfBoundsException at java.nio.Buffer.checkBounds(Buffer.java:530)... (Tuncated stack trace) 2010-11-15 12:50:56,193 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null 2010-11-15 12:50:56,193 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory 2010-11-15 12:50:56,194 [main] WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause: java.sql.SQLException: error in script file line: 24 S1000 General error java.lang.IndexOutOfBoundsException in statement [SET TABLE QB_BUILD INDEX'8996680 8747016 0'] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)... (Tuncated stack trace) java.lang.IndexOutOfBoundsException at java.nio.Buffer.checkBounds(Buffer.java:530)... (Tuncated stack trace) 2010-11-15 12:50:57,044 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null 2010-11-15 12:50:57,044 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory 2010-11-15 12:50:57,044 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - could not get database metadata org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause: java.sql.SQLException: error in script file line: 24 S1000 General error java.lang.IndexOutOfBoundsException in statement [SET TABLE QB_BUILD INDEX'8996680 8747016 0'] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) 2010-11-15 12:50:57,045 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - could not complete schema update org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause: java.sql.SQLException: error in script file line: 24 S1000 General error java.lang.IndexOutOfBoundsException in statement [SET TABLE QB_BUILD INDEX'8996680 8747016 0'] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) 2010-11-15 12:50:57,628 [main] WARN org.springframework.jdbc.support.SQLErrorCodesFactory - Error while extracting database product name - falling back to empty error codes org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause: java.sql.SQLException: error in script file line: 24 S1000 General error java.lang.IndexOutOfBoundsException in statement [SET TABLE QB_BUILD INDEX'8996680 8747016 0'] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) 2010-11-15 12:50:57,897 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null 2010-11-15 12:50:57,897 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory 2010-11-15 12:50:57,898 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null 2010-11-15 12:50:57,898 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause: error in script file line: 24 S1000 General error java.lang.IndexOutOfBoundsException in statement [SET TABLE QB_BUILD INDEX'8996680 8747016 0'] at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:825) Caused by: java.sql.SQLException: error in script file line: 24 S1000 General error java.lang.IndexOutOfBoundsException in statement [SET TABLE QB_BUILD INDEX'8996680 8747016 0'] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) Nov 15, 2010 12:50:57 PM org.apache.catalina.core.StandardContext start SEVERE: Error listenerStart Nov 15, 2010 12:50:57 PM org.apache.catalina.core.StandardContext start SEVERE: Context startup failed due to previous errors Nov 15, 2010 12:50:57 PM org.apache.catalina.core.StandardHost getDeployer INFO: Create Host deployer for direct deployment ( non-jmx ) Nov 15, 2010 12:50:57 PM org.apache.catalina.core.StandardHostDeployer install INFO: Installing web application at context path /webdav from URL file:/local/apps/quickbuild-1.2.13-bugfix/tomcat/webapps/webdav Nov 15, 2010 12:50:58 PM org.apache.coyote.http11.Http11Protocol start INFO: Starting Coyote HTTP/1.1 on http-8080 Nov 15, 2010 12:50:58 PM org.apache.jk.common.ChannelSocket init INFO: JK2: ajp13 listening on /0.0.0.0:8009 Nov 15, 2010 12:50:58 PM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=0/10 config=/local/apps/quickbuild/tomcat/conf/jk2.properties Nov 15, 2010 12:50:58 PM org.apache.catalina.startup.Catalina start INFO: Server startup in 4303 ms Please help. |
| Comments |
| Comment by Dave Silk [ 15/Nov/10 09:30 PM ] |
| looks like the database somehow was corrupted during the shutdown. a restore corrected the issue. |
| Comment by Robin Shen [ 15/Nov/10 11:58 PM ] |
| Please switch to use external db such as MySQL as hsqldb is not reliable enough to be used in a production environment. The procedure can be found in the user guide in data management section. |