replication problems

[Duncan Hutty]

I have a simple master-slave replication setup. Nothing very interesting 
as far as I know, both running identically configured 5.1.31 using 
'mixed' replication.


I have a couple of issues which I assume are related, although I suppose 
they might not be:


1) When the monitoring showed that slaving had stopped, I found the 
last_sql_error which was about a foreign key constraint failing.


Is it possible that the queries against the master get into the bin log 
out of order so that a referent was changed while there were still 
outstanding references to it?


If not, how is it possible that the query would succeed on the master 
but not on the slave?


2) Unable to get quick answers to that I decided that safest and easiest 
would be to take a dump of the master and use it to create a new slave 
from scratch. However, one of my databases failed to load into the new 
slave, with an Identifier too long (error 1509). But this dumpfile 
came from the master. If it's ok on the master, how can it be too long 
for the slave?


And of course, the real question is how do I stop this happening again? 
Is it something wrong with my mysql server setup? Or is it bad code on 
the part of my users? And if the latter, what can I do to prevent their 
bad code making my slaving fail?


--
Duncan Hutty
System Administrator, ECE
Carnegie Mellon University

Please use informative subject lines

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: 5.1.14-beta with ssl build failure

[Duncan Hutty]

Chris White wrote:



Duncan Hutty wrote:
I attempted to build 5.1.14-beta with ssl support and it failed 
(output below).
It builds quite happily on this system without the ssl support 
parameter to configure. Since it appears to fail in an area (timezone 
system) that to me seems rather unrelated, I wondered if something odd 
was afoot.

x86-suse9.3, openssl-0.9.8d, gcc-3.4.6 (or gcc-4.1.1) using:
CFLAGS=-O3 CXX=gcc \
CXXFLAGS=-O3 -felide-constructors \
-fno-exceptions -fno-rtti  \


Kill all this and try changing -O3 to -O2 as -O3 optimizations can get 
dicey sometimes, especially when it comes into C++ oddities.



./configure --with-ndbcluster \
--with-ssl=/usr/local/openssl \
--enable-assembler  make


Also, it seems to be failing during the linking stage, so take a look at 
throwing out --enable-assembler and see what happens.




Thanks for the suggestions, but they didn't change the result.

--
Duncan Hutty
System Administrator, ECE
Carnegie Mellon University

Please use informative subject lines

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

5.1.14-beta with ssl build failure

[Duncan Hutty]

I attempted to build 5.1.14-beta with ssl support and it failed (output 
below).
It builds quite happily on this system without the ssl support parameter 
to configure. Since it appears to fail in an area (timezone system) that 
to me seems rather unrelated, I wondered if something odd was afoot.

x86-suse9.3, openssl-0.9.8d, gcc-3.4.6 (or gcc-4.1.1) using:
CFLAGS=-O3 CXX=gcc \
CXXFLAGS=-O3 -felide-constructors \
-fno-exceptions -fno-rtti  \
./configure --with-ndbcluster \
--with-ssl=/usr/local/openssl \
--enable-assembler  make

Any suggestions?
--
Duncan Hutty
System Administrator, ECE
Carnegie Mellon University


gcc -O3 -felide-constructors -fno-exceptions -fno-rtti 
-fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o 
mysql_tzinfo_to_sql mysql_tzinfo_to_sql.o  ../vio/libvio.a 
../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a 
../strings/libmystrings.a -lz -lpthread -lcrypt -lnsl -lm -lpthread

/usr/lib/crt1.o(.text+0x18): In function `_start':
../sysdeps/i386/elf/start.S:115: undefined reference to `main'
mysql_tzinfo_to_sql.o(.text+0x3ab): In function 
`Time_zone_system::TIME_to_gmt_sec(st_mysql_time const*, char*) const':

mysql_tzinfo_to_sql.cc: undefined reference to `my_system_gmt_sec'
mysql_tzinfo_to_sql.o(.text+0x3ef): In function 
`Time_zone_system::gmt_sec_to_TIME(st_mysql_time*, long) const':
mysql_tzinfo_to_sql.cc: undefined reference to 
`localtime_to_TIME(st_mysql_time*, tm*)'
mysql_tzinfo_to_sql.o(.text+0x45f): In function 
`Time_zone_utc::gmt_sec_to_TIME(st_mysql_time*, long) const':
mysql_tzinfo_to_sql.cc: undefined reference to 
`localtime_to_TIME(st_mysql_time*, tm*)'
mysql_tzinfo_to_sql.o(.text+0x167a): In function `my_tz_find(String 
const*, st_table_list*)':
mysql_tzinfo_to_sql.cc: undefined reference to `sql_print_error(char 
const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1729):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1749):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1764):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1e91):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x1fe9):mysql_tzinfo_to_sql.cc: more 
undefined references to `sql_print_error(char const*, ...)' follow
mysql_tzinfo_to_sql.o(.text+0x20e7): In function `my_tz_init(THD*, char 
const*, char)':

mysql_tzinfo_to_sql.cc: undefined reference to `THD::THD()'
mysql_tzinfo_to_sql.o(.text+0x2117):mysql_tzinfo_to_sql.cc: undefined 
reference to `THD::store_globals()'
mysql_tzinfo_to_sql.o(.text+0x23c4):mysql_tzinfo_to_sql.cc: undefined 
reference to `simple_open_n_lock_tables(THD*, st_table_list*)'
mysql_tzinfo_to_sql.o(.text+0x24ed):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x250e):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_warning(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x2571):mysql_tzinfo_to_sql.cc: undefined 
reference to `global_system_variables'
mysql_tzinfo_to_sql.o(.text+0x25a6):mysql_tzinfo_to_sql.cc: undefined 
reference to `close_thread_tables(THD*, bool, bool)'
mysql_tzinfo_to_sql.o(.text+0x25d8):mysql_tzinfo_to_sql.cc: undefined 
reference to `THD::store_globals()'
mysql_tzinfo_to_sql.o(.text+0x25f6):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x2615):mysql_tzinfo_to_sql.cc: undefined 
reference to `THR_THD'
mysql_tzinfo_to_sql.o(.text+0x262f):mysql_tzinfo_to_sql.cc: undefined 
reference to `THR_MALLOC'
mysql_tzinfo_to_sql.o(.text+0x2645):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x268b):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x26de):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x2748):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x2770):mysql_tzinfo_to_sql.cc: undefined 
reference to `sql_print_error(char const*, ...)'
mysql_tzinfo_to_sql.o(.text+0x28cb): In function 
`my_tz_find_with_opening_tz_tables(THD*, String const*)':
mysql_tzinfo_to_sql.cc: undefined reference to 
`simple_open_n_lock_tables(THD*, st_table_list*)'
mysql_tzinfo_to_sql.o(.text+0x28fd):mysql_tzinfo_to_sql.cc: undefined 
reference to `close_thread_tables(THD*, bool, bool)'

collect2: ld returned 1 exit status
make[4]: *** [mysql_tzinfo_to_sql] Error 1
make[4]: Leaving directory `/home/dhutty/build/mysql-5.1.14-beta/sql'
make[3]: *** [all-recursive] Error 1
make[3]: Leaving directory `/home/dhutty/build/mysql-5.1.14-beta/sql'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/home/dhutty/build/mysql-5.1.14-beta/sql