Download & Extend

SQL Duplicate entry warning from EPublish

Project:E-Publish
Version:6.x-1.0-beta2
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

I used the Quotes module to post a number of nodes simultaneously. The following errors displayed:

user warning: Duplicate entry '155' for key 1 query:
INSERT INTO epublish_abstract (nid, epublish_abstract)
VALUES ('155','First attempt to import a group...')
in ... epublish.module on line 502.

user warning: Duplicate entry '155' for key 1 query:
INSERT INTO event
(nid, event_start, event_end, timezone, start_in_dst, end_in_dst, has_time, has_end_date)
VALUES (155,'2008-06-24 0:28:00','2008-06-24 0:28:00',484, 0, 0, 0, 0)
in ...event.module on line 2288.

This is a heads-up to anyone else who may be using Event and/or Epublish.
I'm starting to wonder if the rapid publishing of several nodes in Quotes is causing some kind of lock contention in MySQL that random nodes are tripping on. Here's a cross-reference back to my report on the Quotes module. Maybe someone else can see a pattern: #274154: SQL errors from other modules on import

We have a fairly new but fully patched v6.2 here (as you can see) with lots of modules in test mode and with E-Publish beta2. I've installed this module but know very little about it yet as I haven't had time to play with it. I'll be happy to alpha test patches.

TIA

Comments

#1

Whoops, I see this is a FAQ. Please close. Thanks.
http://drupal.org/node/69722

#2

Actually, please keep this open for a bit. I'm told "D6 doesn't use the sequences table any more." so that FAQ may not apply. We disabled Event handling for Quotes and even with a small data creation in Quotes the same issue displays for E-Publish. I'm looking into it as time permits.

#3

Status:active» closed (fixed)

I believe this issue is obsolete with the current epublish code. Please reopen if it is not.

nobody click here