Re: Replication stops on ALTER TABLE ; keep on getting "duplicate column names"

2005-08-01 Thread Gleb Paharenko
Hello. Check the structure of `bartran` table on the slave. You master is very old, upgrade to the latest release (4.1.13 or 4.0.25). >Dear All, > >Here's our setup : > >Master : MySQL v4.0.16-max-log > >Slave : MySQL v4.1.10a-max-log > >Everytime I do an ALTER TABLE on the m

Replication stops on ALTER TABLE ; keep on getting "duplicate column names"

2005-07-31 Thread Sinang, Danny
Dear All, Here's our setup : Master : MySQL v4.0.16-max-log Slave : MySQL v4.1.10a-max-log Everytime I do an ALTER TABLE on the master server, I get the following error message on the slave server. 050723 1:51:26 [ERROR] Slave: Error 'Duplicate column name 'TimefileDate'' on query. Defa

Re: notification when replication stops.....

2003-08-15 Thread walt
Tom Roos wrote: > > hi > > every now and then my replication stops. i now about this when i logon 2 the slave > and check the status. > > what is the best procedure i would follow 2 automate a notification message when > replication stops? > > i ryn mys

notification when replication stops.....

2003-08-15 Thread Tom Roos
hi every now and then my replication stops. i now about this when i logon 2 the slave and check the status. what is the best procedure i would follow 2 automate a notification message when replication stops? i ryn mysql 4.0.13 on rh linux tks

Re: Replication stops for no reason...

2003-07-08 Thread Dominicus Donny
- Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 08, 2003 7:58 PM Subject: Re: Replication stops for no reason... > "Jeff McKeon" <[EMAIL PROTECTED]> wrote: > > I've seen one o

Re: Replication stops for no reason...

2003-07-08 Thread Egor Egorov
"Jeff McKeon" <[EMAIL PROTECTED]> wrote: > I've seen one other reference to this exact situation but it didn't have > a resolution. What I've done is created a script that runs every 10 > minutes via cron and checks a value from both databases and if it's not > equal then it issues a "slave stop"

RE: Replication stops for no reason...

2003-07-08 Thread Jeff McKeon
rtin Waite [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 4:37 AM To: Jeff McKeon Cc: MySQL List Subject: RE: Replication stops for no reason... Hi Jeff, We had similar problems caused by replication crossing a firewall with a 5 minute timeout on its access control list. If the replica

RE: Replication stops for no reason...

2003-07-08 Thread Martin Waite
, please re-send it to the sender and delete the original message, > and any copy of it, from your computer system. Thank You.*** > > > > -Original Message- > From: Jeff McKeon > Sent: Monday, July 07, 2003 1:47 PM > To: Mysql List > Subject: Replication stops fo

RE: Replication stops for no reason...

2003-07-07 Thread Jeff McKeon
Monday, July 07, 2003 1:47 PM To: Mysql List Subject: Replication stops for no reason... mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686) I have the following replication setup... DB1 --> DB2 --> DB3 Every often, replication from DB1 to DB2 just stops. There is no error message

Replication stops for no reason...

2003-07-07 Thread Jeff McKeon
mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686) I have the following replication setup... DB1 --> DB2 --> DB3 Every often, replication from DB1 to DB2 just stops. There is no error messages that I can see. I know it's stopped because I have a check that runs every 5 minutes to see a

re: Why Replication Stops ?

2003-04-01 Thread Victoria Reznichenko
On Tuesday 01 April 2003 08:37, hemanth wrote: >Can any body tell me the various reasons why the MySQL replication > stops? Because something is going wrong ;) Check error logs, you can find causes there. -- For technical support contracts, goto https://order.mysql.com/?ref=

Re: Why Replication Stops ?

2003-04-01 Thread Jeremy Zawodny
On Tue, Apr 01, 2003 at 11:07:30AM +0530, hemanth wrote: > Hi there, > >Can any body tell me the various reasons why the MySQL replication >stops? All of them? No, not off the top of my head. If you have a question about a specific instance, I'd be glad to help. Pleas

Why Replication Stops ?

2003-03-31 Thread hemanth
Hi there, Can any body tell me the various reasons why the MySQL replication stops? Thanks in Advance. Regards, HEMANTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why Replication stops ?

2003-03-26 Thread Jeremy Zawodny
On Wed, Mar 26, 2003 at 10:02:52AM +0200, Steve Jackson wrote: > I have only recently been looking into replication with MySQL. > How does it work? Can I do this? > I want our externally hosted web mysql DB to be replicated on our > internally hosted non public domain intranet DB. Is it possible?

RE: Why Replication stops ?

2003-03-26 Thread Steve Jackson
://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 > -Original Message- > From: Jeff Kilbride [mailto:[EMAIL PROTECTED] > Sent: 26. maaliskuuta 2003 9:56 > To: [EMAIL PROTECTED] > Cc: Jeremy Zawodny > Subject: Re: Why Replication stops ? > >

Re: Why Replication stops ?

2003-03-25 Thread Jeff Kilbride
- Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "hemanth" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 11:45 PM Subject: Re: Why Replication stops ? > On Wed, Mar 26, 2003 at 01:00:33PM +0530, hem

Re: Why Replication stops ?

2003-03-25 Thread Jeremy Zawodny
On Wed, Mar 26, 2003 at 01:00:33PM +0530, hemanth wrote: > Hi Jeremy, > > Many Thanks for your support. You're welcome. That's what this list is all about (usually). > May I know about ur participation in this IT industry. Yes, you may. :-) -- Jeremy D. Zawodny | Perl, Web, MySQL, Li

Re: Why Replication stops ?

2003-03-25 Thread hemanth
Hi Jeremy, Many Thanks for your support. May I know about ur participation in this IT industry. Regards, HEMANTH On Wed, 2003-03-26 at 12:24, Jeremy Zawodny wrote: > On Wed, Mar 26, 2003 at 11:49:01AM +0530, hemanth wrote: > > Hi there, > > > > I am using MySQL 3.23.41 datab

Re: Why Replication stops ?

2003-03-25 Thread Fred van Engen
Hi, On Wed, Mar 26, 2003 at 11:49:01AM +0530, hemanth wrote: > I am using MySQL 3.23.41 database in 2 Systems. > Getting replication done in MySQL is really cool. > > But I often face MySQL replication issue. > Replication is getting stopped. > > kindly let me know what could be the re

Re: Why Replication stops ?

2003-03-25 Thread Jeremy Zawodny
On Wed, Mar 26, 2003 at 11:49:01AM +0530, hemanth wrote: > Hi there, > > I am using MySQL 3.23.41 database in 2 Systems. > Getting replication done in MySQL is really cool. > > But I often face MySQL replication issue. > Replication is getting stopped. > > kindly let me know what could

Why Replication stops ?

2003-03-25 Thread hemanth
Hi there, I am using MySQL 3.23.41 database in 2 Systems. Getting replication done in MySQL is really cool. But I often face MySQL replication issue. Replication is getting stopped. kindly let me know what could be the reasons ? And also kindly let me know if there is anyway to autom

replication stops when it shouldn't

2002-03-11 Thread Mike Wexler
like an appropriateerror to ignore. But why is it even worrying about this when the request is to drop 3 temporary tables that are being ignored anyway? >Fix: >Submitter-Id: >Originator:Mike Wexler >Organization: TIAS.COM >MySQL support: extended login support >Synopsis

replication stops

2001-01-28 Thread Matis, Jan
Hallo ... I tried to create simple replication: 2 machines mysql-3.23.32 master - name register slave - nane proxy master configuration: [mysqld] set-variable = max_connections=300 log-bin server-id=1 slave configuration: [mysqld] master-host=register master-user=replicate_user master-password