Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 11th February 2012, 10:34
deeaspark deeaspark is offline
Junior Member
Join Date: Feb 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error after database sync

it's a master - master replication ....

My question: when i run a "create table" statement on one of the databases, is that table also created on the other table ?
or just the table content (the inserted rows) are in sync ?
and here is the error on one of the masters :

120209 22:50:20 [ERROR] Slave SQL: Error 'Duplicate entry '174' for key 'PRIMARY'' on query. Default database: 'rent'. Query: 'INSERT INTO jobs(title, job_type_id, buyer_id, service_provider_id, price_low, price_high, status_id,
VALUES("Test Polo Shirt 2", 2, 65, 64,
"15.00", "50.00", '1208', now())', Error_code: 1062
120209 22:50:20 [Warning] Slave: Field 'modified' doesn't have a default value Error_code: 1364
120209 22:50:20 [Warning] Slave: Duplicate entry '174' for key 'PRIMARY' Error_code: 1062
120209 22:50:20 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysqld-bin.000001' position 6096

Last edited by deeaspark; 11th February 2012 at 10:46. Reason: forgot to add somthing
Reply With Quote
Sponsored Links


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Horde Groupware Webmail Edition ByteMe Networking Tips/Tricks/Mods 17 20th December 2012 11:12
Amavis/ClamAv problem MattJo. General 7 20th October 2010 18:18
Problems with SpamSnake ClamAV (Sanesecurity Signatures) tmaleshafske HOWTO-Related Questions 0 21st September 2010 02:59
UIDs, GIDs, and Database Naming fatbear Developers' Forum 9 2nd August 2010 16:01
Mail System doesnt work! crichton Installation/Configuration 3 18th September 2007 00:49

All times are GMT +2. The time now is 19:58.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.