Re: Replication problem -solved

2014-08-30 Thread william drescher
On 8/30/2014 12:53 PM, Jose Julian Buda wrote: On 30/08/14 12:56, william drescher wrote: Thanks for pointing out the importance of the "last error" I resynced the slave to the master, reset the master position, and restarted the slave. Now all works fine and I am much better equipped next t

Re: Replication problem -solved

2014-08-30 Thread Jose Julian Buda
On 30/08/14 12:56, william drescher wrote: Thanks for pointing out the importance of the "last error" I resynced the slave to the master, reset the master position, and restarted the slave. Now all works fine and I am much better equipped next time to debug the loss of the link. When is the

Re: Replication problem -solved

2014-08-30 Thread william drescher
Thanks for pointing out the importance of the "last error" I resynced the slave to the master, reset the master position, and restarted the slave. Now all works fine and I am much better equipped next time to debug the loss of the link. When is the Last Error data deleted from the show slav

Re: Replication problem

2014-08-30 Thread william drescher
On 8/29/2014 7:40 PM, Suresh Kuna wrote: You can paste the show slave status\G here for us to review and on Master, show global variables like 'log-bin%'; show master status ( 3 to 4 times continuously ) mysql> show global variables like 'log_bin%'; +-+---+

Re: Replication problem

2014-08-30 Thread Jose Julian Buda
On 30/08/14 09:39, william drescher wrote: On 8/29/2014 7:40 PM, Suresh Kuna wrote: You can paste the show slave status\G here for us to review and on Master, show global variables like 'log-bin%'; show master status ( 3 to 4 times continuously ) Master: +--+--+--

Re: Replication problem

2014-08-30 Thread wagnerbianchi.com
Based on the SHOW SLAVE STATUS output you've sent us, I'd suggest that you check what the application is doing, understand *why* the application is violating the PK of the table information_server.audit, repair the possible application problem and the, reconfigure the replication. It seems that th

Re: Replication problem

2014-08-30 Thread william drescher
On 8/29/2014 7:40 PM, Suresh Kuna wrote: You can paste the show slave status\G here for us to review and on Master, show global variables like 'log-bin%'; show master status ( 3 to 4 times continuously ) global var, below +--+--+--+--+ | File

Re: Replication problem

2014-08-30 Thread Johnny Withers
There's a duplicate key on the audit table, 18699. Delete it and restart slave (start slave). Check slave status again, might be more rows in there duplicated. You might want to compare the row to master to ensure it's a duplicate before deleting from slave. On Aug 30, 2014 7:52 AM, "william dre

Re: Replication problem

2014-08-30 Thread william drescher
On 8/29/2014 7:40 PM, Suresh Kuna wrote: You can paste the show slave status\G here for us to review and on Master, show global variables like 'log-bin%'; show master status ( 3 to 4 times continuously ) after a more complex transaction; +--+--+--+---

Re: Replication problem

2014-08-30 Thread william drescher
On 8/29/2014 5:11 PM, wagnerbianchi.com wrote: Hello guys, some points to check here: 1-) Is the master server configured with sync_binlog=1 ? It was not, I reconfigured and restarted mysql and... 2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading events from master,

Re: Replication problem

2014-08-30 Thread william drescher
On 8/29/2014 7:40 PM, Suresh Kuna wrote: You can paste the show slave status\G here for us to review and on Master, show global variables like 'log-bin%'; show master status ( 3 to 4 times continuously ) Master: +--+--+--+--+ | File

Re: Replication problem

2014-08-29 Thread Suresh Kuna
You can paste the show slave status\G here for us to review and on Master, show global variables like 'log-bin%'; show master status ( 3 to 4 times continuously ) On Fri, Aug 29, 2014 at 5:11 PM, wagnerbianchi.com wrote: > Hello guys, some points to check here: > > 1-) Is the master server con

Re: Replication problem

2014-08-29 Thread wagnerbianchi.com
Hello guys, some points to check here: 1-) Is the master server configured with sync_binlog=1 ? 2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading events from master, is the Exec_Master_Log_Pos incrementing or not? 3-) Why are you reconfiguring all the replication just bec

Re: Replication problem

2014-08-29 Thread Andrew Moore
Whilst there are a few possibilities, check on the master that your binary logs are being written to. Another possible reason could be filtering. On 29 Aug 2014 21:36, "william drescher" wrote: > > Replication novice > > I have a master server at the office and a replication server at home. > Thi

Replication problem

2014-08-29 Thread william drescher
Replication novice I have a master server at the office and a replication server at home. This setup has been working for a couple of years. Occasionally the replication server gets out of sync (usually following a internet problem and the vpn going down.) I just stop the slave, make sure th

Re: replication problem

2012-12-05 Thread Shawn Green
On 12/3/2012 7:24 AM, Trimurthy wrote: hi list, i am trying to set up replication but i couldn't complete because of the following error Could not find first log file name in binary log index file can any one please help me. ... snipped ... This one should have been easy for the list

Re: replication problem

2012-12-04 Thread divesh kamra
y are the binlogs in? > > > > -Original Message- > > From: Michael Dykman [mailto:mdyk...@gmail.com] > > Sent: Monday, December 03, 2012 8:53 AM > > To: trimur...@tulassi.com > > Cc: mysql@lists.mysql.com > > Subject: Re: replication problem >

RE: replication problem

2012-12-03 Thread Rick James
SHOW SLAVE STATUS\G SHOW MASTER STATUS; What directory are the binlogs in? > -Original Message- > From: Michael Dykman [mailto:mdyk...@gmail.com] > Sent: Monday, December 03, 2012 8:53 AM > To: trimur...@tulassi.com > Cc: mysql@lists.mysql.com > Subject: Re: r

Re: replication problem

2012-12-03 Thread Michael Dykman
Trimurthy, you will have to describe the method you are using to setup replication. The error message seems plain but an observer could not reasonably guess what caused it without more information. - michael dykman On Mon, Dec 3, 2012 at 7:24 AM, Trimurthy wrote: > hi list, i am tr

RE: Crazy replication problem

2009-07-10 Thread Gary Smith
> -Original Message- > From: Gary Smith > Sent: Friday, July 10, 2009 5:26 PM > To: Gary Smith; mysql@lists.mysql.com > Subject: RE: Crazy replication problem > > One quick follow up note: > > In the top of the big script, I'm doing: > > CREATE

RE: Crazy replication problem

2009-07-10 Thread Gary Smith
specified, even though the tables are qualified. Can anyone confirm this? Gary From: Gary Smith [g...@primeexalia.com] Sent: Friday, July 10, 2009 5:12 PM To: mysql@lists.mysql.com Subject: Crazy replication problem Here is steps take to get to the probl

Crazy replication problem

2009-07-10 Thread Gary Smith
Here is steps take to get to the problem. Version is 5.1.35 To be on the safe side, I did this prior to executing the scripts. I deleted the mysql directory and the mysql-log directory, recreated them, chowned them, ran mysql_install_db, chowned them again. So, I know at least I'm working wit

Re: replication problem

2009-06-26 Thread Moon's Father
Hi. Can you give me a flow of your master/slave? On Wed, Jun 24, 2009 at 7:45 PM, 赵琦 wrote: > hi all: >I have three mysql database,tow run as master and the other one runs as > slave. > Some tables in the database have an autoincreament field named as 'rowid'. > These > tables have 100

replication problem

2009-06-24 Thread 赵琦
hi all: I have three mysql database,tow run as master and the other one runs as slave. Some tables in the database have an autoincreament field named as 'rowid'. These tables have 100 records on master, but some of these tables on the slave only have thousands of record. The tables on the s

Master-Master Replication Problem

2009-06-19 Thread sangprabv
I have configured 2 MySQL server to do master-master replication. Below is my config: Node A server-id = 1 log_bin = mysql-bin expire_logs_days= 10 max_binlog_size = 100M binlog_do_db= clustertest binlog_do_db= gateway binlog_do_

RE: Replication problem

2007-08-21 Thread Jorge Martínez
: mysql@lists.mysql.com> Subject: Re: Replication problem> > Hi,> > Jorge Martínez wrote:> > We have a windows server running our main database and an IIS server. We also have a linux box with apache/php that uses the same database server.> > > > We have configured a

Re: Replication problem

2007-08-21 Thread Baron Schwartz
Hi, Jorge Martínez wrote: We have a windows server running our main database and an IIS server. We also have a linux box with apache/php that uses the same database server. We have configured a replication from that host to another windows server. Then we verified that not all the queries wer

Replication problem

2007-08-21 Thread Jorge Martínez
We have a windows server running our main database and an IIS server. We also have a linux box with apache/php that uses the same database server. We have configured a replication from that host to another windows server. Then we verified that not all the queries were replicated properly. We f

Re: Replication Problem? - SOLVED

2006-12-13 Thread Ed Pauley II
ia invent --- -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Wednesday, 13 December 2006 10:55 AM To: Ed Pauley II Cc: mysql@lists.mysql.com Subject: Re: Replication Probl

Re: Replication Problem? - SOLVED

2006-12-13 Thread Ed Pauley II
ia invent --- -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Wednesday, 13 December 2006 10:55 AM To: Ed Pauley II Cc: mysql@lists.mysql.com Subject: Re: Replication Probl

RE: Replication Problem?

2006-12-12 Thread Logan, David (SST - Adelaide)
ia invent --- -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Wednesday, 13 December 2006 10:55 AM To: Ed Pauley II Cc: mysql@lists.mysql.com Subject: Re: Replication Problem? Ed, this is unfortunately "by design". Personally I don't get why thi

Re: Replication Problem?

2006-12-12 Thread Atle Veka
Ed, this is unfortunately "by design". Personally I don't get why this choice was made... Reference: http://lists.mysql.com/mysql/190869 Regards, Atle FCI, Inc. - Unix Systems Administrator On Tue, 12 Dec 2006, Ed Pauley II wrote: > We recently upgraded to MySQL 5.0. Since upgrading

Replication Problem?

2006-12-12 Thread Ed Pauley II
We recently upgraded to MySQL 5.0. Since upgrading I have noticed that queries of the form "INSERT INTO test.test_table VALUES('test','1')" no longer replicate. If you connect to or change to the test database and then execute "INSERT INTO test_table VALUES('test','1')" the query replicates. Is

replication problem if network delay

2006-08-07 Thread balaraju mandala
Hi All, I need small help from you. I am using Replication, i am using this technique to give live support to Support team. But my Server and Slave are not in LAN. So some times i am getting network delay. Can anybody tell me a good suggestion to over come this. regards, balaraju

RE: Replication Problem

2006-07-24 Thread Brett Harvey
David, that error is only when doing a stop/shutdown. So it doesnt make a lot of sense that would be the problem. Here's the log where I did a stop and start. 060724 20:54:25 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown 060724 20:54:25 [ERROR] Error readin

RE: Replication Problem

2006-07-24 Thread Logan, David (SST - Adelaide)
--- -Original Message- From: Brett Harvey [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 July 2006 10:18 AM To: mysql@lists.mysql.com Subject: RE: Replication Problem David, It is pointing correctly. Plus, I can use a

RE: Replication Problem

2006-07-24 Thread Brett Harvey
David, It is pointing correctly. Plus, I can use a mysql browser and 3rd party tools on the slave server and read the databases/tables properly. I've tried stopping and restarting. I've rebooted... I'm baffled too, obviously. lol Thanks! Brett I am absolutely baffled as to how the

RE: Replication Problem

2006-07-24 Thread Logan, David (SST - Adelaide)
AM To: mysql@lists.mysql.com Subject: RE: Replication Problem David, Thanks for attempting to help. When I look at my show slave status, its updating. When I look at the FMSbuilding-relay-bin, its updating! It has the information that's taken place on the master server. I can see information i

RE: Replication Problem

2006-07-24 Thread Brett Harvey
David, Thanks for attempting to help. When I look at my show slave status, its updating. When I look at the FMSbuilding-relay-bin, its updating! It has the information that's taken place on the master server. I can see information in the FMSbuilding-relay-bin on the slave server that I did

RE: Replication Problem

2006-07-24 Thread Logan, David (SST - Adelaide)
nt --- -Original Message- From: Brett Harvey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 11:06 PM To: mysql@lists.mysql.com Subject: RE: Replication Problem David, I could try and create a table. But I've got

RE: Replication Problem

2006-07-24 Thread Brett Harvey
Australia invent --- -Original Message- From: Brett Harvey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 9:51 PM To: mysql@lists.mysql.com Subject: RE: Repli

RE: Replication Problem

2006-07-24 Thread Logan, David (SST - Adelaide)
CTED] Sent: Monday, 24 July 2006 9:51 PM To: mysql@lists.mysql.com Subject: RE: Replication Problem David, mysql> show master status\g +---+--+--+--+ | File | Position | Binlog_Do_DB | Bi

RE: Replication Problem

2006-07-24 Thread Brett Harvey
David, mysql> show master status\g +---+--+--+--+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +---+--+--+--+ | FMSweb-bin.01 | 903763 | |

RE: Replication Problem

2006-07-24 Thread Logan, David (SST - Adelaide)
nvent --- -Original Message- From: Brett Harvey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 9:28 PM To: mysql@lists.mysql.com Subject: RE: Replication Problem Dave, I tried reset slave as you mentioned

RE: Replication Problem

2006-07-24 Thread Brett Harvey
nt --- -Original Message- From: Brett Harvey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 1:49 PM To: mysql@lists.mysql.com Subject: RE: Replication Problem Hello David, Reset ho

RE: Replication Problem

2006-07-23 Thread Logan, David (SST - Adelaide)
nt --- -Original Message- From: Brett Harvey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 1:49 PM To: mysql@lists.mysql.com Subject: RE: Replication Problem Hello David, Reset how? I did the CHANGE MASTER TO and set it as what was specified from the Show Master command

RE: Replication Problem

2006-07-23 Thread Brett Harvey
mysql@lists.mysql.com Subject: Re: Replication Problem Hi, Thanks for the response. Yes - I have that in my config also. replicate-do-db=FMS Thanks Brett Hi, Did u mention what all databases has to be replicated in ur cnf file as (replicate-do-db=database-name). Thanks & Regards D

Re: Replication Problem

2006-07-23 Thread Dilipkumar
Hi, Check whether u have starting with the correct master position from slave. Thanks & Regards Dilipkumar - Original Message - From: "Brett Harvey" <[EMAIL PROTECTED]> To: Sent: Monday, July 24, 2006 9:36 AM Subject: Re: Replication Problem Hi, Thanks for th

RE: Replication Problem

2006-07-23 Thread Logan, David (SST - Adelaide)
--- -Original Message- From: Brett Harvey [mailto:[EMAIL PROTECTED] Sent: Monday, 24 July 2006 1:36 PM To: mysql@lists.mysql.com Subject: Re: Replication Problem Hi, Thanks for the response. Yes - I have that in my config also. replicate-do-db=FMS Thanks Brett >Hi, >

Re: Replication Problem

2006-07-23 Thread Brett Harvey
Hi, Thanks for the response. Yes - I have that in my config also. replicate-do-db=FMS Thanks Brett Hi, Did u mention what all databases has to be replicated in ur cnf file as (replicate-do-db=database-name). Thanks & Regards Dilipkumar -- -

Re: Replication Problem

2006-07-23 Thread Dilipkumar
Hi, Did u mention what all databases has to be replicated in ur cnf file as (replicate-do-db=database-name). Thanks & Regards Dilipkumar - Original Message - From: "Brett Harvey" <[EMAIL PROTECTED]> To: Sent: Monday, July 24, 2006 8:49 AM Subject: Replicatio

Replication Problem

2006-07-23 Thread Brett Harvey
Well, I successfully setup replication for one server/slave. Now I'm trying to do the same for another set. I've tried both the tar method and load data from master and can't seem to get either to work. Nothing replicates to the slave. I'm running Mysql 5.022. === My error

Re: Replication problem

2005-09-06 Thread Terry Riley
- Original Message - > > However, this does not seem to replicate to the slave, and no error > > shows > > Have you compared the slave's relay logs and master's binary logs? Does > this query present in both logs? The hint was what I needed, Gleb. Spasibo. It turns out that the admi

Re: Replication problem

2005-09-06 Thread Gleb Paharenko
Hello. > However, this does not seem to replicate to the slave, and no error shows Have you compared the slave's relay logs and master's binary logs? Does this query present in both logs? See: http://dev.mysql.com/doc/mysql/en/slave-logs.html http://dev.mysql.com/doc/mysql/en

Replication problem

2005-09-06 Thread Terry Riley
We are running 4.1.13 standard on Linux as a master, and 4.1.14 on NT4 as a slave. Replication seems to work extremely well, except in the following circumstance. On the master server, running a query similar to: insert into zmast.leagueinfo (countieslist, defaultleaguecode, leaguename ...

Re: [Replication] Problem connecting to master

2005-08-31 Thread Jan Roehrich
> If nothing helps, trace files could spill the light on your problem. many thanks for your help. With tracing I found the problem. Like almost every time it was just a typing error :-( Regards Jan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: [Replication] Problem connecting to master

2005-08-30 Thread Gleb Paharenko
Hello. If nothing helps, trace files could spill the light on your problem. See: http://dev.mysql.com/doc/mysql/en/making-trace-files.html Jan Roehrich <[EMAIL PROTECTED]> wrote: >> --skip-networking can be specified as the command line option. Use: >> show variables like 'skip_ne

Re: [Replication] Problem connecting to master

2005-08-29 Thread Nuno Pereira
Jan Roehrich wrote: --skip-networking can be specified as the command line option. Use: show variables like 'skip_networking'; to check if it is enabled. mysql> show variables like 'skip_networking'; +-+---+ | Variable_name | Value | +-+---+ | skip_ne

Re: [Replication] Problem connecting to master

2005-08-29 Thread Jan Roehrich
> --skip-networking can be specified as the command line option. Use: > show variables like 'skip_networking'; > to check if it is enabled. mysql> show variables like 'skip_networking'; +-+---+ | Variable_name | Value | +-+---+ | skip_networking | OFF

Re: [Replication] Problem connecting to master

2005-08-29 Thread Gleb Paharenko
Hello. > Could not see skip-networking anywhere. --skip-networking can be specified as the command line option. Use: show variables like 'skip_networking'; to check if it is enabled. Jan Roehrich <[EMAIL PROTECTED]> wrote: >> Please send your configuration files for master and s

Re: [Replication] Problem connecting to master

2005-08-29 Thread Jan Roehrich
> Please send your configuration files for master and slave. Check that > > you don't have skip-networking in your slave's configuration file. Master: -- [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-bin=bin-log server-id=1 [mysql.server] user=m

Re: [Replication] Problem connecting to master

2005-08-29 Thread Gleb Paharenko
Hello. Please send your configuration files for master and slave. Check that you don't have skip-networking in your slave's configuration file. Jan Roehrich <[EMAIL PROTECTED]> wrote: > I have a strange problem setting up replication. I followed each step of > setting up replication in t

[Replication] Problem connecting to master

2005-08-28 Thread Jan Roehrich
I have a strange problem setting up replication. I followed each step of setting up replication in the mysqld documentation (http://dev.mysql.com/doc/mysql/en/replication-howto.html). But there are some error messages on the salve: 050828 13:22:58 [ERROR] Slave I/O thread: error connecting to mas

Re: Replication problem

2005-06-02 Thread Weicheng Pan
) VALUES ( 'lty0105', '8', 2p); I took your suggestion and have sent a report. And thank you very much. With best regards, Weicheng Pan Jun 3, 2005. - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Thursday, June 02, 2005

Re: Replication problem

2005-06-02 Thread Gleb Paharenko
Hello. I suggest you to check what query was written to the master binary log and then report a bug. Please include all information you've found in the report. "Weicheng Pan" <[EMAIL PROTECTED]> wrote: > Dear Gleb: > The problem has occured again, and I grab some output. > This b

Re: Replication problem

2005-06-01 Thread Weicheng Pan
-relay-bin.60 | grep "( 'lty0105', '8', 2p)" INSERT LOW_PRIORITY INTO `statistics`.`search` ( `userid` , `id` , `func` ) VALUES ( 'lty0105', '8', 2p); [EMAIL PROTECTED] [ /home/mysql ]> With best regards, Weicheng. - Original Message

Re: Replication problem

2005-05-31 Thread Gleb Paharenko
Hi all: > I have replication problem on my FreeBSD 5.4 AMD64 box. > Sometimes replication will stop and throw an error code 1054, > but the query is not the original one in the master. > A query like UPDATE table_a SET col_a = 'abc' where col_b = 234 > the right most ch

Replication problem

2005-05-30 Thread Weicheng Pan
Hi all: I have replication problem on my FreeBSD 5.4 AMD64 box. Sometimes replication will stop and throw an error code 1054, but the query is not the original one in the master. A query like UPDATE table_a SET col_a = 'abc' where col_b = 234 the right most character will become

Re: Replication problem

2005-03-21 Thread Gleb Paharenko
Hello. >Error: 'Unknown MySQL server host > 'server5.domain.com' (1)' errno: 2005 Does the problem remain if you remove the following line from the my.cnf on the server8: skip-networking "Chris Mason" <[EMAIL PROTECTED]> wrote: > I have two servers, server5.mydomain.com a

Replication problem

2005-03-19 Thread Chris Mason
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to replicate one database on server5 to server 8. I did the whole proceedure as recommended in http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set Up Replication I setup the GRANT statement on server5

Replication Problem: I/O Thread exits every night randomly

2004-11-03 Thread Stephan Amann
Hi all We have the following setup: - Master mySQL Server 4.0.11-gamma (sun-solaris2.9-sparc-64bit) - Slave mySQL Server 4.1.7 (sun-solaris2.9-sparc-64bit) Everything worked fine with both servers having the same Version (4.0.11-gamma). As a first step in updating to Rel. 4.1 we migrated the repl

Re: InnoDB backup + replication problem?

2004-10-19 Thread Heikki Tuuri
://www.mysql.com/support/index.html .. From: Don MacAskill ([EMAIL PROTECTED]) Subject: InnoDB backup + replication problem? This is the only article in this thread View: Original Format Newsgroups: mailing.database.myodbc Date: 2004-09-29 09:58:02 PST I've got an interesting (well, I

Re: Replication problem with a cross database query

2004-10-08 Thread Paul Fierro
On 10/06/2004 6:23 PM, Bill Thomason <[EMAIL PROTECTED]> wrote: > I originally posted a query about a problem entitled "Table doesn't > exist on query replication problem..." > > The original title might be a little misleading. The slave replication > is halt

Replication problem with a cross database query

2004-10-06 Thread Bill Thomason
I originally posted a query about a problem entitled "Table doesn't exist on query replication problem..." The original title might be a little misleading. The slave replication is halting on a transaction that contains a query that spans two databases - one that is being rep

Re: Table doesn't exist on query replication problem...

2004-10-06 Thread Bismarck Rojas
Hello, I suggest to you have the same version of mysql in both servers. regards El Miércoles, 6 de Octubre de 2004 13:07, Bill Thomason escribió: > Hi, > > I have a mysql 4.0.21 master and a 4.0.18 slave. > > I am trying to maintain a replication of a DB named masterdb. > > My goal is to have

Table doesn't exist on query replication problem...

2004-10-06 Thread Bill Thomason
Hi, I have a mysql 4.0.21 master and a 4.0.18 slave. I am trying to maintain a replication of a DB named masterdb. My goal is to have multiple slaves with a copy of masterdb. On the master I specified in my.cnf binlog-do-db=masterdb. On the slave I specified replicate-do-db=masterdb in my.cnf.

InnoDB backup + replication problem?

2004-09-29 Thread Don MacAskill
I've got an interesting (well, I think so anyway) problem with my replication. The slave chugs along just fine, then spits out: Query caused different errors on master and slave. Error on master: 'Can't execute the query because you have a conflicting read lock' (1223), Error on slave: 'no erro

RE: Slave replication problem

2004-09-06 Thread Andrew Braithwaite
did you get an answer to your problem yet? If not I may be able to help.. Andrew From: Jeff McKeon [mailto:[EMAIL PROTECTED] Sent: Fri 03/09/2004 15:29 To: [EMAIL PROTECTED] Subject: Slave replication problem Hello all, We had a power outage this morning

Slave replication problem

2004-09-03 Thread Jeff McKeon
Hello all, We had a power outage this morning and before we could shut down our main MySQL server, power to it was lost. Bad UPS battery. Long story. We replicate this server to two others. On one I get the following error... Jeff McKeon IT Manager*** 1. row *

Re: Replication Problem

2004-08-20 Thread Duncan Hill
On Friday 20 August 2004 07:08, [EMAIL PROTECTED] might have typed: > Is replication of database in MySQL is possible. Actually i want to > replicate the changes to the database to different servers located at > different locations. A tiny bit of legwork would have answered it for you. http://dev

Replication Problem

2004-08-20 Thread Smitesh . Damdoo
Hi, All Is replication of database in MySQL is possible. Actually i want to replicate the changes to the database to different servers located at different locations. Please tell me if any suggestions, or available resources for this Replication Topic. From: Smitesh S. Damdoo (Mob. No.) 922

Re: replication problem

2004-08-03 Thread Jeremy Zawodny
On Tue, Aug 03, 2004 at 12:44:05PM +0530, [EMAIL PROTECTED] wrote: > > Hi Friends: > > We are using mysql version 4.0.17 on Linux with a master and a single > slave both running on the same node. > > We have encountered a problem in replication in the following scenario: > > First the slave go

replication problem

2004-08-03 Thread ravi.ramachandra
Hi Friends: We are using mysql version 4.0.17 on Linux with a master and a single slave both running on the same node. We have encountered a problem in replication in the following scenario: First the slave got abnormally terminated while there were some active connections to the master. The m

Re: Replication problem on 3.23.57 & 3.23.58

2004-07-01 Thread Joe Kislo
> somebody here can make sense of it. On the slave I get error messages > like: > > 040630 2:43:52 Slave: reconnected to master > '[EMAIL PROTECTED]:3306',replication resumed in log 'mysql-bin.163' at > position 37919441 > > It does that several times between 2:20am and 4:30am. and every few

Replication problem on 3.23.57 & 3.23.58

2004-07-01 Thread Joe Kislo
We have suddenly run into a replication problem between our master and our slave databases. It had been running without a problem for atleast several months since our last upgrade, and for several years before that. I've tried a number of debugging techniques, and now I'm hopin

replication problem, empty Binlog_do_db ?

2004-05-27 Thread matthew zeier
Running 4.0.20-standard-log on Fedora Core 1 on two boxes. Running with a largely untouched my-huge.cnf - innodb configs uncommented. Followed http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html to setup replication. On the master I see: mysql> show master status; +-+

Re: Replication problem

2004-04-22 Thread Georg Horn
Hi, On Wed, Apr 21, 2004 at 06:35:53PM +0200, Mechain Marc wrote: > Add this in your my.cnf slave file: > > slave-skip-errors = 1062 Ahh, that's what i was looking for. Seems as if i had not read chapter 6 of the documentation thoroughly enough... Thanks, Georg -- MySQL General Mailing List

RE: Replication problem

2004-04-21 Thread Mechain Marc
Add this in your my.cnf slave file: slave-skip-errors = 1062 Marc. -Message d'origine- De : Georg Horn [mailto:[EMAIL PROTECTED] Envoyé : mercredi 21 avril 2004 17:31 À : [EMAIL PROTECTED] Objet : Replication problem Hi, i'm new to this list, but i use mysql for years a

Replication problem

2004-04-21 Thread Georg Horn
Hi, i'm new to this list, but i use mysql for years an are very happy with it. However, today i ran into a problem that i couldn't find a solution for: I set up database replication with a master and one slave, and it works fine so far. I rewrote my application (web based written in php) so that

Re: weird replication problem with master.info being created empty

2004-01-29 Thread Andrew
D]> > Date: Thu, 29 Jan 2004 10:25:24 +0200 > To: [EMAIL PROTECTED] > Subject: Re: weird replication problem with master.info being created empty > > Maybe you should check if the ip address resolved for the > master's url is correct ? > > Also try using CHANGE MA

Re: weird replication problem with master.info being created empty

2004-01-29 Thread Lightware Software
Maybe you should check if the ip address resolved for the master's url is correct ? Also try using CHANGE MASTER TO MASTER_HOST='', MASTER_USER='', MASTER_PASSWORD=''; and then START SLAVE; and see what happens. regards Jurgen > Tried that, but no luck, they get r

Re: weird replication problem with master.info being created empty

2004-01-29 Thread Andrew
f the server changing, but that isn't the case here, the hostname is the same as always (should have added that in the first place). thanks, Andrew > From: "Lightware Software" <[EMAIL PROTECTED]> > Date: Thu, 29 Jan 2004 08:53:48 +0200 > To: [EMAIL PROTECTED] > Subje

Re: weird replication problem with master.info being created empty

2004-01-29 Thread Lightware Software
You need to shutdown mysql, delete the master.info and relay-log.info files and then start mysql again. The reason for this is because if the info files are present then mysql uses them as is and only recreates them from my.ini or my.cnf if absent. This should get your replication going again. re

weird replication problem with master.info being created empty

2004-01-28 Thread Andrew
Hi all, Have a problem, running a master/slave setup which worked until tonight and mysteriously broke with no changes to the setup at all. My server starts up fine, but the master.info and relay-log.info that are created are 0 bytes and empty. In the logfile, I get this: 040128 23:00:29 Error r

Replication Problem

2004-01-06 Thread varun gupta
Hi I understand the concept of master n slave relationship but have certain queries regarding this... 1) In case the master is down i do i configure my system so that a present active slave becomes the master or any other way to tackle this situation.How does the clients know ab

Re: Drop foreign key replication problem

2003-12-03 Thread Heikki Tuuri
base.myodbc Sent: Wednesday, December 03, 2003 6:41 AM Subject: Drop foreign key replication problem > Hi, > > I am running a master and a slave. When I created a foreign key in > master, it looked like this: > CONSTRAINT `0_373` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture` >

Drop foreign key replication problem

2003-12-02 Thread Batara Kesuma
Hi, I am running a master and a slave. When I created a foreign key in master, it looked like this: CONSTRAINT `0_373` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture` (`id`) But on the slave it was like: CONSTRAINT `0_451` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture` (`id`) The pr

Re: Strange replication problem

2003-09-09 Thread Mike Dopheide
I found the problem which I will outline here just in case anyone else runs across it in the future: It appears that a slave will not replicate data from it's own server-id. In my case, a large portion of the binary logs on my slave had originally come from the master, so when the master trie

Strange replication problem

2003-09-08 Thread Mike Dopheide
I have one master and one slave which I am upgrading to 4.0.14 from 4.0.12. To start the upgrade I stopped the slave, took a snapshot of it's data directory, cleared it's binary logs, and switched to the 4.0.14 binaries. I then restarted the slave thread to get it caught up with the master.

Fw: Replication Problem (XP+mysql4.0.14)

2003-08-27 Thread Massimo Petrini
nobody have answer ? For me it is very urgent to kwow when the .15 version will be avalaible . Tks - Original Message - From: "Massimo Petrini" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "I.P." <[EMAIL PROTECTED]> Sent: Friday, August 22, 2003 1:

  1   2   3   >