From: Matt Amos <zerebubuth@gmail.com>
Date: Sat, 13 Jun 2015 09:59:11 +0000 (+0100)
Subject: Fix bug allowing created elements to reference deleted ones
X-Git-Tag: live~4065
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/cf6a5c17ee15eeee6035b7c99996b411f08cc9c1?hp=cf6a5c17ee15eeee6035b7c99996b411f08cc9c1

Fix bug allowing created elements to reference deleted ones

The bug allows a newly-created element to refer to a deleted one
if the transactions for both overlap. Precisely, the issue is that
the check that an element exists does not prevent a concurrent
transaction from altering that row.

Because "deleting" an element in the OSM database does not remove
the row, we cannot rely on FK constraints to ensure the correct
behaviour. Instead, this fix relies on manually locking referenced
elements.

Note that this "fix" is suboptimal, as it does not allow any
updates to the referenced elements. Updates which do not delete
the row could safely be done, but will be prevented.

Also, it's not clear what the negative performance impact of this
change will be.
---