Re: Replication breaks w/o explanation

I thought that might be a problem too, but it doesn't appear to be. It has stopped in different times each time, and I back up at 11:00 every night.

If the slave uses the system user for executing the commands on the slave, does the system user always have the privileges to do whatever it needs to?

Thanks,
Jesse

• Original Message ----- From: "Database System" <database100@yahoo.com> To: "Jesse" <jlc@msdlg.com> Cc: <replication@lists.mysql.com> Sent: Tuesday, October 09, 2007 10:01 AM Subject: Re: Replication breaks w/o explanation

>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