has anyone ran into this one before? mvn just kept on going so i
don't think its a breaking issue.
INFO: Updating Service **********
Jul 30, 2013 12:20:30 PM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 30000, SQLState: 40001
Jul 30, 2013 12:20:30 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: A lock could not be obtained due to a deadlock, cycle of locks
and waiters is:
Lock : ROW, J3_SERVICE_NAME, (2,30)
Waiting XID : {6877, S} , APP, select businessse0_.entity_key as
entity1_6_, businessse0_1_.authorized_name as authori
zed2_6_, businessse0_1_.created as created6_, businessse0_1_.modified
as modified6_, businessse0_1_.modified_including_c
hildren as modified5_6_, businessse0_1_.node_id as node6_6_,
businessse0_.business_key as business2_13_ from j3_business
_service businessse0_ inner join j3_uddi_entity businessse0_1_ on
businessse0_.entity_key=businessse0_1_.entity_key, j3_
service_name servicenam1_ where
businessse0_.entity_key=servicenam1_.entity_key and
(businessse0_.entity_key in (?)) ord
er by servicenam1_.name asc, businessse0_1_.modified desc
Granted XID : {6863, X}
Lock : ROW, J3_BUSINESS_SERVICE, (1,38)
Waiting XID : {6863, X} , APP, delete from j3_business_service where
entity_key=?
Granted XID : {6877, S}
. The selected victim is XID : 6877.
Jul 30, 2013 12:20:30 PM org.apache.juddi.subscription.SubscriptionNotifier run
SEVERE: Could not obtain subscriptionResult for subscriptionKey
uddi:uddi.joepublisher.com:subscriptiononesmtp. org.hibe
rnate.exception.LockAcquisitionException: could not execute query
javax.persistence.PersistenceException:
org.hibernate.exception.LockAcquisitionException: could not execute
query
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:630)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:75)
at
org.apache.juddi.query.EntityQuery.getPagedResult(EntityQuery.java:90)
at
org.apache.juddi.query.FetchBusinessServicesQuery.select(FetchBusinessServicesQuery.java:90)
at
org.apache.juddi.api.impl.InquiryHelper.getServiceListFromKeys(InquiryHelper.java:314)
at
org.apache.juddi.api.impl.UDDISubscriptionImpl.getSubscriptionResults(UDDISubscriptionImpl.java:353)
at
org.apache.juddi.subscription.SubscriptionNotifier.run(SubscriptionNotifier.java:158)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: org.hibernate.exception.LockAcquisitionException: could not
execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:82)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:66)
... 7 more
Caused by: java.sql.SQLTransactionRollbackException: A lock could not
be obtained due to a deadlock, cycle of locks and
waiters is:
Lock : ROW, J3_SERVICE_NAME, (2,30)
Waiting XID : {6877, S} , APP, select businessse0_.entity_key as
entity1_6_, businessse0_1_.authorized_name as authori
zed2_6_, businessse0_1_.created as created6_, businessse0_1_.modified
as modified6_, businessse0_1_.modified_including_c
hildren as modified5_6_, businessse0_1_.node_id as node6_6_,
businessse0_.business_key as business2_13_ from j3_business
_service businessse0_ inner join j3_uddi_entity businessse0_1_ on
businessse0_.entity_key=businessse0_1_.entity_key, j3_
service_name servicenam1_ where
businessse0_.entity_key=servicenam1_.entity_key and
(businessse0_.entity_key in (?)) ord
er by servicenam1_.name asc, businessse0_1_.modified desc
Granted XID : {6863, X}
Lock : ROW, J3_BUSINESS_SERVICE, (1,38)
Waiting XID : {6863, X} , APP, delete from j3_business_service where
entity_key=?
Granted XID : {6877, S}
. The selected victim is XID : 6877.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown
Source)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 15 more
Caused by: java.sql.SQLException: A lock could not be obtained due to
a deadlock, cycle of locks and waiters is:
Lock : ROW, J3_SERVICE_NAME, (2,30)
Waiting XID : {6877, S} , APP, select businessse0_.entity_key as
entity1_6_, businessse0_1_.authorized_name as authori
zed2_6_, businessse0_1_.created as created6_, businessse0_1_.modified
as modified6_, businessse0_1_.modified_including_c
hildren as modified5_6_, businessse0_1_.node_id as node6_6_,
businessse0_.business_key as business2_13_ from j3_business
_service businessse0_ inner join j3_uddi_entity businessse0_1_ on
businessse0_.entity_key=businessse0_1_.entity_key, j3_
service_name servicenam1_ where
businessse0_.entity_key=servicenam1_.entity_key and
(businessse0_.entity_key in (?)) ord
er by servicenam1_.name asc, businessse0_1_.modified desc
Granted XID : {6863, X}
Lock : ROW, J3_BUSINESS_SERVICE, (1,38)
Waiting XID : {6863, X} , APP, delete from j3_business_service where
entity_key=?
Granted XID : {6877, S}
. The selected victim is XID : 6877.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 29 more
Caused by: ERROR 40001: A lock could not be obtained due to a
deadlock, cycle of locks and waiters is:
Lock : ROW, J3_SERVICE_NAME, (2,30)
Waiting XID : {6877, S} , APP, select businessse0_.entity_key as
entity1_6_, businessse0_1_.authorized_name as authori
zed2_6_, businessse0_1_.created as created6_, businessse0_1_.modified
as modified6_, businessse0_1_.modified_including_c
hildren as modified5_6_, businessse0_1_.node_id as node6_6_,
businessse0_.business_key as business2_13_ from j3_business
_service businessse0_ inner join j3_uddi_entity businessse0_1_ on
businessse0_.entity_key=businessse0_1_.entity_key, j3_
service_name servicenam1_ where
businessse0_.entity_key=servicenam1_.entity_key and
(businessse0_.entity_key in (?)) ord
er by servicenam1_.name asc, businessse0_1_.modified desc
Granted XID : {6863, X}
Lock : ROW, J3_BUSINESS_SERVICE, (1,38)
Waiting XID : {6863, X} , APP, delete from j3_business_service where
entity_key=?
Granted XID : {6877, S}
. The selected victim is XID : 6877.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown
Source)
at
org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown
Source)
at
org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(Unknown
Source)
at
org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(Unknown
Source)
at
org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.SortResultSet.getRowFromResultSet(Unknown
Source)
at
org.apache.derby.impl.sql.execute.SortResultSet.getNextRowFromRS(Unknown
Source)
at org.apache.derby.impl.sql.execute.SortResultSet.loadSorter(Unknown
Source)
at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown
Source)
at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
... 23 more
.........Jul 30, 2013 12:20:35 PM
org.apache.juddi.subscription.notify.SMTPNotifier getEMailProperties
INFO:
Path=C:\juddi\trunkcur\juddi-core/uddi-tck/target/juddi-tomcat-3.2.0-SNAPSHOT/temp/
.Jul 30, 2013 12:20:35 PM
org.apache.juddi.subscription.SubscriptionNotifier notify
INFO: Sending out notification to mailto:[email protected]
Jul 30, 2013 12:20:35 PM
org.apache.juddi.subscription.notify.SMTPNotifier
notifySubscriptionListener
INFO: Sending notification email to [email protected]
.Jul 30, 2013 12:20:36 PM
org.apache.juddi.api.impl.API_090_SubscriptionListenerIntegrationTest
joePublisherUpdateServic
e_SMTP
INFO: Received Email Notification
Subject:UDDI Subscription Notification for subscription
Body:<ns4:notify_subscriptionListener xmlns=3D"urn:uddi-org:api_v3"
xmlns:ns2=3D="urn:uddi-org:sub_v3" xmlns:ns3=3D"http
://www.w3.org/2000/09/xmldsig#"
xmln=s:ns4=3D"urn:uddi-org:subr_v3"><authInfo>authtoken:4e799431-d848-4808-a4a5-=45763a9
728ea</authInfo><ns2:subscriptionResultsList><ns2:coveragePeriod><ns=2:startPoint>2013-07-30T12:20:09.501-04:00</ns2:sta
