Skip to content

Instantly share code, notes, and snippets.

@klonuo
Created August 11, 2014 15:43
Show Gist options
  • Save klonuo/b430d2dfd689919b76af to your computer and use it in GitHub Desktop.
Save klonuo/b430d2dfd689919b76af 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
Failed to create directory for tablespaceglobal name 'self' is not defined
....****************************************
Running initial import for basic case
*********************************
.****************************************
Running initial import for slim --drop case
*********************************
.****************************************
Running initial import for Hstore index drop
*********************************
.E****************************************
Running initial import for --tag-transform-script
*********************************
...****************************************
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
*********************************
.EEEE****************************************
Running initial import for --tag-transform-script
*********************************
Running diff-import for --tag-transform-script
*********************************
...****************************************
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
*********************************
F****************************************
Running initial import for lua tagtransform case
*********************************
Running diff-import for lua tagtransform case
*********************************
F****************************************
Running initial import for lua tagtransform case with hstore
*********************************
Running diff-import for lua tagtransform case with hstore
*********************************
F..****************************************
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\osm2pgsql\regression-test.py", line 415, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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-win-cmake (64bit id space)
Projection code failed to initialise
======================================================================
ERROR: runTest (__main__.BasicSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 433, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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:
======================================================================
ERROR: runTest (__main__.BasicSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 433, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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: '['--tablespace-main-data', 'tablespacetest']' failed:
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
osm2pgsql SVN version 0.85-win-cmake (64bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
CREATE TABLE planet_osm_point ( osm_id int8,"access" text,"addr:housename" text,"addr:housenumber" text,"addr:interpolation" text,"admin_level" text,"aerialway" text,"aeroway" text,"amenity" text,"area" text,"barrier" text,"bicycle" text,"brand" text,"bridge" text,"boundary" text,"building" text,"capital" text,"construction" text,"covered" text,"culvert" text,"cutting" text,"denomination" text,"disused" text,"ele" text,"embankment" text,"foot" text,"generator:source" text,"harbour" text,"highway" text,"historic" text,"horse" text,"intermittent" text,"junction" text,"landuse" text,"layer" text,"leisure" text,"lock" text,"man_made" text,"military" text,"motorcar" text,"name" text,"natural" text,"office" text,"oneway" text,"operator" text,"place" text,"poi" text,"population" text,"power" text,"power_source" text,"public_transport" text,"railway" text,"ref" text,"religion" text,"route" text,"service" text,"shop" text,"sport" text,"surface" text,"toll" text,"tourism" text,"tower:type" text,"tunnel" text,"water" text,"waterway" text,"wetland" text,"width" text,"wood" text,"z_order" int4) TABLESPACE tablespacetest
failed: ERROR: tablespace "tablespacetest" does not exist
Error occurred, cleaning up
======================================================================
ERROR: runTest (__main__.BasicSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 433, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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: '['--tablespace-main-index', 'tablespacetest']' failed:
NOTICE: table "planet_osm_point" does not exist, skipping
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
osm2pgsql SVN version 0.85-win-cmake (64bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
CREATE INDEX planet_osm_point_pkey ON planet_osm_point USING BTREE (osm_id) TABLESPACE tablespacetest
failed: ERROR: tablespace "tablespacetest" does not exist
Error occurred, cleaning up
======================================================================
ERROR: runTest (__main__.BasicSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 433, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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: '['--tablespace-slim-data', 'tablespacetest']' failed:
NOTICE: table "planet_osm_point" does not exist, skipping
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
osm2pgsql SVN version 0.85-win-cmake (64bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Using built-in tag processing pipeline
Allocating memory for sparse node cache
Node-cache: cache=100MB, maxblocks=12800*zd, allocation method=8192
Mid: pgsql, scale=100 cache=100
Setting up table: planet_osm_nodes
CREATE TABLE planet_osm_nodes (id int8 PRIMARY KEY , lat int4 not null, lon int4 not null, tags text[]) TABLESPACE tablespacetest;
failed: ERROR: tablespace "tablespacetest" does not exist
Error occurred, cleaning up
======================================================================
ERROR: runTest (__main__.BasicSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 433, in setUp
self.setUpGeneric(self.parameters, full_import_file)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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: '['--tablespace-slim-index', 'tablespacetest']' failed:
NOTICE: table "planet_osm_point" does not exist, skipping
NOTICE: table "planet_osm_point_tmp" does not exist, skipping
NOTICE: table "planet_osm_line" does not exist, skipping
NOTICE: table "planet_osm_line_tmp" does not exist, skipping
NOTICE: table "planet_osm_polygon" does not exist, skipping
NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping
NOTICE: table "planet_osm_roads" does not exist, skipping
NOTICE: table "planet_osm_roads_tmp" does not exist, skipping
NOTICE: table "planet_osm_nodes" does not exist, skipping
osm2pgsql SVN version 0.85-win-cmake (64bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Using built-in tag processing pipeline
Allocating memory for sparse node cache
Node-cache: cache=100MB, maxblocks=12800*zd, allocation method=8192
Mid: pgsql, scale=100 cache=100
Setting up table: planet_osm_nodes
CREATE TABLE planet_osm_nodes (id int8 PRIMARY KEY USING INDEX TABLESPACE tablespacetest, lat int4 not null, lon int4 not null, tags text[]) ;
failed: ERROR: tablespace "tablespacetest" does not exist
Error occurred, cleaning up
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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') {['--tag-transform-script', 'style.lua']}
======================================================================
FAIL: runTest (__main__.MultipolygonSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 464, in runTest
self.executeStatements(self.postDiffStatements)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\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') {['--tag-transform-script', 'style.lua', '-k']}
----------------------------------------------------------------------
Ran 40 tests in 303.271s
FAILED (failures=8, errors=6)
Cleaning up test database
[Finished in 312.4s]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment