Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0049801 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2022-07-14 09:50 | 2022-07-14 09:50 | |||||||
| Reporter | shuehner | View Status | public | |||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0049801: Synchronize terminology fails on oracle only with mutating table (only in case of specific data) | |||||||||||
| Description | CI noticed this problem in openbravo (backoffice) repo with commit 4171f42fde03bd1ae3bda82e12dc3cfec9a10df5 Cause seems to be developer missing to run synchronize terminology. On postgres that caused dbinconsistency as expected. On oracle it triggered the mutating table error [sql] 0,@ERROR=ORA-04091: table INT_DBCONS_ORACLE.AD_COLUMN is mutating, trigger/function may not see it [sql] ORA-06512: at "INT_DBCONS_ORACLE.AD_FIELD_MOD_TRG", line 101 [sql] ORA-04088: error during execution of trigger 'INT_DBCONS_ORACLE.AD_FIELD_MOD_TRG' [sql] ORA-06512: at "INT_DBCONS_ORACLE.AD_COLUMN_TRG", line 44 [sql] ORA-04088: error during execution of trigger 'INT_DBCONS_ORACLE.AD_COLUMN_TRG' That problem disappeared with commit f950df1c9a2e19956a4675f40a23fe9855bd0269 which fixed the data issue. As there seems to be a logic error triggered with specific data this bug is reported. | |||||||||||
| Steps To Reproduce | backoffice repo in commit 4171f42fde03bd1ae3bda82e12dc3cfec9a10df5 install.source on oracle run synchronize terminology and look at errormsg of the ad_pinstance by - INSERT INTO ad_pinstance(ad_pinstance_id, ad_process_id, record_id, updatedby) VALUES('FF2830FB4A534C949084B351DFD00000', '172', 'EBA9C22C0E6745D480EAB10600EAFBC5', 100) - CALL ad_synchronize('FF2830FB4A534C949084B351DFD00000') - SELECT result, errormsg AS message FROM ad_pinstance WHERE ad_pinstance_id = 'FF2830FB4A534C949084B351DFD00000' Note: changes in commit f950df1c9a2e19956a4675f40a23fe9855bd0269 make the problem go away so could help pinpoint the data causing this. Notice the errormsg. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2022-07-14 09:50 | shuehner | New Issue | |
| 2022-07-14 09:50 | shuehner | Assigned To | => Triage Platform Base |
| 2022-07-14 09:50 | shuehner | Modules | => Core |
| 2022-07-14 09:50 | shuehner | Triggers an Emergency Pack | => No |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |