percona-discussion team mailing list archive

[mysqldavid <mysqldavid@xxxxxxxxx>]

Hello Vadim,

I got the configure parameter by running mysqlbug.  I am not quite
sure how the DBA before me selected the parameters for the configure
script.  So I took your advice and removed those 2 parameters (I read
the doc, I dont think we need it anyways).   I was able to
successfully build this for version 5.0.67 hp and 5.0.75 hp.
However, the replication broke as soon as I shutdown the slave and
restarted it.  Here is the log:


090217 22:50:15 [Note] Slave SQL thread initialized, starting
replication in log 'mysql-bin.000008' at position 98, relay log
'/var/lib/mysql/mysql5.000001' position: 4
090217 22:50:15 [Note] Slave I/O thread: connected to master
'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
'mysql-bin.000008' at position 98
090217 22:50:15 [Note] createReplicationMule
090217 22:50:15 [Note] Binglog size 98
090217 22:50:15 [Note] ReplicationMule: RELAY_MATCH_MULE.
090217 22:50:15 [Note]  RELAY_MATCH_MULE event 15
090217 22:50:36 [Note] Slave I/O thread killed while reading event
090217 22:50:36 [Note] Slave I/O thread exiting, read up to log
'mysql-bin.000008', position 98
090217 22:50:36 [Note] Error reading relay log event: slave SQL thread
was killed
090217 22:50:38 [Note] Slave SQL thread initialized, starting
replication in log 'mysql-bin.000008' at position 98, relay log
'/var/lib/mysql/mysql5.000002' position: 235
090217 22:50:38 [Note] Slave I/O thread: connected to master
'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
'mysql-bin.000008' at position 98
090217 22:50:38 [Note] createReplicationMule
090217 22:50:38 [Note] Binglog size 98
090217 22:50:38 [Note] ReplicationMule: RELAY_MATCH_MULE.
090217 22:50:38 [Note]  RELAY_MATCH_MULE event 15
090217 22:54:42 [Note] Slave I/O thread killed while reading event
090217 22:54:42 [Note] Slave I/O thread exiting, read up to log
'mysql-bin.000013', position 85431178
090217 22:54:42 [Note] Error reading relay log event: slave SQL thread
was killed
090217 22:54:46 [Note] Slave SQL thread initialized, starting
replication in log 'mysql-bin.000013' at position 85431178, relay log
'/var/lib/mysql/mysql5.000018' position: 85431315
090217 22:54:46 [Note] Slave I/O thread: connected to master
'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
'mysql-bin.000013' at position 85431178
090217 22:54:46 [Note] createReplicationMule
090217 22:54:46 [Note] Binglog size 85431178
090217 22:54:46 [Note] ReplicationMule: RELAY_MATCH_MULE.
090217 22:54:46 [Note]  RELAY_MATCH_MULE event 15
090217 23:06:10 [Note] /opt/mysql-5.0.75.5/lib/mysqld: Normal shutdown

090217 23:06:10 [Note] Slave I/O thread killed while reading event
090217 23:06:10 [Note] Slave I/O thread exiting, read up to log
'mysql-bin.000013', position 85431178
090217 23:06:10 [Note] Error reading relay log event: slave SQL thread
was killed
090217 23:06:10  InnoDB: Starting shutdown...
090217 23:06:12  InnoDB: Shutdown completed; log sequence number 0 2646942385
090217 23:06:12 [Note] /opt/mysql-5.0.75.5/lib/mysqld: Shutdown complete

090217 23:06:15  InnoDB: Started; log sequence number 0 2646942385
090217 23:06:15 [Note] /opt/mysql-5.0.75.5/lib/mysqld: ready for connections.
Version: '5.0.75-percona-b12-hp-log'  socket:
'/var/run/mysqld/mysqld.sock'  port: 3306  with_mirror_binlog
090217 23:08:12 [Note] Slave SQL thread initialized, starting
replication in log 'mysql-bin.000013' at position 85431178, relay log
'/var/lib/mysql/mysql5.000019' position: 235
090217 23:08:12 [Note] Slave I/O thread: connected to master
'repl@xxxxxxxxxxxxxxxxxxx:3306',  replication started in log
'mysql-bin.000013' at position 85431178
090217 23:08:12 [Note] createReplicationMule
090217 23:08:12 [ERROR] Mule
binlog(/var/lib/mysql/mysql5/mysql-bin.000014) does not match new
relay-binlog(mysql-bin.000013)
090217 23:08:12 [Note] Slave I/O thread exiting, read up to log
'mysql-bin.000013', position 85431178


-David


On Fri, Feb 13, 2009 at 10:14 PM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
> David,
>
> Ok, I am not sure, but it may not work with
> '--with-embedded-server'
> '--with-embedded-privilege-control'.
>
> where did you take that configure line ?
>
>
> mysqldavid wrote:
>> Hi Vadim,
>>
>> I'm still getting an error during the build.   mysql.5.0.67.3 is the
>> label I'm giving to the percona build 10-hp.  mirror_binlog.patch.new
>> was downloaded and renamed via the command "bzr branch
>> lp:~percona-dev/percona-patches/5.0.67".
>>
>> dnguyen@xxxxxxxxxxxxxxxxxxx.:mysql-5.0.67.3$ patch -p1 <
>> ../b10_patch/mirror_binlog.patch.new
>> patching file mysql-test/lib/mtr_cases.pl
>> patching file mysql-test/mysql-test-run.pl
>> patching file mysql-test/r/rpl_mirror_binlog.result
>> patching file mysql-test/t/rpl_mirror_binlog-master.opt
>> patching file mysql-test/t/rpl_mirror_binlog-slave.opt
>> patching file mysql-test/t/rpl_mirror_binlog.1.slave-mi
>> patching file mysql-test/t/rpl_mirror_binlog.2.slave-mi
>> patching file mysql-test/t/rpl_mirror_binlog.test
>> patching file patch_info/mirror_binlog.info
>> patching file sql/Makefile.am
>> patching file sql/Makefile.in
>> patching file sql/lex.h
>> Hunk #1 succeeded at 293 (offset 1 line).
>> patching file sql/log.cc
>> patching file sql/log_event.h
>> patching file sql/mysql_priv.h
>> Hunk #3 succeeded at 1877 (offset -1 lines).
>> patching file sql/mysqld.cc
>> Hunk #1 succeeded at 555 (offset -1 lines).
>> Hunk #2 succeeded at 585 (offset -1 lines).
>> Hunk #3 succeeded at 602 (offset -1 lines).
>> Hunk #4 succeeded at 1345 (offset -1 lines).
>> Hunk #5 succeeded at 3195 (offset -1 lines).
>> Hunk #6 succeeded at 3430 (offset -1 lines).
>> Hunk #7 succeeded at 3481 (offset -1 lines).
>> Hunk #8 succeeded at 5043 (offset -1 lines).
>> Hunk #9 succeeded at 5754 (offset 3 lines).
>> Hunk #10 succeeded at 5883 (offset 3 lines).
>> Hunk #11 succeeded at 6664 (offset -1 lines).
>> patching file sql/repl_mule.cc
>> patching file sql/repl_mule.h
>> patching file sql/set_var.cc
>> Hunk #1 succeeded at 345 (offset -2 lines).
>> Hunk #2 succeeded at 366 (offset -2 lines).
>> Hunk #3 succeeded at 791 (offset 3 lines).
>> Hunk #4 succeeded at 1141 (offset 6 lines).
>> patching file sql/slave.cc
>> patching file sql/sql_class.h
>> Hunk #1 succeeded at 152 (offset 6 lines).
>> Hunk #2 succeeded at 251 (offset 6 lines).
>> Hunk #3 succeeded at 326 (offset 6 lines).
>> Hunk #4 succeeded at 367 (offset 6 lines).
>> Hunk #5 succeeded at 396 (offset 6 lines).
>> patching file sql/sql_lex.h
>> patching file sql/sql_parse.cc
>> Hunk #2 succeeded at 3480 (offset -4 lines).
>> patching file sql/sql_repl.cc
>> patching file sql/sql_repl.h
>> patching file sql/sql_yacc.yy
>> Hunk #1 succeeded at 736 (offset 1 line).
>> Hunk #2 succeeded at 1169 (offset 1 line).
>> Hunk #3 succeeded at 1303 (offset 1 line).
>> Hunk #4 succeeded at 1431 (offset 1 line).
>> Hunk #5 succeeded at 8450 (offset 2 lines).
>>
>> dnguyen@xxxxxxxxxxxxxxxxxxx.:mysql-5.0.67.3$ ./configure
>> '--build=x86_64-linux-gnu' '--host=x86_64-linux-gnu'
>> '--prefix=/opt/mysql-5.0.67.3' '--exec-prefix=/opt/mysql-5.0.67.3'
>> '--libexecdir=/opt/mysql-5.0.67.3/lib'
>> '--datadir=/opt/mysql-5.0.67.3/share' '--localstatedir=/var/lib/mysql'
>> '--includedir=/opt/mysql-5.0.67.3/include'
>> '--infodir=/opt/mysql-5.0.67.3/info'
>> '--mandir=/opt/mysql-5.0.67.3/man'
>> '--with-server-suffix=-percona-b10-hp' '--with-comment=with
>> mirror_binlog' '--enable-shared' '--enable-static'
>> '--enable-thread-safe-client' '--enable-local-infile'
>> '--with-big-tables' '--with-raid'
>> '--with-unix-socket-path=/var/run/mysqld/mysqld.sock'
>> '--with-mysqld-user=mysql' '--with-libwrap' '--with-vio'
>> '--without-openssl' '--with-yassl' '--without-docs' '--with-bench'
>> '--without-readline' '--with-extra-charsets=all' '--with-innodb'
>> '--with-isam' '--with-archive-storage-engine'
>> '--with-csv-storage-engine' '--with-federated-storage-engine'
>> '--without-embedded-server' '--with-ndbcluster' '--with-ndb-shm'
>> '--without-ndb-sci' '--without-ndb-test' '--with-embedded-server'
>> '--with-embedded-privilege-control' '--with-ndb-docs' 'CC=gcc'
>> 'CFLAGS=-DBIG_JOINS=1 -O2' 'CXXFLAGS=-DBIG_JOINS=1
>> -felide-constructors -fno-rtti -O2' 'CXX=g++'
>> 'build_alias=x86_64-linux-gnu' 'host_alias=x86_64-linux-gnu'
>>
>> .
>> .
>> .
>>
>> make[3]: Entering directory `/home/dnguyen/build_dir/mysql-5.0.67.3/libmysqld'
>> if gcc -DEMBEDDED_LIBRARY -DMYSQL_SERVER
>> -DDEFAULT_MYSQL_HOME="\"/opt/mysql-5.0.67.3\""
>> -DDATADIR="\"/var/lib/mysql\""
>> -DSHAREDIR="\"/opt/mysql-5.0.67.3/share/mysql\"" -I. -I. -I../include
>> -I../innobase/include -I../innobase/include -I../ndb/include
>> -I../ndb/include -I../ndb/include/ndbapi -I../ndb/include/mgmapi
>> -I../include -I../include -I../sql -I../sql -I../sql/examples
>> -I../regex      -DDBUG_OFF -DBIG_JOINS=1 -O2   -MT libmysqld.o -MD -MP
>> -MF ".deps/libmysqld.Tpo" -c -o libmysqld.o libmysqld.c; \
>>       then mv -f ".deps/libmysqld.Tpo" ".deps/libmysqld.Po"; else rm -f
>> ".deps/libmysqld.Tpo"; exit 1; fi
>> if g++ -DEMBEDDED_LIBRARY -DMYSQL_SERVER
>> -DDEFAULT_MYSQL_HOME="\"/opt/mysql-5.0.67.3\""
>> -DDATADIR="\"/var/lib/mysql\""
>> -DSHAREDIR="\"/opt/mysql-5.0.67.3/share/mysql\"" -I. -I. -I../include
>> -I../innobase/include -I../innobase/include -I../ndb/include
>> -I../ndb/include -I../ndb/include/ndbapi -I../ndb/include/mgmapi
>> -I../include -I../include -I../sql -I../sql -I../sql/examples
>> -I../regex      -DDBUG_OFF -DBIG_JOINS=1 -felide-constructors
>> -fno-rtti -O2   -fno-implicit-templates -fno-exceptions -fno-rtti  -MT
>> lib_sql.o -MD -MP -MF ".deps/lib_sql.Tpo" -c -o lib_sql.o lib_sql.cc;
>> \
>>       then mv -f ".deps/lib_sql.Tpo" ".deps/lib_sql.Po"; else rm -f
>> ".deps/lib_sql.Tpo"; exit 1; fi
>> ../sql/mysqld.cc: In function 'int init_server_components()':
>> ../sql/mysqld.cc:3433: error: 'make_master_open_index' was not
>> declared in this scope
>> ../sql/mysqld.cc:3485: error: 'make_master' was not declared in this scope
>> make[3]: *** [lib_sql.o] Error 1
>> make[3]: Leaving directory `/home/dnguyen/build_dir/mysql-5.0.67.3/libmysqld'
>> make[2]: *** [all-recursive] Error 1
>> make[2]: Leaving directory `/home/dnguyen/build_dir/mysql-5.0.67.3/libmysqld'
>> make[1]: *** [all-recursive] Error 1
>> make[1]: Leaving directory `/home/dnguyen/build_dir/mysql-5.0.67.3'
>> make: *** [all] Error 2
>>
>>
>> Thanks for the quick replies!
>> -David
>>
>>
>> On Fri, Feb 13, 2009 at 9:21 AM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
>>> Hi David!
>>>
>>> Thanks! Yes please try it.
>>>
>>>
>>> mysqldavid wrote:
>>>> Thanks Vadim!  I'll give it a try.   BTW, I was the one who sat next
>>>> to you at the last MySQL Meetup at Sun on Monday.   Also, great job on
>>>> the High Performance MySQL book.
>>>>
>>>>
>>>> -David
>>>>
>>>> On Thu, Feb 12, 2009 at 11:41 PM, Vadim Tkachenko <vadim@xxxxxxxxxxx> wrote:
>>>>> Can you try last version from
>>>>>
>>>>> lp:~percona-dev/percona-patches/5.0.67 ?
>>>>>
>>>>> I just pushed recent fixes to patch.
>>>>>
>>>>>
>>>>> mysqldavid wrote:
>>>>>
>>>>> --
>>>>> Vadim Tkachenko, CTO
>>>>> Percona Inc.
>>>>> ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
>>>>> MySQL Performance Blog - http://www.mysqlperformanceblog.com
>>>>> MySQL Consulting http://www.percona.com/
>>>>>
>>>>>  Attend the 2009 Percona Performance Conference
>>>>>  April 22-23 - http://conferences.percona.com/
>>>>>
>>>>> --
>>>>> Incorrect mirrored binary log
>>>>> https://bugs.launchpad.net/bugs/304296
>>>>> You received this bug notification because you are a direct subscriber
>>>>> of the bug.
>>>>>
>>>>> Status in Patches for MySQL by Percona: Fix Committed
>>>>>
>>>>> Bug description:
>>>>> I have incorrect mirrored binlog when slave between restarts has no new events
>>>>>
>>>
>>> --
>>> Vadim Tkachenko, CTO
>>> Percona Inc.
>>> ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
>>> MySQL Performance Blog - http://www.mysqlperformanceblog.com
>>> MySQL Consulting http://www.percona.com/
>>>
>>>  Attend the 2009 Percona Performance Conference
>>>  April 22-23 - http://conferences.percona.com/
>>>
>>> --
>>> Incorrect mirrored binary log
>>> https://bugs.launchpad.net/bugs/304296
>>> You received this bug notification because you are a direct subscriber
>>> of the bug.
>>>
>>> Status in Patches for MySQL by Percona: Fix Committed
>>>
>>> Bug description:
>>> I have incorrect mirrored binlog when slave between restarts has no new events
>>>
>>
>
>
> --
> Vadim Tkachenko, CTO
> Percona Inc.
> ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
> MySQL Performance Blog - http://www.mysqlperformanceblog.com
> MySQL Consulting http://www.percona.com/
>
>  Attend the 2009 Percona Performance Conference
>  April 22-23 - http://conferences.percona.com/
>
> --
> Incorrect mirrored binary log
> https://bugs.launchpad.net/bugs/304296
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in Patches for MySQL by Percona: Fix Committed
>
> Bug description:
> I have incorrect mirrored binlog when slave between restarts has no new events
>

-- 
Incorrect mirrored binary log
https://bugs.launchpad.net/bugs/304296
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.

Status in Patches for MySQL by Percona: Fix Committed

Bug description:
I have incorrect mirrored binlog when slave between restarts has no new events