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.
- CreatorTopic
- January 23, 2015 at 1:20 pm #36860
Hello!
My ‘akeneo_batch_job_instance’ table has 3.5GB of data. Do I really need all these?
Thank you! - CreatorTopic
- AuthorReplies
- January 24, 2015 at 5:46 am #36861
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.
January 26, 2015 at 9:37 am #36862Hello 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!
January 26, 2015 at 10:08 am #36863We 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.
January 26, 2015 at 10:25 am #36864Thanks 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
July 3, 2015 at 1:53 pm #36865Hello!
Does oro:cron:batch:cleanup supposed to clean akeneo_batch_job_instance? Only this table are not getting cleaned here. Thanks!
July 8, 2015 at 5:05 am #36866Hello Rodolfo!
Yes, this command removes records from the following tables:
- akeneo_batch_job_execution
- akeneo_batch_step_execution
- akeneo_batch_job_instance
May 21, 2016 at 5:52 am #36867Hi 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 completewhen 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 : 30264COMPLETED
select count(*) as complete_tasl from akeneo_batch_job_execution where exit_code = ‘COMPLETED’ : 26063So it has not cleared akeneo_batch_job_execution . Can we clean this manually?
Regards
Gautam - AuthorReplies
The forum ‘OroPlatform’ is closed to new topics and replies.