OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

Forums Forums OroPlatform akeneo_batch_job_instance with 3.5 Gb

This topic contains 7 replies, has 5 voices, and was last updated by  gautamndsl 7 years, 10 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #36860

    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
  • #36861

    Yevhen Shyshkin
    Participant

    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.

    #36862

    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!

    #36863

    Dima Soroka
    Keymaster

    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.

    #36864

    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

    #36865

    Rodolfo
    Participant

    Hello!

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

    #36866

    Vova Soroka
    Participant

    Hello Rodolfo!

    Yes, this command removes records from the following tables:

    • akeneo_batch_job_execution
    • akeneo_batch_step_execution
    • akeneo_batch_job_instance
    #36867

    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)

The forum ‘OroPlatform’ is closed to new topics and replies.

Back to top