View Issue Details

IDProjectCategoryView StatusLast Update
0000760savapage-coreLDAPpublic2017-07-14 13:29
ReporterrijkrAssigned Torijkr 
Status closedResolutionfixed 
Product Version0.9.11 
Target Version0.9.12Fixed in Version0.9.12 
Summary0000760: Prevent creation of duplicate users at synchronization
DescriptionIST: The user set from the database is compared with the user set from the synchronization source in a "balanced line" batch process. Both sets are sorted by user id: database users ordered by SQL and source users by a Java SortedSet (lexicographical order). If the SQL "order by" does not sort lexicographical, the balanced line breaks, leading to the creation of duplicate users. Sorting order typically breaks on diacritical characters. For example: when the lexicographical order "guy, günther" is SQL ordered like "günther, guy".
SOLL: Convert the SQL ordered result into a Java SortedSet before entering the synchronization process.
TagsNo tags attached.


related to 0000696 closedrijkr Auto-correct inconsistency when logically deleting user 



2016-12-14 12:59

administrator   ~0000100

Duplicate users can be identified with:
./savapage-cmd --list-users | sort | uniq --count | grep -v "^ 1" | sort

Issue History

Date Modified Username Field Change
2016-12-14 12:46 rijkr New Issue
2016-12-14 12:46 rijkr Status new => assigned
2016-12-14 12:46 rijkr Assigned To => rijkr
2016-12-14 12:54 rijkr Status assigned => resolved
2016-12-14 12:54 rijkr Resolution open => fixed
2016-12-14 12:54 rijkr Fixed in Version => 0.9.12
2016-12-14 12:55 rijkr Description Updated View Revisions
2016-12-14 12:59 rijkr Note Added: 0000100
2016-12-15 12:45 rijkr Relationship added related to 0000696
2017-07-14 13:29 rijkr Status resolved => closed