ExportXMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Normal
    • None
    • Component/s: troi
    • None

      When after music collection update I tried to run 'troi db scan' it show some files to update and then fail with errorĀ 

      Traceback (most recent call last):
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 3306, in execute_sql
          cursor.execute(sql, params or ())
          ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
      sqlite3.IntegrityError: FOREIGN KEY constraint failed
      
      During handling of the above exception, another exception occurred:
      
      Traceback (most recent call last):
        File "/home/user/.venv/bin/troi", line 8, in <module>
          sys.exit(cli())
                   ~~~^^
        File "/home/user/.venv/lib/python3.13/site-packages/click/core.py", line 1485, in __call__
          return self.main(*args, **kwargs)
                 ~~~~~~~~~^^^^^^^^^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/click/core.py", line 1406, in main
          rv = self.invoke(ctx)
        File "/home/user/.venv/lib/python3.13/site-packages/click/core.py", line 1873, in invoke
          return _process_result(sub_ctx.command.invoke(sub_ctx))
                                 ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/click/core.py", line 1873, in invoke
          return _process_result(sub_ctx.command.invoke(sub_ctx))
                                 ~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/click/core.py", line 1269, in invoke
          return ctx.invoke(self.callback, **ctx.params)
                 ~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/click/core.py", line 824, in invoke
          return callback(*args, **kwargs)
        File "/home/user/.venv/lib/python3.13/site-packages/troi/content_resolver/cli.py", line 129, in scan
          db.scan(music_dirs, chunksize=chunksize, force=force)
          ~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/troi/content_resolver/database.py", line 173, in scan
          self.traverse()
          ~~~~~~~~~~~~~^^
        File "/home/user/.venv/lib/python3.13/site-packages/troi/content_resolver/database.py", line 225, in traverse
          self.process_chunk()
          ~~~~~~~~~~~~~~~~~~^^
        File "/home/user/.venv/lib/python3.13/site-packages/troi/content_resolver/database.py", line 410, in process_chunk
          statuses += self.read_metadata_and_add(self.chunk)
                      ~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/troi/content_resolver/database.py", line 316, in read_metadata_and_add
          result = Recording.insert_many(datas).on_conflict_replace().execute()
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 2010, in inner
          return method(self, database, *args, **kwargs)
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 2081, in execute
          return self._execute(database)
                 ~~~~~~~~~~~~~^^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 2886, in _execute
          return super(Insert, self)._execute(database)
                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 2599, in _execute
          cursor = database.execute(self)
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 3312, in execute
          return self.execute_sql(sql, params)
                 ~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 3304, in execute_sql
          with __exception_wrapper__:
               ^^^^^^^^^^^^^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 3076, in __exit__
          reraise(new_type, new_type(exc_value, *exc_args), traceback)
          ~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 162, in reraise
          raise value.with_traceback(tb)
        File "/home/user/.venv/lib/python3.13/site-packages/peewee.py", line 3306, in execute_sql
          cursor.execute(sql, params or ())
          ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
      peewee.IntegrityError: FOREIGN KEY constraint failed
      

            Assignee:
            Robert Kaye
            Reporter:
            wrr666
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Version Package