tags: cofacts, meeting note GA: UA-98468513-3 —

20250417 會議記錄

:::info

:potable_water: Release pipeline

:rocket: Staging

:globe_with_meridians: Site

Testing checklist

http://dev.cofacts.tw/

(用手機看)

未登入下檢測：

⛔️ Release Blockers

無

未竟項目

無

:eye: Under review

CCPRIP

[Op] Automatic takedown

https://g0v.hackmd.io/@cofacts/rd/%2Fum7DyY_ESbu2LL78kLw3pg nonumpa

Moderation Doc

https://github.com/cofacts/takedowns/pull/197

## Moderation

### Review the pull request

- When the takedown bot creates a pull request:
  - If the user is confirmed as a spammer:
    - Approve the pull request
    - Merge the pull request
    - The system will automatically block the user
  - If the user is not a spammer (false positive):
    - Simply close the pull request
    - No further action needed

需要申請 coveralls badge 指定錯 branch

:::success Coming up: Article & Reply request detection :::

Langfuse update

SELECT
    database,
    `table`,
    formatReadableSize(sum(bytes_on_disk)) AS total_size
FROM system.parts
WHERE active
GROUP BY
    database,
    `table`
ORDER BY sum(bytes_on_disk) DESC

Query id: e0514dda-4e8d-427f-866d-8e7bc4397550

    ┌─database─┬─table────────────────────┬─total_size─┐
 1. │ default  │ observations             │ 12.62 MiB  │
 2. │ default  │ traces                   │ 8.72 MiB   │
 3. │ default  │ event_log                │ 4.85 MiB   │
 4. │ default  │ scores                   │ 411.61 KiB │
 5. │ system   │ metric_log               │ 152.25 KiB │
 6. │ system   │ query_metric_log         │ 137.81 KiB │
 7. │ system   │ processors_profile_log   │ 27.19 KiB  │
 8. │ system   │ query_log                │ 24.56 KiB  │
 9. │ system   │ asynchronous_metric_log  │ 16.58 KiB  │
10. │ system   │ part_log                 │ 12.26 KiB  │
11. │ system   │ trace_log                │ 9.58 KiB   │
12. │ system   │ query_views_log          │ 9.53 KiB   │
13. │ system   │ text_log_0               │ 9.06 KiB   │
14. │ system   │ asynchronous_insert_log  │ 5.14 KiB   │
15. │ default  │ project_environments     │ 1.30 KiB   │
16. │ system   │ opentelemetry_span_log_0 │ 1.09 KiB   │
17. │ system   │ error_log                │ 962.00 B   │
18. │ default  │ schema_migrations        │ 618.00 B   │
    └──────────┴──────────────────────────┴────────────┘

即使跑測試也只會有這個 error:

2025.04.17 12:26:22.604133 [ 236 ] {} void DB::SystemLog<DB::OpenTelemetrySpanLogElement>::flushImpl(const std::vector &, uint64_t) [LogElement = DB::OpenTelemetrySpanLogElement]: Failed to flush system log system.opentelemetry_span_log with 138 entries up to offset 184667: Code: 47. DB::Exception: Missing columns: 'event_time' 'event_date' while processing: 'event_date, event_time', required columns: 'event_date' 'event_time', available columns: 'attribute.size0' 'attribute.keys' 'parent_span_id' 'attribute' 'finish_time_us' 'hostname' 'finish_date' 'start_time_us' 'span_id' 'kind' 'attribute.values' 'operation_name' 'trace_id'. (UNKNOWN_IDENTIFIER), Stack trace (when copying this message, always include the lines below):

:::warning MrOrz: 要檢查 system.opentelemetry_span_log 的設定，更新 log rotation 要看的欄位名稱 :::

Deep Research & 查核回應

謠言惑眾獎

小聚 rundown

hackmd Default permission

目前是預設 owner team setting -> team notes -> Default permission

團隊公開頁 https://g0v.hackmd.io/@cofacts 顯示有 spammer 來改過 team space 的內容