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 > In infinite wisdom Basil Daoust wrote: > > >

Re: MySql - crashes daily

2010-12-06 Thread Raj Shekhar
In infinite wisdom 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. > Do you have the coredump from this crash? If yes, can you load the core dump into gdb and run "bt" (backtrace) and see w

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

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 > 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 >

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 databas

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 ever

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 tablesp

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

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 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

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 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, ..

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, ..

Re: MySQL crashes with foreign key restraints

2002-12-14 Thread Stefan Hinz
From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL 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

Re: MySQL crashes with foreign key restraints

2002-12-14 Thread Heikki Tuuri
]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, December 14, 2002 10:37 PM Subject: Re: MySQL crashes with foreign key restraints > Dear Heikki, > > thanks for the hint! > > > please upgrade to 4.0.5 and test again. > >

Re: MySQL crashes with foreign key restraints

2002-12-14 Thread Stefan Hinz, iConnect \(Berlin\)
ect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +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 ke

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 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 doe

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 BGW_

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]>

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 __ _ _