MySQL-4.1 keep crashing with latest bk pull

Hi,

How-to-repeat :

Don't know, seems to be a problem during JOIN::cleanup, after a call to a
query containing an UNION.

Various stack trace :

0x80aad31 handle_segfault + 481
0x82a4298 pthread_sighandler + 176
0xc70845 (?)
0x80dd6a8 join_free(JOIN*, bool) + 632
0x80d8bf6 JOIN::cleanup(THD*) + 70
0x814b7db st_select_lex_unit::cleanup() + 91
0x814a8bb mysql_union(THD*, st_lex*, select_result*, st_select_lex_unit*,
bool) + 59
0x80d5f71 handle_select(THD*, st_lex*, select_result*) + 113
0x80b8bc4 mysql_execute_command(THD*) + 644
0x80bd9c9 mysql_parse(THD*, char*, unsigned) + 249
0x80b7723 dispatch_command(enum_server_command, THD*, char*, unsigned) + 867
0x80b7375 do_command(THD*) + 133
0x80b6c31 handle_one_connection + 913
0x82a1cba pthread_start_thread + 218
0x82d5fda thread_start + 4

0x80aad31 handle_segfault + 481
0x82a4298 pthread_sighandler + 176
0x80dd698 join_free(JOIN*, bool) + 616
0x80d8bf6 JOIN::cleanup(THD*) + 70
0x814b7db st_select_lex_unit::cleanup() + 91
0x814a8bb mysql_union(THD*, st_lex*, select_result*, st_select_lex_unit*,
bool) + 59
0x80d5f71 handle_select(THD*, st_lex*, select_result*) + 113
0x80b8bc4 mysql_execute_command(THD*) + 644
0x80bd9c9 mysql_parse(THD*, char*, unsigned) + 249
0x80b7723 dispatch_command(enum_server_command, THD*, char*, unsigned) + 867
0x80b7375 do_command(THD*) + 133
0x80b6c31 handle_one_connection + 913
0x82a1cba pthread_start_thread + 218
0x82d5fda thread_start + 4

0x80aacf1 handle_segfault + 417
0x82a4298 pthread_sighandler + 176
0x8114903 end_read_record(st_read_record*) + 35
0x80dd64f join_free(JOIN*, bool) + 543
0x80d8bf6 JOIN::cleanup(THD*) + 70
0x814b7db st_select_lex_unit::cleanup() + 91
0x814a8bb mysql_union(THD*, st_lex*, select_result*, st_select_lex_unit*,
bool) + 59
0x80d5f71 handle_select(THD*, st_lex*, select_result*) + 113
0x80b8bb4 mysql_execute_command(THD*) + 628
0x80bd9c8 mysql_parse(THD*, char*, unsigned) + 248
0x80b7723 dispatch_command(enum_server_command, THD*, char*, unsigned) + 867
0x80b7375 do_command(THD*) + 133
0x80b6c31 handle_one_connection + 913
0x82a1cba pthread_start_thread + 218
0x82d5fda thread_start + 4

I switch back to 4.0 until the problem is fixed :)

Regards,
Jocelyn


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13663@lists.mysql.com
To unsubscribe, e-mail

Re: MySQL-4.1 keep crashing with latest bk pull

Jocelyn Fournier writes:
> Hi,
>
> How-to-repeat :
>
> Don't know, seems to be a problem during JOIN::cleanup, after a call to a
> query containing an UNION.
>
> Various stack trace :
>

[skip]

>
> I switch back to 4.0 until the problem is fixed :)
>
> Regards,
> Jocelyn

I just ran all tests with latest pull and all tests pass.

Try another pull and build MySQL with a script from BUILD subdir.

If mysql crashes then, just send us a query that crashes it.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13674@lists.mysql.com
To unsubscribe, e-mail

Re: MySQL-4.1 keep crashing with latest bk pull

Jocelyn Fournier writes:
> Hi,
>
> I'm already using the latest pull with the monty's change listed here :
>
> http://mysql.bkbits.net:8080/mysql-4.1/ChangeSet@-1d?nav=ind ex.html
>
> and I'm always building MySQL using ./BUILD/compile-pentium script ;)
>
> According to the log file, the kind of queries leads to a crash :
>
> Some pointers may be invalid and cause the dump to abort...
> thd->query at 0x8a49398 = /*!40001 (SELECT DISTINCT
> searchjoinhardwarefr4.numreponse FROM
> searchjoinhardwarefr4,searchmainhardwarefr4 WHERE
> searchjoinhardwarefr4.numreponse=searchmainhardwarefr4.numre ponse AND
> mot='free' AND topic='90021') UNION (SELECT DISTINCT
> searchjoinhardwarefr4.numreponse FROM
> searchjoinhardwarefr4,searchmainhardwarefr4 WHERE
> searchjoinhardwarefr4.numreponse=searchmainhardwarefr4.numre ponse AND
> id='17817' AND topic='90021') ORDER BY numreponse ASC LIMIT 1,1*/
> thd->thread_id=2255
>
> I'd try to run this query, and it returns *nothing* (not even a "empty set"
> result), so it perhaps could be linked to the use of /*!40001 */ ?
> Unfortunately, I'm currently not able to test it, I need to reinstall my
> personnal computer since my main server now runs with mysql-4.0.
>
> Regards,
> Jocelyn
>

Sorry, no luck:


ysql> /*!40001 (select distinct * from nazivi where broj> 5) union (select distinct * from nazivi where naziv > '' order by broj limit 1,1) */;
+------+-------+
| BROJ | NAZIV |
+------+-------+
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 2 | dva |
+------+-------+
5 rows in set (0.00 sec)

mysql> /*!40001 (select distinct * from nazivi where broj> 5) union all (select distinct * from nazivi where naziv > '' order by broj limit 1,1) */;
+------+-------+
| BROJ | NAZIV |
+------+-------+
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 2 | dva |
+------+-------+
5 rows in set (0.00 sec)


What else should I try ??


--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13679@lists.mysql.com
To unsubscribe, e-mail

Re: MySQL-4.1 keep crashing with latest bk pull

Hi,

I'm already using the latest pull with the monty's change listed here :

http://mysql.bkbits.net:8080/mysql-4.1/ChangeSet@-1d?nav=ind ex.html

and I'm always building MySQL using ./BUILD/compile-pentium script ;)

According to the log file, the kind of queries leads to a crash :

Some pointers may be invalid and cause the dump to abort...
thd->query at 0x8a49398 = /*!40001 (SELECT DISTINCT
searchjoinhardwarefr4.numreponse FROM
searchjoinhardwarefr4,searchmainhardwarefr4 WHERE
searchjoinhardwarefr4.numreponse=searchmainhardwarefr4.numre ponse AND
mot='free' AND topic='90021') UNION (SELECT DISTINCT
searchjoinhardwarefr4.numreponse FROM
searchjoinhardwarefr4,searchmainhardwarefr4 WHERE
searchjoinhardwarefr4.numreponse=searchmainhardwarefr4.numre ponse AND
id='17817' AND topic='90021') ORDER BY numreponse ASC LIMIT 1,1*/
thd->thread_id=2255

I'd try to run this query, and it returns *nothing* (not even a "empty set"
result), so it perhaps could be linked to the use of /*!40001 */ ?
Unfortunately, I'm currently not able to test it, I need to reinstall my
personnal computer since my main server now runs with mysql-4.0.

Regards,
Jocelyn



----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc:
Sent: Tuesday, February 04, 2003 7:13 PM
Subject: Re: MySQL-4.1 keep crashing with latest bk pull


> Jocelyn Fournier writes:
> > Hi,
> >
> > How-to-repeat :
> >
> > Don't know, seems to be a problem during JOIN::cleanup, after a call to
a
> > query containing an UNION.
> >
> > Various stack trace :
> >
>
> [skip]
>
> >
> > I switch back to 4.0 until the problem is fixed :)
> >
> > Regards,
> > Jocelyn
>
> I just ran all tests with latest pull and all tests pass.
>
> Try another pull and build MySQL with a script from BUILD subdir.
>
> If mysql crashes then, just send us a query that crashes it.
>
> --
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
> Join MySQL Users Conference and Expo:
> http://www.mysql.com/events/uc2003/
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13676@lists.mysql.com
To unsubscribe, e-mail

Re: MySQL-4.1 keep crashing with latest bk pull

Hi,

Well I don't know... Perhaps a purify/valgrind run to see if this isn't a
wrongly freed memory space ?

Regards,
Jocelyn


----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc: ;
Sent: Tuesday, February 04, 2003 7:54 PM
Subject: Re: MySQL-4.1 keep crashing with latest bk pull


> Jocelyn Fournier writes:
> > Hi,
> >
> > I'm already using the latest pull with the monty's change listed here :
> >
> > http://mysql.bkbits.net:8080/mysql-4.1/ChangeSet@-1d?nav=ind ex.html
> >
> > and I'm always building MySQL using ./BUILD/compile-pentium script ;)
> >
> > According to the log file, the kind of queries leads to a crash :
> >
> > Some pointers may be invalid and cause the dump to abort...
> > thd->query at 0x8a49398 = /*!40001 (SELECT DISTINCT
> > searchjoinhardwarefr4.numreponse FROM
> > searchjoinhardwarefr4,searchmainhardwarefr4 WHERE
> > searchjoinhardwarefr4.numreponse=searchmainhardwarefr4.numre ponse AND
> > mot='free' AND topic='90021') UNION (SELECT DISTINCT
> > searchjoinhardwarefr4.numreponse FROM
> > searchjoinhardwarefr4,searchmainhardwarefr4 WHERE
> > searchjoinhardwarefr4.numreponse=searchmainhardwarefr4.numre ponse AND
> > id='17817' AND topic='90021') ORDER BY numreponse ASC LIMIT 1,1*/
> > thd->thread_id=2255
> >
> > I'd try to run this query, and it returns *nothing* (not even a "empty
set"
> > result), so it perhaps could be linked to the use of /*!40001 */ ?
> > Unfortunately, I'm currently not able to test it, I need to reinstall my
> > personnal computer since my main server now runs with mysql-4.0.
> >
> > Regards,
> > Jocelyn
> >
>
> Sorry, no luck:
>
>
> ysql> /*!40001 (select distinct * from nazivi where broj> 5) union (select
distinct * from nazivi where naziv > '' order by broj limit 1,1) */;
> +------+-------+
> | BROJ | NAZIV |
> +------+-------+
> | 10 | |
> | 11 | |
> | 12 | |
> | 13 | |
> | 2 | dva |
> +------+-------+
> 5 rows in set (0.00 sec)
>
> mysql> /*!40001 (select distinct * from nazivi where broj> 5) union all
(select distinct * from nazivi where naziv > '' order by broj limit 1,1) */;
> +------+-------+
> | BROJ | NAZIV |
> +------+-------+
> | 10 | |
> | 11 | |
> | 12 | |
> | 13 | |
> | 2 | dva |
> +------+-------+
> 5 rows in set (0.00 sec)
>
>
> What else should I try ??
>
>
> --
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
> Join MySQL Users Conference and Expo:
> http://www.mysql.com/events/uc2003/
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13680@lists.mysql.com
To unsubscribe, e-mail

Re: MySQL-4.1 keep crashing with latest bk pull

On Tuesday 04 February 2003 13:59, Jocelyn Fournier wrote:

Hello Jocelyn,

Does this happen with all UNION commands, or could you show a test case for
it?

I use a lot of UNION calls in my regression tests for new php extension, but
I couldn't detect any instability/crashes...

Cause you was able to reproduce my bug (see memleak thread) a few weeks ago,
I think your installation or environment is buggy (as mine was).

Regards

Georg

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13691@lists.mysql.com
To unsubscribe, e-mail

Re: MySQL-4.1 keep crashing with latest bk pull

Georg Richter writes:
> On Tuesday 04 February 2003 13:59, Jocelyn Fournier wrote:
>
> Hello Jocelyn,
>
> Does this happen with all UNION commands, or could you show a test case for
> it?
>
> I use a lot of UNION calls in my regression tests for new php extension, but
> I couldn't detect any instability/crashes...
>
> Cause you was able to reproduce my bug (see memleak thread) a few weeks ago,
> I think your installation or environment is buggy (as mine was).
>
> Regards
>
> Georg
>

I do not get crashes with UNION's only wrong results in 4.1.

Will fix it as soon as possible.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13703@lists.mysql.com
To unsubscribe, e-mail