On Sat, Nov 14, 2009 at 5:50 AM, Maarten Deen <[email protected]> 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
_______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
