# Checking port 58779
# Found port 58779
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=58779 host=/tmp/Um4Ot22C5Z
Log file: /tmp/cirrus-ci-build/build/testrun/libpq_pipeline/001_libpq_pipeline/log/001_libpq_pipeline_main.log
[08:48:20.126](0.017s) # 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 37364
# Running: libpq_pipeline -r 700 cancel port=58779 host=/tmp/Um4Ot22C5Z dbname='postgres'
test cancellations... 
libpq_pipeline:265: query did not fail when it was expected
[08:51:20.941](180.815s) not ok 1 - libpq_pipeline cancel
[08:51:20.941](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=58779 host=/tmp/Um4Ot22C5Z dbname='postgres'
test error cases... ok
[08:51:20.954](0.014s) ok 2 - libpq_pipeline disallowed_in_pipeline
[08:51:20.955](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=58779 host=/tmp/Um4Ot22C5Z dbname='postgres'
multi pipeline... ok
[08:51:20.968](0.013s) ok 4 - libpq_pipeline multi_pipelines
[08:51:20.969](0.001s) 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=58779 host=/tmp/Um4Ot22C5Z dbname='postgres'
nosync... ok
[08:51:20.982](0.013s) ok 6 - libpq_pipeline nosync
[08:51:20.983](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=58779 host=/tmp/Um4Ot22C5Z 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
[08:51:21.017](0.035s) ok 8 - libpq_pipeline pipeline_abort
[08:51:21.018](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=58779 host=/tmp/Um4Ot22C5Z dbname='postgres'

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

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