[dna-issues] [JBoss JIRA] Resolved: (DNA-616) JPA connector pooling doesn't appear to shutdown

JPA connector pooling doesn't appear to shutdown ------------------------------------------------ Key: DNA-616 URL: https://jira.jboss.org/jira/browse/DNA-616 Project: DNA Issue Type: Bug Components: Connectors Affects Versions: 0.7 Reporter: Randall Hauch Assignee: Randall Hauch Priority: Blocker Fix For: 0.7 Attachments: DNA-616_fix.patch Our integration tests now appear to be running forever in what appears to be an infinite loop. The unit tests in 'docs/examples/gettingstarted/repositories' module appear to run forever, with the log ending with the snippet below (which goes on forever). Note that the example is running with DEBUG (which also needs to be changed). 02:16:42,310 DEBUG org.jboss.dna.connector.store.jpa.model.simple.NodeEntity{referentialIntegrityEnforced=false, childName=Learjet 45, childNamespace=org.jboss.dna.connector.store.jpa.model.common.NamespaceEntity#1, compressed=null, id=5, allowsSameNameChildren=false, largeValues=<uninitialized>, propertyCount=11, data=2c6d8085f7848080808af480a7fbe8f4f4f0baafaff7f7f7aeeae3f0aeeff2e7afeae3f2afb1aeb0fdf0f2e9ede1f2f9d4f9f0e5f 7868080808180cef480b8fbe8f4f4f0baafaff7f7f7aeeae2eff3f3aeeff2e7afe4eee1afe5f8e1edf0ece5f3afe1e9f2e3f2e1e6f4afb 1aeb0fdc1e9f2e3f2e1e6f4f4808ae9eef4f2efe4f5e3e5e4f7868080808180d3f48084b1b9b9b5f48084e3f2e5f7f7868080808 180d3f48081b2f48085ede1ebe5f2f7868080808180d3f48087cce5e1f2eae5f4f48085edefe4e5ecf7868080808180d3f4808 4cccab4b5f4808be3f2f5e9f3e5d3f0e5e5e4f7868080808180d3f48085b4b5b7ebf4f48083f5f2ecf7868080808180d3f480a7 e8f4f4f0baafafe5eeaef7e9ebe9f0e5e4e9e1aeeff2e7aff7e9ebe9afcce5e1f2eae5f4dfb4b5f48085f2e1eee7e5f7868080808 180d3f48086b2b1b2b0eeedf4808beef5ede2e5f2c2f5e9ecf4f7868080808180d3f48084b2b6b4abf4808be5edf0f4f9d7e5 e9e7e8f4f7868080808180d3f48087b1b3b6b9b5ece2, sameNameSiblingIndex=1, indexInParent=1, nodeUuidString=6ae6cf0c-88b8-4cb9-af63-195a6a351378, children=<uninitialized>, parent=org.jboss.dna.connector.store.jpa.model.simple.NodeEntity#3, workspaceId=1} 02:16:42,310 DEBUG more...... 02:16:42,310 DEBUG about to open PreparedStatement (open PreparedStatements: 0, globally: 0) 02:16:42,310 DEBUG delete from DNA_SUBGRAPH_NODES where QUERY_ID=? 02:16:42,311 DEBUG cxnStmtMgr.statementSet( org.hsqldb.jdbc.jdbcConnection@588a137c ).size(): 15 02:16:42,311 DEBUG checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 15; checked out: 1; num connections: 1; num keys: 15 02:16:42,311 DEBUG about to close PreparedStatement (open PreparedStatements: 1, globally: 1) 02:16:42,312 DEBUG checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 15; checked out: 0; num connections: 1; num keys: 15 02:19:41,831 DEBUG Checking for expired resources - Fri Jan 01 02:19:41 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:19:41,831 DEBUG BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:19:41,831 DEBUG FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:19:41,831 DEBUG Refurbishing idle resources - Fri Jan 01 02:19:41 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:19:41,831 DEBUG trace com.mchange.v2.resourcepool.BasicResourcePool@427a39ea [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@2ac6fb1) 02:20:26,832 DEBUG Checking for expired resources - Fri Jan 01 02:20:26 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:20:26,832 DEBUG BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:20:26,832 DEBUG FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:21:11,835 DEBUG Checking for expired resources - Fri Jan 01 02:21:11 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:21:11,835 DEBUG BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:21:11,835 DEBUG FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:21:56,837 DEBUG Checking for expired resources - Fri Jan 01 02:21:56 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:21:56,837 DEBUG BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:21:56,837 DEBUG FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:22:41,834 DEBUG Refurbishing idle resources - Fri Jan 01 02:22:41 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:22:41,834 DEBUG trace com.mchange.v2.resourcepool.BasicResourcePool@427a39ea [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@2ac6fb1) 02:22:41,838 DEBUG Checking for expired resources - Fri Jan 01 02:22:41 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:22:41,838 DEBUG BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:22:41,838 DEBUG FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:23:26,840 DEBUG Checking for expired resources - Fri Jan 01 02:23:26 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:23:26,840 DEBUG BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:23:26,840 DEBUG FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:24:11,843 DEBUG Checking for expired resources - Fri Jan 01 02:24:11 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:24:11,843 DEBUG BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:24:11,843 DEBUG FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:24:56,845 DEBUG Checking for expired resources - Fri Jan 01 02:24:56 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:24:56,845 DEBUG BEGIN check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:24:56,845 DEBUG FINISHED check for expired resources. [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:25:41,837 DEBUG Refurbishing idle resources - Fri Jan 01 02:25:41 EST 2010 [com.mchange.v2.resourcepool.BasicResourcePool@427a39ea] 02:25:41,837 DEBUG trace com.mchange.v2.resourcepool.BasicResourcePool@427a39ea [managed: 1, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@2ac6fb1) and so on.