[opencms-dev] database error

[gleb makarov]

Hello everyone,

After upgrade from 8.0.2 to 8.5 version, we started noticing a problem:
sometimes the following error message appear in the database log (we're
using Postgresql): opencms ERROR:  duplicate key value violates unique
constraint "cms_user_publish_list_pkey" opencms DETAIL:  Key (structure_id,
user_id)=(b2678488-72d3-11e1-8c1e-b31821dcc6bc,
68ef3959-49e6-11e2-9f1c-ab3ff7989614) already exists. opencms STATEMENT:
INSERT INTO CMS_USER_PUBLISH_LIST VALUES ($1, $2, $3)

Also we noticed that value of the field CMS_USER_PUBLISH_LIST.STRUCTURE_ID
actually corresponds to USER_ID (we were able to find corresponding record
in CMS_USERS table) and vice versa: CMS_USER_PUBLISH_LIST.USER_ID have
corresponding records in the CMS_ONLINE_STRUCTURE and CMS_OFFLINE_STRUCTURE
tables.

The problem is not very serious, everything else works fine.
OpenCMS version: 8.5
Postgresql version: 9.1.6

Have someone faced this problem too?

-- 
Best regards,
Gleb Makarov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20121226/613e2faa/attachment.htm>