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 master
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.
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
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 mysql 4.0.13 on rh linux
tks
: Jeff McKeon
Sent: 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
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 replication stream went idle for 5 minutes, the firewall would
drop
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 and slave
- 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 other reference to this exact situation but it didn't have
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
, 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
messages that I can see
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. Please post the output
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]
://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 ?
- Original Message -
From
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?
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
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 be the
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 reasons
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 database in
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, Linux
- 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, hemanth wrote:
Hi Jeremy,
Many Thanks for your
. 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: submitter ID
Originator:Mike Wexler
Organization: TIAS.COM
MySQL support: extended login support
Synopsis: replication stops when it shouldn't
Severity
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
22 matches
Mail list logo