← ペーストに戻る›編集 / フォーク

無題のペースト

#7SYT8UR5Lhpublic / public新しいバージョン

匿名作成日 16 hours ago 失効まで 6 days 10.3 KB 構文: text

変更により、このペーストにリンクされた新しいペーストが作成されます — 元のペーストは変更されません。

新しいバージョン 変更により、このペーストにリンクされた新しいペーストが作成されます — 元のペーストは変更されません。

可視性パブリックフィードアクセス public

変更メモ (任意)

このペーストはパブリックフィードに表示されます。リンクを知っている人だけに見せたい場合は可視性を変更してください。

キャンセル

otel-collector  | 2026-10-09T06:20:23.084Z	error	postgresqlreceiver@v0.160.0/scraper.go:509	failed to explain query	{"resource": {"service.instance.id": "cc2a6c61-7530-4111-9fff-c733cbc27bb5", "service.name": "otelcol-contrib", "service.version": "0.160.0"}, "otelcol.component.id": "postgresql", "otelcol.component.kind": "receiver", "otelcol.signal": "logs", "query": "SELECT\n    COALESCE(sa.datname, $1) AS datname,\n    COALESCE(sa.usename, $2) AS usename,\n    COALESCE(sa.client_addr::TEXT, $3) AS client_addr,\n    COALESCE(sa.client_hostname, $4) AS client_hostname,\n    COALESCE(sa.client_port::TEXT, $5) AS client_port,\n    COALESCE(sa.query_start::TEXT, $6) AS query_start,\n    COALESCE(sa.wait_event_type, $7) AS wait_event_type,\n    COALESCE(sa.wait_event, $8) AS wait_event,\n    COALESCE(sa.query_id::TEXT, $9) AS query_id,\n    COALESCE(sa.pid::TEXT, $10) AS pid,\n    COALESCE(sa.application_name::TEXT, $11) AS application_name,\n    EXTRACT($12 FROM sa.query_start) AS _query_start_timestamp,\n    sa.state,\n    sa.query,\n    CASE\n    WHEN sa.state = $13 THEN\n      EXTRACT($14 FROM (clock_timestamp() - sa.query_start)) * $15\n    WHEN sa.state IN ($16 /*, ... */)\n         AND sa.state_change IS NOT NULL THEN\n      EXTRACT($17 FROM (sa.state_change - sa.query_start)) * $18\n    ELSE\n      $19\n    END AS duration_ms,\n    -- Blocking info\n    COALESCE(pg_blocking_pids(sa.pid)::TEXT, $20) AS blocking_pids,\n    CASE WHEN bl.waitstart IS NOT NULL\n         THEN to_char(bl.waitstart AT TIME ZONE $21, $22)\n         ELSE $23 END AS blocking_start_time,\n    COALESCE(EXTRACT($24 FROM (clock_timestamp() - bl.waitstart))::BIGINT, $25) AS blocking_wait_duration,\n    COALESCE(bl.mode, $26) AS blocking_lock_mode,\n    COALESCE(bl.locktype, $27) AS blocking_lock_type,\n    COALESCE(c.relname, $28) AS blocking_lock_relation,\n    CASE WHEN sa.xact_start IS NOT NULL\n         THEN to_char(sa.xact_start AT TIME ZONE $29, $30)\n         ELSE $31 END AS blocking_transaction_start\nFROM pg_stat_activity sa\nLEFT JOIN LATERAL (\n  SELECT mode, locktype, relation, waitstart\n  FROM pg_locks\n  WHERE pid = sa.pid AND NOT granted\n  ORDER BY waitstart ASC NULLS LAST\n  LIMIT $32\n) bl ON $33\nLEFT JOIN pg_class c\n  ON  c.oid = bl.relation\nWHERE\n    coalesce(\n      TRIM(sa.query),\n      $34\n    ) != $35\n    \n    AND sa.pid != pg_backend_pid()\n    \n    AND sa.query_start IS NOT NULL\n    AND NOT (\n    \n      sa.query_start < TO_TIMESTAMP($36)\n      AND sa.state = $37\n      -- Keep idle-in-transaction sessions that are blocking others\n      AND sa.pid NOT IN (\n        SELECT unnest(pg_blocking_pids(pid))\n        FROM   pg_stat_activity\n        WHERE  cardinality(pg_blocking_pids(pid)) > $38\n      )\n    )\nLIMIT $39", "error": "pq: syntax error at or near \"$12\" at position 13:13 (42601)"}
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).collectTopQuery
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:509
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).scrapeTopQuery
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:304
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.createLogsReceiver.func3
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/factory.go:150
otel-collector  | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs
otel-collector  | 	go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper.wrapObsLogs.func1
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/obs_logs.go:49
otel-collector  | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs
otel-collector  | 	go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper.scrapeLogs
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:145
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper.NewLogsController.func1
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:109
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper/internal/controller.(*Controller[...]).startScraping.func1
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/internal/controller/controller.go:122
otel-collector  | sync.(*WaitGroup).Go.func1
otel-collector  | 	sync/waitgroup.go:258
otel-collector  | 2026-10-09T06:20:23.093Z	error	postgresqlreceiver@v0.160.0/client.go:221	failed to explain statement	{"resource": {"service.instance.id": "cc2a6c61-7530-4111-9fff-c733cbc27bb5", "service.name": "otelcol-contrib", "service.version": "0.160.0"}, "otelcol.component.id": "postgresql", "otelcol.component.kind": "receiver", "otelcol.signal": "logs", "error": "pq: permission denied for table products (42501)"}
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLClient).explainQuery
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/client.go:221
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).collectTopQuery
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:507
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).scrapeTopQuery
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:304
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.createLogsReceiver.func3
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/factory.go:150
otel-collector  | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs
otel-collector  | 	go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper.wrapObsLogs.func1
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/obs_logs.go:49
otel-collector  | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs
otel-collector  | 	go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper.scrapeLogs
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:145
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper.NewLogsController.func1
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:109
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper/internal/controller.(*Controller[...]).startScraping.func1
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/internal/controller/controller.go:122
otel-collector  | sync.(*WaitGroup).Go.func1
otel-collector  | 	sync/waitgroup.go:258
otel-collector  | 2026-10-09T06:20:23.094Z	error	postgresqlreceiver@v0.160.0/scraper.go:509	failed to explain query	{"resource": {"service.instance.id": "cc2a6c61-7530-4111-9fff-c733cbc27bb5", "service.name": "otelcol-contrib", "service.version": "0.160.0"}, "otelcol.component.id": "postgresql", "otelcol.component.kind": "receiver", "otelcol.signal": "logs", "query": "INSERT INTO catalog.products (id, name, description, picture, price_currency_code, price_units, price_nanos, categories)\nVALUES\n    ($1, $2, $3, $4, $5, $6, $7, $8),\n    ($9, $10, $11, $12, $13, $14, $15, $16),\n    ($17, $18, $19, $20, $21, $22, $23, $24),\n    ($25, $26, $27, $28, $29, $30, $31, $32),\n    ($33, $34, $35, $36, $37, $38, $39, $40),\n    ($41, $42, $43, $44, $45, $46, $47, $48),\n    ($49, $50, $51, $52, $53, $54, $55, $56),\n    ($57, $58, $59, $60, $61, $62, $63, $64),\n    ($65, $66, $67, $68, $69, $70, $71, $72),\n    ($73, $74, $75, $76, $77, $78, $79, $80)", "error": "pq: permission denied for table products (42501)"}
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).collectTopQuery
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:509
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).scrapeTopQuery
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:304
otel-collector  | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.createLogsReceiver.func3
otel-collector  | 	github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/factory.go:150
otel-collector  | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs
otel-collector  | 	go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper.wrapObsLogs.func1
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/obs_logs.go:49
otel-collector  | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs
otel-collector  | 	go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper.scrapeLogs
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:145
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper.NewLogsController.func1
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:109
otel-collector  | go.opentelemetry.io/collector/scraper/scraperhelper/internal/controller.(*Controller[...]).startScraping.func1
otel-collector  | 	go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/internal/controller/controller.go:122
otel-collector  | sync.(*WaitGroup).Go.func1
otel-collector  | 	sync/waitgroup.go:258