Wow, just looked at mysql-trunk. I will backport from there.

I don't trust my fix either as I never use code in this area.

On Tue, Feb 1, 2011 at 7:02 PM, Yasufumi Kinoshita
<email address hidden> wrote:
> Thank you.
>
> I knew the something wrong with the innodb_show_sys_tables.patch which was made by another.
> But it was added to XtraDB forcibly against my anxiety at the time.
> Also I don't know whether your fix is enough or not, for now.
>
> I think, ideally, the code about the i_s should be backported from the InnoDB at official MySQL-5.5.6.
> Because it seems much more stable from the innodb_show_sys_tables.patch for 5.1.
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/711532
>
> Title:
>  crash from select from IS.INNODB_SYS_TABLES
>
> Status in Percona Server with XtraDB:
>  New
>
> Bug description:
>  select from IS.INNODB_SYS_TABLES crashes the server using Percona-
>  Server-5.1.54-rel12.5
>
>  Why are there are no tests in mysql-test for this feature?
>
>  1) add this to the end of mysql-test/suite/innodb_plugin/t/innodb.test
>   select * from INNODB_SYS_TABLES;
>  2) run that test
>  3) segfault
>
>  The crash happens on the next iteration of the for loop in i_s_innodb_schema_table_fill after executing this code:
>                  if (rec_get_deleted_flag(rec, 0)) {
>                          /* record marked as deleted */
>                          btr_pcur_close(&pcur);
>                          mtr_commit(&mtr);
>                          continue;
>                  }
>
>  The crash stack:
>
>  #0  0x00007f3fa9539cfc in pthread_kill () from /lib/libpthread.so.0
>  #0  0x00007f3fa9539cfc in pthread_kill () from /lib/libpthread.so.0
>  #1  0x0000000000a2153e in my_write_core (sig=11) at stacktrace.c:333
>  #2  0x0000000000604b6b in handle_segfault (sig=11) at mysqld.cc:2652
>  #3  <signal handler called>
>  #4  0x000000000087f805 in mach_read_from_2 (b=0x2a <Address 0x2a out of bounds>) at ./include/mach0data.ic:84
>  #5  0x000000000087ff84 in page_header_get_field (page=0x0, field=4) at ./include/page0page.ic:119
>  #6  0x000000000087ffa3 in page_is_comp (page=0x0) at ./include/page0page.ic:238
>  #7  0x000000000087ffca in page_rec_is_comp (rec=0x0) at ./include/page0page.ic:250
>  #8  0x00000000008801f7 in page_rec_get_next (rec=0x0) at ./include/page0page.ic:739
>  #9  0x00000000008802ca in page_cur_move_to_next (cur=0x7f3f96c2e248) at ./include/page0cur.ic:185
>  #10 0x0000000000880494 in btr_pcur_move_to_next_on_page (cursor=0x7f3f96c2e240) at ./include/btr0pcur.ic:288
>  #11 0x0000000000880522 in btr_pcur_move_to_next_user_rec (cursor=0x7f3f96c2e240, mtr=0x7f3f96c2e370) at ./include/btr0pcur.ic:352
>  #12 0x00000000008862e9 in i_s_innodb_schema_table_fill (thd=0x27c18d0, tables=0x1b73300, cond=0x0) at handler/i_s.cc:3629
>  #13 0x00000000007c3924 in get_schema_tables_result (join=0x27c45c0, executed_place=PROCESSED_BY_JOIN_EXEC) at sql_show.cc:6715
>  #14 0x000000000068e5a2 in JOIN::exec (this=0x27c45c0) at sql_select.cc:1878
>  #15 0x0000000000690ce0 in mysql_select (thd=0x27c18d0, rref_pointer_array=0x27c3c08, tables=0x1b73300, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684635648, result=0x28009e0, unit=0x27c35d8, select_lex=0x27c3a10) at sql_select.cc:2565
>  #16 0x00000000006889fc in handle_select (thd=0x27c18d0, lex=0x27c3538, result=0x28009e0, setup_tables_done_option=0) at sql_select.cc:284
>  #17 0x0000000000621977 in execute_sqlcom_select (thd=0x27c18d0, all_tables=0x1b73300) at sql_parse.cc:5232
>  #18 0x0000000000618780 in mysql_execute_command (thd=0x27c18d0) at sql_parse.cc:2371
>  #19 0x00000000006240e7 in mysql_parse (thd=0x27c18d0, rawbuf=0x1b72cb0 "select * from INNODB_SYS_TABLES", length=31, found_semicolon=0x7f3f96c308b0) at sql_parse.cc:6210
>  #20 0x0000000000615d8e in dispatch_command (command=COM_QUERY, thd=0x27c18d0, packet=0x27d37d1 "select * from INNODB_SYS_TABLES", packet_length=31) at sql_parse.cc:1278
>  #21 0x0000000000614cef in do_command (thd=0x27c18d0) at sql_parse.cc:903
>  #22 0x0000000000612e92 in handle_one_connection (arg=0x27c18d0) at sql_connect.cc:1738
>  #23 0x00007f3fa9534971 in start_thread () from /lib/libpthread.so.0
>  #24 0x00007f3fa807a92d in clone () from /lib/libc.so.6
>  #25 0x0000000000000000 in ?? ()
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/percona-server/+bug/711532/+subscribe
>



-- 
Mark Callaghan
<email address hidden>