ssossossossosso

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 1 year, 8 months ago.

  • Creator
    Topic
  • #31117

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

    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.

    #31119

    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!

    #31120

    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.

    #31121

    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

    #31122

    Rodolfo
    Participant

    Hello!

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

    #31123

    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
    #31124

    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.