Closed cvvergara closed 9 years ago
robe2
commented
9 years ago 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
commented
9 years ago 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' => 68I'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
commented
9 years ago 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
commented
9 years ago @robe2 Regina, Sorry to bother you again, In this run:
http://winnie.postgis.net:1500/job/pgRouting_2_PGVersion/1813/consolethere 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 -cleanNo 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
commented
9 years ago @robe2 Regina: Thanks, I didn't even know that file existed.
cvvergara
commented
9 years ago @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 directoryI 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
commented
9 years ago ok, I looked at @cvvergara winnie results and noticed a couple of things.
`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.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
commented
9 years ago 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
commented
9 years ago 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).
cvvergara
commented
9 years ago @robe2 Regina: Thank you very much. (we didn't mean to have you working at 3am). I really appreciate your effort. Thanks again. Vicky
P.D.
RUNNING: test-runner.pl -pgver 9.4 -pgport 10446 -cleanwas my attempt to remove the database before the actual tests were taking place, I will remove that line.
cvvergara
commented
9 years ago @robe2 Regina Sorry to bother you again, 9.4 seems working fine, but nothing compiles on postgres 9.3. I tried to make sure that it wasn't something I was doing, I tried a lot of things, but nothing compiles on the 9.3 Vicky
robe2
commented
9 years ago Okay will check it out later. Might be my fault since I was fiddling with 9.3 getting other PostGIS dependencies in place.
robe2
commented
9 years ago Okay I checked but sadly haven't fixed. I guess it had nothing to do with my changes. I recompiled latest 9.3.9 for windows 64 and that unfortunately did not fix the issue. So I think just something they changed between 9.3 and 9.4 that makes 9.4 work. I know they made a bunch of win32 changes in 9.4 since it had broken my 9.4 win32 builds. Anyway will take a look on my dev later this weekend to see what it could be.
robe2
commented
9 years ago @cvvergara Okay I tried building n my desktop and ran into the same issue with 9.3. Not sure what changed in 9.4 codebase (but the pg_config_os.h seems unchanged).
I did make some progress I think. I noticed some other files you have had this at the top
#ifdef __MINGW32__
#include <winsock2.h>
#include <windows.h>
#endifSo I added it to the top of dd-develop/src/driving_distance/src/boost_interface_drivedist.cpp
That got the me past the driving_distance compile errors so now on apsp_warshall not working
-- Build files have been written to: C:/ming64gcc48/projects/pgrouting/build
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -H/C/ming64gcc48/projects/pgrouting/branches/dd-develop -B/C/ming64gcc48/projects/pgrouting/build --check-build-system CMakeFiles/Makefile.cmake 0
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_start /C/ming64gcc48/projects/pgrouting/build/CMakeFiles /C/ming64gcc48/projects/pgrouting/build/CMakeFiles/progress.marks
make -f CMakeFiles/Makefile2 all
make[1]: Entering directory `/projects/pgrouting/build'
make -f src/driving_distance/src/CMakeFiles/driving_distance.dir/build.make src/driving_distance/src/CMakeFiles/driving_distance.dir/depend
make[2]: Entering directory `/projects/pgrouting/build'
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_depends "MSYS Makefiles" /C/ming64gcc48/projects/pgrouting/branches/dd-develop /C/ming64gcc48/projects/pgrouting/branches/dd-develop/src/driving_distance/src /C/ming64gcc48/projects/pgrouting/build /C/ming64gcc48/projects/pgrouting/build/src/driving_distance/src /C/ming64gcc48/projects/pgrout
Scanning dependencies of target driving_distance
make[2]: Leaving directory `/projects/pgrouting/build'
make -f src/driving_distance/src/CMakeFiles/driving_distance.dir/build.make src/driving_distance/src/CMakeFiles/driving_distance.dir/build
make[2]: Entering directory `/projects/pgrouting/build'
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 20
[ 2%] Building C object src/driving_distance/src/CMakeFiles/driving_distance.dir/alpha.c.obj
cd /C/ming64gcc48/projects/pgrouting/build/src/driving_distance/src && /c/ming64gcc48/mingw64/bin/gcc.exe -DPGSQL_VERSION=93 -O2 -g -frounding-math @CMakeFiles/driving_distance.dir/includes_C.rsp -o CMakeFiles/driving_distance.dir/alpha.c.obj -c /C/ming64gcc48/projects/pgrouting/branches/dd-develop/src/driving_distance/src/alpha.c
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 21
[ 5%] Building CXX object src/driving_distance/src/CMakeFiles/driving_distance.dir/alpha_drivedist.cpp.obj
cd /C/ming64gcc48/projects/pgrouting/build/src/driving_distance/src && /c/ming64gcc48/mingw64/bin/g++.exe -Ic:/ming64gcc48/projects/CGAL/rel-gmp-5.1.2w64gcc48/include -I/projects/CGAL/rel-mpfr-3.1.2w64gcc48/include -O2 -g -std=c++0x -frounding-math -Wno-deprecated @CMakeFiles/driving_distance.dir/includes_CXX.rsp -o CMakeFiles/driving_distance.dir
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 22
[ 8%] Building CXX object src/driving_distance/src/CMakeFiles/driving_distance.dir/boost_interface_drivedist.cpp.obj
cd /C/ming64gcc48/projects/pgrouting/build/src/driving_distance/src && /c/ming64gcc48/mingw64/bin/g++.exe -Ic:/ming64gcc48/projects/CGAL/rel-gmp-5.1.2w64gcc48/include -I/projects/CGAL/rel-mpfr-3.1.2w64gcc48/include -O2 -g -std=c++0x -frounding-math -Wno-deprecated @CMakeFiles/driving_distance.dir/includes_CXX.rsp -o CMakeFiles/driving_distance.dir
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 23
[ 11%] Building C object src/driving_distance/src/CMakeFiles/driving_distance.dir/drivedist.c.obj
cd /C/ming64gcc48/projects/pgrouting/build/src/driving_distance/src && /c/ming64gcc48/mingw64/bin/gcc.exe -DPGSQL_VERSION=93 -O2 -g -frounding-math @CMakeFiles/driving_distance.dir/includes_C.rsp -o CMakeFiles/driving_distance.dir/drivedist.c.obj -c /C/ming64gcc48/projects/pgrouting/branches/dd-develop/src/driving_distance/src/drivedist.c
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 24
[ 13%] Building C object src/driving_distance/src/CMakeFiles/driving_distance.dir/many_to_dist_driving_distance.c.obj
cd /C/ming64gcc48/projects/pgrouting/build/src/driving_distance/src && /c/ming64gcc48/mingw64/bin/gcc.exe -DPGSQL_VERSION=93 -O2 -g -frounding-math @CMakeFiles/driving_distance.dir/includes_C.rsp -o CMakeFiles/driving_distance.dir/many_to_dist_driving_distance.c.obj -c /C/ming64gcc48/projects/pgrouting/branches/dd-develop/src/driving_distance/src
make[2]: Leaving directory `/projects/pgrouting/build'
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 20 21 22 23 24
[ 13%] Built target driving_distance
make -f src/apsp_johnson/src/CMakeFiles/apsp_johnson.dir/build.make src/apsp_johnson/src/CMakeFiles/apsp_johnson.dir/depend
make[2]: Entering directory `/projects/pgrouting/build'
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_depends "MSYS Makefiles" /C/ming64gcc48/projects/pgrouting/branches/dd-develop /C/ming64gcc48/projects/pgrouting/branches/dd-develop/src/apsp_johnson/src /C/ming64gcc48/projects/pgrouting/build /C/ming64gcc48/projects/pgrouting/build/src/apsp_johnson/src /C/ming64gcc48/projects/pgrouting/buil
Scanning dependencies of target apsp_johnson
make[2]: Leaving directory `/projects/pgrouting/build'
make -f src/apsp_johnson/src/CMakeFiles/apsp_johnson.dir/build.make src/apsp_johnson/src/CMakeFiles/apsp_johnson.dir/build
make[2]: Entering directory `/projects/pgrouting/build'
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 1
[ 16%] Building C object src/apsp_johnson/src/CMakeFiles/apsp_johnson.dir/apsp_johnson.c.obj
cd /C/ming64gcc48/projects/pgrouting/build/src/apsp_johnson/src && /c/ming64gcc48/mingw64/bin/gcc.exe -DPGSQL_VERSION=93 -O2 -g -frounding-math @CMakeFiles/apsp_johnson.dir/includes_C.rsp -o CMakeFiles/apsp_johnson.dir/apsp_johnson.c.obj -c /C/ming64gcc48/projects/pgrouting/branches/dd-develop/src/apsp_johnson/src/apsp_johnson.c
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 2
[ 19%] Building CXX object src/apsp_johnson/src/CMakeFiles/apsp_johnson.dir/apsp_johnson_boost_wrapper.cpp.obj
cd /C/ming64gcc48/projects/pgrouting/build/src/apsp_johnson/src && /c/ming64gcc48/mingw64/bin/g++.exe -Ic:/ming64gcc48/projects/CGAL/rel-gmp-5.1.2w64gcc48/include -I/projects/CGAL/rel-mpfr-3.1.2w64gcc48/include -O2 -g -std=c++0x -frounding-math -Wno-deprecated -fno-delete-null-pointer-checks @CMakeFiles/apsp_johnson.dir/includes_CXX.rsp -o CMakeFi
make[2]: Leaving directory `/projects/pgrouting/build'
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 1 2
[ 19%] Built target apsp_johnson
make -f src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/build.make src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/depend
make[2]: Entering directory `/projects/pgrouting/build'
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_depends "MSYS Makefiles" /C/ming64gcc48/projects/pgrouting/branches/dd-develop /C/ming64gcc48/projects/pgrouting/branches/dd-develop/src/apsp_warshall/src /C/ming64gcc48/projects/pgrouting/build /C/ming64gcc48/projects/pgrouting/build/src/apsp_warshall/src /C/ming64gcc48/projects/pgrouting/bu
Scanning dependencies of target apsp_warshall
make[2]: Leaving directory `/projects/pgrouting/build'
make -f src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/build.make src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/build
make[2]: Entering directory `/projects/pgrouting/build'
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 3
[ 22%] Building C object src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/apsp.c.obj
cd /C/ming64gcc48/projects/pgrouting/build/src/apsp_warshall/src && /c/ming64gcc48/mingw64/bin/gcc.exe -DPGSQL_VERSION=93 -O2 -g -frounding-math @CMakeFiles/apsp_warshall.dir/includes_C.rsp -o CMakeFiles/apsp_warshall.dir/apsp.c.obj -c /C/ming64gcc48/projects/pgrouting/branches/dd-develop/src/apsp_warshall/src/apsp.c
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -E cmake_progress_report /C/ming64gcc48/projects/pgrouting/build/CMakeFiles 4
[ 25%] Building CXX object src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/apsp_boost_wrapper.cpp.obj
cd /C/ming64gcc48/projects/pgrouting/build/src/apsp_warshall/src && /c/ming64gcc48/mingw64/bin/g++.exe -Ic:/ming64gcc48/projects/CGAL/rel-gmp-5.1.2w64gcc48/include -I/projects/CGAL/rel-mpfr-3.1.2w64gcc48/include -O2 -g -std=c++0x -frounding-math -Wno-deprecated @CMakeFiles/apsp_warshall.dir/includes_CXX.rsp -o CMakeFiles/apsp_warshall.dir/apsp_boo
In file included from c:/ming64gcc48/projects/postgresql/rel/pg9.3w64gcc48/include/server/c.h:92:0,
from c:/ming64gcc48/projects/postgresql/rel/pg9.3w64gcc48/include/server/postgres.h:47,
from c:/ming64gcc48/projects/pgrouting/branches/dd-develop/src/apsp_warshall/src/apsp.h:25,
from c:/ming64gcc48/projects/pgrouting/branches/dd-develop/src/apsp_warshall/src/apsp_boost_wrapper.cpp:32:
c:/ming64gcc48/projects/postgresql/rel/pg9.3w64gcc48/include/server/pg_config_os.h:215:8: error: redefinition of 'struct itimerval'
struct itimerval
^
In file included from c:/ming64gcc48/projects/postgresql/rel/pg9.3w64gcc48/include/server/c.h:57:0,
from c:/ming64gcc48/projects/postgresql/rel/pg9.3w64gcc48/include/server/postgres.h:47,
from c:/ming64gcc48/projects/pgrouting/branches/dd-develop/src/apsp_warshall/src/apsp.h:25,
from c:/ming64gcc48/projects/pgrouting/branches/dd-develop/src/apsp_warshall/src/apsp_boost_wrapper.cpp:32:
c:/ming64gcc48/projects/postgresql/rel/pg9.3w64gcc48/include/server/pg_config_os.h:215:8: error: previous definition of 'struct itimerval'
struct itimerval
^
src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/build.make:85: recipe for target `src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/apsp_boost_wrapper.cpp.obj' failed
make[2]: *** [src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/apsp_boost_wrapper.cpp.obj] Error 1
make[2]: Leaving directory `/projects/pgrouting/build'
CMakeFiles/Makefile2:382: recipe for target `src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/all' failed
make[1]: *** [src/apsp_warshall/src/CMakeFiles/apsp_warshall.dir/all] Error 2
make[1]: Leaving directory `/projects/pgrouting/build'
Makefile:119: recipe for target `all' failed
make: *** [all] Error 2
RUNNING: test-runner.pl -pgisver 2.1.7 -pgport 5443
ERROR: test database 'pgr_test__db__test' exists, you must drop or rename it!Trying to see if I can get past that one too.
robe2
commented
9 years ago Okay applying the same fix on all the .cpp files it complained about seems to have gotten it thru the compile phase. I'm guessing PGDG changed something in 9.4 that ensures winsock2.h comes first which might be why the issues doesn't show in the 9.4 builds. Can't find where that would be though.
I'm not sure if putting winsock in all those files (I think I had to touch about 10 of them), is the best solution.
On testing though - I did get some failures and crashers
Install the project...
/c/ming64gcc48/cmake-2.8.11-win32-x86/bin/cmake.exe -P cmake_install.cmake
-- Install configuration: ""
-- Installing: c:/MING64~1/projects/POSTGR~1/rel/PG9~1.3W6/lib/librouting-2.1.dll.a
-- Installing: c:/MING64~1/projects/POSTGR~1/rel/PG9~1.3W6/lib/librouting-2.1.dll
-- Installing: c:/MING64~1/projects/POSTGR~1/rel/PG9~1.3W6/share/extension/pgrouting--2.1.0.sql
-- Installing: c:/MING64~1/projects/POSTGR~1/rel/PG9~1.3W6/share/extension/pgrouting.control
-- Installing: c:/MING64~1/projects/POSTGR~1/rel/PG9~1.3W6/share/contrib/pgrouting-2.1/pgrouting.sql
-- Installing: c:/MING64~1/projects/POSTGR~1/rel/PG9~1.3W6/share/contrib/pgrouting-2.1/pgrouting.control
RUNNING: test-runner.pl -pgisver 2.1.7 -pgport 5443
CREATE EXTENSION
CREATE EXTENSION
Processing test: parallel_handling
test run time: 0.200659
Processing test: example_recipe
test run time: 0.398909
Processing test: zzz-remove_sampledata
test run time: 0.080692
Processing test: sampledata
test run time: 0.198083
Processing test: alphashape-any
test run time: 0.084426
Processing test: apspJohnson-any
test run time: 0.082796
Processing test: apspWarshall-any
test run time: 0.080206
Processing test: astar-any
test run time: 0.07959
Processing test: bdstar-any
test run time: 0.080294
Processing test: bdDijkstra-any
test run time: 0.080595
Processing test: dijkstra-v2
test run time: 0.086165
Processing test: dijkstra-v3
test run time: 0.111287
Processing test: pointsAsPolygon-any
test run time: 0.081485
Processing test: kdijkstra-any
test run time: 0.08462
Processing test: tsp-any
test run time: 0.122365
Processing test: trsp-any
test run time: 0.104343
Processing test: utilities-any
test run time: 0.081153
Processing test: createTopology-any
test run time: 1.13423
Processing test: createVertTab-any
test run time: 0.769615
Processing test: analyzeGraph-any
test run time: 1.069508
Processing test: analyzeOneway-any
test run time: 0.112069
Processing test: nodeNetwork-any
test run time: 0.497406
Processing test: apsp_johnson-any-00
test run time: 0.080596
Processing test: apsp_warshall-any-00
test run time: 0.07577
Processing test: spas-any-00
test run time: 0.076302
Processing test: spas-any-01
test run time: 0.077195
Processing test: bd_astar-any-01
test run time: 0.093984
Processing test: bd_astar-any-02
test run time: 0.091723
Processing test: bd_astar-any-03
test run time: 0.101298
Processing test: bd_astar-any-04
test run time: 0.090022
Processing test: bd_astar-any-05
test run time: 0.092778
Processing test: bd_astar-any-06
test run time: 0.098595
Processing test: bd_dijkstra-any-01
test run time: 0.093561
Processing test: bd_dijkstra-any-02
test run time: 0.096227
Processing test: bd_dijkstra-any-03
test run time: 0.090922
Processing test: bd_dijkstra-any-04
test run time: 0.088697
Processing test: bd_dijkstra-any-05
test run time: 0.089421
Processing test: bd_dijkstra-any-06
test run time: 0.092281
Processing test: versionless-any-01
test run time: 0.097868
Processing test: common-any-01
test run time: 0.175046
Processing test: common-any-02
test run time: 0.199822
Processing test: common-any-03
test run time: 0.186414
Processing test: common-any-04
test run time: 0.439979
Processing test: common-any-05
test run time: 0.209377
Processing test: createTopology-any-01
test run time: 2.779771
Processing test: createVerticesTable-any-01
test run time: 1.879608
Processing test: gettablename-any-01
test run time: 0.191803
Processing test: pgrouting_conversion_tools-any-01
test run time: 0.090147
Processing test: pgrouting_dmatrix_tools-any-01
test run time: 0.097378
Processing test: pgr_getColumnName_any_01
test run time: 0.209664
Processing test: pgr_getColumnType_any_01
test run time: 0.212243
Processing test: pgr_checkVertTab_any_01
test run time: 0.185189
Processing test: incrementalCreateTopology_any_01
test run time: 0.331706
Processing test: no_underscored-2x
test run time: 0.127137
Processing test: isColumnIndexed-any
test run time: 0.353017
Processing test: isColumnInTable-any
test run time: 0.319026
Processing test: 1_to_many
test run time: 0.08307
Processing test: many_to_1
test run time: 0.082548
Processing test: many_to_many
test run time: 0.081322
Processing test: dijkstra-v2
test run time: 0.078381
Processing test: dijkstra-v3
test run time: 0.10506
Processing test: dijkstra-undi-00
test run time: 0.081209
Processing test: dijkstra-undi-01
test run time: 0.079279
Processing test: dijkstra-dir-00
test run time: 0.086142
Processing test: dijkstra-dir-01
test run time: 0.07849
Processing test: drivingdistance-any-00
test run time: 0.093184
Processing test: drivingdistance-doc-v2
test run time: 0.080788
Processing test: drivingdistance-doc-v3
test run time: 0.089551
Processing test: kdijkstra-any-01
test run time: 0.076645
Processing test: kdijkstra-any-02
test run time: 0.076316
Processing test: kdijkstra-any-03
test run time: 0.080507
Processing test: vidstodmatrix-any-01
test run time: 0.0793
Processing test: vidstodmatrix-any-02
test run time: 0.079731
Processing test: show_data
test run time: 0.08268
Processing test: ksp-any-01
test run time: 0.080455
Processing test: ksp-any-02
test run time: 0.08138
Processing test: ksp-parallel-any-03
test run time: 0.084793
Processing test: ksp-v2
test run time: 0.080706
Processing test: ksp-v3
CRASHED SERVER: 'src/ksp/test/ksp-v3.test.sql', sleeping 5 ...
test run time: 5.488697
Processing test: trsp-any-00
test run time: 0.074812
Processing test: trsp-any-01
test run time: 0.076054
Processing test: trsp-any-02
test run time: 0.067328
Processing test: trsp-any-03
test run time: 0.075644
Processing test: trsp_vias-any-04
test run time: 0.079353
Processing test: trsp-issue244
test run time: 0.076867
Processing test: tsp-any-00
test run time: 0.109596
Processing test: tsp-any-01
test run time: 0.105331
Processing test: tsp-any-03
test run time: 0.218019
Processing test: tsp-any-04
test run time: 0.095865
Processing test: tsp-any-05
test run time: 0.09463
$stats = {
'doc/src/recipes/test/test.conf' => [
{
'comment' => 'Recipes test for any versions.',
'doc/src/recipes/test/example_recipe.test.sql' => 'Passed',
'doc/src/recipes/test/parallel_handling.test.sql' => 'Passed',
'doc/src/recipes/test/zzz-remove_sampledata.test.sql' => 'Passed'
}
],
'doc/test/test.conf' => [
{
'comment' => 'documentation SQL tests for any versions.',
'doc/test/alphashape-any.test.sql' => 'Passed',
'doc/test/analyzeGraph-any.test.sql' => 'Passed',
'doc/test/analyzeOneway-any.test.sql' => 'Passed',
'doc/test/apspJohnson-any.test.sql' => 'Passed',
'doc/test/apspWarshall-any.test.sql' => 'Passed',
'doc/test/astar-any.test.sql' => 'Passed',
'doc/test/bdDijkstra-any.test.sql' => 'Passed',
'doc/test/bdstar-any.test.sql' => 'Passed',
'doc/test/createTopology-any.test.sql' => 'Passed',
'doc/test/createVertTab-any.test.sql' => 'Passed',
'doc/test/dijkstra-v2.test.sql' => 'Passed',
'doc/test/dijkstra-v3.test.sql' => 'Passed',
'doc/test/kdijkstra-any.test.sql' => 'Passed',
'doc/test/nodeNetwork-any.test.sql' => 'Passed',
'doc/test/pointsAsPolygon-any.test.sql' => 'Passed',
'doc/test/sampledata.test.sql' => 'Passed',
'doc/test/trsp-any.test.sql' => 'Passed',
'doc/test/tsp-any.test.sql' => 'Passed',
'doc/test/utilities-any.test.sql' => 'Passed'
}
],
'src/apsp_johnson/test/test.conf' => [
{
'comment' => 'APSP Johnson test for any versions.',
'src/apsp_johnson/test/apsp_johnson-any-00.test.sql' => 'Passed'
}
],
'src/apsp_warshall/test/test.conf' => [
{
'comment' => 'APSP Warshall test for any versions.',
'src/apsp_warshall/test/apsp_warshall-any-00.test.sql' => 'Passed'
}
],
'src/astar/test/test.conf' => [
{
'comment' => 'astar test for any versions.',
'src/astar/test/spas-any-00.test.sql' => 'Passed',
'src/astar/test/spas-any-01.test.sql' => 'Passed'
}
],
'src/bd_astar/test/test.conf' => [
{
'comment' => 'Bi-directional AStar test for any versions.',
'src/bd_astar/test/bd_astar-any-01.test.sql' => 'Passed',
'src/bd_astar/test/bd_astar-any-02.test.sql' => 'Passed',
'src/bd_astar/test/bd_astar-any-03.test.sql' => 'Passed',
'src/bd_astar/test/bd_astar-any-04.test.sql' => 'Passed',
'src/bd_astar/test/bd_astar-any-05.test.sql' => 'Passed',
'src/bd_astar/test/bd_astar-any-06.test.sql' => 'Passed'
}
],
'src/bd_dijkstra/test/test.conf' => [
{
'comment' => 'Bi-directional Dijkstra test for any versions.',
'src/bd_dijkstra/test/bd_dijkstra-any-01.test.sql' => 'Passed',
'src/bd_dijkstra/test/bd_dijkstra-any-02.test.sql' => 'Passed',
'src/bd_dijkstra/test/bd_dijkstra-any-03.test.sql' => 'Passed',
'src/bd_dijkstra/test/bd_dijkstra-any-04.test.sql' => 'Passed',
'src/bd_dijkstra/test/bd_dijkstra-any-05.test.sql' => 'Passed',
'src/bd_dijkstra/test/bd_dijkstra-any-06.test.sql' => '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.sql' => 'FAILED: 2c2
< NOTICE: pgr_createTopology(\'edges2\',1e-06,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_createTopology(\'edges2\',1e-006,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')',
'src/common/test/common-any-02.test.sql' => 'FAILED: 2c2
< NOTICE: pgr_createTopology(\'edges2\',1e-06,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_createTopology(\'edges2\',1e-006,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')
11c11
< NOTICE: pgr_analyzeGraph(\'edges2\',1e-06,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_analyzeGraph(\'edges2\',1e-006,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')',
'src/common/test/common-any-03.test.sql' => 'FAILED: 2c2
< NOTICE: pgr_createTopology(\'edges2\',1e-05,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_createTopology(\'edges2\',1e-005,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')',
'src/common/test/common-any-04.test.sql' => 'FAILED: 3c3
< NOTICE: pgr_nodeNetwork(\'unnoded\',1e-06,\'the_geom\',\'id\',\'noded\')
---
> NOTICE: pgr_nodeNetwork(\'unnoded\',1e-006,\'the_geom\',\'id\',\'noded\')
16c16
< NOTICE: pgr_createTopology(\'unnoded_noded\',1e-06,\'the_geom\',\'id\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_createTopology(\'unnoded_noded\',1e-006,\'the_geom\',\'id\',\'source\',\'target\',\'true\')
25c25
< NOTICE: pgr_analyzeGraph(\'unnoded_noded\',1e-06,\'the_geom\',\'id\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_analyzeGraph(\'unnoded_noded\',1e-006,\'the_geom\',\'id\',\'source\',\'target\',\'true\')
113c113
< NOTICE: pgr_createTopology(\'noded2\',1e-06,\'the_geom\',\'gid\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_createTopology(\'noded2\',1e-006,\'the_geom\',\'gid\',\'source\',\'target\',\'true\')
122c122
< NOTICE: pgr_analyzeGraph(\'noded2\',1e-06,\'the_geom\',\'gid\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_analyzeGraph(\'noded2\',1e-006,\'the_geom\',\'gid\',\'source\',\'target\',\'true\')',
'src/common/test/common-any-05.test.sql' => 'FAILED: 4c4
< NOTICE: pgr_createTopology(\'noded3\',1e-06,\'the_geom\',\'gid\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_createTopology(\'noded3\',1e-006,\'the_geom\',\'gid\',\'source\',\'target\',\'true\')',
'src/common/test/createTopology-any-01.test.sql' => 'Passed',
'src/common/test/createVerticesTable-any-01.test.sql' => 'FAILED: 2c2
< NOTICE: pgr_createTopology(\'edges2\',1e-05,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')
---
> NOTICE: pgr_createTopology(\'edges2\',1e-005,\'the_geom\',\'eid\',\'source\',\'target\',\'true\')',
'src/common/test/gettablename-any-01.test.sql' => 'Passed',
'src/common/test/incrementalCreateTopology_any_01.test.sql' => 'Passed',
'src/common/test/isColumnInTable-any.test.sql' => 'Passed',
'src/common/test/isColumnIndexed-any.test.sql' => 'Passed',
'src/common/test/no_underscored-2x.test.sql' => 'Passed',
'src/common/test/pgr_checkVertTab_any_01.test.sql' => 'Passed',
'src/common/test/pgr_getColumnName_any_01.test.sql' => 'Passed',
'src/common/test/pgr_getColumnType_any_01.test.sql' => 'Passed',
'src/common/test/pgrouting_conversion_tools-any-01.test.sql' => 'Passed',
'src/common/test/pgrouting_dmatrix_tools-any-01.test.sql' => 'Passed',
'src/common/test/versionless-any-01.test.sql' => 'Passed'
}
],
'src/dijkstra/test/test.conf' => [
{
'comment' => 'Dijkstra test for any versions.',
'src/dijkstra/test/1_to_many.test.sql' => 'Passed',
'src/dijkstra/test/dijkstra-dir-00.test.sql' => 'Passed',
'src/dijkstra/test/dijkstra-dir-01.test.sql' => 'Passed',
'src/dijkstra/test/dijkstra-undi-00.test.sql' => 'Passed',
'src/dijkstra/test/dijkstra-undi-01.test.sql' => 'Passed',
'src/dijkstra/test/dijkstra-v2.test.sql' => 'Passed',
'src/dijkstra/test/dijkstra-v3.test.sql' => 'Passed',
'src/dijkstra/test/many_to_1.test.sql' => 'Passed',
'src/dijkstra/test/many_to_many.test.sql' => 'Passed'
}
],
'src/driving_distance/test/test.conf' => [
{
'comment' => 'Driving Distance test for any versions.',
'src/driving_distance/test/drivingdistance-any-00.test.sql' => 'Passed',
'src/driving_distance/test/drivingdistance-doc-v2.test.sql' => 'Passed',
'src/driving_distance/test/drivingdistance-doc-v3.test.sql' => 'Passed'
}
],
'src/kdijkstra/test/test.conf' => [
{
'comment' => 'KDijkstra test for any versions.',
'src/kdijkstra/test/kdijkstra-any-01.test.sql' => 'Passed',
'src/kdijkstra/test/kdijkstra-any-02.test.sql' => 'Passed',
'src/kdijkstra/test/kdijkstra-any-03.test.sql' => 'Passed',
'src/kdijkstra/test/vidstodmatrix-any-01.test.sql' => 'Passed',
'src/kdijkstra/test/vidstodmatrix-any-02.test.sql' => 'Passed'
}
],
'src/ksp/test/test.conf' => [
{
'comment' => 'KSP test for any versions.',
'src/ksp/test/ksp-any-01.test.sql' => 'Passed',
'src/ksp/test/ksp-any-02.test.sql' => 'Passed',
'src/ksp/test/ksp-parallel-any-03.test.sql' => 'Passed',
'src/ksp/test/ksp-v2.test.sql' => 'Passed',
'src/ksp/test/ksp-v3.test.sql' => 'CRASHED SERVER: 125,205c125,128
< 0|-1|-1|-1|0|0
< 0|0|2|4|1|0
< 1|0|5|8|1|1
< 2|0|6|9|1|2
< 3|0|9|15|1|3
< 4|0|12|-1|0|4
< 5|1|2|4|1|0
< 6|1|5|8|1|1
< 7|1|6|11|1|0
< 8|1|11|13|1|1
< 9|1|12|-1|0|2
< 0|0|2|4|1|0
< 1|0|5|8|1|1
< 2|0|6|9|1|2
< 3|0|9|15|1|3
< 4|0|12|-1|0|4
< 5|1|2|4|1|0
< 6|1|5|8|1|1
< 7|1|6|11|1|0
< 8|1|11|13|1|1
< 9|1|12|-1|0|2
< 10|2|2|4|1|0
< 11|2|5|10|1|0
< 12|2|10|12|1|1
< 13|2|11|13|1|2
< 14|2|12|-1|0|3
< 0|0|2|4|1|0
< 1|0|5|8|1|1
< 2|0|6|9|1|2
< 3|0|9|15|1|3
< 4|0|12|-1|0|4
< 5|1|2|4|1|0
< 6|1|5|8|1|1
< 7|1|6|11|1|0
< 8|1|11|13|1|1
< 9|1|12|-1|0|2
< 10|2|2|4|1|0
< 11|2|5|10|1|0
< 12|2|10|12|1|1
< 13|2|11|13|1|2
< 14|2|12|-1|0|3
< 0|0|2|4|1|0
< 1|0|5|8|1|1
< 2|0|6|9|1|2
< 3|0|9|15|1|3
< 4|0|12|-1|0|4
< 5|1|2|4|1|0
< 6|1|5|8|1|1
< 7|1|6|11|1|0
< 8|1|11|13|1|1
< 9|1|12|-1|0|2
< 0|0|2|4|1|0
< 1|0|5|8|1|1
< 2|0|6|9|1|2
< 3|0|9|15|1|3
< 4|0|12|-1|0|4
< 5|1|2|4|1|0
< 6|1|5|8|1|1
< 7|1|6|11|1|0
< 8|1|11|13|1|1
< 9|1|12|-1|0|2
< 10|2|2|4|1|0
< 11|2|5|10|1|0
< 12|2|10|12|1|1
< 13|2|11|13|1|2
< 14|2|12|-1|0|3
< 0|0|2|4|1|0
< 1|0|5|8|1|1
< 2|0|6|9|1|2
< 3|0|9|15|1|3
< 4|0|12|-1|0|4
< 5|1|2|4|1|0
< 6|1|5|8|1|1
< 7|1|6|11|1|0
< 8|1|11|13|1|1
< 9|1|12|-1|0|2
< 10|2|2|4|1|0
< 11|2|5|10|1|0
< 12|2|10|12|1|1
< 13|2|11|13|1|2
< 14|2|12|-1|0|3
---
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> connection to server was lost',
'src/ksp/test/show_data.test.sql' => 'Passed'
}
],
'src/trsp/test/test.conf' => [
{
'comment' => 'TRSP test for any versions.',
'src/trsp/test/trsp-any-00.test.sql' => 'Passed',
'src/trsp/test/trsp-any-01.test.sql' => 'Passed',
'src/trsp/test/trsp-any-02.test.sql' => 'Passed',
'src/trsp/test/trsp-any-03.test.sql' => 'Passed',
'src/trsp/test/trsp-issue244.test.sql' => 'Passed',
'src/trsp/test/trsp_vias-any-04.test.sql' => 'Passed'
}
],
'src/tsp/test/test.conf' => [
{
'comment' => 'TSP test for any versions.',
'src/tsp/test/tsp-any-00.test.sql' => 'Passed',
'src/tsp/test/tsp-any-01.test.sql' => 'Passed',
'src/tsp/test/tsp-any-03.test.sql' => 'Passed',
'src/tsp/test/tsp-any-04.test.sql' => 'Passed',
'src/tsp/test/tsp-any-05.test.sql' => 'Passed'
}
],
'src/vrp_basic/test/test.conf' => [
{
'comment' => 'VRP Single depot test for any versions.'
}
],
'z_crash' => 1,
'z_fail' => 6,
'z_pass' => 83
};I should note I only tested on my 9.3.9 w64. Haven't tried on the 32-bit one.
cvvergara
commented
9 years ago @robe2 Regina: You did it!!! its compiling!!! thanks very much. Can you pull request against develop_2_1_0 in the main repository? I'll fix the tests. (I think they are alredy fixed in the repository)
Thanks again!!!!
cvvergara
commented
9 years ago @robe2 Regina: Sorry to bother you again, looks like pg_config.exe is not found.
I Iam getting the following in build 1920 & 1921:
-- POSTGRESQL_EXECUTABLE is e:/jenkins/postgresql/rel/pg9.3w64gcc48/bin/postgres.exe
-- POSTGRESQL_PG_CONFIG is POSTGRESQL_PG_CONFIG-NOTFOUND
-- PostgreSQL not found.
CMake Error at CMakeLists.txt:102 (message):
Please check your PostgreSQL installation.In build 1919 I got:
-- CMAKE_PREFIX_PATH=/usr:/usr/local:/c/ming32/projects/pgx32/pg92
-- POSTGRESQL_EXECUTABLE is e:/jenkins/postgresql/rel/pg9.3w32gcc481/bin/postgres.exe
-- POSTGRESQL_PG_CONFIG is e:/jenkins/postgresql/rel/pg9.3w32gcc481/bin/pg_config.exe
-- POSTGRESQL_INCLUDE_DIR: e:/jenkins/postgresql/rel/pg9.3w32gcc481/include/server
-- POSTGRESQL_LIBRARIES: e:/jenkins/postgresql/rel/pg9.3w32gcc481/libHmm I did upgrade it recently but the pg_config is there and seems to work. Does it just look for pg_config in same folder as postgres. I assumed so
E:\jenkins\postgresql\rel\pg9.3w64gcc48\bin\pg_config
BINDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/bin
DOCDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/share/doc
HTMLDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/share/doc
INCLUDEDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/include
PKGINCLUDEDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/include
INCLUDEDIR-SERVER = E:/jenkins/postgresql/rel/pg9.3w64gcc48/include/server
LIBDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/lib
PKGLIBDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/lib
LOCALEDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/share/locale
MANDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/share/man
SHAREDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/share
SYSCONFDIR = E:/jenkins/postgresql/rel/pg9.3w64gcc48/etc
PGXS = E:/jenkins/postgresql/rel/pg9.3w64gcc48/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/projects/postgresql/rel/pg9.3w64gcc48' '--build=x86_64-w6
4-mingw32' '--disable-float8-byval' '--enable-cassert' '--enable-debug' '--enabl
e-integer-datetimes' '--with-libxml' '--without-zlib' 'build_alias=x86_64-w64-mi
ngw32'
CC = gcc
CPPFLAGS = -I./src/include/port/win32 -DEXEC_BACKEND -I/projects/libxml/rel-libx
ml2-2.7.8w64gcc48/include/libxml2 -I../../../src/include/port/win32
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-stat
ement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-al
iasing -fwrapv -fexcess-precision=standard -g
CFLAGS_SL =
LDFLAGS = -L../../../src/common -Wl,--allow-multiple-definition -L/projects/libx
ml/rel-libxml2-2.7.8w64gcc48/lib -Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgport -lpgcommon -lxml2 -lwsock32 -lm -lws2_32 -lshfolder
VERSION = PostgreSQL 9.3.9I was missing the libxml dependency in the folder but just put that there. I suppose it could still be the libxml causing problems.
My 9.3.9 32-bit pg_config output looks like:
E:\jenkins\postgresql\rel\pg9.3w64gcc48>E:\jenkins\postgresql\rel\pg9.3w32gcc481
\bin\pg_config
BINDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/bin
DOCDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/share/doc
HTMLDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/share/doc
INCLUDEDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/include
PKGINCLUDEDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/include
INCLUDEDIR-SERVER = E:/jenkins/postgresql/rel/pg9.3w32gcc481/include/server
LIBDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/lib
PKGLIBDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/lib
LOCALEDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/share/locale
MANDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/share/man
SHAREDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/share
SYSCONFDIR = E:/jenkins/postgresql/rel/pg9.3w32gcc481/etc
PGXS = E:/jenkins/postgresql/rel/pg9.3w32gcc481/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--host=i686-w64-mingw32' '--prefix=/projects/postgresql/rel/pg9.3w3
2gcc481' '--build=i686-w64-mingw32' '--disable-float8-byval' '--enable-cassert'
'--enable-debug' '--enable-integer-datetimes' '--without-zlib' 'build_alias=i686
-w64-mingw32' 'host_alias=i686-w64-mingw32'
CC = i686-w64-mingw32-gcc
CPPFLAGS = -I./src/include/port/win32 -DEXEC_BACKEND -I../../../src/include/port
/win32
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-stat
ement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-al
iasing -fwrapv -fexcess-precision=standard -g
CFLAGS_SL =
LDFLAGS = -L../../../src/common -Wl,--allow-multiple-definition -Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgport -lpgcommon -lm -lws2_32 -lshfolder
VERSION = PostgreSQL 9.3.9I'll try compling without libxml and see if that fixes it.
robe2
commented
9 years ago Tried recompiling and it didn't help. It looks like I am getting now found for all of them now. Did something change in the findmake?
cvvergara
commented
9 years ago @robe2 Regina, The same error happens on Mac, So I am re-checking CMakelists. https://github.com/pgRouting/pgrouting/issues/301#issuecomment-116373187
cvvergara
commented
9 years ago @robe2 Regina, Thanks for everything, It was two files that generated the error on mac also, and actually the changes to "handle" many postgresql versions in one server is what doesn't work for windows or mac. (those changes only worked on travis) I also used the fix you mentioned of winsock. (yes a lot of files to modify) Vicky
robe2
commented
9 years ago Great work.
I still have to setup to truly test against the VC++ standard builds though. still on my list but got to get my PostGIS installing right first under EDB using create extension before I can do that.
Thanks.
cvvergara
commented
9 years ago Ok, I will create a new issue that mentions the standard builds for develop_2_1_0 . (because develop still has the changes to handle many postgresql versions in one server) tagging it as work in progress.
cvvergara
commented
9 years ago Not closing this issue because it needs to get fixed on develop for the handling many postgresql versions in one server
robe2
commented
9 years ago I put comment in wrong ticket -- sorry meant to put my trsp troubleshooting here:
Yap same issue -- unremarking the DEBUG 1 in trsp.c makes it work.
What's interesting is that it fails still under cmake tests, but that's because I have ignore notices turned on there.
So with the debug flag turned on, when I do this:
set client_min_messages='ERROR';
select * from pgr_trsp(
'select eid as id, source::integer, target::integer, cost, reverse_cost from edges1',
1, -- node_id of start
5, -- node_id of end
true, -- directed graph?
true, -- has_reverse_cost?
null); -- no turn restrictionsGives wrong answer:
seq | id1 | id2 | cost
-----+-----+-----+-----------------------
0 | -1 | 0 | 8.89318162514244e-323But if I do this:
set client_min_messages='NOTICE';
select * from pgr_trsp(
'select eid as id, source::integer, target::integer, cost, reverse_cost from edges1',
1, -- node_id of start
5, -- node_id of end
true, -- directed graph?
true, -- has_reverse_cost?
null); -- no turn restrictionsGives right answer
NOTICE: Calling compute_trsp
NOTICE: start turn_restrict_shortest_path
NOTICE: columns: id 1 source 2 target 3 cost 4
NOTICE: columns: reverse_cost cost 5
NOTICE: Min vertex id: 1 , Max vid: 13
NOTICE: Total 16 edge tuples
NOTICE: Fetching restriction tuples
NOTICE: Sql for restrictions is null.
NOTICE: Total 0 restriction tuples
NOTICE: Calling trsp_node_wrapper
NOTICE: Message received from inside:
NOTICE: XdB
NOTICE: ret = 0
NOTICE: *path_count = 5
NOTICE: In finish, trying to disconnect from spi 0
NOTICE: Ret is 0
NOTICE: Total cost is: 4.000000
NOTICE: Going to free path
seq | id1 | id2 | cost
----+-----+-----+------
0 | 1 | 1 | 1
1 | 2 | 4 | 1
2 | 7 | 7 | 1
3 | 6 | 6 | 1
4 | 5 | -1 | 0I thought the elog stuff runs whether or not you set it to write to client? So why would one cause a memory issue and the other not.
woodbri
commented
9 years ago when DEBUG is not defined we don't compile the elog, so compile with DEBUG set causes addition data to complied and there is probably an off by one array overwrite somewhere that is overwriting something benign when the elog message get added.
robe2
commented
9 years ago What I'm saying is I don't think it has anything to do with whether its compiled or not, because even with DEBUG it fails if I have client messages set to ignore (as I normally do in the tests). So it still fails during the tests, but when I manually run it with client messages set to allow notices it works. Trun off client notices it fails.
woodbri
commented
9 years ago ahhh, ok. then I have no idea what is happening.
robe2
commented
9 years ago Just switched winnie to test against EDB distributed PostgreSQL (VC++) and good news is issue only seems to be in 64-bit VC++ build, not the 32-bit VC++ build.
cvvergara
commented
9 years ago A note has being added in notes on installation
@robe2, @woodbri I am opening this issue, now that #337 passed tests on Winnie (PostGIS/PgRouting windows buildbot)