SEO
vBulletin Search Engine Optimization
Error with mysql replication - one specific vbseo table
This is a discussion on Error with mysql replication - one specific vbseo table within the Troubleshooting forums, part of the vBSEO SEO Plugin category; Hi Guys, We are running mySQL slave replication on our servers and our slave breaks connection due to an error ...
| |||||||
Enhancing 80 million pages. | Register | FAQ | Members List | Social Groups | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
11-17-2008, 03:15 AM
| |||
| |||
| Error with mysql replication - one specific vbseo table
Hi Guys, We are running mySQL slave replication on our servers and our slave breaks connection due to an error to one specific table. The query is Error 'Duplicate entry '24954' for key 1' on query. Default database: 'sitename_vb'. Query: 'INSERT INTO vb3_vbseo_linkback (t_time, t_src_url, t_dest_url, t_type, t_postid, t_postcount, t_threadid, t_page, t_title, t_text, t_approve, t_incoming, t_wait) It consistently breaks every minute. We then have to ignore the query and then start the replication again. Is there a way around this? This is urgent since we now have had to shut down the slave .. any leads will be appreciated. Thanks       |
|
#2
11-17-2008, 07:25 AM
| ||||
| ||||
|
Please check if you have more than one record in master db with primary key (t_id) equal to 24945 for some reason. If that's the case, you should keep only one of them.
__________________ Oleg Ignatiuk / Crawlability Inc. Support Team Launches New DeskPro Powered Tool Enhanced Support at Your Service vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
 |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linkback Table Error from MySQL | GlitterKill | Bug Reporting | 2 | 07-01-2008 07:02 PM |
| MySQL error | debug | Troubleshooting | 1 | 05-21-2008 11:18 PM |
| mysql error | Slingblade61 | Troubleshooting | 13 | 03-09-2008 06:22 AM |
| Blog table error | Banana Man | Troubleshooting | 3 | 02-19-2008 09:20 AM |
| MySQL error: mailqueue | rj2 | Troubleshooting | 1 | 03-04-2006 06:27 AM |
All times are GMT -4. The time now is 03:09 AM.
