Home Quick start All builds News Donations
More
Log In
Light Theme Docs
Workers

SparrowCI Report - gh-FCO-Red | [image: melezhik/sparrow:alpine]

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