Skip to content

Instantly share code, notes, and snippets.

@klonuo
Created August 12, 2014 12:22
Show Gist options
  • Save klonuo/91dd7ceb23028eb295ea to your computer and use it in GitHub Desktop.
Save klonuo/91dd7ceb23028eb295ea to your computer and use it in GitHub Desktop.
Setting up test database
For the test, we need to create a tablespace. This needs root privileges
....****************************************
Running initial import for basic case
*********************************
.****************************************
Running initial import for slim --drop case
*********************************
.****************************************
Running initial import for Hstore index drop
*********************************
.EE..****************************************
Running initial import for basic case
*********************************
Running diff-import for basic case
*********************************
.****************************************
Running initial import for Parallel processing
*********************************
Running diff-import for Parallel processing
*********************************
.****************************************
Running initial import for Parallel processing with non 100% node-cache
*********************************
Running diff-import for Parallel processing with non 100% node-cache
*********************************
.E****************************************
Running initial import for Hstore match only
*********************************
Running diff-import for Hstore match only
*********************************
.****************************************
Running initial import for Hstore name column
*********************************
Running diff-import for Hstore name column
*********************************
.****************************************
Running initial import for Hstore
*********************************
Running diff-import for Hstore
*********************************
.****************************************
Running initial import for Hstore all
*********************************
Running diff-import for Hstore all
*********************************
.****************************************
Running initial import for Hstore index
*********************************
Running diff-import for Hstore index
*********************************
.****************************************
Running initial import for Extra tags hstore match only
*********************************
Running diff-import for Extra tags hstore match only
*********************************
.****************************************
Running initial import for Extra tags hstore all
*********************************
Running diff-import for Extra tags hstore all
*********************************
.****************************************
Running initial import for --tablespace-main-data
*********************************
Running diff-import for --tablespace-main-data
*********************************
.****************************************
Running initial import for --tablespace-main-index
*********************************
Running diff-import for --tablespace-main-index
*********************************
.****************************************
Running initial import for --tablespace-slim-data
*********************************
Running diff-import for --tablespace-slim-data
*********************************
.****************************************
Running initial import for --tablespace-slim-index
*********************************
Running diff-import for --tablespace-slim-index
*********************************
.E..****************************************
Running initial import for basic case
*********************************
Running diff-import for basic case
*********************************
F****************************************
Running initial import for multi geometry
*********************************
Running diff-import for multi geometry
*********************************
F****************************************
Running initial import for hstore case
*********************************
Running diff-import for hstore case
*********************************
F****************************************
Running initial import for hstore case
*********************************
Running diff-import for hstore case
*********************************
F****************************************
Running initial import for Extra tags hstore match only
*********************************
Running diff-import for Extra tags hstore match only
*********************************
F****************************************
Running initial import for Extra tags hstore match only
*********************************
Running diff-import for Extra tags hstore match only
*********************************
FEE..****************************************
Running initial import in gazetteer mode for basic case
*********************************
Running diff-import in gazetteer mode for basic case
*********************************
.
======================================================================
ERROR: runTest (__main__.BasicNonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 415, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 377, in setUpGeneric
self.assertEqual (proc.returncode, 0, "Execution of osm2pgsql with options: '%s' failed:\n%s\n%s\n" % (str(parameters), outp, outerr))
AssertionError: Execution of osm2pgsql with options: '['-l']' failed:
osm2pgsql SVN version 0.85.0 (64bit id space)
Projection code failed to initialise
======================================================================
ERROR: runTest (__main__.BasicNonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 415, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 377, in setUpGeneric
self.assertEqual (proc.returncode, 0, "Execution of osm2pgsql with options: '%s' failed:\n%s\n%s\n" % (str(parameters), outp, outerr))
AssertionError: Execution of osm2pgsql with options: '['--tag-transform-script', 'style.lua']' failed:
osm2pgsql SVN version 0.85.0 (64bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
Using lua based tag processing pipeline with script style.lua
Error: Could not init lua tag transform, as lua support was not compiled into this version
Error: Failed to initialise tag processing.
Error occurred, cleaning up
======================================================================
ERROR: runTest (__main__.BasicSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 433, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 385, in setUpGeneric
self.assertEqual (proc.returncode, 0, "Execution of osm2pgsql --slim with options: '%s' failed:\n%s\n%s\n" % (str(parameters), outp, outerr))
AssertionError: Execution of osm2pgsql --slim with options: '['-C0']' failed:
osm2pgsql SVN version 0.85.0 (64bit id space)
WARNING: ram cache is disabled. This will likely slow down processing a lot.
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
Using built-in tag processing pipeline
Allocating memory for sparse node cache
Node-cache: cache=0MB, maxblocks=0*0, allocation method=8192
Mid: pgsql, scale=100 cache=0
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Reading in file: liechtenstein-2013-08-03.osm.pbf
Processing: Node(10k 10.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(20k 20.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(30k 30.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(40k 40.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(50k 50.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(60k 60.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(1k 1.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(2k 1.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(3k 1.50k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(4k 1.33k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(5k 1.67k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(6k 2.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(7k 2.33k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(10 5.00/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(20 10.00/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(30 15.00/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(40 13.33/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(50 12.50/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(60 15.00/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(70 14.00/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(80 13.33/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(90 15.00/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(100 12.50/s)
Processing: Node(65k 65.7k/s) Way(7k 1.78k/s) Relation(110 13.75/s) parse time: 13s
Node stats: total(65733), max(2403384707) in 1s
Way stats: total(7121), max(232012458) in 4s
Relation stats: total(113), max(3090789) in 8s
Committing transaction for planet_osm_point
1 [main] osm2pgsql 4004 open_stackdumpfile: Dumping stack trace to osm2pgsql.exe.stackdump
======================================================================
ERROR: runTest (__main__.BasicSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 433, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 385, in setUpGeneric
self.assertEqual (proc.returncode, 0, "Execution of osm2pgsql --slim with options: '%s' failed:\n%s\n%s\n" % (str(parameters), outp, outerr))
AssertionError: Execution of osm2pgsql --slim with options: '['--tag-transform-script', 'style.lua']' failed:
osm2pgsql SVN version 0.85.0 (64bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
Using lua based tag processing pipeline with script style.lua
Error: Could not init lua tag transform, as lua support was not compiled into this version
Error: Failed to initialise tag processing.
Error occurred, cleaning up
======================================================================
ERROR: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 455, in setUp
self.setUpGeneric(self.parameters, multipoly_import_file)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 385, in setUpGeneric
self.assertEqual (proc.returncode, 0, "Execution of osm2pgsql --slim with options: '%s' failed:\n%s\n%s\n" % (str(parameters), outp, outerr))
AssertionError: Execution of osm2pgsql --slim with options: '['--tag-transform-script', 'style.lua']' failed:
osm2pgsql SVN version 0.85.0 (64bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
Using lua based tag processing pipeline with script style.lua
Error: Could not init lua tag transform, as lua support was not compiled into this version
Error: Failed to initialise tag processing.
Error occurred, cleaning up
======================================================================
ERROR: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 455, in setUp
self.setUpGeneric(self.parameters, multipoly_import_file)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 385, in setUpGeneric
self.assertEqual (proc.returncode, 0, "Execution of osm2pgsql --slim with options: '%s' failed:\n%s\n%s\n" % (str(parameters), outp, outerr))
AssertionError: Execution of osm2pgsql --slim with options: '['--tag-transform-script', 'style.lua', '-k']' failed:
osm2pgsql SVN version 0.85.0 (64bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table "planet_osm_point" does not exist, skipping
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table "planet_osm_line" does not exist, skipping
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table "planet_osm_polygon" does not exist, skipping
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table "planet_osm_roads" does not exist, skipping
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
Using lua based tag processing pipeline with script style.lua
Error: Could not init lua tag transform, as lua support was not compiled into this version
Error: Failed to initialise tag processing.
Error occurred, cleaning up
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {[]}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-G']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-k']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-k', '--hstore-match-only']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-x', '-k', '--hstore-match-only']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\cygwin-package\regression-test.py", line 367, in executeStatements
" (" + sql_test_statements[i][2] + ") {" + str(self.parameters) +"}")
AssertionError: 66: Failed Multipolygon diff moved point of outer way case (Tags from outer way), expected 24751 but was 24750.0 (SELECT round(ST_Area(way)) FROM planet_osm_polygon WHERE osm_id = -15 and landuse = 'residential' and name = 'Name_way') {['-x', '-j']}
----------------------------------------------------------------------
Ran 40 tests in 1136.206s
FAILED (failures=6, errors=6)
Cleaning up test database
[Finished in 1155.1s]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment