Re: MySql - crashes daily

2010-12-21 Thread 杨涛涛
Hi. Can you show me some of your critical system logs? David Yeung, In China, Beijing. My First Blog:http://yueliangdao0608.cublog.cn My Second Blog:http://yueliangdao0608.blog.51cto.com My Msn: yueliangdao0...@gmail.com 2010/12/7 Raj Shekhar rajl...@rajshekhar.net In infinite wisdom

Re: MySql - crashes daily

2010-12-06 Thread Raj Shekhar
In infinite wisdom Basil Daoust bdao...@lemonfree.com wrote: Any help greatly appreciated. Our mysql is restarting a LOT! Here is what is in the log, it doesn't seem to give much help. Do you have the coredump from this crash? If yes, can you load the core dump into gdb and run bt

Re: MySql - crashes daily

2010-12-03 Thread Wm Mussatto
On Fri, December 3, 2010 14:11, Basil Daoust wrote: Any help greatly appreciated. Our mysql is restarting a LOT! Here is what is in the log, it doesn't seem to give much help. --start of log-- InnoDB: Warning: a long semaphore wait: 101203 15:12:40 - mysqld got signal 11; This could

Re: MySQL crashes

2010-06-21 Thread Tyler Poland
Charlene, You should check the mysql error log and if there isn't a message about the cause there you may want to check /var/log/syslog for mysql being killed by oomkiller. Tyler On 6/21/10 11:11 AM, Charlene wrote: Anybody have any idea why MySQL would start to have this error message

Re: MySQL crashes

2010-06-21 Thread Ann W. Harrison
Charlene wrote: Anybody have any idea why MySQL would start to have this error message every 4 or so days at midnight: Do look at the logs, but if the error always occurs at midnight, you might look for a disk backup or compression program that's scheduled to run than and accesses the

Re: MySQL crashes

2010-06-21 Thread Guifre Bosch Fabregas
you can stop your Mysql server (the program) and delete the file mysql.sock and the try to start. 2010/6/21 Tyler Poland tpol...@engineyard.com Charlene, You should check the mysql error log and if there isn't a message about the cause there you may want to check /var/log/syslog for mysql

RE: Mysql crashes, do not understand backtrace

2010-02-15 Thread Gavin Towey
When running with force-recovery, the database will indeed be read-only. This is on purpose. When you have an error of this nature, the procedure is to find a force-recovery level which allows you to start mysql, then export all the data. Then you can shut down mysql, wipe your innodb

Re: Mysql Crashes I/O error...

2007-08-06 Thread George F. Crewe
This was a faulty disk after all. I just did not see any errors, when running smartd. However, they showed up when looking on the system log. I am currently replacing the disk. Thank you, George Crewe On 8/3/07, George F. Crewe [EMAIL PROTECTED] wrote: Hello everybody, I am looking for some

Re: MySQL crashes constantly and can't get MySQL 5.0.21 to write core-file

2006-06-13 Thread Wouter de Jong
On Tue, Jun 13, 2006 at 08:55:59AM +0200, Wouter de Jong wrote: The symptoms are that MySQL is constantly (eg. within every 30 minutes) getting signal 11's according to the logfile, and is restarting. Problem finally tracked down and filed bug report. Regards, -- WideXS

Re: MySQL crashes

2006-06-07 Thread Daniel da Veiga
On 6/7/06, Ian Collins [EMAIL PROTECTED] wrote: I have a site running MySQL 4.1.19. When I was first given the problem, the site only stayed up for a couple of days - they then found they had to reboot (as opposed to just restarting MySQL). The error message they were getting is below (between

Re: MySQL crashes

2006-06-07 Thread Dilipkumar
Hi, This might be a bug try to create mysql stack trace file and find out what is causing for mysql crash, this might be a query hitting mysql and also memory related issues.Try to upgrade your mysql and report back. Daniel da Veiga wrote: On 6/7/06, Ian Collins [EMAIL PROTECTED] wrote:

Re: MySQL crashes randomly

2006-05-12 Thread Daniel da Veiga
On 5/12/06, sheeri kritzer [EMAIL PROTECTED] wrote: So, our MySQL master database crashes about once a week, then immediately recovers. We are running a Dell 2850 -- 64-bit Fedora Core 3 box with 6G of memory, 4 Intel Xeon processors, at 3.60 GHz speed each (says /proc/cpuinfo), each cpu cache

Re: MySQL crashes with foreign key restraints

2002-12-15 Thread Heikki Tuuri
Stefan, - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 15, 2002 1:39 AM Subject: Re: MySQL crashes with foreign key restraints Dear Heikki, ... Hmm ... seems like 4.0.5 is the first MySQL/InnoDB

Re: MySQL crashes with foreign key restraints

2002-12-15 Thread Heikki Tuuri
Stefan, - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 15, 2002 1:39 AM Subject: Re: MySQL crashes with foreign key restraints Dear Heikki, ... Hmm ... seems like 4.0.5 is the first MySQL/InnoDB

Re: MySQL crashes with foreign key restraints

2002-12-14 Thread Heikki Tuuri
Stefan, please upgrade to 4.0.5 and test again. 4.0.1 is a very old alpha release, and lots of bugs have been fixed since. 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

Re: MySQL crashes with foreign key restraints

2002-12-14 Thread Stefan Hinz, iConnect \(Berlin\)
: +49 30 7970948-3 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 13, 2002 9:47 PM Subject: Re: MySQL crashes with foreign key restraints Stefan, please upgrade to 4.0.5 and test again. 4.0.1 is a very old alpha release

Re: MySQL crashes with foreign key restraints

2002-12-14 Thread Heikki Tuuri
for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 10:37 PM Subject: Re: MySQL crashes

Re: MySQL crashes with foreign key restraints

2002-12-14 Thread Stefan Hinz
PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 10:28 PM Subject: Re: MySQL crashes with foreign key restraints Stefan, are you sure you used the script: CREATE TABLE Projekt( id SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (id)) TYPE=InnoDB; CREATE TABLE Teilnehmer( id

Re: MySQL Crashes When a Remote Connection Is Made

2002-11-08 Thread Tabor J. Wells
On Fri, Nov 08, 2002 at 10:25:01PM -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] is thought to have said: Description: MySQL crashes when a remote computer attempts to make a standard connection. Making a local connection does not cause this problem, connecting to other systems does not

re: MySQL crashes after an update statement

2002-10-18 Thread Victoria Reznichenko
bas, Friday, October 18, 2002, 3:59:02 PM, you wrote: bdvaodc REALFROM: [EMAIL PROTECTED] Description: bdvaodc MySQL crashes after issueing the following command : bdvaodc UPDATE BGW_Master, ICA_1_SplitInter bdvaodc SET ICA_1_SplitInter.I1_Proc_Dt = BGW_Master.I1_Proc_Dt bdvaodc WHERE

Re: mysql crashes after adding memory.

2002-08-08 Thread Bhavin Vyas
If it is saying that it cannot bind to port 3306, then maybe the port is still locked by another process, mysqld or otherwise. netstat -na | grep 3306 should show you that. Kill that process and try again. Regards, Bhavin. - Original Message - From: Johannes Ullrich [EMAIL PROTECTED] To:

Re: MySQL crashes is fulltext search on with some words.

2002-04-16 Thread Sergei Golubchik
Hi! On Apr 16, Erlend Hopso Stromsvik wrote: I'm not sure if this has been reported earlier, but my mysql-server goes down if I run a query with two 'match against' where one of them contains/matches the word 'think'... Can you create a repeatable test case for this ? Regards, Sergei --

Re: MySQL crashes permanently on FreeBSD thru signal 11 or 10

2001-03-11 Thread Sinisa Milivojevic
Hi! As it has been posted to this mailinglist, you have to upgrade your system to 4.2 STABLE. Then, please use a contributed 3.23.33 binary for 4.2 stable from 3.23 download page. And what do you use MySQL for in your esteemed Institute ?? Regards, Sinisa __ _ _