Hello,
I saw this similar post (while searching for my particular error) in Drupal and Drigg issues:

http://drupal.org/node/366402

Merc, who supports the Drigg module(s), said this:

You need to check the auto-increment value of your drigg_node table. For some reason, the auto-increment is set to 30, but you already have that primary key. Did you run the pligg importer? That could cause it...

and that this particular issue needed a "reset of the auto increment table in mysql"

My particular PHP error is identical to the one in the support ticket in the URL above:

Duplicate entry 'http://www.musicloversgroup.com/franz-ferdinand-no-you-girls-vid' for key 3 query: INSERT INTO drigg_node (dnid, promoted_on,killed,url, title_url, safe_section, content_type,trackback_ping_url, trackback_ping_successful) VALUES (82151, 1237213791, 0, 'http://www.musicloversgroup.com/franz-ferdinand-no-you-girls-video-and-l..., 'Franz-Ferdinand-No-You-Girls-Video-and-Lyrics-R19937', 'Entertainment', 'text/html; charset=UTF-8', '', 1) in /home/bgilley/public_html/includes/database.mysql.inc on line 172.

I get hundreds of these PHP errors back to back in Watchdog which is why, I think, the VPS hosting is sending emails saying they've suspended the account for 15 minutes, i.e: "The cause for suspension its due to excessive I/O hard drive utilization, mostly by excessive writes, which slows down the overall performance of the VPS box"

So, I'm wondering if resetting the auto increment table for drigg_node will work? If so, how would one go about doing this? Further, how would one prevent auto-increment tables from getting out of whack in the future? We delete dozens of Drigg submissions each day due to spam, so I'm thinking auto-increment issues would happen again and again, right?

Thanks for any help!