Autosubmit database (SQLite) persistence is not working
@pechevar
Reported bySteps to reproduce the bug:
- Set the following configuration in the
autosubmit_xxxx.conf
file:
[storage]
TYPE = db
- Run the experiment:
$> autosubmit create xxxx
Preparing .lock file to avoid multiple instances with same expid.
Checking configuration files...
autosubmit_a0fl.conf OK
platforms_a0fl.conf OK
jobs_a0fl.conf OK
expdef_a0fl.conf OK
Configuration files OK
Loading parameters...
Creating the jobs list...
Creating jobs...
Adding dependencies...
Removing redundant dependencies...
Saving the jobs list...
[CRITICAL] Unhandled exception on Autosubmit: table job_list has 11 columns but 12 values were supplied
Traceback (most recent call last):
File "/home/Earth/jlope2/Development/PycharmProjects/autosubmit/autosubmit/autosubmit.py", line 342, in parse_args
return Autosubmit.create(args.expid, args.noplot, args.hide, args.output)
File "/home/Earth/jlope2/Development/PycharmProjects/autosubmit/autosubmit/autosubmit.py", line 1673, in create
job_list.save()
File "/home/Earth/jlope2/Development/PycharmProjects/autosubmit/autosubmit/job/job_list.py", line 516, in save
self._persistence.save(self._persistence_path, self._persistence_file, self._job_list)
File "/home/Earth/jlope2/Development/PycharmProjects/autosubmit/autosubmit/job/job_list_persistence.py", line 137, in save
self.db_manager.insertMany(self.JOB_LIST_TABLE, jobs_data)
File "/home/Earth/jlope2/Development/PycharmProjects/autosubmit/autosubmit/database/db_manager.py", line 90, in insertMany
cursor.executemany(insert_many_command, data)
OperationalError: table job_list has 11 columns but 12 values were supplied
The observed behaviour
There's a Python crash while creating the experiment.
The expected behaviour is
create
progress should work normally.