Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: kitchen hang; connection pool deadlock

  1. #1
    Join Date
    Jul 2015
    Posts
    16

    Question kitchen hang; connection pool deadlock

    On 6.0.1, ran into http://jira.pentaho.com/browse/PDI-14882
    On 6.1.0.1, kettle just hangs when ececuting via Kitchen. I used jstack to extract stack traces (attached)

    The stuck threads all look like this

    Code:
    2017-01-05 13:39:17
    Full thread dump Java HotSpot(TM) 64-Bit Server VM (25.112-b15 mixed mode):
    
    
    "init of testresult.0 (Thread-58)" #87 prio=5 os_prio=0 tid=0x0000000021ce3000 nid=0x3600 in Object.wait() [0x0000000029b4f000]
       java.lang.Thread.State: WAITING (on object monitor)
    	at java.lang.Object.wait(Native Method)
    	at java.lang.Object.wait(Unknown Source)
    	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1115)
    	- locked <0x00000000e94c6a98> (a org.apache.commons.pool.impl.GenericObjectPool$Latch)
    	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
    	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    	at org.pentaho.di.core.database.ConnectionPoolUtil.getConnection(ConnectionPoolUtil.java:101)
    	at org.pentaho.di.core.database.ConnectionPoolUtil.getConnection(ConnectionPoolUtil.java:87)
    	at org.pentaho.di.core.database.Database.normalConnect(Database.java:439)
    	at org.pentaho.di.core.database.Database.connect(Database.java:364)
    	- locked <0x00000000e94c45a0> (a org.pentaho.di.core.database.Database)
    	at org.pentaho.di.core.database.Database.connect(Database.java:335)
    	at org.pentaho.di.trans.steps.tableinput.TableInput.init(TableInput.java:330)
    	at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
    	at java.lang.Thread.run(Unknown Source)
    This is with the MSFT SQL JDBC server driver. Happens every time it's run. Any ideas?

    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2015
    Posts
    16

    Default

    Any takers? We're pretty desperate around here, we tried to buy support from Pentaho, but we just don't have the $50k+ in the budget. Any pointers on JDBC connection pooling would help as well.

  3. #3
    Join Date
    Aug 2011
    Posts
    360

    Default

    Well, seems it is waiting forever for a new connection from the pool...
    So how did you set your connections pool?

    Moreover, try once with no connection pooling, just to be sure the problem comes from the pool.

  4. #4
    Join Date
    Jul 2015
    Posts
    16

    Default

    I don't - it's disabled.

  5. #5
    Join Date
    Jul 2015
    Posts
    16

    Default

    I worked around the problem by enabling a connection pool. Looks like this regressed from 6.0 to 6.1.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.