Duplicate tasklist macro items cause SQL duplicate key exception on restore

If you are experiencing problems in restore of your backup data due to SQL duplicate key exceptions, it may be caused by having duplicate items in the tasklists.

There is a bug in the current implementation of the tasklist macro that allows duplicate items to show up in the list if they have trailing spaces. So "apple" and "apple " would be erroneously considered different. When these similar items are marked as complete in Confluence, two entries are inserted into the OS_PROPERTYENTRY table. When these entries are exported to XML however, the trailing spaces are removed, so the second item is actually written to the XML file as a duplicate of the first. When this backup is restored, you will get a SQL duplicate key exception as Confluence tries to re-insert "apple" (without trailing space).