MySQL Forums
Forum List  »  Replication

Slave_IO_Running = NO
Posted by: Edwin Valencia
Date: March 29, 2005 07:27AM

Hi.

I have formed the reply of mysql, and this one working partly well.

I have some problems and I believe it is for the following :

- The "MASTER" change the file BINLOG "binlog.001" to "binlog.002".
- The "SLAVE" NOT change the file BINLOG "binlog.001".
- The "SLAVE" NOT exec the new SQL "update, select, insert, delete".

I use the InnoDB tables.

In the master every second there is an update in all tables, I only
reply some tables of DB.

My conf. in the MASTER (SO = MSW) :
--
[client]
port=3306

[mysqld]
log-bin
server-id=1
port=3306
basedir="C:/Archivos de programa/MySQL/MySQL Server 4.1/"
datadir="C:/Archivos de programa/MySQL/MySQL Server 4.1/Data/"
default-character-set=latin1
default-storage-engine=INNODB
max_connections=126
query_cache_size=8M
table_cache=256
tmp_table_size=7M
thread_cache=8

myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=8M
key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=232K
sort_buffer_size=174K

innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=8M
innodb_log_file_size=10M
innodb_thread_concurrency=8
--

My conf. in the SLAVE (SO = GNU/Linux):
--
[mysqld]
server-id=2
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
master-host=xxx.xxx.xxx.xxx
master-user=user
master-password=pass
replicate-do-table=db.r000
replicate-do-table=db.r001
slave-skip-errors=all
master-connect-retry=1
log
log-warnings=2

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
--

Logs in the "SLAVE"
--
- Error reading packet from server: Client requested master to start
replication from impossible position (server_errno=1236)
- Got fatal error 1236: 'Client requested master to start replication
from impossible position' from master when reading data from binary
log
- Slave I/O thread exiting, read up to log 'slave-bin.000001',
position 15240949
--

Bash "SLAVE"
--
$perror 12
Error code 12: Cannot allocate memory
$ perror 36
Error code 36: File name too long
--

Any idea?

---
Thank's for the attentioin lent...

Options: ReplyQuote


Subject
Views
Written By
Posted
Slave_IO_Running = NO
31058
March 29, 2005 07:27AM
14721
March 30, 2005 12:32AM
92675
March 30, 2005 06:38AM
30668
April 01, 2005 01:35AM
20176
April 01, 2005 03:21AM
16811
April 01, 2005 09:31PM
26203
April 18, 2006 12:07AM
19432
April 21, 2006 07:18PM
13661
June 14, 2006 03:04PM
11820
January 08, 2008 03:50PM
11430
January 08, 2008 04:47PM
11812
March 08, 2008 07:40PM
10551
March 09, 2008 07:59AM
11114
December 15, 2008 11:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.