mysqld crashing

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
cybaf
Forum Commoner
Posts: 89
Joined: Tue Oct 01, 2002 5:28 am
Location: Gothenburg Sweden

mysqld crashing

Post by cybaf »

Hi!

Not sure if this is the right forum for this type of question, but anyways...

I have a apache webserver running on OpenBSD 3.3 and a mysql server running on the same machine.

The problem that I'm experiencing is that if I'm logged on to the console of the database, and at the same time try to run some php-scripts (which use mysql) of my website, then the mysqldeamon crashes and has to be restarted.

any idéas??
evilMind
Forum Contributor
Posts: 145
Joined: Fri Sep 19, 2003 10:09 am
Location: Earth

Post by evilMind »

I had a similar problem w/php and crashing. However my experience was that when I ran *any* php scripts it would kill my apache server... poor httpd :!: I was using php 5b at the time. The cause of my crashes was because php was missing a couple modules, pear was incorrectly installed, and it was just a little bit buggy. However, you might consider doing some or all of the following if you haven't already:

Check your error log for apache and make sure that it (and php are) finding the correct modules at start. (If it is missing modules this could be the cause (as it was for me))
Restart your mysql server then restart your webserver

What version of mysql, apache, and php are you using?
User avatar
cybaf
Forum Commoner
Posts: 89
Joined: Tue Oct 01, 2002 5:28 am
Location: Gothenburg Sweden

Post by cybaf »

evilMind wrote:What version of mysql, apache, and php are you using?
I guess that could be relevant in this type of question... :oops:

MySQL/3.23.49
Apache/1.3.26
PHP/4.2.3

The mysqlconnections works perfectly (for the apache user) when I'm not logged in the the mysql-console. but as long as I don't do both at the same time it works perfectly... but there must be something wrong in some configuration somewhere, and I thought that someone here might know...:)

All thoughts greatly appreciated
User avatar
cybaf
Forum Commoner
Posts: 89
Joined: Tue Oct 01, 2002 5:28 am
Location: Gothenburg Sweden

Post by cybaf »

the httpd error_log does not show any errors what so ever regarding the crashed mysqld or that it had problems to connect...

any takers?
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Post by BDKR »

If the problem is with the mysql daemon going away or MySQL crashing in general, the most likely place to check is the error file. MySQL maintains an error file in it's /data directory. If you mysql directory is /usr/local/mysql, the try looking for the file in /usr/local/mysql/data/.

The online manual at mysql.com is a big help too.

Cheers,
BDKR
Post Reply