date: 2026-10-30T04:32:50Z  commit: 81dd816
$ docker compose ps --format '{{.Service}} {{.Status}} {{.Ports}}'
api Up 18 seconds (healthy) 
api Up 18 seconds (healthy) 
lb Up 29 seconds (healthy) 127.0.0.1:18084->8080/tcp, 127.0.0.1:24084->8404/tcp
migrate Exited (0) 28 seconds ago 
postgres Up 30 seconds (healthy) 
s3 Up 30 seconds (healthy) 
s3-init Exited (0) 24 seconds ago 
valkey Up 30 seconds (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   |    16 |           264
 pending |     1 |           264
(2 rows)

$ rc object list --recursive root/messenger-attachments/attachments/ | count
16
$ rc object list root/messenger-attachments/ (первые 3 объекта, ключи назначены сервером)
[2026-10-30 04:29:04] 109.20 KiB attachments/01a18b11-8813-7355-a90c-65a4532e2480
[2026-10-30 04:29:08] 109.20 KiB attachments/01a18b11-97b6-7641-a82b-06b56dc04f0c
[2026-10-30 04:29:15] 109.20 KiB attachments/01a18b11-b2c9-7385-a99d-aa018f1053cb
$ сверка вне API: sha256 и размер последнего ready-вложения в PostgreSQL против байтов объекта в bucket
postgres: 99ea7533c441f79cd630d15ce4d58d1ec4e06f6f0efb3b77a5c088305cd1bd75 111817
s3:       99ea7533c441f79cd630d15ce4d58d1ec4e06f6f0efb3b77a5c088305cd1bd75 111817
$ docker inspect api: ReadonlyRootfs, tmpfs, volumes/bind mounts
0cc3ee358e59 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 
899a952a5a21 ro=true tmpfs={"/tmp":""} mounts=bind:/run/secrets/cursor_secret bind:/run/secrets/s3_access_key_id bind:/run/secrets/s3_secret_access_key bind:/run/secrets/database_url bind:/run/secrets/cache_url 
$ docker inspect s3: volume данных
volume:mtusi2026lab4_s3data:/data bind::/run/secrets/s3_root_user bind::/run/secrets/s3_root_password 
$ секреты сервисов: 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_root_password', 's3_root_user', 's3_secret_access_key']
valkey ['valkey.conf']
