DaemonForums  

Go Back   DaemonForums > FreeBSD > FreeBSD General

FreeBSD General Other questions regarding FreeBSD which do not fit in any of the categories below.

Reply
 
Thread Tools Display Modes
  #1   (View Single Post)  
Old 24th May 2008
zeltus zeltus is offline
New User
 
Join Date: May 2008
Posts: 3
Default MySQL 5.1 install - daemon crashes

This is a new thread based on my earlier one - I have tried deinstalling/reinstalling package MySQL but the mysqld daemon still crashes as fast as I can start it. mysqld_safe continually loops, which makes for fun and games trying to kill it off, but

#/usr/local/libexec/mysqld can be called direct... this throws out

zeltus# ./mysqld --user=mysql &
[2] 68492
[1] Exit 1 mysqld --user=mysql
jail0087# 080524 8:52:38 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
080524 8:52:38 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 46409.
InnoDB: Doing recovery: scanned up to log sequence number 0 46409
080524 8:52:38 InnoDB: Started; log sequence number 0 46409
080524 8:52:38 [Note] Recovering after a crash using mysql-bin
080524 8:52:38 [Note] Starting crash recovery...
080524 8:52:38 [Note] Crash recovery finished.
080524 8:52:38 [Note] Event Scheduler: Loaded 0 events
080524 8:52:38 [Note] ./mysqld: ready for connections.
Version: '5.1.20-beta-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.1.20
[2] Done ./mysqld --user=mysql

Unfortunately, this is all I have achieved so far re diagnostics.. and other than telling me that mysqld died suddenly, I haven't got much else.

Can anyone else suggest what I might do now to get this up and running? I have no idea what I have to do to get mysqld to tell me why it is crashing... and it's all getting a bit frustrating. Sigh.

Cheers

Bill
Reply With Quote
  #2   (View Single Post)  
Old 25th May 2008
zeltus zeltus is offline
New User
 
Join Date: May 2008
Posts: 3
Default Fixed (I hope!)

Well, I sorted it in the end... I had to de-install MySQL and reinstall it.. I re-make'd it from scratch, but with an extra option

zeltus# cd /usr/ports/databases/mysql51-server
zeltus# make deinstall
zeltus# make -DWITH_PROC_SCOPE_PTH=yes -DBUILD_OPTIMIZED=yes
zeltus# make install clean

And thereafter all was/is well. So far.

BUILD_OPTIMIZED is a bit of a red herring, it had no impact on this problem, but hey! it looked like a good idea to include it.

Dunno why PTHREADS needs to be included but again, on reflection, it seems to be a a good idea (the other thread option was for a LINUX set up and I run FREEBSD, so out of the three available options, the default of NONE fails with an immediate crash, the LINUX threads option looks to be inapplicable and thus I was left with this option.) Which as I said, seems to have worked. So far. I shall watch it like a hawl for a few days, methinks.

Cheers

Bill
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
FreeBSD 7.0 with SSD Crashes map7 FreeBSD General 4 5th February 2009 10:08 PM
dbus-daemon lumiwa FreeBSD General 2 2nd October 2008 12:05 AM
net-im/sim-im* crashes blackbox TerryP FreeBSD Ports and Packages 0 28th September 2008 08:29 AM
Mysql 5.1 install on Freebsd 7 64 bit ijk FreeBSD Ports and Packages 1 23rd July 2008 02:10 PM
Akregator crashes map7 FreeBSD Ports and Packages 2 13th July 2008 11:22 PM


All times are GMT. The time now is 08:30 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick