Re: SHOW SLAVE HOSTS returns nothing ?

[Ion-Mihai Tetcu]

On Mon, 22 Sep 2003 12:25:48 +0300
Victoria Reznichenko [EMAIL PROTECTED] wrote:

 Ion-Mihai Tetcu [EMAIL PROTECTED] wrote:
  
  I had set up replication between 2 4.0.14 servers and everything
  seems to work OK. Except that SHOW SLAVE HOSTS on muster returns
  nothing. What am I missing ?
  
 
 Use report-host option on the slave:
   http://www.mysql.com/doc/en/Replication_Options.html

Tnx. Read the page in aa hurry.


IO


-- 
IOnut
FreeBSD unregistered ;) user

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

log-warning entries questions

[Ion-Mihai Tetcu]

Hi,


buh/var/db/mysql# tail buh.XXX.XX
030919  0:31:00  Slave I/O thread exiting, read up to log 'cm-bin.086', position 
16233275
030919  0:31:00  Error reading relay log event: slave SQL thread was killed
030919 11:08:46  Slave SQL thread initialized, starting replication in log 
'cm-bin.086' at position 16233275, relay log './buh-relay-bin.004' position: 1798782
030919 11:08:46  Slave I/O thread: connected to master '[EMAIL PROTECTED]',  
replication started in log 'cm-bin.086' at position 16233275
030919 11:08:47  Slave: load data infile at position 16309655 in log 'cm-bin.086' 
produced 11 warning(s)
030919 11:08:47  Slave: load data infile at position 16318421 in log 'cm-bin.086' 
produced 4 warning(s)
030919 11:08:47  Slave: load data infile at position 16352824 in log 'cm-bin.086' 
produced 2 warning(s)
030919 11:08:48  Slave: load data infile at position 16414682 in log 'cm-bin.086' 
produced 10 warning(s)
030919 11:08:48  Slave: load data infile at position 16429049 in log 'cm-bin.086' 
produced 6 warning(s)
030919 11:08:48  Slave: load data infile at position 16448729 in log 'cm-bin.086' 
produced 14 warning(s)

 -- Query:
 -- SHOW BINLOG EVENTS IN 'cm-bin.086'  FROM  16309655 limit 4
 --
'Pos','Event_type','Orig_log_pos','Info'
'16309655','Create_file','16309655','db=hoasc_server;table=tecrdata_43;file_id=916;block_len=8194'
'16318084','Exec_load','16318084',';file_id=916'
'16318107','Intvar','16318107','INSERT_ID=69780'
'16318135','Query','16318135','use hoasc_server; INSERT INTO server_tmessages VALUES 
(NULL, 'INFO', 'End importing tecrdata', NOW())'


Questions: 
1. How can I find out what is wrong ?
2. Are there anywhere explained what the 'Event_type' and 'Info' mean ? I didn't found 
anything in docs.
3. in the master error-log I have:
030919 11:20:54  Error in Log_event::read_log_event(): 'Event too big', 
data_len=2157824,event_type=63


Tnx,
IOnut

-- 
IOnut
FreeBSD unregistered ;) user

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]