ssossossosso

Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 7 replies, has 5 voices, and was last updated by  gautamndsl 1 year, 4 months ago.

  • Creator
    Topic
  • #8188

    Rodolfo
    Participant

    Hello!

    My ‘akeneo_batch_job_instance’ table has 3.5GB of data. Do I really need all these?
    Thank you!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Author
    Replies
  • #8216
    Yevhen Shyshkin
    Yevhen Shyshkin
    Oro Core

    Hello, Rodolfo.

    Tables akeneo_batch_job_instance, akeneo_batch_job_execution and akeneo_batch_step_execution contins logs and errors related to appropriate jobs. You can remove them if you don’t need these data.

    However before removing it, probably, it would be good to check table akeneo_batch_job_execution for incorrectly finished jobs (select * from akeneo_batch_job_execution where exit_code != ‘COMPLETED’) – these records may contain important information about failed operations.

    #8238

    Rodolfo
    Participant

    Hello Yevhen!

    I found 9k rows != COMPLETED and 1.5M = COMPLETED.
    So, assuming that my only size problem is akeneo_batch_job_instance, and I have only logs living inside it, I’ll remove these rows.

    Thanks!

    #8239
    Dima Soroka
    Dima Soroka
    Oro Core

    We introduced oro:cron:batch:cleanup command in OroPlatform 1.5. If your instance cron is configured in the right way, this table should be cleaned up every day.

    #8240

    Rodolfo
    Participant

    Thanks Dima,

    I’m not using the oro:cron. I’ve added my syncs manually in my crontab. So, when I type this command, I’m getting this message: “There are no jobs eligible for clean up”. By now I’m going to keep cleaning this table manually once a week. Thanks!

    00 02 * * * php /var/www/html/orocrm/app/console oro:cron:integration –integration-id=4 -e prod

    #11333

    Rodolfo
    Participant

    Hello!

    Does oro:cron:batch:cleanup supposed to clean akeneo_batch_job_instance? Only this table are not getting cleaned here. Thanks!

    #11374

    Vova Soroka
    Oro Core

    Hello Rodolfo!

    Yes, this command removes records from the following tables:

    • akeneo_batch_job_execution
    • akeneo_batch_step_execution
    • akeneo_batch_job_instance
    #18256

    gautamndsl
    Participant

    Hi Vova,
    I am using 1.9.2 orocrm , when I tried
    $php app/console oro:cron:batch:cleanup
    Batch jobs will be deleted: 35
    Batch job history cleanup complete

    when i look into database:
    SELECT COUNT(*) AS Total_count FROM akeneo_batch_job_execution : 30265
    select count(*) as Total_count from akeneo_batch_step_execution : 47147
    select count(*) as Total_count from akeneo_batch_job_instance : 30264

    COMPLETED
    select count(*) as complete_tasl from akeneo_batch_job_execution where exit_code = ‘COMPLETED’ : 26063

    So it has not cleared akeneo_batch_job_execution . Can we clean this manually?

    Regards
    Gautam

Viewing 7 replies - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.