Re: Replication breaks w/o explanation

From: Database System <database100(at)yahoo.com>
Date: Tue Oct 09 2007 - 10:01:15 EDT

I think the cause os stopping replication is from admin backup process. Please note if the time of stopping every day is around same time.

I think the slave uses system user.

Lisa

• Jesse <jlc@msdlg.com> wrote:

> 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=database100@yahoo.com
>
>

---

Catch up on fall's hot new shows on Yahoo! TV. Watch previews, get listings, and more! http://tv.yahoo.com/collections/3658

-- 
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 Tue Oct 9 10:01:32 2007