conflicts with an existing job

[weiguang-zz]

I have the Config like this:

class Config(object):
    JOBS = [
        {
            'id': 'job9',
            'func': 'sync:job1',
            'args': (1, 2),
            'trigger': 'interval',
            'seconds': 10
        }
    ]

    SCHEDULER_JOBSTORES = {
        'default': SQLAlchemyJobStore(url='sqlite:///'+utils.get_absolute_path("datas/jobstore.db"))
    }

    SCHEDULER_EXECUTORS = {
        'default': {'type': 'threadpool', 'max_workers': 20}
    }

    SCHEDULER_JOB_DEFAULTS = {
        'coalesce': False,
        'max_instances': 3
    }

    SCHEDULER_VIEWS_ENABLED = True

So, when i start the scheduler, it will insert the job in the sqlite. however, when i restart the scheduler, it will insert again, which will cause an exception:

Traceback (most recent call last):
  File "/Users/zhangzheng/PycharmProjects/quant/mainapp.py", line 73, in <module>
    scheduler.start()
  File "/Users/zhangzheng/pyenv/tensorflow/lib/python2.7/site-packages/flask_apscheduler/scheduler.py", line 81, in start
    self.__scheduler.start()
  File "/Users/zhangzheng/pyenv/tensorflow/lib/python2.7/site-packages/apscheduler/schedulers/background.py", line 33, in start
    BaseScheduler.start(self, *args, **kwargs)
  File "/Users/zhangzheng/pyenv/tensorflow/lib/python2.7/site-packages/apscheduler/schedulers/base.py", line 151, in start
    self._real_add_job(job, jobstore_alias, replace_existing)
  File "/Users/zhangzheng/pyenv/tensorflow/lib/python2.7/site-packages/apscheduler/schedulers/base.py", line 847, in _real_add_job
    store.add_job(job)
  File "/Users/zhangzheng/pyenv/tensorflow/lib/python2.7/site-packages/apscheduler/jobstores/sqlalchemy.py", line 94, in add_job
    raise ConflictingIdError(job.id)
apscheduler.jobstores.base.ConflictingIdError: u'Job identifier (job9) conflicts with an existing job'

I think this isn't the right way when I start a scheduler. the right way should be inserting a job when the store not exist or just skip it. beacuse, when my app is done, i want to resume the existing job when i restart it.

zhangzheng

[viniciuschiele]

Hi @zhangzheng88

If your tasks are in the config file, why are you storing them in sqlite? It seems redundant.

[weiguang-zz]

you are right, thanks