Eclipse Community Forums: Eclipse Process Manager (Stardust) » Sysconsole archiving (deletion) is very slow

Home » Archived » Eclipse Process Manager (Stardust) » Sysconsole archiving (deletion) is very slow

Sysconsole archiving (deletion) is very slow [message #1001075]

Tue, 15 January 2013 20:08

Eclipse User

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

Eclipse User

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:

-=] Back to Top [=-

Current Time: Thu Jul 24 16:59:58 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter