Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Eclipse Process Manager (Stardust) » Sysconsole archiving (deletion) is very slow
Sysconsole archiving (deletion) is very slow [message #1001075] Tue, 15 January 2013 20:08 Go to next message
Robert Emsbach is currently offline Robert Emsbach
Messages: 115
Registered: October 2011
Location: Singapore
Senior Member

Hi,

it is observed that the sysconsole process is running fine but not able to delete the full unrequired records. After 2-3 days of continuous monitoring it is observed that it run continuously and I have to manually stop it otherwise there might be chances it will eat up DB connections and lead to failure of important daily job import process.

Before starting the archiving I usually run the following query to get an idea of the records about to deleted.

Query: SELECT count(*) FROM process_instance pi WHERE (pi.state IN (1, 2) AND pi.oid = pi.rootProcessInstance)
Result: 7295553

Sysconsole setup:
Quote:
sysconsole -verbose -force archive -deadProcesses -noBackup -b 20 -partition mypartition



After 8 hours the above query returns a result of 7163153.

Please suggest what corrective measure can be applied.

Thank you
Re: Sysconsole archiving (deletion) is very slow [message #1001077 is a reply to message #1001075] Tue, 15 January 2013 20:11 Go to previous message
Robert Emsbach is currently offline Robert Emsbach
Messages: 115
Registered: October 2011
Location: Singapore
Senior Member

You should archive / delete long entries before each archive run of dead processes.

sysconsole -force archive -logEntries -b 20 -partition mypartition


This should speed up the archive process significantly as no expensive reference check on log_entry table needs to be done.

Secondly, you should remove verbose attribute and make sure that the log level is on ERROR again.

You may increase the batch size again, since it was not the root cause of the issue.

All three actions should improve the speed of archiving tremendously.
Previous Topic:Stardust execution issue in Linux
Next Topic:Using IPP Camel components in EAR deployment
Goto Forum:
  


Current Time: Thu Jul 24 11:34:46 EDT 2014

Powered by FUDForum. Page generated in 0.11698 seconds