vtanas opened a new issue, #5698:
URL: https://github.com/apache/hop/issues/5698
### Apache Hop version?
2.11.0
### Java version?
OpenJDK 64-Bit Server VM Temurin-17.0.15+6
### Operating system
Linux
### What happened?
Simple data load/transform job hangs on java wait, not stable issue.
Job is simple
1job sql TableInput, read from Oracle db (Oracle 11g, lib/core/ojdbc6.jar,
Implementation-Version: 11.2.0.3.0
Repository-Id: JAVAVM_11.2.0.4.0_LINUX.X64_130711)
2job TableOutput, insert/load to Vertica DB
it is visible from stacktrace parallel init of all steps after java start
elapsed=51299.33s nid=0xf350
elapsed=51299.30s nid=0xf351
strange that 2nd job, that should use only Vertica connection/driver, also
pending on connection pool/factory/init and pending on Oracke JDBC class init.
issue frequency: 1 time per ~20 job starts, java process hangs, for resolve
have to kill resolve process.
`
"main" #1 prio=5 os_prio=0 cpu=4106.74ms elapsed=51315.31s
tid=0x000078d05002dd90 nid=0xf097 in Object.wait() [0x000078d0566e5000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait([email protected]/Native Method)
- waiting on <0x0000000085d32c00> (a java.lang.Thread)
at java.lang.Thread.join([email protected]/Thread.java:1313)
....
"init of Get ORDERS.0 (Thread-4)" #19 prio=5 os_prio=0 cpu=28.08ms
elapsed=51299.33s tid=0x000078cf7792f530 nid=0xf350 in Object.wait()
[0x000078d0256f5000]
java.lang.Thread.State: RUNNABLE
at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:189)
- waiting on the Class initialization monitor for
oracle.jdbc.OracleDriver
at java.lang.Class.forName0([email protected]/Native Method)
at java.lang.Class.forName([email protected]/Class.java:375)
at
org.apache.hop.core.database.Database.connectUsingClass(Database.java:422)
- locked <0x0000000081c5b110> (a java.lang.Class for
java.sql.DriverManager)
at
org.apache.hop.core.database.Database.normalConnect(Database.java:368)
at org.apache.hop.core.database.Database.connect(Database.java:314)
at
org.apache.hop.pipeline.transforms.tableinput.TableInput.init(TableInput.java:332)
at
org.apache.hop.pipeline.transform.TransformInitThread.run(TransformInitThread.java:66)
at java.lang.Thread.run([email protected]/Thread.java:840)
"init of Fill ORDERS.0 (Thread-5)" #20 prio=5 os_prio=0 cpu=19.50ms
elapsed=51299.30s tid=0x000078cf77930120 nid=0xf351 in Object.wait()
[0x000078d0255f4000]
java.lang.Thread.State: RUNNABLE
at
jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0([email protected]/Native
Method)
- waiting on the Class initialization monitor for
oracle.jdbc.driver.OracleDriver
at
jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance([email protected]/NativeConstructorAccessorImpl.java:77)
at
jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance([email protected]/DelegatingConstructorAccessorImpl.java:45)
at
java.lang.reflect.Constructor.newInstanceWithCaller([email protected]/Constructor.java:500)
at
java.lang.reflect.Constructor.newInstance([email protected]/Constructor.java:481)
at
java.util.ServiceLoader$ProviderImpl.newInstance([email protected]/ServiceLoader.java:789)
at
java.util.ServiceLoader$ProviderImpl.get([email protected]/ServiceLoader.java:729)
at
java.util.ServiceLoader$3.next([email protected]/ServiceLoader.java:1403)
at
java.sql.DriverManager$2.run([email protected]/DriverManager.java:618)
at
java.sql.DriverManager$2.run([email protected]/DriverManager.java:598)
at
java.security.AccessController.executePrivileged([email protected]/AccessController.java:776)
at
java.security.AccessController.doPrivileged([email protected]/AccessController.java:318)
at
java.sql.DriverManager.ensureDriversInitialized([email protected]/DriverManager.java:598)
- locked <0x0000000081c5b248> (a java.lang.Object)
at
java.sql.DriverManager.getConnection([email protected]/DriverManager.java:669)
at
java.sql.DriverManager.getConnection([email protected]/DriverManager.java:190)
at
org.apache.hop.core.database.Database.connectUsingClass(Database.java:462)
at
org.apache.hop.core.database.Database.normalConnect(Database.java:368)
at org.apache.hop.core.database.Database.connect(Database.java:314)
at
org.apache.hop.pipeline.transforms.tableoutput.TableOutput.init(TableOutput.java:520)
at
org.apache.hop.pipeline.transform.TransformInitThread.run(TransformInitThread.java:66)
at java.lang.Thread.run([email protected]/Thread.java:840)
`
### Issue Priority
Priority: 3
### Issue Component
Component: Hop Run
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
