Problem importing Documents into new Paperless-ngx installation reddit / selfhosted ---------------------------------------------------------------------- blackbunt · 2023-12-26 17:34 Hey guys I think i am missing something, maybe someone could help me: I moved my Paperless-ngx instance to a new machine. On my new machine I ran the same docker-compose file for Paperless-ngx and I made sure the version matched. (v. 1.17.3) Then I exported the existing documents using the document\_exporter function as a zip. Moved that zip to my new installation, extracted that and ran document\_importer. This got me following error message: root@paperless:/usr/src/paperless/src# document_importer /usr/src/paperless/export/ --traceback Checking the manifest Database import failed No version information present Traceback (most recent call last): File "/usr/local/lib/python3.9/site- packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.9/site- packages/django/db/backends/sqlite3/base.py", line 357, in execute return Database.Cursor.execute(self, query, params) sqlite3.IntegrityError: UNIQUE constraint failed: auth_user.username The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/src/paperless/src/manage.py", line 10, in execute_from_command_line(sys.argv) File "/usr/local/lib/python3.9/site- packages/django/core/management/__init__.py", line 446, in execute_from_command_line utility.execute() File "/usr/local/lib/python3.9/site- packages/django/core/management/__init__.py", line 440, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python3.9/site- packages/django/core/management/base.py", line 402, in run_from_argv self.execute(*args, **cmd_options) File "/usr/local/lib/python3.9/site- packages/django/core/management/base.py", line 448, in execute output = self.handle(*args, **options) File "/usr/src/paperless/src/documents/management/commands/docum ent_importer.py", line 147, in handle raise e File "/usr/src/paperless/src/documents/management/commands/docum ent_importer.py", line 128, in handle call_command("loaddata", manifest_path) File "/usr/local/lib/python3.9/site- packages/django/core/management/__init__.py", line 198, in call_command return command.execute(*args, **defaults) File "/usr/local/lib/python3.9/site- packages/django/core/management/base.py", line 448, in execute output = self.handle(*args, **options) File "/usr/local/lib/python3.9/site- packages/django/core/management/commands/loaddata.py", line 102, in handle self.loaddata(fixture_labels) File "/usr/local/lib/python3.9/site- packages/django/core/management/commands/loaddata.py", line 163, in loaddata self.load_label(fixture_label) File "/usr/local/lib/python3.9/site- packages/django/core/management/commands/loaddata.py", line 253, in load_label if self.save_obj(obj): File "/usr/local/lib/python3.9/site- packages/django/core/management/commands/loaddata.py", line 209, in save_obj obj.save(using=self.using) File "/usr/local/lib/python3.9/site- packages/django/core/serializers/base.py", line 288, in save models.Model.save_base(self.object, using=using, raw=True, **kwargs) File "/usr/local/lib/python3.9/site- packages/django/db/models/base.py", line 863, in save_base updated = self._save_table( File "/usr/local/lib/python3.9/site- packages/django/db/models/base.py", line 976, in _save_table updated = self._do_update( File "/usr/local/lib/python3.9/site- packages/django/db/models/base.py", line 1040, in _do_update return filtered._update(values) > 0 File "/usr/local/lib/python3.9/site- packages/django/db/models/query.py", line 1216, in _update return query.get_compiler(self.db).execute_sql(CURSOR) File "/usr/local/lib/python3.9/site- packages/django/db/models/sql/compiler.py", line 1822, in execute_sql cursor = super().execute_sql(result_type) File "/usr/local/lib/python3.9/site- packages/django/db/models/sql/compiler.py", line 1398, in execute_sql cursor.execute(sql, params) File "/usr/local/lib/python3.9/site- packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers( File "/usr/local/lib/python3.9/site- packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers return executor(sql, params, many, context) File "/usr/local/lib/python3.9/site- packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.9/site- packages/django/db/utils.py", line 91, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/usr/local/lib/python3.9/site- packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.9/site- packages/django/db/backends/sqlite3/base.py", line 357, in execute return Database.Cursor.execute(self, query, params) django.db.utils.IntegrityError: Problem installing fixture '/usr/src/paperless/export/manifest.json': Could not load auth.User(pk=2): UNIQUE constraint failed: auth_user.username root@paperless:/usr/src/paperless/src# ---------------------------------------------------------------------- blackbunt · 2023-12-26 18:22 okay figured it out: paperless-ngx wants a clean installation, if you have set up the docker environment like meyou specified those in your initial deployment: PAPERLESS\_ADMIN\_USER=adminPAPERLESS\_ADMIN\_PASSWORD=supersecretpass solution is a to comment them out, so the installation is really clean and no admin user is configured at first startup \#PAPERLESS\_ADMIN\_USER=admin#PAPERLESS\_ADMIN\_PASSWORD=supersecretp ass then document\_importer should work as it should :)