S Knox | 1 Dec 01:28 2008
Picon

Re: [OSM-dev] dev Digest, Vol 44, Issue 56

Hi,

I'm trying to get the Osmosis migration tools to work. I get the following:

01-Dec-2008 00:25:51 com.bretth.osmosis.core.pipeline..common.ActiveTaskManager waitForCompletion
SEVERE: Thread for task 1-read-xml-0.5 failed
java.lang.NullPointerException
        at com.bretth.osmosis.core.migrate.impl.EntityContainerMigrater.process(EntityContainerMigrater.java:56)

It seems that this is common to many tasks using migrate.

Can anyone help - I know this is quite new functionality.

My command line is: --read-xml-0.5 "*****" --migrate --write-pgsql-0.6 host=*** database=*** user=***validateSchemaVersion=no

Many thanks

Steve

_______________________________________________
dev mailing list
dev <at> openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev
Brett Henderson | 1 Dec 01:33 2008

Re: [OSM-dev] dev Digest, Vol 44, Issue 56

I just noticed the same thing.  I did some re-arranging a few things ago and broke something.  I don't have a unit test in place for the migration code ...

I've just checked in a fix.  Are you able to download from svn and compile it yourself?

On Mon, Dec 1, 2008 at 11:28 AM, S Knox <roxyknox <at> yahoo.co.uk> wrote:
Hi,

I'm trying to get the Osmosis migration tools to work. I get the following:

01-Dec-2008 00:25:51 com.bretth.osmosis.core.pipeline..common.ActiveTaskManager waitForCompletion
SEVERE: Thread for task 1-read-xml-0.5 failed
java.lang.NullPointerException
        at com.bretth.osmosis.core.migrate.impl.EntityContainerMigrater.process(EntityContainerMigrater.java:56)

It seems that this is common to many tasks using migrate.

Can anyone help - I know this is quite new functionality.

My command line is: --read-xml-0.5 "*****" --migrate --write-pgsql-0.6 host=*** database=*** user=***validateSchemaVersion=no

Many thanks

Steve


_______________________________________________
dev mailing list
dev <at> openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


_______________________________________________
dev mailing list
dev <at> openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev
Brett Henderson | 1 Dec 10:08 2008

Re: [OSM-dev] Slow Osmosis

Whenever I have seen that error in the past it has been because I have 
data in the tables already.  Changing table types shouldn't have any 
effect on duplicate key checks.  It'd be worth double checking to make 
absolutely sure you have no data in the tables already.

Andreas Kalsch wrote:
> Yes I drop the database completely - part of my shell script:
>
> echo 'Create database, create tables ..'
> mysql -u $mysql_user -p$mysql_pw -e "DROP DATABASE IF EXISTS 
> $db_name;CREATE DATABASE $db_name DEFAULT CHARACTER SET utf8 COLLATE 
> utf8_general_ci;"
>
> date
>
> mysql -u $mysql_user -D $db_name -p$mysql_pw < 
> jobs/osm_schema_latest_optimized0.sql
>
> echo 'Write to database ..'
> osmosis/bin/osmosis --read-xml file=$uncompressedFile --write-mysql 
> host=localhost database=$db_name user=$mysql_user password=$mysql_pw 
> validateSchemaVersion=no
>
> mysql -u $mysql_user -D $db_name -p$mysql_pw < 
> jobs/osm_schema_latest_optimized1.sql
>
> date
>
> I have split up the sql script in two parts - 1st to create table just 
> with primary keys on auto_increment fields, 2nd to alter the populated 
> tables.
>
> Best,
>
> Andi
>
>
> Joachim Zobel schrieb:
>> Am Sonntag, den 30.11.2008, 15:38 +0100 schrieb Andreas Kalsch:
>>  
>>> com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: 
>>> Duplicate entry '1' for key 1
>>>     
>>
>> Did you start with empty tables? This looks like remains from a
>> cancelled previous run.
>>
>> Sincerely,
>> Joachim
>>
>>
>>
>>   
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> dev mailing list
> dev <at> openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
Dominik Spies | 1 Dec 13:34 2008
Picon

Re: [OSM-dev] API 0.6 Test Server

On Wed, Nov 26, 2008 at 8:33 PM, Thomas Wood <grand.edgemaster <at> gmail.com> wrote:
> Hi all,
> I have set up a copy of the 0.6 API at
> http://api06.dev.openstreetmap.org/ as a testing server.
> The previous version that was originally at this address was quite
> neglected as the original maintainer had moved onto other projects.
> It currently contains a planet extract of the London area.
>
> I hope to keep it tracking svn closely.
>
> Many thanks to Shaun McDonald, Chris Schmidt and Brett Henderson for
> their help so far.

Hi,

where can I get some username / password combination to test uploading?
The *normal* one does not work for me..

Regards,

Dominik
Shaun McDonald | 1 Dec 13:38 2008
Picon

Re: [OSM-dev] API 0.6 Test Server


On 1 Dec 2008, at 12:34, Dominik Spies wrote:

> On Wed, Nov 26, 2008 at 8:33 PM, Thomas Wood <grand.edgemaster <at> gmail.com 
> > wrote:
>> Hi all,
>> I have set up a copy of the 0.6 API at
>> http://api06.dev.openstreetmap.org/ as a testing server.
>> [..]
>
> Hi,
>
> where can I get some username / password combination to test  
> uploading?
> The *normal* one does not work for me..
>

You will need to create a new one specific to this server. No users  
were transferred from the production server.

Shaun

Attachment (smime.p7s): application/pkcs7-signature, 3287 bytes
_______________________________________________
dev mailing list
dev <at> openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev
Iván Sánchez Ortega | 1 Dec 13:39 2008
Picon

Re: [OSM-dev] API 0.6 Test Server

El Monday 01 December 2008 13:34:42 Dominik Spies escribió:
> where can I get some username / password combination to test uploading?
> The *normal* one does not work for me..

Maybe http://api06.dev.openstreetmap.org/user/new  ? (I haven't tried myself)

--

-- 
Iván Sánchez Ortega <ivan <at> sanchezortega.es>

Un ordenador no es una televisión ni un microondas: es una herramienta 
compleja.
Dominik Spies | 1 Dec 14:21 2008
Picon

Re: [OSM-dev] API 0.6 Test Server

On Wed, Nov 26, 2008 at 8:33 PM, Thomas Wood <grand.edgemaster <at> gmail.com> wrote:
> Hi all,
> I have set up a copy of the 0.6 API at
> http://api06.dev.openstreetmap.org/ as a testing server.
> The previous version that was originally at this address was quite
> neglected as the original maintainer had moved onto other projects.
> It currently contains a planet extract of the London area.
>
> I hope to keep it tracking svn closely.
>
> Many thanks to Shaun McDonald, Chris Schmidt and Brett Henderson for
> their help so far.

I'm not sur if this is the right place to submit such a (possible)
bug, but I don't know where else.

I tried this devapi with JOSM 1097. When I try to add or change a Tag
on a *node*, this doesn't work.
A trcace with wireshark shows, that JOSM creats the changeset
(successfully), than tries to upload and getting a HTTP/1.1 422
Unprocessable Entity in response. With some payload showing an
exception:

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <title>Action Controller: Exception caught</title>
  <style>
    body { background-color: #fff; color: #333; }

    body, p, ol, ul, td {
      font-family: verdana, arial, helvetica, sans-serif;
      font-size:   13px;
      line-height: 18px;
    }

    pre {
      background-color: #eee;
      padding: 10px;
      font-size: 11px;
    }

    a { color: #000; }
    a:visited { color: #666; }
    a:hover { color: #fff; background-color:#000; }
  </style>
</head>
<body>

<h1>
  ActiveRecord::RecordInvalid

    in ChangesetController#upload

</h1>
<pre>Validation failed: Changeset is invalid</pre>

<p><code>RAILS_ROOT: /home/edgemaster/apis/api06</code></p>

<div id="traces">

    <a href="#"
onclick="document.getElementById('Framework-Trace').style.display='none';document.getElementById('Full-Trace').style.display='none';document.getElementById('Application-Trace').style.display='block';;
return false;">Application Trace</a> |

    <a href="#"
onclick="document.getElementById('Application-Trace').style.display='none';document.getElementById('Full-Trace').style.display='none';document.getElementById('Framework-Trace').style.display='block';;
return false;">Framework Trace</a> |

    <a href="#"
onclick="document.getElementById('Application-Trace').style.display='none';document.getElementById('Framework-Trace').style.display='none';document.getElementById('Full-Trace').style.display='block';;
return false;">Full Trace</a>

    <div id="Application-Trace" style="display: block;">
      <pre><code>/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/validations.rb:923:in
`save_without_dirty!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/dirty.rb:83:in
`save_without_transactions!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:110:in
`save!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:79:in
`transaction_without_deadlock_handling'
/home/edgemaster/apis/api06/vendor/plugins/deadlock_retry/lib/deadlock_retry.rb:45:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:98:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:110:in
`save!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:118:in
`rollback_active_record_state!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:110:in
`save!'
/home/edgemaster/apis/api06/app/models/node.rb:130:in `save_with_history!'
/home/edgemaster/apis/api06/app/models/node.rb:127:in `save_with_history!'
/home/edgemaster/apis/api06/app/models/node.rb:199:in `update_from'
/home/edgemaster/apis/api06/lib/diff_reader.rb:129:in `commit'
/home/edgemaster/apis/api06/lib/diff_reader.rb:54:in `with_model'
/home/edgemaster/apis/api06/lib/diff_reader.rb:39:in `with_element'
/home/edgemaster/apis/api06/lib/diff_reader.rb:50:in `with_model'
/home/edgemaster/apis/api06/lib/diff_reader.rb:120:in `commit'
/home/edgemaster/apis/api06/lib/diff_reader.rb:39:in `with_element'
/home/edgemaster/apis/api06/lib/diff_reader.rb:86:in `commit'
/home/edgemaster/apis/api06/app/controllers/changeset_controller.rb:144:in
`upload'
/home/edgemaster/apis/api06/app/controllers/changeset_controller.rb:143:in
`upload'</code></pre>
    </div>

    <div id="Framework-Trace" style="display: none;">
      <pre><code>/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/validations.rb:923:in
`save_without_dirty!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/dirty.rb:83:in
`save_without_transactions!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:110:in
`save!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:79:in
`transaction_without_deadlock_handling'
/home/edgemaster/apis/api06/vendor/plugins/deadlock_retry/lib/deadlock_retry.rb:45:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:98:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:110:in
`save!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:118:in
`rollback_active_record_state!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:110:in
`save!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:79:in
`transaction_without_deadlock_handling'
/home/edgemaster/apis/api06/vendor/plugins/deadlock_retry/lib/deadlock_retry.rb:45:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:79:in
`transaction_without_deadlock_handling'
/home/edgemaster/apis/api06/vendor/plugins/deadlock_retry/lib/deadlock_retry.rb:45:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:1166:in
`send'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:1166:in
`perform_action_without_filters'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/filters.rb:579:in
`call_filters'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/filters.rb:572:in
`perform_action_without_benchmark'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/benchmarking.rb:68:in
`perform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/benchmarking.rb:68:in
`perform_action_without_rescue'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/rescue.rb:201:in
`perform_action_without_caching'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/caching/sql_cache.rb:13:in
`passenger_orig_perform_action'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in
`cache'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/query_cache.rb:8:in
`cache'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/caching/sql_cache.rb:12:in
`passenger_orig_perform_action'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/request_handler.rb:53:in
`perform_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:529:in
`send'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:529:in
`process_without_filters'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/filters.rb:568:in
`process_without_session_management_support'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/session_management.rb:130:in
`process'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:389:in
`process'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:149:in
`handle_request'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:107:in
`dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:104:in
`synchronize'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:104:in
`dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:120:in
`dispatch_cgi'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:35:in
`dispatch'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/request_handler.rb:38:in
`process_request'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_request_handler.rb:163:in
`main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:307:in
`start_request_handler'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:276:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:165:in
`safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:163:in `fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:163:in
`safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:274:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:165:in
`safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:163:in `fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:163:in
`safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:273:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:168:in
`start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:135:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:112:in
`fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:112:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:177:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/framework_spawner.rb:270:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/framework_spawner.rb:263:in
`synchronize'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/framework_spawner.rb:263:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:168:in
`start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:135:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:112:in
`fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:112:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/framework_spawner.rb:87:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:218:in
`spawn_rails_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:213:in
`synchronize'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:213:in
`spawn_rails_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:122:in
`spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:247:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:168:in
`start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/bin/passenger-spawn-server:46</code></pre>
    </div>

    <div id="Full-Trace" style="display: none;">
      <pre><code>/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/validations.rb:923:in
`save_without_dirty!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/dirty.rb:83:in
`save_without_transactions!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:110:in
`save!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:79:in
`transaction_without_deadlock_handling'
/home/edgemaster/apis/api06/vendor/plugins/deadlock_retry/lib/deadlock_retry.rb:45:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:98:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:110:in
`save!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:118:in
`rollback_active_record_state!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:110:in
`save!'
/home/edgemaster/apis/api06/app/models/node.rb:130:in `save_with_history!'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:79:in
`transaction_without_deadlock_handling'
/home/edgemaster/apis/api06/vendor/plugins/deadlock_retry/lib/deadlock_retry.rb:45:in
`transaction'
/home/edgemaster/apis/api06/app/models/node.rb:127:in `save_with_history!'
/home/edgemaster/apis/api06/app/models/node.rb:199:in `update_from'
/home/edgemaster/apis/api06/lib/diff_reader.rb:129:in `commit'
/home/edgemaster/apis/api06/lib/diff_reader.rb:54:in `with_model'
/home/edgemaster/apis/api06/lib/diff_reader.rb:39:in `with_element'
/home/edgemaster/apis/api06/lib/diff_reader.rb:50:in `with_model'
/home/edgemaster/apis/api06/lib/diff_reader.rb:120:in `commit'
/home/edgemaster/apis/api06/lib/diff_reader.rb:39:in `with_element'
/home/edgemaster/apis/api06/lib/diff_reader.rb:86:in `commit'
/home/edgemaster/apis/api06/app/controllers/changeset_controller.rb:144:in
`upload'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
`transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/transactions.rb:79:in
`transaction_without_deadlock_handling'
/home/edgemaster/apis/api06/vendor/plugins/deadlock_retry/lib/deadlock_retry.rb:45:in
`transaction'
/home/edgemaster/apis/api06/app/controllers/changeset_controller.rb:143:in
`upload'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:1166:in
`send'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:1166:in
`perform_action_without_filters'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/filters.rb:579:in
`call_filters'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/filters.rb:572:in
`perform_action_without_benchmark'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/benchmarking.rb:68:in
`perform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/benchmarking.rb:68:in
`perform_action_without_rescue'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/rescue.rb:201:in
`perform_action_without_caching'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/caching/sql_cache.rb:13:in
`passenger_orig_perform_action'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in
`cache'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.1.2/lib/active_record/query_cache.rb:8:in
`cache'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/caching/sql_cache.rb:12:in
`passenger_orig_perform_action'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/request_handler.rb:53:in
`perform_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:529:in
`send'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:529:in
`process_without_filters'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/filters.rb:568:in
`process_without_session_management_support'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/session_management.rb:130:in
`process'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/base.rb:389:in
`process'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:149:in
`handle_request'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:107:in
`dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:104:in
`synchronize'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:104:in
`dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:120:in
`dispatch_cgi'
/usr/lib/ruby/gems/1.8/gems/actionpack-2.1.2/lib/action_controller/dispatcher.rb:35:in
`dispatch'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/request_handler.rb:38:in
`process_request'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_request_handler.rb:163:in
`main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:307:in
`start_request_handler'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:276:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:165:in
`safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:163:in `fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:163:in
`safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:274:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:165:in
`safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:163:in `fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/utils.rb:163:in
`safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:273:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:168:in
`start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:135:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:112:in
`fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:112:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/application_spawner.rb:177:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/framework_spawner.rb:270:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/framework_spawner.rb:263:in
`synchronize'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/framework_spawner.rb:263:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:168:in
`start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:135:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:112:in
`fork'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:112:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/railz/framework_spawner.rb:87:in
`start'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:218:in
`spawn_rails_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:213:in
`synchronize'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:213:in
`spawn_rails_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:122:in
`spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/spawn_manager.rb:247:in
`handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:317:in
`main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/lib/passenger/abstract_server.rb:168:in
`start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-2.0.3/bin/passenger-spawn-server:46</code></pre>
    </div>

</div>

<h2 style="margin-top: 30px">Request</h2>
<p><b>Parameters</b>: <pre>{&quot;id&quot;=&gt;&quot;21&quot;,
 &quot;&lt;osmChange version&quot;=&gt;&quot;\&quot;0.6\&quot;
generator=\&quot;JOSM\&quot;&gt;\n&lt;modify version=\&quot;0.6\&quot;
generator=\&quot;JOSM\&quot;&gt;\n  &lt;node id='267824285'
action='modify' timestamp='2008-11-19T11:18:40Z' visible='true'
version='1' changeset='21' lat='51.4996308' lon='0.0041466'&gt;\r\n
&lt;tag k='created_by' v='JOSM' /&gt;\r\n    &lt;tag k='capacity'
v='1000' /&gt;\r\n    &lt;tag k='amenity' v='bicycle_parking'
/&gt;\r\n  &lt;/node&gt;\r\n&lt;/modify&gt;\n&lt;/osmChange&gt;\n&quot;}</pre></p>

<p><a href="#" onclick="document.getElementById('session_dump').style.display='block';
return false;">Show session dump</a></p>
<div id="session_dump" style="display:none"><pre class='debug_dump'>---
flash: !map:ActionController::Flash::FlashHash {}

</pre></div>

<h2 style="margin-top: 30px">Response</h2>
<p><b>Headers</b>: <pre>{&quot;X-Powered-By&quot;=&gt;&quot;Phusion
Passenger (mod_rails/mod_rack) 2.0.3&quot;,
 &quot;cookie&quot;=&gt;[],
 &quot;Cache-Control&quot;=&gt;&quot;no-cache&quot;}</pre></p>

</body>
</html>

After that, JOSM closes successfully the opened changeset, AND after
that, tries also to close the changeset with id 0. which is not
successfull. (404 Not Found)

Regards,

Dominik
Andreas Kalsch | 1 Dec 14:49 2008
Picon
Picon

Re: [OSM-dev] Slow Osmosis

Brett Henderson schrieb:
> Whenever I have seen that error in the past it has been because I have 
> data in the tables already.  Changing table types shouldn't have any 
> effect on duplicate key checks.  It'd be worth double checking to make 
> absolutely sure you have no data in the tables already.
I am very sure. I added an exit ...
>
> Andreas Kalsch wrote:
>> Yes I drop the database completely - part of my shell script:
>>
>> echo 'Create database, create tables ..'
>> mysql -u $mysql_user -p$mysql_pw -e "DROP DATABASE IF EXISTS 
>> $db_name;CREATE DATABASE $db_name DEFAULT CHARACTER SET utf8 COLLATE 
>> utf8_general_ci;"
>>
>> date
>>
>> mysql -u $mysql_user -D $db_name -p$mysql_pw < 
>> jobs/osm_schema_latest_optimized0.sql
... here and checked the database: All tables are existing and empty.
>>
>> echo 'Write to database ..'
>> osmosis/bin/osmosis --read-xml file=$uncompressedFile --write-mysql 
>> host=localhost database=$db_name user=$mysql_user password=$mysql_pw 
>> validateSchemaVersion=no
>>
>> mysql -u $mysql_user -D $db_name -p$mysql_pw < 
>> jobs/osm_schema_latest_optimized1.sql
>>
>> date 
So, probably these constructs (I don't know what thy do), cause trouble:

/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;

(?)

Andi
Brian Quinion | 1 Dec 15:11 2008
Picon

Request for UK address lists for postcode extraction

Hi,

I'm currently doing some work trying to generate postcode location
data for the UK using address lists and address lookup using OSM data
to supplement NPE.  So far it seems to work quite well with the
address lists that I have available to me (and coping quite well with
ambiguous road names) but I'm limited in my data sources and most of
the address data is fairly consistent in both format and quality.

So, before I open the interface to the public, I'd like to test the
code with some lists provided by other people.

Does anyone have, or know of, any address lists that I would be able
to use for this purpose?  Obviously it needs to be license compatible
with OSM (so please no lists generated from royal mail postcode data!)
and ideally I'm after data sets containing at least:

street address (house name / number optional)
town / city
postcode

formatted as CSV or TSV.  I'm specifically not after data containing
the names of individuals.

Has anyone got any suggestions, or is willing to offer any data?  Even
personal address books would be useful for testing...

Cheers,
--
 Brian
Stefan de Konink | 1 Dec 15:18 2008
Picon

Re: [OSM-dev] Request for UK address lists for postcode extraction

Brian Quinion wrote:
> Has anyone got any suggestions, or is willing to offer any data?  Even
> personal address books would be useful for testing...

For the same thing in NL we are using Chambre of Commerce data. Isn't 
that free available in the UK as well?

Stefan

Gmane