Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0053777Openbravo ERPA. Platformpublic2023-10-26 16:592023-11-30 14:16
egoitz 
AugustoMauch 
normalmajorhave not tried
closedfixed 
5
 
PR24Q1 
approved
Gold
Core
No
0053777: Background grouping process is not working in HA
The feature to allow define grouping background processes is not working prokperly when defining clustering and having High availability with one or more app applications.
In a clustered environment:
- Connect to the backoffice
- Create a process group that contains two processes, i.e. Acct Server Process and Alert Process
- Open process Request, check the Group flag, select the group created in the previous point, and click on the Schedule Process. Note that the Process Monitor shows the process as Processing and that the following error is displayed in the Openbravo.log of one of the cluster instances:

org.quartz.JobPersistenceException: Couldn't store job: Unable to serialize JobDataMap for insertion into database because the value of property 'org.openbravo.scheduling.ProcessBundle.KEY' is not serializable: org.openbravo.scheduling.GroupInfo
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1120) ~[quartz-2.3.2.jar:?]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$2.executeVoid(JobStoreSupport.java:1067) ~[quartz-2.3.2.jar:?]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3780) ~[quartz-2.3.2.jar:?]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3778) ~[quartz-2.3.2.jar:?]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3864) ~[quartz-2.3.2.jar:?]
        at org.openbravo.scheduling.quartz.OpenbravoPersistentJobStore.executeInLock(OpenbravoPersistentJobStore.java:152) ~[classes/:?]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1063) ~[quartz-2.3.2.jar:?]
        at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:855) ~[quartz-2.3.2.jar:?]
        at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:249) ~[quartz-2.3.2.jar:?]
        at org.openbravo.scheduling.OBScheduler.schedule(OBScheduler.java:174) ~[classes/:?]
        at org.openbravo.scheduling.OBScheduler.schedule(OBScheduler.java:143) ~[classes/:?]
        at org.openbravo.scheduling.GroupInfo.executeNextProcess(GroupInfo.java:187) ~[classes/:?]
        at org.openbravo.scheduling.ProcessGroup.doExecute(ProcessGroup.java:67) ~[classes/:?]
        at org.openbravo.service.db.DalBaseProcess.execute(DalBaseProcess.java:85) ~[classes/:?]
        at org.openbravo.scheduling.DefaultJob.execute(DefaultJob.java:65) [classes/:?]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202) [quartz-2.3.2.jar:?]
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.2.jar:?]
Caused by: java.io.NotSerializableException: Unable to serialize JobDataMap for insertion into database because the value of property 'org.openbravo.scheduling.ProcessBundle.KEY' is not serializable: org.openbravo.scheduling.GroupInfo
        at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.serializeJobData(StdJDBCDelegate.java:3083) ~[quartz-2.3.2.jar:?]
        at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertJobDetail(StdJDBCDelegate.java:606) ~[quartz-2.3.2.jar:?]
        at org.openbravo.scheduling.quartz.OpenbravoDriverDelegate.insertJobDetail(OpenbravoDriverDelegate.java:125) ~[classes/:?]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1117) ~[quartz-2.3.2.jar:?]
        ... 16 more
No tags attached.
related to defect 0054029 closed AugustoMauch Connection leak when using scheduling process requests based on process groups 
Issue History
2023-10-26 16:59egoitzNew Issue
2023-10-26 16:59egoitzAssigned To => Triage Platform Base
2023-10-26 16:59egoitzOBNetwork customer => No
2023-10-26 16:59egoitzModules => Core
2023-10-26 16:59egoitzTriggers an Emergency Pack => No
2023-10-26 16:59egoitzOBNetwork customerNo => Gold
2023-11-22 17:24AugustoMauchAssigned ToTriage Platform Base => AugustoMauch
2023-11-22 17:26AugustoMauchSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=27177#r27177
2023-11-24 00:17AugustoMauchStatusnew => scheduled
2023-11-24 10:27AugustoMauchSummaryBackground groupoing process is not working in HA => Background grouping process is not working in HA
2023-11-26 21:40AugustoMauchRelationship addedrelated to 0054029
2023-11-27 17:41hgbotMerge Request Status => open
2023-11-27 17:41hgbotNote Added: 0157704
2023-11-30 08:05hgbotMerge Request Statusopen => approved
2023-11-30 08:05hgbotNote Added: 0157827
2023-11-30 08:05hgbotResolutionopen => fixed
2023-11-30 08:05hgbotStatusscheduled => closed
2023-11-30 08:05hgbotFixed in Version => PR24Q1
2023-11-30 08:05hgbotNote Added: 0157828
2023-11-30 14:14hgbotNote Added: 0157863
2023-11-30 14:16hgbotNote Added: 0157864
2023-11-30 14:16hgbotNote Added: 0157865

Notes
(0157704)
hgbot   
2023-11-27 17:41   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1060 [^]
(0157827)
hgbot   
2023-11-30 08:05   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1060 [^]
(0157828)
hgbot   
2023-11-30 08:05   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 8d2fc6848c338cdb1c6f53d73df3124d98afa791
Author: Augusto Mauch <augusto.mauch@openbravo.com>
Date: 30-11-2023 07:05:17
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/8d2fc6848c338cdb1c6f53d73df3124d98afa791 [^]

Fixes ISSUE-53777: Makes GroupInfo serializable, so that grouped processes work in clustered environment

---
A src-test/src/org/openbravo/scheduling/ProcessBundleSerializationTest.java
M src-test/src/org/openbravo/test/StandaloneTestSuite.java
M src-test/src/org/openbravo/test/base/mock/VariablesSecureAppMock.java
M src/org/openbravo/base/secureApp/VariablesSecureApp.java
M src/org/openbravo/scheduling/GroupInfo.java
M src/org/openbravo/scheduling/ProcessBundle.java
M src/org/openbravo/scheduling/ProcessMonitor.java
---
(0157863)
hgbot   
2023-11-30 14:14   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1418 [^]
(0157864)
hgbot   
2023-11-30 14:16   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1418 [^]
(0157865)
hgbot   
2023-11-30 14:16   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: cc71d1d8021312fd650e541da87ce565cc06b6f8
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 30-11-2023 14:13:08
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/cc71d1d8021312fd650e541da87ce565cc06b6f8 [^]

related to BUG-53777: fixes warning in VariablesSecureApp subclass

---
M src-test/org/openbravo/retail/posterminal/OBBaseRetailTest.java
---