Solution never finishes importing

jd2p · January 24, 2013, 5:58pm

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 · January 24, 2013, 11:12pm

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

Peter_de_Groot · January 25, 2013, 7:07am

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 · January 25, 2013, 2:23pm

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 · January 25, 2013, 5:53pm

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

jd2p · January 28, 2013, 6:02pm

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:

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 · January 28, 2013, 10:20pm

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 · January 29, 2013, 8:42am

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 · January 29, 2013, 1:31pm

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 · January 29, 2013, 8:05pm

ROCLASI:
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 · January 29, 2013, 8:10pm

jcompagner:
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 · January 30, 2013, 9:28am

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 · January 30, 2013, 3:20pm

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

jcompagner · January 30, 2013, 6:52pm

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

siavash.roozbehan · April 30, 2013, 3:59am

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?

Andrei_Costescu · April 30, 2013, 9:11am

Do you (siavash/jd)

have by any chance multiple post-import hooks or multiple pre-import hooks in the .servoy file?
have import hooks at all? If you do, what do those hooks do?

Anyway, I think you should create cases for these problems - and attach the stack dumps (see “Dump the current stack/systeminfo” link on application server admin - main page) taken after the import hangs - for further investigation.

siavash.roozbehan · May 1, 2013, 11:17pm

Hi Andrei,

I’m not sure what sort of hooks are you talking about but I don’t export the solution with any specific condition rather than including the sample data and exporting 1i8n data and when I import the solution I keep the standard options ticked and just tick a couple more (screenshot is included). But if, by hooks, you are talking about something else, maybe some functions, I would appreciate if you clarify it so that I can give you a better answer.

I have attached the screenshot of both my export and import settings as well if they help.

I will create a case and include the stack dump as well, so hopefully I can get my problem solved.

By the way, I tried the same procedure with mysql as well and I get the same result (takes 45 minutes to import the solution). all the tables will get created after 45 minutes but none of the sample data are copied to the tables!

Here is the stack dump:

Current time: Thu May 02 09:18:20 EST 2013

Server Information
Servoy version 7.0.0 -build 2008
Port used by RMI Registry: 1199
Repository version 43

Current time: Thu May 02 09:18:20 EST 2013

Uptime:  21 hours 54 minutes 28 seconds

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

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

System Information
Heap Space Memory: allocated=261188K, used=76853K, max=1267072K
Non-Heap Space Memory: allocated=65152K, used=64863K, max=163840K
Number of Processors: 4

Thread: http-2013-6, state: WAITING, total cpu time: 15.6001ms, total user time: 0.0ms
  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: pool-1-thread-4, 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.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: pool-2-thread-2, state: WAITING, total cpu time: 31.2002ms, total user time: 31.2002ms
  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.runWorker(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: SocketAccepter1-thread-4, state: WAITING, total cpu time: 15.6001ms, total user time: 15.6001ms
  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.runWorker(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: SocketAccepter1-thread-3, 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)
  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: RMI Scheduler(0), 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.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: SocketAccepter1-thread-2, 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)
  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: SocketAccepter1-thread-1, state: WAITING, total cpu time: 62.4004ms, total user time: 46.8003ms
  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.runWorker(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: http-2013-5, state: RUNNABLE, total cpu time: 140.4009ms, total user time: 93.6006ms
  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:4867)
  com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:1749)
  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:103)
  org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
  org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
  org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
  org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
  org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  java.lang.Thread.run(Unknown Source)

Thread: http-2013-4, state: WAITING, total cpu time: 20436.131ms, total user time: 19952.5279ms
  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-2013-3, state: WAITING, total cpu time: 13712.4879ms, total user time: 13369.2857ms
  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-2013-2, state: WAITING, total cpu time: 21777.7396ms, total user time: 21138.1355ms
  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-2013-1, state: WAITING, total cpu time: 18922.9213ms, total user time: 18298.9173ms
  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: pool-1-thread-3, 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.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: http-2013-Acceptor-0, state: RUNNABLE, total cpu time: 15.6001ms, 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: 11559.6741ms, total user time: 1747.2112ms
  java.lang.Thread.sleep(Native Method)
  org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1631)
  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: Thread-2, state: TIMED_WAITING, total cpu time: 0.0ms, total user time: 0.0ms
  java.lang.Thread.sleep(Native Method)
  com.drmaison.plugin.jtapi.PhoneServer$2.run(PhoneServer.java:483)

Thread: AWT-Windows, state: RUNNABLE, total cpu time: 0.0ms, total user time: 0.0ms
  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: 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: 561.6036ms, total user time: 483.6031ms
  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.runWorker(Unknown Source)
  java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  java.lang.Thread.run(Unknown Source)

Thread: RMI TCP Accept-1199, 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:603)
  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: 15.6001ms, 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)
  sun.security.ssl.SSLServerSocketImpl.accept(Unknown Source)
  com.servoy.j2db.rmi.ServerTwoWaySocketFactory$TwoWayServerSocket.run(ServerTwoWaySocketFactory.java:621)
  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:26)
  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:27)
  java.lang.Thread.run(Unknown Source)

Thread: DestroyJavaVM, state: RUNNABLE, total cpu time: 639.6041ms, total user time: 546.0035ms

Thread: Wrapper-Connection, state: RUNNABLE, total cpu time: 46.8003ms, total user time: 31.2002ms
  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: 15.6001ms, total user time: 15.6001ms
  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: 218.4014ms, total user time: 202.8013ms
  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: 46.8003ms, total user time: 46.8003ms
  java.lang.Object.wait(Native Method)
  java.lang.Object.wait(Object.java:503)
  java.lang.ref.Reference$ReferenceHandler.run(Unknown Source)

Thanks,
Siavash

jcompagner · May 2, 2013, 8:25am

that stacktrace is of no use, you are not importing at that time, at least it is not doing anything at the moment of that stack dump

siavash.roozbehan · May 7, 2013, 12:31am

Well, I’ve got this stackdump right after the import was finished! I’m not sure when should get the stack dump to give you something that is of use?! :roll: I tried to import the solution twice after that time on SQLExpress and I get no luck importing the solution again (even after 45 minutes). Although when I try it with mysql, it will create the tables bur is not successful to put the data in it.

Do you think that it would be easier if we set our application to work with sqlexpress and then import the solution to servers that are using postgresql if it was needed for the customers or we would get the same problem in that case as well?

Andrei_Costescu · May 7, 2013, 7:52am

siavash.roozbehan:
(…)But if, by hooks, you are talking about something else, maybe some functions, I would appreciate if you clarify it so that I can give you a better answer.(…)

I was talking about modules(solutions) of “Post-import hook” or “Pre-import hook” type. If you didn’t know they existed then you probably don’t have any .
More info about import hooks here.

The stack dump needs to happen during import. Not after. So after you start an import and see that it’s taking too long or it’s not finishing, open a new browser window/tab and dump the stack.

Topic		Replies	Views
Solution Upload Classic Servoy	8	10096	July 18, 2019
servot server not accepting a new solution Classic Servoy	3	3242	April 20, 2011
Importing to Servoy 7.4.4 Classic Servoy	5	7453	October 26, 2016
problem with import solution Classic Servoy	12	7588	December 2, 2011
importing solutions issues in v.30 Classic Servoy	6	2847	July 5, 2006

Solution never finishes importing

Related topics