gistfile1.txt

where eKycStatus.targetType = ?1 and eKycStatus.targetCode = ?2 */ select ekycstatus0_.id as id1_12_, ekycstatus0_.active_from as active_f2_12_, ekycstatus0_.active_to as active_t3_12_, ekycstatus0_.created_at as created_4_12_, ekycstatus0_.deleted_at as deleted_5_12_, ekycstatus0_.last_updated_at as last_upd6_12_, ekycstatus0_.optlockver as optlockv7_12_, ekycstatus0_.namespace as namespac8_12_, ekycstatus0_.accountowner_id as account14_12_, ekycstatus0_.last_check_request_seq as last_che9_12_, ekycstatus0_.last_check_response_seq as last_ch10_12_, ekycstatus0_.status_code as status_11_12_, ekycstatus0_.target_code as target_12_12_, ekycstatus0_.target_type as target_13_12_ from kyc_status ekycstatus0_ where ekycstatus0_.target_type=? and ekycstatus0_.target_code=?
[DEBUG] 2020-07-07 21:12:17.452 [qtp706322686-577] SQL - /* insert com.payaut.fund.persistence.entity.EVirtualAccount */ insert into virtual_accounts (active_from, active_to, code, created_at, deleted_at, last_updated_at, optlockver, account_holder_code, account_type, display_name, division_code, ext_ref, external_account_code, merchant_code, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: /* insert com.payaut.fund.persistence.entity.EVirtualAccount */ insert into virtual_accounts (active_from, active_to, code, created_at, deleted_at, last_updated_at, optlockver, account_holder_code, account_type, display_name, division_code, ext_ref, external_account_code, merchant_code, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[DEBUG] 2020-07-07 21:12:17.456 [qtp706322686-589] SQL - /* update com.payaut.accountowner.persistence.entity.ELegalEntityIndividual */ update legalentities set active_from=?, active_to=?, deleted_at=?, last_updated_at=?, optlockver=?, address_addition=?, address_city=?, address_country_code=?, address_house_number=?, address_state_code=?, address_street=?, address_zipcode=?, email=?, kyc_status_id=?, legal_name=?, phone=?, tax_number=? where id=? and optlockver=?
Hibernate: /* update com.payaut.accountowner.persistence.entity.ELegalEntityIndividual */ update legalentities set active_from=?, active_to=?, deleted_at=?, last_updated_at=?, optlockver=?, address_addition=?, address_city=?, address_country_code=?, address_house_number=?, address_state_code=?, address_street=?, address_zipcode=?, email=?, kyc_status_id=?, legal_name=?, phone=?, tax_number=? where id=? and optlockver=?
[INFO ] 2020-07-07 21:12:17.462 [qtp706322686-580] AccountHolderServiceImpl - {"kycCheckRequest":{"readyForKyc":false,"targetEntities":[{"targetType":"PERSON","firstName":"Margarette","lastName":"Schmidt","nationality":"MLI","changeType":"ADD","changeSequence":1594149137462,"extRef":"AO:A:FD5CMG8JBWAdL8WfFfz1ZHgL7Jcq337nsfv","legalName":"Margarette Schmidt"}]}}
[DEBUG] 2020-07-07 21:12:17.462 [qtp706322686-580] PartitionAwareReplyingKafkaTemplate - Using partition 0
[DEBUG] 2020-07-07 21:12:17.462 [qtp706322686-580] PartitionAwareReplyingKafkaTemplate - Sending: ProducerRecord(topic=kyc-check-request-v1-request, partition=null, headers=RecordHeaders(headers = [RecordHeader(key = kafka_replyTopic, value = [107, 121, 99, 45, 99, 104, 101, 99, 107, 45, 114, 101, 113, 117, 101, 115, 116, 45, 118, 49, 45, 114, 101, 112, 108, 121]), RecordHeader(key = kafka_replyPartition, value = [0, 0, 0, 0]), RecordHeader(key = kafka_correlationId, value = [78, 124, -35, 17, -117, 64, 70, 1, -110, 118, -13, 106, -84, 25, 17, 66])], isReadOnly = false), key=null, value=RCheckDataChangeRequest(readyForKyc=false, checkProfileCode=null, targetEntities=[RPerson(organizationExtRef=null, socialSecurityNumber=null, firstName=Margarette, lastName=Schmidt, gender=Optional.empty, dateOfBirth=Optional.empty, placeOfBirth=null, nationality=Optional[MLI])], processedAmounts=null), timestamp=null) with correlationId: [104328112284179044686368899864540549442]
[DEBUG] 2020-07-07 21:12:17.463 [qtp706322686-580] SQL - /* update com.payaut.accountowner.persistence.entity.EKycStatus */ update kyc_status set active_from=?, active_to=?, deleted_at=?, last_updated_at=?, optlockver=?, accountowner_id=?, last_check_request_seq=?, last_check_response_seq=?, status_code=?, target_type=? where id=? and optlockver=?
Hibernate: /* update com.payaut.accountowner.persistence.entity.EKycStatus */ update kyc_status set active_from=?, active_to=?, deleted_at=?, last_updated_at=?, optlockver=?, accountowner_id=?, last_check_request_seq=?, last_check_response_seq=?, status_code=?, target_type=? where id=? and optlockver=?
[INFO ] 2020-07-07 21:12:17.468 [qtp706322686-600] AccountHolderServiceImpl - {"kycCheckRequest":{"readyForKyc":false,"targetEntities":[{"targetType":"PERSON","firstName":"Caleb","lastName":"Marvin","nationality":"GLP","changeType":"ADD","changeSequence":1594149137468,"extRef":"AO:A:FD5CMG8JBXF9ojDMxvoHq7hEr9y64kpzcr4","legalName":"Caleb Marvin"}]}}
[DEBUG] 2020-07-07 21:12:17.468 [qtp706322686-600] PartitionAwareReplyingKafkaTemplate - Using partition 0
[DEBUG] 2020-07-07 21:12:17.468 [qtp706322686-600] PartitionAwareReplyingKafkaTemplate - Sending: ProducerRecord(topic=kyc-check-request-v1-request, partition=null, headers=RecordHeaders(headers = [RecordHeader(key = kafka_replyTopic, value = [107, 121, 99, 45, 99, 104, 101, 99, 107, 45, 114, 101, 113, 117, 101, 115, 116, 45, 118, 49, 45, 114, 101, 112, 108, 121]), RecordHeader(key = kafka_replyPartition, value = [0, 0, 0, 0]), RecordHeader(key = kafka_correlationId, value = [-74, -6, 50, -80, -10, 29, 65, -60, -125, -15, -21, 50, 11, 64, -23, 48])], isReadOnly = false), key=null, value=RCheckDataChangeRequest(readyForKyc=false, checkProfileCode=null, targetEntities=[RPerson(organizationExtRef=null, socialSecurityNumber=null, firstName=Caleb, lastName=Marvin, gender=Optional.empty, dateOfBirth=Optional.empty, placeOfBirth=null, nationality=Optional[GLP])], processedAmounts=null), timestamp=null) with correlationId: [-97063769332644600749993909537241765584]
[DEBUG] 2020-07-07 21:12:17.469 [qtp706322686-600] SQL - /* update com.payaut.accountowner.persistence.entity.EKycStatus */ update kyc_status set active_from=?, active_to=?, deleted_at=?, last_updated_at=?, optlockver=?, accountowner_id=?, last_check_request_seq=?, last_check_response_seq=?, status_code=?, target_type=? where id=? and optlockver=?
Hibernate: /* update com.payaut.accountowner.persistence.entity.EKycStatus */ update kyc_status set active_from=?, active_to=?, deleted_at=?, last_updated_at=?, optlockver=?, accountowner_id=?, last_check_request_seq=?, last_check_response_seq=?, status_code=?, target_type=? where id=? and optlockver=?
[DEBUG] 2020-07-07 21:12:17.472 [qtp706322686-589] SQL - /* update com.payaut.accountowner.persistence.entity.ELegalEntityIndividual */ update legalentities_individual set birth_date=?, first_name=?, gender=?, last_name=?, nationality_country_code=?, birth_city=?, birth_country_code=?, birth_state_code=?, selfie_file_store_code=?, selfie_took_at=?, social_security_number=?, accountowner_id=? where id=?
Hibernate: /* update com.payaut.accountowner.persistence.entity.ELegalEntityIndividual */ update legalentities_individual set birth_date=?, first_name=?, gender=?, last_name=?, nationality_country_code=?, birth_city=?, birth_country_code=?, birth_state_code=?, selfie_file_store_code=?, selfie_took_at=?, social_security_number=?, accountowner_id=? where id=?
[DEBUG] 2020-07-07 21:12:17.485 [qtp706322686-600] SQL - /* select eKycStatus
from EKycStatus eKycStatus
where eKycStatus.accountOwner = ?1 and eKycStatus.deletedAt is null */ select ekycstatus0_.id as id1_12_, ekycstatus0_.active_from as active_f2_12_, ekycstatus0_.active_to as active_t3_12_, ekycstatus0_.created_at as created_4_12_, ekycstatus0_.deleted_at as deleted_5_12_, ekycstatus0_.last_updated_at as last_upd6_12_, ekycstatus0_.optlockver as optlockv7_12_, ekycstatus0_.namespace as namespac8_12_, ekycstatus0_.accountowner_id as account14_12_, ekycstatus0_.last_check_request_seq as last_che9_12_, ekycstatus0_.last_check_response_seq as last_ch10_12_, ekycstatus0_.status_code as status_11_12_, ekycstatus0_.target_code as target_12_12_, ekycstatus0_.target_type as target_13_12_ from kyc_status ekycstatus0_ where ekycstatus0_.accountowner_id=? and (ekycstatus0_.deleted_at is null)
Hibernate: /* select eKycStatus
from EKycStatus eKycStatus
where eKycStatus.accountOwner = ?1 and eKycStatus.deletedAt is null */ select ekycstatus0_.id as id1_12_, ekycstatus0_.active_from as active_f2_12_, ekycstatus0_.active_to as active_t3_12_, ekycstatus0_.created_at as created_4_12_, ekycstatus0_.deleted_at as deleted_5_12_, ekycstatus0_.last_updated_at as last_upd6_12_, ekycstatus0_.optlockver as optlockv7_12_, ekycstatus0_.namespace as namespac8_12_, ekycstatus0_.accountowner_id as account14_12_, ekycstatus0_.last_check_request_seq as last_che9_12_, ekycstatus0_.last_check_response_seq as last_ch10_12_, ekycstatus0_.status_code as status_11_12_, ekycstatus0_.target_code as target_12_12_, ekycstatus0_.target_type as target_13_12_ from kyc_status ekycstatus0_ where ekycstatus0_.accountowner_id=? and (ekycstatus0_.deleted_at is null)
[DEBUG] 2020-07-07 21:12:17.485 [qtp706322686-580] SQL - /* select eKycStatus
from EKycStatus eKycStatus
where eKycStatus.accountOwner = ?1 and eKycStatus.deletedAt is null */ select ekycstatus0_.id as id1_12_, ekycstatus0_.active_from as active_f2_12_, ekycstatus0_.active_to as active_t3_12_, ekycstatus0_.created_at as created_4_12_, ekycstatus0_.deleted_at as deleted_5_12_, ekycstatus0_.last_updated_at as last_upd6_12_, ekycstatus0_.optlockver as optlockv7_12_, ekycstatus0_.namespace as namespac8_12_, ekycstatus0_.accountowner_id as account14_12_, ekycstatus0_.last_check_request_seq as last_che9_12_, ekycstatus0_.last_check_response_seq as last_ch10_12_, ekycstatus0_.status_code as status_11_12_, ekycstatus0_.target_code as target_12_12_, ekycstatus0_.target_type as target_13_12_ from kyc_status ekycstatus0_ where ekycstatus0_.accountowner_id=? and (ekycstatus0_.deleted_at is null)
Hibernate: /* select eKycStatus
from EKycStatus eKycStatus
where eKycStatus.accountOwner = ?1 and eKycStatus.deletedAt is null */ select ekycstatus0_.id as id1_12_, ekycstatus0_.active_from as active_f2_12_, ekycstatus0_.active_to as active_t3_12_, ekycstatus0_.created_at as created_4_12_, ekycstatus0_.deleted_at as deleted_5_12_, ekycstatus0_.last_updated_at as last_upd6_12_, ekycstatus0_.optlockver as optlockv7_12_, ekycstatus0_.namespace as namespac8_12_, ekycstatus0_.accountowner_id as account14_12_, ekycstatus0_.last_check_request_seq as last_che9_12_, ekycstatus0_.last_check_response_seq as last_ch10_12_, ekycstatus0_.status_code as status_11_12_, ekycstatus0_.target_code as target_12_12_, ekycstatus0_.target_type as target_13_12_ from kyc_status ekycstatus0_ where ekycstatus0_.accountowner_id=? and (ekycstatus0_.deleted_at is null)
[DEBUG] 2020-07-07 21:12:17.501 [qtp706322686-580] AccountHolderEntityConverter - AccountHolder parent reference is EMerchantDivision FD5CMFSvPkLwjbeWsgEtjGStGjdvbJznYG8
[DEBUG] 2020-07-07 21:12:17.501 [qtp706322686-600] AccountHolderEntityConverter - AccountHolder parent reference is EMerchantDivision FD5CMFSvPkLwjbeWsgEtjGStGjdvbJznYG8
[DEBUG] 2020-07-07 21:12:17.501 [qtp706322686-580] AccountHolderEntityConverter - AccountHolder parent reference is DMerchantDivision LookupValue(value=287ef3c7-5690-41ae-8055-923dc7cb580b, parentRef=null, def=com.payaut.common.module.api.model.field.LookupFieldDef@363751f2)
[DEBUG] 2020-07-07 21:12:17.502 [qtp706322686-600] AccountHolderEntityConverter - AccountHolder parent reference is DMerchantDivision LookupValue(value=287ef3c7-5690-41ae-8055-923dc7cb580b, parentRef=null, def=com.payaut.common.module.api.model.field.LookupFieldDef@363751f2)
[INFO ] 2020-07-07 21:12:17.506 [qtp706322686-577] DefaultFundAccountService - Created virtualAccount relation: DVirtualAccount{id=7d19b0ee-cfea-406d-9a2a-cb03aa47e92d, merchantCode='FD5CMFSvPkLxpigEGnG7bvfxVjfk984WBqa', divisionCode='FD5CMFSvPkLwjbeWsgEtjGStGjdvbJznYG8', accountHolderCode='FD5CMG8JBW9CobnGh16fmdgrdK823t3i3nY', externalAccountCode='FD5CMG8JBXmyLQ3zv2ESvnwemGk1rsCMmGU', extRef='null', displayName='Default', code='FD5CMG8JBXmyLQ3zv2ESvnwemGk1rsCMmGU', accountType=DEFAULT}
[INFO ] 2020-07-07 21:12:17.506 [qtp706322686-577] AccountServiceImpl - Fund module returned: DVirtualAccount{id=7d19b0ee-cfea-406d-9a2a-cb03aa47e92d, merchantCode='FD5CMFSvPkLxpigEGnG7bvfxVjfk984WBqa', divisionCode='FD5CMFSvPkLwjbeWsgEtjGStGjdvbJznYG8', accountHolderCode='FD5CMG8JBW9CobnGh16fmdgrdK823t3i3nY', externalAccountCode='FD5CMG8JBXmyLQ3zv2ESvnwemGk1rsCMmGU', extRef='null', displayName='Default', code='FD5CMG8JBXmyLQ3zv2ESvnwemGk1rsCMmGU', accountType=DEFAULT}
[DEBUG] 2020-07-07 21:12:17.529 [qtp706322686-589] SQL - /* select eKycStatus
from EKycStatus eKycStatus
where eKycStatus.targetType = ?1 and eKycStatus.targetCode = ?2 */ select ekycstatus0_.id as id1_12_, ekycstatus0_.active_from as active_f2_12_, ekycstatus0_.active_to as active_t3_12_, ekycstatus0_.created_at as created_4_12_, ekycstatus0_.deleted_at as deleted_5_12_, ekycstatus0_.last_updated_at as last_upd6_12_, ekycstatus0_.optlockver as optlockv7_12_, ekycstatus0_.namespace as namespac8_12_, ekycstatus0_.accountowner_id as account14_12_, ekycstatus0_.last_check_request_seq as last_che9_12_, ekycstatus0_.last_check_response_seq as last_ch10_12_, ekycstatus0_.status_code as status_11_12_, ekycstatus0_.target_code as target_12_12_, ekycstatus0_.target_type as target_13_12_ from kyc_status ekycstatus0_ where ekycstatus0_.target_type=? and ekycstatus0_.target_code=?
Hibernate: /* select eKycStatus
from EKycStatus eKycStatus
where eKycStatus.targetType = ?1 and eKycStatus.targetCode = ?2 */ select ekycstatus0_.id as id1_12_, ekycstatus0_.active_from as active_f2_12_, ekycstatus0_.active_to as active_t3_12_, ekycstatus0_.created_at as created_4_12_, ekycstatus0_.deleted_at as deleted_5_12_, ekycstatus0_.last_updated_at as last_upd6_12_, ekycstatus0_.optlockver as optlockv7_12_, ekycstatus0_.namespace as namespac8_12_, ekycstatus0_.accountowner_id as account14_12_, ekycstatus0_.last_check_request_seq as last_che9_12_, ekycstatus0_.last_check_response_seq as last_ch10_12_, ekycstatus0_.status_code as status_11_12_, ekycstatus0_.target_code as target_12_12_, ekycstatus0_.target_type as target_13_12_ from kyc_status ekycstatus0_ where ekycstatus0_.target_type=? and ekycstatus0_.target_code=?
[DEBUG] 2020-07-07 21:12:17.532 [qtp706322686-577] HttpEntityMethodProcessor - Using 'application/json', given [application/json] and supported [application/json, application/*+json, application/json, application/*+json, application/xml;charset=UTF-8, text/xml;charset=UTF-8, application/*+xml;charset=UTF-8, application/xml;charset=UTF-8, text/xml;charset=UTF-8, application/*+xml;charset=UTF-8]
[DEBUG] 2020-07-07 21:12:17.533 [qtp706322686-577] HttpEntityMethodProcessor - Writing [RAccount(code=FD5CMG8JBXmyLQ3zv2ESvnwemGk1rsCMmGU, extRef=Optional.empty, accountType=DEFAULT, displ (truncated)...]
[DEBUG] 2020-07-07 21:12:17.533 [qtp706322686-577] DispatcherServlet - Completed 201 CREATED
[WARN ] 2020-07-07 21:12:17.541 [qtp706322686-621] ExecCtx - Correlation id is null. Continuing with null correlation ID
[DEBUG] 2020-07-07 21:12:17.542 [qtp706322686-621] DispatcherServlet - POST "/api/v1//merchants/FD5CMFSvPkLxpigEGnG7bvfxVjfk984WBqa/merchantdivisions/FD5CMFSvPkLwjbeWsgEtjGStGjdvbJznYG8/submerchants", parameters={}
[DEBUG] 2020-07-07 21:12:17.544 [qtp706322686-621] RequestMappingHandlerMapping - Mapped to com.payaut.accountowner.rest.v1.controller.AccountHolderControllerImpl#create(RWithLookup, Map, Map)
[DEBUG] 2020-07-07 21:12:17.545 [qtp706322686-621] RequestResponseBodyMethodProcessor - Read "application/json;charset=UTF-8" to [com.payaut.accountowner.ext.api.v1.model.RAccountHolder@669ad1ac]
[DEBUG] 2020-07-07 21:12:17.575 [qtp706322686-600] AutoRetryTransactionTemplate - Transaction execution heuristic exception found with state: 2
[DEBUG] 2020-07-07 21:12:17.575 [qtp706322686-600] AutoRetryTransactionTemplate - Transaction execution PSQL exception found [getSQLState: 40001 serverErrorMessage: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=e9d586cf key=/Table/129/1/"\x8e\xb1\xb6\xe4\xcf\xe2K3\xbf\xda\x05džY\x8c\xde"/0 pri=0.00042818 epo=0 ts=1594149137.122283800,1 min=1594149136.810050600,0 seq=22} lock=true stat=PENDING rts=1594149136.810050600,0 wto=false max=1594149136.810050600,0
[INFO ] 2020-07-07 21:12:17.575 [qtp706322686-589] AccountHolderServiceImpl - {"kycCheckRequest":{"readyForKyc":false,"targetEntities":[{"targetType":"PERSON","firstName":"Carolanne","lastName":"Goodwin","nationality":"TZA","changeType":"ADD","changeSequence":1594149137574,"extRef":"AO:A:FD5CMG8JBW7jPmXKWuKQ16ixKtXttRbuBYL","legalName":"Carolanne Goodwin"}]}}
[DEBUG] 2020-07-07 21:12:17.575 [qtp706322686-589] PartitionAwareReplyingKafkaTemplate - Using partition 0
[DEBUG] 2020-07-07 21:12:17.575 [qtp706322686-589] PartitionAwareReplyingKafkaTemplate - Sending: ProducerRecord(topic=kyc-check-request-v1-request, partition=null, headers=RecordHeaders(headers = [RecordHeader(key = kafka_replyTopic, value = [107, 121, 99, 45, 99, 104, 101, 99, 107, 45, 114, 101, 113, 117, 101, 115, 116, 45, 118, 49, 45, 114, 101, 112, 108, 121]), RecordHeader(key = kafka_replyPartition, value = [0, 0, 0, 0]), RecordHeader(key = kafka_correlationId, value = [-4, 119, 74, 109, 116, -88, 71, -80, -108, -29, 47, -91, -18, 118, 110, 52])], isReadOnly = false), key=null, value=RCheckDataChangeRequest(readyForKyc=false, checkProfileCode=null, targetEntities=[RPerson(organizationExtRef=null, socialSecurityNumber=null, firstName=Carolanne, lastName=Goodwin, gender=Optional.empty, dateOfBirth=Optional.empty, placeOfBirth=null, nationality=Optional[TZA])], processedAmounts=null), timestamp=null) with correlationId: [-4697519086689935503048931866898436556]
[DEBUG] 2020-07-07 21:12:17.578 [qtp706322686-589] SQL - /* update com.payaut.accountowner.persistence.entity.EKycStatus */ update kyc_status set active_from=?, active_to=?, deleted_at=?, last_updated_at=?, optlockver=?, accountowner_id=?, last_check_request_seq=?, last_check_response_seq=?, status_code=?, target_type=? where id=? and optlockver=?
Hibernate: /* update com.payaut.accountowner.persistence.entity.EKycStatus */ update kyc_status set active_from=?, active_to=?, deleted_at=?, last_updated_at=?, optlockver=?, accountowner_id=?, last_check_request_seq=?, last_check_response_seq=?, status_code=?, target_type=? where id=? and optlockver=?
[DEBUG] 2020-07-07 21:12:17.575 [qtp706322686-600] AutoRetryTransactionTemplate - Retrying transaction (iteration: 1)
org.springframework.transaction.HeuristicCompletionException: Heuristic completion: outcome state is rolled back; nested exception is org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection
	at org.springframework.data.transaction.ChainedTransactionManager.commit(ChainedTransactionManager.java:177) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:152) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at com.payaut.common.persistence.util.AutoRetryTransactionTemplate.execute(AutoRetryTransactionTemplate.java:47) ~[classes/:?]
	at com.payaut.accountowner.module.service.TransactionalAccountOwnerService.execWrite(TransactionalAccountOwnerService.kt:126) ~[classes/:?]
	at com.payaut.common.persistence.service.AbstractCrudService.create(AbstractCrudService.kt:138) ~[classes/:?]
	at com.payaut.common.persistence.service.AbstractCrudService$$FastClassBySpringCGLIB$$fd321e53.invoke(<generated>) ~[classes/:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at com.payaut.accountowner.module.service.AccountHolderServiceImpl$$EnhancerBySpringCGLIB$$68513a02.create(<generated>) ~[classes/:?]
	at com.payaut.common.rest.v1.controller.AbstractStandardController.create(AbstractStandardController.kt:148) ~[classes/:?]
	at com.payaut.common.rest.v1.controller.AbstractStandardController$$FastClassBySpringCGLIB$$75d234ba.invoke(<generated>) ~[classes/:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:119) ~[spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at com.payaut.accountowner.rest.v1.controller.AccountHolderControllerImpl$$EnhancerBySpringCGLIB$$423e86f4.create(<generated>) ~[classes/:?]
	at jdk.internal.reflect.GeneratedMethodAccessor339.invoke(Unknown Source) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:567) ~[?:?]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:523) ~[jakarta.servlet-api-4.0.3.jar:4.0.3]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:590) ~[jakarta.servlet-api-4.0.3.jar:4.0.3]
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1631) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226) ~[websocket-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at com.payaut.common.rest.filter.ExecCtxServletFilter.doFilter(ExecCtxServletFilter.kt:80) ~[classes/:?]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at com.payaut.common.rest.filter.ProductionHttpHeaderFilter.doFilter(ProductionHttpHeaderFilter.kt:24) ~[classes/:?]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) ~[spring-boot-actuator-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at com.payaut.common.rest.filter.ExceptionHandlerFilter.doFilter(ExceptionHandlerFilter.java:62) ~[classes/:?]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[jetty-security-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1610) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1369) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:489) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1580) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1284) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.Server.handle(Server.java:501) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) [jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) [jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) [jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [jetty-io-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at java.lang.Thread.run(Thread.java:835) [?:?]
Caused by: org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:353) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at com.payaut.common.persistence.util.JpaDialectWrapper.translateExceptionIfPossible(JpaDialectWrapper.java:39) ~[classes/:?]
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:538) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.data.transaction.MultiTransactionStatus.commit(MultiTransactionStatus.java:74) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.data.transaction.ChainedTransactionManager.commit(ChainedTransactionManager.java:150) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	... 88 more
Caused by: org.hibernate.TransactionException: Unable to commit against JDBC Connection
	at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:92) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:282) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:534) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.data.transaction.MultiTransactionStatus.commit(MultiTransactionStatus.java:74) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.data.transaction.ChainedTransactionManager.commit(ChainedTransactionManager.java:150) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	... 88 more
Caused by: org.postgresql.util.PSQLException: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=e9d586cf key=/Table/129/1/"\x8e\xb1\xb6\xe4\xcf\xe2K3\xbf\xda\x05džY\x8c\xde"/0 pri=0.00042818 epo=0 ts=1594149137.122283800,1 min=1594149136.810050600,0 seq=22} lock=true stat=PENDING rts=1594149136.810050600,0 wto=false max=1594149136.810050600,0
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532) ~[postgresql-42.2.14.jar:42.2.14]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267) ~[postgresql-42.2.14.jar:42.2.14]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312) ~[postgresql-42.2.14.jar:42.2.14]
	at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:837) ~[postgresql-42.2.14.jar:42.2.14]
	at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:859) ~[postgresql-42.2.14.jar:42.2.14]
	at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:387) ~[HikariCP-3.4.5.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java) ~[HikariCP-3.4.5.jar:?]
	at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:86) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:282) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:534) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.data.transaction.MultiTransactionStatus.commit(MultiTransactionStatus.java:74) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.data.transaction.ChainedTransactionManager.commit(ChainedTransactionManager.java:150) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	... 88 more
[DEBUG] 2020-07-07 21:12:17.581 [qtp706322686-600] SQL - /* select eMerchantDivision
from EMerchantDivision eMerchantDivision
where eMerchantDivision.deletedAt is null and eMerchantDivision.code = ?1 */ select emerchantd0_.id as id1_1_, emerchantd0_1_.active_from as active_f2_1_, emerchantd0_1_.active_to as active_t3_1_, emerchantd0_1_.created_at as created_4_1_, emerchantd0_1_.deleted_at as deleted_5_1_, emerchantd0_1_.last_updated_at as last_upd6_1_, emerchantd0_1_.optlockver as optlockv7_1_, emerchantd0_1_.code as code8_1_, emerchantd0_1_.description as descript9_1_, emerchantd0_1_.display_name as display10_1_, emerchantd0_1_.extref as extref11_1_, emerchantd0_1_.legalentity_id as legalen15_1_, emerchantd0_1_.namespace as namespa12_1_, emerchantd0_1_.parent_account_owner_id as parent_16_1_, emerchantd0_1_.status_code as status_13_1_, emerchantd0_1_.status_reason as status_14_1_ from merchantdivisions emerchantd0_ inner join accountowners emerchantd0_1_ on emerchantd0_.id=emerchantd0_1_.id where (emerchantd0_1_.deleted_at is null) and emerchantd0_1_.code=? limit ?
Hibernate: /* select eMerchantDivision
from EMerchantDivision eMerchantDivision
where eMerchantDivision.deletedAt is null and eMerchantDivision.code = ?1 */ select emerchantd0_.id as id1_1_, emerchantd0_1_.active_from as active_f2_1_, emerchantd0_1_.active_to as active_t3_1_, emerchantd0_1_.created_at as created_4_1_, emerchantd0_1_.deleted_at as deleted_5_1_, emerchantd0_1_.last_updated_at as last_upd6_1_, emerchantd0_1_.optlockver as optlockv7_1_, emerchantd0_1_.code as code8_1_, emerchantd0_1_.description as descript9_1_, emerchantd0_1_.display_name as display10_1_, emerchantd0_1_.extref as extref11_1_, emerchantd0_1_.legalentity_id as legalen15_1_, emerchantd0_1_.namespace as namespa12_1_, emerchantd0_1_.parent_account_owner_id as parent_16_1_, emerchantd0_1_.status_code as status_13_1_, emerchantd0_1_.status_reason as status_14_1_ from merchantdivisions emerchantd0_ inner join accountowners emerchantd0_1_ on emerchantd0_.id=emerchantd0_1_.id where (emerchantd0_1_.deleted_at is null) and emerchantd0_1_.code=? limit ?
[DEBUG] 2020-07-07 21:12:17.596 [qtp706322686-580] AutoRetryTransactionTemplate - Transaction execution heuristic exception found with state: 2
[DEBUG] 2020-07-07 21:12:17.596 [qtp706322686-580] AutoRetryTransactionTemplate - Transaction execution PSQL exception found [getSQLState: 40001 serverErrorMessage: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=df8d07a6 key=/Table/129/1/"N>4\xc1^\nFߥ%\x92\xec\xc5g\xcb\xce"/0 pri=0.00140211 epo=0 ts=1594149137.122283800,1 min=1594149137.078454200,0 seq=22} lock=true stat=PENDING rts=1594149137.078454200,0 wto=false max=1594149137.078454200,0
[DEBUG] 2020-07-07 21:12:17.596 [qtp706322686-580] AutoRetryTransactionTemplate - Non retryable exception in transaction execution
[INFO ] 2020-07-07 21:12:17.625 [qtp706322686-580] AccountHolderServiceImpl - AO lock released: /accountOwner/lock/FD5CMFSvPkLxpigEGnG7bvfxVjfk984WBqa/FD5CMFSvPkLwjbeWsgEtjGStGjdvbJznYG8/FD5CMG8JBWAdL8WfFfz1ZHgL7Jcq337nsfv
[DEBUG] 2020-07-07 21:12:17.626 [qtp706322686-580] ExceptionHandlerExceptionResolver - Using @ExceptionHandler com.payaut.common.rest.v1.error.RestExceptionHandler#anyException(Exception)
[ERROR] 2020-07-07 21:12:17.626 [qtp706322686-580] RestExceptionHandler - Heuristic completion: outcome state is rolled back; nested exception is org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection
org.springframework.transaction.HeuristicCompletionException: Heuristic completion: outcome state is rolled back; nested exception is org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection
	at org.springframework.data.transaction.ChainedTransactionManager.commit(ChainedTransactionManager.java:177) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:152) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at com.payaut.common.persistence.util.AutoRetryTransactionTemplate.execute(AutoRetryTransactionTemplate.java:47) ~[classes/:?]
	at com.payaut.accountowner.module.service.TransactionalAccountOwnerService.execWrite(TransactionalAccountOwnerService.kt:126) ~[classes/:?]
	at com.payaut.common.persistence.service.AbstractCrudService.create(AbstractCrudService.kt:138) ~[classes/:?]
	at com.payaut.common.persistence.service.AbstractCrudService$$FastClassBySpringCGLIB$$fd321e53.invoke(<generated>) ~[classes/:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at com.payaut.accountowner.module.service.AccountHolderServiceImpl$$EnhancerBySpringCGLIB$$68513a02.create(<generated>) ~[classes/:?]
	at com.payaut.common.rest.v1.controller.AbstractStandardController.create(AbstractStandardController.kt:148) ~[classes/:?]
	at com.payaut.common.rest.v1.controller.AbstractStandardController$$FastClassBySpringCGLIB$$75d234ba.invoke(<generated>) ~[classes/:?]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:119) ~[spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at com.payaut.accountowner.rest.v1.controller.AccountHolderControllerImpl$$EnhancerBySpringCGLIB$$423e86f4.create(<generated>) ~[classes/:?]
	at jdk.internal.reflect.GeneratedMethodAccessor339.invoke(Unknown Source) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:567) ~[?:?]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:523) ~[jakarta.servlet-api-4.0.3.jar:4.0.3]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:590) ~[jakarta.servlet-api-4.0.3.jar:4.0.3]
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1631) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226) ~[websocket-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at com.payaut.common.rest.filter.ExecCtxServletFilter.doFilter(ExecCtxServletFilter.kt:80) ~[classes/:?]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at com.payaut.common.rest.filter.ProductionHttpHeaderFilter.doFilter(ProductionHttpHeaderFilter.kt:24) ~[classes/:?]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) ~[spring-boot-actuator-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at com.payaut.common.rest.filter.ExceptionHandlerFilter.doFilter(ExceptionHandlerFilter.java:62) ~[classes/:?]
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1618) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[jetty-security-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1610) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1369) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:489) ~[jetty-servlet-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1580) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1284) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.Server.handle(Server.java:501) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~[jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) [jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) [jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) [jetty-server-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [jetty-io-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [jetty-util-9.4.29.v20200521.jar:9.4.29.v20200521]
	at java.lang.Thread.run(Thread.java:835) [?:?]
Caused by: org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:353) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at com.payaut.common.persistence.util.JpaDialectWrapper.translateExceptionIfPossible(JpaDialectWrapper.java:39) ~[classes/:?]
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:538) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.data.transaction.MultiTransactionStatus.commit(MultiTransactionStatus.java:74) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.data.transaction.ChainedTransactionManager.commit(ChainedTransactionManager.java:150) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	... 88 more
Caused by: org.hibernate.TransactionException: Unable to commit against JDBC Connection
	at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:92) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:282) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:534) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.data.transaction.MultiTransactionStatus.commit(MultiTransactionStatus.java:74) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.data.transaction.ChainedTransactionManager.commit(ChainedTransactionManager.java:150) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	... 88 more
Caused by: org.postgresql.util.PSQLException: ERROR: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): "sql txn" meta={id=df8d07a6 key=/Table/129/1/"N>4\xc1^\nFߥ%\x92\xec\xc5g\xcb\xce"/0 pri=0.00140211 epo=0 ts=1594149137.122283800,1 min=1594149137.078454200,0 seq=22} lock=true stat=PENDING rts=1594149137.078454200,0 wto=false max=1594149137.078454200,0
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532) ~[postgresql-42.2.14.jar:42.2.14]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267) ~[postgresql-42.2.14.jar:42.2.14]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312) ~[postgresql-42.2.14.jar:42.2.14]
	at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:837) ~[postgresql-42.2.14.jar:42.2.14]
	at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:859) ~[postgresql-42.2.14.jar:42.2.14]
	at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:387) ~[HikariCP-3.4.5.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java) ~[HikariCP-3.4.5.jar:?]
	at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:86) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:282) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.4.17.Final.jar:5.4.17.Final]
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:534) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.data.transaction.MultiTransactionStatus.commit(MultiTransactionStatus.java:74) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.data.transaction.ChainedTransactionManager.commit(ChainedTransactionManager.java:150) ~[spring-data-commons-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	... 88 more
[DEBUG] 2020-07-07 21:12:17.630 [qtp706322686-580] HttpEntityMethodProcessor - Using 'application/json', given [application/json] and supported [text/plain, */*, text/plain, */*, application/json, application/*+json, application/json, application/*+json, application/xml;charset=UTF-8, text/xml;charset=UTF-8, application/*+xml;charset=UTF-8, application/xml;charset=UTF-8, text/xml;charset=UTF-8, application/*+xml;charset=UTF-8]
[DEBUG] 2020-07-07 21:12:17.630 [qtp706322686-580] HttpEntityMethodProcessor - Writing ["{"code":"500.000.000","message":"Internal error"}"]
[DEBUG] 2020-07-07 21:12:17.630 [qtp706322686-580] ExceptionHandlerExceptionResolver - Resolved [org.springframework.transaction.HeuristicCompletionException: Heuristic completion: outcome state is rolled back; nested exception is org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection]
[DEBUG] 2020-07-07 21:12:17.630 [qtp706322686-580] DispatcherServlet - Completed 500 INTERNAL_SERVER_ERROR
[DEBUG] 2020-07-07 21:12:17.631 [qtp706322686-600] AccountHolderEntityConverter - AccountHolder parent reference is EMerchantDivision FD5CMFSvPkLwjbeWsgEtjGStGjdvbJznYG8
[DEBUG] 2020-07-07 21:12:17.631 [qtp706322686-600] AccountHolderEntityConverter - AccountHolder parent reference is DMerchantDivision LookupValue(value=287ef3c7-5690-41ae-8055-923dc7cb580b, parentRef=null, def=com.payaut.common.module.api.model.field.LookupFieldDef@363751f2)
[DEBUG] 2020-07-07 21:12:17.631 [qtp706322686-600] SQL - /* select eCountry