date: 2026-11-05T22:59:45Z  commit: 763b0255575366082c4c6731b54611af717685a5
$ docker compose ps --format '{{.Service}} {{.Status}} {{.Ports}}'
api Up About a minute (healthy) 
api Up 50 seconds (healthy) 
lb Up About a minute (healthy) 127.0.0.1:18084->8080/tcp, 127.0.0.1:24844->8404/tcp
migrate Exited (0) About a minute ago 
postgres Up About a minute (healthy) 
s3 Up 23 seconds (healthy) 
s3-init Exited (0) About a minute ago 
valkey Up About a minute (healthy) 
$ psql -c '\d attachments'
                          Table "public.attachments"
      Column       |           Type           | Collation | Nullable | Default 
-------------------+--------------------------+-----------+----------+---------
 id                | uuid                     |           | not null | 
 chat_id           | uuid                     |           | not null | 
 owner_id          | uuid                     |           | not null | 
 filename          | text                     |           | not null | 
 content_type      | text                     |           | not null | 
 size_bytes        | bigint                   |           | not null | 
 sha256            | text                     |           | not null | 
 width             | integer                  |           | not null | 
 height            | integer                  |           | not null | 
 object_key        | text                     | C         | not null | 
 status            | text                     |           | not null | 
 created_at        | timestamp with time zone |           | not null | 
 updated_at        | timestamp with time zone |           | not null | 
 quarantine_reason | text                     |           |          | 
 quarantined_at    | timestamp with time zone |           |          | 
Indexes:
    "attachments_pkey" PRIMARY KEY, btree (id)
    "attachments_chat_key" UNIQUE CONSTRAINT, btree (id, chat_id)
    "attachments_object_key_key" UNIQUE CONSTRAINT, btree (object_key)
    "attachments_pending_idx" btree (created_at) WHERE status = 'pending'::text
Check constraints:
    "attachments_content_type_check" CHECK (content_type = ANY (ARRAY['image/png'::text, 'image/jpeg'::text]))
    "attachments_filename_check" CHECK (char_length(filename) >= 1 AND char_length(filename) <= 255)
    "attachments_height_check" CHECK (height > 0)
    "attachments_quarantine_check" CHECK ((quarantine_reason IS NULL) = (quarantined_at IS NULL))
    "attachments_quarantine_reason_check" CHECK (quarantine_reason = ANY (ARRAY['missing'::text, 'size_mismatch'::text, 'sha_mismatch'::text]))
    "attachments_sha256_check" CHECK (sha256 ~ '^[0-9a-f]{64}$'::text)
    "attachments_size_bytes_check" CHECK (size_bytes >= 1 AND size_bytes <= 10485760)
    "attachments_status_check" CHECK (status = ANY (ARRAY['pending'::text, 'ready'::text]))
    "attachments_width_check" CHECK (width > 0)
Foreign-key constraints:
    "attachments_owner_fkey" FOREIGN KEY (chat_id, owner_id) REFERENCES chat_members(chat_id, user_id)
Referenced by:
    TABLE "message_attachments" CONSTRAINT "message_attachments_attachment_fkey" FOREIGN KEY (attachment_id, chat_id) REFERENCES attachments(id, chat_id) ON DELETE RESTRICT

$ psql -c '\d message_attachments'
            Table "public.message_attachments"
    Column     |   Type   | Collation | Nullable | Default 
---------------+----------+-----------+----------+---------
 message_id    | uuid     |           | not null | 
 position      | smallint |           | not null | 
 chat_id       | uuid     |           | not null | 
 attachment_id | uuid     |           | not null | 
Indexes:
    "message_attachments_pkey" PRIMARY KEY, btree (message_id, "position")
    "message_attachments_attachment_idx" btree (attachment_id)
    "message_attachments_message_id_attachment_id_key" UNIQUE CONSTRAINT, btree (message_id, attachment_id)
Check constraints:
    "message_attachments_position_check" CHECK ("position" >= 0 AND "position" <= 9)
Foreign-key constraints:
    "message_attachments_attachment_fkey" FOREIGN KEY (attachment_id, chat_id) REFERENCES attachments(id, chat_id) ON DELETE RESTRICT
    "message_attachments_message_id_fkey" FOREIGN KEY (message_id) REFERENCES messages(id) ON DELETE CASCADE

$ psql: столбцы bytea во всей схеме (хеши токенов и отпечатки, не файлы)
    table_name    | column_name 
------------------+-------------
 idempotency_keys | fingerprint
 sessions         | token_hash
(2 rows)

$ psql: вложения по статусу и максимальный размер строки attachments
 status  | count | max_row_bytes 
---------+-------+---------------
 ready   |    10 |           264
 pending |     3 |           264
(2 rows)

$ rc object list --recursive root/messenger-attachments/attachments/ | count
10
$ rc object list root/messenger-attachments/ (первые 3 объекта, ключи назначены сервером)
[2026-11-05 22:58:21] 109.20 KiB attachments/01a1adef-432f-74b3-9212-2983a33641cd
[2026-11-05 22:58:21] 109.20 KiB attachments/01a1adef-45b4-753d-a583-15cfdd598dd2
[2026-11-05 22:58:34] 109.20 KiB attachments/01a1adef-788a-7696-bc0a-77207d3a287a
$ сверка вне API: sha256 и размер последнего ready-вложения в PostgreSQL против байтов объекта в bucket
postgres: 99ea7533c441f79cd630d15ce4d58d1ec4e06f6f0efb3b77a5c088305cd1bd75 111817
s3:       99ea7533c441f79cd630d15ce4d58d1ec4e06f6f0efb3b77a5c088305cd1bd75 111817
$ docker inspect api: ReadonlyRootfs, tmpfs, volumes/bind mounts
cff4a17e0883 ro=true tmpfs={"/tmp":""} mounts=bind:/run/secrets/cache_url bind:/run/secrets/cursor_secret bind:/run/secrets/s3_access_key_id bind:/run/secrets/s3_secret_access_key bind:/run/secrets/database_url 
f2e1260f6803 ro=true tmpfs={"/tmp":""} mounts=bind:/run/secrets/s3_secret_access_key bind:/run/secrets/database_url bind:/run/secrets/cache_url bind:/run/secrets/cursor_secret bind:/run/secrets/s3_access_key_id 
$ docker inspect s3: volume данных
volume:hlpipe-lab4-grades-20261106_s3data:/data bind::/run/secrets/s3_root_password bind::/run/secrets/s3_root_user 
$ секреты сервисов: root-ключи S3 только у s3/s3-init/s3-cli
api ['cache_url', 'cursor_secret', 'database_url', 's3_access_key_id', 's3_secret_access_key']
lb []
migrate ['database_url']
postgres ['postgres_password']
s3 ['s3_root_password', 's3_root_user']
s3-init ['s3_access_key_id', 's3_reconciler_access_key_id', 's3_reconciler_secret_access_key', 's3_root_password', 's3_root_user', 's3_secret_access_key']
valkey ['valkey.conf']
