← volver a la publicación›Editar / bifurcar

Publicación sin título

#7SYT8UR5Lhpublic / publicnueva versión

anónimo creado 16 hours ago Caduca en 6 days 10.3 KB sintaxis: text

Tus cambios crean una nueva publicación enlazada a esta — la original no se toca.

nueva versión Tus cambios crean una nueva publicación enlazada a esta — la original no se toca.

Visibilidad Feed público Acceso public

Nota de cambio (opcional)

Esta publicación aparecerá en el feed público. Cambia Visibilidad si solo quieres compartirla por enlace.

Cancelar

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