Assertion failure for libmysqld on Tru64

Assertion failure for libmysqld on Tru64

am 09.10.2002 23:13:16 von Randall Severy

How-To-Repeat:

Ever since MySQL 4.0.1 was released I've been trying to build a
working libmysqld embedded MySQL library on the Compaq Tru64 (formerly Dec
OSF) platform. With each successive bugfix release I've tried again, and
just did with 4.0.4, but each time I run into a problem with the error
handling that causes a core dump when a database error occurs that
generates the following failed assertion:

Assertion failed: vio->packets, file lib_vio.c, line 118

The stack trace from the latest test is as follows:

>0 0x3ff8057d728 in __nxm_thread_kill(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ff
c0184000) in /usr/shlib/libpthread.so
#1 0x3ff80576560 in pthread_kill(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ffc0184
000) in /usr/shlib/libpthread.so
#2 0x3ff80581ae8 in UnknownProcedure2FromFile99(0x3ffc01842c8, 0x6, 0x1,
0x1, 0
x14, 0x3ffc0184000) in /usr/shlib/libpthread.so
#3 0x3ff807e3aa0 in UnknownProcedure16FromFile0(0x3ffc01842c8, 0x6, 0x1,
0x1, 0
x14, 0x3ffc0184000) in /usr/shlib/libexc.so
#4 0x3ff807e3e90 in exc_raise_signal_exception(0x3ffc01842c8, 0x6, 0x1,
0x1, 0x
14, 0x3ffc0184000) in /usr/shlib/libexc.so
#5 0x3ff80578040 in UnknownProcedure282FromFile0(0x3ffc01842c8, 0x6, 0x1, 0x1,
0x14, 0x3ffc0184000) in /usr/shlib/libpthread.so
#6 0x3ff800d5270 in __sigtramp(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ffc018400
0) in /usr/shlib/libc.so
#7 0x3ff8057d728 in __nxm_thread_kill(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ff
c0184000) in /usr/shlib/libpthread.so
#8 0x3ff80576560 in pthread_kill(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ffc0184
000) in /usr/shlib/libpthread.so
#9 0x3ff8058da08 in UnknownProcedure6FromFile108(0x3ffc01842c8, 0x6, 0x1, 0x1,
0x14, 0x3ffc0184000) in /usr/shlib/libpthread.so
#10 0x3ff8013b0b4 in __tis_raise(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ffc01840
00) in /usr/shlib/libc.so
#11 0x3ff8019f570 in raise(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ffc0184000) in
/usr/shlib/libc.so
#12 0x3ff801c2800 in abort(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ffc0184000) in
/usr/shlib/libc.so
#13 0x3ff801c22b0 in __assert(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ffc0184000)
in /usr/shlib/libc.so
#14 0x120176d90 in vio_read(vio=0x14089d000,
buf=0x140896000="\377z\004Table \'w
sd.wsd_user_prefs\' doesn\'t exist", siz
#15 0x1201b2c14 in my_real_read(net=0x140048b70, complen=0x11fffad30)
"net_serv.
cc":534
#16 0x1201b3134 in my_net_read(net=0x140
#17 0x120178cc0 in net_safe_read(mysql=0x140048b70) "libmysqld.c":95
#18 0x12017a190 in read_rows(mysql=0x140048b70, mysql_fields=0x0, fields=5)
"lib
mysqld.c":620
#19 0x12017be4c in mysql_read_query_result(mysql=0x140048b70)
"libmysqld.c":1164
#20 0x12017c330 in mysql_real_query(mysql=0x140048b70,
query=0x140060980="select
userid,prefid,prefvalue from wsd_user_prefs where userid=\'\'",
length=66) "lib
mysqld.c":1285
#21 0x12017bbf8 in mysql_query(mysql=0x140048b70, query=0x140060980="select
user
id,prefid,prefvalue from wsd_user_prefs where userid=\'\'") "libmysqld.c":1117
#22 0x120148c30 in select_db_fields(0x3ffc01842c8, 0x6, 0x1, 0x1, 0x14,
0x3ffc01
84000) in wsd

I have posted messages about this problem to mysql@lists.mysql.com
several times during the spring and summer, and had a detailed conversation
with Dan Nelson on that list in August that helped isolate the specific
problem, but no one has been able to identify a solution to the problem.

Best Regards,

Randall Severy
CyberTeams, Inc.

Randall Severy severy@cyberteams.com http://www.cyberteams.com/severy
CyberTeams, Inc. info@cyberteams.com http://www.cyberteams.com
Frederick, MD
(301) 682-8885 "Building effective teams in cyberspace"
1-888-832-5575



------------------------------------------------------------ ---------
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-thread12686@lists.mysql.com
To unsubscribe, e-mail

Assertion failure for libmysqld on Tru64

am 15.10.2002 16:44:33 von Michael Widenius

Hi!

>>>>> "Randall" == Randall Severy writes:

Randall> How-To-Repeat:
Randall> Ever since MySQL 4.0.1 was released I've been trying to build a
Randall> working libmysqld embedded MySQL library on the Compaq Tru64 (formerly Dec
Randall> OSF) platform. With each successive bugfix release I've tried again, and
Randall> just did with 4.0.4, but each time I run into a problem with the error
Randall> handling that causes a core dump when a database error occurs that
Randall> generates the following failed assertion:

Randall> Assertion failed: vio->packets, file lib_vio.c, line 118



Have you tried if the test programs in libmysqld/examples compiles and
works on your machine ?

Do you have a test program that shows this behaviour that you could
share with us so that we can try to repeat this ?

Another option is if you could let us login to your system and try to
debug this.

The assert in lib_vio.c indicates that something strange is going on,
but it doesn't tell us what it could be and how to fix this.



Randall> sd.wsd_user_prefs\' doesn\'t exist", siz
Randall> #15 0x1201b2c14 in my_real_read(net=0x140048b70, complen=0x11fffad30)
Randall> "net_serv.

Does the above table exists ?

There could be some bug in the error handling for the embedded library
that we are not aware of...

Regards,
Monty

--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com

------------------------------------------------------------ ---------
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-thread12731@lists.mysql.com
To unsubscribe, e-mail

Re: Assertion failure for libmysqld on Tru64

am 15.10.2002 19:14:46 von Randall Severy

At 05:44 PM 10/15/2002 +0300, Michael Widenius wrote:
>Have you tried if the test programs in libmysqld/examples compiles and
>works on your machine ?
>
>Do you have a test program that shows this behaviour that you could
>share with us so that we can try to repeat this ?

Monty,

I'll see if I can duplicate the problem with one of the test programs
in libmysqld/examples.

>Randall> sd.wsd_user_prefs\' doesn\'t exist", siz
>Randall> #15 0x1201b2c14 in my_real_read(net=0x140048b70,
>complen=0x11fffad30)
>Randall> "net_serv.
>
>Does the above table exists ?
>
>There could be some bug in the error handling for the embedded library
>that we are not aware of...

No, the above table does not exist. Both times I have received the
assertion failed error it has occurred during the error handling in the
embedded library, so your guess may be correct.

Regards,

Randall


Randall Severy severy@cyberteams.com http://www.cyberteams.com/severy
CyberTeams, Inc. info@cyberteams.com http://www.cyberteams.com
Frederick, MD
(301) 682-8885 "Building effective teams in cyberspace"
1-888-832-5575



------------------------------------------------------------ ---------
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-thread12735@lists.mysql.com
To unsubscribe, e-mail

Re: Assertion failure for libmysqld on Tru64

am 15.10.2002 20:08:06 von Randall Severy

At 05:44 PM 10/15/2002 +0300, Michael Widenius wrote:
>Do you have a test program that shows this behaviour that you could
>share with us so that we can try to repeat this ?

Monty,

Here is the shortest test program I could come up with that
duplicates the problem:

------------------------------------------------------------ -------------------
/*
testmysqld.c - Test program to duplicate assertion error on Tru64
Written 2002 Randall Severy, CyberTeams, Inc.
*/
#include
#include
#include
#include "mysql.h"

static MYSQL connect_socket;

int main(int argc,char **argv)
{
MYSQL *db_socket;
char *init_args[3] = {"","--datadir=./db","--language=."};

mysql_server_init(3,init_args,NULL);
db_socket = mysql_real_connect(&connect_socket,NULL,NULL,NULL,
"testdb",0,NULL,0);
mysql_query(db_socket,"drop table test");
mysql_close(db_socket);
mysql_server_end();
return(0);
}
------------------------------------------------------------ -------------------

The output from this test program is the same as the original program
(Assertion failed: vio->packets, file lib_vio.c, line 118). The "test"
table used in the above example does not exist. The test program never
gets past the "mysql_query" call. Interestingly enough, in setting up this
test I found that if the directory specified by "datadir" does not exist
that the test program crashes with a seg fault error.

>Another option is if you could let us login to your system and try to
>debug this.

I'm doing this testing on one of Compaq's Tru64 "Test Drive"
servers. If you need to get in there to debug this I can send you the
login information.

Best Regards,

Randall


Randall Severy severy@cyberteams.com http://www.cyberteams.com/severy
CyberTeams, Inc. info@cyberteams.com http://www.cyberteams.com
Frederick, MD
(301) 682-8885 "Building effective teams in cyberspace"
1-888-832-5575



------------------------------------------------------------ ---------
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-thread12739@lists.mysql.com
To unsubscribe, e-mail

Re: Assertion failure for libmysqld on Tru64

am 11.11.2002 14:21:48 von Michael Widenius

Hi!

>>>>> "Randall" == Randall Severy writes:



>> Do you have a test program that shows this behaviour that you could
>> share with us so that we can try to repeat this ?

Randall> Monty,

Randall> Here is the shortest test program I could come up with that
Randall> duplicates the problem:



Ramil, what is the status of this bug ?

I haven't seen any response from you to Randall about this...

Regards,
Monty

------------------------------------------------------------ ---------
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-thread12955@lists.mysql.com
To unsubscribe, e-mail

Re[2]: Assertion failure for libmysqld on Tru64

am 12.11.2002 09:36:01 von Ramil Kalimullin

Hello Michael,

Monday, November 11, 2002, 5:21:48 PM, you wrote:


MW> Hi!

>>>>>> "Randall" == Randall Severy writes:

MW>

>>> Do you have a test program that shows this behaviour that you could
>>> share with us so that we can try to repeat this ?

Randall>> Here is the shortest test program I could come up with that
Randall>> duplicates the problem:

MW>

MW> Ramil, what is the status of this bug ?
MW> I haven't seen any response from you to Randall about this...

Holyfoot is in charge of this problem.
HF, could you describe the current status, please?

Regards,
Ramil.
--
For technical support contracts, visit https://order.mysql.com/?ref=mrka
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Ramil Kalimullin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia
<___/ www.mysql.com


------------------------------------------------------------ ---------
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-thread12962@lists.mysql.com
To unsubscribe, e-mail

Re: Assertion failure for libmysqld on Tru64

am 12.11.2002 11:54:23 von Holyfoot

> what is the status of this bug ?
> I haven't seen any response from you to Randall about this...

There was problems in compiling MySQL on Tru64 I had.
I followed instructions from Randall and LenZ, but still result was
improper.
mysqld I got just falls out with signal 11, and I can't build
libmysqld/examples.
On this stage I postponed this thinking that other tasks are of more
importance.

I guess I should get to this problem again cooperating with LenZ.

HF
__
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexey Botchkov
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia
<___/ www.mysql.com


------------------------------------------------------------ ---------
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-thread12963@lists.mysql.com
To unsubscribe, e-mail