ERROR: cache lookup failed for foreign server

[AntoniJakubiak]

Hi,

I am trying to use influxdb_fdw.

CREATE FOREIGN TABLE cpu(
   time timestamp with time zone,
   host text, 
   cpu text,
   usage_idle double precision
 )
 SERVER influxdb_svr
 OPTIONS (
   table 'cpu', 
   tags 'host, cpu'
 );
CREATE FOREIGN TABLE
influx=# SELECT time, usage_idle FROM cpu LIMIT 5;
DEBUG:  influxdb_fdw : influxdb_fdw_handler
DEBUG:  influxdb_fdw : influxdbGetForeignRelSize
DEBUG:  influxdb_fdw : influxdbGetForeignPaths
DEBUG:  influxdb_fdw : influxdbGetForeignUpperPaths
DEBUG:  influxdb_fdw : influxdbGetForeignPlan
DEBUG:  influxdb_fdw : influxdbBeginForeignScan
DEBUG:  influxdb_fdw : influxdbIterateForeignScan
ERROR:  cache lookup failed for foreign server 1734439797

What could be wrong?

PostgreSQL 12.18 InfluxDB 1.6.4

Kind regards Antoni Jakubiak

[cobolbaby]

It is likely that Influxdb cannot be accessed from the PG side. It is recommended to test whether the network is reachable.

[AntoniJakubiak]

Hi,

Fixed after upgrading PostgreSQL to 14.

Thanks