When running the first SQL statement, I got spammed by "The system cannot find the path specified."

[f1yingbanana]

I'm running PGlite 0.3.1 in Node 20.9 on Windows 11, and running the code below:

const client = new PGlite();
console.log(JSON.stringify(await client.exec("SELECT 1")));

Gives me the following console output:

The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
[{"rows":[{"?column?":1}],"fields":[{"name":"?column?","dataTypeID":23}],"affectedRows":0}]

Everything else works, but running the first query gives me that. Why is that? How do I get rid of it?

Passing in a local path doesn't seem to change anything either.

Doesn't seem to be happening in my Linux GitHub actions 👀

[lroal]

I get this when running Bun 1.2.14 and @electric-sql/pglite@0.3.2

$ bun run index.ts
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.

[henry-fun]

Me too , i encounter this issue in Windows, my version is @electric-sql/pglite@0.3.2

[henry-fun]

I've discovered that the initial SQL execution is actually not necessary. just new PGlite('./db-dir') will triggers this problem.
My guess is that there's some kind of bug occurring during the initial local database setup

[pmp-p]

Hi, did you create (empty) "db-dir" folder prior running pglite hybrid node/web ?

We don't ship node with raw filesystem access. the PGDATA directory will be mounted at runtime from drive everything else outside that folder stays in memory.

[f1yingbanana]

Shouldn't the entire thing be in-memory? If I don't pass in a path where am I supposed to creat an empty folder at?

[henry-fun]

For me, before first new PGlite(dbPath) , I always use fs.mkdirSync(dbPath, { recursive: true }) to create the empty folder

[Ciantic]

I have Windows too, this happens with Deno, Bun and Node. Maybe something to do with Windows only?

It happens with new PGLite() and new PGLite("memory://"), it's not related to persisted databases.

[tdrz]

We're looking for help with this issue! Someone that develops using PGlite on Windows that could look into this would be great.

[igalklebanov]

Hey 👋

Witnessing this on my home Windows 10 PC when running prisma dev.

Happens during this sequence:

# 3527:/home/runner/work/pglite/pglite/src/bin/initdb/initdb.c
creating directory /tmp/pglite/base ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
selecting default "max_connections" ... 25
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
selecting default "shared_buffers" ... 400kB

Wanna arrange a call?

[pmp-p]

hint: /dev/urandom

[hllshiro]

I've tested Windows, Ubuntu, Mac, and this issue only appears on Windows, so any clues now? #770

[tdrz]

Thank you @hllshiro ! We'll need more time to address this.