[heartbeat] starting: bash /home/fedora/load_both.sh
[heartbeat] interval: 60s
[heartbeat] label:    bash
+ export PATH=/opt/pg18/bin:/home/fedora/.cargo/bin:/home/fedora/.local/bin:/home/fedora/bin:/usr/local/bin:/usr/bin
+ PATH=/opt/pg18/bin:/home/fedora/.cargo/bin:/home/fedora/.local/bin:/home/fedora/bin:/usr/local/bin:/usr/bin
+ D=/data/co1024_1m/copy
+ R=/home/fedora/results/p0
+ mkdir -p /home/fedora/results/p0
+ PS='psql -h /tmp -v ON_ERROR_STOP=1 -X'
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c $'DROP TABLE IF EXISTS docs, queries; CREATE TABLE docs(id bigint PRIMARY KEY, emb vector(1024)); ALTER TABLE docs ALTER COLUMN emb SET STORAGE PLAIN;\n  CREATE TABLE queries(qid int PRIMARY KEY, q vector(1024)); ALTER TABLE queries ALTER COLUMN q SET STORAGE PLAIN;'
NOTICE:  table "docs" does not exist, skipping
NOTICE:  table "queries" does not exist, skipping
DROP TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_tv -c $'DROP TABLE IF EXISTS docs, queries; CREATE TABLE docs(id bigint PRIMARY KEY, emb turbovec.vector); ALTER TABLE docs ALTER COLUMN emb SET STORAGE PLAIN;\n  CREATE TABLE queries(qid int PRIMARY KEY, q turbovec.vector); ALTER TABLE queries ALTER COLUMN q SET STORAGE PLAIN;'
NOTICE:  table "docs" does not exist, skipping
NOTICE:  table "queries" does not exist, skipping
DROP TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
+ for db in db_pv db_tv
++ date +%s.%N
+ t0=1792005842.588048522
+ for f in $D/docs_*.tsv
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_00.tsv'\'''
+ for f in $D/docs_*.tsv
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_01.tsv'\'''
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_02.tsv'\'''
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_03.tsv'\'''
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_04.tsv'\'''
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_05.tsv'\'''
+ for f in $D/docs_*.tsv
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_06.tsv'\'''
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_07.tsv'\'''
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_08.tsv'\'''
+ for f in $D/docs_*.tsv
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_09.tsv'\'''
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_10.tsv'\'''
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_11.tsv'\'''
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_12.tsv'\'''
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_13.tsv'\'''
+ for f in $D/docs_*.tsv
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_14.tsv'\'''
+ wait
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy docs FROM '\''/data/co1024_1m/copy/docs_15.tsv'\'''
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
COPY 62500
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c '\copy queries FROM '\''/data/co1024_1m/copy/queries.tsv'\'''
COPY 5200
++ date +%s.%N
+ t1=1792005854.029065347
+ tee -a /home/fedora/results/p0/load_times.txt
++ echo 1792005854.029065347-1792005842.588048522
++ bc
+ echo 'LOAD db_pv 11.441016825 s'
LOAD db_pv 11.441016825 s
+ psql -h /tmp -v ON_ERROR_STOP=1 -X -d db_pv -c 'VACUUM (FREEZE, ANALYZE) docs; VACUUM (FREEZE, ANALYZE) queries;'
ERROR:  VACUUM cannot run inside a transaction block
[heartbeat] DONE rc=1 (failed)
