#1  
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,
created)
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
  #2  
Old 12th February 2012, 13:00
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
 
Default

Quote:
Originally Posted by deeaspark View Post
My question: when i run a "create table" statement on one of the databases, is that table also created on the other table ?
Yes, the database is alsos created in the other database.

Quote:
Originally Posted by deeaspark View Post
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,
created)
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
You have a duplicate entry somewhere. Please check your database.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
feeninuoumn (17th December 2013)
Reply

Bookmarks

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 08:00.


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