Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0026818 | Openbravo ERP | A. Platform | public | 2014-06-09 18:24 | 2014-09-02 09:29 |
| Reporter | shuehner | ||||
| Assigned To | AugustoMauch | ||||
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | 3.0PR14Q4 | Fixed in Version | 3.0PR14Q4 | ||
| Merge Request Status | |||||
| Review Assigned To | marvintm | ||||
| OBNetwork customer | OBPS | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0026818: new fk-batching code in dbsm behaves wrong when having at least 1 fk which cannot be enabled (on postgresql) | ||||
| Description | This bug is known to happen on postgresql. Unknown if it also applies to oracle. Some time ago code for dropping + re-enabling foreign keys inside update.database was changed to use jdbc-batching (to improve performance). That code contains fallback to non-batching in case of any fk failing to enable (because of non-conforming data). Idea was -> fast with batching if all fk's are fine fall back to be slow if now (slow not so important as should not happen frequently in practice). Now it is noticed that the fallback is not working properly. If you have a fk failing to enable in postgres then update.db does show error message about a different fk which is completely unrelated to user. That is happening frequently in CI (every 1-2 weeks at least) + also at least in one client. AMO has a patch in progress which should fix it but this needs more work. | ||||
| Steps To Reproduce | - | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2014-06-09 18:24 | shuehner | New Issue | |||
| 2014-06-09 18:24 | shuehner | Assigned To | => AugustoMauch | ||
| 2014-06-09 18:24 | shuehner | Modules | => Core | ||
| 2014-06-09 18:24 | shuehner | OBNetwork customer | => Yes | ||
| 2014-06-09 18:24 | shuehner | Triggers an Emergency Pack | => No | ||
| 2014-06-20 14:49 | alostale | Target Version | PR14Q3 => PR14Q4 | ||
| 2014-07-24 12:30 | jonalegriaesarte | Resolution time | => 1407967200 | ||
| 2014-08-07 15:19 | AugustoMauch | Issue Monitored: marvintm | |||
| 2014-08-07 15:20 | AugustoMauch | Review Assigned To | => marvintm | ||
| 2014-08-07 15:20 | hgbot | Checkin | |||
| 2014-08-07 15:20 | hgbot | Note Added: 0069114 | |||
| 2014-08-07 15:20 | hgbot | Checkin | |||
| 2014-08-07 15:20 | hgbot | Note Added: 0069115 | |||
| 2014-08-07 15:20 | hgbot | Status | new => resolved | ||
| 2014-08-07 15:20 | hgbot | Resolution | open => fixed | ||
| 2014-08-07 15:20 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/09161e69861377accfb61ef9afdbfb912115c3c2 [^] | ||
| 2014-08-07 15:20 | hgbot | Status | new => resolved | ||
| 2014-08-08 18:54 | hudsonbot | Checkin | |||
| 2014-08-08 18:54 | hudsonbot | Note Added: 0069269 | |||
| 2014-09-02 09:29 | marvintm | Status | resolved => closed | ||
| 2014-09-02 09:29 | marvintm | Fixed in Version | => 3.0PR14Q4 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||