On 06/27/2011 11:24 AM, Eric Kreiser wrote: > the problem(I think) is that I don't use Resin's clustering... and > rely on the db persistent sessions to handle bouncing between servers.
The db persistent sessions in Resin 4.0 is a backup to Resin's clustering. If you're using db persistent sessions, you're also using Resin's clustered sessions. It's not a replacement, it's an additional level of reliability. -- Scott > > > On 06/27/2011 01:50 PM, Scott Ferguson wrote: >> On 06/27/2011 10:39 AM, Eric Kreiser wrote: >>> I am trying to upgrade from 4.0.15 to 4.0.19. >>> >>> The server fails to start. >> For now, just set the persistent-store type="cluster" instead of "jdbc". >> >> The jdbc store in Resin 4.0 acts as a backup to the normal cluster >> store. >> >> -- Scott >> >>> The problem is that it is trying to create the "resin_data" and >>> "resin_mnode" database tables ... but the "create table" syntax is not >>> valid for Oracle. >>> >>> -------------------------------------------------------------------------------------------------- >>> >>> >>> 06-27 12:38:29.146 JdbcMnodeStore[server] >>> java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not >>> exist >>> >>> 06-27 12:38:29.146 CREATE TABLE resin_mnode ( >>> id CHAR(64) PRIMARY KEY, >>> value CHAR(64), >>> cache_id CHAR(64), >>> expire_timeout BIGINT, >>> idle_timeout BIGINT, >>> lease_timeout BIGINT, >>> local_read_timeout BIGINT, >>> update_time BIGINT, >>> item_version BIGINT, >>> flags INTEGER, >>> server_version INTEGER) >>> 06-27 12:38:29.149 [3ms] >>> jdbc/versioncloud.d0.0.0:exn-executeUpdate(CREATE TABLE resin_mnode ( >>> id CHAR(64) PRIMARY KEY, >>> value CHAR(64), >>> cache_id CHAR(64), >>> expire_timeout BIGINT, >>> idle_timeout BIGINT, >>> lease_timeout BIGINT, >>> local_read_timeout BIGINT, >>> update_time BIGINT, >>> item_version BIGINT, >>> flags INTEGER, >>> server_version INTEGER)) -> >>> java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype >>> >>> 06-27 12:38:29.149 [0ms] jdbc/versioncloud.d0.0.0:close() >>> 06-27 12:38:29.149 idle >>> ManagedPoolItem[jdbc/versioncloud,0,ManagedConnectionImpl] >>> 06-27 12:38:29.149 jdbc/versioncloud.d0.0:clearWarnings() >>> 06-27 12:38:29.149 java.lang.RuntimeException: >>> java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype >>> >>> at >>> com.caucho.distcache.cluster.ClusterDataBacking.<init>(ClusterDataBacking.java:89) >>> >>> >>> at >>> com.caucho.distcache.cluster.ClusterCacheManagerImpl.createDataBacking(ClusterCacheManagerImpl.java:81) >>> >>> >>> at >>> com.caucho.server.distcache.AbstractCacheManager.start(AbstractCacheManager.java:1133) >>> >>> >>> at >>> com.caucho.distcache.cluster.ClusterCacheManagerImpl.start(ClusterCacheManagerImpl.java:90) >>> >>> >>> at >>> com.caucho.env.distcache.DistCacheSystem.start(DistCacheSystem.java:110) >>> >>> at >>> com.caucho.env.service.ResinSystem.startServices(ResinSystem.java:513) >>> at >>> com.caucho.env.service.ResinSystem.start(ResinSystem.java:481) >>> at >>> com.caucho.server.resin.Resin.start(Resin.java:999) >>> at >>> com.caucho.server.resin.Resin.initMain(Resin.java:1127) >>> at >>> com.caucho.server.resin.Resin.main(Resin.java:1426) >>> Caused by: java.sql.SQLSyntaxErrorException: >>> ORA-00902: invalid datatype >>> >>> at >>> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) >>> at >>> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) >>> at >>> oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) >>> at >>> oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) >>> at >>> oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) >>> at >>> oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) >>> at >>> oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) >>> at >>> oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) >>> at >>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) >>> >>> >>> at >>> oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814) >>> >>> >>> at >>> oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779) >>> >>> at >>> oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277) >>> >>> >>> at >>> com.caucho.sql.spy.SpyStatement.executeUpdate(SpyStatement.java:225) >>> at >>> com.caucho.sql.UserStatement.executeUpdate(UserStatement.java:230) >>> at >>> com.caucho.distcache.jdbc.JdbcMnodeStore.initDatabase(JdbcMnodeStore.java:256) >>> >>> >>> at >>> com.caucho.distcache.jdbc.JdbcMnodeStore.init(JdbcMnodeStore.java:196) >>> at >>> com.caucho.distcache.cluster.ClusterDataBacking.<init>(ClusterDataBacking.java:80) >>> >>> >>> ... 9 more >>> -------------------------------------------------------------------------------------------------- >>> >>> >>> >>> >>> If I manually add the tables... the server starts... but I get errors. >>> >>> -------------------------------------------------------------------------------------------------- >>> >>> >>> 06-27 12:07:31.860 jdbc/versioncloud.d0.0.5:prepareStatement(SELECT >>> d.id, d.expire_time, m.value FROM resin_mnode AS m LEFT JOIN resin_data >>> AS d ON(m.value = d.id)) >>> 06-27 12:07:31.866 [6ms] >>> jdbc/versioncloud.d0.0.5:exn-executeQuery(java.sql.SQLSyntaxErrorException: >>> >>> ORA-00933: SQL command not properly ended >>> -------------------------------------------------------------------------------------------------- >>> >>> >>> >>> >>> >> >> >> _______________________________________________ >> resin-interest mailing list >> resin-interest@caucho.com >> http://maillist.caucho.com/mailman/listinfo/resin-interest >> > > > _______________________________________________ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
