Solution never finishes importing

[jd2p]

Hello everyone, I encountered a problem I hadn't seen before. While importing our solution at the client site, the application server appears to be working, however the solution never finishes importing, the log doesn't display any errors, even with trace on. We have left this running for more than an hour and the Application Server appears to be doing something but we get no results. If we make a small, sample application with a single form, it does get imported.

Details of the cusomer machine. A VM (on Hyper-V) with:
Windows server 2008 r2 version SP1, 64 bits
Servoy App Server version 6.1.0 release 1416
PostgreSQL 9.0
32 bit Java 1.7.0_09
Oracle 11G R2 (the back-end that our solutions uses)

Also tried with the latest Servoy App Server with the same thing happening.

The solution gets exported from Servoy Developer 6.1.2 - build 1421. Our solution uses ServoyGuy_ServoyCOM-v1.1.3 and ChartNScript_Servoy_JasperReports_Plugin_v.4.0.0b1.

Has anyone seen a similar situation?

Regards,
jd

[jd2p]

This happens even with Servoy sample solutions such as the CRM.

[Peter de Groot]

Hello JD,

No solution buy F.Y.I.,

we experience this several times a year with Servoy 5.2.9, the import hangs for no known reason. When this happens we restart the Servoy service and do the import again, after the restart the import proceeds as expected. Because of this uncertainty we always import outside business hours.

Regards,

Peter

[jd2p]

Hi Peter,
Thanks for the reply! The weird thing is, we already tried restarting the service, the server and even reinstalling Servoy, and the same thing keeps happening.

[jd2p]

After restarting the service I CAN import a sample solution, but still can't upload our own.

[jd2p]

We tried changing the connections so that they worked against the Postgres database instead of the Oracle database.. it got imported in just over a minute. So we could say there is a problem with the connections to Oracle, even though they appear online, the Database is in the same machine and is working properly and there are no errors in the log.

I posted this in Servoy Support and posted the stack dump since it was requested, I haven't gotten a response yet I think mainly due to the time differences. I'm reposting here in the hopes that someone else may have seen this case and can offer a solution.

The current stackdump while importing is the following:

Code: Select all

Current time: Mon Jan 28 11:53:02 CST 2013

Server Information
Servoy version 6.1.0 rc4-build 1416
Port used by RMI Registry: 1099
Repository version 42

Current time: Mon Jan 28 11:53:02 CST 2013

Uptime:  19 minutes 15 seconds

JDK Information
java.vm.name=Java HotSpot(TM) Client VM
java.version=1.7.0_09
java.vm.info=mixed mode
java.vm.vendor=Oracle Corporation

Operating System Information
os.name=Windows Server 2008 R2
os.version=6.1
os.arch=x86

System Information
Heap Space Memory: allocated=71760K, used=50107K, max=1267072K
Non-Heap Space Memory: allocated=42240K, used=42151K, max=163840K

Thread: http-8080-4, state: RUNNABLE, total cpu time: 15.625ms, total user time: 15.625ms
  sun.management.ThreadImpl.getThreadInfo1(Native Method)
  sun.management.ThreadImpl.getThreadInfo(Unknown Source)
  sun.management.ThreadImpl.getThreadInfo(Unknown Source)
  com.servoy.j2db.server.servlets.ConfigServlet.Zt(ConfigServlet.java:2360)
  com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:1896)
  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: http-8080-3, state: RUNNABLE, total cpu time: 0.0ms, total user time: 0.0ms
  java.net.SocketInputStream.socketRead0(Native Method)
  java.net.SocketInputStream.read(Unknown Source)
  java.net.SocketInputStream.read(Unknown Source)
  org.apache.coyote.http11.InternalInputBuffer.fill(InternalInputBuffer.java:735)
  org.apache.coyote.http11.InternalInputBuffer.parseRequestLine(InternalInputBuffer.java:366)
  org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:814)
  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: http-8080-2, state: RUNNABLE, total cpu time: 4187.5ms, total user time: 3453.125ms
  java.net.SocketInputStream.socketRead0(Native Method)
  java.net.SocketInputStream.read(Unknown Source)
  java.net.SocketInputStream.read(Unknown Source)
  oracle.net.ns.Packet.receive(Packet.java:300)
  oracle.net.ns.DataPacket.receive(DataPacket.java:106)
  oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:315)
  oracle.net.ns.NetInputStream.read(NetInputStream.java:260)
  oracle.net.ns.NetInputStream.read(NetInputStream.java:185)
  oracle.net.ns.NetInputStream.read(NetInputStream.java:102)
  oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)
  oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)
  oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)
  oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
  oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
  oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
  oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
  oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
  oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
  oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
  oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:4117)
  org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
  org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
  org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
  com.servoy.j2db.server.Za.Zo.Za(Zo.java:209)
  com.servoy.j2db.server.Za.Zo.Zf(Zo.java:1237)
  com.servoy.j2db.server.Za.Zo.Zd(Zo.java:1377)
  com.servoy.j2db.server.Za.Zo.Zc(Zo.java:787)
  com.servoy.j2db.server.Za.Zo.getTable(Zo.java:527)
  com.servoy.j2db.server.Zc.Zj.importDatabaseInfo(Zj.java:709)
  com.servoy.j2db.server.Zc.Zdb.Za(Zdb.java:235)
  com.servoy.j2db.server.Zc.Zdb.importFromJarFile(Zdb.java:190)
  com.servoy.j2db.server.servlets.ConfigServlet.Zi(ConfigServlet.java:4405)
  com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:708)
  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: http-8080-1, state: WAITING, total cpu time: 312.5ms, total user time: 296.875ms
  java.lang.Object.wait(Native Method)
  java.lang.Object.wait(Object.java:503)
  org.apache.tomcat.util.net.JIoEndpoint$Worker.await(JIoEndpoint.java:458)
  org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:484)
  java.lang.Thread.run(Unknown Source)

Thread: http-8080-Acceptor-0, state: RUNNABLE, total cpu time: 0.0ms, total user time: 0.0ms
  java.net.DualStackPlainSocketImpl.accept0(Native Method)
  java.net.DualStackPlainSocketImpl.socketAccept(Unknown Source)
  java.net.AbstractPlainSocketImpl.accept(Unknown Source)
  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: 0.0ms, 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.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
  java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: AWT-Windows, state: RUNNABLE, total cpu time: 15.625ms, total user time: 15.625ms
  sun.awt.windows.WToolkit.eventLoop(Native Method)
  sun.awt.windows.WToolkit.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: Java2D Disposer, 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.java2d.Disposer.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: GC Daemon, state: TIMED_WAITING, total cpu time: 15.625ms, 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: RUNNABLE, total cpu time: 1156.25ms, total user time: 1093.75ms
  java.net.SocketInputStream.socketRead0(Native Method)
  java.net.SocketInputStream.read(Unknown Source)
  java.net.SocketInputStream.read(Unknown Source)
  oracle.net.ns.Packet.receive(Packet.java:300)
  oracle.net.ns.DataPacket.receive(DataPacket.java:106)
  oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:315)
  oracle.net.ns.NetInputStream.read(NetInputStream.java:260)
  oracle.net.ns.NetInputStream.read(NetInputStream.java:185)
  oracle.net.ns.NetInputStream.read(NetInputStream.java:102)
  oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)
  oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)
  oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)
  oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
  oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
  oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
  oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
  oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
  oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
  oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
  oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:4117)
  org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
  org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
  org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
  com.servoy.j2db.server.Za.Zo.Za(Zo.java:209)
  com.servoy.j2db.server.Za.Zo.Zf(Zo.java:1237)
  com.servoy.j2db.server.Za.Zo.Zd(Zo.java:1377)
  com.servoy.j2db.server.Za.Zo.Zc(Zo.java:787)
  com.servoy.j2db.server.Za.Zo.getTable(Zo.java:527)
  com.servoy.j2db.server.main.Zs.run(Zs.java:8)
  java.util.concurrent.ThreadPoolExecutor.runWorker(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.LinkedBlockingQueue.take(Unknown Source)
  com.sebster.tunnel.impl.od.accept(od.java:94)
  com.sebster.tunnel.TunnelServerSocket.accept(TunnelServerSocket.java:5)
  com.sebster.tunnel.TunnelServerSocket.accept(TunnelServerSocket.java:35)
  com.servoy.j2db.rmi.compressing.CompressingServerSocket.accept(CompressingServerSocket.java:46)
  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: acceptor-0.0.0.0/0.0.0.0:1099, state: RUNNABLE, total cpu time: 0.0ms, total user time: 0.0ms
  java.net.DualStackPlainSocketImpl.accept0(Native Method)
  java.net.DualStackPlainSocketImpl.socketAccept(Unknown Source)
  java.net.AbstractPlainSocketImpl.accept(Unknown Source)
  java.net.PlainSocketImpl.accept(Unknown Source)
  java.net.ServerSocket.implAccept(Unknown Source)
  java.net.ServerSocket.accept(Unknown Source)
  com.sebster.tunnel.socket.ServerSocketSocketAcceptor.accept(ServerSocketSocketAcceptor.java:11)
  com.sebster.tunnel.impl.jd.run(jd.java:4)
  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.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
  java.util.concurrent.ScheduledThreadPoolExecutor$DelayedWorkQueue.take(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor.getTask(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor.runWorker(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:49)
  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:54)
  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:503)
  com.servoy.j2db.dataprocessing.ClientMessagePreQueueHandler.run(ClientMessagePreQueueHandler.java:12)
  java.lang.Thread.run(Unknown Source)

Thread: DestroyJavaVM, state: RUNNABLE, total cpu time: 609.375ms, total user time: 562.5ms

Thread: Wrapper-Connection, state: RUNNABLE, total cpu time: 46.875ms, total user time: 31.25ms
  java.net.SocketInputStream.socketRead0(Native Method)
  java.net.SocketInputStream.read(Unknown Source)
  java.net.SocketInputStream.read(Unknown Source)
  java.net.SocketInputStream.read(Unknown Source)
  java.io.DataInputStream.readByte(Unknown Source)
  org.tanukisoftware.wrapper.WrapperManager.handleSocket(WrapperManager.java:4203)
  org.tanukisoftware.wrapper.WrapperManager.run(WrapperManager.java:4558)
  java.lang.Thread.run(Unknown Source)

Thread: Wrapper-Control-Event-Monitor, state: TIMED_WAITING, total cpu time: 31.25ms, total user time: 15.625ms
  java.lang.Thread.sleep(Native Method)
  org.tanukisoftware.wrapper.WrapperManager$3.run(WrapperManager.java:816)

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: 15.625ms, total user time: 15.625ms
  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: 31.25ms, total user time: 31.25ms
  java.lang.Object.wait(Native Method)
  java.lang.Object.wait(Object.java:503)
  java.lang.ref.Reference$ReferenceHandler.run(Unknown Source)


From that, I can't determine where the problem may be. Any ideas"?

[jd2p]

I was able to import the solution twice. One time it took 49 minutes, and the second time it took 37 minutes. I noticed there was a difference in the amount of available RAM between both imports. First time, used RAM was over 11.2 out of 12 GB, second time Used RAM was around 10.5 out of 12 GB. So, I'm assuming this is a resources or tuning issue, I will run more tests after restarting the server to see how it behaves with more available RAM.

[ROCLASI]

Hi JD,

What Oracle driver version are you using?
You should use the driver that is compatible with the exact version of your database server.

[jcompagner]

what happens if you wait long enough before you start importing so that all tables are loaded.
This means that this piece that you see in the stack dump:

Thread: pool-1-thread-1, state: RUNNABLE, total cpu time: 1156.25ms, total user time: 1093.75ms
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(Unknown Source)
java.net.SocketInputStream.read(Unknown Source)
oracle.net.ns.Packet.receive(Packet.java:300)
oracle.net.ns.DataPacket.receive(DataPacket.java:106)
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:315)
oracle.net.ns.NetInputStream.read(NetInputStream.java:260)
oracle.net.ns.NetInputStream.read(NetInputStream.java:185)
oracle.net.ns.NetInputStream.read(NetInputStream.java:102)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838)
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803)
oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:4117)
org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
com.servoy.j2db.server.Za.Zo.Za(Zo.java:209)
com.servoy.j2db.server.Za.Zo.Zf(Zo.java:1237)
com.servoy.j2db.server.Za.Zo.Zd(Zo.java:1377)
com.servoy.j2db.server.Za.Zo.Zc(Zo.java:787)
com.servoy.j2db.server.Za.Zo.getTable(Zo.java:527)
com.servoy.j2db.server.main.Zs.run(Zs.java:8)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)

should be finished
it can be a little bit different name "Thread: pool-1-thread-1" like " Thread: pool-1-thread-2" or something like that
But the thread with this:

com.servoy.j2db.server.Za.Zo.getTable(Zo.java:527)
com.servoy.j2db.server.main.Zs.run(Zs.java:8)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

should be finished.

It seems to me that 2 connections of oracle are both loading in table information, maybe that is locking each other out..

[jd2p]

What Oracle driver version are you using?
You should use the driver that is compatible with the exact version of your database server.

I hadn't considered that, we are using the jdbc driver that corresponds to Oracle Database 11g Release 2 (11.2.0.3.0).. the database server installed version is 11.2.0.1.0... the same as in our testing environment. But we'll look into that. Thanks for the tip.

[jd2p]

It seems to me that 2 connections of oracle are both loading in table information, maybe that is locking each other out..

Hi Johan, Im pretty much lost understanding the stackdump. However, what do you suggest we should try out? We have tried right after starting the App Server and also once it has been running for a while. What do you mean by waiting until all tables are loaded?

Thanks in advance,

[jcompagner]

if you do it right after you start the app server you will get the above stack dump

But as i said if you see in the stack dump that you do this text:

com.servoy.j2db.server.Za.Zo.getTable(Zo.java:527)
com.servoy.j2db.server.main.Zs.run(Zs.java:8)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

Just don't import, that means that it is still busy loading in all the tables.

[jd2p]

Ok. Even if I do it after its been up for hours, I get the same problem.

[jcompagner]

what does the stackdump looks like then?
and also have a few stackdumps 2 minutes apart.

[siavash.roozbehan]

Hi guys,

I have a similar problem with importing solutions but the only difference is that I export a solution that is already working wiht postgreSQL and try to import in on another server that is connected to SQLExpress databases. I am doing the import procedure as part of our installer. I first create the databases I need in MS SQLExpress in the code (which works fine, and it shows I don't have any connection or persmission problems accessing that DBMS), then I try to programatically import the solution on the server, and that's where it gets stuck. (Btw, the whole procedure works fine if I want to import the solution to the server that is connected to postgres)

I also tried to import the solution manually in the admin page but same thing happens. I waited for more than 45 mins and it was still not done.

Can somebody please tell me what can be the problem and how can I solve this issue?