<p><a href="https://github.com/danstowell" class="user-mention">@danstowell</a> Error occurred. Any help?</p>
<p>[hanchao07@dx-wmarch-map-routing01 ~]$ ./osmosis/bin/osmosis --truncate-apidb host="waimai-pgsql-wmmapdata01-write.vip.sankuai.com" database="wmgis" user="wmgis_rw" password="3ab8CPjB0C1mx6q7fdsuOuLkp" validateSchemaVersion="no"<br>
九月 19, 2016 5:14:58 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Osmosis Version 0.45<br>
九月 19, 2016 5:14:58 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Preparing pipeline.<br>
九月 19, 2016 5:14:58 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Launching pipeline execution.<br>
九月 19, 2016 5:14:58 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Pipeline executing, waiting for completion.<br>
九月 19, 2016 5:14:59 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Pipeline complete.<br>
九月 19, 2016 5:14:59 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Total execution time: 674 milliseconds.</p>
<p>[hanchao07@dx-wmarch-map-routing01 ~]$ ./osmosis/bin/osmosis --read-pbf file=china-latest.osm.pbf --write-apidb host="waimai-pgsql-wmmapdata01-write.vip.sankuai.com" database="wmgis" user="wmgis_rw" password="****" validateSchemaVersion="no"<br>
九月 19, 2016 5:15:11 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Osmosis Version 0.45<br>
九月 19, 2016 5:15:11 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Preparing pipeline.<br>
九月 19, 2016 5:15:11 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Launching pipeline execution.<br>
九月 19, 2016 5:15:11 下午 org.openstreetmap.osmosis.core.Osmosis run<br>
信息: Pipeline executing, waiting for completion.<br>
九月 19, 2016 5:16:18 下午 org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion<br>
严重: Thread for task 1-read-pbf failed<br>
org.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to insert user with id 3642735 into the database.<br>
at org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:143)<br>
at org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.addOrUpdateUser(UserManager.java:191)<br>
at org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1098)<br>
at crosby.binary.osmosis.OsmosisBinaryParser.parseDense(OsmosisBinaryParser.java:138)<br>
at org.openstreetmap.osmosis.osmbinary.BinaryParser.parse(BinaryParser.java:124)<br>
at org.openstreetmap.osmosis.osmbinary.BinaryParser.handleBlock(BinaryParser.java:68)<br>
at org.openstreetmap.osmosis.osmbinary.file.FileBlock.process(FileBlock.java:135)<br>
at org.openstreetmap.osmosis.osmbinary.file.BlockInputStream.process(BlockInputStream.java:34)<br>
at crosby.binary.osmosis.OsmosisReader.run(OsmosisReader.java:45)<br>
at java.lang.Thread.run(Thread.java:745)<br>
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "users_display_name_idx"<br>
详细：Key (display_name)=(Nodes&Roads) already exists.<br>
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)<br>
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)<br>
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)<br>
at org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:140)<br>
... 9 more</p>
<p>九月 19, 2016 5:16:18 下午 org.openstreetmap.osmosis.core.Osmosis main<br>
严重: 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(NativeMethodAccessorImpl.java:57)<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>
at java.lang.reflect.Method.invoke(Method.java:606)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:330)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)<br>
at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)<br>
at org.codehaus.classworlds.Launcher.main(Launcher.java:47)</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/282#issuecomment-247947133">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABWnLTit1CSJctNYpdnopqk6t2TN8-fyks5qrlU4gaJpZM4ApvMe">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/ABWnLXRp0vNGKEVr1OZDr1ihk3ZkWsb5ks5qrlU4gaJpZM4ApvMe.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/openstreetmap/openstreetmap-website/issues/282#issuecomment-247947133"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/openstreetmap/openstreetmap-website","title":"openstreetmap/openstreetmap-website","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/openstreetmap-website"}},"updates":{"snippets":[{"icon":"PERSON","message":"@hanchao in #282: @danstowell Error occurred. Any help?\r\n\r\n[hanchao07@dx-wmarch-map-routing01 ~]$ ./osmosis/bin/osmosis --truncate-apidb host=\"waimai-pgsql-wmmapdata01-write.vip.sankuai.com\" database=\"wmgis\" user=\"wmgis_rw\" password=\"3ab8CPjB0C1mx6q7fdsuOuLkp\" validateSchemaVersion=\"no\"\r\n九月 19, 2016 5:14:58 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Osmosis Version 0.45\r\n九月 19, 2016 5:14:58 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Preparing pipeline.\r\n九月 19, 2016 5:14:58 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Launching pipeline execution.\r\n九月 19, 2016 5:14:58 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Pipeline executing, waiting for completion.\r\n九月 19, 2016 5:14:59 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Pipeline complete.\r\n九月 19, 2016 5:14:59 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Total execution time: 674 milliseconds.\r\n\r\n[hanchao07@dx-wmarch-map-routing01 ~]$ ./osmosis/bin/osmosis --read-pbf file=china-latest.osm.pbf --write-apidb host=\"waimai-pgsql-wmmapdata01-write.vip.sankuai.com\" database=\"wmgis\" user=\"wmgis_rw\" password=\"****\" validateSchemaVersion=\"no\"\r\n九月 19, 2016 5:15:11 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Osmosis Version 0.45\r\n九月 19, 2016 5:15:11 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Preparing pipeline.\r\n九月 19, 2016 5:15:11 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Launching pipeline execution.\r\n九月 19, 2016 5:15:11 下午 org.openstreetmap.osmosis.core.Osmosis run\r\n信息: Pipeline executing, waiting for completion.\r\n九月 19, 2016 5:16:18 下午 org.openstreetmap.osmosis.core.pipeline.common.ActiveTaskManager waitForCompletion\r\n严重: Thread for task 1-read-pbf failed\r\norg.openstreetmap.osmosis.core.OsmosisRuntimeException: Unable to insert user with id 3642735 into the database.\r\n \tat org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:143)\r\n \tat org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.addOrUpdateUser(UserManager.java:191)\r\n \tat org.openstreetmap.osmosis.apidb.v0_6.ApidbWriter.process(ApidbWriter.java:1098)\r\n \tat crosby.binary.osmosis.OsmosisBinaryParser.parseDense(OsmosisBinaryParser.java:138)\r\n \tat org.openstreetmap.osmosis.osmbinary.BinaryParser.parse(BinaryParser.java:124)\r\n \tat org.openstreetmap.osmosis.osmbinary.BinaryParser.handleBlock(BinaryParser.java:68)\r\n \tat org.openstreetmap.osmosis.osmbinary.file.FileBlock.process(FileBlock.java:135)\r\n \tat org.openstreetmap.osmosis.osmbinary.file.BlockInputStream.process(BlockInputStream.java:34)\r\n \tat crosby.binary.osmosis.OsmosisReader.run(OsmosisReader.java:45)\r\n \tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"users_display_name_idx\"\r\n 详细：Key (display_name)=(Nodes\u0026Roads) already exists.\r\n \tat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)\r\n \tat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)\r\n \tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)\r\n \tat org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)\r\n \tat org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)\r\n \tat org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)\r\n \tat org.openstreetmap.osmosis.apidb.v0_6.impl.UserManager.insertUser(UserManager.java:140)\r\n \t... 9 more\r\n\r\n九月 19, 2016 5:16:18 下午 org.openstreetmap.osmosis.core.Osmosis main\r\n严重: Execution aborted.\r\norg.openstreetmap.osmosis.core.OsmosisRuntimeException: One or more tasks failed.\r\n \tat org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)\r\n \tat org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:92)\r\n \tat org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:37)\r\n \tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n \tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\r\n \tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n \tat java.lang.reflect.Method.invoke(Method.java:606)\r\n \tat org.codehaus.plexus.classworlds.launcher.Launcher.launchStandard(Launcher.java:330)\r\n \tat org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:238)\r\n \tat org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)\r\n \tat org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)\r\n \tat org.codehaus.classworlds.Launcher.main(Launcher.java:47)\r\n"}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/openstreetmap-website/issues/282#issuecomment-247947133"}}}</script>