Project:
| View Revisions: Issue #38291 | [ Back to Issue ] | ||
| Summary | 0038291: Log Clean Up process doesn't finish deleting C_IMPORT_ENTRY_ARCHIVE table with big amount of data | ||
| Revision | 2018-04-06 14:52 by shuehner | ||
| Description | Log Clean Up process doesn't finish deleting C_IMPORT_ENTRY_ARCHIVE table with big amount of data. The problem happens when there are lot of records in OBEDL_REQUEST_LINE table that has a foreign key to C_IMPORT_ENTRY_ARCHIVE. Same issue can happen with C_IMPORT_ENTRY_ID column. (In ImportEntryArchiveThread as it deletes from c_import_entry table triggering same seq-scan) -> Already visible with 500ms avg time of pgbadger for delete of c_import_entry probably coming from that (2nd indicator is very high number of seq-scans of obedl_request_line table) |
||
| Revision | 2018-04-06 14:52 by shuehner | ||
| Description | Log Clean Up process doesn't finish deleting C_IMPORT_ENTRY_ARCHIVE table with big amount of data. The problem happens when there are lot of records in OBEDL_REQUEST_LINE table that has a foreign key to C_IMPORT_ENTRY_ARCHIVE. Same issue can happen with C_IMPORT_ENTRY_ID column. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |