Duplicate key violates unique constraint ... [message #19322] |
Fri, 09 July 2004 19:36 |
Sebastian_T
Messages: 33 Registered: January 2004 Location: Warsaw, Poland
Karma: 0
|
Member |
|
|
Hello, World
some of our users report us such an error:
Warning: pg_query(): Query failed: ERROR: duplicate key violates unique constraint "fud23_thread_view_i_fps" . in /usr/local/apache/htdocs/forum.blizniaki.net/index.php on line 141
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /usr/local/apache/htdocs/forum.blizniaki.net/index.php on line 47
For me it was unable to recreate it. And as our "guru" (technical admin) is for some days out, we can't check logs etc.
What it can be? It shows, when replying in one of subforums...
FUD 2.6.4 stable, on PostgreSQL.
Best wishes,
Sebastian
|
|
|
|
Odp: Re: Duplicate key violates unique constraint ... [message #19327 is a reply to message #19323] |
Sat, 10 July 2004 07:38 |
Sebastian_T
Messages: 33 Registered: January 2004 Location: Warsaw, Poland
Karma: 0
|
Member |
|
|
it started on Monday (unfortunately, on Monday our "guru" went for some days... ), and it continues - last error is from Friday...
Mon Jul 5 17:21:48 GMT 2004 (/usr/local/apache/htdocs/forum.blizniaki.net/index.php:141
/usr/local/apache/htdocs/forum.blizniaki.net/theme/default/post.php:2822
/usr/local/apache/htdocs/forum.blizniaki.net/theme/default/post.php:1662
/usr/local/apache/htdocs/forum.blizniaki.net/theme/default/post.php:3909
/usr/local/apache/htdocs/forum.blizniaki.net/index.php:1183
) : ERROR: duplicate key violates unique constraint "fud23_thread_view_i_fps"
Query: INSERT INTO fud23_thread_view (thread_id,forum_id,page,pos) SELECT thread_id,forum_id,CEIL(pos/40.0),(pos-(CEIL(pos/40.0)-1)*40) FROM fud23_ftvt_1350593311
Server Version:
[Referring Page] http://forum.blizniaki.net/index.php?t=post
[...]
Fri Jul 9 22:41:15 GMT 2004 (/usr/local/apache/htdocs/forum.blizniaki.net/index.php:141
/usr/local/apache/htdocs/forum.blizniaki.net/theme/default/post.php:2822
/usr/local/apache/htdocs/forum.blizniaki.net/theme/default/post.php:1662
/usr/local/apache/htdocs/forum.blizniaki.net/theme/default/post.php:3909
/usr/local/apache/htdocs/forum.blizniaki.net/index.php:1183
) : ERROR: duplicate key violates unique constraint "fud23_thread_view_i_fps"
Query: INSERT INTO fud23_thread_view (thread_id,forum_id,page,pos) SELECT thread_id,forum_id,CEIL(pos/40.0),(pos-(CEIL(pos/40.0)-1)*40) FROM fud23_ftvt_2049700293
Server Version:
[Referring Page] http://forum.blizniaki.net/index.php?t=post&th_id=2348&reply_to=185 76&&start=0
Sebastian
|
|
|
|
Odp: Re: Odp: Re: Duplicate key violates unique constraint ... [message #19340 is a reply to message #19331] |
Sun, 11 July 2004 18:40 |
Sebastian_T
Messages: 33 Registered: January 2004 Location: Warsaw, Poland
Karma: 0
|
Member |
|
|
Done (result below). Nothing changed...
Disabling the forum for the duration of maintenance run
Locking the database for checking
Locked!
Validating category order
Done: Validating category order
Checking if moderator and users table match
OK
Rebuilding moderators
Done: Rebuilding moderators
Checking if all private messages have users
OK
Checking messages against users & threads
2 entries unmatched, deleted
Checking threads against forums
OK
Checking message approvals
Done: Checking message approvals
Checking threads against messages
OK
Checking thread last & first post ids
Done: Checking thread last & first post ids
Checking forum & topic relations
Done: Checking forum & topic relations
Validating Forum Order
Done: Validating Forum Order
Checking thread_exchange
OK
Checking read table against users & threads
413 entries unmatched, deleted
Checking file attachments against messages
19 entries unmatched, deleted
Rebuild attachment cache for regular messages
Done: Rebuild attachment cache for regular messages
Rebuild attachment cache for private messages
Done: Rebuild attachment cache for private messages
Checking message reports
OK
Checking polls against messages
1 entries unmatched, deleted
Checking polls options against polls
6 entries unmatched, deleted
Checking polls votes
OK
Rebuilding poll cache
Done: Rebuilding poll cache
Validating poll activation
Done: Validating poll activation
Checking smilies against disk files
OK
Checking disk files against smilies
OK
Checking topic notification
41 entries unmatched, deleted
Checking forum notification
OK
Checking topic votes against topics
OK
Rebuild topic rating cache
Done: Rebuild topic rating cache
Rebuilding Topic Views
Done: Rebuilding Topic Views
Rebuilding user ranks, message counts & last post ids
Done: Rebuilding user levels, message counts & last post ids Checking buddy list entries OK Checking ignore list entries OK Rebuilding buddy list cache
Done: Rebuilding buddy list cache
Rebuilding ignore list cache
Done: Rebuilding ignore list cache
Rebuilding ip filter cache
Done: Rebuilding ip filter cache
Rebuilding login filter cache
Done: Rebuilding login filter cache
Rebuilding email filter cache
Done: Rebuilding email filter cache
Rebuilding extension filter cache
Done: Rebuilding extension filter cache
Rebuilding custom tags for users
Done Rebuilding custom tags for users
Validating group resources
OK
Done: Validating group resources
Validating group validity
OK
OK
Done: Validating group validity
Validating group members
OK
Done: Validating group members
Validating group/forum relations
Done: Validating group/forum relations
Validating group/forum names
Done: Validating group/forum names (fixed: 0 relations) Validating group/primary user relations
Done: Validating group/primary user relations
Rebuilding group leader cache
Done: Rebuilding group leader cache
Rebuilding group cache
Done: Rebuilding group cache
Validating User/Theme Relations
Done: Validating User/Theme Relations
Rebuilding Forum/Category order cache
Done: Rebuilding Forum/Category order cache
Remove absolete entries inside sessions table
Done: Removing absolete entries inside sessions table
Unlocking database
Database unlocked
Cleaning forum's tmp directory
Done: Cleaning forum's tmp directory
Validate GLOBALS.php
Done: Validate GLOBALS.php
Re-enabling the forum.
DONE
Sebastian
|
|
|
|