Closed kuzmos closed 1 year ago
Tested using existing database and reinstalled LP from scratch (fresh database). In both cases could not reproduce the issue.
could you provide more details:
docker images | grep reallibrephotos
docker logs backend
1) It does download and extract new stuff 2)
sudo docker images | grep reallibrephotos
reallibrephotos/librephotos-frontend dev 27db54f36d5e 23 hours ago 25.1MB
reallibrephotos/librephotos dev ed5167c48070 6 days ago 7.31GB
reallibrephotos/librephotos-proxy dev 6182ba14165c 8 weeks ago 142MB
3)
sudo docker logs backend
use SECRET_KEY from env
admin
[X] 0001_initial
[X] 0002_logentry_remove_auto_add
[X] 0003_logentry_add_action_flag_choices
api
[X] 0001_initial
[X] 0002_add_confidence
[X] 0003_remove_unused_thumbs
[X] 0004_fix_album_thing_constraint
[X] 0005_add_video_to_photo
[X] 0006_migrate_to_boolean_field
[X] 0007_migrate_to_json_field
[X] 0008_remove_image_path
[X] 0009_add_clip_embedding_field
[X] 0009_add_aspect_ratio
[X] 0010_merge_20210725_1547
[X] 0011_a_add_rating
[X] 0011_b_migrate_favorited_to_rating
[X] 0011_c_remove_favorited
[X] 0012_add_favorite_min_rating
[X] 0013_add_image_scale_and_misc
[X] 0014_add_save_metadata_to_disk
[X] 0015_add_dominant_color
[X] 0016_add_transcode_videos
[X] 0017_add_cover_photo
[X] 0018_user_config_datetime_rules
[X] 0019_change_config_datetime_rules
[X] 0020_add_default_timezone
[X] 0021_remove_photo_image
[X] 0022_photo_video_length
[X] 0023_photo_deleted
[X] 0024_photo_timestamp
[X] 0025_add_cover_photo
[X] 0026_add_cluster_info
[X] 0027_rename_unknown_person
[X] 0028_add_metadata_fields
[X] 0029_change_to_text_field
[X] 0030_user_confidence_person
[X] 0031_remove_account
[X] 0032_always_have_owner
[X] 0033_add_post_delete_person
[X] 0034_allow_deleting_person
[X] 0035_add_files_model
[X] 0036_handle_missing_files
[ ] 0037_migrate_to_files
[ ] 0038_add_main_file
[ ] 0039_remove_photo_image_paths
[ ] 0040_add_user_public_sharing_flag
[ ] 0041_apply_user_enum_for_person
auth
[X] 0001_initial
[X] 0002_alter_permission_name_max_length
[X] 0003_alter_user_email_max_length
[X] 0004_alter_user_username_opts
[X] 0005_alter_user_last_login_null
[X] 0006_require_contenttypes_0002
[X] 0007_alter_validators_add_error_messages
[X] 0008_alter_user_username_max_length
[X] 0009_alter_user_last_name_max_length
[X] 0010_alter_group_name_max_length
[X] 0011_update_proxy_permissions
[X] 0012_alter_user_first_name_max_length
chunked_upload
[X] 0001_initial
contenttypes
[X] 0001_initial
[X] 0002_remove_content_type_name
database
[X] 0001_initial
[X] 0002_auto_20190129_2304
django_rq
[X] 0001_initial
sessions
[X] 0001_initial
use SECRET_KEY from env
Operations to perform:
Apply all migrations: admin, api, auth, chunked_upload, contenttypes, database, django_rq, sessions
Running migrations:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890566 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/code/manage.py", line 11, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 401, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 330, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 371, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 85, in wrapped
res = handle_func(*args, **kwargs)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/commands/migrate.py", line 243, in handle
post_migrate_state = executor.migrate(
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 227, in apply_migration
state = migration.apply(state, schema_editor)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/migration.py", line 124, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/operations/special.py", line 190, in database_forwards
self.code(from_state.apps, schema_editor)
File "/code/api/migrations/0037_migrate_to_files.py", line 27, in migrate_to_files
for photo in Photo.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890566 in pg_toast_16577
Applying api.0037_migrate_to_files...use SECRET_KEY from env
admin
[X] 0001_initial
[X] 0002_logentry_remove_auto_add
[X] 0003_logentry_add_action_flag_choices
api
[X] 0001_initial
[X] 0002_add_confidence
[X] 0003_remove_unused_thumbs
[X] 0004_fix_album_thing_constraint
[X] 0005_add_video_to_photo
[X] 0006_migrate_to_boolean_field
[X] 0007_migrate_to_json_field
[X] 0008_remove_image_path
[X] 0009_add_clip_embedding_field
[X] 0009_add_aspect_ratio
[X] 0010_merge_20210725_1547
[X] 0011_a_add_rating
[X] 0011_b_migrate_favorited_to_rating
[X] 0011_c_remove_favorited
[X] 0012_add_favorite_min_rating
[X] 0013_add_image_scale_and_misc
[X] 0014_add_save_metadata_to_disk
[X] 0015_add_dominant_color
[X] 0016_add_transcode_videos
[X] 0017_add_cover_photo
[X] 0018_user_config_datetime_rules
[X] 0019_change_config_datetime_rules
[X] 0020_add_default_timezone
[X] 0021_remove_photo_image
[X] 0022_photo_video_length
[X] 0023_photo_deleted
[X] 0024_photo_timestamp
[X] 0025_add_cover_photo
[X] 0026_add_cluster_info
[X] 0027_rename_unknown_person
[X] 0028_add_metadata_fields
[X] 0029_change_to_text_field
[X] 0030_user_confidence_person
[X] 0031_remove_account
[X] 0032_always_have_owner
[X] 0033_add_post_delete_person
[X] 0034_allow_deleting_person
[X] 0035_add_files_model
[X] 0036_handle_missing_files
[ ] 0037_migrate_to_files
[ ] 0038_add_main_file
[ ] 0039_remove_photo_image_paths
[ ] 0040_add_user_public_sharing_flag
[ ] 0041_apply_user_enum_for_person
auth
[X] 0001_initial
[X] 0002_alter_permission_name_max_length
[X] 0003_alter_user_email_max_length
[X] 0004_alter_user_username_opts
[X] 0005_alter_user_last_login_null
[X] 0006_require_contenttypes_0002
[X] 0007_alter_validators_add_error_messages
[X] 0008_alter_user_username_max_length
[X] 0009_alter_user_last_name_max_length
[X] 0010_alter_group_name_max_length
[X] 0011_update_proxy_permissions
[X] 0012_alter_user_first_name_max_length
chunked_upload
[X] 0001_initial
contenttypes
[X] 0001_initial
[X] 0002_remove_content_type_name
database
[X] 0001_initial
[X] 0002_auto_20190129_2304
django_rq
[X] 0001_initial
sessions
[X] 0001_initial
use SECRET_KEY from env
Your cache has been cleared!
use SECRET_KEY from env
Warning: ignoring provided email admin@example.com
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/code/manage.py", line 11, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 401, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 330, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 371, in execute
output = self.handle(*args, **options)
File "/code/api/management/commands/createadmin.py", line 58, in handle
admin_user = User.objects.get(username=options["admin_username"].lower())
File "/usr/local/lib/python3.10/dist-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 425, in get
num = len(clone)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 269, in __len__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
Running backend server...
production backend starting
use SECRET_KEY from env
[2023-02-05 11:13:24 +0000] [233] [INFO] Starting gunicorn 20.1.0
[2023-02-05 11:13:24 +0000] [233] [INFO] Listening at: http://0.0.0.0:8001 (233)
[2023-02-05 11:13:24 +0000] [233] [INFO] Using worker: gevent
[2023-02-05 11:13:24 +0000] [235] [INFO] Booting worker with pid: 235
[2023-02-05 11:13:24 +0000] [236] [INFO] Booting worker with pid: 236
[2023-02-05 11:13:24 +0000] [237] [INFO] Booting worker with pid: 237
[2023-02-05 11:13:24 +0000] [238] [INFO] Booting worker with pid: 238
[2023-02-05 11:13:24 +0000] [239] [INFO] Booting worker with pid: 239
[2023-02-05 11:13:24 +0000] [240] [INFO] Booting worker with pid: 240
use SECRET_KEY from env
use SECRET_KEY from env
use SECRET_KEY from env
use SECRET_KEY from env
use SECRET_KEY from env
use SECRET_KEY from env
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
11:13:28 Worker rq:worker:f6553f17270b472aaf23733cadaed5fe: started, version 1.10.1
11:13:28 Subscribing to channel rq:pubsub:f6553f17270b472aaf23733cadaed5fe
11:13:28 *** Listening on default...
11:13:28 Cleaning registries for queue: default
11:13:28 default: api.apps.build_index() (6694e188-cf1e-4151-9d85-fbd8f198ad31)
11:13:28 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
11:13:28 default: api.apps.build_index() (e9596ef8-22e5-470c-a0d0-7ec9c9693b85)
11:13:29 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
11:13:29 default: api.apps.build_index() (c2578831-3c95-458b-8f98-9ab1714b2725)
11:13:29 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
11:13:29 default: api.apps.build_index() (c8c18b33-7242-4d19-b8ec-d4a86b045f76)
11:13:29 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
11:13:29 default: api.apps.build_index() (7b5bdd6b-f593-4b15-a527-0fb11d504c8a)
11:13:29 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
11:13:29 default: api.apps.build_index() (be748432-749f-4bae-8bc1-a2c42007ae6a)
11:13:29 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
11:13:29 default: api.apps.build_index() (52a406ac-afdb-40b3-a95b-e6fb50c1d9a0)
11:13:29 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
11:13:29 default: api.apps.build_index() (74a293d0-3ee5-429b-a51b-1112dadbaac3)
11:13:29 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedColumn: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 18, in build_index
for user in User.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: column api_user.public_sharing does not exist
LINE 1: ...."datetime_rules", "api_user"."default_timezone", "api_user"...
^
11:40:29 Cleaning registries for queue: default
12:07:29 Cleaning registries for queue: default
And I think I spotted the root cause, however not sure what to do about it other than reset the DB - with all the learned faces etc... :(
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890566 in pg_toast_16577
I see that, for whatever reason, db migrations are not executed. Wonder if following answer here would solve your issue?
I've rolled back to previous snapshot on my ZFS volume to the working version of Librephotos. Executed docker-compose pull
, docker-compose up -d
, and the error appeared again, so it is not about data corruption in the database. Could the migration script be broken? What info should I provide to better debug the issue?
So I rolled back again, added the column manually: alter table api_user add column public_sharing boolean;
executed docker-compose pull
, docker-compose up -d
, and librephotos started, althought lots of complaints about corrupted data (??) in the logs which follow in the next comment. Doesn't look healthy to me, but works for now.
docker logs xxxxxx
use SECRET_KEY from env
admin
[X] 0001_initial
[X] 0002_logentry_remove_auto_add
[X] 0003_logentry_add_action_flag_choices
api
[X] 0001_initial
[X] 0002_add_confidence
[X] 0003_remove_unused_thumbs
[X] 0004_fix_album_thing_constraint
[X] 0005_add_video_to_photo
[X] 0006_migrate_to_boolean_field
[X] 0007_migrate_to_json_field
[X] 0008_remove_image_path
[X] 0009_add_clip_embedding_field
[X] 0009_add_aspect_ratio
[X] 0010_merge_20210725_1547
[X] 0011_a_add_rating
[X] 0011_b_migrate_favorited_to_rating
[X] 0011_c_remove_favorited
[X] 0012_add_favorite_min_rating
[X] 0013_add_image_scale_and_misc
[X] 0014_add_save_metadata_to_disk
[X] 0015_add_dominant_color
[X] 0016_add_transcode_videos
[X] 0017_add_cover_photo
[X] 0018_user_config_datetime_rules
[X] 0019_change_config_datetime_rules
[X] 0020_add_default_timezone
[X] 0021_remove_photo_image
[X] 0022_photo_video_length
[X] 0023_photo_deleted
[X] 0024_photo_timestamp
[X] 0025_add_cover_photo
[X] 0026_add_cluster_info
[X] 0027_rename_unknown_person
[X] 0028_add_metadata_fields
[X] 0029_change_to_text_field
[X] 0030_user_confidence_person
[X] 0031_remove_account
[X] 0032_always_have_owner
[X] 0033_add_post_delete_person
[X] 0034_allow_deleting_person
[ ] 0035_add_files_model
[ ] 0036_handle_missing_files
[ ] 0037_migrate_to_files
[ ] 0038_add_main_file
[ ] 0039_remove_photo_image_paths
[ ] 0040_add_user_public_sharing_flag
[ ] 0041_apply_user_enum_for_person
auth
[X] 0001_initial
[X] 0002_alter_permission_name_max_length
[X] 0003_alter_user_email_max_length
[X] 0004_alter_user_username_opts
[X] 0005_alter_user_last_login_null
[X] 0006_require_contenttypes_0002
[X] 0007_alter_validators_add_error_messages
[X] 0008_alter_user_username_max_length
[X] 0009_alter_user_last_name_max_length
[X] 0010_alter_group_name_max_length
[X] 0011_update_proxy_permissions
[X] 0012_alter_user_first_name_max_length
chunked_upload
[X] 0001_initial
contenttypes
[X] 0001_initial
[X] 0002_remove_content_type_name
database
[X] 0001_initial
[X] 0002_auto_20190129_2304
django_rq
[X] 0001_initial
sessions
[X] 0001_initial
use SECRET_KEY from env
Operations to perform:
Apply all migrations: admin, api, auth, chunked_upload, contenttypes, database, django_rq, sessions
Running migrations:
Applying api.0035_add_files_model... OK
Applying api.0036_handle_missing_files... OK
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890566 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/code/manage.py", line 11, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 401, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 330, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 371, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 85, in wrapped
res = handle_func(*args, **kwargs)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/commands/migrate.py", line 243, in handle
post_migrate_state = executor.migrate(
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 227, in apply_migration
state = migration.apply(state, schema_editor)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/migration.py", line 124, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/operations/special.py", line 190, in database_forwards
self.code(from_state.apps, schema_editor)
File "/code/api/migrations/0037_migrate_to_files.py", line 27, in migrate_to_files
for photo in Photo.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890566 in pg_toast_16577
Applying api.0037_migrate_to_files...use SECRET_KEY from env
admin
[X] 0001_initial
[X] 0002_logentry_remove_auto_add
[X] 0003_logentry_add_action_flag_choices
api
[X] 0001_initial
[X] 0002_add_confidence
[X] 0003_remove_unused_thumbs
[X] 0004_fix_album_thing_constraint
[X] 0005_add_video_to_photo
[X] 0006_migrate_to_boolean_field
[X] 0007_migrate_to_json_field
[X] 0008_remove_image_path
[X] 0009_add_clip_embedding_field
[X] 0009_add_aspect_ratio
[X] 0010_merge_20210725_1547
[X] 0011_a_add_rating
[X] 0011_b_migrate_favorited_to_rating
[X] 0011_c_remove_favorited
[X] 0012_add_favorite_min_rating
[X] 0013_add_image_scale_and_misc
[X] 0014_add_save_metadata_to_disk
[X] 0015_add_dominant_color
[X] 0016_add_transcode_videos
[X] 0017_add_cover_photo
[X] 0018_user_config_datetime_rules
[X] 0019_change_config_datetime_rules
[X] 0020_add_default_timezone
[X] 0021_remove_photo_image
[X] 0022_photo_video_length
[X] 0023_photo_deleted
[X] 0024_photo_timestamp
[X] 0025_add_cover_photo
[X] 0026_add_cluster_info
[X] 0027_rename_unknown_person
[X] 0028_add_metadata_fields
[X] 0029_change_to_text_field
[X] 0030_user_confidence_person
[X] 0031_remove_account
[X] 0032_always_have_owner
[X] 0033_add_post_delete_person
[X] 0034_allow_deleting_person
[X] 0035_add_files_model
[X] 0036_handle_missing_files
[ ] 0037_migrate_to_files
[ ] 0038_add_main_file
[ ] 0039_remove_photo_image_paths
[ ] 0040_add_user_public_sharing_flag
[ ] 0041_apply_user_enum_for_person
auth
[X] 0001_initial
[X] 0002_alter_permission_name_max_length
[X] 0003_alter_user_email_max_length
[X] 0004_alter_user_username_opts
[X] 0005_alter_user_last_login_null
[X] 0006_require_contenttypes_0002
[X] 0007_alter_validators_add_error_messages
[X] 0008_alter_user_username_max_length
[X] 0009_alter_user_last_name_max_length
[X] 0010_alter_group_name_max_length
[X] 0011_update_proxy_permissions
[X] 0012_alter_user_first_name_max_length
chunked_upload
[X] 0001_initial
contenttypes
[X] 0001_initial
[X] 0002_remove_content_type_name
database
[X] 0001_initial
[X] 0002_auto_20190129_2304
django_rq
[X] 0001_initial
sessions
[X] 0001_initial
use SECRET_KEY from env
Your cache has been cleared!
use SECRET_KEY from env
Warning: ignoring provided email admin@example.com
Running backend server...
production backend starting
use SECRET_KEY from env
[2023-02-11 13:46:32 +0000] [277] [INFO] Starting gunicorn 20.1.0
[2023-02-11 13:46:32 +0000] [277] [INFO] Listening at: http://0.0.0.0:8001 (277)
[2023-02-11 13:46:32 +0000] [277] [INFO] Using worker: gevent
[2023-02-11 13:46:32 +0000] [279] [INFO] Booting worker with pid: 279
[2023-02-11 13:46:32 +0000] [280] [INFO] Booting worker with pid: 280
[2023-02-11 13:46:32 +0000] [281] [INFO] Booting worker with pid: 281
[2023-02-11 13:46:32 +0000] [282] [INFO] Booting worker with pid: 282
use SECRET_KEY from env
[2023-02-11 13:46:32 +0000] [298] [INFO] Booting worker with pid: 298
use SECRET_KEY from env
[2023-02-11 13:46:32 +0000] [299] [INFO] Booting worker with pid: 299
use SECRET_KEY from env
use SECRET_KEY from env
use SECRET_KEY from env
use SECRET_KEY from env
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
13:46:36 Worker rq:worker:02baab5e9c414ae89da0214626f823b6: started, version 1.10.1
13:46:36 Subscribing to channel rq:pubsub:02baab5e9c414ae89da0214626f823b6
13:46:36 *** Listening on default...
13:46:36 Cleaning registries for queue: default
13:46:36 default: api.apps.build_index() (fb1aecf9-945d-4516-8972-b66de7c32045)
127.0.0.1 - - [2023-02-11 13:46:36] "POST /build/ HTTP/1.1" 200 139 0.001347
127.0.0.1 - - [2023-02-11 13:46:36] "POST /build/ HTTP/1.1" 200 139 0.000841
127.0.0.1 - - [2023-02-11 13:46:42] "POST /build/ HTTP/1.1" 200 142 1.375528
127.0.0.1 - - [2023-02-11 13:46:48] "POST /build/ HTTP/1.1" 200 142 1.267329
127.0.0.1 - - [2023-02-11 13:46:53] "POST /build/ HTTP/1.1" 200 142 1.311563
13:46:53 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
13:46:54 default: api.apps.build_index() (3a9aff96-ee09-472b-a86d-93e606e097c4)
127.0.0.1 - - [2023-02-11 13:46:54] "POST /build/ HTTP/1.1" 200 139 0.000967
127.0.0.1 - - [2023-02-11 13:46:54] "POST /build/ HTTP/1.1" 200 139 0.000777
127.0.0.1 - - [2023-02-11 13:46:59] "POST /build/ HTTP/1.1" 200 142 1.193675
127.0.0.1 - - [2023-02-11 13:47:04] "POST /build/ HTTP/1.1" 200 142 1.219846
127.0.0.1 - - [2023-02-11 13:47:10] "POST /build/ HTTP/1.1" 200 142 1.200292
13:47:10 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
13:47:10 default: api.apps.build_index() (c0853184-7ac4-4f3d-bdce-d471b2b1a292)
127.0.0.1 - - [2023-02-11 13:47:10] "POST /build/ HTTP/1.1" 200 139 0.000952
127.0.0.1 - - [2023-02-11 13:47:10] "POST /build/ HTTP/1.1" 200 139 0.000774
127.0.0.1 - - [2023-02-11 13:47:15] "POST /build/ HTTP/1.1" 200 142 1.203337
dbadmin@dagobah:~/librephotos$ sudo docker logs 0fb94d60dfac
use SECRET_KEY from env
admin
[X] 0001_initial
[X] 0002_logentry_remove_auto_add
[X] 0003_logentry_add_action_flag_choices
api
[X] 0001_initial
[X] 0002_add_confidence
[X] 0003_remove_unused_thumbs
[X] 0004_fix_album_thing_constraint
[X] 0005_add_video_to_photo
[X] 0006_migrate_to_boolean_field
[X] 0007_migrate_to_json_field
[X] 0008_remove_image_path
[X] 0009_add_clip_embedding_field
[X] 0009_add_aspect_ratio
[X] 0010_merge_20210725_1547
[X] 0011_a_add_rating
[X] 0011_b_migrate_favorited_to_rating
[X] 0011_c_remove_favorited
[X] 0012_add_favorite_min_rating
[X] 0013_add_image_scale_and_misc
[X] 0014_add_save_metadata_to_disk
[X] 0015_add_dominant_color
[X] 0016_add_transcode_videos
[X] 0017_add_cover_photo
[X] 0018_user_config_datetime_rules
[X] 0019_change_config_datetime_rules
[X] 0020_add_default_timezone
[X] 0021_remove_photo_image
[X] 0022_photo_video_length
[X] 0023_photo_deleted
[X] 0024_photo_timestamp
[X] 0025_add_cover_photo
[X] 0026_add_cluster_info
[X] 0027_rename_unknown_person
[X] 0028_add_metadata_fields
[X] 0029_change_to_text_field
[X] 0030_user_confidence_person
[X] 0031_remove_account
[X] 0032_always_have_owner
[X] 0033_add_post_delete_person
[X] 0034_allow_deleting_person
[ ] 0035_add_files_model
[ ] 0036_handle_missing_files
[ ] 0037_migrate_to_files
[ ] 0038_add_main_file
[ ] 0039_remove_photo_image_paths
[ ] 0040_add_user_public_sharing_flag
[ ] 0041_apply_user_enum_for_person
auth
[X] 0001_initial
[X] 0002_alter_permission_name_max_length
[X] 0003_alter_user_email_max_length
[X] 0004_alter_user_username_opts
[X] 0005_alter_user_last_login_null
[X] 0006_require_contenttypes_0002
[X] 0007_alter_validators_add_error_messages
[X] 0008_alter_user_username_max_length
[X] 0009_alter_user_last_name_max_length
[X] 0010_alter_group_name_max_length
[X] 0011_update_proxy_permissions
[X] 0012_alter_user_first_name_max_length
chunked_upload
[X] 0001_initial
contenttypes
[X] 0001_initial
[X] 0002_remove_content_type_name
database
[X] 0001_initial
[X] 0002_auto_20190129_2304
django_rq
[X] 0001_initial
sessions
[X] 0001_initial
use SECRET_KEY from env
Operations to perform:
Apply all migrations: admin, api, auth, chunked_upload, contenttypes, database, django_rq, sessions
Running migrations:
Applying api.0035_add_files_model... OK
Applying api.0036_handle_missing_files... OK
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890566 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/code/manage.py", line 11, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 401, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python3.10/dist-packages/django/core/management/__init__.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 330, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 371, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/base.py", line 85, in wrapped
res = handle_func(*args, **kwargs)
File "/usr/local/lib/python3.10/dist-packages/django/core/management/commands/migrate.py", line 243, in handle
post_migrate_state = executor.migrate(
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/executor.py", line 227, in apply_migration
state = migration.apply(state, schema_editor)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/migration.py", line 124, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/usr/local/lib/python3.10/dist-packages/django/db/migrations/operations/special.py", line 190, in database_forwards
self.code(from_state.apps, schema_editor)
File "/code/api/migrations/0037_migrate_to_files.py", line 27, in migrate_to_files
for photo in Photo.objects.all():
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890566 in pg_toast_16577
Applying api.0037_migrate_to_files...use SECRET_KEY from env
admin
[X] 0001_initial
[X] 0002_logentry_remove_auto_add
[X] 0003_logentry_add_action_flag_choices
api
[X] 0001_initial
[X] 0002_add_confidence
[X] 0003_remove_unused_thumbs
[X] 0004_fix_album_thing_constraint
[X] 0005_add_video_to_photo
[X] 0006_migrate_to_boolean_field
[X] 0007_migrate_to_json_field
[X] 0008_remove_image_path
[X] 0009_add_clip_embedding_field
[X] 0009_add_aspect_ratio
[X] 0010_merge_20210725_1547
[X] 0011_a_add_rating
[X] 0011_b_migrate_favorited_to_rating
[X] 0011_c_remove_favorited
[X] 0012_add_favorite_min_rating
[X] 0013_add_image_scale_and_misc
[X] 0014_add_save_metadata_to_disk
[X] 0015_add_dominant_color
[X] 0016_add_transcode_videos
[X] 0017_add_cover_photo
[X] 0018_user_config_datetime_rules
[X] 0019_change_config_datetime_rules
[X] 0020_add_default_timezone
[X] 0021_remove_photo_image
[X] 0022_photo_video_length
[X] 0023_photo_deleted
[X] 0024_photo_timestamp
[X] 0025_add_cover_photo
[X] 0026_add_cluster_info
[X] 0027_rename_unknown_person
[X] 0028_add_metadata_fields
[X] 0029_change_to_text_field
[X] 0030_user_confidence_person
[X] 0031_remove_account
[X] 0032_always_have_owner
[X] 0033_add_post_delete_person
[X] 0034_allow_deleting_person
[X] 0035_add_files_model
[X] 0036_handle_missing_files
[ ] 0037_migrate_to_files
[ ] 0038_add_main_file
[ ] 0039_remove_photo_image_paths
[ ] 0040_add_user_public_sharing_flag
[ ] 0041_apply_user_enum_for_person
auth
[X] 0001_initial
[X] 0002_alter_permission_name_max_length
[X] 0003_alter_user_email_max_length
[X] 0004_alter_user_username_opts
[X] 0005_alter_user_last_login_null
[X] 0006_require_contenttypes_0002
[X] 0007_alter_validators_add_error_messages
[X] 0008_alter_user_username_max_length
[X] 0009_alter_user_last_name_max_length
[X] 0010_alter_group_name_max_length
[X] 0011_update_proxy_permissions
[X] 0012_alter_user_first_name_max_length
chunked_upload
[X] 0001_initial
contenttypes
[X] 0001_initial
[X] 0002_remove_content_type_name
database
[X] 0001_initial
[X] 0002_auto_20190129_2304
django_rq
[X] 0001_initial
sessions
[X] 0001_initial
use SECRET_KEY from env
Your cache has been cleared!
use SECRET_KEY from env
Warning: ignoring provided email admin@example.com
Running backend server...
production backend starting
use SECRET_KEY from env
[2023-02-11 13:46:32 +0000] [277] [INFO] Starting gunicorn 20.1.0
[2023-02-11 13:46:32 +0000] [277] [INFO] Listening at: http://0.0.0.0:8001 (277)
[2023-02-11 13:46:32 +0000] [277] [INFO] Using worker: gevent
[2023-02-11 13:46:32 +0000] [279] [INFO] Booting worker with pid: 279
[2023-02-11 13:46:32 +0000] [280] [INFO] Booting worker with pid: 280
[2023-02-11 13:46:32 +0000] [281] [INFO] Booting worker with pid: 281
[2023-02-11 13:46:32 +0000] [282] [INFO] Booting worker with pid: 282
use SECRET_KEY from env
[2023-02-11 13:46:32 +0000] [298] [INFO] Booting worker with pid: 298
use SECRET_KEY from env
[2023-02-11 13:46:32 +0000] [299] [INFO] Booting worker with pid: 299
use SECRET_KEY from env
use SECRET_KEY from env
use SECRET_KEY from env
use SECRET_KEY from env
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float64'> type is zero.
return self._float_to_str(self.smallest_subnormal)
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:500: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
setattr(self, word, getattr(machar, word).flat[0])
/usr/local/lib/python3.10/dist-packages/numpy/core/getlimits.py:89: UserWarning: The value of the smallest subnormal for <class 'numpy.float32'> type is zero.
return self._float_to_str(self.smallest_subnormal)
13:46:36 Worker rq:worker:02baab5e9c414ae89da0214626f823b6: started, version 1.10.1
13:46:36 Subscribing to channel rq:pubsub:02baab5e9c414ae89da0214626f823b6
13:46:36 *** Listening on default...
13:46:36 Cleaning registries for queue: default
13:46:36 default: api.apps.build_index() (fb1aecf9-945d-4516-8972-b66de7c32045)
127.0.0.1 - - [2023-02-11 13:46:36] "POST /build/ HTTP/1.1" 200 139 0.001347
127.0.0.1 - - [2023-02-11 13:46:36] "POST /build/ HTTP/1.1" 200 139 0.000841
127.0.0.1 - - [2023-02-11 13:46:42] "POST /build/ HTTP/1.1" 200 142 1.375528
127.0.0.1 - - [2023-02-11 13:46:48] "POST /build/ HTTP/1.1" 200 142 1.267329
127.0.0.1 - - [2023-02-11 13:46:53] "POST /build/ HTTP/1.1" 200 142 1.311563
13:46:53 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
13:46:54 default: api.apps.build_index() (3a9aff96-ee09-472b-a86d-93e606e097c4)
127.0.0.1 - - [2023-02-11 13:46:54] "POST /build/ HTTP/1.1" 200 139 0.000967
127.0.0.1 - - [2023-02-11 13:46:54] "POST /build/ HTTP/1.1" 200 139 0.000777
127.0.0.1 - - [2023-02-11 13:46:59] "POST /build/ HTTP/1.1" 200 142 1.193675
127.0.0.1 - - [2023-02-11 13:47:04] "POST /build/ HTTP/1.1" 200 142 1.219846
127.0.0.1 - - [2023-02-11 13:47:10] "POST /build/ HTTP/1.1" 200 142 1.200292
13:47:10 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
13:47:10 default: api.apps.build_index() (c0853184-7ac4-4f3d-bdce-d471b2b1a292)
127.0.0.1 - - [2023-02-11 13:47:10] "POST /build/ HTTP/1.1" 200 139 0.000952
127.0.0.1 - - [2023-02-11 13:47:10] "POST /build/ HTTP/1.1" 200 139 0.000774
127.0.0.1 - - [2023-02-11 13:47:15] "POST /build/ HTTP/1.1" 200 142 1.203337
127.0.0.1 - - [2023-02-11 13:47:21] "POST /build/ HTTP/1.1" 200 142 1.193973
127.0.0.1 - - [2023-02-11 13:47:26] "POST /build/ HTTP/1.1" 200 142 1.197248
13:47:26 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
13:47:26 default: api.apps.build_index() (f890a650-0601-4440-ab53-793ae86f77af)
127.0.0.1 - - [2023-02-11 13:47:26] "POST /build/ HTTP/1.1" 200 139 0.000904
127.0.0.1 - - [2023-02-11 13:47:26] "POST /build/ HTTP/1.1" 200 139 0.000690
127.0.0.1 - - [2023-02-11 13:47:32] "POST /build/ HTTP/1.1" 200 142 1.208081
127.0.0.1 - - [2023-02-11 13:47:37] "POST /build/ HTTP/1.1" 200 142 1.197741
127.0.0.1 - - [2023-02-11 13:47:43] "POST /build/ HTTP/1.1" 200 142 1.208272
13:47:43 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
13:47:43 default: api.apps.build_index() (c29fa0b5-a7ff-41cb-9c75-38324e73ea31)
127.0.0.1 - - [2023-02-11 13:47:43] "POST /build/ HTTP/1.1" 200 139 0.000924
127.0.0.1 - - [2023-02-11 13:47:43] "POST /build/ HTTP/1.1" 200 139 0.000743
127.0.0.1 - - [2023-02-11 13:47:48] "POST /build/ HTTP/1.1" 200 142 1.194873
127.0.0.1 - - [2023-02-11 13:47:53] "POST /build/ HTTP/1.1" 200 142 1.200100
127.0.0.1 - - [2023-02-11 13:47:59] "POST /build/ HTTP/1.1" 200 142 1.195740
13:47:59 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
13:47:59 default: api.apps.build_index() (9ce49822-f6cb-4536-8eee-90ab514f712d)
127.0.0.1 - - [2023-02-11 13:47:59] "POST /build/ HTTP/1.1" 200 139 0.000937
127.0.0.1 - - [2023-02-11 13:47:59] "POST /build/ HTTP/1.1" 200 139 0.000762
127.0.0.1 - - [2023-02-11 13:48:04] "POST /build/ HTTP/1.1" 200 142 1.199211
127.0.0.1 - - [2023-02-11 13:48:10] "POST /build/ HTTP/1.1" 200 142 1.220847
127.0.0.1 - - [2023-02-11 13:48:15] "POST /build/ HTTP/1.1" 200 142 1.196812
13:48:15 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
13:48:15 default: api.apps.build_index() (54b0dc25-a0d5-4201-b7c2-ad78d9b4d70b)
127.0.0.1 - - [2023-02-11 13:48:15] "POST /build/ HTTP/1.1" 200 139 0.000901
127.0.0.1 - - [2023-02-11 13:48:15] "POST /build/ HTTP/1.1" 200 139 0.000788
127.0.0.1 - - [2023-02-11 13:48:21] "POST /build/ HTTP/1.1" 200 142 1.202321
127.0.0.1 - - [2023-02-11 13:48:26] "POST /build/ HTTP/1.1" 200 142 1.191333
127.0.0.1 - - [2023-02-11 13:48:32] "POST /build/ HTTP/1.1" 200 142 1.214266
13:48:32 Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.DataCorrupted: missing chunk number 0 for toast value 34890536 in pg_toast_16577
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/rq/worker.py", line 1061, in perform_job
rv = job.perform()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 821, in perform
self._result = self._execute()
File "/usr/local/lib/python3.10/dist-packages/rq/job.py", line 844, in _execute
result = self.func(*self.args, **self.kwargs)
File "/code/api/apps.py", line 19, in build_index
build_image_similarity_index(user)
File "/code/api/image_similarity.py", line 78, in build_image_similarity_index
for photo in paginator.page(page).object_list:
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 287, in __iter__
self._fetch_all()
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/usr/local/lib/python3.10/dist-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/usr/local/lib/python3.10/dist-packages/django/db/models/sql/compiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/usr/local/lib/python3.10/dist-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.10/dist-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.InternalError: missing chunk number 0 for toast value 34890536 in pg_toast_16577
13:48:32 default: api.apps.build_index() (cf644305-e4f0-4749-b547-9ee05f852609)
127.0.0.1 - - [2023-02-11 13:48:32] "POST /build/ HTTP/1.1" 200 139 0.000980
127.0.0.1 - - [2023-02-11 13:48:32] "POST /build/ HTTP/1.1" 200 139 0.000848
127.0.0.1 - - [2023-02-11 13:48:37] "POST /build/ HTTP/1.1" 200 142 1.192021
127.0.0.1 - - [2023-02-11 13:48:42] "POST /build/ HTTP/1.1" 200 142 1.190184
I deleted the whole data
dir and scanned the photos anew. It looks to me that the issue was caused by the DB corruption, which subsequently lead to inability to execute migration scripts.
When Submitting please remove every thing above this line
π Bug Report
log
files - relevant output fromcommand_createadmin.log
includedπ Description of issue:
π How can we reproduce it:
Please provide additional information:
π» Operating system:
β Architecture (x86 or ARM): x86
π’ Librephotos version: latest
πΈ Librephotos installation method (Docker, Kubernetes, .deb, etc.): docker
π How is you picture library mounted (Local file system (Type), NFS, SMB, etc.): SMB
β If you are virtualizing librephotos, Virtualization platform (Proxmox, Xen, HyperV, etc.): bhyve on TrueNAS