Your message dated Thu, 14 May 2015 00:34:02 +0200
with message-id <5553d15a.6020...@xs4all.nl>
and subject line Re: Bug#785257: osmosis: ClassCastException when reading from
pgsnapshot
has caused the Debian Bug report #785257,
regarding osmosis: ClassCastException when reading from pgsnapshot
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
785257: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=785257
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: osmosis
Version: 0.43.1-4
Severity: normal
I recently dropped my pgsimple database and created a new pgsnapshot
database. But although osmosis successfully writes to it (both
initially and every night using replication), a read fails:
/--------
| $ osmosis -q --read-pgsimp database=osm --dataset-dump --write-null
| log4j:WARN No appenders could be found for logger
(org.springframework.jdbc.datasource.DataSourceTransactionManager).
| log4j:WARN Please initialize the log4j system properly.
| log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more
info.
| May 13, 2015 5:30:03 AM
org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager
waitForCompletion
| SEVERE: Thread for task 1-read-pgsql failed
| java.lang.ClassCastException: java.util.HashMap cannot be cast to
org.openstreetmap.osmosis.hstore.PGHStore
| at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.EntityRowMapper.mapCommonEntityData(EntityRowMapper.java:80)
| at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.NodeRowMapper.mapRow(NodeRowMapper.java:30)
| at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.NodeRowMapper.mapRow(NodeRowMapper.java:17)
| at
org.openstreetmap.osmosis.pgsnapshot.common.RowMapperRowCallbackListener.processRow(RowMapperRowCallbackListener.java:46)
| at
org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1493)
| at
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:446)
| at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
| at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
| at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:460)
| at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.EntityDao.getFeaturelessEntity(EntityDao.java:178)
| at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.EntityDao.iterate(EntityDao.java:227)
| at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.EntityDao.iterate(EntityDao.java:256)
| at
org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.PostgreSqlDatasetContext.iterate(PostgreSqlDatasetContext.java:208)
| at
org.openstreetmap.osmosis.dataset.v0_6.DumpDataset.process(DumpDataset.java:48)
| at
org.openstreetmap.osmosis.pgsnapshot.v0_6.PostgreSqlDatasetReader.run(PostgreSqlDatasetReader.java:53)
| at java.lang.Thread.run(Thread.java:745)
|
| May 13, 2015 5:30:03 AM org.openstreetmap.osmosis.core.Osmosis main
| SEVERE: Execution aborted.
| org.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks
failed.
| at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)
| at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)
| at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
| at java.lang.reflect.Method.invoke(Method.java:606)
| at
org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:328)
| at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)
| at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408)
| at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351)
| at org.codehaus.classworlds.Launcher.main(Launcher.java:31)
\--------
Shell tracing /usr/bin/osmosis shows the final command as
/--------
| exec java -server -Xmx4G -Djava.io.tmpdir=/tmp/user/1000 -cp
/usr/share/java/plexus-classworlds.jar -Dapp.home=/usr/share/osmosis
-Dclassworlds.conf=/etc/osmosis/plexus.conf
-Dlog4j.configuration=file:/etc/osmosis/log4j.properties
org.codehaus.classworlds.Launcher -q --read-pgsimp database=osm --dataset-dump
--write-null
\--------
My database was created using the SQL from
/usr/share/doc/osmosis/examples/pgsnapshot_schema_0.6*, and the table
definitions look reasonable - here's the nodes table:
/--------
| osm=# \d nodes
| Table "public.nodes"
| Column | Type | Modifiers
| --------------+-----------------------------+-----------
| id | bigint | not null
| version | integer | not null
| user_id | integer | not null
| tstamp | timestamp without time zone | not null
| changeset_id | bigint | not null
| tags | hstore |
| geom | geometry(Point,4326) |
| Indexes:
| "pk_nodes" PRIMARY KEY, btree (id)
| "idx_nodes_geom" gist (geom)
\--------
P.S. the log4j warnings start appearing once I use pgsnapshot operations,
and didn't with pgsimple - related to Bug #579206, perhaps?
-- System Information:
Debian Release: stretch/sid
APT prefers testing
APT policy: (900, 'testing'), (900, 'stable'), (400, 'unstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386, armel
Kernel: Linux 3.16.7-ckt2-balti (SMP w/8 CPU cores; PREEMPT)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: sysvinit (via /sbin/init)
Versions of packages osmosis depends on:
ii default-jre-headless [java6-runtime-headless] 2:1.7-52
ii libbatik-java 1.7+dfsg-5
ii libcommons-codec-java 1.10-1
ii libcommons-compress-java 1.9-1
ii libcommons-dbcp-java 1.4-5
ii libcommons-pool-java 1.6-2
ii libjpf-java 1.5.1+dfsg-4
ii libmysql-java 5.1.32-1
ii libnetty-java 1:3.2.6.Final-2
ii libosmpbf-java 1.3.3-3
ii libplexus-classworlds-java 1.5.0-5
ii libpostgis-java 2.1.7+dfsg-1
ii libpostgresql-jdbc-java 9.2-1002-1
ii libprotobuf-java 2.6.1-1
ii libspring-beans-java 3.2.13-1
ii libspring-context-java 3.2.13-1
ii libspring-core-java 3.2.13-1
ii libspring-jdbc-java 3.2.13-1
ii libspring-transaction-java 3.2.13-1
ii libxerces2-java 2.11.0-7
ii libxz-java 1.5-1
ii openjdk-6-jre-headless [java6-runtime-headless] 6b35-1.13.7-1
ii openjdk-7-jre-headless [java6-runtime-headless] 7u79-2.5.5-1~deb8u1
osmosis recommends no packages.
osmosis suggests no packages.
-- no debconf information
--- End Message ---
--- Begin Message ---
On 05/13/2015 11:17 PM, Toby Speight wrote:
> I recently dropped my pgsimple database and created a new pgsnapshot
> database. But although osmosis successfully writes to it (both
> initially and every night using replication), a read fails:
>
> /--------
> | $ osmosis -q --read-pgsimp database=osm --dataset-dump --write-null
You should use --read-pgsql for the snapshot schema.
Or recreate your database with the simple schema you used before.
> | log4j:WARN No appenders could be found for logger
> (org.springframework.jdbc.datasource.DataSourceTransactionManager).
> | log4j:WARN Please initialize the log4j system properly.
> | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for
> more info.
> P.S. the log4j warnings start appearing once I use pgsnapshot operations,
> and didn't with pgsimple - related to Bug #579206, perhaps?
The log4j warnings are related to #579206, there are no appenders
configured int he log4j.properties shipped with osmosis it only sets the
level level to WARN.
Kind Regards,
Bas
--
GPG Key ID: 4096R/6750F10AE88D4AF1
Fingerprint: 8182 DE41 7056 408D 6146 50D1 6750 F10A E88D 4AF1
--- End Message ---
_______________________________________________
Pkg-grass-devel mailing list
Pkg-grass-devel@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-grass-devel
