BuildID: 3729
Status: FAIL
Image: melezhik/sparrow:alpine_arm
Worker status: OK
---
Date: 21.10.2023 @ 10:51
Time elapsed: 133 sec
---
SCM:
https://github.com/FCO/Red.git
Git sha: 0462820
Git comment: Removing DB::Pg as dependency (not sure yet if it's a good idea) to make it possible to only install it for SQLite. Closes #557
tasks:
-
language: Bash
name: zef_test
default: true
code: |
set -e
sudo apk add --no-cache sqlite-libs sqlite-dev
export RED_DATABASE="Pg host=localhost port=5432 user=testuser password=testpass dbname=redtest"
cd source/
raku --version
zef install . --deps-only --test-depends --build-depends --/test .
zef test . --verbose
depends:
-
name: install_pg_server
-
name: install_pg_server
plugin: sparkyci-service-postgresql
config:
db_name: redtest
db_user: testuser
db_pass: testpass
[35m10:50:55[0m :: [repository] - index updated from https://sparrowhub.io/repo/api/v1/index
run stage: run
[35m10:50:58[0m :: [repository] - installing sparkyci-service-postgresql, version 0.000012
[1;36m[task run: task.bash - install_pg_server][0m
[1;36m[dump code: task.bash][0m
[1] set -e
[2]
[3] db_user=$(config db_user)
[4] db_pass=$(config db_pass)
[5] db_name=$(config db_name)
[6]
[7] set -x
[8]
[9] 2>&1
[10]
[11] echo "installing postgresql service on sparky"
[12] echo "======================================="
[13]
[14]
[15] sudo apk add postgresql
[16]
[17] sudo mkdir -p /run/postgresql
[18]
[19] sudo chown postgres:postgres /run/postgresql
[20]
[21] sudo rm -rf /var/lib/postgresql/data
[22]
[23] sudo mkdir -p /var/lib/postgresql/data
[24]
[25] sudo chown postgres:postgres /var/lib/postgresql/data
[26]
[27] sudo chmod 0700 /var/lib/postgresql/data
[28]
[29] sudo -u postgres sh -c -l 'initdb -D /var/lib/postgresql/data'
[30]
[31] sudo -u postgres sh -c -l 'postgres -D /var/lib/postgresql/data >/var/lib/postgresql/logfile 2>&1 &'
[32]
[33] sleep 5
[34]
[35] sudo -u postgres psql -c "create user $db_user with password '$db_pass'"
[36] sudo -u postgres sh -l -c "createdb $db_name"
[37] sudo -u postgres psql -c "grant all privileges on database $db_name to $db_user;"
[38]
[39] export PGPASSWORD=$db_pass
[40]
[41] psql -d $db_name -U $db_user -c "create table foo(a text)" -h localhost
[42]
[43]
[1;36m[task stdout][0m
[35m10:50:59[0m :: installing postgresql service on sparky
[35m10:50:59[0m :: =======================================
[35m10:51:00[0m :: (1/13) Installing postgresql-common (1.2-r0)
[35m10:51:00[0m :: Executing postgresql-common-1.2-r0.pre-install
[35m10:51:00[0m :: (2/13) Installing lz4-libs (1.9.4-r4)
[35m10:51:00[0m :: (3/13) Installing libpq (15.4-r0)
[35m10:51:00[0m :: (4/13) Installing postgresql15-client (15.4-r0)
[35m10:51:00[0m :: (5/13) Installing tzdata (2023c-r1)
[35m10:51:00[0m :: (6/13) Installing icu-data-en (73.2-r2)
[35m10:51:00[0m :: Executing icu-data-en-73.2-r2.post-install
[35m10:51:00[0m :: (7/13) Installing icu-libs (73.2-r2)
[35m10:51:00[0m :: (8/13) Installing gdbm (1.23-r1)
[35m10:51:00[0m :: (9/13) Installing libsasl (2.1.28-r4)
[35m10:51:00[0m :: (10/13) Installing libldap (2.6.5-r0)
[35m10:51:00[0m :: (11/13) Installing xz-libs (5.4.3-r0)
[35m10:51:00[0m :: (12/13) Installing libxml2 (2.11.4-r0)
[35m10:51:00[0m :: (13/13) Installing postgresql15 (15.4-r0)
[35m10:51:00[0m :: Executing postgresql15-15.4-r0.post-install
[35m10:51:00[0m :: Executing busybox-1.36.1-r2.trigger
[35m10:51:00[0m :: Executing postgresql-common-1.2-r0.trigger
[35m10:51:00[0m :: OK: 513 MiB in 75 packages
[35m10:51:01[0m :: The files belonging to this database system will be owned by user "postgres".
[35m10:51:01[0m :: This user must also own the server process.
[35m10:51:01[0m ::
[35m10:51:01[0m :: The database cluster will be initialized with this locale configuration:
[35m10:51:01[0m :: provider: libc
[35m10:51:01[0m :: LC_COLLATE: C
[35m10:51:01[0m :: LC_CTYPE: C.UTF-8
[35m10:51:01[0m :: LC_MESSAGES: C
[35m10:51:01[0m :: LC_MONETARY: C
[35m10:51:01[0m :: LC_NUMERIC: C
[35m10:51:01[0m :: LC_TIME: C
[35m10:51:01[0m :: The default database encoding has accordingly been set to "UTF8".
[35m10:51:01[0m :: The default text search configuration will be set to "english".
[35m10:51:01[0m ::
[35m10:51:01[0m :: Data page checksums are disabled.
[35m10:51:01[0m ::
[35m10:51:01[0m :: fixing permissions on existing directory /var/lib/postgresql/data ... ok
[35m10:51:01[0m :: creating subdirectories ... ok
[35m10:51:01[0m :: selecting dynamic shared memory implementation ... posix
[35m10:51:01[0m :: selecting default max_connections ... 100
[35m10:51:01[0m :: selecting default shared_buffers ... 128MB
[35m10:51:01[0m :: selecting default time zone ... UTC
[35m10:51:01[0m :: creating configuration files ... ok
[35m10:51:01[0m :: running bootstrap script ... ok
[35m10:51:01[0m :: performing post-bootstrap initialization ... ok
[35m10:51:03[0m :: syncing data to disk ... ok
[35m10:51:03[0m ::
[35m10:51:03[0m ::
[35m10:51:03[0m :: Success.
[35m10:51:03[0m ::
[35m10:51:08[0m :: CREATE ROLE
[35m10:51:08[0m :: GRANT
[1;36m[task stderr][0m
[35m10:51:08[0m :: ++ echo 'installing postgresql service on sparky'
[35m10:51:08[0m :: ++ echo =======================================
[35m10:51:08[0m :: ++ sudo apk add postgresql
[35m10:51:08[0m :: *
[35m10:51:08[0m :: * If you need ICU with non-English locales and legacy charset support, install
[35m10:51:08[0m :: * package icu-data-full.
[35m10:51:08[0m :: *
[35m10:51:08[0m :: *
[35m10:51:08[0m :: * If you want to use JIT in PostgreSQL, install postgresql15-jit or
[35m10:51:08[0m :: * postgresql-jit (if you didn't install specific major version of postgresql).
[35m10:51:08[0m :: *
[35m10:51:08[0m :: * Setting postgresql15 as the default version
[35m10:51:08[0m :: ++ sudo mkdir -p /run/postgresql
[35m10:51:08[0m :: ++ sudo chown postgres:postgres /run/postgresql
[35m10:51:08[0m :: ++ sudo rm -rf /var/lib/postgresql/data
[35m10:51:08[0m :: ++ sudo mkdir -p /var/lib/postgresql/data
[35m10:51:08[0m :: ++ sudo chown postgres:postgres /var/lib/postgresql/data
[35m10:51:08[0m :: ++ sudo chmod 0700 /var/lib/postgresql/data
[35m10:51:08[0m :: ++ sudo -u postgres sh -c -l 'initdb -D /var/lib/postgresql/data'
[35m10:51:08[0m :: initdb: warning: enabling "trust" authentication for local connections
[35m10:51:08[0m :: initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
[35m10:51:08[0m :: ++ sudo -u postgres sh -c -l 'postgres -D /var/lib/postgresql/data >/var/lib/postgresql/logfile 2>&1 &'
[35m10:51:08[0m :: ++ sleep 5
[35m10:51:08[0m :: ++ sudo -u postgres psql -c 'create user testuser with password '\''testpass'\'''
[35m10:51:08[0m :: ++ sudo -u postgres sh -l -c 'createdb redtest'
[35m10:51:08[0m :: ++ sudo -u postgres psql -c 'grant all privileges on database redtest to testuser;'
[35m10:51:08[0m :: ++ export PGPASSWORD=testpass
[35m10:51:08[0m :: ++ PGPASSWORD=testpass
[35m10:51:08[0m :: ++ psql -d redtest -U testuser -c 'create table foo(a text)' -h localhost
[35m10:51:08[0m :: ERROR: permission denied for schema public
[35m10:51:08[0m :: LINE 1: create table foo(a text)
[35m10:51:08[0m :: ^
[35m10:51:08[0m :: task exit status: 1
[35m10:51:08[0m :: task install_pg_server FAILED
The spawned command 'docker exec -i sparrow-worker sh -l /var/.sparrowdo/env/install_pg_server/.sparrowdo/sparrowrun.sh' exited unsuccessfully (exit code: 1, signal: 0)
in block <unit> at /home/ubuntu/projects/rakudo/rakudo-2022.12/install/share/perl6/site/resources/7E8029CBEC6AEAB4CF3B86B0FA3D5E6E21936B90 line 13
in sub MAIN at /home/ubuntu/projects/rakudo/rakudo-2022.12/install/share/perl6/site/bin/sparrowdo line 3
in block <unit> at /home/ubuntu/projects/rakudo/rakudo-2022.12/install/share/perl6/site/bin/sparrowdo line 1
[35m10:50:10[0m :: [repository] - index updated from https://sparrowhub.io/repo/api/v1/index
run stage: run
source directory does not yet exist, download source archive from storage
[35m10:50:13[0m :: [repository] - installing pack-unpack, version 0.000001
[1;36m[task run: task.bash - unpack source archive][0m
[1;36m[dump code: task.bash][0m
[1] set -e
[2]
[3] file=$(config file)
[4] dir=$(config dir)
[5]
[6] echo "tar -xzf $file "
[7]
[8] tar -xzf $file
[9]
[10] if test $dir; then
[11] ls -l $dir
[12] fi
[13]
[14]
[1;36m[task stdout][0m
[35m10:50:15[0m :: tar -xzf source.tar.gz
some depends jobs failed or timeouted: ${:FAIL(1), :OK(0), :TIMEOUT(0)}
The spawned command 'docker exec -i sparrow-worker sh -l /var/.sparrowdo/env/zef_test/.sparrowdo/sparrowrun.sh' exited unsuccessfully (exit code: 1, signal: 0)
in block <unit> at /home/ubuntu/projects/rakudo/rakudo-2022.12/install/share/perl6/site/resources/7E8029CBEC6AEAB4CF3B86B0FA3D5E6E21936B90 line 13
in sub MAIN at /home/ubuntu/projects/rakudo/rakudo-2022.12/install/share/perl6/site/bin/sparrowdo line 3
in block <unit> at /home/ubuntu/projects/rakudo/rakudo-2022.12/install/share/perl6/site/bin/sparrowdo line 1