Bug #1192
ERROR: duplicate key value violates unique constraint "buffer_userid_key"
0%
Description
I get the following error in my server logs about once or twice a month. I can provide additional errors or surrounding context if needed.
2012-11-12 12:08:15 Error:                   last Query: UPDATE bufferSET buffername = :buffername, buffercnam
e = :buffercnameWHERE userid = :userid AND bufferid = :bufferid  
2012-11-12 12:08:15 Error:               executed Query: UPDATE bufferSET buffername = ?, buffercname = ?WHERE
 userid = ? AND bufferid = ?  
2012-11-12 12:08:15 Error:                 bound Values: <removed>
2012-11-12 12:08:15 Error:                 Error Number: -1  
2012-11-12 12:08:15 Error:                Error Message: ERROR:  duplicate key value violates unique constrain
t "buffer_userid_key"QPSQL: Unable to create query  
2012-11-12 12:08:15 Error:               Driver Message: QPSQL: Unable to create query  
2012-11-12 12:08:15 Error:                   DB Message: ERROR:  duplicate key value violates unique constraint "buffer_userid_key"