Sure thing. I'll have the bug updated sometime this weekend.
Many thanks for your help on these bugs!
On Sat, Jul 3, 2010 at 3:59 AM, Prafulla Tekawade < <email address hidden>> wrote:
> Hi Patrick, > I have pushed fix for this bug at > https://code.launchpad.net/~prafulla-tekawade/drizzle/dr-bug-600664 > > Can you please take a look at it? > > > ** Changed in: drizzle > Assignee: (unassigned) => Prafulla Tekawade (prafulla-tekawade) > > ** Branch linked: lp:~prafulla-tekawade/drizzle/dr-bug-600664 > > ** Changed in: drizzle > Status: Confirmed => In Progress > > -- > Crash / segfault in drizzled::optimizer::add_key_part (keyuse_array=<value > optimized out>, key_field=0x2d0dc28) at drizzled/optimizer/key_field.cc:63 > https://bugs.launchpad.net/bugs/600664 > You received this bug notification because you are a direct subscriber > of the bug. > > Status in A Lightweight SQL Database for Cloud and Web: In Progress > > Bug description: > Crashing bug / segfault: > in drizzled::optimizer::add_key_part (keyuse_array=<value optimized out>, > key_field=0x2d0dc28) at drizzled/optimizer/key_field.cc:63 > > Test case on the way > > Backtrace: > #0 0x0000000000000000 in ?? () > #1 0x00000000005aeb7c in drizzled::optimizer::add_key_part > (keyuse_array=<value optimized out>, key_field=0x2d0dc28) at > drizzled/optimizer/key_field.cc:63 > #2 0x0000000000617781 in drizzled::update_ref_and_keys (session=<value > optimized out>, keyuse=0x2d0ae18, join_tab=0x2d48738, tables=<value > optimized out>, > cond=<value optimized out>, normal_tables=18446744073709551615, > select_lex=0x2c54940, sargables=...) at drizzled/sql_select.cc:596 > #3 0x0000000000594eed in make_join_statistics (join=0x2d09858, tables=0x0, > conds=<value optimized out>, keyuse_array=<value optimized out>) at > drizzled/join.cc:5610 > #4 0x00000000005964f1 in drizzled::Join::optimize (this=0x2d09858) at > drizzled/join.cc:565 > #5 0x0000000000577ca2 in drizzled::subselect_single_select_engine::exec > (this=0x2c55490) at drizzled/item/subselect.cc:2148 > #6 0x000000000057a128 in drizzled::Item_subselect::exec (this=0x2c55350) > at drizzled/item/subselect.cc:299 > #7 drizzled::Item_in_subselect::exec (this=0x2c55350) at > drizzled/item/subselect.cc:348 > #8 0x0000000000577547 in drizzled::Item_in_subselect::val_bool > (this=0x2c55350) at drizzled/item/subselect.cc:907 > #9 0x000000000055550c in drizzled::Item_in_optimizer::val_int > (this=0x2c87480) at drizzled/item/cmpfunc.cc:1597 > #10 0x000000000054d6bc in drizzled::Item::val_bool (this=0x2c87480) at > drizzled/item.cc:94 > #11 0x0000000000554a79 in drizzled::Item_cond_and::val_int (this=0x2d0c7b8) > at drizzled/item/cmpfunc.cc:4203 > #12 0x000000000054d6bc in drizzled::Item::val_bool (this=0x2d0c7b8) at > drizzled/item.cc:94 > #13 0x00000000005549e9 in drizzled::Item_cond_or::val_int (this=0x2d0c6d0) > at drizzled/item/cmpfunc.cc:4221 > #14 0x00000000005b6df8 in drizzled::optimizer::SqlSelect::skip_record > (this=<value optimized out>) at drizzled/optimizer/range.cc:423 > #15 0x000000000058d349 in drizzled::flush_cached_records (join=0x2d07878, > join_tab=0x2d0b220, skip_last=<value optimized out>) at > drizzled/join.cc:2698 > #16 0x00000000006133f7 in drizzled::sub_select_cache (join=0x2d07878, > join_tab=0x2d0b220, end_of_records=<value optimized out>) at > drizzled/sql_select.cc:3384 > #17 0x0000000000617e70 in drizzled::do_select (join=0x2d07878, fields=0x0, > table=0x2d30bb8) at drizzled/sql_select.cc:3335 > #18 0x0000000000592a97 in drizzled::Join::exec (this=0x2d07878) at > drizzled/join.cc:1349 > #19 0x00000000006145f2 in drizzled::mysql_select (session=0x7fe4183a36c0, > rref_pointer_array=<value optimized out>, tables=0x2c53e20, wild_num=0, > fields=<value optimized out>, > conds=<value optimized out>, og_num=2, order=0x2c86518, group=0x0, > having=0x0, select_options=2147500033, result=0x2c870a0, > unit=0x7fe4183a4130, select_lex=0x7fe4183a4330) > at drizzled/sql_select.cc:427 > #20 0x0000000000614ef0 in drizzled::handle_select (session=0x7fe4183a36c0, > lex=0x7fe4183a4110, result=0x2c870a0, setup_tables_done_option=0) at > drizzled/sql_select.cc:146 > #21 0x000000000060ea65 in drizzled::execute_sqlcom_select > (session=0x7fe4183a36c0, all_tables=0x2c53e20) at drizzled/sql_parse.cc:543 > #22 0x000000000060e6ce in mysql_execute_command (session=0x7fe4183a36c0, > inBuf=<value optimized out>, length=<value optimized out>) at > drizzled/sql_parse.cc:478 > #23 drizzled::mysql_parse (session=0x7fe4183a36c0, inBuf=<value optimized > out>, length=<value optimized out>) at drizzled/sql_parse.cc:736 > #24 0x00000000006108c2 in drizzled::dispatch_command > (command=drizzled::COM_QUERY, session=0x7fe4183a36c0, > packet=0x7fe41839d391 "SELECT DISTINCT AVG(DISTINCT OUTR . > `col_int_not_null` ) AS X FROM BB AS OUTR2 LEFT JOIN BB AS OUTR ON ( OUTR2 . > `col_text` <= OUTR . `col_text_key` ) WHERE ( OUTR . `col_text_not_null` , > OUTR . `col_"..., packet_length=<value optimized out>) at > drizzled/sql_parse.cc:223 > #25 0x00000000005e18df in drizzled::Session::executeStatement > (this=0x7fe4183a36c0) at drizzled/session.cc:646 > ---Type <return> to continue, or q <return> to quit--- > #26 0x00000000005e3e12 in drizzled::Session::run (this=0x7fe4183a36c0) at > drizzled/session.cc:505 > #27 0x00007fe431586083 in MultiThreadScheduler::runSession (arg=<value > optimized out>) at ./plugin/multi_thread/multi_thread.h:67 > #28 session_thread (arg=<value optimized out>) at > plugin/multi_thread/multi_thread.cc:43 > #29 0x00007fe4353549ca in start_thread (arg=<value optimized out>) at > pthread_create.c:300 > #30 0x00007fe4350b26cd in clone () at > ../sysdeps/unix/sysv/linux/x86_64/clone.S:112 > #31 0x0000000000000000 in ?? () > > To unsubscribe from this bug, go to: > https://bugs.launchpad.net/drizzle/+bug/600664/+subscribe >
Sure thing. I'll have the bug updated sometime this weekend.
Many thanks for your help on these bugs!
On Sat, Jul 3, 2010 at 3:59 AM, Prafulla Tekawade <
<email address hidden>> wrote:
> Hi Patrick, /code.launchpad .net/~prafulla- tekawade/ drizzle/ dr-bug- 600664 :optimizer: :add_key_ part (keyuse_ array=< value 0x2d0dc28) at drizzled/ optimizer/ key_field. cc:63 /bugs.launchpad .net/bugs/ 600664 :optimizer: :add_key_ part (keyuse_ array=< value optimized out>, 0x2d0dc28) at drizzled/ optimizer/ key_field. cc:63 :optimizer: :add_key_ part array=< value optimized out>, key_field= 0x2d0dc28) at optimizer/ key_field. cc:63 :update_ ref_and_ keys (session=<value tables= 184467440737095 51615, lex=0x2c54940, sargables=...) at drizzled/ sql_select. cc:596 statistics (join=0x2d09858, tables=0x0, join.cc: 5610 :Join:: optimize (this=0x2d09858) at join.cc: 565 :subselect_ single_ select_ engine: :exec item/subselect. cc:2148 :Item_subselect ::exec (this=0x2c55350) item/subselect. cc:299 :Item_in_ subselect: :exec (this=0x2c55350) at item/subselect. cc:348 :Item_in_ subselect: :val_bool item/subselect. cc:907 :Item_in_ optimizer: :val_int item/cmpfunc. cc:1597 :Item:: val_bool (this=0x2c87480) at :Item_cond_ and::val_ int (this=0x2d0c7b8) item/cmpfunc. cc:4203 :Item:: val_bool (this=0x2d0c7b8) at :Item_cond_ or::val_ int (this=0x2d0c6d0) item/cmpfunc. cc:4221 :optimizer: :SqlSelect: :skip_record optimizer/ range.cc: 423 :flush_ cached_ records (join=0x2d07878, join.cc: 2698 :sub_select_ cache (join=0x2d07878, records= <value optimized out>) at sql_select. cc:3384 sql_select. cc:3335 :Join:: exec (this=0x2d07878) at join.cc: 1349 :mysql_ select (session= 0x7fe4183a36c0, array=< value optimized out>, tables=0x2c53e20, wild_num=0, options= 2147500033, result=0x2c870a0, 4130, select_ lex=0x7fe4183a4 330) sql_select. cc:427 :handle_ select (session= 0x7fe4183a36c0, done_option= 0) at sql_select. cc:146 :execute_ sqlcom_ select 0x7fe4183a36c0, all_tables= 0x2c53e20) at drizzled/ sql_parse. cc:543 command (session= 0x7fe4183a36c0, sql_parse. cc:478 :mysql_ parse (session= 0x7fe4183a36c0, inBuf=<value optimized sql_parse. cc:736 :dispatch_ command drizzled: :COM_QUERY, session= 0x7fe4183a36c0, 0x7fe41839d391 "SELECT DISTINCT AVG(DISTINCT OUTR . length= <value optimized out>) at sql_parse. cc:223 :Session: :executeStateme nt a36c0) at drizzled/ session. cc:646 :Session: :run (this=0x7fe4183 a36c0) at session. cc:505 duler:: runSession (arg=<value multi_thread/ multi_thread. h:67 multi_thread/ multi_thread. cc:43 create. c:300 unix/sysv/ linux/x86_ 64/clone. S:112 /bugs.launchpad .net/drizzle/ +bug/600664/ +subscribe
> I have pushed fix for this bug at
> https:/
>
> Can you please take a look at it?
>
>
> ** Changed in: drizzle
> Assignee: (unassigned) => Prafulla Tekawade (prafulla-tekawade)
>
> ** Branch linked: lp:~prafulla-tekawade/drizzle/dr-bug-600664
>
> ** Changed in: drizzle
> Status: Confirmed => In Progress
>
> --
> Crash / segfault in drizzled:
> optimized out>, key_field=
> https:/
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in A Lightweight SQL Database for Cloud and Web: In Progress
>
> Bug description:
> Crashing bug / segfault:
> in drizzled:
> key_field=
>
> Test case on the way
>
> Backtrace:
> #0 0x0000000000000000 in ?? ()
> #1 0x00000000005aeb7c in drizzled:
> (keyuse_
> drizzled/
> #2 0x0000000000617781 in drizzled:
> optimized out>, keyuse=0x2d0ae18, join_tab=0x2d48738, tables=<value
> optimized out>,
> cond=<value optimized out>, normal_
> select_
> #3 0x0000000000594eed in make_join_
> conds=<value optimized out>, keyuse_array=<value optimized out>) at
> drizzled/
> #4 0x00000000005964f1 in drizzled:
> drizzled/
> #5 0x0000000000577ca2 in drizzled:
> (this=0x2c55490) at drizzled/
> #6 0x000000000057a128 in drizzled:
> at drizzled/
> #7 drizzled:
> drizzled/
> #8 0x0000000000577547 in drizzled:
> (this=0x2c55350) at drizzled/
> #9 0x000000000055550c in drizzled:
> (this=0x2c87480) at drizzled/
> #10 0x000000000054d6bc in drizzled:
> drizzled/item.cc:94
> #11 0x0000000000554a79 in drizzled:
> at drizzled/
> #12 0x000000000054d6bc in drizzled:
> drizzled/item.cc:94
> #13 0x00000000005549e9 in drizzled:
> at drizzled/
> #14 0x00000000005b6df8 in drizzled:
> (this=<value optimized out>) at drizzled/
> #15 0x000000000058d349 in drizzled:
> join_tab=0x2d0b220, skip_last=<value optimized out>) at
> drizzled/
> #16 0x00000000006133f7 in drizzled:
> join_tab=0x2d0b220, end_of_
> drizzled/
> #17 0x0000000000617e70 in drizzled::do_select (join=0x2d07878, fields=0x0,
> table=0x2d30bb8) at drizzled/
> #18 0x0000000000592a97 in drizzled:
> drizzled/
> #19 0x00000000006145f2 in drizzled:
> rref_pointer_
> fields=<value optimized out>,
> conds=<value optimized out>, og_num=2, order=0x2c86518, group=0x0,
> having=0x0, select_
> unit=0x7fe4183a
> at drizzled/
> #20 0x0000000000614ef0 in drizzled:
> lex=0x7fe4183a4110, result=0x2c870a0, setup_tables_
> drizzled/
> #21 0x000000000060ea65 in drizzled:
> (session=
> #22 0x000000000060e6ce in mysql_execute_
> inBuf=<value optimized out>, length=<value optimized out>) at
> drizzled/
> #23 drizzled:
> out>, length=<value optimized out>) at drizzled/
> #24 0x00000000006108c2 in drizzled:
> (command=
> packet=
> `col_int_not_null` ) AS X FROM BB AS OUTR2 LEFT JOIN BB AS OUTR ON ( OUTR2 .
> `col_text` <= OUTR . `col_text_key` ) WHERE ( OUTR . `col_text_not_null` ,
> OUTR . `col_"..., packet_
> drizzled/
> #25 0x00000000005e18df in drizzled:
> (this=0x7fe4183
> ---Type <return> to continue, or q <return> to quit---
> #26 0x00000000005e3e12 in drizzled:
> drizzled/
> #27 0x00007fe431586083 in MultiThreadSche
> optimized out>) at ./plugin/
> #28 session_thread (arg=<value optimized out>) at
> plugin/
> #29 0x00007fe4353549ca in start_thread (arg=<value optimized out>) at
> pthread_
> #30 0x00007fe4350b26cd in clone () at
> ../sysdeps/
> #31 0x0000000000000000 in ?? ()
>
> To unsubscribe from this bug, go to:
> https:/
>