Database - Postgresql 8.4
In postgres log file I see these errors:

EEST ERROR: duplicate key value violates unique constraint "semaphore_pkey"
EEST STATEMENT:  INSERT INTO semaphore (name, value, expire) VALUES ('locale_cache_bg', '19217212324be725919ac5d7.88212629', 1273439663.63)

2010-05-10 00:13:53 EEST ERROR:  duplicate key value violates unique constraint "cache_pkey"

Installed modules:

Taxonomy
CCK
Date
ImageAPI
ImageField
DME Image
ImageCache
Views
Drupal Markup Engine
Taxonomy Manager
Taxonomy hide
Scheduler
Nice Menus
getID3()
FCKeditor

I attached a part of postgresql.log as pdf

Best regards
Bozho

CommentFileSizeAuthor
postgresql-8.4-main.pdf106.18 KBbozho

Comments

alpapan’s picture

alpapan commented

Hello

Even with Drupal 6.20, I can verify that I have the same issue but I think it is sensitive to the configuration of the postgres server for it doesn't happen to another server of ours

More investigations in progress...

cheers,
alexie

alpapan’s picture

alpapan commented

Nope, it is not the postgres setup. I filed bug report and a patch that fixes the issue to the cache system http://drupal.org/node/1019260 but it may be a deeper database system problem.

steinmb’s picture

steinmb commented

Damien closed (1019260) as, work as designed, and told people to ignore them. If so, perhaps we should close all related issues to this and move on?
#1019260: Postgres cache race condition violates "cache_pkey"

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.