Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Replication breaks w/o explanation

From: Jesse <jlc(at)msdlg.com>
Date: Mon Oct 08 2007 - 08:02:23 EDT


I posted messages about this last week, and still have not found a reason for my problems. Replication will simply stop, with the message, "Slave SQL thread exiting, replication stopped in log 'mysql-bin.000002' at position 191" There is no further explanation than that. I look at position 191 in the BINLOG of the master, and 191 is an End Position. However, the command at that location is the execution of a function:

use `tsa`; DO `AddSchool`(_latin1'Easy High School',_latin1'2',_binary'0',1)

My question is this. When a slave is executing commands from the binlog on the master, what user does it use? Does it use the original user that was used, does it use the root user, or the Replication user? Or does it by-pass the user process all together, and simply executes the commands? If it's the replication user, I may see my problem. Strange, though, that updates and inserts seem to work, but executing functions doesn't, when I haven't granted any rights to the replication user on the slave at all, and I only granted replication rights to it on the master. In fact, when I added the user, I used the server's name as the "host" designation, so it would appear that in MySQL Administrator, I can't assign rights to it. Maybe I can in the command prompt, but I haven't tried that yet.

Am I on the right track here, or does anyone else have any ideas?

Thanks,
Jesse

-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com
Received on Mon Oct 8 08:02:53 2007

This archive was generated by hypermail 2.1.8 : Fri Jul 04 2008 - 00:24:03 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library