Still no solution on this
anybody have any ideas?
It's not network, or hard drive, it's got to be some type of bug in my
config files, attached in original email
The master is on 4.0.20a and the slave is on 4.0.20a
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Anybody else have any ideas?
I cant keep the slave up
only thing I have not tried is upgrading to 4.0.20, however, nothing
changed to cause this problem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I reset the master, flush logs, reset master, show master status..
shows FINANCE-bin.186 at position 79
so I started the slave
CHANGE MASTER TO
MASTER_HOST='192.168.1.168',
MASTER_USER='repl',
MASTER_PASSWORD='Daredevil22',
MASTER_LOG_FILE='FINANCE-bin.186',
MASTER_LOG_POS=79;
start slave;
and I
More info..
I dont see anythign wrong with the binlog the slave has
E:\mysql\datamysqlbinlog databasebackup-relay-bin.001
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
# at 4
#691231 19:00:00 server id 1 log_pos 0 Rotate to
FINANCE-bin.186 pos:79
# at 46
#691231 19:00:00 server
Have you considered that a proxy server may be in the way. I have been
watching this thread but I can't remember if you said anything about your
network connectivity (sorry!). I have seen several programs make what they
thought was a connection then fail because they don't know they are
[EMAIL PROTECTED] wrote:
Have you considered that a proxy server may be in the way. I have been
watching this thread but I can't remember if you said anything about
your network connectivity (sorry!). I have seen several programs make
what they thought was a connection then fail because they
I cant keep the slave up for more than 10 minutes
constantly getting these errors
040812 10:32:25 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040812 10:32:25 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when
Can you reset the slave to read the next event its relay log? If this is not
possible, is refreshing the data from the master a viable option?
-Original Message-
From: matt ryan
To: [EMAIL PROTECTED]
Sent: 8/12/04 10:22 AM
Subject: Help, slave wont stay running!
I cant keep the slave up
Victor Pendleton wrote:
Can you reset the slave to read the next event its relay log? If this is not
possible, is refreshing the data from the master a viable option?
I can start slave, and it runs a little while, then stops again.
I can refresh the data from the master, iv'e done it 25 times
El Jueves, 12 de Agosto de 2004 09:22, matt ryan escribió:
I cant keep the slave up for more than 10 minutes
constantly getting these errors
040812 10:32:25 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040812 10:32:25 Got fatal error 1236:
I deleted every table off the slave, and reloaded them, I do this twice
a week because it wont replicate
The master server has a check optimize every sunday
I had a similar situation one week ago. Found one of the tables (MyISAM) had a
corrupt index. After fixing it, everything was fine again.
Check it out
mysql start slave;
Query OK, 0 rows affected (0.00 sec)
mysql start slave;
ERROR 1198: This operation cannot be performed with a running slave, run
SLAVE S
TOP first
mysql start slave;
ERROR 1198: This operation cannot be performed with a running slave, run
SLAVE S
TOP first
mysql
12 matches
Mail list logo