# Checking port 59335
# Found port 59335
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=59335 host=/tmp/fEH2xmgVxd
Log file: /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/log/001_libpq_pipeline_main.log
[03:17:09.715](0.013s) # 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 36202
# Running: libpq_pipeline -r 700 cancel port=59335 host=/tmp/fEH2xmgVxd dbname='postgres'
test cancellations... 
libpq_pipeline:259: query did not fail when it was expected
[03:20:10.466](180.751s) not ok 1 - libpq_pipeline cancel
[03:20:10.466](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=59335 host=/tmp/fEH2xmgVxd dbname='postgres'
test error cases... ok
[03:20:10.481](0.014s) ok 2 - libpq_pipeline disallowed_in_pipeline
[03:20:10.481](0.001s) 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=59335 host=/tmp/fEH2xmgVxd dbname='postgres'
multi pipeline... ok
[03:20:10.495](0.014s) ok 4 - libpq_pipeline multi_pipelines
[03:20:10.495](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=59335 host=/tmp/fEH2xmgVxd dbname='postgres'
nosync... ok
[03:20:10.509](0.014s) ok 6 - libpq_pipeline nosync
[03:20:10.510](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=59335 host=/tmp/fEH2xmgVxd 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
[03:20:10.545](0.035s) ok 8 - libpq_pipeline pipeline_abort
[03:20:10.546](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=59335 host=/tmp/fEH2xmgVxd dbname='postgres'

pipeline idle...
ok - 1
NOTICE 1: WARNING:  you don't own a lock of type ExclusiveLock
ok - 2
[03:20:10.560](0.014s) ok 10 - libpq_pipeline pipeline_idle
[03:20:10.560](0.001s) ok 11 - pipeline_idle trace match
# Running: libpq_pipeline -r 700 pipelined_insert port=59335 host=/tmp/fEH2xmgVxd dbname='postgres'
ok
pipeline sync sent
[03:20:10.596](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=59335 host=/tmp/fEH2xmgVxd dbname='postgres'
prepared... closing statement..creating portal... closing portal... ok
[03:20:10.610](0.014s) ok 13 - libpq_pipeline prepared
[03:20:10.611](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=59335 host=/tmp/fEH2xmgVxd dbname='postgres'
simple pipeline... ok
[03:20:10.624](0.014s) ok 15 - libpq_pipeline simple_pipeline
[03:20:10.625](0.000s) 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=59335 host=/tmp/fEH2xmgVxd 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
[03:20:10.638](0.014s) ok 17 - libpq_pipeline singlerow
[03:20:10.639](0.000s) 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=59335 host=/tmp/fEH2xmgVxd 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
[03:20:10.653](0.014s) ok 19 - libpq_pipeline transaction
[03:20:10.654](0.001s) ok 20 - transaction trace match
# Running: libpq_pipeline -r 700 uniqviol port=59335 host=/tmp/fEH2xmgVxd dbname='postgres'
uniqviol ...NOTICE:  table "ppln_uniqviol" does not exist, skipping
................................................................................................................................................................
switch to reading
................................................................................E.......................................................................
switch to reading
result 0/312: 0
result 1/312: 1
result 2/312: 2
result 3/312: 3
result 4/312: 4
result 5/312: 5
result 6/312: 6
result 7/312: 7
result 8/312: 8
result 9/312: 9
result 10/312: 10
result 11/312: 11
result 12/312: 12
result 13/312: 13
result 14/312: 14
result 15/312: 15
result 16/312: 16
result 17/312: 17
result 18/312: 18
result 19/312: 19
result 20/312: 20
result 21/312: 21
result 22/312: 22
result 23/312: 23
result 24/312: 24
result 25/312: 25
result 26/312: 26
result 27/312: 27
result 28/312: 28
result 29/312: 29
result 30/312: 30
result 31/312: 31
result 32/312: 32
result 33/312: 33
result 34/312: 34
result 35/312: 35
result 36/312: 36
result 37/312: 37
result 38/312: 38
result 39/312: 39
result 40/312: 40
result 41/312: 41
result 42/312: 42
result 43/312: 43
result 44/312: 44
result 45/312: 45
result 46/312: 46
result 47/312: 47
result 48/312: 48
result 49/312: 49
result 50/312: 50
result 51/312: 51
result 52/312: 52
result 53/312: 53
result 54/312: 54
result 55/312: 55
result 56/312: 56
result 57/312: 57
result 58/312: 58
result 59/312: 59
result 60/312: 60
result 61/312: 61
result 62/312: 62
result 63/312: 63
result 64/312: 64
result 65/312: 65
result 66/312: 66
result 67/312: 67
result 68/312: 68
result 69/312: 69
result 70/312: 70
result 71/312: 71
result 72/312: 72
result 73/312: 73
result 74/312: 74
result 75/312: 75
result 76/312: 76
result 77/312: 77
result 78/312: 78
result 79/312: 79
result 80/312: 80
result 81/312: 81
result 82/312: 82
result 83/312: 83
result 84/312: 84
result 85/312: 85
result 86/312: 86
result 87/312: 87
result 88/312: 88
result 89/312: 89
result 90/312: 90
result 91/312: 91
result 92/312: 92
result 93/312: 93
result 94/312: 94
result 95/312: 95
result 96/312: 96
result 97/312: 97
result 98/312: 98
result 99/312: 99
result 100/312: 100
result 101/312: 101
result 102/312: 102
result 103/312: 103
result 104/312: 104
result 105/312: 105
result 106/312: 106
result 107/312: 107
result 108/312: 108
result 109/312: 109
result 110/312: 110
result 111/312: 111
result 112/312: 112
result 113/312: 113
result 114/312: 114
result 115/312: 115
result 116/312: 116
result 117/312: 117
result 118/312: 118
result 119/312: 119
result 120/312: 120
result 121/312: 121
result 122/312: 122
result 123/312: 123
result 124/312: 124
result 125/312: 125
result 126/312: 126
result 127/312: 127
result 128/312: 128
result 129/312: 129
result 130/312: 130
..................................................
done writing
result 131/362: 131
result 132/362: 132
result 133/362: 133
result 134/362: 134
result 135/362: 135
result 136/362: 136
result 137/362: 137
result 138/362: 138
result 139/362: 139
result 140/362: 140
result 141/362: 141
result 142/362: 142
result 143/362: 143
result 144/362: 144
result 145/362: 145
result 146/362: 146
result 147/362: 147
result 148/362: 148
result 149/362: 149
result 150/362: 150
result 151/362: 151
result 152/362: 152
result 153/362: 153
result 154/362: 154
result 155/362: 155
result 156/362: 156
result 157/362: 157
result 158/362: 158
result 159/362: 159
result 160/362: 160
result 161/362: 161
result 162/362: 162
result 163/362: 163
result 164/362: 164
result 165/362: 165
result 166/362: 166
result 167/362: 167
result 168/362: 168
result 169/362: 169
result 170/362: 170
result 171/362: 171
result 172/362: 172
result 173/362: 173
result 174/362: 174
result 175/362: 175
result 176/362: 176
result 177/362: 177
result 178/362: 178
result 179/362: 179
result 180/362: 180
result 181/362: 181
result 182/362: 182
result 183/362: 183
result 184/362: 184
result 185/362: 185
result 186/362: 186
result 187/362: 187
result 188/362: 188
result 189/362: 189
result 190/362: 190
result 191/362: 191
result 192/362: 192
result 193/362: 193
result 194/362: 194
result 195/362: 195
result 196/362: 196
result 197/362: 197
result 198/362: 198
result 199/362: 199
result 200/362: 200
result 201/362: 201
result 202/362: 202
result 203/362: 203
result 204/362: 204
result 205/362: 205
result 206/362: 206
result 207/362: 207
result 208/362: 208
result 209/362: 209
result 210/362: 210
result 211/362: 211
result 212/362: 212
result 213/362: 213
result 214/362: 214
result 215/362: 215
result 216/362: 216
result 217/362: 217
result 218/362: 218
result 219/362: 219
result 220/362: 220
result 221/362: 221
result 222/362: 222
result 223/362: 223
result 224/362: 224
result 225/362: 225
result 226/362: 226
result 227/362: 227
result 228/362: 228
result 229/362: 229
result 230/362: 230
result 231/362: 231
result 232/362: 232
result 233/362: 233
result 234/362: 234
result 235/362: 235
result 236/362: 236
result 237/362: 237
result 238/362: 238
result 239/362: 239
result 240/362 (error): ERROR:  duplicate key value violates unique constraint "ppln_uniqviol_pkey"
DETAIL:  Key (id)=(120) already exists.

result 241/362: pipeline aborted
result 242/362: pipeline aborted
result 243/362: pipeline aborted
result 244/362: pipeline aborted
result 245/362: pipeline aborted
result 246/362: pipeline aborted
result 247/362: pipeline aborted
result 248/362: pipeline aborted
result 249/362: pipeline aborted
result 250/362: pipeline aborted
result 251/362: pipeline aborted
result 252/362: pipeline aborted
result 253/362: pipeline aborted
result 254/362: pipeline aborted
result 255/362: pipeline aborted
result 256/362: pipeline aborted
result 257/362: pipeline aborted
result 258/362: pipeline aborted
result 259/362: pipeline aborted
result 260/362: pipeline aborted
result 261/362: pipeline aborted
result 262/362: pipeline aborted
result 263/362: pipeline aborted
result 264/362: pipeline aborted
result 265/362: pipeline aborted
result 266/362: pipeline aborted
result 267/362: pipeline aborted
result 268/362: pipeline aborted
result 269/362: pipeline aborted
result 270/362: pipeline aborted
result 271/362: pipeline aborted
result 272/362: pipeline aborted
result 273/362: pipeline aborted
result 274/362: pipeline aborted
result 275/362: pipeline aborted
result 276/362: pipeline aborted
result 277/362: pipeline aborted
result 278/362: pipeline aborted
result 279/362: pipeline aborted
result 280/362: pipeline aborted
result 281/362: pipeline aborted
result 282/362: pipeline aborted
result 283/362: pipeline aborted
result 284/362: pipeline aborted
result 285/362: pipeline aborted
result 286/362: pipeline aborted
result 287/362: pipeline aborted
result 288/362: pipeline aborted
result 289/362: pipeline aborted
result 290/362: pipeline aborted
result 291/362: pipeline aborted
result 292/362: pipeline aborted
result 293/362: pipeline aborted
result 294/362: pipeline aborted
result 295/362: pipeline aborted
result 296/362: pipeline aborted
result 297/362: pipeline aborted
result 298/362: pipeline aborted
result 299/362: pipeline aborted
result 300/362: pipeline aborted
result 301/362: pipeline aborted
result 302/362: pipeline aborted
result 303/362: pipeline aborted
result 304/362: pipeline aborted
result 305/362: pipeline aborted
result 306/362: pipeline aborted
result 307/362: pipeline aborted
result 308/362: pipeline aborted
result 309/362: pipeline aborted
result 310/362: pipeline aborted
result 311/362: pipeline aborted
result 312/362: pipeline aborted
result 313/362: pipeline aborted
result 314/362: pipeline aborted
result 315/362: pipeline aborted
result 316/362: pipeline aborted
result 317/362: pipeline aborted
result 318/362: pipeline aborted
result 319/362: pipeline aborted
result 320/362: pipeline aborted
result 321/362: pipeline aborted
result 322/362: pipeline aborted
result 323/362: pipeline aborted
result 324/362: pipeline aborted
result 325/362: pipeline aborted
result 326/362: pipeline aborted
result 327/362: pipeline aborted
result 328/362: pipeline aborted
result 329/362: pipeline aborted
result 330/362: pipeline aborted
result 331/362: pipeline aborted
result 332/362: pipeline aborted
result 333/362: pipeline aborted
result 334/362: pipeline aborted
result 335/362: pipeline aborted
result 336/362: pipeline aborted
result 337/362: pipeline aborted
result 338/362: pipeline aborted
result 339/362: pipeline aborted
result 340/362: pipeline aborted
result 341/362: pipeline aborted
result 342/362: pipeline aborted
result 343/362: pipeline aborted
result 344/362: pipeline aborted
result 345/362: pipeline aborted
result 346/362: pipeline aborted
result 347/362: pipeline aborted
result 348/362: pipeline aborted
result 349/362: pipeline aborted
result 350/362: pipeline aborted
result 351/362: pipeline aborted
result 352/362: pipeline aborted
result 353/362: pipeline aborted
result 354/362: pipeline aborted
result 355/362: pipeline aborted
result 356/362: pipeline aborted
result 357/362: pipeline aborted
result 358/362: pipeline aborted
result 359/362: pipeline aborted
result 360/362: pipeline aborted
result 361/362: pipeline aborted
ok
[03:20:10.689](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"
[03:20:10.799](0.110s) 1..21
[03:20:10.800](0.001s) # Looks like you failed 1 test of 21.