[osmosis-dev] Osmosis error on constraint nodes_ibfk_1

[Maarten Deen]

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?

Maarten