Can't run this repo locally because of glibc bug on pganalyze/pg_query/ repo.

[theokkj]

Bug report

I tried running it on Windows, WSL and on a new Docker container. It always generates an error.

After cloning the repo to my machine, i run "npm install" and always get this error log:

https://drive.google.com/file/d/145O-poTkiodmGYwAnm3jf4adAnGQdJFe/view?usp=drive_link

Describe the bug

I did some research and discovered that this bug comes from the pganalyze/pg_query/ repo.

Some useful links are:

pganalyze/pg_query_go#95
pganalyze/libpg_query#202
pganalyze/pg_query#298

And the resolution

pganalyze/pg_query#299

To Reproduce

1. Git clone the database-build repo
2. cd database-build
3. npm install
4. see error

Expected behavior

I expect it to npm install successfuly.

System information

• OS: Windows 11 WSL Ubuntu 24.04.1 LTS
• Version of Node.js: v20.18.1

[gregnr]

Thanks for reporting @theokkj. I'll try to reproduce this on WSL2 and see if we can get to the bottom of it.

[theokkj]

Thanks for reporting @theokkj. I'll try to reproduce this on WSL2 and see if we can get to the bottom of it.

Hey @gregnr, were you able to take a look at that issue?

[psk001]

Has there been any resolution? Getting the same issue on ubuntu 24.

[mgold]

+1 for seeing this in Ubuntu 24.04.1 LTS.

.../node_modules/libpg-query install: src/postgres/src_port_snprintf.c:374:1: error: conflicting types for ‘strchrnul’; have ‘const char *(const char *, int)’
.../node_modules/libpg-query install:   374 | strchrnul(const char *s, int c)
.../node_modules/libpg-query install:       | ^~~~~~~~~
.../node_modules/libpg-query install: In file included from ./src/postgres/include/c.h:61,
.../node_modules/libpg-query install:                  from src/postgres/src_port_snprintf.c:62:
.../node_modules/libpg-query install: /usr/include/string.h:286:14: note: previous declaration of ‘strchrnul’ with type ‘char *(const char *, int)’
.../node_modules/libpg-query install:   286 | extern char *strchrnul (const char *__s, int __c)
.../node_modules/libpg-query install:       |              ^~~~~~~~~
.../node_modules/libpg-query install: make[1]: *** [Makefile:171: src/postgres/src_port_snprintf.o] Error 1

[yadazula]

A side note, it works fine with Ubuntu 22.04 LTS.

For my use-case, I changed the target OS to Ubuntu 22.04 LTS in the GitHub Actions workflow file as a workaround solution.

[theokkj]

A side note, it works fine with Ubuntu 22.04 LTS.

For my use-case, I changed the target OS to Ubuntu 22.04 LTS in the GitHub Actions workflow file as a workaround solution.

Can you show the steps that you've done?

[yadazula]

Can you show the steps that you've done?

Oh, it's a different project but the error is same. I reproduced it here and fixed with this workaround.

[mgold]

Upgrading libpg-query to 13.3.2 seems to work for me.

[psk001]

@mgold changing version to 13.3.2 gives below error

NPM page of this package doesnt show 13.3.2 a supported version