Re-Snapshot button is failing with core.models.Snapshot.DoesNotExist: Snapshot matching query does not exist

[pirate]

Discussed in #1340

^{Originally posted by gerroon January 31, 2024}

0.7.3
ArchiveBox v0.7.3+editable COMMIT_HASH=a4bd441 BUILD_TIME=2024-01-31 10:01:56 1706695316
IN_DOCKER=True IN_QEMU=False ARCH=x86_64 OS=Linux PLATFORM=Linux-5.14.0-4-amd64-x86_64-with-glibc2.36 PYTHON=Cpython
FS_ATOMIC=True FS_REMOTE=True FS_USER=1000:1000 FS_PERMS=644
DEBUG=False IS_TTY=True TZ=UTC SEARCH_BACKEND=sonic LDAP=False

[i] Dependency versions:
 √  PYTHON_BINARY         v3.11.7         valid     /usr/local/bin/python3.11
 √  SQLITE_BINARY         v2.6.0          valid     /usr/local/lib/python3.11/sqlite3/dbapi2.py
 √  DJANGO_BINARY         v3.1.14         valid     /usr/local/lib/python3.11/site-packages/django/__init__.py
 √  ARCHIVEBOX_BINARY     v0.7.3          valid     /usr/local/bin/archivebox

 √  CURL_BINARY           v8.5.0          valid     /usr/bin/curl
 √  WGET_BINARY           v1.21.3         valid     /usr/bin/wget
 √  NODE_BINARY           v20.11.0        valid     /usr/bin/node
 √  SINGLEFILE_BINARY     v1.1.46         valid     /app/node_modules/single-file-cli/single-file
 √  READABILITY_BINARY    v0.0.11         valid     /app/node_modules/readability-extractor/readability-extractor
 √  MERCURY_BINARY        v1.0.0          valid     /app/node_modules/@postlight/parser/cli.js
────GIT_BINARY            v2.39.2         valid     /usr/bin/git
 √  YOUTUBEDL_BINARY      v2023.12.30     valid     /usr/local/bin/yt-dlp
 √  CHROME_BINARY         v121.0.6167.57  valid     /usr/bin/chromium-browser
 √  RIPGREP_BINARY        v13.0.0         valid     /usr/bin/rg

[i] Source-code locations:
 √  PACKAGE_DIR           23 files        valid     /app/archivebox
 √  TEMPLATES_DIR         3 files         valid     /app/archivebox/templates
 -  CUSTOM_TEMPLATES_DIR  -               disabled  None

[i] Secrets locations:
 -  CHROME_USER_DATA_DIR  -               disabled  None
 -  COOKIES_FILE          -               disabled  None

[i] Data locations:
 √  OUTPUT_DIR            11 files @      valid     /data
 √  SOURCES_DIR           532 files       valid     ./sources
 √  LOGS_DIR              1 files         valid     ./logs
 √  ARCHIVE_DIR           382 files       valid     ./archive
 √  CONFIG_FILE           554.0 Bytes     valid     ./ArchiveBox.conf
 √  SQL_INDEX             4.4 MB          valid     ./index.sqlite3

archivebox_1  | [*] [2024-01-31 22:46:18] Writing 1 links to main index...
archivebox_1  | Internal Server Error: /admin/core/snapshot/
archivebox_1  | Traceback (most recent call last):
archivebox_1  |   File "/app/archivebox/index/sql.py", line 48, in write_link_to_sql_index
archivebox_1  |     info["timestamp"] = Snapshot.objects.get(url=link.url).timestamp
archivebox_1  |                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    ivebox_1  |   File "/usr/local/lib/python3.11/site-packages/django/db/models/manager.py", line 85, in manager_method
    ivebox_1  |     return getattr(self.get_queryset(), name)(*args, **kwargs)
    ivebox_1  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
archivebox_1  |   File "/usr/local/lib/python3.11/site-packages/django/db/models/query.py", line 429, in get
archivebox_1  |     raise self.model.DoesNotExist(
    ivebox_1  | core.models.Snapshot.DoesNotExist: Snapshot matching query does not exist.
    ivebox_1  |
    ivebox_1  | During handling of the above exception, another exception occurred:
archivebox_1  |
archivebox_1  | Traceback (most recent call last):
    ivebox_1  |   File "/usr/local/lib/python3.11/site-packages/django/db/models/query.py", line 589, in update_or_create
    ivebox_1  |     obj = self.select_for_update().get(**kwargs)
    ivebox_1  |           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
archivebox_1  |   File "/usr/local/lib/python3.11/site-packages/django/db/models/query.py", line 429, in get
archivebox_1  |     raise self.model.DoesNotExist(
    ivebox_1  | core.models.Snapshot.DoesNotExist: Snapshot matching query does not exist.
    ivebox_1  |
    ivebox_1  | During handling of the above exception, another exception occurred:
archivebox_1  |
archivebox_1  | Traceback (most recent call last):
    ivebox_1  |   File "/usr/local/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute
    ivebox_1  |     return self.cursor.execute(sql, params)
    ivebox_1  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
archivebox_1  |   File "/usr/local/lib/python3.11/site-packages/django/db/backends/sqlite3/base.py", line 413, in execute
archivebox_1  |     return Database.Cursor.execute(self, query, params)
    ivebox_1  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    ivebox_1  | sqlite3.OperationalError: database is locked
    ivebox_1  |
    ivebox_1  | The above exception was the direct cause of the following exception:
    ivebox_1  |
    ivebox_1  | Traceback (most recent call last):
    ivebox_1  |   File "/usr/local/lib/python3.11/site-packages/django/core/handlers/exception.py", line 47, in inner
    ivebox_1  |     response = get_response(request)
    ivebox_1  |                ^^^^^^^^^^^^^^^^^^^^^
    ivebox_1  |   File "/usr/local/lib/python3.11/site-packages/django/core/handlers/base.py", line 181, in _get_response
    ivebox_1  |     response = wrapped_callback(request, *callback_args, **callback_kwargs)
    ivebox_1  |                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    ivebox_1  |   File "/usr/local/lib/python3.11/site-packages/django/contrib/admin/options.py", line 614, in wrapper
    ivebox_1  |     return self.admin_site.admin_view(view)(*args, **kwargs)
    ivebox_1  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
              [t  File "/usr/local/lib/python3.11/site-packages/django/utils/decorators.py", line 130, in _wrapped_view

```</div>