<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1">Hello <br>
<br>
The latest planet file which we have downloaded is OK and we have
started with the import<br>
Since osm2pgsql does not work for us since there is no sufficient
memory we have tried with osmosis <br>
Now the reading part is OK since we have 4GB of ram and we also
have an additional partition over 400GB which is used for osmosis
to put the temporary file, but we get the following error<br>
<br>
F:\osmosis-latest\osmosis-0.39\bin>osmosis --read-xml
file="D:\planet-latest.osm" --wp user="postgres" database="gisw"
host="10.1.1.63"<br>
Jun 15, 2011 9:33:26 AM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Osmosis Version 0.39<br>
Jun 15, 2011 9:33:26 AM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Preparing pipeline.<br>
Jun 15, 2011 9:33:26 AM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Launching pipeline execution.<br>
Jun 15, 2011 9:33:26 AM org.openstreetmap.osmosis.core.Osmosis run<br>
INFO: Pipeline executing, waiting for completion.<br>
Jun 15, 2011 12:02:16 PM
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions<br>
INFO: Loading XML bean definitions from class path resource
[org/springframework/jdbc/support/sql-error-codes.xml]<br>
Jun 15, 2011 12:02:16 PM
org.springframework.jdbc.support.SQLErrorCodesFactory <init><br>
INFO: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix,
MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]<br>
Jun 15, 2011 12:02:20 PM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion<br>
SEVERE: Thread for task 1-read-xml failed<br>
org.springframework.jdbc.BadSqlGrammarException:
StatementCallback; bad SQL grammar [SELECT version FROM
schema_info]; nested exception is org.postgresql.util.PSQLExcepti<br>
on: ERROR: relation "schema_info" does not exist<br>
Position: 21<br>
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)<br>
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)<br>
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)<br>
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)<br>
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463)<br>
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:471)<br>
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:476)<br>
at
org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:485)<br>
at
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForInt(SimpleJdbcTemplate.java:113)<br>
at
org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateDBVersion(SchemaVersionValidator.java:64)<br>
at
org.openstreetmap.osmosis.pgsnapshot.common.SchemaVersionValidator.validateVersion(SchemaVersionValidator.java:47)<br>
at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.CopyFilesetLoader.run(CopyFilesetLoader.java:78)<br>
at
org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlCopyWriter.complete(PostgreSqlCopyWriter.java:108)<br>
at
org.openstreetmap.osmosis.xml.v0_6.XmlReader.run(XmlReader.java:110)<br>
at java.lang.Thread.run(Unknown Source)<br>
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"schema_info" does not exist<br>
Position: 21<br>
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br>
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)<br>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)<br>
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)<br>
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)<br>
at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440)<br>
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)<br>
... 12 more<br>
Jun 15, 2011 12:02:20 PM org.openstreetmap.osmosis.core.Osmosis
main<br>
SEVERE: Execution aborted.<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or
more tasks failed.<br>
at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)<br>
at
org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)<br>
at
org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)<br>
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<br>
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)<br>
at java.lang.reflect.Method.invoke(Unknown Source)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:329)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:239)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)<br>
at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)<br>
at
org.codehaus.classworlds.Launcher.main(Launcher.java:31)<br>
<br>
F:\osmosis-latest\osmosis-0.39\bin><br>
<br>
The database is postGIS.<br>
Are we missing something ?<br>
</font><br>
On 6/14/2011 12:55 AM, Jon Burgess wrote:
<blockquote
cite="mid:1308005740.2379.11.camel@shark.nightingale.homedns.org"
type="cite">
<pre wrap="">On Mon, 2011-06-13 at 12:04 +0200, Zolt Egete wrote:
</pre>
<blockquote type="cite">
<pre wrap="">As far as other map files are concerned I have downloaded a few ones
but this is the only one which I could unpack (have used pbzunzip2,
bzip2, bunzip2) but all the time I have got corrupt archive messages.
Also the MD5 sum of the downloaded file where not consistent with the
md5 hash sum from the servers (I do not yet know the reason why)
</pre>
</blockquote>
<pre wrap="">I think this is where your problem is.
With the recurring checksum issues you are seeing I would suspect that
something in your system is causing random data to be corruption. This
could be one of a thousand different things: a faulty RAM module, hard
drive cable, bad PSU, an over clocked or over heating CPU, bad PCI card
etc. Or it could be a software issue, such as a bad driver in the kernel
or X11. It can be really hard to identify the real cause but you could
try running memtest86+ or swapping around pieces of hardware.
I do not believe the files on the server are at fault. If they were then
I would expect to see many more complaints.
Until you can resolve the underlying data corruption issue then I don't
believe it is worth you trying different combinations of options with
osm2pgsql.
Jon
</pre>
</blockquote>
</body>
</html>