BuildID: 2550
Status: OK
Image: melezhik/sparrow:alpine
Worker status: OK
---
Date: 10.01.2023 @ 23:49
Time elapsed: 635 sec
---
SCM:
https://github.com/FCO/Red.git
Git sha: 81bec4c
Git comment: Add prefetch on to-many for Pg
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
[35m23:39:56[0m :: [repository] - index updated from https://sparrowhub.io/repo/api/v1/index
run stage: run
[35m23:39:59[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
[35m23:40:01[0m :: installing postgresql service on sparky
[35m23:40:01[0m :: =======================================
[35m23:40:01[0m :: fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
[35m23:40:02[0m :: fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
[35m23:40:02[0m :: fetch https://dl.cloudsmith.io/public/nxadm-pkgs/rakudo-pkg/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
[35m23:40:03[0m :: (1/12) Installing postgresql-common (1.1-r2)
[35m23:40:03[0m :: Executing postgresql-common-1.1-r2.pre-install
[35m23:40:03[0m :: (2/12) Installing libpq (14.5-r0)
[35m23:40:03[0m :: (3/12) Installing postgresql14-client (14.5-r0)
[35m23:40:03[0m :: (4/12) Installing tzdata (2022f-r1)
[35m23:40:03[0m :: (5/12) Installing icu-data-en (71.1-r2)
[35m23:40:03[0m :: Executing icu-data-en-71.1-r2.post-install
[35m23:40:03[0m :: (6/12) Installing icu-libs (71.1-r2)
[35m23:40:03[0m :: (7/12) Installing gdbm (1.23-r0)
[35m23:40:03[0m :: (8/12) Installing libsasl (2.1.28-r1)
[35m23:40:03[0m :: (9/12) Installing libldap (2.6.3-r3)
[35m23:40:03[0m :: (10/12) Installing xz-libs (5.2.5-r1)
[35m23:40:03[0m :: (11/12) Installing libxml2 (2.9.14-r2)
[35m23:40:03[0m :: (12/12) Installing postgresql14 (14.5-r0)
[35m23:40:03[0m :: Executing postgresql14-14.5-r0.post-install
[35m23:40:03[0m :: Executing busybox-1.35.0-r17.trigger
[35m23:40:03[0m :: Executing postgresql-common-1.1-r2.trigger
[35m23:40:04[0m :: OK: 739 MiB in 72 packages
[35m23:40:04[0m :: The files belonging to this database system will be owned by user "postgres".
[35m23:40:04[0m :: This user must also own the server process.
[35m23:40:04[0m ::
[35m23:40:04[0m :: The database cluster will be initialized with locales
[35m23:40:04[0m :: COLLATE: C
[35m23:40:04[0m :: CTYPE: C.UTF-8
[35m23:40:04[0m :: MESSAGES: C
[35m23:40:04[0m :: MONETARY: C
[35m23:40:04[0m :: NUMERIC: C
[35m23:40:04[0m :: TIME: C
[35m23:40:04[0m :: The default database encoding has accordingly been set to "UTF8".
[35m23:40:04[0m :: The default text search configuration will be set to "english".
[35m23:40:04[0m ::
[35m23:40:04[0m :: Data page checksums are disabled.
[35m23:40:04[0m ::
[35m23:40:04[0m :: fixing permissions on existing directory /var/lib/postgresql/data ... ok
[35m23:40:04[0m :: creating subdirectories ... ok
[35m23:40:04[0m :: selecting dynamic shared memory implementation ... posix
[35m23:40:04[0m :: selecting default max_connections ... 100
[35m23:40:04[0m :: selecting default shared_buffers ... 128MB
[35m23:40:05[0m :: selecting default time zone ... UTC
[35m23:40:05[0m :: creating configuration files ... ok
[35m23:40:05[0m :: running bootstrap script ... ok
[35m23:40:06[0m :: performing post-bootstrap initialization ... ok
[35m23:40:08[0m :: syncing data to disk ... ok
[35m23:40:08[0m ::
[35m23:40:08[0m ::
[35m23:40:08[0m :: Success.
[35m23:40:08[0m ::
[35m23:40:13[0m :: CREATE ROLE
[35m23:40:13[0m :: GRANT
[35m23:40:13[0m :: CREATE TABLE
[1;36m[task stderr][0m
[35m23:40:13[0m :: ++ echo 'installing postgresql service on sparky'
[35m23:40:13[0m :: ++ echo =======================================
[35m23:40:13[0m :: ++ sudo apk add postgresql
[35m23:40:13[0m :: *
[35m23:40:13[0m :: * If you need ICU with non-English locales and legacy charset support, install
[35m23:40:13[0m :: * package icu-data-full.
[35m23:40:13[0m :: *
[35m23:40:13[0m :: *
[35m23:40:13[0m :: * If you want to use JIT in PostgreSQL, install postgresql14-jit or
[35m23:40:13[0m :: * postgresql-jit (if you didn't install specific major version of postgresql).
[35m23:40:13[0m :: *
[35m23:40:13[0m :: * Setting postgresql14 as the default version
[35m23:40:13[0m :: ++ sudo mkdir -p /run/postgresql
[35m23:40:13[0m :: ++ sudo chown postgres:postgres /run/postgresql
[35m23:40:13[0m :: ++ sudo rm -rf /var/lib/postgresql/data
[35m23:40:13[0m :: ++ sudo mkdir -p /var/lib/postgresql/data
[35m23:40:13[0m :: ++ sudo chown postgres:postgres /var/lib/postgresql/data
[35m23:40:13[0m :: ++ sudo chmod 0700 /var/lib/postgresql/data
[35m23:40:13[0m :: ++ sudo -u postgres sh -c -l 'initdb -D /var/lib/postgresql/data'
[35m23:40:13[0m :: initdb: warning: enabling "trust" authentication for local connections
[35m23:40:13[0m :: You can change this by editing pg_hba.conf or using the option -A, or
[35m23:40:13[0m :: --auth-local and --auth-host, the next time you run initdb.
[35m23:40:13[0m :: ++ sudo -u postgres sh -c -l 'postgres -D /var/lib/postgresql/data >/var/lib/postgresql/logfile 2>&1 &'
[35m23:40:13[0m :: ++ sleep 5
[35m23:40:13[0m :: ++ sudo -u postgres psql -c 'create user testuser with password '\''testpass'\'''
[35m23:40:13[0m :: ++ sudo -u postgres sh -l -c 'createdb redtest'
[35m23:40:13[0m :: ++ sudo -u postgres psql -c 'grant all privileges on database redtest to testuser;'
[35m23:40:13[0m :: ++ export PGPASSWORD=testpass
[35m23:40:13[0m :: ++ PGPASSWORD=testpass
[35m23:40:13[0m :: ++ psql -d redtest -U testuser -c 'create table foo(a text)' -h localhost
[35m23:39:29[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
[35m23:39:32[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
[35m23:39:34[0m :: tar -xzf source.tar.gz
[1;36m[task run: task.bash - tasks/zef_test][0m
[1;36m[dump code: task.bash][0m
[1] set -e
[2] sudo apk add --no-cache sqlite-libs sqlite-dev
[3] export RED_DATABASE="Pg host=localhost port=5432 user=testuser password=testpass dbname=redtest"
[4] cd source/
[5] raku --version
[6] zef install . --deps-only --test-depends --build-depends --/test .
[7] zef test . --verbose
[8]
[1;36m[task stdout][0m
[35m23:40:16[0m :: fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
[35m23:40:16[0m :: fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
[35m23:40:16[0m :: fetch https://dl.cloudsmith.io/public/nxadm-pkgs/rakudo-pkg/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
[35m23:40:16[0m :: (1/2) Installing sqlite-libs (3.38.5-r0)
[35m23:40:16[0m :: (2/2) Installing sqlite-dev (3.38.5-r0)
[35m23:40:16[0m :: OK: 741 MiB in 74 packages
[35m23:40:16[0m :: Welcome to Rakudo™ v2022.07.
[35m23:40:16[0m :: Implementing the Raku® Programming Language v6.d.
[35m23:40:16[0m :: Built on MoarVM version 2022.07.
[35m23:40:20[0m :: ===> Searching for missing dependencies: DBIish, DB::Pg, UUID, Test::META, App::RaCoCo
[35m23:42:44[0m :: ===> Searching for missing dependencies: NativeHelpers::Blob, NativeLibs:ver<0.0.9+>:auth<github:salortiz>, NativeCall::TypeDiag, App::Prove6, META6:ver<0.0.24+>, URI, License::SPDX, NativeLibs:ver<0.0.7+>:auth<github:salortiz>, LibUUID, Test::When
[35m23:42:44[0m :: ===> Searching for missing dependencies: File::Temp, Getopt::Long:ver<0.3.0+>, Path::Finder:ver<0.4.4+>, Pod::Usage, TAP:ver<0.3.4+>, sigpipe, JSON::Class:ver<0.0.15+>, JSON::Name, JSON::Class:ver<0.0.14+>
[35m23:42:44[0m :: ===> Searching for missing dependencies: JSON::Marshal:ver<0.0.23+>, JSON::Unmarshal:ver<0.08+>, JSON::OptIn
[35m23:42:44[0m :: ===> Installing: NativeHelpers::Blob:ver<0.1.12>:auth<github:salortiz>
[35m23:42:44[0m :: ===> Installing: NativeLibs:ver<0.0.9>:auth<github:salortiz>
[35m23:42:44[0m :: ===> Installing: File::Temp:ver<0.0.10>:auth<zef:rbt>
[35m23:42:44[0m :: ===> Installing: NativeCall::TypeDiag
[35m23:42:44[0m :: ===> Installing: DBIish:ver<0.6.6>:auth<zef:raku-community-modules>:api<1>
[35m23:42:44[0m :: ===> Installing: UUID:ver<1.0.0>
[35m23:42:44[0m :: ===> Installing: Getopt::Long:ver<0.4.1>
[35m23:42:44[0m :: ===> Installing: Path::Finder:ver<0.4.5>
[35m23:42:44[0m :: ===> Installing: Pod::Usage:ver<0.0.1>:auth<zef:leont>
[35m23:42:44[0m :: ===> Installing: TAP:ver<0.3.11>
[35m23:42:44[0m :: ===> Installing: sigpipe:ver<0.0.3>:auth<zef:leont>
[35m23:42:44[0m :: ===> Installing: App::Prove6:ver<0.0.17>:auth<cpan:LEONT>
[35m23:42:44[0m :: ===> Installing: App::RaCoCo:ver<1.6.0>:auth<zef:atroxaper>:api<1>
[35m23:42:44[0m :: ===> Installing: JSON::OptIn:ver<0.0.2>:auth<zef:jonathanstowe>
[35m23:42:44[0m :: ===> Installing: JSON::Name:ver<0.0.7>:auth<zef:jonathanstowe>:api<1.0>
[35m23:42:44[0m :: ===> Installing: JSON::Marshal:ver<0.0.24>:auth<zef:jonathanstowe>:api<1.0>
[35m23:42:44[0m :: ===> Installing: JSON::Unmarshal:ver<0.11>:auth<zef:raku-community-modules>
[35m23:42:44[0m :: ===> Installing: JSON::Class:ver<0.0.19>:auth<zef:jonathanstowe>:api<1.0>
[35m23:42:44[0m :: ===> Installing: META6:ver<0.0.29>:auth<zef:jonathanstowe>:api<1.0>
[35m23:42:44[0m :: ===> Installing: URI:ver<0.3.6>:auth<zef:raku-community-modules>
[35m23:42:44[0m :: ===> Installing: License::SPDX:ver<3.19.0>:auth<zef:jonathanstowe>:api<1.0>
[35m23:42:44[0m :: ===> Installing: Test::META:ver<0.0.19>:auth<zef:jonathanstowe>:api<1.0>
[35m23:42:44[0m :: ===> Installing: Test::When:ver<1.001009>:auth<zef:raku-community-modules>
[35m23:42:44[0m :: ===> Installing: LibUUID:ver<0.5>:auth<github:CurtTilmes>
[35m23:42:44[0m :: ===> Installing: DB::Pg:ver<1.1>:auth<github:CurtTilmes>:api<1>
[35m23:42:44[0m ::
[35m23:42:44[0m :: 2 bin/ scripts [prove6 racoco] installed to:
[35m23:42:44[0m :: /home/worker/.raku/bin
[35m23:42:46[0m :: ===> Testing: Red:ver<0.1.66>:auth<zef:FCO>:api<2>
[35m23:49:12[0m :: [Red] t/00-meta.t ........................... ok
[35m23:49:12[0m :: [Red] t/02-tdd.t ............................ skipped
[35m23:49:12[0m :: [Red] t/03-sqlite.t ......................... skipped
[35m23:49:12[0m :: [Red] t/04-blog.t ........................... ok
[35m23:49:12[0m :: [Red] t/05-ticket.t ......................... ok
[35m23:49:12[0m :: [Red] t/06-better-map.t ..................... skipped
[35m23:49:12[0m :: [Red] t/07-optimizer.t ...................... ok
[35m23:49:12[0m :: [Red] t/08-best-tree.t ...................... ok
[35m23:49:12[0m :: [Red] t/09-alternate-relation.t ............. ok
[35m23:49:12[0m :: [Red] t/10-alternate-relation-modules.t ..... ok
[35m23:49:12[0m :: [Red] t/11-join.t ........................... ok
[35m23:49:12[0m :: [Red] t/12-types.t .......................... ok
[35m23:49:12[0m :: [Red] t/13-roles.t .......................... ok
[35m23:49:12[0m :: [Red] t/14-result-seq-update.t .............. ok
[35m23:49:12[0m :: [Red] t/15-union.t .......................... ok
[35m23:49:12[0m :: [Red] t/16-result-seq-bool.t ................ ok
[35m23:49:12[0m :: [Red] t/17-create-related-pars.t ............ ok
[35m23:49:12[0m :: [Red] t/18-pp.t ............................. ok
[35m23:49:12[0m :: [Red] t/19-phasers.t ........................ ok
[35m23:49:12[0m :: [Red] t/20-in-sql.t ......................... ok
[35m23:49:12[0m :: [Red] t/21-new-with-id.t .................... ok
[35m23:49:12[0m :: [Red] t/22-red-do.t ......................... ok
[35m23:49:12[0m :: [Red] t/23-edit-id.t ........................ ok
[35m23:49:12[0m :: [Red] t/24-metamodel-model.t ................ ok
[35m23:49:12[0m :: [Red] t/25-grep-no-AND-OR.t ................. ok
[35m23:49:12[0m :: [Red] t/26-is-rw.t .......................... ok
[35m23:49:12[0m :: [Red] t/27-classify.t ....................... ok
[35m23:49:12[0m :: [Red] t/28-LPW-2019.t ....................... ok
[35m23:49:12[0m :: [Red] t/29-events.t ......................... ok
[35m23:49:12[0m :: [Red] t/30-result-seq-pick.t ................ ok
[35m23:49:12[0m :: [Red] t/31-update.t ......................... ok
[35m23:49:12[0m :: [Red] t/32-join.t ........................... ok
[35m23:49:12[0m :: [Red] t/33-join.t ........................... ok
[35m23:49:12[0m :: [Red] t/34-join.t ........................... ok
[35m23:49:12[0m :: [Red] t/35-ast-generic.t .................... ok
[35m23:49:12[0m :: [Red] t/35-create.t ......................... ok
[35m23:49:12[0m :: [Red] t/35-default-deflate.t ................ ok
[35m23:49:12[0m :: [Red] t/36-json.t ........................... ok
[35m23:49:12[0m :: [Red] t/37-equal.t .......................... skipped
[35m23:49:12[0m :: [Red] t/38-xmas.t ........................... ok
[35m23:49:12[0m :: [Red] t/39-relationship-multiple-columns.t .. skipped
[35m23:49:12[0m :: [Red] t/40-fallback.t ....................... ok
[35m23:49:12[0m :: [Red] t/41-create-table.t ................... ok
[35m23:49:12[0m :: [Red] t/42-prefetch.t ....................... ok
[35m23:49:12[0m :: [Red] t/43-error-without-id.t ............... ok
[35m23:49:12[0m :: [Red] t/44-is-handling.t .................... ok
[35m23:49:12[0m :: [Red] t/45-rw.t ............................. ok
[35m23:49:12[0m :: [Red] t/46-rypervenche.t .................... ok
[35m23:49:12[0m :: [Red] t/47-source-source-id.t ............... ok
[35m23:49:12[0m :: [Red] t/48-experimental-formater.t .......... ok
[35m23:49:12[0m :: [Red] t/49-experimental-name.t .............. ok
[35m23:49:12[0m :: [Red] t/50-pre-create-or-update.t ........... ok
[35m23:49:12[0m :: [Red] t/51-schema.t ......................... ok
[35m23:49:12[0m :: [Red] t/52-unique.t ......................... ok
[35m23:49:12[0m :: [Red] t/53-hand-made-many-to-many.t ......... ok
[35m23:49:12[0m :: [Red] t/54-no-optimization.t ................ ok
[35m23:49:12[0m :: [Red] t/55-refreshable.t .................... ok
[35m23:49:12[0m :: [Red] t/56-experimental.t ................... ok
[35m23:49:12[0m :: [Red] t/57-nm-relationship.t ................ ok
[35m23:49:12[0m :: [Red] t/58-tomgraceys-schema.t .............. ok
[35m23:49:12[0m :: [Red] t/59-runtime-role.t ................... ok
[35m23:49:12[0m :: [Red] t/60-model-as-type.t .................. ok
[35m23:49:12[0m :: [Red] t/61-date-coercion.t .................. ok
[35m23:49:12[0m :: [Red] t/62-inflate-deflate.t ................ ok
[35m23:49:12[0m :: [Red] t/63-create-on-defined-obj.t .......... ok
[35m23:49:12[0m :: [Red] t/64-patrickb.t ....................... ok
[35m23:49:12[0m :: [Red] t/65-join-model.t ..................... ok
[35m23:49:12[0m :: [Red] t/66-enums.t .......................... skipped
[35m23:49:12[0m :: [Red] t/66-red-config.t ..................... ok
[35m23:49:12[0m :: [Red] t/67-array-columns.t .................. ok
[35m23:49:12[0m :: [Red] t/68-submodel.t ....................... ok
[35m23:49:12[0m :: [Red] t/70-conflicting-column-attribute.t ... ok
[35m23:49:12[0m :: [Red] t/71-agg-methods.t .................... ok
[35m23:49:12[0m :: [Red] t/72-red-defaults-from-module.t ....... ok
[35m23:49:12[0m :: [Red] t/73-enum-reassign.t .................. ok
[35m23:49:12[0m :: [Red] t/74-patrick-operators.t .............. ok
[35m23:49:12[0m :: [Red] t/74-view.t ........................... ok
[35m23:49:12[0m :: [Red] t/75-red-type.t ....................... ok
[35m23:49:12[0m :: [Red] t/99-group-sort.t ..................... skipped
[35m23:49:12[0m :: [Red] All tests successful.
[35m23:49:12[0m :: [Red]
[35m23:49:12[0m :: [Red] Test Summary Report
[35m23:49:12[0m :: [Red] -------------------
[35m23:49:12[0m :: [Red] Files=79, Tests=832, 385 wallclock secs
[35m23:49:12[0m :: [Red] Result: PASS
[35m23:49:12[0m :: ===> Testing [OK] for Red:ver<0.1.66>:auth<zef:FCO>:api<2>
[1;36m[task stderr][0m
[35m23:49:12[0m :: ===> Updating fez mirror: https://360.zef.pm/
[35m23:49:12[0m :: ===> Updated fez mirror: https://360.zef.pm/
[35m23:49:12[0m :: ===> Updating rea mirror: https://raw.githubusercontent.com/Raku/REA/main/META.json
[35m23:49:12[0m :: ===> Updated rea mirror: https://raw.githubusercontent.com/Raku/REA/main/META.json