Tob1as / docker-postgresql-postgis

PostgreSQL with PostGIS - Docker Image for amd64, arm64, arm (Raspberry Pi)
https://hub.docker.com/r/tobi312/rpi-postgresql-postgis/
MIT License
15 stars 4 forks source link

Multiarch Image not build #3

Open Tob1as opened 1 year ago

Tob1as commented 1 year ago

Multiarch Image not build

with platforms: linux/amd64,linux/arm64/v8,linux/arm/v7 in one github action job.

Sat, 26 Nov 2022 16:56:56 GMT #18 2495.2 2022-11-26 16:56:55.990 UTC [29650] LOG:  could not bind IPv4 address "0.0.0.0": Address in use
Sat, 26 Nov 2022 16:56:56 GMT #18 2495.2 2022-11-26 16:56:55.990 UTC [29650] HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
Sat, 26 Nov 2022 16:56:56 GMT #18 2495.2 2022-11-26 16:56:55.995 UTC [29650] LOG:  could not bind IPv6 address "::": Address in use
Sat, 26 Nov 2022 16:56:56 GMT #18 2495.2 2022-11-26 16:56:55.995 UTC [29650] HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
Sat, 26 Nov 2022 16:56:56 GMT #18 2495.2 2022-11-26 16:56:55.996 UTC [29650] WARNING:  could not create listen socket for "*"
Sat, 26 Nov 2022 16:56:56 GMT #18 2495.2 2022-11-26 16:56:55.997 UTC [29650] FATAL:  could not create any TCP/IP sockets
Sat, 26 Nov 2022 16:56:56 GMT #18 2495.2 2022-11-26 16:56:56.000 UTC [29650] LOG:  database system is shut down

Temporary solution: build each architecture separately.

Anybody have any ideas?

Tob1as commented 1 year ago

arm64 error, when build in separately job but one workflow:

#9 1327.2 Creating database 'postgis_reg' 
#9 1328.0 Preparing db 'postgis_reg' using: CREATE EXTENSION postgis SCHEMA public
#9 1333.5 PostgreSQL 13.9 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 11.2.1_git20220219) 11.2.1 20220219, 64-bit
#9 1333.5   Postgis 3.3.2 - (0) - 2022-11-26 18:25:58
#9 1333.5   scripts 3.3.2 0
#9 1333.5   GEOS: 3.10.3-CAPI-1.16.1
#9 1333.5   PROJ: 9.0.0
#9 1333.5 
#9 1333.5 Running tests
#9 1333.5 
#9 1333.5  after-create-script ../regress/hooks/hook-after-create.sql .. ok 
#9 1333.6  ./core/affine .. ok in 345 ms
#9 1334.4  ./core/bestsrid .. ok in 266 ms
#9 1335.0  ./core/binary ..2022-11-26 18:45:48.175 UTC [29650] LOG:  server process (PID 29936) was terminated by signal 7: Bus error
#9 1336.7 2022-11-26 18:45:48.175 UTC [29650] DETAIL:  Failed process was running: SELECT 'geometry', count(*) FROM tm.geoms_in i, tm.geoms o WHERE i.id = o.id
#9 1336.7    AND ST_OrderingEquals(i.g, o.g);
#9 1336.7 2022-11-26 18:45:48.175 UTC [29650] LOG:  terminating any other active server processes
#9 1336.7 Died at ../regress/run_test.pl line 799.
#9 1336.7 2022-11-26 18:45:48.182 UTC [29660] WARNING:  terminating connection because of crash of another server process
#9 1336.7 2022-11-26 18:45:48.182 UTC [29660] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
#9 1336.7 2022-11-26 18:45:48.182 UTC [29660] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
#9 1336.7  failed (psql exited with an error: /tmp/pgis_reg/test_4_out)
#9 1336.8 2022-11-26 18:45:48.187 UTC [29650] LOG:  all server processes terminated; reinitializing
#9 1336.8 make: *** [runtest.mk:24: check-regress] Error 2