Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0030279 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Openbravo ERP] A. Platform | minor | have not tried | 2015-06-29 13:43 | 2022-02-01 08:09 | ||||||
| Reporter | alostale | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | 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 | 0030279: log clean up process doesn't vacuum tables deleted via FK cascaded deletion | ||||||||||
| Description | When log clean up process is run in PostgreSQL, tables that where cleaned up are vacuumed. If there are tables that are deleted because they have a delete cascade FK to one of the tables marked to be deleted, vacuum is not executed for them. | ||||||||||
| Steps To Reproduce | In the default configuration ad_session is marked to be deleted, ad_session_usage_audit is also deleted via FK. Execute clean up process and check there is a vacuum for ad_session but not for ad_session_usage_audit. | ||||||||||
| Proposed Solution | Check cascaded FK tables to also vacuum them: SELECT distinct pc1.relname FROM pg_constraint pc, pg_class pc1, pg_class pc2 WHERE pc.contype='f' and pc.conrelid= pc1.oid and pc.confrelid = pc2.oid and pc2.relname in :deletedTables Note this can be recursive to several levels | ||||||||||
| Tags | Performance | ||||||||||
| 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 |
| 2015-06-29 13:43 | alostale | New Issue | |
| 2015-06-29 13:43 | alostale | Assigned To | => platform |
| 2015-06-29 13:43 | alostale | Modules | => Core |
| 2015-06-29 13:43 | alostale | Triggers an Emergency Pack | => No |
| 2015-06-29 13:43 | alostale | Status | new => acknowledged |
| 2015-06-29 13:43 | alostale | Target Version | => 3.0PR15Q4 |
| 2015-06-29 13:46 | alostale | Relationship added | related to 0028930 |
| 2015-06-29 13:46 | shuehner | Issue Monitored: shuehner | |
| 2015-06-29 13:47 | alostale | Tag Attached: Performance | |
| 2015-10-01 07:51 | alostale | Target Version | 3.0PR15Q4 => |
| 2022-02-01 08:09 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |