Database problem when upgrading to 6.0.4

[rgansevles]

Michael,

In Servoy 6.0.5 the error logging is improved a bit when this exception occurs.

Can you show the latest stacktraces?

Rob

[msedita]

One thing I notice, the repository_server always connects OK, the others do not.

Here is the entire log file:

Code: Select all

2012-02-07 15:11:56,276 ERROR [pool-1-thread-1] com.servoy.j2db.server.Za.Zo - error init table [ ]
java.sql.SQLException: Accessing a closed ResultSet object
   at sybase.jdbc.sqlanywhere.IIResultSet.getStatement(Native Method)
   at sybase.jdbc.sqlanywhere.IIResultSet.getMetaData(IResultSet.java:872)
   at sybase.jdbc.sqlanywhere.IColumnsResultSet.getMetaData(IColumnsResultSet.java:371)
   at org.apache.commons.dbcp.DelegatingResultSet.getMetaData(DelegatingResultSet.java:322)
   at org.apache.commons.dbcp.DelegatingResultSet.getMetaData(DelegatingResultSet.java:322)
   at org.apache.commons.dbcp.DelegatingResultSet.getMetaData(DelegatingResultSet.java:322)
   at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:707)
   at com.servoy.j2db.server.Za.Zo.Zd(Zo.java:132)
   at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:456)
   at com.servoy.j2db.server.Za.Zo.getTable(Zo.java:23)
   at com.servoy.j2db.server.main.Zr.run(Zr.java:14)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
2012-02-07 15:11:56,279 ERROR [pool-1-thread-1] com.servoy.j2db.util.Debug - Throwable [ ]
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Accessing a closed ResultSet object Accessing a closed ResultSet object
   at com.servoy.j2db.server.Za.Zo.Zd(Zo.java:1462)
   at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:456)
   at com.servoy.j2db.server.Za.Zo.getTable(Zo.java:23)
   at com.servoy.j2db.server.main.Zr.run(Zr.java:14)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
2012-02-07 15:11:56,355 ERROR [pool-1-thread-1] com.servoy.j2db.server.Za.Zo - error init table [ ]
java.sql.SQLException: Accessing a closed ResultSet object
   at sybase.jdbc.sqlanywhere.IIResultSet.getStatement(Native Method)
   at sybase.jdbc.sqlanywhere.IIResultSet.getMetaData(IResultSet.java:872)
   at sybase.jdbc.sqlanywhere.IColumnsResultSet.getMetaData(IColumnsResultSet.java:371)
   at org.apache.commons.dbcp.DelegatingResultSet.getMetaData(DelegatingResultSet.java:322)
   at org.apache.commons.dbcp.DelegatingResultSet.getMetaData(DelegatingResultSet.java:322)
   at org.apache.commons.dbcp.DelegatingResultSet.getMetaData(DelegatingResultSet.java:322)
   at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:707)
   at com.servoy.j2db.server.Za.Zo.Zd(Zo.java:132)
   at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:456)
   at com.servoy.j2db.server.Za.Zo.getTable(Zo.java:23)
   at com.servoy.j2db.server.main.Zr.run(Zr.java:14)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
2012-02-07 15:11:56,356 ERROR [pool-1-thread-1] com.servoy.j2db.util.Debug - Throwable [ ]
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Accessing a closed ResultSet object Accessing a closed ResultSet object
   at com.servoy.j2db.server.Za.Zo.Zd(Zo.java:1462)
   at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:456)
   at com.servoy.j2db.server.Za.Zo.getTable(Zo.java:23)
   at com.servoy.j2db.server.main.Zr.run(Zr.java:14)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)


Here is the stack/server info:

Code: Select all

Current time: Tue Feb 07 15:14:59 EST 2012

Server Information
Servoy version 6.0.5 -build 1230
Port used by RMI Registry: 1099
Repository version 40

Current time: Tue Feb 07 15:14:59 EST 2012

Uptime:  3 minutes 5 seconds

JDK Information
java.vm.name=Java HotSpot(TM) Client VM
java.version=1.6.0_29
java.vm.info=mixed mode
java.vm.vendor=Sun Microsystems Inc.

Operating System Information
os.name=Windows 7
os.version=6.1
os.arch=x86

System Information
Heap Space Memory: allocated=74040K, used=46658K, max=1267072K
Non-Heap Space Memory: allocated=37280K, used=37254K, max=163840K

Thread: http-8080-1, state: RUNNABLE, total cpu time: 140.4009ms, total user time: 124.8008ms
  sun.management.ThreadImpl.getThreadInfo1(Native Method)
  sun.management.ThreadImpl.getThreadInfo(Unknown Source)
  sun.management.ThreadImpl.getThreadInfo(Unknown Source)
  com.servoy.j2db.server.servlets.ConfigServlet.Zs(ConfigServlet.java:2372)
  com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:2133)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554)
  org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
  org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  java.lang.Thread.run(Unknown Source)

Thread: DestroyJavaVM, state: RUNNABLE, total cpu time: 4773.6306ms, total user time: 4071.6261ms

Thread: http-8080-Acceptor-0, state: RUNNABLE, total cpu time: 0.0ms, total user time: 0.0ms
  java.net.PlainSocketImpl.socketAccept(Native Method)
  java.net.PlainSocketImpl.accept(Unknown Source)
  java.net.ServerSocket.implAccept(Unknown Source)
  java.net.ServerSocket.accept(Unknown Source)
  org.apache.tomcat.util.net.DefaultServerSocketFactory.acceptSocket(DefaultServerSocketFactory.java:61)
  org.apache.tomcat.util.net.JIoEndpoint$Acceptor.run(JIoEndpoint.java:352)
  java.lang.Thread.run(Unknown Source)

Thread: ContainerBackgroundProcessor[StandardEngine[Catalina]], state: TIMED_WAITING, total cpu time: 15.6001ms, total user time: 0.0ms
  java.lang.Thread.sleep(Native Method)
  org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1627)
  java.lang.Thread.run(Unknown Source)

Thread: ModificationWatcher Task, state: TIMED_WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  java.lang.Thread.sleep(Native Method)
  org.apache.wicket.util.time.Duration.sleep(Duration.java:445)
  org.apache.wicket.util.thread.Task$1.run(Task.java:130)
  java.lang.Thread.run(Unknown Source)

Thread: pool-1-thread-2, state: TIMED_WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  sun.misc.Unsafe.park(Native Method)
  java.util.concurrent.locks.LockSupport.parkNanos(Unknown Source)
  java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(Unknown Source)
  java.util.concurrent.DelayQueue.take(Unknown Source)
  java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
  java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: GC Daemon, state: TIMED_WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  java.lang.Object.wait(Native Method)
  sun.misc.GC$Daemon.run(Unknown Source)

Thread: RMI Reaper, state: WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  java.lang.Object.wait(Native Method)
  java.lang.ref.ReferenceQueue.remove(Unknown Source)
  java.lang.ref.ReferenceQueue.remove(Unknown Source)
  sun.rmi.transport.ObjectTable$Reaper.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: pool-1-thread-1, state: WAITING, total cpu time: 15.6001ms, total user time: 0.0ms
  sun.misc.Unsafe.park(Native Method)
  java.util.concurrent.locks.LockSupport.park(Unknown Source)
  java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unknown Source)
  java.util.concurrent.LinkedBlockingQueue.take(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: RMI TCP Accept-1099, state: WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  sun.misc.Unsafe.park(Native Method)
  java.util.concurrent.locks.LockSupport.park(Unknown Source)
  java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unknown Source)
  java.util.concurrent.ArrayBlockingQueue.take(Unknown Source)
  com.servoy.j2db.rmi.ServerTwoWaySocketFactory$TwoWayServerSocket.accept(ServerTwoWaySocketFactory.java:579)
  sun.rmi.transport.tcp.TCPTransport$AcceptLoop.executeAcceptLoop(Unknown Source)
  sun.rmi.transport.tcp.TCPTransport$AcceptLoop.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: 2 way Server Acceptor, state: RUNNABLE, total cpu time: 0.0ms, total user time: 0.0ms
  java.net.PlainSocketImpl.socketAccept(Native Method)
  java.net.PlainSocketImpl.accept(Unknown Source)
  java.net.ServerSocket.implAccept(Unknown Source)
  com.sun.net.ssl.internal.ssl.SSLServerSocketImpl.accept(Unknown Source)
  com.servoy.j2db.rmi.ServerTwoWaySocketFactory$TwoWayServerSocket.run(ServerTwoWaySocketFactory.java:597)
  java.lang.Thread.run(Unknown Source)

Thread: pool-2-thread-1, state: TIMED_WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  sun.misc.Unsafe.park(Native Method)
  java.util.concurrent.locks.LockSupport.parkNanos(Unknown Source)
  java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(Unknown Source)
  java.util.concurrent.DelayQueue.take(Unknown Source)
  java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
  java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: PingScanner, state: TIMED_WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  java.lang.Object.wait(Native Method)
  com.servoy.j2db.dataprocessing.Zn.run(Zn.java:12)
  java.lang.Thread.run(Unknown Source)

Thread: MessageScheduler, state: TIMED_WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  java.lang.Object.wait(Native Method)
  com.servoy.j2db.dataprocessing.Zp.run(Zp.java:25)
  java.lang.Thread.run(Unknown Source)

Thread: MessagePreHandler, state: WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  java.lang.Object.wait(Native Method)
  java.lang.Object.wait(Object.java:485)
  com.servoy.j2db.dataprocessing.ClientMessagePreQueueHandler.run(ClientMessagePreQueueHandler.java:10)
  java.lang.Thread.run(Unknown Source)

Thread: Attach Listener, state: RUNNABLE, total cpu time: 0.0ms, total user time: 0.0ms

Thread: Signal Dispatcher, state: RUNNABLE, total cpu time: 0.0ms, total user time: 0.0ms

Thread: Finalizer, state: WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  java.lang.Object.wait(Native Method)
  java.lang.ref.ReferenceQueue.remove(Unknown Source)
  java.lang.ref.ReferenceQueue.remove(Unknown Source)
  java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)

Thread: Reference Handler, state: WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  java.lang.Object.wait(Native Method)
  java.lang.Object.wait(Object.java:485)
  java.lang.ref.Reference$ReferenceHandler.run(Unknown Source)




Here is servoy properties (note I start the database manually):

Code: Select all

# Servoy properties file
# NOTE: At least one connection must be called 'repository_server' !!

# Number of servers defined in this file
ServerManager.numberOfServers=3
server.0.URL=jdbc\:sqlanywhere\:CommLinks\=tcpip(host\=localhost;port\=2638;dobroad\=no);UID\=DBA;PWD\=sql;ENG\=servoy_repository;DBN\=CMHCi;Enc\=tls(tls_type\=rsa;trusted_certificates\=sybase.cmhcihost.crt);log\=cmhci_connect.txt;pbuf=2m
server.0.catalog=<none>
server.0.connectionValidationType=2
server.0.driver=sybase.jdbc.sqlanywhere.IDriver
server.0.enabled=true
server.0.maxConnectionsActive=10
server.0.maxConnectionsIdle=10
server.0.maxPreparedStatementsIdle=45
server.0.password=encrypted\:aD4kOmHPzcM\=
server.0.schema=<none>
server.0.serverName=cmhci
server.0.skipSysTables=false
server.0.userName=DBA
server.0.validationQuery=select 1;
server.1.URL=jdbc\:sqlanywhere\:CommLinks\=tcpip(host\=localhost;port\=2638;dobroad\=no);UID\=DBA;PWD\=sql;ENG\=servoy_repository;DBN\=log_data;Enc\=tls(tls_type\=rsa;trusted_certificates\=sybase.cmhcihost.crt);log\=log_connect.txt;pbuf=2m
server.1.catalog=<none>
server.1.connectionValidationType=2
server.1.driver=sybase.jdbc.sqlanywhere.IDriver
server.1.enabled=true
server.1.maxConnectionsActive=10
server.1.maxConnectionsIdle=10
server.1.maxPreparedStatementsIdle=45
server.1.password=encrypted\:aD4kOmHPzcM\=
server.1.schema=<none>
server.1.serverName=log_server
server.1.skipSysTables=false
server.1.userName=DBA
server.1.validationQuery=select 1;
server.2.URL=jdbc\:sqlanywhere\:CommLinks\=tcpip(host\=localhost;port\=2638;dobroad\=no);UID\=DBA;PWD\=sql;ENG\=servoy_repository;DBN\=servoy_repository;Enc\=tls(tls_type\=rsa;trusted_certificates\=sybase.cmhcihost.crt);log\=repository_connect.txt;pbuf=2m
server.2.catalog=<none>
server.2.connectionValidationType=2
server.2.driver=sybase.jdbc.sqlanywhere.IDriver
server.2.enabled=true
server.2.maxConnectionsActive=10
server.2.maxConnectionsIdle=10
server.2.maxPreparedStatementsIdle=45
server.2.password=encrypted\:aD4kOmHPzcM\=
server.2.schema=<none>
server.2.serverName=repository_server
server.2.skipSysTables=false
server.2.userName=DBA
server.2.validationQuery=select 1;


#start database engine
waitForNativeStartup=false

#for use by pdf_forms plugin
pdf_forms_plugin_servername=pdf_forms

#network config
SocketFactory.useTwoWaySocket=true
SocketFactory.useSSL=true
java.rmi.server.hostname=127.0.0.1
servoy.rmiStartPort=1099
servoy.application_server.startRepositoryAsTeamProvider=false