# Checking port 57786
# Found port 57786
Name: main
Data directory: /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/t_001_libpq_pipeline_main_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/t_001_libpq_pipeline_main_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/t_001_libpq_pipeline_main_data/archives
Connection string: port=57786 host=/tmp/QUxawPrHxV
Log file: /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/log/001_libpq_pipeline_main.log
[17:10:14.439](0.014s) # initializing database system by copying initdb template
# Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/t_001_libpq_pipeline_main_data/pgdata
# Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/t_001_libpq_pipeline_main_data/pgdata
### Starting node "main"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/t_001_libpq_pipeline_main_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/log/001_libpq_pipeline_main.log -o --cluster-name=main start
waiting for server to start.... done
server started
# Postmaster PID for node "main" is 37834
# Running: libpq_pipeline -r 700 cancel port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
test cancellations... 
libpq_pipeline:314: query did not fail when it was expected
[17:13:14.823](180.384s) not ok 1 - libpq_pipeline cancel
[17:13:14.824](0.000s) #   Failed test 'libpq_pipeline cancel'
#   at /tmp/cirrus-ci-build/src/test/modules/libpq_pipeline/t/001_libpq_pipeline.pl line 55.
# Running: libpq_pipeline -r 700 -t /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/traces/disallowed_in_pipeline.trace disallowed_in_pipeline port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
test error cases... ok
[17:13:14.837](0.013s) ok 2 - libpq_pipeline disallowed_in_pipeline
[17:13:14.837](0.000s) ok 3 - disallowed_in_pipeline trace match
# Running: libpq_pipeline -r 700 -t /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/traces/multi_pipelines.trace multi_pipelines port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
multi pipeline... ok
[17:13:14.850](0.013s) ok 4 - libpq_pipeline multi_pipelines
[17:13:14.851](0.000s) ok 5 - multi_pipelines trace match
# Running: libpq_pipeline -r 700 -t /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/traces/nosync.trace nosync port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
nosync... ok
[17:13:14.863](0.013s) ok 6 - libpq_pipeline nosync
[17:13:14.864](0.001s) ok 7 - nosync trace match
# Running: libpq_pipeline -r 700 -t /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/traces/pipeline_abort.trace pipeline_abort port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
aborted pipeline... NOTICE:  table "pq_pipeline_demo" does not exist, skipping
ok
ok
got expected ERROR:  cannot insert multiple commands into a prepared statement
got row: 0.33333333333333333333
got row: 0.50000000000000000000
got row: 1.00000000000000000000
got expected division-by-zero
[17:13:14.877](0.013s) ok 8 - libpq_pipeline pipeline_abort
[17:13:14.877](0.001s) ok 9 - pipeline_abort trace match
# Running: libpq_pipeline -r 700 -t /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/traces/pipeline_idle.trace pipeline_idle port=57786 host=/tmp/QUxawPrHxV dbname='postgres'

pipeline idle...
ok - 1
NOTICE 1: WARNING:  you don't own a lock of type ExclusiveLock
ok - 2
[17:13:14.890](0.013s) ok 10 - libpq_pipeline pipeline_idle
[17:13:14.891](0.001s) ok 11 - pipeline_idle trace match
# Running: libpq_pipeline -r 700 pipelined_insert port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
ok
pipeline sync sent
[17:13:14.926](0.035s) ok 12 - libpq_pipeline pipelined_insert
# Running: libpq_pipeline -r 700 -t /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/traces/prepared.trace prepared port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
prepared... closing statement..creating portal... closing portal... ok
[17:13:14.939](0.013s) ok 13 - libpq_pipeline prepared
[17:13:14.940](0.001s) ok 14 - prepared trace match
# Running: libpq_pipeline -r 700 -t /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/traces/simple_pipeline.trace simple_pipeline port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
simple pipeline... ok
[17:13:14.953](0.014s) ok 15 - libpq_pipeline simple_pipeline
[17:13:14.954](0.001s) ok 16 - simple_pipeline trace match
# Running: libpq_pipeline -r 700 -t /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/traces/singlerow.trace singlerow port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
Result status PGRES_SINGLE_TUPLE for query 0, 1 tuple: 42
Result status PGRES_SINGLE_TUPLE for query 0, 1 tuple: 43
Result status PGRES_SINGLE_TUPLE for query 0, 1 tuple: 44
Result status PGRES_TUPLES_OK for query 0, tuples: 0
all tuples received in query 0
Result status PGRES_SINGLE_TUPLE for query 1, 1 tuple: 42
Result status PGRES_SINGLE_TUPLE for query 1, 1 tuple: 43
Result status PGRES_SINGLE_TUPLE for query 1, 1 tuple: 44
Result status PGRES_SINGLE_TUPLE for query 1, 1 tuple: 45
Result status PGRES_TUPLES_OK for query 1, tuples: 0
all tuples received in query 1
Result status PGRES_TUPLES_OK for query 2, tuples: 5
end of pipeline reached
ok
[17:13:14.967](0.013s) ok 17 - libpq_pipeline singlerow
[17:13:14.968](0.001s) ok 18 - singlerow trace match
# Running: libpq_pipeline -r 700 -t /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/traces/transaction.trace transaction port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
NOTICE:  table "pq_pipeline_tst" does not exist, skipping
ok
0: got status PGRES_COMMAND_OK
1: got NULL result
2: got status PGRES_COMMAND_OK
3: got NULL result
4: got status PGRES_FATAL_ERROR; error: ERROR:  division by zero
5: got NULL result
6: got status PGRES_PIPELINE_ABORTED: command didn't run because pipeline aborted
7: got NULL result
8: got status PGRES_PIPELINE_ABORTED: command didn't run because pipeline aborted
9: got NULL result
10: got status PGRES_PIPELINE_SYNC
11: got status PGRES_FATAL_ERROR; error: ERROR:  current transaction is aborted, commands ignored until end of transaction block
12: got NULL result
13: got status PGRES_PIPELINE_SYNC
14: got status PGRES_COMMAND_OK
15: got NULL result
16: got status PGRES_COMMAND_OK
17: got NULL result
18: got status PGRES_PIPELINE_SYNC
19: got status PGRES_PIPELINE_SYNC
[17:13:14.981](0.013s) ok 19 - libpq_pipeline transaction
[17:13:14.981](0.001s) ok 20 - transaction trace match
# Running: libpq_pipeline -r 700 uniqviol port=57786 host=/tmp/QUxawPrHxV dbname='postgres'
uniqviol ...NOTICE:  table "ppln_uniqviol" does not exist, skipping
...............................................................................................................................................................
switch to reading
...............................................................................E........................................................................
switch to reading
result 0/311: 0
result 1/311: 1
result 2/311: 2
result 3/311: 3
result 4/311: 4
result 5/311: 5
result 6/311: 6
result 7/311: 7
result 8/311: 8
result 9/311: 9
result 10/311: 10
result 11/311: 11
result 12/311: 12
result 13/311: 13
result 14/311: 14
result 15/311: 15
result 16/311: 16
result 17/311: 17
result 18/311: 18
result 19/311: 19
result 20/311: 20
result 21/311: 21
result 22/311: 22
result 23/311: 23
result 24/311: 24
result 25/311: 25
result 26/311: 26
result 27/311: 27
result 28/311: 28
result 29/311: 29
result 30/311: 30
result 31/311: 31
result 32/311: 32
result 33/311: 33
result 34/311: 34
result 35/311: 35
result 36/311: 36
result 37/311: 37
result 38/311: 38
result 39/311: 39
result 40/311: 40
result 41/311: 41
result 42/311: 42
result 43/311: 43
result 44/311: 44
result 45/311: 45
result 46/311: 46
result 47/311: 47
result 48/311: 48
result 49/311: 49
result 50/311: 50
result 51/311: 51
result 52/311: 52
result 53/311: 53
result 54/311: 54
result 55/311: 55
result 56/311: 56
result 57/311: 57
result 58/311: 58
result 59/311: 59
result 60/311: 60
result 61/311: 61
result 62/311: 62
result 63/311: 63
result 64/311: 64
result 65/311: 65
result 66/311: 66
result 67/311: 67
result 68/311: 68
result 69/311: 69
result 70/311: 70
result 71/311: 71
result 72/311: 72
result 73/311: 73
result 74/311: 74
result 75/311: 75
result 76/311: 76
result 77/311: 77
result 78/311: 78
result 79/311: 79
result 80/311: 80
result 81/311: 81
result 82/311: 82
result 83/311: 83
result 84/311: 84
result 85/311: 85
result 86/311: 86
result 87/311: 87
result 88/311: 88
result 89/311: 89
result 90/311: 90
result 91/311: 91
result 92/311: 92
result 93/311: 93
result 94/311: 94
result 95/311: 95
result 96/311: 96
result 97/311: 97
result 98/311: 98
result 99/311: 99
result 100/311: 100
result 101/311: 101
result 102/311: 102
result 103/311: 103
result 104/311: 104
result 105/311: 105
result 106/311: 106
result 107/311: 107
result 108/311: 108
result 109/311: 109
result 110/311: 110
result 111/311: 111
result 112/311: 112
result 113/311: 113
result 114/311: 114
result 115/311: 115
result 116/311: 116
result 117/311: 117
result 118/311: 118
result 119/311: 119
result 120/311: 120
result 121/311: 121
result 122/311: 122
result 123/311: 123
result 124/311: 124
result 125/311: 125
result 126/311: 126
result 127/311: 127
result 128/311: 128
result 129/311: 129
result 130/311: 130
.................................................
done writing
result 131/360: 131
result 132/360: 132
result 133/360: 133
result 134/360: 134
result 135/360: 135
result 136/360: 136
result 137/360: 137
result 138/360: 138
result 139/360: 139
result 140/360: 140
result 141/360: 141
result 142/360: 142
result 143/360: 143
result 144/360: 144
result 145/360: 145
result 146/360: 146
result 147/360: 147
result 148/360: 148
result 149/360: 149
result 150/360: 150
result 151/360: 151
result 152/360: 152
result 153/360: 153
result 154/360: 154
result 155/360: 155
result 156/360: 156
result 157/360: 157
result 158/360: 158
result 159/360: 159
result 160/360: 160
result 161/360: 161
result 162/360: 162
result 163/360: 163
result 164/360: 164
result 165/360: 165
result 166/360: 166
result 167/360: 167
result 168/360: 168
result 169/360: 169
result 170/360: 170
result 171/360: 171
result 172/360: 172
result 173/360: 173
result 174/360: 174
result 175/360: 175
result 176/360: 176
result 177/360: 177
result 178/360: 178
result 179/360: 179
result 180/360: 180
result 181/360: 181
result 182/360: 182
result 183/360: 183
result 184/360: 184
result 185/360: 185
result 186/360: 186
result 187/360: 187
result 188/360: 188
result 189/360: 189
result 190/360: 190
result 191/360: 191
result 192/360: 192
result 193/360: 193
result 194/360: 194
result 195/360: 195
result 196/360: 196
result 197/360: 197
result 198/360: 198
result 199/360: 199
result 200/360: 200
result 201/360: 201
result 202/360: 202
result 203/360: 203
result 204/360: 204
result 205/360: 205
result 206/360: 206
result 207/360: 207
result 208/360: 208
result 209/360: 209
result 210/360: 210
result 211/360: 211
result 212/360: 212
result 213/360: 213
result 214/360: 214
result 215/360: 215
result 216/360: 216
result 217/360: 217
result 218/360: 218
result 219/360: 219
result 220/360: 220
result 221/360: 221
result 222/360: 222
result 223/360: 223
result 224/360: 224
result 225/360: 225
result 226/360: 226
result 227/360: 227
result 228/360: 228
result 229/360: 229
result 230/360: 230
result 231/360: 231
result 232/360: 232
result 233/360: 233
result 234/360: 234
result 235/360: 235
result 236/360: 236
result 237/360: 237
result 238/360 (error): ERROR:  duplicate key value violates unique constraint "ppln_uniqviol_pkey"
DETAIL:  Key (id)=(119) already exists.

result 239/360: pipeline aborted
result 240/360: pipeline aborted
result 241/360: pipeline aborted
result 242/360: pipeline aborted
result 243/360: pipeline aborted
result 244/360: pipeline aborted
result 245/360: pipeline aborted
result 246/360: pipeline aborted
result 247/360: pipeline aborted
result 248/360: pipeline aborted
result 249/360: pipeline aborted
result 250/360: pipeline aborted
result 251/360: pipeline aborted
result 252/360: pipeline aborted
result 253/360: pipeline aborted
result 254/360: pipeline aborted
result 255/360: pipeline aborted
result 256/360: pipeline aborted
result 257/360: pipeline aborted
result 258/360: pipeline aborted
result 259/360: pipeline aborted
result 260/360: pipeline aborted
result 261/360: pipeline aborted
result 262/360: pipeline aborted
result 263/360: pipeline aborted
result 264/360: pipeline aborted
result 265/360: pipeline aborted
result 266/360: pipeline aborted
result 267/360: pipeline aborted
result 268/360: pipeline aborted
result 269/360: pipeline aborted
result 270/360: pipeline aborted
result 271/360: pipeline aborted
result 272/360: pipeline aborted
result 273/360: pipeline aborted
result 274/360: pipeline aborted
result 275/360: pipeline aborted
result 276/360: pipeline aborted
result 277/360: pipeline aborted
result 278/360: pipeline aborted
result 279/360: pipeline aborted
result 280/360: pipeline aborted
result 281/360: pipeline aborted
result 282/360: pipeline aborted
result 283/360: pipeline aborted
result 284/360: pipeline aborted
result 285/360: pipeline aborted
result 286/360: pipeline aborted
result 287/360: pipeline aborted
result 288/360: pipeline aborted
result 289/360: pipeline aborted
result 290/360: pipeline aborted
result 291/360: pipeline aborted
result 292/360: pipeline aborted
result 293/360: pipeline aborted
result 294/360: pipeline aborted
result 295/360: pipeline aborted
result 296/360: pipeline aborted
result 297/360: pipeline aborted
result 298/360: pipeline aborted
result 299/360: pipeline aborted
result 300/360: pipeline aborted
result 301/360: pipeline aborted
result 302/360: pipeline aborted
result 303/360: pipeline aborted
result 304/360: pipeline aborted
result 305/360: pipeline aborted
result 306/360: pipeline aborted
result 307/360: pipeline aborted
result 308/360: pipeline aborted
result 309/360: pipeline aborted
result 310/360: pipeline aborted
result 311/360: pipeline aborted
result 312/360: pipeline aborted
result 313/360: pipeline aborted
result 314/360: pipeline aborted
result 315/360: pipeline aborted
result 316/360: pipeline aborted
result 317/360: pipeline aborted
result 318/360: pipeline aborted
result 319/360: pipeline aborted
result 320/360: pipeline aborted
result 321/360: pipeline aborted
result 322/360: pipeline aborted
result 323/360: pipeline aborted
result 324/360: pipeline aborted
result 325/360: pipeline aborted
result 326/360: pipeline aborted
result 327/360: pipeline aborted
result 328/360: pipeline aborted
result 329/360: pipeline aborted
result 330/360: pipeline aborted
result 331/360: pipeline aborted
result 332/360: pipeline aborted
result 333/360: pipeline aborted
result 334/360: pipeline aborted
result 335/360: pipeline aborted
result 336/360: pipeline aborted
result 337/360: pipeline aborted
result 338/360: pipeline aborted
result 339/360: pipeline aborted
result 340/360: pipeline aborted
result 341/360: pipeline aborted
result 342/360: pipeline aborted
result 343/360: pipeline aborted
result 344/360: pipeline aborted
result 345/360: pipeline aborted
result 346/360: pipeline aborted
result 347/360: pipeline aborted
result 348/360: pipeline aborted
result 349/360: pipeline aborted
result 350/360: pipeline aborted
result 351/360: pipeline aborted
result 352/360: pipeline aborted
result 353/360: pipeline aborted
result 354/360: pipeline aborted
result 355/360: pipeline aborted
result 356/360: pipeline aborted
result 357/360: pipeline aborted
result 358/360: pipeline aborted
result 359/360: pipeline aborted
ok
[17:13:15.016](0.035s) ok 21 - libpq_pipeline uniqviol
### Stopping node "main" using mode fast
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/data/t_001_libpq_pipeline_main_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "main"
[17:13:15.126](0.109s) 1..21
[17:13:15.127](0.001s) # Looks like you failed 1 test of 21.