Skip to content

Error running job: database is locked #621

@n0valis

Description

@n0valis

This is for bugs only

Did you already ask in the discord?

Yes

You verified that this is a bug and not a feature request or question by asking in the discord?

Yes

Describe the bug

This error occurs after the programm has already written to the db. So no idea why it thinks it's locked.
❯ ls -l /opt/ai-toolkit/aitk_db.db
-rwxr-xr-x 1 57344 30. Dez 21:26 /opt/ai-toolkit/aitk_db.db*

`
32 buckets made

Error running job: database is locked

========================================

Result:

  • 0 completed jobs

  • 1 failure

========================================

Traceback (most recent call last):

Traceback (most recent call last):

File "/opt/ai-toolkit/run.py", line 120, in

File "/opt/ai-toolkit/run.py", line 120, in

    main()main()

File "/opt/ai-toolkit/run.py", line 108, in main

File "/opt/ai-toolkit/run.py", line 108, in main

    raise eraise e

File "/opt/ai-toolkit/run.py", line 96, in main

File "/opt/ai-toolkit/run.py", line 96, in main

    job.run()job.run()

File "/opt/ai-toolkit/jobs/ExtensionJob.py", line 22, in run

File "/opt/ai-toolkit/jobs/ExtensionJob.py", line 22, in run

    process.run()process.run()

File "/opt/ai-toolkit/jobs/process/BaseSDTrainProcess.py", line 2015, in run

File "/opt/ai-toolkit/jobs/process/BaseSDTrainProcess.py", line 2015, in run

    self.hook_before_train_loop()self.hook_before_train_loop()

File "/opt/ai-toolkit/extensions_built_in/sd_trainer/DiffusionTrainer.py", line 279, in hook_before_train_loop

File "/opt/ai-toolkit/extensions_built_in/sd_trainer/DiffusionTrainer.py", line 279, in hook_before_train_loop

    super().hook_before_train_loop()super().hook_before_train_loop()

File "/opt/ai-toolkit/extensions_built_in/sd_trainer/SDTrainer.py", line 246, in hook_before_train_loop

File "/opt/ai-toolkit/extensions_built_in/sd_trainer/SDTrainer.py", line 246, in hook_before_train_loop

    super().hook_before_train_loop()super().hook_before_train_loop()

File "/opt/ai-toolkit/jobs/process/BaseSDTrainProcess.py", line 705, in hook_before_train_loop

File "/opt/ai-toolkit/jobs/process/BaseSDTrainProcess.py", line 705, in hook_before_train_loop

    self.logger.start()self.logger.start()

File "/opt/ai-toolkit/toolkit/logging_aitk.py", line 122, in start

File "/opt/ai-toolkit/toolkit/logging_aitk.py", line 122, in start

    self._con.execute("PRAGMA journal_mode=WAL;")self._con.execute("PRAGMA journal_mode=WAL;")

sqlite3sqlite3..OperationalErrorOperationalError: : database is lockeddatabase is locked
`

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions