[ISSUE] PostgreSQL 16 initdb fails with dict_snowball.so: undefined symbol: CurrentMemoryContext

[ISSUE] PostgreSQL 16 initdb fails with dict_snowball.so: undefined symbol: CurrentMemoryContext

[Xiong-Tian]

[-- Attachment #1: Type: text/plain, Size: 995 bytes --]

New issue by Xiong-Tian on void-packages repository

https://github.com/void-linux/void-packages/issues/50535

Description:
### Is this a new report?

Yes

### System Info

Void 5.10.160 aarch64 Unknown uptodate rrnFFFF

### Package(s) Affected

postgresql16-16.2_1

### Does a report exist for this bug with the project's home (upstream) and/or another distro?

https://lore.kernel.org/buildroot/20240117210756.265708-1-ju.o@free.fr/

### Expected behaviour

PostgreSQL 16 initdb succeeds

### Actual behaviour

When the postgresql16 service is started without existing data, initdb is run and yields:
FATAL:  could not load library "/usr/lib/psql16/lib/postgresql/dict_snowball.so": /usr/lib/psql16/lib/postgresql/dict_snowball.so: undefined symbol: CurrentMemoryContext
It then remains stuck in a loop trying to run initdb and failing.
This appears to affect aarch64 but not x86_64.

### Steps to reproduce

Install fresh copy of PostgreSQL 16 (on aarch64)
Start the postgresql16 service

Re: PostgreSQL 16 initdb fails with dict_snowball.so: undefined symbol: CurrentMemoryContext

[Skaytacium]

[-- Attachment #1: Type: text/plain, Size: 1366 bytes --]

New comment by Skaytacium on void-packages repository

https://github.com/void-linux/void-packages/issues/50535#issuecomment-2424236851

Comment:
Getting the same issue on Void Linux 6.6.42_1 aarch64 (4KiB page kernel for the Raspberry Pi/kernel8).

```
Oct 20 03:32:15 [postgresql16] creating configuration files ... ok
Oct 20 03:32:15 [postgresql16] running bootstrap script ... ok
Oct 20 03:32:15 [postgresql16] performing post-bootstrap initialization ... 2024-10-20 03:32:15.650 IST [14834] FATAL:  could not load library "/usr/lib/psql16/lib/postgresql/dict_snowball.so": /usr/lib/psql16/lib/postgresql/dict_snowball.so: undefined symbol: CurrentMemoryContext
Oct 20 03:32:15 [postgresql16] 2024-10-20 03:32:15.650 IST [14834] STATEMENT:  CREATE FUNCTION dsnowball_init(INTERNAL)
Oct 20 03:32:15 [postgresql16] _    RETURNS INTERNAL AS '$libdir/dict_snowball', 'dsnowball_init'
Oct 20 03:32:15 [postgresql16] _LANGUAGE C STRICT;
Oct 20 03:32:15 [postgresql16] _
Oct 20 03:32:15 [postgresql16] child process exited with exit code 1
Oct 20 03:32:15 [postgresql16] initdb: removing contents of data directory "/var/lib/postgresql16/data"
```

Could be related to [cross-compiling](https://www.postgresql.org/message-id/flat/1266022.1701958693%40sss.pgh.pa.us#1f658341bdc76dd4f0e97a0122c6efda) and the potential fix has already been mentioned by OP.