make USE_PGXS=1 install,fail

[ghost]

[postgres@zys-spider-215 imgsmlr-master]$ make USE_PGXS=1 installcheck
/usr/local/pgsql/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --psqldir='/usr/local/pgsql/bin' --dbname=contrib_regression imgsmlr
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test imgsmlr ... FAILED

======================
1 of 1 tests failed.

The differences that caused some tests to fail can be viewed in the
file "/usr/local/src/imgsmlr-master/regression.diffs". A copy of the test summary that you see
above is saved in the file "/usr/local/src/imgsmlr-master/regression.out".

make: *** [installcheck] Error 1

[akorotkov]

Please post contents of "/usr/local/src/imgsmlr-master/regression.diffs"

[ghost]

my psql server version is 9.4.4

[ghost]

[postgres@zys-spider-215 imgsmlr-master]$ cat regression.diffs
*** /usr/local/src/imgsmlr-master/expected/imgsmlr.out 2018-02-24 05:08:51.000000000 +0800
--- /usr/local/src/imgsmlr-master/results/imgsmlr.out 2018-10-17 17:47:17.136327179 +0800

---

*** 59,205 ****
id | id | round
----+----+--------
1 | 1 | 0.0000
! 1 | 2 | 1.5411
! 1 | 3 | 1.6179
! 1 | 4 | 2.8484
! 1 | 5 | 3.1757
! 1 | 6 | 2.7149
! 1 | 7 | 3.7669
! 1 | 8 | 3.8673
! 1 | 9 | 3.8833
! 1 | 10 | 4.7472
! 1 | 11 | 4.3779
! 1 | 12 | 3.5497
! 2 | 1 | 1.5411
2 | 2 | 0.0000
! 2 | 3 | 1.2575
! 2 | 4 | 2.7384
! 2 | 5 | 2.8913
! 2 | 6 | 2.6645
! 2 | 7 | 3.7849
! 2 | 8 | 3.8382
! 2 | 9 | 3.8564
! 2 | 10 | 4.9827
! 2 | 11 | 4.5090
! 2 | 12 | 3.7336
! 3 | 1 | 1.6179
! 3 | 2 | 1.2575
3 | 3 | 0.0000
! 3 | 4 | 2.7808
! 3 | 5 | 3.0869
! 3 | 6 | 2.7949
! 3 | 7 | 3.8342
! 3 | 8 | 3.9121
! 3 | 9 | 3.9258
! 3 | 10 | 4.8348
! 3 | 11 | 4.4050
! 3 | 12 | 3.6224
! 4 | 1 | 2.8484
! 4 | 2 | 2.7384
! 4 | 3 | 2.7808
4 | 4 | 0.0000
! 4 | 5 | 2.4249
! 4 | 6 | 2.0933
! 4 | 7 | 3.7250
! 4 | 8 | 3.6681
! 4 | 9 | 3.6846
! 4 | 10 | 5.0549
! 4 | 11 | 4.6132
! 4 | 12 | 3.8741
! 5 | 1 | 3.1757
! 5 | 2 | 2.8913
! 5 | 3 | 3.0869
! 5 | 4 | 2.4249
5 | 5 | 0.0000
! 5 | 6 | 2.9383
! 5 | 7 | 3.5100
! 5 | 8 | 3.4645
! 5 | 9 | 3.4829
! 5 | 10 | 5.1797
! 5 | 11 | 4.7246
! 5 | 12 | 3.8624
! 6 | 1 | 2.7149
! 6 | 2 | 2.6645
! 6 | 3 | 2.7949
! 6 | 4 | 2.0933
! 6 | 5 | 2.9383
6 | 6 | 0.0000
! 6 | 7 | 3.6537
! 6 | 8 | 3.7144
! 6 | 9 | 3.7347
! 6 | 10 | 5.1326
! 6 | 11 | 4.5488
! 6 | 12 | 3.9115
! 7 | 1 | 3.7669
! 7 | 2 | 3.7849
! 7 | 3 | 3.8342
! 7 | 4 | 3.7250
! 7 | 5 | 3.5100
! 7 | 6 | 3.6537
7 | 7 | 0.0000
! 7 | 8 | 1.2442
! 7 | 9 | 1.2549
! 7 | 10 | 5.0754
! 7 | 11 | 4.6682
! 7 | 12 | 4.0868
! 8 | 1 | 3.8673
! 8 | 2 | 3.8382
! 8 | 3 | 3.9121
! 8 | 4 | 3.6681
! 8 | 5 | 3.4645
! 8 | 6 | 3.7144
! 8 | 7 | 1.2442
8 | 8 | 0.0000
! 8 | 9 | 0.0380
! 8 | 10 | 5.2355
! 8 | 11 | 4.8206
! 8 | 12 | 4.1464
! 9 | 1 | 3.8833
! 9 | 2 | 3.8564
! 9 | 3 | 3.9258
! 9 | 4 | 3.6846
! 9 | 5 | 3.4829
! 9 | 6 | 3.7347
! 9 | 7 | 1.2549
! 9 | 8 | 0.0380
9 | 9 | 0.0000
! 9 | 10 | 5.2370
! 9 | 11 | 4.8217
! 9 | 12 | 4.1514
! 10 | 1 | 4.7472
! 10 | 2 | 4.9827
! 10 | 3 | 4.8348
! 10 | 4 | 5.0549
! 10 | 5 | 5.1797
! 10 | 6 | 5.1326
! 10 | 7 | 5.0754
! 10 | 8 | 5.2355
! 10 | 9 | 5.2370
10 | 10 | 0.0000
! 10 | 11 | 3.0530
! 10 | 12 | 3.1208
! 11 | 1 | 4.3779
! 11 | 2 | 4.5090
! 11 | 3 | 4.4050
! 11 | 4 | 4.6132
! 11 | 5 | 4.7246
! 11 | 6 | 4.5488
! 11 | 7 | 4.6682
! 11 | 8 | 4.8206
! 11 | 9 | 4.8217
! 11 | 10 | 3.0530
11 | 11 | 0.0000
11 | 12 | 3.1781
! 12 | 1 | 3.5497
! 12 | 2 | 3.7336
! 12 | 3 | 3.6224
! 12 | 4 | 3.8741
! 12 | 5 | 3.8624
! 12 | 6 | 3.9115
! 12 | 7 | 4.0868
! 12 | 8 | 4.1464
! 12 | 9 | 4.1514
! 12 | 10 | 3.1208
12 | 11 | 3.1781
12 | 12 | 0.0000
(144 rows)
--- 59,205 ----
id | id | round
----+----+--------
1 | 1 | 0.0000
! 1 | 2 | 1.5499
! 1 | 3 | 1.6159
! 1 | 4 | 2.8597
! 1 | 5 | 3.1844
! 1 | 6 | 2.7292
! 1 | 7 | 3.7746
! 1 | 8 | 3.8756
! 1 | 9 | 3.8916
! 1 | 10 | 4.7468
! 1 | 11 | 4.3770
! 1 | 12 | 3.5522
! 2 | 1 | 1.5499
2 | 2 | 0.0000
! 2 | 3 | 1.2565
! 2 | 4 | 2.7438
! 2 | 5 | 2.8960
! 2 | 6 | 2.6721
! 2 | 7 | 3.7896
! 2 | 8 | 3.8436
! 2 | 9 | 3.8618
! 2 | 10 | 4.9851
! 2 | 11 | 4.5120
! 2 | 12 | 3.7382
! 3 | 1 | 1.6159
! 3 | 2 | 1.2565
3 | 3 | 0.0000
! 3 | 4 | 2.7837
! 3 | 5 | 3.0885
! 3 | 6 | 2.7983
! 3 | 7 | 3.8356
! 3 | 8 | 3.9139
! 3 | 9 | 3.9276
! 3 | 10 | 4.8350
! 3 | 11 | 4.4051
! 3 | 12 | 3.6227
! 4 | 1 | 2.8597
! 4 | 2 | 2.7438
! 4 | 3 | 2.7837
4 | 4 | 0.0000
! 4 | 5 | 2.4292
! 4 | 6 | 2.0993
! 4 | 7 | 3.7311
! 4 | 8 | 3.6741
! 4 | 9 | 3.6906
! 4 | 10 | 5.0569
! 4 | 11 | 4.6157
! 4 | 12 | 3.8772
! 5 | 1 | 3.1844
! 5 | 2 | 2.8960
! 5 | 3 | 3.0885
! 5 | 4 | 2.4292
5 | 5 | 0.0000
! 5 | 6 | 2.9476
! 5 | 7 | 3.5138
! 5 | 8 | 3.4678
! 5 | 9 | 3.4861
! 5 | 10 | 5.1824
! 5 | 11 | 4.7274
! 5 | 12 | 3.8656
! 6 | 1 | 2.7292
! 6 | 2 | 2.6721
! 6 | 3 | 2.7983
! 6 | 4 | 2.0993
! 6 | 5 | 2.9476
6 | 6 | 0.0000
! 6 | 7 | 3.6673
! 6 | 8 | 3.7291
! 6 | 9 | 3.7493
! 6 | 10 | 5.1358
! 6 | 11 | 4.5512
! 6 | 12 | 3.9189
! 7 | 1 | 3.7746
! 7 | 2 | 3.7896
! 7 | 3 | 3.8356
! 7 | 4 | 3.7311
! 7 | 5 | 3.5138
! 7 | 6 | 3.6673
7 | 7 | 0.0000
! 7 | 8 | 1.2451
! 7 | 9 | 1.2558
! 7 | 10 | 5.0763
! 7 | 11 | 4.6685
! 7 | 12 | 4.0880
! 8 | 1 | 3.8756
! 8 | 2 | 3.8436
! 8 | 3 | 3.9139
! 8 | 4 | 3.6741
! 8 | 5 | 3.4678
! 8 | 6 | 3.7291
! 8 | 7 | 1.2451
8 | 8 | 0.0000
! 8 | 9 | 0.0381
! 8 | 10 | 5.2375
! 8 | 11 | 4.8223
! 8 | 12 | 4.1483
! 9 | 1 | 3.8916
! 9 | 2 | 3.8618
! 9 | 3 | 3.9276
! 9 | 4 | 3.6906
! 9 | 5 | 3.4861
! 9 | 6 | 3.7493
! 9 | 7 | 1.2558
! 9 | 8 | 0.0381
9 | 9 | 0.0000
! 9 | 10 | 5.2390
! 9 | 11 | 4.8233
! 9 | 12 | 4.1534
! 10 | 1 | 4.7468
! 10 | 2 | 4.9851
! 10 | 3 | 4.8350
! 10 | 4 | 5.0569
! 10 | 5 | 5.1824
! 10 | 6 | 5.1358
! 10 | 7 | 5.0763
! 10 | 8 | 5.2375
! 10 | 9 | 5.2390
10 | 10 | 0.0000
! 10 | 11 | 3.0531
! 10 | 12 | 3.1209
! 11 | 1 | 4.3770
! 11 | 2 | 4.5120
! 11 | 3 | 4.4051
! 11 | 4 | 4.6157
! 11 | 5 | 4.7274
! 11 | 6 | 4.5512
! 11 | 7 | 4.6685
! 11 | 8 | 4.8223
! 11 | 9 | 4.8233
! 11 | 10 | 3.0531
11 | 11 | 0.0000
11 | 12 | 3.1781
! 12 | 1 | 3.5522
! 12 | 2 | 3.7382
! 12 | 3 | 3.6227
! 12 | 4 | 3.8772
! 12 | 5 | 3.8656
! 12 | 6 | 3.9189
! 12 | 7 | 4.0880
! 12 | 8 | 4.1483
! 12 | 9 | 4.1534
! 12 | 10 | 3.1209
12 | 11 | 3.1781
12 | 12 | 0.0000
(144 rows)

---

*** 208,354 ****
id | id | round
----+----+--------
1 | 1 | 0.0000
! 1 | 2 | 0.5867
! 1 | 3 | 0.6410
! 1 | 4 | 1.1409
! 1 | 5 | 1.3776
! 1 | 6 | 1.5149
! 1 | 7 | 3.1433
! 1 | 8 | 3.4325
! 1 | 9 | 3.4649
! 1 | 10 | 4.0842
! 1 | 11 | 3.3723
! 1 | 12 | 2.4935
! 2 | 1 | 0.5867
2 | 2 | 0.0000
! 2 | 3 | 0.7878
! 2 | 4 | 1.1464
! 2 | 5 | 1.2832
! 2 | 6 | 1.4290
! 2 | 7 | 3.2926
! 2 | 8 | 3.5544
! 2 | 9 | 3.5892
! 2 | 10 | 4.4382
! 2 | 11 | 3.6304
! 2 | 12 | 2.8089
! 3 | 1 | 0.6410
! 3 | 2 | 0.7878
3 | 3 | 0.0000
! 3 | 4 | 1.0521
! 3 | 5 | 1.3870
! 3 | 6 | 1.4914
! 3 | 7 | 3.0093
! 3 | 8 | 3.2599
! 3 | 9 | 3.2895
! 3 | 10 | 4.0590
! 3 | 11 | 3.2181
! 3 | 12 | 2.4356
! 4 | 1 | 1.1409
! 4 | 2 | 1.1464
! 4 | 3 | 1.0521
4 | 4 | 0.0000
! 4 | 5 | 0.5918
! 4 | 6 | 0.7625
! 4 | 7 | 2.6852
! 4 | 8 | 2.9110
! 4 | 9 | 2.9435
! 4 | 10 | 3.8710
! 4 | 11 | 2.9798
! 4 | 12 | 2.1815
! 5 | 1 | 1.3776
! 5 | 2 | 1.2832
! 5 | 3 | 1.3870
! 5 | 4 | 0.5918
5 | 5 | 0.0000
! 5 | 6 | 0.6988
! 5 | 7 | 2.9093
! 5 | 8 | 3.1235
! 5 | 9 | 3.1573
! 5 | 10 | 4.0526
! 5 | 11 | 3.2134
! 5 | 12 | 2.3678
! 6 | 1 | 1.5149
! 6 | 2 | 1.4290
! 6 | 3 | 1.4914
! 6 | 4 | 0.7625
! 6 | 5 | 0.6988
6 | 6 | 0.0000
! 6 | 7 | 2.8572
! 6 | 8 | 3.0858
! 6 | 9 | 3.1190
! 6 | 10 | 3.7984
! 6 | 11 | 2.7854
! 6 | 12 | 2.0468
! 7 | 1 | 3.1433
! 7 | 2 | 3.2926
! 7 | 3 | 3.0093
! 7 | 4 | 2.6852
! 7 | 5 | 2.9093
! 7 | 6 | 2.8572
7 | 7 | 0.0000
! 7 | 8 | 0.6971
! 7 | 9 | 0.7130
! 7 | 10 | 4.3993
! 7 | 11 | 3.5102
! 7 | 12 | 3.2894
! 8 | 1 | 3.4325
! 8 | 2 | 3.5544
! 8 | 3 | 3.2599
! 8 | 4 | 2.9110
! 8 | 5 | 3.1235
! 8 | 6 | 3.0858
! 8 | 7 | 0.6971
8 | 8 | 0.0000
! 8 | 9 | 0.0421
! 8 | 10 | 4.6892
! 8 | 11 | 3.7489
! 8 | 12 | 3.5759
! 9 | 1 | 3.4649
! 9 | 2 | 3.5892
! 9 | 3 | 3.2895
! 9 | 4 | 2.9435
! 9 | 5 | 3.1573
! 9 | 6 | 3.1190
! 9 | 7 | 0.7130
! 9 | 8 | 0.0421
9 | 9 | 0.0000
! 9 | 10 | 4.6962
! 9 | 11 | 3.7582
! 9 | 12 | 3.5938
! 10 | 1 | 4.0842
! 10 | 2 | 4.4382
! 10 | 3 | 4.0590
! 10 | 4 | 3.8710
! 10 | 5 | 4.0526
! 10 | 6 | 3.7984
! 10 | 7 | 4.3993
! 10 | 8 | 4.6892
! 10 | 9 | 4.6962
10 | 10 | 0.0000
! 10 | 11 | 1.8257
! 10 | 12 | 2.0829
! 11 | 1 | 3.3723
! 11 | 2 | 3.6304
! 11 | 3 | 3.2181
! 11 | 4 | 2.9798
! 11 | 5 | 3.2134
! 11 | 6 | 2.7854
! 11 | 7 | 3.5102
! 11 | 8 | 3.7489
! 11 | 9 | 3.7582
! 11 | 10 | 1.8257
11 | 11 | 0.0000
11 | 12 | 1.2968
! 12 | 1 | 2.4935
! 12 | 2 | 2.8089
! 12 | 3 | 2.4356
! 12 | 4 | 2.1815
! 12 | 5 | 2.3678
! 12 | 6 | 2.0468
! 12 | 7 | 3.2894
! 12 | 8 | 3.5759
! 12 | 9 | 3.5938
! 12 | 10 | 2.0829
12 | 11 | 1.2968
12 | 12 | 0.0000
(144 rows)
--- 208,354 ----
id | id | round
----+----+--------
1 | 1 | 0.0000
! 1 | 2 | 0.5968
! 1 | 3 | 0.6292
! 1 | 4 | 1.1425
! 1 | 5 | 1.3847
! 1 | 6 | 1.5240
! 1 | 7 | 3.1347
! 1 | 8 | 3.4230
! 1 | 9 | 3.4552
! 1 | 10 | 4.0722
! 1 | 11 | 3.3602
! 1 | 12 | 2.4833
! 2 | 1 | 0.5968
2 | 2 | 0.0000
! 2 | 3 | 0.7769
! 2 | 4 | 1.1451
! 2 | 5 | 1.2831
! 2 | 6 | 1.4357
! 2 | 7 | 3.2845
! 2 | 8 | 3.5451
! 2 | 9 | 3.5799
! 2 | 10 | 4.4330
! 2 | 11 | 3.6232
! 2 | 12 | 2.8031
! 3 | 1 | 0.6292
! 3 | 2 | 0.7769
3 | 3 | 0.0000
! 3 | 4 | 1.0499
! 3 | 5 | 1.3862
! 3 | 6 | 1.4890
! 3 | 7 | 3.0112
! 3 | 8 | 3.2606
! 3 | 9 | 3.2903
! 3 | 10 | 4.0595
! 3 | 11 | 3.2179
! 3 | 12 | 2.4357
! 4 | 1 | 1.1425
! 4 | 2 | 1.1451
! 4 | 3 | 1.0499
4 | 4 | 0.0000
! 4 | 5 | 0.5969
! 4 | 6 | 0.7624
! 4 | 7 | 2.6807
! 4 | 8 | 2.9057
! 4 | 9 | 2.9382
! 4 | 10 | 3.8654
! 4 | 11 | 2.9725
! 4 | 12 | 2.1760
! 5 | 1 | 1.3847
! 5 | 2 | 1.2831
! 5 | 3 | 1.3862
! 5 | 4 | 0.5969
5 | 5 | 0.0000
! 5 | 6 | 0.7035
! 5 | 7 | 2.9077
! 5 | 8 | 3.1211
! 5 | 9 | 3.1549
! 5 | 10 | 4.0507
! 5 | 11 | 3.2102
! 5 | 12 | 2.3655
! 6 | 1 | 1.5240
! 6 | 2 | 1.4357
! 6 | 3 | 1.4890
! 6 | 4 | 0.7624
! 6 | 5 | 0.7035
6 | 6 | 0.0000
! 6 | 7 | 2.8485
! 6 | 8 | 3.0762
! 6 | 9 | 3.1093
! 6 | 10 | 3.7838
! 6 | 11 | 2.7671
! 6 | 12 | 2.0317
! 7 | 1 | 3.1347
! 7 | 2 | 3.2845
! 7 | 3 | 3.0112
! 7 | 4 | 2.6807
! 7 | 5 | 2.9077
! 7 | 6 | 2.8485
7 | 7 | 0.0000
! 7 | 8 | 0.6970
! 7 | 9 | 0.7127
! 7 | 10 | 4.3997
! 7 | 11 | 3.5100
! 7 | 12 | 3.2903
! 8 | 1 | 3.4230
! 8 | 2 | 3.5451
! 8 | 3 | 3.2606
! 8 | 4 | 2.9057
! 8 | 5 | 3.1211
! 8 | 6 | 3.0762
! 8 | 7 | 0.6970
8 | 8 | 0.0000
! 8 | 9 | 0.0423
! 8 | 10 | 4.6899
! 8 | 11 | 3.7493
! 8 | 12 | 3.5768
! 9 | 1 | 3.4552
! 9 | 2 | 3.5799
! 9 | 3 | 3.2903
! 9 | 4 | 2.9382
! 9 | 5 | 3.1549
! 9 | 6 | 3.1093
! 9 | 7 | 0.7127
! 9 | 8 | 0.0423
9 | 9 | 0.0000
! 9 | 10 | 4.6968
! 9 | 11 | 3.7585
! 9 | 12 | 3.5946
! 10 | 1 | 4.0722
! 10 | 2 | 4.4330
! 10 | 3 | 4.0595
! 10 | 4 | 3.8654
! 10 | 5 | 4.0507
! 10 | 6 | 3.7838
! 10 | 7 | 4.3997
! 10 | 8 | 4.6899
! 10 | 9 | 4.6968
10 | 10 | 0.0000
! 10 | 11 | 1.8260
! 10 | 12 | 2.0833
! 11 | 1 | 3.3602
! 11 | 2 | 3.6232
! 11 | 3 | 3.2179
! 11 | 4 | 2.9725
! 11 | 5 | 3.2102
! 11 | 6 | 2.7671
! 11 | 7 | 3.5100
! 11 | 8 | 3.7493
! 11 | 9 | 3.7585
! 11 | 10 | 1.8260
11 | 11 | 0.0000
11 | 12 | 1.2968
! 12 | 1 | 2.4833
! 12 | 2 | 2.8031
! 12 | 3 | 2.4357
! 12 | 4 | 2.1760
! 12 | 5 | 2.3655
! 12 | 6 | 2.0317
! 12 | 7 | 3.2903
! 12 | 8 | 3.5768
! 12 | 9 | 3.5946
! 12 | 10 | 2.0833
12 | 11 | 1.2968
12 | 12 | 0.0000
(144 rows)

======================================================================

[ghost]

I`m looking forword to your reply,thank you in advance!

[Joezczhang]

I`m looking forword to your reply,thank you in advance!

Hello ghost:

I had the same failure with you. How did you solve the problem?