Duplicate entry 'conformist' for key 1 query: INSERT INTO search_total and many similair errors

Posted by kmillecam on September 20, 2006 at 3:31pm

Issue Summary

A few users are getting this error in their logs (see attached) when Poorman's cron is installed.

More details can be found here: http://drupal.org/node/69915

Thanks for any help or guidance you can provide.

Kevin

Attachment	Size	Status	Test result	Operations
watchdog.gif	19.71 KB	Ignored: Check issue status.	None	None

Posted by fgm on January 6, 2007 at 10:19am

Status:

active

» postponed (maintainer needs more info)

This looks like search.module trying to perform several updates at once. Things to make sure of:

are you running with the drupal prerequisites: php version, mysql/pgsql version ? See http://drupal.org/requirements for details
does your host enable table locks ?
does the problem still occur with 4.7.5, which is today's current version ?
are you sure you didn't set poorman's cron to run too often (like 0 or 1 minute interval) ?

Posted by wwwoliondorcom on September 13, 2008 at 10:24pm

Hi,

I got this problem and wonder if you have found a solution ?

Thanks for help.

Posted by fgm on September 14, 2008 at 8:35am

Can you answer the questions I asked to the initial poster regarding your own site ?

Posted by gpk on November 20, 2008 at 11:47am

This error is probably caused by multiple instances of cron running concurrently. See for example #43511: Race Condition in the code..

Posted by Dave Reid on April 20, 2009 at 5:43pm

Status:

postponed (maintainer needs more info)

» closed (duplicate)

Yes, this would be caused by multiple instances running. Marking as a duplicate.