#219 Cleanup History logs not working (db increasing)

[Bruno]

Using JS7 2.6.2 : the cleanup seems to not work properly , my DB size is increasing, and logs seems to be not deleted.
See my log file here after : 0 entry deleted from history logs

2024-01-17T13:48:51,034 INFO cleanup-t-s-start-47-4 c.s.j.c.CleanupServiceTask - [cleanup_task][manual_task][deployment][10][completed=true]JocServiceTaskAnswerState[COMPLETED]
2024-01-17T13:48:51,043 INFO cleanup-t-s-start-47-3 c.s.j.c.m.CleanupTaskMonitoring - [monitor][monitoring][remaining steps][1d+2d 2024-01-14 13:48:47][MON_ORDER_STEPS]found=0
2024-01-17T13:48:51,043 INFO cleanup-t-s-start-47-3 c.s.j.c.m.CleanupTaskMonitoring - [monitor][monitoring][1d][2024-01-16T13:48:47.379691Z[UTC]]end cleanup
2024-01-17T13:48:51,043 INFO cleanup-t-s-start-47-3 c.s.j.c.CleanupServiceTask - [cleanup_task][service_task][monitor][completed=true]JocServiceTaskAnswerState[COMPLETED]
2024-01-17T13:48:51,342 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STATES=1000 total=1000]
2024-01-17T13:48:51,353 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STATES=866 total=1866]
2024-01-17T13:48:51,472 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=1000 total=1000]
2024-01-17T13:48:51,973 INFO cleanup-t-s-start-47-2 c.s.j.c.m.CleanupTaskDailyPlan - [dailyplan][deleted][8d][DPL_ORDER_VARIABLES=343 total=343][DPL_HISTORY=6714 total=6714][DPL_ORDERS=6714 total=6714][DPL_SUBMISSIONS=13 total=13]
2024-01-17T13:48:51,994 INFO cleanup-t-s-start-47-2 c.s.j.c.m.CleanupTaskDailyPlan - [dailyplan][8d][DPL_SUBMISSIONS]found=0
2024-01-17T13:48:51,994 INFO cleanup-t-s-start-47-2 c.s.j.c.CleanupServiceTask - [cleanup_task][service_task][dailyplan][completed=true]JocServiceTaskAnswerState[COMPLETED]
2024-01-17T13:48:52,493 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=10000 total=11000]
2024-01-17T13:48:53,464 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=10000 total=21000]
2024-01-17T13:48:55,789 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=10000 total=31000]
2024-01-17T13:48:56,619 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=10000 total=41000]
2024-01-17T13:48:57,158 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=10000 total=51000]
2024-01-17T13:48:57,708 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=10000 total=61000]
2024-01-17T13:48:58,354 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=10000 total=71000]
2024-01-17T13:48:59,090 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=10000 total=81000]
2024-01-17T13:49:01,562 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDER_STEPS=5602 total=86602]
2024-01-17T13:49:02,321 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=1000 total=1000]
2024-01-17T13:49:08,173 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=10000 total=11000]
2024-01-17T13:49:13,950 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=10000 total=21000]
2024-01-17T13:49:18,473 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=10000 total=31000]
2024-01-17T13:49:28,558 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=10000 total=41000]
2024-01-17T13:49:34,216 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=10000 total=51000]
2024-01-17T13:49:40,543 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=10000 total=61000]
2024-01-17T13:49:48,052 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=10000 total=71000]
2024-01-17T13:49:55,392 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=10000 total=81000]
2024-01-17T13:49:59,990 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=10000 total=91000]
2024-01-17T13:50:05,380 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_LOGS=6376 total=97376]
2024-01-17T13:50:05,852 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDERS=1000 total=1000]
2024-01-17T13:50:06,362 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDERS=9790 total=10790]
2024-01-17T13:50:06,375 INFO cleanup-t-s-start-47-1 c.s.j.c.h.CleanupPartialResult - [history][maxMainParentId=72628][HISTORY_ORDERS=0 total=10790]
2024-01-17T13:50:06,375 INFO cleanup-t-s-start-47-1 c.s.j.c.m.CleanupTaskHistory - [history][main all][8d 2024-01-09 13:48:47][maxMainParentId=72628][deleted][HISTORY_ORDER_STATES=1866 total=1866][HISTORY_ORDER_STEPS=86602 total=86602][HISTORY_LOGS=97376 total=97376][HISTORY_ORDERS=10790 total=10790]
2024-01-17T13:50:06,433 INFO cleanup-t-s-start-47-1 c.s.j.c.m.CleanupTaskHistory - [history][main all][8d 2024-01-09 13:48:47][HISTORY_ORDERS]found=0
2024-01-17T13:50:06,447 INFO cleanup-t-s-start-47-1 c.s.j.c.m.CleanupTaskHistory - [history][remaining all][8d+2d 2024-01-07 13:48:47][HISTORY_ORDERS]found=0
2024-01-17T13:50:24,176 INFO cleanup-t-s-start-47-1 c.s.j.c.m.CleanupTaskHistory - [history][remaining steps][8d+2d 2024-01-07 13:48:47][MON_ORDER_STEPS]found=0
2024-01-17T13:50:24,190 INFO cleanup-t-s-start-47-1 c.s.j.c.m.CleanupTaskHistory - [history][remaining states][8d+2d 2024-01-07 13:48:47][deleted][HISTORY_ORDER_STATES=0 total=1866]
2024-01-17T13:50:24,549 INFO cleanup-t-s-start-47-1 c.s.j.c.m.CleanupTaskHistory - [history][remaining logs][8d+2d 2024-01-07 13:48:47][deleted][HISTORY_LOGS=0 total=97376]
2024-01-17T13:50:24,555 INFO cleanup-t-s-start-47-1 c.s.j.c.m.CleanupTaskHistory - [history][deleteNotStartedOrdersLogs][8d 2024-01-09 13:48:47]/var/sos-berlin.com/js7/joc/logs/history/0

[Bruno]

Can be closed , the main pb was the postgres db cleaning indexes and relations, a VACCUM FULL solved th pb

[Andreas]

Just for the records: consider that deletion of records in a database does not necessarily shrink the table space. In particular for PostgreSQL data will be wiped only after a successful run of the vaccumizer.