Re: Query returns error "there is no parameter $1" but server logs that there are two parameters supplied

Thanks for your replies. Apologies for the sparse bug report.

I will work on collecting more details & hopefully a reproducible test case as per the bug reporting guidelines. Along with sample data etc.

In the meantime here are some more details from another database (same host/cluster & different database driver in use) that does not have any triggers involved.

The first post was using node-pg (nodejs), this one querying iot.device_reading is using jackc/pgx (golang).

The following pasted details are also located at https://gist.github.com/pdeaudney/28d991c3831c2f5963461dd47669bedd for potentially nicer formatting.

2023-07-17 01:30:37.418 UTC [1843972] iot_stats@iot_devicereadings ERROR:  there is no parameter $1 at character 24
2023-07-17 01:30:37.418 UTC [1843972] iot_stats@iot_devicereadings CONTEXT:  unnamed portal with parameters: $1 = '2023-07-16 01:30:37.329811Z', $2 = 'pixel', $3 = 'byo_monnit'
2023-07-17 01:30:37.418 UTC [1843972] iot_stats@iot_devicereadings STATEMENT:			SELECT r.vendor, COUNT(r.vendor_id) as "count"			FROM (				SELECT DISTINCT vendor, vendor_id				FROM iot.device_reading				WHERE created >= $1 AND vendor IN ($2, $3)			) r			GROUP BY r.vendor

iot_devicereadings=# \d+ iot.device_reading
                                                   Table "iot.device_reading"
  Column   |            Type             | Collation | Nullable | Default | Storage  | Compression | Stats target | Description
-----------+-----------------------------+-----------+----------+---------+----------+-------------+--------------+-------------
 asset_id  | character varying(36)       |           | not null |         | extended |             |              |
 vendor    | character varying(36)       |           | not null |         | extended |             |              |
 vendor_id | character varying(36)       |           | not null |         | extended |             |              |
 type      | character varying(36)       |           | not null |         | extended |             |              |
 value     | real                        |           | not null |         | plain    |             |              |
 created   | timestamp without time zone |           | not null |         | plain    |             |              |
Indexes:
    "device_reading_pk" PRIMARY KEY, btree (asset_id, type, created)
    "device_reading_asset_id_created_idx" btree (asset_id, created)
    "device_reading_created_idx" btree (created)
Access method: heap

iot_devicereadings=# \dx
                                            List of installed extensions
        Name        | Version |   Schema   |                              Description
--------------------+---------+------------+------------------------------------------------------------------------
 citus              | 11.2-2  | pg_catalog | Citus distributed database
 citus_columnar     | 11.1-1  | pg_catalog | Citus Columnar extension
 pg_buffercache     | 1.3     | public     | examine the shared buffer cache
 pg_repack          | 1.4.8   | public     | Reorganize tables in PostgreSQL databases with minimal locks
 pg_stat_statements | 1.9     | public     | track planning and execution statistics of all SQL statements executed
 pgaudit            | 1.6.2   | public     | provides auditing functionality
 plpgsql            | 1.0     | pg_catalog | PL/pgSQL procedural language
 uuid-ossp          | 1.1     | public     | generate universally unique identifiers (UUIDs)
(8 rows)

iot_devicereadings=# select version();
                                                              version
-----------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 14.8 (Ubuntu 14.8-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
(1 row)

Regards,

Paul De Audney