I get this error while trying to update from 1.6 to 1.7 through drush.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '727566' for key '                               PRIMARY': INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, ti                               mestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder                               _3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_inser                               t_placeholder_8, :db_insert_placeholder_9); Array
(
    [:db_insert_placeholder_0] => 0
    [:db_insert_placeholder_1] => boost
    [:db_insert_placeholder_2] => Flushed all files (%count) from static page cache.
    [:db_insert_placeholder_3] => a:1:{s:6:"%count";b:0;}
    [:db_insert_placeholder_4] => 5
    [:db_insert_placeholder_5] =>
    [:db_insert_placeholder_6] => http://default/index.php
    [:db_insert_placeholder_7] =>
    [:db_insert_placeholder_8] => 127.0.0.1
    [:db_insert_placeholder_9] => 1438761017
)
 in dblog_watchdog() (line 160 of /home/iverons0/public_html/modules/dblog/dblog.module).

Comments

CPJS created an issue. See original summary.

DamienMcKenna’s picture

There were no database updates between the 1.6 and 1.7 releases? Are you sure it was 1.6 you were running before you updated?

heykarthikwithu’s picture

Their were no database update from 1.6 to 1.7.

$ sudo drush pm-update
Checking available update data 
Checked available update data for Metatag.
Checked available update data for Token.   
Checked available update data for 2 projects
Update information last refreshed: Wed, 08/05/2015 - 12:58

Update status information on all installed and enabled Drupal projects:
Name          Installed  Proposed  Status                                             
Drupal         7.38        7.38       Up to date                                         
Chaos tools 7.x-1.7     7.x-1.7  Up to date                                         
Metatag      7.x-1.6     7.x-1.7   Update available                                   
Token           7.x-1.6    7.x-1.6  Up to date                                         
Code updates will be made to the following projects: Metatag [metatag-7.x-1.7]

Do you really want to continue with the update process? (y/n): y

Project metatag was updated successfully. Installed version is now 7.x-1.7.
No database updates required                                               
Finished performing updates.
DamienMcKenna’s picture

Title: Error updating » Error updating to 1.7
Version: 7.x-1.6 » 7.x-1.7
Category: Bug report » Support request
Status: Active » Postponed (maintainer needs more info)

Can you please let me know what update script is failing, that way I'll be able to track it down.

DamienMcKenna’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)