BIN LOG Error when use Begin Trans in Replication.

BIN LOG Error when use Begin Trans in Replication.

am 21.04.2010 15:19:21 von Vikram A

--0-819650313-1271855961=:25631
Content-Type: multipart/alternative; boundary="0-1384559478-1271855961=:25631"

--0-1384559478-1271855961=:25631
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi, I have installed mysql 5.1.45 version on windows server 2003[sta=
ndard edition] and windows xp. I am using WIN SERVER as MASTER and WIN XP a=
s slave.And the default engine in both severs is INNODB. I am using vi=
sual basic for my front end. The replication system is running quite well.=
When i am using the rs.BeginTrans =0AI am facing the following error=
when i am pointing my master, [MySQL][ODBC 5.1 Driver][mysqld-5.1.45-=
community-log]Binary logging not possible. Message: Transaction level 'READ=
-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' If i poi=
nt my slave as server[I have done for checking beginTrans]; it is running q=
uite well. Can I have help from any one. It will be useful to me.=0A=
=0AI am attaching the my.ini for your reference. Thank you Vikram=
A =0A
--0-1384559478-1271855961=:25631
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

ad>

0pt">
Hi,

I have installed  mysql 5.1.45 version on windo=
ws server 2003[standard edition] and windows xp. I am using WIN SERVER as M=
ASTER and WIN XP as slave. And the default engine in both severs is INNODB.=


I am using visual basic for my front end.  The replication sys=
tem is running quite well.

When i am using the style: italic; color: rgb(0, 0, 127);">rs.BeginTrans
I am facing=
the following error when i am pointing my master,

gb(255, 0, 0);">=
[MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community-log]Binary logging not pos=
sible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe fo=
r binlog mode 'STATEMENT'
0);">
 =3D"color: rgb(0, 0, 0);">If i point my slave as server[I have done for che=
cking beginTrans]; it is running quite well t-style: italic; color: rgb(255, 0, 0);"> ;">.

 e=3D"color: rgb(0, 0, 0);">Can I have help from any one. It will be useful =
to me.

I am attaching the my.ini for your reference.

Thank yo=
u

=
Vikram A
 rgb(255, 0, 0);">
=
=0A


--0-1384559478-1271855961=:25631--

--0-819650313-1271855961=:25631
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--0-819650313-1271855961=:25631--

Fw: BIN LOG Error when use Begin Trans in Replication.

am 21.04.2010 18:30:33 von Vikram A

--0-105090299-1271867433=:20505
Content-Type: multipart/alternative; boundary="0-1084452823-1271867433=:20505"

--0-1084452823-1271867433=:20505
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi Hao Ding, =0AI attached in my request mail it self. Please find the=
attachment. =0AThank you =0A________________________________=0A=
From: hao ding =0ATo: Vikram A =
=0ASent: Wed, 21 April, 2010 7:25:05 PM=0ASubject: Re: BIN LOG Error when u=
se Begin Trans in Replication. Vikram,=0AI don't find my.ini. =0A=
On Wed, Apr 21, 2010 at 9:19 PM, Vikram A wrote:=0A=
=0AHi, =0A>=0A>I have installed mysql 5.1.45 version on windows server 200=
3[standard edition] and windows xp. I am using WIN SERVER as MASTER and WIN=
XP as slave. And the default engine in both severs is INNODB.=0A>=0A>I am =
using visual basic for my front end. The replication system is running qui=
te well. =0A>=0A>When i am using the rs.BeginTrans =0A>I am facing the foll=
owing error when i am pointing my master,=0A>=0A>[MySQL][ODBC 5.1 Driver][m=
ysqld-5.1.45-community-log]Binary logging not possible. Message: Transactio=
n level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'=
=0A>=0A>If i point my slave as server[I have done for checking beginTrans];=
it is running quite well.=0A>=0A>Can I have help from any one. It will be =
useful to me.=0A>=0A>I am attaching the my.ini for your reference.=0A>=0A>T=
hank you=0A>=0A>Vikram A=0A>=0A>=0A>=0A>>--=0A>>MySQL General Mailing List=
=0A>>For list archives: http://lists.mysql.com/mysql=0A>>To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dfire9dingh@gmail.com=0A >
--0-1084452823-1271867433=:20505
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

ad>

0pt">Hi Hao Ding,
f; font-size: 10pt;">
mes,serif; font-size: 12pt;">
ans-serif; font-size: 10pt;">

I at=
tached in my request mail it self. Please find the attachment.
Thank yo=
u
font-size: 10pt;">
imes,serif; font-size: 12pt;">
1">From: hao ding <fire=
9dingh@gmail.com>
To: > Vikram A <vikkiatbipl@yahoo.in>
old;">Sent:
Wed, 21 April, 2010 7:25:05 PM
Su=
bject: Re: BIN LOG Error when use Begin Trans in Replication. >
Vikram,
I don't find my.ini.

te">On=0A Wed, Apr 21, 2010 at 9:19 PM, Vikram A < el=3D"nofollow" ymailto=3D"mailto:vikkiatbipl@yahoo.in" target=3D"_blank" h=
ref=3D"mailto:vikkiatbipl@yahoo.in">vikkiatbipl@yahoo.in> wro=
te:
lid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> >
>
Hi,

I have installed  mysql 5.1.45 version on windows s=
erver 2003[standard edition] and windows xp. I am using WIN SERVER as MASTE=
R and WIN XP as slave. And the default engine in both severs is INNODB.
=

I am using visual basic for my front end.  The replication s=
ystem is running quite well.

When i am using the t-style: italic; color: rgb(0, 0, 127);">rs.BeginTrans
I am faci=
ng the following error when i am pointing my master,

color: rgb(255, 0, 0);"> 0, 0);">[MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community-log]Binary logging=
not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not=
safe for binlog mode 'STATEMENT'
0);">
 =3D"color: rgb(0, 0, 0);">If i point my slave as server[I have done for che=
cking beginTrans]; it is running quite well t-style: italic; color: rgb(255, 0, 0);"> ;">.

 n style=3D"color: rgb(0, 0, 0);">Can I have help from any one. It will be u=
seful to me.

I am attaching the my.ini for your reference.

Th=
ank you

e: italic;">Vikram A
 lic; color: rgb(255, 0, 0);"> span>
=0A



=0A--
=0AMySQL General Mailing Lis=
t
=0AFor list archives: tp://lists.mysql.com/mysql">http://lists.mysql.com/mysql
=0ATo unsub=
scribe:     ists.mysql.com/mysql?unsub=3Dfire9dingh@gmail.com">http://li sts.mysql.com/m=
ysql?unsub=3Dfire9dingh@gmail.com

=0A div>
=0A

=0A


--0-1084452823-1271867433=:20505--

--0-105090299-1271867433=:20505
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--0-105090299-1271867433=:20505--

Re: Fw: BIN LOG Error when use Begin Trans in Replication.

am 21.04.2010 22:47:29 von Max Bube

--001517475e626e1f540484c54d80
Content-Type: text/plain; charset=ISO-8859-1

Hi Vikram,

Add binlog_format=row to your my.ini master's conf file



2010/4/21 Vikram A

> Hi Hao Ding,
>
> I attached in my request mail it self. Please find the attachment.
> Thank you
>
> ------------------------------
> *From:* hao ding
> *To:* Vikram A
> *Sent:* Wed, 21 April, 2010 7:25:05 PM
> *Subject:* Re: BIN LOG Error when use Begin Trans in Replication.
>
> Vikram,
> I don't find my.ini.
>
> On Wed, Apr 21, 2010 at 9:19 PM, Vikram A wrote:
>
>> Hi,
>>
>> I have installed mysql 5.1.45 version on windows server 2003[standard
>> edition] and windows xp. I am using WIN SERVER as MASTER and WIN XP as
>> slave. And the default engine in both severs is INNODB.
>>
>> I am using visual basic for my front end. The replication system is
>> running quite well.
>>
>> When i am using the rs.BeginTrans
>> I am facing the following error when i am pointing my master,
>>
>> [MySQL][ODBC 5.1 Driver][mysqld-5.1.45-community-log]Binary logging not
>> possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe
>> for binlog mode 'STATEMENT'
>>
>> If i point my slave as server[I have done for checking beginTrans]; it is
>> running quite well.
>>
>> Can I have help from any one. It will be useful to me.
>>
>> I am attaching the my.ini for your reference.
>>
>> Thank you
>>
>> Vikram A
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=fire9dingh@gmail.com
>>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=maxbube@gmail.com
>

--001517475e626e1f540484c54d80--

Re: Fw: BIN LOG Error when use Begin Trans in Replication.

am 22.04.2010 06:49:36 von Vikram A

--0-1282568779-1271911776=:95493
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi Max Bube, The following are the variables related to the binlog.=0A=
mysql>show variables =0Avaribale_name : Value=0A.=0A.=0A.=0Abinlog_cache_si=
ze : 32768=0Abinlog_direct_non_transactional_updates : OFF=0Abinlog_format =
: STATEMENT .=0A.=0A.=0ABy default I found the statement based[it is b=
etter than row based?] format for bin log. I left it as such. I hope it is =
enough. As you said, in the my.ini file which part i suppose to add th=
is binlog-format =3D statement ? Thank you Vikram __=
______________________________=0AFrom: Max Bube =0ATo: V=
ikram A =0ACc: MY SQL Mailing list ..com>=0ASent: Thu, 22 April, 2010 2:17:29 AM=0ASubject: Re: Fw: BIN LOG Err=
or when use Begin Trans in Replication. Hi Vikram, Add binlog_for=
mat=3Drow to your my.ini master's conf file =0A2010/4/21 Vikram =
A Hi Hao Ding,=0A>=0A>=0A>I attached in my requ=
est mail it self. Please find the attachment. =0A>Thank you=0A>=0A>=0A>=0A>=
=0A________________________________=0AFrom: hao ding =
=0A>To: Vikram A =0A>Sent: > Wed, 21 April, 2010 7:25=
:05 PM=0A>Subject: Re: BIN LOG Error when use Begin Trans in Replication.=
=0A>=0A>Vikram,=0A>I don't find my.ini.=0A>=0A>=0A>On=0A> Wed, Apr 21, 2010=
at 9:19 PM, Vikram A wrote:=0A>=0A>Hi, =0A>>=0A>>I =
have installed mysql 5.1.45 version on windows server 2003[standard editio=
n] and windows xp. I am using WIN SERVER as MASTER and WIN XP as slave. And=
the default engine in both severs is INNODB.=0A>>=0A>>I am using visual ba=
sic for my front end. The replication system is running quite well. =0A>>=
=0A>>When i am using the rs.BeginTrans =0A>>I am facing the following error=
when i am pointing my master,=0A>>=0A>>[MySQL][ODBC 5.1 Driver][mysqld-5.1=
..45-community-log]Binary logging not possible. Message: Transaction level '=
READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'=0A>>=0A>>=
If i point my slave as server[I have done for checking beginTrans]; it is r=
unning quite well.=0A>>=0A>>Can I have help from any one. It will be useful=
to me.=0A>>=0A>>I am attaching the my.ini for your reference.=0A>>=0A>>Tha=
nk you=0A>>=0A>>Vikram A=0A>>=0A>>=0A>>=0A>>=0A>>>>--=0A>>>>MySQL General M=
ailing List=0A>>>>For list archives: http://lists.mysql.com/mysql=0A>>=0A>>=
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dfire9dingh@gmail.co=
m=0A>>=0A>=0A>=0A>=0A>=0A>>--=0A>>MySQL General Mailing List=0A>>For list a=
rchives: http://lists.mysql.com/mysql=0A>>To unsubscribe: http://lists.m=
ysql.com/mysql?unsub=3Dmaxbube@gmail.com=0A> =0A
--0-1282568779-1271911776=:95493--

Re: Fw: BIN LOG Error when use Begin Trans in Replication.

am 22.04.2010 07:05:58 von Vikram A

--0-1009173491-1271912758=:64087
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

hi, I tried with ROW and MIXED tyoe it is working fine. When i go for =
statement based, it is =0Acausing the error. mysql> SET GLOBAL binlog_=
format =3D 'STATEMENT';=0Amysql> SET GLOBAL binlog_format =3D 'ROW';=0Amysq=
l> SET GLOBAL binlog_format =3D 'MIXED'; can you suggest Which is the =
best format?=0AThank you VIKRAM=0AFrom: Max Bube =
To: Vikram A =0ACc: MY SQL Mailing list lists.mysql.com>=0ASent: Thu, 22 April, 2010 2:17:29 AM=0ASubject: Re: Fw: =
BIN LOG Error when use Begin Trans in Replication. Hi Vikram, Add=
binlog_format=3Drow to your my.ini master's conf file =0A2010/4=
/21 Vikram A Hi Hao Ding,=0A>=0A>=0A>I attached=
in my request mail it self. Please find the attachment. =0A>Thank you=0A>=
=0A>=0A>=0A>=0A________________________________=0AFrom: hao ding h@gmail.com>=0A>To: Vikram A =0A>Sent: > Wed, 21 Apri=
l, 2010 7:25:05 PM=0A>Subject: Re: BIN LOG Error when use Begin Trans in Re=
plication.=0A>=0A>Vikram,=0A>I don't find my.ini.=0A>=0A>=0A>On=0A> Wed, Ap=
r 21, 2010 at 9:19 PM, Vikram A wrote:=0A>=0A>Hi, =
=0A>>=0A>>I have installed mysql 5.1.45 version on windows server 2003[sta=
ndard edition] and windows xp. I am using WIN SERVER as MASTER and WIN XP a=
s slave. And the default engine in both severs is INNODB.=0A>>=0A>>I am usi=
ng visual basic for my front end. The replication system is running quite =
well. =0A>>=0A>>When i am using the rs.BeginTrans =0A>>I am facing the foll=
owing error when i am pointing my master,=0A>>=0A>>[MySQL][ODBC 5.1 Driver]=
[mysqld-5.1.45-community-log]Binary logging not possible. Message: Transact=
ion level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT=
'=0A>>=0A>>If i point my slave as server[I have done for checking beginTran=
s]; it is running quite well.=0A>>=0A>>Can I have help from any one. It wil=
l be useful to me.=0A>>=0A>>I am attaching the my.ini for your reference.=
=0A>>=0A>>Thank you=0A>>=0A>>Vikram A=0A>>=0A>>=0A>>=0A>>=0A>>>>--=0A>>>>My=
SQL General Mailing List=0A>>>>For list archives: http://lists.mysql.com/my=
sql=0A>>=0A>>To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dfire9d=
ingh@gmail.com=0A>>=0A>=0A>=0A>=0A>=0A>>--=0A>>MySQL General Mailing List=
=0A>>For list archives: http://lists.mysql.com/mysql=0A>>To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dmaxbube@gmail.com=0A>=0 A
--0-1009173491-1271912758=:64087--