Skip to Content
This question has been flagged
cronschedulerpostgresqllock
3 Replies
22041 Views
Avatar
Hannes Smit

I have an ir.cron job / schedule that stopped running a few days ago, although its interval is 10 minutes.

So, first I tried to reset the date to now, or 1 minute in the future. But then an error message appears:

Record cannot be modified right now This cron task is currently being executed and may not be modified, please try again in a few minutes

see: bazaar.launchpad.net/~openerp/openobject-server/7.0/view/head:/openerp/addons/base/ir/ir_cron.py#L262

I understand that the schedule record is locked by FOR UPDATE NOWAIT.

How would OpenERP remove this lock in the end? And, for now, how to remove the lock now?

EDIT: An answer to the latter is simple: restart server.

Avatar
Discard
Avatar
Harsh Dhaduk
Best Answer

Right Grahame Jordan but you want to force fully stop then you need following step.

  • Stop OpenERP Server
  • login to postgresql database (with selected database)
  • fire following query
    "select * from ir_crom;"
  • check what you try to edit or create perticular form is it under in ir_crom if yes then get that id and fire following query
  • """update ir_cron set active = False where id = (Selected id);"""
    (inactive all scheduler)
  • Start openerp server and login and do your work.
Avatar
Discard
Avatar
Grahame Jordan
Best Answer

While the cron is running a job it will block writes to the ir_cron table. You need to wait for the job to complete. If you are running the mrp scheduler this may take a while

Avatar
Discard
Zahin

Its not complete, continue working... how to stop it, without restarting server !

Avatar
Zahin
Best Answer

Problem due to most continue working scheduler and access all most resources.

I had read a article where problem fixed somehow, Its work for me.

Steps to fix

http://goo.gl/vZSYd1

I suggest to OpenERP Bugs fixer to resolve this issue with OpenERP 7.0 first.

Avatar
Discard
Related Posts Replies Views Activity
could not obtain lock on row in relation "ir_cron" Solved
cron postgresql lock
Avatar
Avatar
Avatar
Avatar
Avatar
7
Mar 25
52875
Error calling function from a scheduled action method Solved
cron scheduler
Avatar
Avatar
2
Apr 23
3732
"How to Trigger a Button Automatically when scheduler is Running"
cron scheduler
Avatar
Avatar
1
Mar 15
6736
openerp 7 scheduler is not running
cron scheduler
Avatar
0
Mar 15
6323
CRONs aren't executed after a certain time
cron postgresql odoo16features
Avatar
Avatar
Avatar
3
Apr 24
4551