# Checking port 57138 # Found port 57138 Name: main Data directory: /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/backup Archive directory: /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/archives Connection string: port=57138 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/7y8Bx6EsuX Log file: /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/log/001_pgbench_with_server_main.log [15:09:57.219](0.230s) # initializing database system by running initdb # Running: initdb -D /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata -A trust -N --locale C The files belonging to this database system will be owned by user "admin". This user must also own the server process. The database cluster will be initialized with locale "C". The default database encoding has accordingly been set to "SQL_ASCII". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata -l logfile start # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata ### Starting node "main" # Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata -l /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/log/001_pgbench_with_server_main.log -o --cluster-name=main start waiting for server to start.... done server started # Postmaster PID for node "main" is 32051 # Running: pgbench --no-vacuum --client=5 --protocol=prepared --transactions=25 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_concurrent_insert [15:10:02.291](5.071s) ok 1 - concurrent OID generation status (got 0 vs expected 0) [15:10:02.291](0.000s) ok 2 - concurrent OID generation stdout /(?^:processed: 125/125)/ [15:10:02.291](0.000s) ok 3 - concurrent OID generation stderr /(?^:^$)/ # Running: pgbench no-such-database [15:10:02.317](0.026s) ok 4 - no such database status (got 1 vs expected 1) [15:10:02.317](0.000s) ok 5 - no such database stdout /(?^:^$)/ [15:10:02.317](0.000s) ok 6 - no such database stderr /(?^:connection to server .* failed)/ [15:10:02.318](0.000s) ok 7 - no such database stderr /(?^:FATAL: database "no-such-database" does not exist)/ # Running: pgbench -S -t 1 [15:10:02.336](0.018s) ok 8 - run without init status (got 1 vs expected 1) [15:10:02.336](0.000s) ok 9 - run without init stderr /(?^:Perhaps you need to do initialization)/ # Running: pgbench -i [15:10:03.070](0.734s) ok 10 - pgbench scale 1 initialization status (got 0 vs expected 0) [15:10:03.070](0.001s) ok 11 - pgbench scale 1 initialization stdout /(?^:^$)/ [15:10:03.071](0.001s) ok 12 - pgbench scale 1 initialization stderr /(?^:creating tables)/ [15:10:03.071](0.000s) ok 13 - pgbench scale 1 initialization stderr /(?^:vacuuming)/ [15:10:03.071](0.000s) ok 14 - pgbench scale 1 initialization stderr /(?^:creating primary keys)/ [15:10:03.072](0.000s) ok 15 - pgbench scale 1 initialization stderr /(?^:done in \d+\.\d\d s )/ [15:10:03.121](0.049s) ok 16 - client-side: filler column of pgbench_accounts has no NULL data [15:10:03.168](0.048s) ok 17 - client-side: filler column of pgbench_branches has only NULL data [15:10:03.197](0.029s) ok 18 - client-side: filler column of pgbench_tellers has only NULL data [15:10:03.246](0.050s) ok 19 - client-side: pgbench_history has no data # Running: pgbench --initialize --init-steps=dtpvg --scale=1 --unlogged-tables --fillfactor=98 --foreign-keys --quiet --tablespace=regress_pgbench_tap_1_ts --index-tablespace=regress_pgbench_tap_1_ts --partitions=2 --partition-method=hash [15:10:03.964](0.717s) ok 20 - pgbench scale 1 initialization status (got 0 vs expected 0) [15:10:03.964](0.000s) ok 21 - pgbench scale 1 initialization stdout /(?^i:^$)/ [15:10:03.964](0.000s) ok 22 - pgbench scale 1 initialization stderr /(?^:dropping old tables)/ [15:10:03.964](0.000s) ok 23 - pgbench scale 1 initialization stderr /(?^:creating tables)/ [15:10:03.964](0.000s) ok 24 - pgbench scale 1 initialization stderr /(?^:creating 2 partitions)/ [15:10:03.964](0.000s) ok 25 - pgbench scale 1 initialization stderr /(?^:vacuuming)/ [15:10:03.964](0.000s) ok 26 - pgbench scale 1 initialization stderr /(?^:creating primary keys)/ [15:10:03.964](0.000s) ok 27 - pgbench scale 1 initialization stderr /(?^:creating foreign keys)/ [15:10:03.964](0.000s) ok 28 - pgbench scale 1 initialization stderr /(?^:(?!vacuuming))/ [15:10:03.965](0.000s) ok 29 - pgbench scale 1 initialization stderr /(?^:done in \d+\.\d\d s )/ # Running: pgbench --initialize --init-steps=dtpvGvv --no-vacuum --foreign-keys --unlogged-tables --partitions=3 [15:10:04.598](0.634s) ok 30 - pgbench --init-steps status (got 0 vs expected 0) [15:10:04.599](0.000s) ok 31 - pgbench --init-steps stdout /(?^:^$)/ [15:10:04.599](0.000s) ok 32 - pgbench --init-steps stderr /(?^:dropping old tables)/ [15:10:04.599](0.000s) ok 33 - pgbench --init-steps stderr /(?^:creating tables)/ [15:10:04.599](0.000s) ok 34 - pgbench --init-steps stderr /(?^:creating 3 partitions)/ [15:10:04.599](0.000s) ok 35 - pgbench --init-steps stderr /(?^:creating primary keys)/ [15:10:04.599](0.000s) ok 36 - pgbench --init-steps stderr /(?^:generating data \(server-side\))/ [15:10:04.599](0.000s) ok 37 - pgbench --init-steps stderr /(?^:creating foreign keys)/ [15:10:04.600](0.000s) ok 38 - pgbench --init-steps stderr /(?^:(?!vacuuming))/ [15:10:04.600](0.000s) ok 39 - pgbench --init-steps stderr /(?^:done in \d+\.\d\d s )/ [15:10:04.627](0.027s) ok 40 - server-side: filler column of pgbench_accounts has no NULL data [15:10:04.645](0.018s) ok 41 - server-side: filler column of pgbench_branches has only NULL data [15:10:04.662](0.017s) ok 42 - server-side: filler column of pgbench_tellers has only NULL data [15:10:04.687](0.025s) ok 43 - server-side: pgbench_history has no data # Running: pgbench --transactions=5 -Dfoo=bla --client=2 --protocol=simple --builtin=t --connect -n -v -n [15:10:04.835](0.148s) ok 44 - pgbench tpcb-like status (got 0 vs expected 0) [15:10:04.836](0.000s) ok 45 - pgbench tpcb-like stdout /(?^:builtin: TPC-B)/ [15:10:04.836](0.000s) ok 46 - pgbench tpcb-like stdout /(?^:clients: 2\b)/ [15:10:04.836](0.000s) ok 47 - pgbench tpcb-like stdout /(?^:processed: 10/10)/ [15:10:04.836](0.000s) ok 48 - pgbench tpcb-like stdout /(?^:mode: simple)/ [15:10:04.836](0.000s) ok 49 - pgbench tpcb-like stdout /(?^:maximum number of tries: 1)/ [15:10:04.836](0.000s) ok 50 - pgbench tpcb-like stderr /(?^:^$)/ # Running: pgbench --transactions=20 --client=5 -M extended --builtin=si -C --no-vacuum -s 1 [15:10:05.279](0.443s) ok 51 - pgbench simple update status (got 0 vs expected 0) [15:10:05.279](0.000s) ok 52 - pgbench simple update stdout /(?^:builtin: simple update)/ [15:10:05.279](0.000s) ok 53 - pgbench simple update stdout /(?^:clients: 5\b)/ [15:10:05.279](0.000s) ok 54 - pgbench simple update stdout /(?^:threads: 1\b)/ [15:10:05.279](0.000s) ok 55 - pgbench simple update stdout /(?^:processed: 100/100)/ [15:10:05.279](0.000s) ok 56 - pgbench simple update stdout /(?^:mode: extended)/ [15:10:05.279](0.000s) ok 57 - pgbench simple update stderr /(?^:scale option ignored)/ # Running: pgbench -t 100 -c 7 -M prepared -b se --debug [15:10:05.361](0.082s) ok 58 - pgbench select only status (got 0 vs expected 0) [15:10:05.361](0.000s) ok 59 - pgbench select only stdout /(?^:builtin: select only)/ [15:10:05.362](0.000s) ok 60 - pgbench select only stdout /(?^:clients: 7\b)/ [15:10:05.362](0.000s) ok 61 - pgbench select only stdout /(?^:threads: 1\b)/ [15:10:05.362](0.000s) ok 62 - pgbench select only stdout /(?^:processed: 700/700)/ [15:10:05.362](0.000s) ok 63 - pgbench select only stdout /(?^:mode: prepared)/ [15:10:05.362](0.000s) ok 64 - pgbench select only stderr /(?^:vacuum)/ [15:10:05.362](0.000s) ok 65 - pgbench select only stderr /(?^:client 0)/ [15:10:05.362](0.000s) ok 66 - pgbench select only stderr /(?^:client 1)/ [15:10:05.362](0.000s) ok 67 - pgbench select only stderr /(?^:sending)/ [15:10:05.362](0.000s) ok 68 - pgbench select only stderr /(?^:receiving)/ [15:10:05.362](0.000s) ok 69 - pgbench select only stderr /(?^:executing)/ # Running: pgbench -j 2 --bad-option # Running: pgbench -t 100 -c 1 -j 2 -M prepared -n -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_custom_script_1@1 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_custom_script_2@2 [15:10:05.559](0.197s) ok 70 - pgbench custom scripts status (got 0 vs expected 0) [15:10:05.559](0.000s) ok 71 - pgbench custom scripts stdout /(?^:type: multiple scripts)/ [15:10:05.559](0.000s) ok 72 - pgbench custom scripts stdout /(?^:mode: prepared)/ [15:10:05.559](0.000s) ok 73 - pgbench custom scripts stdout /(?^:script 1: .*/001_pgbench_custom_script_1)/ [15:10:05.559](0.000s) ok 74 - pgbench custom scripts stdout /(?^:weight: 2)/ [15:10:05.559](0.000s) ok 75 - pgbench custom scripts stdout /(?^:script 2: .*/001_pgbench_custom_script_2)/ [15:10:05.559](0.000s) ok 76 - pgbench custom scripts stdout /(?^:weight: 1)/ [15:10:05.559](0.000s) ok 77 - pgbench custom scripts stdout /(?^:processed: 100/100)/ [15:10:05.559](0.000s) ok 78 - pgbench custom scripts stderr /(?^:^$)/ # Running: pgbench -n -t 10 -c 1 -M simple -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_custom_script_3 [15:10:05.694](0.134s) ok 79 - pgbench custom script status (got 0 vs expected 0) [15:10:05.694](0.000s) ok 80 - pgbench custom script stdout /(?^:type: .*/001_pgbench_custom_script_3)/ [15:10:05.694](0.000s) ok 81 - pgbench custom script stdout /(?^:processed: 10/10)/ [15:10:05.694](0.000s) ok 82 - pgbench custom script stdout /(?^:mode: simple)/ [15:10:05.694](0.000s) ok 83 - pgbench custom script stderr /(?^:^$)/ # Running: pgbench -n -t 10 -c 2 -M extended -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_custom_script_4 [15:10:05.741](0.047s) ok 84 - pgbench custom script status (got 0 vs expected 0) [15:10:05.742](0.000s) ok 85 - pgbench custom script stdout /(?^:type: .*/001_pgbench_custom_script_4)/ [15:10:05.742](0.000s) ok 86 - pgbench custom script stdout /(?^:processed: 20/20)/ [15:10:05.743](0.002s) ok 87 - pgbench custom script stdout /(?^:mode: extended)/ [15:10:05.743](0.000s) ok 88 - pgbench custom script stderr /(?^:^$)/ ### Reloading node "main" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata reload server signaled # Running: pgbench -n -t1 -c1 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_param_1 [15:10:05.778](0.034s) ok 89 - server parameter logging status (got 2 vs expected 2) [15:10:05.778](0.000s) ok 90 - server parameter logging stderr /(?^:ERROR: invalid input syntax for type json)/ [15:10:05.779](0.000s) ok 91 - server parameter logging stderr /(?^:(?!unnamed portal with parameters))/ [15:10:05.782](0.004s) ok 92 - no parameters logged ### Reloading node "main" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata reload server signaled # Running: pgbench -n -t1 -c1 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_param_2 [15:10:05.816](0.034s) ok 93 - server parameter logging status (got 2 vs expected 2) [15:10:05.816](0.000s) ok 94 - server parameter logging stderr /(?^:ERROR: division by zero)/ [15:10:05.817](0.000s) ok 95 - server parameter logging stderr /(?^:CONTEXT: unnamed portal with parameters: \$1 = '1', \$2 = NULL)/ # Running: pgbench -n -t1 -c1 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_param_3 [15:10:05.887](0.070s) ok 96 - server parameter logging status (got 2 vs expected 2) [15:10:05.887](0.000s) ok 97 - server parameter logging stderr /(?^:ERROR: invalid input syntax for type json)/ [15:10:05.887](0.000s) ok 98 - server parameter logging stderr /(?^m:CONTEXT: JSON data, line 1: \{ invalid\.\.\.[\r\n]+unnamed portal with parameters: \$1 = '\{ invalid ', \$2 = '''Valame Dios!'' dijo Sancho; ''no le dije yo a vuestra merced que \.\.\.')/ [15:10:05.888](0.001s) ok 99 - parameter report does not truncate ### Reloading node "main" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata reload server signaled # Running: pgbench -n -t1 -c1 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_param_4 [15:10:05.921](0.033s) ok 100 - server parameter logging status (got 2 vs expected 2) [15:10:05.921](0.000s) ok 101 - server parameter logging stderr /(?^:ERROR: division by zero)/ [15:10:05.921](0.000s) ok 102 - server parameter logging stderr /(?^:CONTEXT: unnamed portal with parameters: \$1 = '1', \$2 = NULL)/ ### Reloading node "main" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata reload server signaled # Running: pgbench -n -t1 -c1 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_param_5 [15:10:06.956](1.035s) ok 103 - server parameter logging status (got 2 vs expected 2) [15:10:06.956](0.000s) ok 104 - server parameter logging stderr /(?^:ERROR: invalid input syntax for type json)/ [15:10:06.956](0.000s) ok 105 - server parameter logging stderr /(?^m:CONTEXT: JSON data, line 1: \{ invalid\.\.\.[\r\n]+unnamed portal with parameters: \$1 = '\{ invalid ', \$2 = '''Valame Dios!'' dijo Sancho; ''no le dije yo a vuestra merced que mirase bien lo que hacia\?')/ [15:10:06.958](0.001s) ok 106 - parameter report truncates # Running: pgbench -n -t1 -c1 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_param_6 [15:10:07.000](0.043s) ok 107 - server parameter logging status (got 2 vs expected 2) [15:10:07.001](0.000s) ok 108 - server parameter logging stderr /(?^:ERROR: invalid input syntax for type smallint: "1a")/ [15:10:07.001](0.000s) ok 109 - server parameter logging stderr /(?^:CONTEXT: unnamed portal parameter \$2 = '1a')/ ### Reloading node "main" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata reload server signaled # Running: pgbench --random-seed=5432 -t 1 -Dfoo=-10.1 -Dbla=false -Di=+3 -Dn=null -Dt=t -Df=of -Dd=1.0 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_expressions [15:10:07.079](0.079s) ok 110 - pgbench expressions status (got 0 vs expected 0) [15:10:07.079](0.000s) ok 111 - pgbench expressions stdout /(?^:type: .*/001_pgbench_expressions)/ [15:10:07.080](0.000s) ok 112 - pgbench expressions stdout /(?^:processed: 1/1)/ [15:10:07.080](0.000s) ok 113 - pgbench expressions stderr /(?^:setting random seed to 5432\b)/ [15:10:07.080](0.000s) ok 114 - pgbench expressions stderr /(?^:command=1.: int 17\b)/ [15:10:07.080](0.000s) ok 115 - pgbench expressions stderr /(?^:command=2.: int 104\b)/ [15:10:07.080](0.000s) ok 116 - pgbench expressions stderr /(?^:command=3.: int 1498\b)/ [15:10:07.080](0.000s) ok 117 - pgbench expressions stderr /(?^:command=4.: int 4\b)/ [15:10:07.080](0.000s) ok 118 - pgbench expressions stderr /(?^:command=5.: int 5\b)/ [15:10:07.080](0.000s) ok 119 - pgbench expressions stderr /(?^:command=6.: int 6\b)/ [15:10:07.080](0.000s) ok 120 - pgbench expressions stderr /(?^:command=7.: int 7\b)/ [15:10:07.080](0.000s) ok 121 - pgbench expressions stderr /(?^:command=8.: int 8\b)/ [15:10:07.080](0.000s) ok 122 - pgbench expressions stderr /(?^:command=9.: int 9\b)/ [15:10:07.080](0.000s) ok 123 - pgbench expressions stderr /(?^:command=10.: int 10\b)/ [15:10:07.080](0.000s) ok 124 - pgbench expressions stderr /(?^:command=11.: int 11\b)/ [15:10:07.080](0.000s) ok 125 - pgbench expressions stderr /(?^:command=12.: int 12\b)/ [15:10:07.080](0.000s) ok 126 - pgbench expressions stderr /(?^:command=15.: double 15\b)/ [15:10:07.080](0.000s) ok 127 - pgbench expressions stderr /(?^:command=16.: double 16\b)/ [15:10:07.080](0.000s) ok 128 - pgbench expressions stderr /(?^:command=17.: double 17\b)/ [15:10:07.080](0.000s) ok 129 - pgbench expressions stderr /(?^:command=20.: int 3\b)/ [15:10:07.080](0.000s) ok 130 - pgbench expressions stderr /(?^:command=21.: double -27\b)/ [15:10:07.080](0.000s) ok 131 - pgbench expressions stderr /(?^:command=22.: double 1024\b)/ [15:10:07.080](0.000s) ok 132 - pgbench expressions stderr /(?^:command=23.: double 1\b)/ [15:10:07.080](0.000s) ok 133 - pgbench expressions stderr /(?^:command=24.: double 1\b)/ [15:10:07.081](0.000s) ok 134 - pgbench expressions stderr /(?^:command=25.: double -0.125\b)/ [15:10:07.081](0.000s) ok 135 - pgbench expressions stderr /(?^:command=26.: double -0.125\b)/ [15:10:07.081](0.000s) ok 136 - pgbench expressions stderr /(?^:command=27.: double -0.00032\b)/ [15:10:07.081](0.000s) ok 137 - pgbench expressions stderr /(?^:command=28.: double 8.50705917302346e\+0?37\b)/ [15:10:07.081](0.000s) ok 138 - pgbench expressions stderr /(?^:command=29.: double 1e\+0?30\b)/ [15:10:07.081](0.000s) ok 139 - pgbench expressions stderr /(?^:command=30.: boolean false\b)/ [15:10:07.081](0.000s) ok 140 - pgbench expressions stderr /(?^:command=31.: boolean true\b)/ [15:10:07.081](0.000s) ok 141 - pgbench expressions stderr /(?^:command=32.: int 32\b)/ [15:10:07.081](0.000s) ok 142 - pgbench expressions stderr /(?^:command=33.: int 33\b)/ [15:10:07.081](0.000s) ok 143 - pgbench expressions stderr /(?^:command=34.: double 34\b)/ [15:10:07.081](0.000s) ok 144 - pgbench expressions stderr /(?^:command=35.: int 35\b)/ [15:10:07.081](0.000s) ok 145 - pgbench expressions stderr /(?^:command=36.: int 36\b)/ [15:10:07.081](0.000s) ok 146 - pgbench expressions stderr /(?^:command=37.: double 37\b)/ [15:10:07.081](0.000s) ok 147 - pgbench expressions stderr /(?^:command=38.: int 38\b)/ [15:10:07.081](0.000s) ok 148 - pgbench expressions stderr /(?^:command=39.: int 39\b)/ [15:10:07.081](0.000s) ok 149 - pgbench expressions stderr /(?^:command=40.: boolean true\b)/ [15:10:07.081](0.000s) ok 150 - pgbench expressions stderr /(?^:command=41.: null\b)/ [15:10:07.081](0.000s) ok 151 - pgbench expressions stderr /(?^:command=42.: null\b)/ [15:10:07.081](0.000s) ok 152 - pgbench expressions stderr /(?^:command=43.: boolean true\b)/ [15:10:07.082](0.000s) ok 153 - pgbench expressions stderr /(?^:command=44.: boolean true\b)/ [15:10:07.082](0.000s) ok 154 - pgbench expressions stderr /(?^:command=45.: boolean true\b)/ [15:10:07.082](0.000s) ok 155 - pgbench expressions stderr /(?^:command=46.: int 46\b)/ [15:10:07.082](0.000s) ok 156 - pgbench expressions stderr /(?^:command=47.: boolean true\b)/ [15:10:07.082](0.000s) ok 157 - pgbench expressions stderr /(?^:command=48.: boolean true\b)/ [15:10:07.082](0.000s) ok 158 - pgbench expressions stderr /(?^:command=49.: int -5817877081768721676\b)/ [15:10:07.082](0.000s) ok 159 - pgbench expressions stderr /(?^:command=50.: boolean true\b)/ [15:10:07.082](0.000s) ok 160 - pgbench expressions stderr /(?^:command=51.: int -7793829335365542153\b)/ [15:10:07.082](0.000s) ok 161 - pgbench expressions stderr /(?^:command=52.: int -?\d+\b)/ [15:10:07.082](0.000s) ok 162 - pgbench expressions stderr /(?^:command=53.: boolean true\b)/ [15:10:07.082](0.000s) ok 163 - pgbench expressions stderr /(?^:command=65.: int 65\b)/ [15:10:07.082](0.000s) ok 164 - pgbench expressions stderr /(?^:command=74.: int 74\b)/ [15:10:07.082](0.000s) ok 165 - pgbench expressions stderr /(?^:command=83.: int 83\b)/ [15:10:07.083](0.000s) ok 166 - pgbench expressions stderr /(?^:command=86.: int 86\b)/ [15:10:07.083](0.000s) ok 167 - pgbench expressions stderr /(?^:command=93.: int 93\b)/ [15:10:07.083](0.000s) ok 168 - pgbench expressions stderr /(?^:command=95.: int 0\b)/ [15:10:07.083](0.000s) ok 169 - pgbench expressions stderr /(?^:command=96.: int 1\b)/ [15:10:07.083](0.000s) ok 170 - pgbench expressions stderr /(?^:command=97.: int 0\b)/ [15:10:07.083](0.000s) ok 171 - pgbench expressions stderr /(?^:command=98.: int 5432\b)/ [15:10:07.083](0.000s) ok 172 - pgbench expressions stderr /(?^:command=99.: int -9223372036854775808\b)/ [15:10:07.083](0.000s) ok 173 - pgbench expressions stderr /(?^:command=100.: int 9223372036854775807\b)/ [15:10:07.083](0.000s) ok 174 - pgbench expressions stderr /(?^:command=101.: boolean true\b)/ [15:10:07.083](0.000s) ok 175 - pgbench expressions stderr /(?^:command=102.: boolean true\b)/ [15:10:07.083](0.000s) ok 176 - pgbench expressions stderr /(?^:command=103.: boolean true\b)/ [15:10:07.084](0.000s) ok 177 - pgbench expressions stderr /(?^:command=104.: boolean true\b)/ [15:10:07.084](0.000s) ok 178 - pgbench expressions stderr /(?^:command=105.: boolean true\b)/ [15:10:07.084](0.000s) ok 179 - pgbench expressions stderr /(?^:command=109.: boolean true\b)/ [15:10:07.084](0.000s) ok 180 - pgbench expressions stderr /(?^:command=110.: boolean true\b)/ [15:10:07.084](0.000s) ok 181 - pgbench expressions stderr /(?^:command=111.: boolean true\b)/ [15:10:07.084](0.000s) ok 182 - pgbench expressions stderr /(?^:command=113.: boolean true\b)/ # Running: pgbench --random-seed=595400291 -t 1 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_random_seed_1 [15:10:07.159](0.075s) ok 183 - random seeded with 595400291 status (got 0 vs expected 0) [15:10:07.159](0.000s) ok 184 - random seeded with 595400291 stdout /(?^:processed: 1/1)/ [15:10:07.159](0.000s) ok 185 - random seeded with 595400291 stderr /(?^:setting random seed to 595400291\b)/ # Running: pgbench --random-seed=595400291 -t 1 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_random_seed_2 [15:10:07.225](0.067s) ok 186 - random seeded with 595400291 status (got 0 vs expected 0) [15:10:07.225](0.000s) ok 187 - random seeded with 595400291 stdout /(?^:processed: 1/1)/ [15:10:07.226](0.000s) ok 188 - random seeded with 595400291 stderr /(?^:setting random seed to 595400291\b)/ [15:10:07.251](0.025s) ok 189 - psql seeded_random count ok [15:10:07.251](0.000s) ok 190 - psql seeded_random count stderr is empty [15:10:07.251](0.000s) ok 191 - psql seeded_random count uniform [15:10:07.251](0.000s) ok 192 - psql seeded_random count exponential [15:10:07.251](0.000s) ok 193 - psql seeded_random count gaussian [15:10:07.251](0.000s) ok 194 - psql seeded_random count zipfian # Running: pgbench -t 1 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_backslash_commands [15:10:07.372](0.120s) ok 195 - pgbench backslash commands status (got 0 vs expected 0) [15:10:07.372](0.000s) ok 196 - pgbench backslash commands stdout /(?^:type: .*/001_pgbench_backslash_commands)/ [15:10:07.372](0.000s) ok 197 - pgbench backslash commands stdout /(?^:processed: 1/1)/ [15:10:07.372](0.000s) ok 198 - pgbench backslash commands stdout /(?^:shell-echo-output)/ [15:10:07.372](0.000s) ok 199 - pgbench backslash commands stderr /(?^:command=8.: int 1\b)/ # Running: pgbench -t 1 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_gset [15:10:07.459](0.087s) ok 200 - pgbench gset command status (got 0 vs expected 0) [15:10:07.459](0.000s) ok 201 - pgbench gset command stdout /(?^:type: .*/001_pgbench_gset)/ [15:10:07.459](0.000s) ok 202 - pgbench gset command stdout /(?^:processed: 1/1)/ [15:10:07.459](0.000s) ok 203 - pgbench gset command stderr /(?^:command=3.: int 0\b)/ [15:10:07.459](0.000s) ok 204 - pgbench gset command stderr /(?^:command=5.: int 1\b)/ [15:10:07.459](0.000s) ok 205 - pgbench gset command stderr /(?^:command=6.: int 2\b)/ [15:10:07.459](0.000s) ok 206 - pgbench gset command stderr /(?^:command=8.: int 3\b)/ [15:10:07.459](0.000s) ok 207 - pgbench gset command stderr /(?^:command=10.: int 4\b)/ [15:10:07.460](0.000s) ok 208 - pgbench gset command stderr /(?^:command=12.: int 5\b)/ # Running: pgbench -t 1 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_gset_two_rows [15:10:07.550](0.091s) ok 209 - pgbench gset command with two rows status (got 2 vs expected 2) [15:10:07.551](0.000s) ok 210 - pgbench gset command with two rows stdout /(?^:type: .*/001_pgbench_gset_two_rows)/ [15:10:07.551](0.000s) ok 211 - pgbench gset command with two rows stdout /(?^:processed: 0/1)/ [15:10:07.551](0.000s) ok 212 - pgbench gset command with two rows stderr /(?^:expected one row, got 2\b)/ # Running: pgbench -t 1 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_aset [15:10:07.673](0.122s) ok 213 - pgbench aset command status (got 0 vs expected 0) [15:10:07.673](0.000s) ok 214 - pgbench aset command stdout /(?^:type: .*/001_pgbench_aset)/ [15:10:07.673](0.000s) ok 215 - pgbench aset command stdout /(?^:processed: 1/1)/ [15:10:07.673](0.000s) ok 216 - pgbench aset command stderr /(?^:command=3.: int 8\b)/ [15:10:07.673](0.000s) ok 217 - pgbench aset command stderr /(?^:command=4.: int 7\b)/ # Running: pgbench -t 1 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_aset_empty [15:10:07.715](0.041s) ok 218 - pgbench aset command with empty result status (got 2 vs expected 2) [15:10:07.715](0.000s) ok 219 - pgbench aset command with empty result stdout /(?^:type: .*/001_pgbench_aset_empty)/ [15:10:07.715](0.000s) ok 220 - pgbench aset command with empty result stdout /(?^:processed: 0/1)/ [15:10:07.715](0.000s) ok 221 - pgbench aset command with empty result stderr /(?^:undefined variable \"i8\")/ [15:10:07.715](0.000s) ok 222 - pgbench aset command with empty result stderr /(?^:evaluation of meta-command failed\b)/ # Running: pgbench -t 1 -n -M extended -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline [15:10:07.733](0.018s) ok 223 - working \startpipeline status (got 0 vs expected 0) [15:10:07.734](0.000s) ok 224 - working \startpipeline stdout /(?^:type: .*/001_pgbench_pipeline)/ [15:10:07.734](0.000s) ok 225 - working \startpipeline stdout /(?^:actually processed: 1/1)/ # Running: pgbench -t 1 -n -M extended -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline_sync [15:10:07.752](0.019s) ok 226 - working \startpipeline with \syncpipeline status (got 0 vs expected 0) [15:10:07.753](0.000s) ok 227 - working \startpipeline with \syncpipeline stdout /(?^:type: .*/001_pgbench_pipeline_sync)/ [15:10:07.753](0.000s) ok 228 - working \startpipeline with \syncpipeline stdout /(?^:actually processed: 1/1)/ # Running: pgbench -t 1 -n -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline_prep [15:10:07.788](0.036s) ok 229 - working \startpipeline status (got 0 vs expected 0) [15:10:07.789](0.000s) ok 230 - working \startpipeline stdout /(?^:type: .*/001_pgbench_pipeline_prep)/ [15:10:07.789](0.000s) ok 231 - working \startpipeline stdout /(?^:actually processed: 1/1)/ # Running: pgbench -t 1 -n -M extended -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline_2 [15:10:07.819](0.030s) ok 232 - error: call \startpipeline twice status (got 2 vs expected 2) [15:10:07.819](0.000s) ok 233 - error: call \startpipeline twice stderr /(?^:already in pipeline mode)/ # Running: pgbench -t 1 -n -M extended -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline_3 [15:10:07.854](0.035s) ok 234 - error: \endpipeline with no start status (got 2 vs expected 2) [15:10:07.855](0.000s) ok 235 - error: \endpipeline with no start stderr /(?^:not in pipeline mode)/ # Running: pgbench -t 1 -n -M extended -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline_4 [15:10:07.932](0.077s) ok 236 - error: \gset not allowed in pipeline mode status (got 2 vs expected 2) [15:10:07.932](0.000s) ok 237 - error: \gset not allowed in pipeline mode stderr /(?^:gset is not allowed in pipeline mode)/ # Running: pgbench -t 1 -n -M extended -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline_5 [15:10:07.969](0.037s) ok 238 - error: call \startpipeline without \endpipeline in a single transaction status (got 2 vs expected 2) [15:10:07.969](0.000s) ok 239 - error: call \startpipeline without \endpipeline in a single transaction stderr /(?^:end of script reached with pipeline open)/ # Running: pgbench -t 2 -n -M extended -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline_6 [15:10:08.016](0.046s) ok 240 - error: call \startpipeline without \endpipeline status (got 2 vs expected 2) [15:10:08.016](0.000s) ok 241 - error: call \startpipeline without \endpipeline stderr /(?^:end of script reached with pipeline open)/ # Running: pgbench -t 2 -n -M extended -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline_7 [15:10:08.104](0.089s) ok 242 - error: call \startpipeline and \syncpipeline without \endpipeline status (got 2 vs expected 2) [15:10:08.104](0.000s) ok 243 - error: call \startpipeline and \syncpipeline without \endpipeline stderr /(?^:end of script reached with pipeline open)/ # Running: pgbench -c4 -t 10 -n -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_pipeline_serializable [15:10:08.166](0.062s) ok 244 - working \startpipeline with serializable status (got 0 vs expected 0) [15:10:08.167](0.000s) ok 245 - working \startpipeline with serializable stdout /(?^:type: .*/001_pgbench_pipeline_serializable)/ [15:10:08.167](0.000s) ok 246 - working \startpipeline with serializable stdout /(?^:actually processed: (\d+)/\1)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_sql_syntax_error [15:10:08.290](0.124s) ok 247 - pgbench script error: sql syntax error status (got 2 vs expected 2) [15:10:08.291](0.000s) ok 248 - pgbench script error: sql syntax error stdout /(?^:processed: 0/1)/ [15:10:08.291](0.000s) ok 249 - pgbench script error: sql syntax error stderr /(?^:ERROR: syntax error)/ [15:10:08.291](0.000s) ok 250 - pgbench script error: sql syntax error stderr /(?^:prepared statement .* does not exist)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_sql_too_many_args [15:10:08.460](0.170s) ok 251 - pgbench script error: sql too many args status (got 1 vs expected 1) [15:10:08.461](0.000s) ok 252 - pgbench script error: sql too many args stdout /(?^:^$)/ [15:10:08.461](0.000s) ok 253 - pgbench script error: sql too many args stderr /(?^:statement has too many arguments.*\b255\b)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_shell_bad_command [15:10:08.579](0.118s) ok 254 - pgbench script error: shell bad command status (got 2 vs expected 2) [15:10:08.579](0.000s) ok 255 - pgbench script error: shell bad command stdout /(?^:processed: 0/1)/ [15:10:08.580](0.000s) not ok 256 - pgbench script error: shell bad command stderr /(?^:\(shell\) .* meta-command failed)/ [15:10:08.580](0.000s) # Failed test 'pgbench script error: shell bad command stderr /(?^:\(shell\) .* meta-command failed)/' # at /Users/admin/pgsql/src/bin/pgbench/t/001_pgbench_with_server.pl line 1214. [15:10:08.580](0.000s) # '' # doesn't match '(?^:\(shell\) .* meta-command failed)' # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_shell_undefined_variable [15:10:08.609](0.029s) ok 257 - pgbench script error: shell undefined variable status (got 2 vs expected 2) [15:10:08.609](0.000s) ok 258 - pgbench script error: shell undefined variable stdout /(?^:processed: 0/1)/ [15:10:08.609](0.000s) ok 259 - pgbench script error: shell undefined variable stderr /(?^:undefined variable ":nosuchvariable")/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_shell_missing_command [15:10:08.625](0.017s) ok 260 - pgbench script error: shell missing command status (got 1 vs expected 1) [15:10:08.626](0.000s) ok 261 - pgbench script error: shell missing command stdout /(?^:^$)/ [15:10:08.626](0.000s) ok 262 - pgbench script error: shell missing command stderr /(?^:missing command )/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_shell_too_many_args [15:10:08.648](0.022s) ok 263 - pgbench script error: shell too many args status (got 1 vs expected 1) [15:10:08.648](0.000s) ok 264 - pgbench script error: shell too many args stdout /(?^:^$)/ [15:10:08.648](0.000s) ok 265 - pgbench script error: shell too many args stderr /(?^:too many arguments in command "shell")/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_syntax_error [15:10:08.667](0.018s) ok 266 - pgbench script error: set syntax error status (got 1 vs expected 1) [15:10:08.667](0.001s) ok 267 - pgbench script error: set syntax error stdout /(?^:^$)/ [15:10:08.668](0.000s) ok 268 - pgbench script error: set syntax error stderr /(?^:syntax error in command "set")/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_no_such_function [15:10:08.686](0.018s) ok 269 - pgbench script error: set no such function status (got 1 vs expected 1) [15:10:08.686](0.000s) ok 270 - pgbench script error: set no such function stdout /(?^:^$)/ [15:10:08.686](0.000s) ok 271 - pgbench script error: set no such function stderr /(?^:unexpected function name)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_invalid_variable_name [15:10:08.729](0.043s) ok 272 - pgbench script error: set invalid variable name status (got 2 vs expected 2) [15:10:08.729](0.000s) ok 273 - pgbench script error: set invalid variable name stdout /(?^:processed: 0/1)/ [15:10:08.730](0.000s) ok 274 - pgbench script error: set invalid variable name stderr /(?^:invalid variable name)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_division_by_zero [15:10:08.793](0.064s) ok 275 - pgbench script error: set division by zero status (got 2 vs expected 2) [15:10:08.793](0.000s) ok 276 - pgbench script error: set division by zero stdout /(?^:processed: 0/1)/ [15:10:08.793](0.000s) ok 277 - pgbench script error: set division by zero stderr /(?^:division by zero)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_undefined_variable [15:10:08.831](0.038s) ok 278 - pgbench script error: set undefined variable status (got 2 vs expected 2) [15:10:08.832](0.000s) ok 279 - pgbench script error: set undefined variable stdout /(?^:processed: 0/1)/ [15:10:08.832](0.000s) ok 280 - pgbench script error: set undefined variable stderr /(?^:undefined variable "nosuchvariable")/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_unexpected_char [15:10:08.877](0.045s) ok 281 - pgbench script error: set unexpected char status (got 1 vs expected 1) [15:10:08.877](0.000s) ok 282 - pgbench script error: set unexpected char stdout /(?^:^$)/ [15:10:08.877](0.000s) ok 283 - pgbench script error: set unexpected char stderr /(?^:unexpected character .;.)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_too_many_args [15:10:08.908](0.031s) ok 284 - pgbench script error: set too many args status (got 2 vs expected 2) [15:10:08.908](0.000s) ok 285 - pgbench script error: set too many args stdout /(?^:processed: 0/1)/ [15:10:08.908](0.000s) ok 286 - pgbench script error: set too many args stderr /(?^:too many function arguments)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_empty_random_range [15:10:08.934](0.026s) ok 287 - pgbench script error: set empty random range status (got 2 vs expected 2) [15:10:08.934](0.000s) ok 288 - pgbench script error: set empty random range stdout /(?^:processed: 0/1)/ [15:10:08.935](0.000s) ok 289 - pgbench script error: set empty random range stderr /(?^:empty range given to random)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_random_range_too_large [15:10:08.957](0.022s) ok 290 - pgbench script error: set random range too large status (got 2 vs expected 2) [15:10:08.957](0.000s) ok 291 - pgbench script error: set random range too large stdout /(?^:processed: 0/1)/ [15:10:08.957](0.000s) ok 292 - pgbench script error: set random range too large stderr /(?^:random range is too large)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_gaussian_param_too_small [15:10:08.981](0.023s) ok 293 - pgbench script error: set gaussian param too small status (got 2 vs expected 2) [15:10:08.981](0.000s) ok 294 - pgbench script error: set gaussian param too small stdout /(?^:processed: 0/1)/ [15:10:08.981](0.000s) ok 295 - pgbench script error: set gaussian param too small stderr /(?^:gaussian param.* at least 2)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_exponential_param_greater_0 [15:10:09.059](0.078s) ok 296 - pgbench script error: set exponential param greater 0 status (got 2 vs expected 2) [15:10:09.059](0.000s) ok 297 - pgbench script error: set exponential param greater 0 stdout /(?^:processed: 0/1)/ [15:10:09.059](0.000s) ok 298 - pgbench script error: set exponential param greater 0 stderr /(?^:exponential parameter must be greater )/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_zipfian_param_to_1 [15:10:09.111](0.052s) ok 299 - pgbench script error: set zipfian param to 1 status (got 2 vs expected 2) [15:10:09.111](0.000s) ok 300 - pgbench script error: set zipfian param to 1 stdout /(?^:processed: 0/1)/ [15:10:09.111](0.000s) ok 301 - pgbench script error: set zipfian param to 1 stderr /(?^:zipfian parameter must be in range \[1\.001, 1000\])/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_zipfian_param_too_large [15:10:09.135](0.023s) ok 302 - pgbench script error: set zipfian param too large status (got 2 vs expected 2) [15:10:09.135](0.000s) ok 303 - pgbench script error: set zipfian param too large stdout /(?^:processed: 0/1)/ [15:10:09.135](0.000s) ok 304 - pgbench script error: set zipfian param too large stderr /(?^:zipfian parameter must be in range \[1\.001, 1000\])/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_non_numeric_value [15:10:09.501](0.366s) ok 305 - pgbench script error: set non numeric value status (got 2 vs expected 2) [15:10:09.501](0.001s) ok 306 - pgbench script error: set non numeric value stdout /(?^:processed: 0/1)/ [15:10:09.502](0.000s) ok 307 - pgbench script error: set non numeric value stderr /(?^:malformed variable "foo" value: "bla")/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_no_expression [15:10:09.519](0.017s) ok 308 - pgbench script error: set no expression status (got 1 vs expected 1) [15:10:09.519](0.000s) ok 309 - pgbench script error: set no expression stdout /(?^:^$)/ [15:10:09.519](0.000s) ok 310 - pgbench script error: set no expression stderr /(?^:syntax error)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_missing_argument [15:10:09.539](0.020s) ok 311 - pgbench script error: set missing argument status (got 1 vs expected 1) [15:10:09.539](0.000s) ok 312 - pgbench script error: set missing argument stdout /(?^:^$)/ [15:10:09.539](0.000s) ok 313 - pgbench script error: set missing argument stderr /(?^i:missing argument)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_not_a_bool [15:10:09.621](0.081s) ok 314 - pgbench script error: set not a bool status (got 2 vs expected 2) [15:10:09.621](0.000s) ok 315 - pgbench script error: set not a bool stdout /(?^:processed: 0/1)/ [15:10:09.621](0.000s) ok 316 - pgbench script error: set not a bool stderr /(?^:cannot coerce double to boolean)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_not_an_int [15:10:09.676](0.055s) ok 317 - pgbench script error: set not an int status (got 2 vs expected 2) [15:10:09.676](0.001s) ok 318 - pgbench script error: set not an int stdout /(?^:processed: 0/1)/ [15:10:09.677](0.000s) ok 319 - pgbench script error: set not an int stderr /(?^:cannot coerce boolean to int)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_not_a_double [15:10:09.729](0.052s) ok 320 - pgbench script error: set not a double status (got 2 vs expected 2) [15:10:09.729](0.000s) ok 321 - pgbench script error: set not a double stdout /(?^:processed: 0/1)/ [15:10:09.729](0.000s) ok 322 - pgbench script error: set not a double stderr /(?^:cannot coerce boolean to double)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_case_error [15:10:09.778](0.048s) ok 323 - pgbench script error: set case error status (got 1 vs expected 1) [15:10:09.778](0.000s) ok 324 - pgbench script error: set case error stdout /(?^:^$)/ [15:10:09.778](0.000s) ok 325 - pgbench script error: set case error stderr /(?^:syntax error in command "set")/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_random_error [15:10:09.810](0.032s) ok 326 - pgbench script error: set random error status (got 2 vs expected 2) [15:10:09.810](0.000s) ok 327 - pgbench script error: set random error stdout /(?^:processed: 0/1)/ [15:10:09.810](0.000s) ok 328 - pgbench script error: set random error stderr /(?^:cannot coerce boolean to int)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_number_of_args_mismatch [15:10:09.830](0.020s) ok 329 - pgbench script error: set number of args mismatch status (got 1 vs expected 1) [15:10:09.831](0.000s) ok 330 - pgbench script error: set number of args mismatch stdout /(?^:^$)/ [15:10:09.831](0.000s) ok 331 - pgbench script error: set number of args mismatch stderr /(?^:unexpected number of arguments)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_at_least_one_arg [15:10:09.856](0.025s) ok 332 - pgbench script error: set at least one arg status (got 1 vs expected 1) [15:10:09.857](0.001s) ok 333 - pgbench script error: set at least one arg stdout /(?^:^$)/ [15:10:09.857](0.001s) ok 334 - pgbench script error: set at least one arg stderr /(?^:at least one argument expected)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_double_to_int_overflow [15:10:09.898](0.040s) ok 335 - pgbench script error: set double to int overflow status (got 2 vs expected 2) [15:10:09.898](0.000s) ok 336 - pgbench script error: set double to int overflow stdout /(?^:processed: 0/1)/ [15:10:09.898](0.000s) ok 337 - pgbench script error: set double to int overflow stderr /(?^:double to int overflow for 100)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_bigint_add_overflow [15:10:09.930](0.032s) ok 338 - pgbench script error: set bigint add overflow status (got 2 vs expected 2) [15:10:09.930](0.000s) ok 339 - pgbench script error: set bigint add overflow stdout /(?^:processed: 0/1)/ [15:10:09.930](0.000s) ok 340 - pgbench script error: set bigint add overflow stderr /(?^:int add out)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_bigint_sub_overflow [15:10:10.001](0.071s) ok 341 - pgbench script error: set bigint sub overflow status (got 2 vs expected 2) [15:10:10.001](0.000s) ok 342 - pgbench script error: set bigint sub overflow stdout /(?^:processed: 0/1)/ [15:10:10.002](0.000s) ok 343 - pgbench script error: set bigint sub overflow stderr /(?^:int sub out)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_bigint_mul_overflow [15:10:10.105](0.104s) ok 344 - pgbench script error: set bigint mul overflow status (got 2 vs expected 2) [15:10:10.106](0.000s) ok 345 - pgbench script error: set bigint mul overflow stdout /(?^:processed: 0/1)/ [15:10:10.106](0.000s) ok 346 - pgbench script error: set bigint mul overflow stderr /(?^:int mul out)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_set_bigint_div_out_of_range [15:10:10.245](0.139s) ok 347 - pgbench script error: set bigint div out of range status (got 2 vs expected 2) [15:10:10.245](0.000s) ok 348 - pgbench script error: set bigint div out of range stdout /(?^:processed: 0/1)/ [15:10:10.245](0.000s) ok 349 - pgbench script error: set bigint div out of range stderr /(?^:bigint div out of range)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_setshell_not_an_int [15:10:10.342](0.096s) ok 350 - pgbench script error: setshell not an int status (got 2 vs expected 2) [15:10:10.342](0.000s) ok 351 - pgbench script error: setshell not an int stdout /(?^:processed: 0/1)/ [15:10:10.342](0.000s) ok 352 - pgbench script error: setshell not an int stderr /(?^:command must return an integer)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_setshell_missing_arg [15:10:10.446](0.104s) ok 353 - pgbench script error: setshell missing arg status (got 1 vs expected 1) [15:10:10.447](0.000s) ok 354 - pgbench script error: setshell missing arg stdout /(?^:^$)/ [15:10:10.447](0.000s) ok 355 - pgbench script error: setshell missing arg stderr /(?^:missing argument )/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_setshell_no_such_command [15:10:10.488](0.041s) ok 356 - pgbench script error: setshell no such command status (got 2 vs expected 2) [15:10:10.488](0.001s) ok 357 - pgbench script error: setshell no such command stdout /(?^:processed: 0/1)/ [15:10:10.489](0.000s) ok 358 - pgbench script error: setshell no such command stderr /(?^:could not read result )/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_sleep_undefined_variable [15:10:10.526](0.037s) ok 359 - pgbench script error: sleep undefined variable status (got 2 vs expected 2) [15:10:10.526](0.000s) ok 360 - pgbench script error: sleep undefined variable stdout /(?^:processed: 0/1)/ [15:10:10.526](0.000s) ok 361 - pgbench script error: sleep undefined variable stderr /(?^:sleep: undefined variable)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_sleep_too_many_args [15:10:10.624](0.098s) ok 362 - pgbench script error: sleep too many args status (got 1 vs expected 1) [15:10:10.624](0.000s) ok 363 - pgbench script error: sleep too many args stdout /(?^:^$)/ [15:10:10.624](0.000s) ok 364 - pgbench script error: sleep too many args stderr /(?^:too many arguments)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_sleep_missing_arg [15:10:10.684](0.060s) ok 365 - pgbench script error: sleep missing arg status (got 1 vs expected 1) [15:10:10.684](0.000s) ok 366 - pgbench script error: sleep missing arg stdout /(?^:^$)/ [15:10:10.684](0.000s) ok 367 - pgbench script error: sleep missing arg stderr /(?^:missing argument)/ [15:10:10.685](0.000s) ok 368 - pgbench script error: sleep missing arg stderr /(?^:\\sleep)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_sleep_unknown_unit [15:10:10.698](0.014s) ok 369 - pgbench script error: sleep unknown unit status (got 1 vs expected 1) [15:10:10.698](0.000s) ok 370 - pgbench script error: sleep unknown unit stdout /(?^:^$)/ [15:10:10.699](0.000s) ok 371 - pgbench script error: sleep unknown unit stderr /(?^:unrecognized time unit)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_misc_invalid_backslash_command [15:10:10.711](0.013s) ok 372 - pgbench script error: misc invalid backslash command status (got 1 vs expected 1) [15:10:10.712](0.000s) ok 373 - pgbench script error: misc invalid backslash command stdout /(?^:^$)/ [15:10:10.712](0.000s) ok 374 - pgbench script error: misc invalid backslash command stderr /(?^:invalid command .* "nosuchcommand")/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_misc_empty_script [15:10:10.732](0.020s) ok 375 - pgbench script error: misc empty script status (got 1 vs expected 1) [15:10:10.732](0.000s) ok 376 - pgbench script error: misc empty script stdout /(?^:^$)/ [15:10:10.732](0.000s) ok 377 - pgbench script error: misc empty script stderr /(?^:empty command list for script)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_bad_boolean [15:10:10.759](0.027s) ok 378 - pgbench script error: bad boolean status (got 2 vs expected 2) [15:10:10.759](0.000s) ok 379 - pgbench script error: bad boolean stdout /(?^:processed: 0/1)/ [15:10:10.759](0.000s) ok 380 - pgbench script error: bad boolean stderr /(?^:malformed variable.*trueXXX)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_invalid_permute_size [15:10:10.847](0.087s) ok 381 - pgbench script error: invalid permute size status (got 2 vs expected 2) [15:10:10.847](0.000s) ok 382 - pgbench script error: invalid permute size stdout /(?^:processed: 0/1)/ [15:10:10.847](0.000s) ok 383 - pgbench script error: invalid permute size stderr /(?^:permute size parameter must be greater than zero)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_gset_no_row [15:10:10.892](0.045s) ok 384 - pgbench script error: gset no row status (got 2 vs expected 2) [15:10:10.897](0.004s) ok 385 - pgbench script error: gset no row stdout /(?^:processed: 0/1)/ [15:10:10.897](0.000s) ok 386 - pgbench script error: gset no row stderr /(?^:expected one row, got 0\b)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_gset_alone [15:10:10.917](0.020s) ok 387 - pgbench script error: gset alone status (got 1 vs expected 1) [15:10:10.917](0.000s) ok 388 - pgbench script error: gset alone stdout /(?^:^$)/ [15:10:10.917](0.000s) ok 389 - pgbench script error: gset alone stderr /(?^:gset must follow an SQL command)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_gset_no_SQL [15:10:10.935](0.017s) ok 390 - pgbench script error: gset no SQL status (got 1 vs expected 1) [15:10:10.935](0.000s) ok 391 - pgbench script error: gset no SQL stdout /(?^:^$)/ [15:10:10.935](0.000s) ok 392 - pgbench script error: gset no SQL stderr /(?^:gset must follow an SQL command)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_gset_too_many_arguments [15:10:10.952](0.017s) ok 393 - pgbench script error: gset too many arguments status (got 1 vs expected 1) [15:10:10.952](0.000s) ok 394 - pgbench script error: gset too many arguments stdout /(?^:^$)/ [15:10:10.952](0.000s) ok 395 - pgbench script error: gset too many arguments stderr /(?^:too many arguments)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_gset_after_gset [15:10:10.965](0.013s) ok 396 - pgbench script error: gset after gset status (got 1 vs expected 1) [15:10:10.966](0.001s) ok 397 - pgbench script error: gset after gset stdout /(?^:^$)/ [15:10:10.966](0.000s) ok 398 - pgbench script error: gset after gset stderr /(?^:gset must follow an SQL command)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_gset_non_SELECT [15:10:10.990](0.024s) ok 399 - pgbench script error: gset non SELECT status (got 2 vs expected 2) [15:10:10.990](0.000s) ok 400 - pgbench script error: gset non SELECT stdout /(?^:processed: 0/1)/ [15:10:10.990](0.000s) ok 401 - pgbench script error: gset non SELECT stderr /(?^:expected one row, got 0)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_gset_bad_default_name [15:10:11.014](0.023s) ok 402 - pgbench script error: gset bad default name status (got 2 vs expected 2) [15:10:11.014](0.000s) ok 403 - pgbench script error: gset bad default name stdout /(?^:processed: 0/1)/ [15:10:11.014](0.000s) ok 404 - pgbench script error: gset bad default name stderr /(?^:error storing into variable \?column\?)/ # Running: pgbench -n -t 1 -Dfoo=bla -Dnull=null -Dtrue=true -Done=1 -Dzero=0.0 -Dbadtrue=trueXXX -Dmaxint=9223372036854775807 -Dminint=-9223372036854775808 -M prepared -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_error_gset_bad_name [15:10:11.048](0.034s) ok 405 - pgbench script error: gset bad name status (got 2 vs expected 2) [15:10:11.049](0.001s) ok 406 - pgbench script error: gset bad name stdout /(?^:processed: 0/1)/ [15:10:11.049](0.000s) ok 407 - pgbench script error: gset bad name stderr /(?^:error storing into variable bad name!)/ # Running: pgbench -t 100 -S --rate=100000 --latency-limit=1000000 -c 2 -n -r [15:10:11.131](0.082s) ok 408 - pgbench throttling status (got 0 vs expected 0) [15:10:11.132](0.001s) ok 409 - pgbench throttling stdout /(?^:processed: 200/200)/ [15:10:11.132](0.000s) ok 410 - pgbench throttling stdout /(?^:builtin: select only)/ [15:10:11.132](0.000s) ok 411 - pgbench throttling stderr /(?^:^$)/ # Running: pgbench -t 10 --rate=100000 --latency-limit=1 -n -r -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_sleep [15:10:11.173](0.041s) ok 412 - pgbench late throttling status (got 0 vs expected 0) [15:10:11.173](0.001s) ok 413 - pgbench late throttling stdout /(?^:processed: [01]/10)/ [15:10:11.175](0.002s) ok 414 - pgbench late throttling stdout /(?^:type: .*/001_pgbench_sleep)/ [15:10:11.175](0.000s) ok 415 - pgbench late throttling stdout /(?^:above the 1.0 ms latency limit: [01]/)/ [15:10:11.175](0.000s) ok 416 - pgbench late throttling stderr /(?^:^$)/ # Running: pgbench -n -S -t 50 -c 2 --log --sampling-rate=0.5 --log-prefix=/Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_log_2 [15:10:11.208](0.033s) ok 417 - pgbench logs status (got 0 vs expected 0) [15:10:11.208](0.000s) ok 418 - pgbench logs stdout /(?^:select only)/ [15:10:11.208](0.000s) ok 419 - pgbench logs stdout /(?^:processed: 100/100)/ [15:10:11.209](0.000s) ok 420 - pgbench logs stderr /(?^:^$)/ [15:10:11.209](0.000s) ok 421 - number of log files [15:10:11.209](0.000s) ok 422 - file name format [15:10:11.209](0.000s) ok 423 - transaction count for /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_log_2.33271 (46) [15:10:11.209](0.000s) ok 424 - transaction format for 001_pgbench_log_2 # Running: pgbench -n -b select-only -t 10 -l --log-prefix=/Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_log_3 [15:10:11.236](0.027s) ok 425 - pgbench logs contents status (got 0 vs expected 0) [15:10:11.237](0.000s) ok 426 - pgbench logs contents stdout /(?^:select only)/ [15:10:11.237](0.000s) ok 427 - pgbench logs contents stdout /(?^:processed: 10/10)/ [15:10:11.237](0.000s) ok 428 - pgbench logs contents stderr /(?^:^$)/ [15:10:11.237](0.000s) ok 429 - number of log files [15:10:11.237](0.000s) ok 430 - file name format [15:10:11.241](0.004s) ok 431 - transaction count for /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_log_3.33279 (10) [15:10:11.241](0.000s) ok 432 - transaction format for 001_pgbench_log_3 # Running: pgbench --no-vacuum -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_incomplete_transaction_block [15:10:11.264](0.023s) ok 433 - incomplete transaction block status (got 2 vs expected 2) [15:10:11.264](0.000s) ok 434 - incomplete transaction block stdout /(?^:processed: 1/10)/ [15:10:11.264](0.000s) ok 435 - incomplete transaction block stderr /(?^:client 0 aborted: end of script reached without completing the last transaction)/ # Running: pgbench -n -c 2 -t 1 --debug --verbose-errors --max-tries 2 -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_serialization [15:10:11.312](0.047s) ok 436 - concurrent update with retrying status (got 0 vs expected 0) [15:10:11.312](0.000s) ok 437 - concurrent update with retrying stdout /(?^:processed: 2/2\b)/ [15:10:11.312](0.000s) ok 438 - concurrent update with retrying stdout /(?^:number of transactions retried: 1\b)/ [15:10:11.312](0.000s) ok 439 - concurrent update with retrying stdout /(?^:total number of retries: 1\b)/ [15:10:11.312](0.000s) ok 440 - concurrent update with retrying stderr /(?^s:(client (0|1) sending UPDATE xy SET y = y \+ -?\d+\b).*client \2 got an error in command 3 \(SQL\) of script 0; ERROR: could not serialize access due to concurrent update\b.*\1)/ # Running: pgbench -n -c 2 -t 1 --max-tries 2 --verbose-errors -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_pgbench_deadlock [15:10:12.539](1.227s) ok 441 - deadlock with retrying status (got 0 vs expected 0) [15:10:12.540](0.000s) ok 442 - deadlock with retrying stdout /(?^:processed: 2/2\b)/ [15:10:12.540](0.000s) ok 443 - deadlock with retrying stdout /(?^:number of transactions retried: 1\b)/ [15:10:12.540](0.000s) ok 444 - deadlock with retrying stdout /(?^:total number of retries: 1\b)/ [15:10:12.540](0.000s) ok 445 - deadlock with retrying stderr /(?^:client (0|1) got an error in command (3|5) \(SQL\) of script 0; ERROR: deadlock detected\b)/ # Running: pgbench -t 10 -c 2 -j 2 --exit-on-abort -f /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/001_exit_on_abort [15:10:13.628](1.088s) ok 446 - test --exit-on-abort status (got 2 vs expected 2) [15:10:13.628](0.000s) ok 447 - test --exit-on-abort stderr /(?^:division by zero)/ [15:10:13.628](0.000s) ok 448 - test --exit-on-abort stderr /(?^:Run was aborted due to an error in thread)/ ### Stopping node "main" using mode fast # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/pgbench/001_pgbench_with_server/data/t_001_pgbench_with_server_main_data/pgdata -m fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "main" [15:10:13.789](0.161s) 1..448 [15:10:13.790](0.001s) # Looks like you failed 1 test of 448.