TypeError: Cannot read properties of undefined (reading 'replace')

[joshxyzhimself]

Hi, just curious, has anyone encountered this error before?

TypeError: Cannot read properties of undefined (reading 'replace')
    at queryError (file:///server/node_modules/postgres/src/connection.js:389:48)
    at errored (file:///server/node_modules/postgres/src/connection.js:384:17)
    at Socket.data (file:///server/node_modules/postgres/src/connection.js:318:9)
    at Socket.emit (node:events:517:28)
    at Socket.emit (node:domain:489:12)
    at addChunk (node:internal/streams/readable:368:12)
    at readableAddChunk (node:internal/streams/readable:341:9)
    at Readable.push (node:internal/streams/readable:278:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)

• What could be causing query.origin to be undefined?
• https://github.com/porsager/postgres/blob/master/src/connection.js#L387-L396

[boehs]

Did you ever find a solution to this, josh?

[joshxyzhimself]

Related issue here: kysely-org/kysely-postgres-js#60

Context is I get these errors when the database is still not ready yet. For example, when using PostgreSQL in Docker with initialization scripts, it takes a while on its first run.

In my case I just added a loop that checks if postgresql db is ready.

const pgc_ready_check = async () => {
  for (let i = 1, l = Infinity; i < l; i += 1) {
    try {
      console.log("pgc_ready_check", "#", i);
      const tables = await pgc`
        SELECT * FROM information_schema.tables;
      `;
      if (tables instanceof Array) {
        console.log("pgc_ready_check", "OK");
        return true;
      }
    } catch (e) {
      if (e instanceof Error) {
        console.error("pgc_ready_check", e.name);
      }
    }
    await new Promise((r) => setTimeout(r, 2500));
  }
  return null;
};

await pgc_ready_check();

I also use a similar one for elasticsearch.

const esc_ready_check = async () => {
  for (let i = 1, l = Infinity; i < l; i += 1) {
    let timeout: NodeJS.Timeout | null = null;
    try {
      console.log("esc_ready_check", "#", i);
      const controller = new AbortController();
      timeout = setTimeout(() => {
        controller.abort();
      }, 2500);
      const health = await esc.cluster.health(
        {},
        { signal: controller.signal },
      );
      if (health.status === "green" || health.status === "yellow") {
        console.log("esc_ready_check", "OK");
        return true;
      }
    } catch (e) {
      if (e instanceof Error) {
        console.error("esc_ready_check", e.name);
      }
    } finally {
      if (timeout instanceof Object) {
        clearTimeout(timeout);
      }
    }
    await new Promise((r) => setTimeout(r, 2500));
  }
  return null;
};

await esc_ready_check();

Band-aid fixes, I know, I know.. lol.