Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041484Openbravo ERPA. Platformpublic2019-07-30 12:282020-09-23 06:44
Reporteralostale 
Assigned Tocberner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR20Q4 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041484: make job scheduling clusterizable
DescriptionMake it possible to run job scheduler in all the different nodes in a cluster.

More information: http://wiki.openbravo.com/wiki/Projects:Quartz_Clusterization [^]
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0044963 closed cberner Change quartz.properties to be a .template instead of a versioned file 
related to defect 0044969 closed cberner Execute quartz scheduling tests in both clustered and non-clustered mode 
depends on feature request 0041483 closed caristu update quartz 
depends on defect 0041460 closed alostale A foreign key composed of more than 1 field will produced duplicated information when the database is exported by DBSM 
depends on defect 0041503 closed mauricio_peccorini DBSM doesn't handle not null BLOB columns correctly in Oracle 
related to defect 0044997 closed cberner missplaced "Cluster Instance" menu entry 
related to defect 0045022 closed cberner Add missing description/help in AD_Table and AD_Windows from clustered quartz 
blocks design defect 0034490 acknowledged Triage Platform Base [clustering] Support clustering 
causes defect 0044952 closed cberner Fix added column in AD_PROCESS breaking CI 
causes defect 0045006 closed cberner unstable background scheduler jUnit test 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-07-30 12:28alostaleNew Issue
2019-07-30 12:28alostaleAssigned To => platform
2019-07-30 12:28alostaleModules => Core
2019-07-30 12:28alostaleTriggers an Emergency Pack => No
2019-07-30 12:29alostaleStatusnew => acknowledged
2019-07-30 12:29alostaleDescription Updatedbug_revision_view_page.php?rev_id=19224#r19224
2019-07-30 12:29alostaleRelationship addeddepends on 0041483
2019-07-30 12:30alostaleRelationship addedblocks 0034490
2019-07-30 12:31alostaleRelationship addeddepends on 0041460
2019-07-31 12:03mauricio_peccoriniRelationship addeddepends on 0041503
2020-08-30 18:05AugustoMauchStatusacknowledged => scheduled
2020-08-30 18:05AugustoMauchAssigned Toplatform => cberner
2020-08-30 18:05AugustoMauchNote Added: 0122451
2020-08-31 14:18hgbotResolutionopen => fixed
2020-08-31 14:18hgbotStatusscheduled => resolved
2020-08-31 14:18hgbotFixed in Version => PR20Q4
2020-08-31 14:18hgbotNote Added: 0122495
2020-09-03 06:53alostaleRelationship addedcauses 0044952
2020-09-03 06:54alostaleRelationship addedrelated to 0044963
2020-09-03 06:54alostaleReview Assigned To => AugustoMauch
2020-09-03 06:54alostaleStatusresolved => closed
2020-09-03 07:08alostaleRelationship addedrelated to 0044969
2020-09-07 08:08alostaleRelationship addedrelated to 0044997
2020-09-07 15:43alostaleRelationship addedcauses 0045006
2020-09-10 10:12cbernerRelationship addedcauses 0045022
2020-09-10 10:12cbernerRelationship deletedcauses 0045022
2020-09-10 10:13cbernerRelationship addedrelated to 0045022
2020-09-22 13:36hgbotNote Added: 0123286
2020-09-23 06:44hgbotNote Added: 0123303
2020-09-23 06:44hgbotNote Added: 0123304

Notes
(0122451)
AugustoMauch   
2020-08-30 18:05   
Merge request: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/99 [^]
(0122495)
hgbot   
2020-08-31 14:18   
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: b8b98998a65cf4a623b48b5da19896e61ce68d28
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 2020-08-31T14:11:30+02:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/b8b98998a65cf4a623b48b5da19896e61ce68d28 [^]

Fixes ISSUE-41484: Allow background job scheduling to be clusterizable

Previously background processes could only be scheduled on a single
instance of a cluster. With these changes it is now possible to configure
multiple instances to schedule background processes.

Merges quartz-cluster project.

Project page: http://wiki.openbravo.com/wiki/Projects:Quartz_Clusterization [^]
Merge request: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/99 [^]

---
A src-db/database/model/tables/AD_CLUSTER_INSTANCE.xml
A src-db/database/model/tables/AD_PROCESS_CLUSTER_INST.xml
A src-db/database/model/tables/OBSCHED_BLOB_TRIGGERS.xml
A src-db/database/model/tables/OBSCHED_CALENDARS.xml
A src-db/database/model/tables/OBSCHED_CRON_TRIGGERS.xml
A src-db/database/model/tables/OBSCHED_FIRED_TRIGGERS.xml
A src-db/database/model/tables/OBSCHED_JOB_DETAILS.xml
A src-db/database/model/tables/OBSCHED_LOCKS.xml
A src-db/database/model/tables/OBSCHED_PAUSED_TRIGGER_GRPS.xml
A src-db/database/model/tables/OBSCHED_SCHEDULER_STATE.xml
A src-db/database/model/tables/OBSCHED_SIMPLE_TRIGGERS.xml
A src-db/database/model/tables/OBSCHED_SIMPROP_TRIGGERS.xml
A src-db/database/model/tables/OBSCHED_TRIGGERS.xml
A src-db/database/model/triggers/OBSCHED_BLOB_TRIGGERS_TRG.xml
A src-db/database/model/triggers/OBSCHED_CALENDARS_TRG.xml
A src-db/database/model/triggers/OBSCHED_CRON_TRIGGERS_TRG.xml
A src-db/database/model/triggers/OBSCHED_FIRED_TRIGGERS_TRG.xml
A src-db/database/model/triggers/OBSCHED_JOB_DETAILS_TRG.xml
A src-db/database/model/triggers/OBSCHED_LOCKS_TRG.xml
A src-db/database/model/triggers/OBSCHED_PAUSED_TRI_GRPS_TRG.xml
A src-db/database/model/triggers/OBSCHED_SCHEDULER_STATE_TRG.xml
A src-db/database/model/triggers/OBSCHED_SIMPLE_TRIGGERS_TRG.xml
A src-db/database/model/triggers/OBSCHED_SIMPROP_TRIGGERS_TRG.xml
A src-db/database/model/triggers/OBSCHED_TRIGGERS_TRG.xml
A src/org/openbravo/erpCommon/ad_callouts/BackgroundProcessClusterConfig.java
A src/org/openbravo/scheduling/ClusterInstanceProcessAccess.java
A src/org/openbravo/scheduling/KillableProcessHandler.java
A src/org/openbravo/scheduling/OBSchedulerMBean.java
A src/org/openbravo/scheduling/quartz/JobInitializationListener.java
A src/org/openbravo/scheduling/quartz/OpenbravoCalendarIntervalTriggerPersistenceDelegate.java
A src/org/openbravo/scheduling/quartz/OpenbravoDailyTimeIntervalTriggerPersistenceDelegate.java
A src/org/openbravo/scheduling/quartz/OpenbravoDriverDelegate.java
A src/org/openbravo/scheduling/quartz/OpenbravoInstanceIdGenerator.java
A src/org/openbravo/scheduling/quartz/OpenbravoJDBCDelegate.java
A src/org/openbravo/scheduling/quartz/OpenbravoJDBCPersistenceSupport.java
A src/org/openbravo/scheduling/quartz/OpenbravoOracleJDBCDelegate.java
A src/org/openbravo/scheduling/quartz/OpenbravoPersistentJobStore.java
A src/org/openbravo/scheduling/quartz/OpenbravoPostgreJDBCDelegate.java
A src/org/openbravo/scheduling/quartz/QuartzConnectionProvider.java
M config/quartz.properties
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS.xml
M modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_PROCESS.xml
M modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_PROCESS.xml
M modules/org.openbravo.utility.cleanup.log/src-db/database/sourcedata/AD_PROCESS.xml
M src-core/src/org/openbravo/base/ConfigParameters.java
M src-db/database/model/tables/AD_PROCESS.xml
M src-db/database/model/tables/AD_PROCESS_RUN.xml
M src-db/database/model/views/AD_PROCESS_EXECUTION_V.xml
M src-db/database/sourcedata/AD_CALLOUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_FIELDGROUP.xml
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml
M src-db/database/sourcedata/AD_PACKAGE.xml
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src-db/database/sourcedata/AD_TREENODE.xml
M src-db/database/sourcedata/AD_WINDOW.xml
M src-test/src/org/openbravo/scheduling/trigger/MisfirePolicyTest.java
M src/org/openbravo/base/OBSchedulerInitializerListener.java
M src/org/openbravo/common/actionhandler/KillProcess.java
M src/org/openbravo/erpCommon/ad_process/ScheduleProcess.java
M src/org/openbravo/erpCommon/ad_process/UnscheduleProcess.java
M src/org/openbravo/scheduling/OBScheduler.java
M src/org/openbravo/scheduling/ProcessBundle.java
M src/org/openbravo/scheduling/ProcessContext.java
M src/org/openbravo/scheduling/ProcessMonitor.java
M src/org/openbravo/scheduling/ProcessRun_data.xsql
M src/org/openbravo/scheduling/ProcessRunner.java
---
(0123286)
hgbot   
2020-09-22 13:36   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/176 [^]
(0123303)
hgbot   
2020-09-23 06:44   
Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: b8c7dee0f01f099118cc3e65dde778453273d6c2
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 2020-09-22T13:33:30+02:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/b8c7dee0f01f099118cc3e65dde778453273d6c2 [^]

Related to ISSUE-41484: Temporarily disable test case checkMisfirePolicy

MisfirePolicyTest testcase checkMisfirePolicy is unstable but not
consistently when in a clustered configuration. The test is disabled (ignored)
until completely fixed or substituted by similar tests.

---
M src-test/src/org/openbravo/scheduling/trigger/MisfirePolicyTest.java
---
(0123304)
hgbot   
2020-09-23 06:44   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/176 [^]