On 07/06/2011 07:28 PM, Eric Kreiser wrote: > So I am attempting to get the servers working in "clustered" mode... > > it is not working... and if I turn logging up... I am getting all kinds > of ClassNotFoundException's... it is looking for a number of Hessian > classes that are not in any of the jars released with the resin download... >
level="all" isn't generally useful because it includes normal exceptions like that one. The most you'd normally want to run at is "finer". -- Scott > 07-06 21:41:56.823 HmtpWriter[null] query AuthQuery[,SignedCredentials] > {id: 1, to:null, from:baa.app-tier.admin.resin} > 07-06 21:41:56.853 java.lang.ClassNotFoundException: > com.caucho.hmtp.AuthQueryHessianSerializer > at > java.net.URLClassLoader$1.run(URLClassLoader.java:202) > at > java.security.AccessController.doPrivileged(Native Method) > at > java.net.URLClassLoader.findClass(URLClassLoader.java:190) > at > java.lang.ClassLoader.loadClass(ClassLoader.java:307) > at > sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) > at > java.lang.ClassLoader.loadClass(ClassLoader.java:248) > at java.lang.Class.forName0(Native Method) > at java.lang.Class.forName(Class.java:247) > at > com.caucho.hessian.io.ContextSerializerFactory.getCustomSerializer(ContextSerializerFactory.java:190) > at > com.caucho.hessian.io.SerializerFactory.loadSerializer(SerializerFactory.java:266) > at > com.caucho.hessian.io.SerializerFactory.getSerializer(SerializerFactory.java:224) > at > com.caucho.hessian.io.SerializerFactory.getObjectSerializer(SerializerFactory.java:197) > at > com.caucho.hessian.io.Hessian2Output.writeObject(Hessian2Output.java:437) > at > com.caucho.hmtp.HmtpWriter.query(HmtpWriter.java:194) > at > com.caucho.hmtp.HmtpWebSocketWriter.query(HmtpWebSocketWriter.java:152) > at > com.caucho.cloud.bam.HmtpStream.authenticate(HmtpStream.java:167) > at > com.caucho.cloud.bam.HmtpStream.init(HmtpStream.java:137) > at > com.caucho.cloud.bam.HmtpStream.<init>(HmtpStream.java:78) > at > com.caucho.cloud.heartbeat.HeartbeatActor.openStream(HeartbeatActor.java:335) > at > com.caucho.cloud.heartbeat.HeartbeatActor.sendMessage(HeartbeatActor.java:288) > at > com.caucho.cloud.heartbeat.HeartbeatActor.sendHeartbeatMessage(HeartbeatActor.java:270) > at > com.caucho.cloud.heartbeat.HeartbeatActor.sendHeartbeat(HeartbeatActor.java:195) > at > com.caucho.cloud.heartbeat.HeartbeatActor.access$000(HeartbeatActor.java:62) > at > com.caucho.cloud.heartbeat.HeartbeatActor$HeartBeatSender.run(HeartbeatActor.java:417) > at > com.caucho.env.thread.ResinThread.runTasks(ResinThread.java:164) > at > com.caucho.env.thread.ResinThread.run(ResinThread.java:130) > > On 07/05/2011 09:44 AM, Eric Kreiser wrote: >> I've attached a stripped down resin.conf >> >> you wrote "But the cluster store doesn't use jdbc." - BUT earlier in >> the thread you wrote "The jdbc store in Resin 4.0 acts as a backup to >> the normal cluster store." >> >> which is it? >> >> how can things like persistent sessions work in a load balanced scenario >> if all servers are not pointing to the same DB? >> >> like I stated earlier in the thread - I haven't been using Resin's >> clustering setup... I have been relying on db persisted sessions to >> "tie" the server together... is this approach no longer valid with 4.0? >> >> Does Caucho intend to support Oracle? or do I need to stay on a earlier >> version until I can figure out what I am going to do? >> >> >> >> >> >> On 07/01/2011 11:41 AM, Scott Ferguson wrote: >>> On 07/01/2011 07:57 AM, Eric Kreiser wrote: >>>> I changed my persistent-store type to be "cluster" instead of "jdbc"... >>>> but it still doesn't start because it still needs the "new" resin >>>> database tables... (which fail on create connecting to Oracle) >>> But the cluster store doesn't use jdbc. It wouldn't even know about the >>> Oracle database. >>> >>> What does that section of the resin.xml look like? >>> >>> -- Scott >>> >>>> thoughts? >>>> Eric Kreiser >>>> >>>> >>>> On 06/27/2011 02:24 PM, 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. >>>>> >>>>> >>>>> 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 >>>>> >>>> _______________________________________________ >>>> 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 >>> > > > _______________________________________________ > 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