Bug #31205 Crash when running 'rpl' tests between 5.1.20 master and 5.1.22 slave
Submitted: 26 Sep 2007 10:29 Modified: 18 Jun 2008 10:55
Reporter: Kent Boortz Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S2 (Serious)
Version:5.1.22 OS:Solaris (10 Sparc 64 bit)
Assigned to: Alexander Nozdrin CPU Architecture:Any

[26 Sep 2007 10:29] Kent Boortz
Description:
When running the 5.1.22 replication test using a 5.1.20 master,
the 5.1.22 slave is crashing with

(dbx) threads
 >    t@1  a  l@1   ?()   LWP suspended in  __pollsys()
      t@2  a  l@2   remove_table_from_cache()   sleep on 0x1012f08e8  in  __lwp_park()
      t@3  a  l@3   remove_table_from_cache()   sleep on 0x1012f0970  in  __lwp_park()
      t@4  a  l@4   remove_table_from_cache()   sleep on 0x1012f09f8  in  __lwp_park()
      t@5  a  l@5   remove_table_from_cache()   sleep on 0x1012f0a80  in  __lwp_park()
      t@6  a  l@6   setup_conds()   LWP suspended in  __pollsys()
      t@7  a  l@7   fill_record()   LWP suspended in  __pollsys()
      t@8  a  l@8   fill_record_n_invoke_before_triggers()   sleep on 0x100cdac68  in  __lwp_park()
      t@9  b  l@9   get_text()   LWP suspended in  ___sigtimedwait()
     t@39  b l@39   mysql_ha_close()   LWP suspended in  _read()
o    t@40  b l@40   mysql_ha_close()   signal SIGBUS in  __lwp_kill()
     t@41  b l@41   mysql_ha_close()   LWP suspended in  _read()
     t@42  b l@42   mysql_ha_close()   sleep on 0x100819140  in  __lwp_park()
(dbx) thread t@40
t@40 (l@40) stopped in __lwp_kill at 0xffffffff7dcca124
0xffffffff7dcca124: __lwp_kill+0x0008:  bcc,a,pt  %icc,__lwp_kill+0x18  ! 0xffffffff7dcca134
(dbx) where
current thread: t@40
=>[1] __lwp_kill(0x0, 0xa, 0xffffffff7ddeae40, 0x1009638ac, 0xffffffff7cf02c00, 0x4), at 0xffffffff7dcca124
  [2] 0x100365538(0xa, 0xffffffffffffffff, 0x100, 0x10096b000, 0x10096b, 0x0), at 0x100365537
  [3] get_quoted_token(0xa, 0x150818, 0x1005da490, 0x100963880, 0x399fb48, 0x2a103), at 0x100213c9c
  [4] __sighndlr(0xa, 0x0, 0xffffffff7be3ce00, 0x1002139e4, 0x0, 0x0), at 0xffffffff7dcc9030
  ---- called from signal handler with signal 10 (SIGBUS) ------
  [5] build_table_filename(0xffffffff7be3d298, 0x1035ad970, 0x1, 0x1035ad970, 0x10, 0x0), at 0x10051c190
  [6] Create_func_coercibility::Create_func_coercibility(0xffffffff7be3d460, 0x9240, 0x103565768, 0xffffffff7be3d298, 0xc, 0xffffffffffffffff), at 0x1002ee0f8
  [7] 0x1002ee990(0x1, 0x1035ada90, 0x120, 0x12, 0x6, 0x18), at 0x1002ee98f
  [8] Create_func_field::Create_func_field(0x103541740, 0x3331, 0x5550, 0xffffffff7be3d5c0, 0x14, 0xc), at 0x1002ec664
  [9] cmp_item_sort_string_in_static::make_same(0x103541740, 0x10362b848, 0x40, 0x103543200, 0x2710, 0x0), at 0x1002a91e8
  [10] 0x100227b24(0x103541740, 0x100400, 0x1400, 0x1400, 0x10362b848, 0x10362b848), at 0x100227b23
  [11] get_full_part_id_from_key(0x103541740, 0x10362b750, 0x25, 0xffffffff7be3fd28, 0x103542bf8, 0x1400), at 0x100229a40
  [12] 0x1002206b4(0x100964000, 0x103541740, 0x25, 0x10362b750, 0x100964, 0x1420), at 0x1002206b3
  [13] mysql_ha_close(0x103541740, 0x1, 0x1007c7780, 0x100967120, 0xffffffff7be3ff48, 0x1420), at 0x10021ec1c

How to repeat:
See bug#31204 for details about the setup and how to reproduce.
[18 Jun 2008 10:55] Konstantin Osipov
I believe this is not relevant any more. Please reopen otherwise.