Delete User Aborts on Shared Address
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Confirmed
|
Medium
|
Unassigned |
Bug Description
Evergreen 2.0.4
PostgreSQL 9.0 and PostgreSQL 8.4.7
Debian Squeeze and Debian Lenny
When deleting a patron that has an address that is shared by another patron the delete aborts returning {"ilsevent"
Traced the error to the following log entry:
2011-11-01 11:25:19 192.168.80.12 open-ils.cstore: [ERR :9525:oils_
2011-11-01 11:25:19 192.168.80.12 open-ils.cstore: [INFO:9525:
In the example error above the patron's actor.usr_address key of 442945 was shared by another patron resulting in this error. From what I can tell the definition of actor.usr_delete calls the function actor.usr_
Changed in evergreen: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
tags: | added: patron |
Changed in evergreen: | |
assignee: | nobody → Rogan Hamby (rogan-hamby) |
Changed in evergreen: | |
assignee: | Rogan Hamby (rogan-hamby) → nobody |
I would argue that this is an issue of bad data. Patrons should not be sharing address entries as each address has a *single* usr field to identify which patron it belongs to. By having any other patron's record refer to that address the behavior would not be defined in a number of places.