Skip to content

Instantly share code, notes, and snippets.

@klonuo
Created August 12, 2014 12:20
Show Gist options
  • Save klonuo/a0c2680cfca7a67c28de to your computer and use it in GitHub Desktop.
Save klonuo/a0c2680cfca7a67c28de 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
*********************************
.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
*********************************
.****************************************
Running initial import for Parallel processing with disabled node-cache
*********************************
Running diff-import for Parallel processing with disabled node-cache
F****************************************
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
*********************************
.****************************************
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
======================================================================
FAIL: runTest (__main__.BasicSlimTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 441, in runTest
self.updateGeneric(self.parameters, diff_import_file)
File "C:\PostgreSQL\9.3\bin\osm2pgsql\regression-test.py", line 390, in updateGeneric
self.assertEqual (proc.returncode, 0, "Execution of osm2pgsql --slim --append with options: '%s' failed:\n%s\n%s\n" % (str(parameters), outp, outerr))
AssertionError: Execution of osm2pgsql --slim --append with options: '['-C0']' failed:
======================================================================
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 385.389s
FAILED (failures=9, errors=1)
Cleaning up test database
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment