[osmosis-dev] Osmosis error on constraint nodes_ibfk_1

[Brett Henderson]

On Sat, Nov 14, 2009 at 5:50 AM, Maarten Deen <mdeen at xs4all.nl> wrote:

> I'm using osmosis 0.31.2 to insert some data (from XAPI) in a mysql
> database and
> I get the error
> Cannot add or update a child row: a foreign key constraint fails
> (`osm06/nodes`,
> CONSTRAINT `nodes_ibfk_1` FOREIGN KEY (`changeset_id`) REFERENCES
> `changesets`
> (`id`))
>
> I'm trying to load two osm files (which I've merged and sorted in the
> process).
> If I read the error correct, it is trying to insert a node with a
> changeset_id
> that does not occur in the changesets table.
>
> What could be the problem here and how can I correct it?
>

Sorry for slow reply.  Off the top of my head I don't know what could cause
this.  Your analysis sounds about right.

Are you able to provide a small test OSM file to reproduce the problem, and
the full command line you are using?

Brett
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20091120/6931f477/attachment.html>