[jira] [Updated] (SCB-971) Saga TCC Demo

2018-10-22 Thread Minzhi Yan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/SCB-971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Minzhi Yan updated SCB-971:
---
Attachment: 截图.PNG

> Saga TCC Demo 
> --
>
> Key: SCB-971
> URL: https://issues.apache.org/jira/browse/SCB-971
> Project: Apache ServiceComb
>  Issue Type: Bug
>  Components: Saga
>Affects Versions: saga-0.3.0
>Reporter: Minzhi Yan
>Priority: Major
> Attachments: 截图.PNG
>
>
> When I run the tcc demo and curl -X POST 
> http://${host_address}:8083/ordering/order/UserC/ProductA/2/2, saga works 
> well.
> But one hour later, I invoke the service  with "curl -X POST 
> http://${host_address}:8083/ordering/order/UserC/ProductA/2/2; again, it 
> returns "\{"timestamp":1540188973814,"status":500,"error":"Internal Server 
> Error","exception":"org.springframework.web.client.HttpServerErrorException","message":"500
>  null","path":"/ordering/order/UserC/ProductA/2/2"}", and the command " curl 
> -X http://${host_address}:8082/orderings; returns 
> [\{"userName":"UserC","productName":"ProductA","units":2,"confirmed":false,"cancelled":true},\{"userName":"UserC","productName":"ProductA","units":2,"confirmed":false,"cancelled":false}]
>  ,both "confirmed" and "cancelled" are marked as false.
> The stack trace is here.
> {code}
> Caused by: javax.persistence.RollbackException: Exception [EclipseLink-4002] 
> (Eclipse Persistence Services - 2.7.1.v20171221-bd47e8f): 
> org.eclipse.persistence.exceptions.DatabaseException
> alpha_1  | Internal Exception: org.postgresql.util.PSQLException: The 
> connection attempt failed.
> alpha_1  | Error Code: 0
> alpha_1  | Query: InsertObjectQuery(GlobalTxEvent{surrogateId=null, 
> globalTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', 
> localTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', parentTxId='', 
> serviceName='ordering', instanceId='ordering-172.21.0.6', txType='ENDED', 
> status='Failed', creationTime=Mon Oct 22 06:16:13 GMT 2018, lastModified=Mon 
> Oct 22 06:16:13 GMT 2018})
> alpha_1  |at 
> org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:159)
>  ~[org.eclipse.persistence.jpa-2.7.1.jar!/:?]
> alpha_1  |at 
> org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
>  ~[spring-orm-4.3.18.RELEASE.jar!/:4.3.18.RELEASE]
> alpha_1  |... 19 more
> alpha_1  | Caused by: 
> org.eclipse.persistence.exceptions.DatabaseException: 
> alpha_1  | Internal Exception: org.postgresql.util.PSQLException: The 
> connection attempt failed.
> alpha_1  | Error Code: 0
> alpha_1  | Query: InsertObjectQuery(GlobalTxEvent{surrogateId=null, 
> globalTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', 
> localTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', parentTxId='', 
> serviceName='ordering', instanceId='ordering-172.21.0.6', txType='ENDED', 
> status='Failed', creationTime=Mon Oct 22 06:16:13 GMT 2018, lastModified=Mon 
> Oct 22 06:16:13 GMT 2018})
> alpha_1  |at 
> org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:316)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
> org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:147)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
> org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
> org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:313)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
> org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1660)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
> org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
> org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
> org.eclipse.persistence.sessions.server.ClientSession.retryTransaction(ClientSession.java:786)
>  ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
> alpha_1  |at 
>

[jira] [Updated] (SCB-971) Saga TCC Demo

2018-10-22 Thread Willem Jiang (JIRA) 


 [ 
https://issues.apache.org/jira/browse/SCB-971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Willem Jiang updated SCB-971:
-
Description: 
When I run the tcc demo and curl -X POST 
http://${host_address}:8083/ordering/order/UserC/ProductA/2/2, saga works well.

But one hour later, I invoke the service  with "curl -X POST 
http://${host_address}:8083/ordering/order/UserC/ProductA/2/2; again, it 
returns "\{"timestamp":1540188973814,"status":500,"error":"Internal Server 
Error","exception":"org.springframework.web.client.HttpServerErrorException","message":"500
 null","path":"/ordering/order/UserC/ProductA/2/2"}", and the command " curl -X 
http://${host_address}:8082/orderings; returns 
[\{"userName":"UserC","productName":"ProductA","units":2,"confirmed":false,"cancelled":true},\{"userName":"UserC","productName":"ProductA","units":2,"confirmed":false,"cancelled":false}]
 ,both "confirmed" and "cancelled" are marked as false.

The stack trace is here.
{code}
Caused by: javax.persistence.RollbackException: Exception [EclipseLink-4002] 
(Eclipse Persistence Services - 2.7.1.v20171221-bd47e8f): 
org.eclipse.persistence.exceptions.DatabaseException
alpha_1  | Internal Exception: org.postgresql.util.PSQLException: The 
connection attempt failed.
alpha_1  | Error Code: 0
alpha_1  | Query: InsertObjectQuery(GlobalTxEvent{surrogateId=null, 
globalTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', 
localTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', parentTxId='', 
serviceName='ordering', instanceId='ordering-172.21.0.6', txType='ENDED', 
status='Failed', creationTime=Mon Oct 22 06:16:13 GMT 2018, lastModified=Mon 
Oct 22 06:16:13 GMT 2018})
alpha_1  |  at 
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:159)
 ~[org.eclipse.persistence.jpa-2.7.1.jar!/:?]
alpha_1  |  at 
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
 ~[spring-orm-4.3.18.RELEASE.jar!/:4.3.18.RELEASE]
alpha_1  |  ... 19 more
alpha_1  | Caused by: org.eclipse.persistence.exceptions.DatabaseException: 
alpha_1  | Internal Exception: org.postgresql.util.PSQLException: The 
connection attempt failed.
alpha_1  | Error Code: 0
alpha_1  | Query: InsertObjectQuery(GlobalTxEvent{surrogateId=null, 
globalTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', 
localTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', parentTxId='', 
serviceName='ordering', instanceId='ordering-172.21.0.6', txType='ENDED', 
status='Failed', creationTime=Mon Oct 22 06:16:13 GMT 2018, lastModified=Mon 
Oct 22 06:16:13 GMT 2018})
alpha_1  |  at 
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:316)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:147) 
~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:313)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1660)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.server.ClientSession.retryTransaction(ClientSession.java:786)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:747)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:755)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:268)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:280)

[jira] [Updated] (SCB-971) Saga TCC Demo

2018-10-22 Thread Willem Jiang (JIRA) 


 [ 
https://issues.apache.org/jira/browse/SCB-971?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Willem Jiang updated SCB-971:
-
Environment: (was: Caused by: javax.persistence.RollbackException: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 
2.7.1.v20171221-bd47e8f): org.eclipse.persistence.exceptions.DatabaseException
alpha_1  | Internal Exception: org.postgresql.util.PSQLException: The 
connection attempt failed.
alpha_1  | Error Code: 0
alpha_1  | Query: InsertObjectQuery(GlobalTxEvent{surrogateId=null, 
globalTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', 
localTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', parentTxId='', 
serviceName='ordering', instanceId='ordering-172.21.0.6', txType='ENDED', 
status='Failed', creationTime=Mon Oct 22 06:16:13 GMT 2018, lastModified=Mon 
Oct 22 06:16:13 GMT 2018})
alpha_1  |  at 
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:159)
 ~[org.eclipse.persistence.jpa-2.7.1.jar!/:?]
alpha_1  |  at 
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
 ~[spring-orm-4.3.18.RELEASE.jar!/:4.3.18.RELEASE]
alpha_1  |  ... 19 more
alpha_1  | Caused by: org.eclipse.persistence.exceptions.DatabaseException: 
alpha_1  | Internal Exception: org.postgresql.util.PSQLException: The 
connection attempt failed.
alpha_1  | Error Code: 0
alpha_1  | Query: InsertObjectQuery(GlobalTxEvent{surrogateId=null, 
globalTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', 
localTxId='6ce54fa3-0cb5-403f-badf-81134d290a17', parentTxId='', 
serviceName='ordering', instanceId='ordering-172.21.0.6', txType='ENDED', 
status='Failed', creationTime=Mon Oct 22 06:16:13 GMT 2018, lastModified=Mon 
Oct 22 06:16:13 GMT 2018})
alpha_1  |  at 
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:316)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:147) 
~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:346)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:313)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:581)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1660)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:321)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.beginTransaction(DatasourceAccessor.java:254)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.server.ClientSession.retryTransaction(ClientSession.java:786)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.sessions.AbstractSession.basicBeginTransaction(AbstractSession.java:747)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.server.ClientSession.addWriteConnection(ClientSession.java:755)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.server.ServerSession.acquireClientConnection(ServerSession.java:268)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:280)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:270)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:256)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:405)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at 
org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165)
 ~[org.eclipse.persistence.core-2.7.1.jar!/:?]
alpha_1  |  at