Re: InnoDB on FreeBSD-Alpha problem
heikki, Anyone i running MySQL with InnoDB on FreeBSD-Alpha? I get the mysqld compiling/running ok. DB dump is restored ok locally. Locally everything wirks. But it crashes on the incoming network connection. unaligned access: va=0x11fff784 pc=. I found the reason of this. It's because in file sql/mysqld.cc the functions fromhost(), hosts_access() and eval_client() were used w/out arguments. Declaration of those in tcpd.h is KR style -- also w/out arguments. But actual definitions in libwrap.so are with args. Linux folks should look at this line #if defined (__linux__) which lets these functions be used w/out arguments. Is this incorrect in Linux also? Yuri. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB on FreeBSD-Alpha problem
Yuri, - Original Message - From: Yuri [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, August 17, 2002 1:41 AM Subject: InnoDB on FreeBSD-Alpha problem Anyone i running MySQL with InnoDB on FreeBSD-Alpha? I get the mysqld compiling/running ok. DB dump is restored ok locally. Locally everything wirks. But it what do you mean with this? If you issue SQL statements from the same computer, they work ok? crashes on the incoming network connection. unaligned access: va=0x11fff784 pc=. If this only happens in an incoming network connection, then probably your network library is buggy. In Compaq Alpha C and C++ variables have to be aligned to machine addresses divisible by 4 or 8, which is not required in Intel x86. Looks like some variable in the library is not aligned. Anyone knows the solution? Thanx, Yuri. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB on FreeBSD-Alpha problem
Heikki, I get the mysqld compiling/running ok. DB dump is restored ok locally. Locally everything wirks. But it what do you mean with this? If you issue SQL statements from the same computer, they work ok? Exactly. If I connect via local UNIX socket all happily works. If I just connect via network it crashes right away. If this only happens in an incoming network connection, then probably your network library is buggy. In Compaq Alpha C and C++ variables have to be aligned to machine addresses divisible by 4 or 8, which is not required in Intel x86. Looks like some variable in the library is not aligned. It's no such thing as network library in FreeBSD. It's networking support in kernel. And it's perfectly ok. Whole bunch of other apps work w/out any problems. MySQL server app is crashing. It only started when I enabled InnoDB at compile time. Before it was no such problem. So somewhere I guess they mangle with addresses and use unaligned one. It happens on *network* level. So even telnet connection on 3306 crashes it. Not even in logon phase. Or early in logon phase. So it's a bug in MySQL somewhere. I will try to troubleshoot it down to the source code line. Yuri. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB on FreeBSD-Alpha problem
Yuri, - Original Message - From: Yuri [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, August 17, 2002 5:13 PM Subject: Re: InnoDB on FreeBSD-Alpha problem Heikki, I get the mysqld compiling/running ok. DB dump is restored ok locally. Locally everything wirks. But it what do you mean with this? If you issue SQL statements from the same computer, they work ok? Exactly. If I connect via local UNIX socket all happily works. If I just connect via network it crashes right away. If this only happens in an incoming network connection, then probably your network library is buggy. In Compaq Alpha C and C++ variables have to be aligned to machine addresses divisible by 4 or 8, which is not required in Intel x86. Looks like some variable in the library is not aligned. It's no such thing as network library in FreeBSD. It's networking support in kernel. And it's perfectly ok. Whole bunch of other apps work w/out any problems. MySQL server app is crashing. It only started when I enabled InnoDB at compile time. Before it was no such problem. So somewhere I guess they mangle with addresses and use unaligned one. It happens on *network* level. So even telnet connection on 3306 crashes it. Not even in logon phase. Or early in logon phase. So it's a bug in MySQL somewhere. I will try to troubleshoot it down to the source code line. if you can compile with the gcc -g option and run mysqld inside gdb, then you probably see in what function and line it crashes. If you just take a connection to mysqld, it does not execute InnoDB code at all. So the bug is probably in the network code of MySQL or the libraries involved, for example, glibc. I guess that libraries are always involved in network communication. The kernel API is more primitive. Yuri. Regards, Heikki - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB on FreeBSD-Alpha problem
Heikki, if you can compile with the gcc -g option and run mysqld inside gdb, then you probably see in what function and line it crashes. That's what I am going to do. If you just take a connection to mysqld, it does not execute InnoDB code at all. Well I was connecting to it before ok, but it was w/out InnoDB and older version. Yesterday I upgraded it to new stable and added InnoDB all at once. So I am not really sure it the bug was introduced with the new stable version or InnoDB enabling. Sounds more reasonable that it's just in the new stable version vs. InnoDB since it's in connect time. .So the bug is probably in the network code of MySQL or the libraries involved, for example, glibc. I guess that libraries are always involved in network communication. The kernel API is more primitive. In FreeBSD it's no glibc. And system libs aren't involved in networking. Kernel exposes POSIX-networking interface directly. So bug is somewhere in MySQL code. Will find out and make the patch. Regards, Yuri. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php