Hi everyone, If you have increased your MAXDSIZ variable in FreeBSD to above 2048 the mysqld will crash on FreeBSD 4.5. Please set it to 2047 or lower: options MAXDSIZ="(2047*1024*1024)"
to quote a very intelligent source (Thanks Sinisa!) >It happens with MySQL as it is the only one trying to create threads. > >So, as threads take up stack, FBSD checks for available memory. > >And as it is saved in signed int, it crashes !!!!!!!!!!!! Don't forget to install the new kernel (make kernel) after lowering MAXDSIZ. If you are using the GENERIC kernel you won't have this problem. You will only have this problem if you added MAXDSIZ to you kernel config and set it above 2047. Hope this helps, Ken ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]> Sent: Tuesday, March 12, 2002 3:27 PM Subject: Re: mysql under FreeBSD 4.5 > Good to hear I'm not the only one. I'm still trying to get this resolved > btw, in case you're wondering. I am no nearer to a solution than I was > when I first reported this. > > On Mon, 11 Mar 2002, Ken Menzel wrote: > > > I am now seeing this behavior as well. I will work with the > > developement group to help resolve this. > > Ken > > ----- Original Message ----- > > From: <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, February 22, 2002 2:10 AM > > Subject: mysql under FreeBSD 4.5 > > > > > > > Just recently installed FreeBSD 4.5-RELEASE and cvsup'd to latest > > > 4-STABLE. Updated ports tree and did a make install in > > > /usr/ports/databases/mysql323-server and received the following on > > the > > > mysql_install_db part: > > > > > > /usr/local/bin/mysql_install_db > > > Preparing db table > > > Preparing host table > > > Preparing user table > > > Preparing func table > > > Preparing tables_priv table > > > Preparing columns_priv table > > > Installing all prepared tables > > > Fatal error 'Can't create gc thread' at line ? in file > > > /usr/src/lib/libc_r/uthread/uthread > > > _create.c (errno = ?) > > > Abort trap - core dumped > > > Installation of grant tables failed! > > > > > > Examine the logs in /var/db/mysql for more information. > > > You can also try to start the mysqld daemon with: > > > /usr/local/libexec/mysqld --skip-grant & > > > You can use the command line tool > > > /usr/local/bin/mysql to connect to the mysql > > > database and look at the grant tables: > > > > > > shell> /usr/local/bin/mysql -u root mysql > > > mysql> show tables > > > > > > Try 'mysqld --help' if you have problems with paths. Using --log > > > gives you a log in /var/db/mysql that may be helpful. > > > > > > > > > > > > I saw that one other person had ran into the same thing, but the > > trail > > > ends there as I can't find if she/he ever resolved it. The version > > in the > > > ports of FreeBSD is 3.23.49, btw. Please help? This is and will be > > our > > > future ACM local chapter website, hopefully running MySQL. If we can > > ever > > > get it to install properly. > > > > > > Thanks in advance. --------------------------------------------------------------------- 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
