You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@fineract.apache.org by "Adam Saghy (Jira)" <ji...@apache.org> on 2023/01/31 08:10:00 UTC
[jira] [Created] (FINERACT-1876) ERROR: Could not serialize access due to concurrent update
Adam Saghy created FINERACT-1876:
------------------------------------
Summary: ERROR: Could not serialize access due to concurrent update
Key: FINERACT-1876
URL: https://issues.apache.org/jira/browse/FINERACT-1876
Project: Apache Fineract
Issue Type: Bug
Reporter: Adam Saghy
During job execution (manually or by cron) sometimes the job execution is failing due to:
ERROR: could not serialize access due to concurrent update
Probably Fineract is using too strict transaction isolation and that causes the problem
+Source:+
[!https://pganalyze.com/favicon-32x32.png?v=f4ef6be3b5ad3a442f4c9a3d4449d1c8!U138: Could not serialize access due to concurrent update · pganalyze|https://pganalyze.com/docs/log-insights/app-errors/U138]
*Example stacktrace: (not always happen…)*
2023-01-30 13:31:25.216 - INFO 87125 --- [group3_Worker-1] o.s.b.c.l.support.SimpleJobLauncher : Job: [SimpleJob: [name=ADD_PERIODIC_ACCRUAL_ENTRIES]] completed with the following parameters: [\{run.id=92}] and the following status: [COMPLETED] in 152ms
[EL Warning]: 2023-01-30 13:31:30.015--UnitOfWork([1743312334|https://mifosforge.jira.com/jira/software/c/projects/PS/boards/45/backlog?view=detail&selectedIssue=PS-1215&issueLimit=100])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: could not serialize access due to concurrent update
*During integration test (not consistent, not always happen)*
org.apache.fineract.integrationtests.SchedulerJobsTest
Test testTriggeringManualExecutionOfAllSchedulerJobs() FAILED (2m 52s)
java.lang.AssertionError: 1 expectation failed.
Expected status code <202> but was <500>.
at org.apache.fineract.integrationtests.SchedulerJobsTest.tearDown(SchedulerJobsTest.java:69)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)