← retour au collage›Modifier / dupliquer

Collage sans titre

#7SYT8UR5Lhpublic / publicnouvelle version

anonyme créé 16 hours ago Expire dans 6 days 10.3 KB syntaxe: text

Vos changements créent un nouveau collage lié à celui-ci — l’original reste intact.

nouvelle version Vos changements créent un nouveau collage lié à celui-ci — l’original reste intact.

Visibilité Fil public Accès public

Note de changement (facultatif)

Ce collage sera affiché dans le fil public. Changez la visibilité si vous voulez seulement le partager par lien.

Annuler

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