Compilation failure under windows VC = Microsoft's Visual Studio C++ stuf

[cvvergara]

@robe2, @woodbri
I am opening this issue, now that #337 passed tests on Winnie (PostGIS/PgRouting windows buildbot)

[robe2]

I'm closing this out as a dupe of #336

The issue on that one seems to be an encoding one. My VC++ development build happens to default to WIN1252 (I think most production ones those are UTF-8) and that issue only appears if I have a WIN1252 encoded database or my psql is in WIN1252 mode (which sadly is probably many people).

[robe2]

Okay I was mistaken and there are a bunch of other issues I am seeing when testing against VC++ postgesql build so reopening.

$stats = {
           'doc/test/test.conf' => [
                                     {
                                       'comment' => 'documentation SQL tests for any versions.',
                                       'doc/test/alphashape-any.test' => 'Passed',
                                       'doc/test/analyzeGraph-any.test' => 'Passed',
                                       'doc/test/analyzeOneway-any.test' => 'Passed',
                                       'doc/test/apspJohnson-any.test' => 'Passed',
                                       'doc/test/apspWarshall-any.test' => 'FAILED: 7c7
< 6|1|11|2
---
> 6|1|9|0
9,10c9,10
< 8|1|12|1
< 9|1|13|4
---
> 8|1|11|2
> 9|1|12|1',
                                       'doc/test/astar-any.test' => 'Passed',
                                       'doc/test/bdDijkstra-any.test' => 'Passed',
                                       'doc/test/bdstar-any.test' => 'Passed',
                                       'doc/test/createTopology-any.test' => 'Passed',
                                       'doc/test/createVertTab-any.test' => 'Passed',
                                       'doc/test/dijkstra-any.test' => 'Passed',
                                       'doc/test/drivingDistance-any.test' => 'Passed',
                                       'doc/test/kdijkstra-any.test' => 'Passed',
                                       'doc/test/nodeNetwork-any.test' => 'Passed',
                                       'doc/test/pointsAsPolygon-any.test' => 'Passed',
                                       'doc/test/sampledata.test' => 'Passed',
                                       'doc/test/trsp-any.test' => 'FAILED: 1,12c1,2
< 0|7|6|1
< 1|8|7|1
< 2|5|8|1
< 3|6|11|1
< 4|11|13|1
< 5|12|-1|0
< 0|7|6|1
< 1|8|7|1
< 2|5|8|1
< 3|6|11|1
< 4|11|13|1
< 5|12|-1|0
---
> 0|-1|0|8.89318162514244e-323
> 0|-1|0|8.89318162514244e-323',
                                       'doc/test/tsp-any.test' => 'Passed',
                                       'doc/test/utilities-any.test' => 'Passed'
                                     }
                                   ],
           'src/apsp_johnson/test/test.conf' => [
                                                  {
                                                    'comment' => 'APSP Johnson test for any versions.',
                                                    'src/apsp_johnson/test/apsp_johnson-any-00.test' => 'Passed'
                                                  }
                                                ],
           'src/apsp_warshall/test/test.conf' => [
                                                   {
                                                     'comment' => 'APSP Warshall test for any versions.',
                                                     'src/apsp_warshall/test/apsp_warshall-any-00.test' => 'Passed'
                                                   }
                                                 ],
           'src/astar/test/test.conf' => [
                                           {
                                             'comment' => 'astar test for any versions.',
                                             'src/astar/test/spas-any-00.test' => 'Passed',
                                             'src/astar/test/spas-any-01.test' => 'Passed'
                                           }
                                         ],
           'src/bd_astar/test/test.conf' => [
                                              {
                                                'comment' => 'Bi-directional AStar test for any versions.',
                                                'src/bd_astar/test/bd_astar-any-01.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-02.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-03.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-04.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-05.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-06.test' => 'Passed'
                                              }
                                            ],
           'src/bd_dijkstra/test/test.conf' => [
                                                 {
                                                   'comment' => 'Bi-directional Dijkstra test for any versions.',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-01.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-02.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-03.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-04.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-05.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-06.test' => 'Passed'
                                                 }
                                               ],
           'src/common/test/test.conf' => [
                                            {
                                              'comment' => 'pgr_createTopology, pgr_analyzegraph, and pgr_analyzeOneway tests for any versions.',
                                              'src/common/test/common-any-01.test' => 'Passed',
                                              'src/common/test/common-any-02.test' => 'Passed',
                                              'src/common/test/common-any-03.test' => 'Passed',
                                              'src/common/test/common-any-04.test' => 'Passed',
                                              'src/common/test/common-any-05.test' => 'Passed',
                                              'src/common/test/createTopology-any-01.test' => 'Passed',
                                              'src/common/test/createVerticesTable-any-01.test' => 'Passed',
                                              'src/common/test/gettablename-any-01.test' => 'Passed',
                                              'src/common/test/incrementalCreateTopology_any_01.test' => 'FAILED: 51c51
< 1|B|10|11|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
---
> 1|B|12|13|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
54c54
< 4|B|11|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
---
> 4|B|13|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
56,57c56,57
< 6|B|12|13|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
< 7|B|13|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
---
> 6|B|14|15|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
> 7|B|15|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
68c68
< 18|B|14|15|1|1|3.5|2.3|3.5|4|0102000000020000000000000000000C4066666666666602400000000000000C400000000000001040
---
> 18|B|10|11|1|1|3.5|2.3|3.5|4|0102000000020000000000000000000C4066666666666602400000000000000C400000000000001040
70,71c70,71
< 1|B|10|11|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
< 2|TF|11|17|-1|1|2|1|3|1|0102000000020000000000000000000040000000000000F03F0000000000000840000000000000F03F
---
> 1|B|12|13|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
> 2|TF|13|17|-1|1|2|1|3|1|0102000000020000000000000000000040000000000000F03F0000000000000840000000000000F03F
73c73
< 4|B|11|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
---
> 4|B|13|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
75,76c75,76
< 6|B|12|13|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
< 7|B|13|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
---
> 6|B|14|15|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
> 7|B|15|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
87c87
< 18|B|14|15|1|1|3.5|2.3|3.5|4|0102000000020000000000000000000C4066666666666602400000000000000C400000000000001040
---
> 18|B|10|11|1|1|3.5|2.3|3.5|4|0102000000020000000000000000000C4066666666666602400000000000000C400000000000001040
89,90c89,90
< 1|B|10|11|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
< 2|TF|11|17|-1|1|2|1|3|1|0102000000020000000000000000000040000000000000F03F0000000000000840000000000000F03F
---
> 1|B|12|13|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
> 2|TF|13|17|-1|1|2|1|3|1|0102000000020000000000000000000040000000000000F03F0000000000000840000000000000F03F
92c92
< 4|B|11|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
---
> 4|B|13|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
94,95c94,95
< 6|B|12|13|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
< 7|B|13|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
---
> 6|B|14|15|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
> 7|B|15|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
106c106
< 18|B|14|15|1|1|3.5|2.3|3.5|4|0102000000020000000000000000000C4066666666666602400000000000000C400000000000001040
---
> 18|B|10|11|1|1|3.5|2.3|3.5|4|0102000000020000000000000000000C4066666666666602400000000000000C400000000000001040',
                                              'src/common/test/isColumnInTable-any.test' => 'Passed',
                                              'src/common/test/isColumnIndexed-any.test' => 'Passed',
                                              'src/common/test/no_underscored-2x.test' => 'Passed',
                                              'src/common/test/pgr_checkVertTab_any_01.test' => 'Passed',
                                              'src/common/test/pgr_getColumnName_any_01.test' => 'Passed',
                                              'src/common/test/pgr_getColumnType_any_01.test' => 'Passed',
                                              'src/common/test/pgrouting_conversion_tools-any-01.test' => 'FAILED: 1a2
> WARNING:  ST_Line_Locate_Point signature was deprecated in 2.1.0. Please use ST_LineLocatePoint
2a4
> WARNING:  ST_Line_Locate_Point signature was deprecated in 2.1.0. Please use ST_LineLocatePoint
24a27
> WARNING:  ST_Line_Locate_Point signature was deprecated in 2.1.0. Please use ST_LineLocatePoint',
                                              'src/common/test/pgrouting_dmatrix_tools-any-01.test' => 'FAILED: 3a4
> WARNING:  ST_Line_Locate_Point signature was deprecated in 2.1.0. Please use ST_LineLocatePoint',
                                              'src/common/test/versionless-any-01.test' => 'Passed'
                                            }
                                          ],
           'src/dijkstra/test/test.conf' => [
                                              {
                                                'comment' => 'Dijkstra test for any versions.',
                                                'src/dijkstra/test/dijkstra-dir-00.test' => 'Passed',
                                                'src/dijkstra/test/dijkstra-dir-01.test' => 'Passed',
                                                'src/dijkstra/test/dijkstra-undi-00.test' => 'Passed',
                                                'src/dijkstra/test/dijkstra-undi-01.test' => 'Passed'
                                              }
                                            ],
           'src/driving_distance/test/test.conf' => [
                                                      {
                                                        'comment' => 'Driving Distance test for any versions.',
                                                        'src/driving_distance/test/drivingdistance-any-00.test' => 'Passed'
                                                      }
                                                    ],
           'src/kdijkstra/test/test.conf' => [
                                               {
                                                 'comment' => 'KDijkstra test for any versions.',
                                                 'src/kdijkstra/test/kdijkstra-any-01.test' => 'Passed',
                                                 'src/kdijkstra/test/kdijkstra-any-02.test' => 'Passed',
                                                 'src/kdijkstra/test/kdijkstra-any-03.test' => 'Passed',
                                                 'src/kdijkstra/test/vidstodmatrix-any-01.test' => 'Passed',
                                                 'src/kdijkstra/test/vidstodmatrix-any-02.test' => 'Passed'
                                               }
                                             ],
           'src/ksp/test/test.conf' => [
                                         {
                                           'comment' => 'KSP test for any versions.',
                                           'src/ksp/test/ksp-any-01.test' => 'Passed',
                                           'src/ksp/test/ksp-any-02.test' => 'Passed',
                                           'src/ksp/test/ksp-parallel-any-03.test' => 'Passed'
                                         }
                                       ],
           'src/trsp/test/test.conf' => [
                                          {
                                            'comment' => 'TRSP test for any versions.',
                                            'src/trsp/test/trsp-any-00.test' => 'Passed',
                                            'src/trsp/test/trsp-any-01.test' => 'FAILED: 1,5c1
< 0|1|1|1
< 1|2|4|1
< 2|7|7|1
< 3|6|6|1
< 4|5|-1|0
---
> 0|-1|0|8.89318162514244e-323',
                                            'src/trsp/test/trsp-any-02.test' => 'Passed',
                                            'src/trsp/test/trsp-any-03.test' => 'FAILED: 1,11c1
< 0|1|1|1
< 1|2|4|1
< 2|7|8|1
< 3|8|9|1
< 4|9|16|1
< 5|4|3|1
< 6|3|5|1
< 7|8|8|1
< 8|7|7|1
< 9|6|6|1
< 10|5|-1|0
---
> 0|-1|0|8.89318162514244e-323',
                                            'src/trsp/test/trsp-issue244.test' => 'FAILED: 1,6c1
< 0|7|6|1
< 1|8|7|1
< 2|5|8|1
< 3|6|11|1
< 4|11|13|1
< 5|12|-1|0
---
> 0|-1|0|8.89318162514244e-323',
                                            'src/trsp/test/trsp_vias-any-04.test' => 'FAILED: 1,11c1,3
< 1|1|1|1
< 2|2|4|1
< 3|7|8|1
< 4|8|8|1
< 5|7|10|1
< 6|10|14|1
< 7|13|14|1
< 8|10|10|1
< 9|7|7|1
< 10|6|6|1
< 4|5|-1|0
---
> 1|-1|0|8.89318162514244e-323
> 2|-1|0|8.89318162514244e-323
> 3|-1|0|8.89318162514244e-323'
                                          }
                                        ],
           'src/tsp/test/test.conf' => [
                                         {
                                           'comment' => 'TSP test for any versions.',
                                           'src/tsp/test/tsp-any-00.test' => 'Passed',
                                           'src/tsp/test/tsp-any-01.test' => 'Passed',
                                           'src/tsp/test/tsp-any-03.test' => 'Passed',
                                           'src/tsp/test/tsp-any-04.test' => 'Passed',
                                           'src/tsp/test/tsp-any-05.test' => 'Passed'
                                         }
                                       ],
           'src/vrp_basic/test/test.conf' => [
                                               {
                                                 'comment' => 'VRP Single depot test for any versions.'
                                               }
                                             ],
           'z_crash' => 0,
           'z_fail' => 9,
           'z_pass' => 68

I'll retest on a 2.1.7 instance. I think all those line locate ones etc, are because Sandro bumped up deprecated notices to warnings in 2.2 (and I only have 2.2 installed on my vc++ dev instance at the moment)

[robe2]

Here is the 2.1.7 I think the only ones that disappeared were the deprecation warning notices:

    test run time: 0.178767
$stats = {
           'doc/test/test.conf' => [
                                     {
                                       'comment' => 'documentation SQL tests for any versions.',
                                       'doc/test/alphashape-any.test' => 'Passed',
                                       'doc/test/analyzeGraph-any.test' => 'Passed',
                                       'doc/test/analyzeOneway-any.test' => 'Passed',
                                       'doc/test/apspJohnson-any.test' => 'Passed',
                                       'doc/test/apspWarshall-any.test' => 'Passed',
                                       'doc/test/astar-any.test' => 'Passed',
                                       'doc/test/bdDijkstra-any.test' => 'Passed',
                                       'doc/test/bdstar-any.test' => 'Passed',
                                       'doc/test/createTopology-any.test' => 'Passed',
                                       'doc/test/createVertTab-any.test' => 'Passed',
                                       'doc/test/dijkstra-any.test' => 'Passed',
                                       'doc/test/drivingDistance-any.test' => 'Passed',
                                       'doc/test/kdijkstra-any.test' => 'Passed',
                                       'doc/test/nodeNetwork-any.test' => 'Passed',
                                       'doc/test/pointsAsPolygon-any.test' => 'Passed',
                                       'doc/test/sampledata.test' => 'Passed',
                                       'doc/test/trsp-any.test' => 'FAILED: 1,12c1,2
< 0|7|6|1
< 1|8|7|1
< 2|5|8|1
< 3|6|11|1
< 4|11|13|1
< 5|12|-1|0
< 0|7|6|1
< 1|8|7|1
< 2|5|8|1
< 3|6|11|1
< 4|11|13|1
< 5|12|-1|0
---
> 0|-1|0|8.89318162514244e-323
> 0|-1|0|8.89318162514244e-323',
                                       'doc/test/tsp-any.test' => 'Passed',
                                       'doc/test/utilities-any.test' => 'Passed'
                                     }
                                   ],
           'src/apsp_johnson/test/test.conf' => [
                                                  {
                                                    'comment' => 'APSP Johnson test for any versions.',
                                                    'src/apsp_johnson/test/apsp_johnson-any-00.test' => 'Passed'
                                                  }
                                                ],
           'src/apsp_warshall/test/test.conf' => [
                                                   {
                                                     'comment' => 'APSP Warshall test for any versions.',
                                                     'src/apsp_warshall/test/apsp_warshall-any-00.test' => 'Passed'
                                                   }
                                                 ],
           'src/astar/test/test.conf' => [
                                           {
                                             'comment' => 'astar test for any versions.',
                                             'src/astar/test/spas-any-00.test' => 'Passed',
                                             'src/astar/test/spas-any-01.test' => 'Passed'
                                           }
                                         ],
           'src/bd_astar/test/test.conf' => [
                                              {
                                                'comment' => 'Bi-directional AStar test for any versions.',
                                                'src/bd_astar/test/bd_astar-any-01.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-02.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-03.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-04.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-05.test' => 'Passed',
                                                'src/bd_astar/test/bd_astar-any-06.test' => 'Passed'
                                              }
                                            ],
           'src/bd_dijkstra/test/test.conf' => [
                                                 {
                                                   'comment' => 'Bi-directional Dijkstra test for any versions.',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-01.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-02.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-03.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-04.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-05.test' => 'Passed',
                                                   'src/bd_dijkstra/test/bd_dijkstra-any-06.test' => 'Passed'
                                                 }
                                               ],
           'src/common/test/test.conf' => [
                                            {
                                              'comment' => 'pgr_createTopology, pgr_analyzegraph, and pgr_analyzeOneway tests for any versions.',
                                              'src/common/test/common-any-01.test' => 'Passed',
                                              'src/common/test/common-any-02.test' => 'Passed',
                                              'src/common/test/common-any-03.test' => 'Passed',
                                              'src/common/test/common-any-04.test' => 'Passed',
                                              'src/common/test/common-any-05.test' => 'Passed',
                                              'src/common/test/createTopology-any-01.test' => 'Passed',
                                              'src/common/test/createVerticesTable-any-01.test' => 'Passed',
                                              'src/common/test/gettablename-any-01.test' => 'Passed',
                                              'src/common/test/incrementalCreateTopology_any_01.test' => 'FAILED: 51c51
< 1|B|10|11|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
---
> 1|B|1|2|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
54c54
< 4|B|11|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
---
> 4|B|2|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
56,60c56,60
< 6|B|12|13|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
< 7|B|13|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
< 8|B|3|1|1|1|2|2|3|2|0102000000020000000000000000000040000000000000004000000000000008400000000000000040
< 9|B|1|2|1|1|3|2|4|2|0102000000020000000000000000000840000000000000004000000000000010400000000000000040
< 10|B|3|4|1|1|2|2|2|3|0102000000020000000000000000000040000000000000004000000000000000400000000000000840
---
> 6|B|4|5|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
> 7|B|5|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
> 8|B|3|6|1|1|2|2|3|2|0102000000020000000000000000000040000000000000004000000000000008400000000000000040
> 9|B|6|7|1|1|3|2|4|2|0102000000020000000000000000000840000000000000004000000000000010400000000000000040
> 10|B|3|8|1|1|2|2|2|3|0102000000020000000000000000000040000000000000004000000000000000400000000000000840
64,67c64,67
< 14|B|4|5|1|1|2|3|2|4|0102000000020000000000000000000040000000000000084000000000000000400000000000001040
< 15|B|2|6|1|1|4|2|4|3|0102000000020000000000000000001040000000000000004000000000000010400000000000000840
< 16|B|7|2|1|1|4|1|4|2|0102000000020000000000000000001040000000000000F03F00000000000010400000000000000040
< 17|B|8|9|1|1|0.5|3.5|1.999999999999|3.5|010200000002000000000000000000E03F0000000000000C4068EEFFFFFFFFFF3F0000000000000C40
---
> 14|B|8|9|1|1|2|3|2|4|0102000000020000000000000000000040000000000000084000000000000000400000000000001040
> 15|B|7|10|1|1|4|2|4|3|0102000000020000000000000000001040000000000000004000000000000010400000000000000840
> 16|B|11|7|1|1|4|1|4|2|0102000000020000000000000000001040000000000000F03F00000000000010400000000000000040
> 17|B|12|13|1|1|0.5|3.5|1.999999999999|3.5|010200000002000000000000000000E03F0000000000000C4068EEFFFFFFFFFF3F0000000000000C40
70,86c70,86
< 1|B|10|11|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
< 2|TF|11|17|-1|1|2|1|3|1|0102000000020000000000000000000040000000000000F03F0000000000000840000000000000F03F
< 3|TF|17|7|-1|1|3|1|4|1|0102000000020000000000000000000840000000000000F03F0000000000001040000000000000F03F
< 4|B|11|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
< 5|FT|17|1|1|-1|3|1|3|2|0102000000020000000000000000000840000000000000F03F00000000000008400000000000000040
< 6|B|12|13|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
< 7|B|13|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
< 8|B|3|1|1|1|2|2|3|2|0102000000020000000000000000000040000000000000004000000000000008400000000000000040
< 9|B|1|2|1|1|3|2|4|2|0102000000020000000000000000000840000000000000004000000000000010400000000000000040
< 10|B|3|4|1|1|2|2|2|3|0102000000020000000000000000000040000000000000004000000000000000400000000000000840
< 11|FT|1|16|1|-1|3|2|3|3|0102000000020000000000000000000840000000000000004000000000000008400000000000000840
< 12|FT|4|16|1|-1|2|3|3|3|0102000000020000000000000000000040000000000000084000000000000008400000000000000840
< 13|FT|16|6|1|-1|3|3|4|3|0102000000020000000000000000000840000000000000084000000000000010400000000000000840
< 14|B|4|5|1|1|2|3|2|4|0102000000020000000000000000000040000000000000084000000000000000400000000000001040
< 15|B|2|6|1|1|4|2|4|3|0102000000020000000000000000001040000000000000004000000000000010400000000000000840
< 16|B|7|2|1|1|4|1|4|2|0102000000020000000000000000001040000000000000F03F00000000000010400000000000000040
< 17|B|8|9|1|1|0.5|3.5|1.999999999999|3.5|010200000002000000000000000000E03F0000000000000C4068EEFFFFFFFFFF3F0000000000000C40
---
> 1|B|1|2|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
> 2|TF|2|16|-1|1|2|1|3|1|0102000000020000000000000000000040000000000000F03F0000000000000840000000000000F03F
> 3|TF|16|11|-1|1|3|1|4|1|0102000000020000000000000000000840000000000000F03F0000000000001040000000000000F03F
> 4|B|2|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
> 5|FT|16|6|1|-1|3|1|3|2|0102000000020000000000000000000840000000000000F03F00000000000008400000000000000040
> 6|B|4|5|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
> 7|B|5|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
> 8|B|3|6|1|1|2|2|3|2|0102000000020000000000000000000040000000000000004000000000000008400000000000000040
> 9|B|6|7|1|1|3|2|4|2|0102000000020000000000000000000840000000000000004000000000000010400000000000000040
> 10|B|3|8|1|1|2|2|2|3|0102000000020000000000000000000040000000000000004000000000000000400000000000000840
> 11|FT|6|17|1|-1|3|2|3|3|0102000000020000000000000000000840000000000000004000000000000008400000000000000840
> 12|FT|8|17|1|-1|2|3|3|3|0102000000020000000000000000000040000000000000084000000000000008400000000000000840
> 13|FT|17|10|1|-1|3|3|4|3|0102000000020000000000000000000840000000000000084000000000000010400000000000000840
> 14|B|8|9|1|1|2|3|2|4|0102000000020000000000000000000040000000000000084000000000000000400000000000001040
> 15|B|7|10|1|1|4|2|4|3|0102000000020000000000000000001040000000000000004000000000000010400000000000000840
> 16|B|11|7|1|1|4|1|4|2|0102000000020000000000000000001040000000000000F03F00000000000010400000000000000040
> 17|B|12|13|1|1|0.5|3.5|1.999999999999|3.5|010200000002000000000000000000E03F0000000000000C4068EEFFFFFFFFFF3F0000000000000C40
89,105c89,105
< 1|B|10|11|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
< 2|TF|11|17|-1|1|2|1|3|1|0102000000020000000000000000000040000000000000F03F0000000000000840000000000000F03F
< 3|TF|17|7|-1|1|3|1|4|1|0102000000020000000000000000000840000000000000F03F0000000000001040000000000000F03F
< 4|B|11|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
< 5|FT|17|1|1|-1|3|1|3|2|0102000000020000000000000000000840000000000000F03F00000000000008400000000000000040
< 6|B|12|13|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
< 7|B|13|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
< 8|B|3|1|1|1|2|2|3|2|0102000000020000000000000000000040000000000000004000000000000008400000000000000040
< 9|B|1|2|1|1|3|2|4|2|0102000000020000000000000000000840000000000000004000000000000010400000000000000040
< 10|B|3|4|1|1|2|2|2|3|0102000000020000000000000000000040000000000000004000000000000000400000000000000840
< 11|FT|1|16|1|-1|3|2|3|3|0102000000020000000000000000000840000000000000004000000000000008400000000000000840
< 12|FT|4|16|1|-1|2|3|3|3|0102000000020000000000000000000040000000000000084000000000000008400000000000000840
< 13|FT|16|6|1|-1|3|3|4|3|0102000000020000000000000000000840000000000000084000000000000010400000000000000840
< 14|B|4|5|1|1|2|3|2|4|0102000000020000000000000000000040000000000000084000000000000000400000000000001040
< 15|B|2|6|1|1|4|2|4|3|0102000000020000000000000000001040000000000000004000000000000010400000000000000840
< 16|B|7|2|1|1|4|1|4|2|0102000000020000000000000000001040000000000000F03F00000000000010400000000000000040
< 17|B|8|9|1|1|0.5|3.5|1.999999999999|3.5|010200000002000000000000000000E03F0000000000000C4068EEFFFFFFFFFF3F0000000000000C40
---
> 1|B|1|2|1|1|2|0|2|1|010200000002000000000000000000004000000000000000000000000000000040000000000000F03F
> 2|TF|2|16|-1|1|2|1|3|1|0102000000020000000000000000000040000000000000F03F0000000000000840000000000000F03F
> 3|TF|16|11|-1|1|3|1|4|1|0102000000020000000000000000000840000000000000F03F0000000000001040000000000000F03F
> 4|B|2|3|1|1|2|1|2|2|0102000000020000000000000000000040000000000000F03F00000000000000400000000000000040
> 5|FT|16|6|1|-1|3|1|3|2|0102000000020000000000000000000840000000000000F03F00000000000008400000000000000040
> 6|B|4|5|1|1|0|2|1|2|01020000000200000000000000000000000000000000000040000000000000F03F0000000000000040
> 7|B|5|3|1|1|1|2|2|2|010200000002000000000000000000F03F000000000000004000000000000000400000000000000040
> 8|B|3|6|1|1|2|2|3|2|0102000000020000000000000000000040000000000000004000000000000008400000000000000040
> 9|B|6|7|1|1|3|2|4|2|0102000000020000000000000000000840000000000000004000000000000010400000000000000040
> 10|B|3|8|1|1|2|2|2|3|0102000000020000000000000000000040000000000000004000000000000000400000000000000840
> 11|FT|6|17|1|-1|3|2|3|3|0102000000020000000000000000000840000000000000004000000000000008400000000000000840
> 12|FT|8|17|1|-1|2|3|3|3|0102000000020000000000000000000040000000000000084000000000000008400000000000000840
> 13|FT|17|10|1|-1|3|3|4|3|0102000000020000000000000000000840000000000000084000000000000010400000000000000840
> 14|B|8|9|1|1|2|3|2|4|0102000000020000000000000000000040000000000000084000000000000000400000000000001040
> 15|B|7|10|1|1|4|2|4|3|0102000000020000000000000000001040000000000000004000000000000010400000000000000840
> 16|B|11|7|1|1|4|1|4|2|0102000000020000000000000000001040000000000000F03F00000000000010400000000000000040
> 17|B|12|13|1|1|0.5|3.5|1.999999999999|3.5|010200000002000000000000000000E03F0000000000000C4068EEFFFFFFFFFF3F0000000000000C40',
                                              'src/common/test/isColumnInTable-any.test' => 'Passed',
                                              'src/common/test/isColumnIndexed-any.test' => 'Passed',
                                              'src/common/test/no_underscored-2x.test' => 'Passed',
                                              'src/common/test/pgr_checkVertTab_any_01.test' => 'Passed',
                                              'src/common/test/pgr_getColumnName_any_01.test' => 'Passed',
                                              'src/common/test/pgr_getColumnType_any_01.test' => 'Passed',
                                              'src/common/test/pgrouting_conversion_tools-any-01.test' => 'Passed',
                                              'src/common/test/pgrouting_dmatrix_tools-any-01.test' => 'Passed',
                                              'src/common/test/versionless-any-01.test' => 'Passed'
                                            }
                                          ],
           'src/dijkstra/test/test.conf' => [
                                              {
                                                'comment' => 'Dijkstra test for any versions.',
                                                'src/dijkstra/test/dijkstra-dir-00.test' => 'Passed',
                                                'src/dijkstra/test/dijkstra-dir-01.test' => 'Passed',
                                                'src/dijkstra/test/dijkstra-undi-00.test' => 'Passed',
                                                'src/dijkstra/test/dijkstra-undi-01.test' => 'Passed'
                                              }
                                            ],
           'src/driving_distance/test/test.conf' => [
                                                      {
                                                        'comment' => 'Driving Distance test for any versions.',
                                                        'src/driving_distance/test/drivingdistance-any-00.test' => 'Passed'
                                                      }
                                                    ],
           'src/kdijkstra/test/test.conf' => [
                                               {
                                                 'comment' => 'KDijkstra test for any versions.',
                                                 'src/kdijkstra/test/kdijkstra-any-01.test' => 'Passed',
                                                 'src/kdijkstra/test/kdijkstra-any-02.test' => 'Passed',
                                                 'src/kdijkstra/test/kdijkstra-any-03.test' => 'Passed',
                                                 'src/kdijkstra/test/vidstodmatrix-any-01.test' => 'Passed',
                                                 'src/kdijkstra/test/vidstodmatrix-any-02.test' => 'Passed'
                                               }
                                             ],
           'src/ksp/test/test.conf' => [
                                         {
                                           'comment' => 'KSP test for any versions.',
                                           'src/ksp/test/ksp-any-01.test' => 'Passed',
                                           'src/ksp/test/ksp-any-02.test' => 'Passed',
                                           'src/ksp/test/ksp-parallel-any-03.test' => 'Passed'
                                         }
                                       ],
           'src/trsp/test/test.conf' => [
                                          {
                                            'comment' => 'TRSP test for any versions.',
                                            'src/trsp/test/trsp-any-00.test' => 'Passed',
                                            'src/trsp/test/trsp-any-01.test' => 'FAILED: 1,5c1
< 0|1|1|1
< 1|2|4|1
< 2|7|7|1
< 3|6|6|1
< 4|5|-1|0
---
> 0|-1|0|8.89318162514244e-323',
                                            'src/trsp/test/trsp-any-02.test' => 'Passed',
                                            'src/trsp/test/trsp-any-03.test' => 'FAILED: 1,11c1
< 0|1|1|1
< 1|2|4|1
< 2|7|8|1
< 3|8|9|1
< 4|9|16|1
< 5|4|3|1
< 6|3|5|1
< 7|8|8|1
< 8|7|7|1
< 9|6|6|1
< 10|5|-1|0
---
> 0|-1|0|8.89318162514244e-323',
                                            'src/trsp/test/trsp-issue244.test' => 'FAILED: 1,6c1
< 0|7|6|1
< 1|8|7|1
< 2|5|8|1
< 3|6|11|1
< 4|11|13|1
< 5|12|-1|0
---
> 0|-1|0|8.89318162514244e-323',
                                            'src/trsp/test/trsp_vias-any-04.test' => 'FAILED: 1,11c1,3
< 1|1|1|1
< 2|2|4|1
< 3|7|8|1
< 4|8|8|1
< 5|7|10|1
< 6|10|14|1
< 7|13|14|1
< 8|10|10|1
< 9|7|7|1
< 10|6|6|1
< 4|5|-1|0
---
> 1|-1|0|8.89318162514244e-323
> 2|-1|0|8.89318162514244e-323
> 3|-1|0|8.89318162514244e-323'
                                          }
                                        ],
           'src/tsp/test/test.conf' => [
                                         {
                                           'comment' => 'TSP test for any versions.',
                                           'src/tsp/test/tsp-any-00.test' => 'Passed',
                                           'src/tsp/test/tsp-any-01.test' => 'Passed',
                                           'src/tsp/test/tsp-any-03.test' => 'Passed',
                                           'src/tsp/test/tsp-any-04.test' => 'Passed',
                                           'src/tsp/test/tsp-any-05.test' => 'Passed'
                                         }
                                       ],
           'src/vrp_basic/test/test.conf' => [
                                               {
                                                 'comment' => 'VRP Single depot test for any versions.'
                                               }
                                             ],
           'z_crash' => 0,
           'z_fail' => 6,
           'z_pass' => 71
         };

[cvvergara]

@robe2 Regina, Sorry to bother you again,
In this run:

http://winnie.postgis.net:1500/job/pgRouting_2_PGVersion/1813/console

there is are these lines:

RUNNING: test-runner.pl -pgisver 2.1.7 -pgport 10444 -ignorenotice
ERROR: test database 'pgr_test__db__test' exists, you must drop or rename it!

Can you add: -clean flag to the command please:

 test-runner.pl -pgisver 2.1.7 -pgport 10444 -ignorenotice -clean

[robe2]

No bother. Sorry been distracted with trying to get stuff in postgis before 6/30 feature freeze.

Regarding the clean thing, you should be able to do this yourself. Winnie just runs whatever script is in git pgrouting repo -- pgrouting source/tools/winnie/build_pgrouting.sh

So just edit that to your hearts content.

[cvvergara]

@robe2 Regina:
Thanks, I didn't even know that file existed.

[cvvergara]

@robe2 Regina, I know you are busy, I have this other issue:
In run:
http://winnie.postgis.net:1500/view/pgRouting/job/pgRouting_2_PGVersion/lastBuild/console
there are this lines:

-- Installing: e:/jenkins/postgresql/rel/pg9.4w64gcc48/share/extension/pgrouting.control
-- Installing: e:/jenkins/postgresql/rel/pg9.4w64gcc48/share/contrib/pgrouting-2.1/pgrouting.sql
-- Installing: e:/jenkins/postgresql/rel/pg9.4w64gcc48/share/contrib/pgrouting-2.1/pgrouting.control
RUNNING: test-runner.pl -pgisver 2.1.7 -pgport 10444 -ignorenotice -clean
CREATE EXTENSION
ERROR:  could not open extension control file "e:/jenkins/postgresql/rel/pg9.3w64gcc48/share/extension/pgrouting.control": No such file or directory

I looked in the whole file and this number 4w64gcc48 always show up, but not this number used for opening extension control 3w64gcc48 and I just couldn’t figure out where the 3w64gcc48 when everything else is 4w64gcc48.
I don't know if it has to do with the fact that I changed the version number to 2.1
(I am implementing this https://docs.google.com/document/d/1lgBNr9I-otJmMJMeYyRTxi51VxvX9b6yaRWBT2p_ip4/edit)

[woodbri]

ok, I looked at @cvvergara winnie results and noticed a couple of things.

• there is a commandline option in ``test-runner.pl -pgver 9.4 ...` that does not do anything. I think it might have been originally used to decide if we we needed to install via a template vs create extension, but it is totally useless and I'll probably remove it as it is not getting used.
• in this winnie test: http://winnie.postgis.net:1500/view/pgRouting/job/pgRouting_2_PGVersion/1827/console you will notice that everything is building against 9.4 but when we connect to the database via port 10444 the actual database is DBVERSION=9.3.6 so port number is wrong or the wrong database has been installed.

I looked around but I'm not sure where this is defined or if it is something that we can change or it is just a problem with how the VM is getting setup.

[robe2]

I'll take a look. That is all set by the matrix, so its possible the old service didn't shut down gracefully and couldn't be shut down destroyed before the new one started. Anyway will take a look at that. I may just have them run on different ports to avoid this issue.

[robe2]

Okay hopefully its fixed now. I think the issue was I had the stop postgres service as a step in the job, so it required success to run and when the next run happened in matrix (with a different version/etc it was not shutting it off but trying to use the same port for initdb). I moved it as a post build always run step.
Noticed something odd though. Might be in winnie script, but it tries to call test runner without a version number (which sadly picks up postgis 2.2, and I guess I don't have paths set right for that).

RUNNING: test-runner.pl -pgver 9.4 -pgport 10446 -clean
dropdb: database removal failed: ERROR:  database "pgr_test__db__test" does not exist
ERROR:  could not load library "e:/jenkins/postgresql/rel/pg9.4w64gcc48/lib/postgis-2.2.dll": The specified module could not be found.


ERROR:  required extension "postgis" is not installed
ERROR:  function pgr_version() does not exist
LINE 1: select pgr_version()
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
ERROR: failed to install pgrouting into the database!

Then it correctly runs with 2.1.7 (which it reads from jenkins config).