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
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
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 be because you hit a bug. It is also possible that this binary
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
Anybody have any idea why MySQL would start to have this error message
every 4 or so days at midnight:
Connection error: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
This just started happening a little more than 2 weeks ago. The server
has been
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
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
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
On one of the servers we maintain mysql recently crashed.
In safe mode (innodb_force_recovery = 4) it runs but then you can't do
any mutations to the databases.
When we try to start it in normal mode it crashes and we do not really
understand the backtrace.
We eventually ended up in flushing
[mailto:wes...@oktober.nl]
Sent: Monday, February 15, 2010 6:30 AM
To: mysql@lists.mysql.com
Subject: Mysql crashes, do not understand backtrace
On one of the servers we maintain mysql recently crashed.
In safe mode (innodb_force_recovery = 4) it runs but then you can't do
any mutations
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
Hello everybody,
I am looking for some help on my mysql server crashes.
I run version 5.0.27 on Fedora 6.
However, suddenly mysql server starting crashing. I revised the log
and it is telling me that is having a input/output operating system
error on a read operation.
The error shows up like
Hi,
Each night I replicate a server running a 4.1 version of mysql via
mysqldump and then import to a box running a 5.0.18-standard. It has
been working well for some four or five months. Suddenly, the job
started failing during the import. After stepping through the job, I
determined that
Hi,
We have major problems with one of our database machines the past few
weeks. We've replaced the complete machine about 3 times now, with
different memory... no luck. So I doubt it's hardware.
It's a SuperMicro SuperServer 6014H-82 ... dual Xeon 3.0, 8GB DDR2-RAM,
4x73GB Maxtor SCSI (RAID10)
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
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 the snip's).
After looking at the site, I
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
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:
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 size is 2048 Kb. It
replicates to 2 slaves, which have
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
HI
MySQL 5.0 (windows XP)
I have a problem where i think some of my tables have somehow been
corrupted, if i try to run a check table command against some tables the
mysql service crashes and i have to restart it. I am not sure how this
damage has occurred but has anyone got any
First of all I would check for file system corruption.
IIRC there is a command line tool for repairing MyISAM tables, so you can use
that without needing the MySQL database server. I'm sure there are full details
in the manual:
http://dev.mysql.com/doc/refman/5.0/en/
Good luck!
James Harvard
On 1/31/06, Adrian Bruce [EMAIL PROTECTED] wrote:
HI
MySQL 5.0 (windows XP)
I have a problem where i think some of my tables have somehow been
corrupted, if i try to run a check table command against some tables the
mysql service crashes and i have to restart it. I am not sure how this
Thanks for the reply
yep mysqldump also causes the service to crash.
i have a few innodb tables mixed in amongst the myisam, it seems that it
is the innodb tables that may be causing the problems but i am not sure
why ???
Imran Chaudhry wrote:
On 1/31/06, Adrian Bruce [EMAIL PROTECTED]
On Jan 31, 2006, at 11:01 AM, Adrian Bruce wrote:
Thanks for the reply
yep mysqldump also causes the service to crash.
i have a few innodb tables mixed in amongst the myisam, it seems
that it is the innodb tables that may be causing the problems but i
am not sure why ???
If it's InnoDB
Hi Guys:
Does anyone know how come I'm getting a lot of mysql processes when I start
mysql server for the first time.
When I type top it showed the following:
5:33pm up 15 min, 4 users, load average: 0.16, 0.19, 0.10
80 processes: 79 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states:
Hey folks,
before posting to the bugs-list I would like to try it here to get some help :).
Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine.
Its not reproducible nor I know a query which does it.
(The log shows that at the end, so no query :-( :
Trying to get some variables.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote:
before posting to the bugs-list I would like to try it here to get some
help :). Every now and then MySQL-4.0.13 crashes on my
Dual-Athlon-MP-machine.
Is that a self-compiled binary or one of
Hi Lenz,
thanks a lot for your reply!
Is that a self-compiled binary or one of ours?
It are the MySQL-4.0.13-MAX-RPMs from your site.
Not very helpful. Does this occur under high load only?
Yeah I know, otherwise I would have tried to generate a reproducible testcase with a
given query or
Description:
When accessing this mysql version from a WinXP client (running in a VMWare
shel) the server crashes reproducable.
How-To-Repeat:
Access to server with DBTools 1.0.x from WinXP client.
Fix:
?
Submitter-Id: submitter ID
Originator:Hans-Joerg Wolff
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
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
on InnoDB
sql query
Subject: MySQL crashes with foreign key restraints
From: Stefan Hinz
Date: Fri, 13 Dec 2002 16:17:56 +0100
Dear list,
I am using MySQL-max 4.0.1 on Win 98 Second Edition
Dear list,
I am using MySQL-max 4.0.1 on Win 98 Second Edition with InnoDB as
default table type. Using DeZign, I created the following SQL file with
three tables (I left out all those other CHAR and TEXT fields here):
CREATE TABLE Projekt(
id SMALLINT UNSIGNED NOT NULL,
PRIMARY KEY (id));
: +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
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
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
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 cause this problem, but a connection
from a remote computer to mySQL immediately crashes mySQL
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
/slave stop, I maybe see a
crash 10% of the time.
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis: mysql crashes when the slave is started with incorrect master info
Severity
Description:
MySQL crashes after issueing the following command :
UPDATE BGW_Master, ICA_1_SplitInter
SET ICA_1_SplitInter.I1_Proc_Dt = BGW_Master.I1_Proc_Dt
WHERE BGW_Master.I1_FileName = ICA_1_SplitInter.I1_FileName
AND BGW_Master.I1_runDate = ICA_1_SplitInter.I1_runDate
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
Yesterday, I increased the memory in my mysql server from
2 GByte to 4 GByte.
Here the log file as it died:
Number of processes running now: 1
mysqld process hanging, pid 1015 - killed
020808 09:40:12 mysqld restarted
020808 9:40:12 Can't start server: Bind on TCP/IP port: Address
]
To: [EMAIL PROTECTED]
Sent: Thursday, August 08, 2002 11:31 AM
Subject: mysql crashes after adding memory.
Yesterday, I increased the memory in my mysql server from
2 GByte to 4 GByte.
Here the log file as it died:
Number of processes running now: 1
mysqld process hanging, pid 1015
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
--
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'...
It terminates after the first query, but when I change the word 'think' to
'excel' or any other word it works flawlessy.
FYI
-christian-
On Wed, Jan 09, 2002 at 08:52:34PM +0100, Sjoerd Simons wrote:
Package: mysql-client
Version: 3.22.32-6
Severity: normal
Tags: patch
mysql -D something causes a segv, the attached patch to mysql.cc seems to fix
this..
...
--- mysql.cc.orig Wed Jan 9 20:46:07 2002
Need MySql 3.21 for Win2000
I have some old databases from MySql 3.21 and I want to move these to MySql 3.23, but
the server just crashes.
I've tried to start the MySql with --old-protocol, but no changes.
My plan is to install MySql 3.21 on my PC to get the databases, but there is no
MySQL crashes, when number of entries in table is
greater than some number 'X', in mf_radix.c file on
execution of a select query.
Optimization used: O2
Please suggest some approach to debug this crash.
It works fine with O0 optimization option
I am posting this in the hope it will be useful; I seem
to have solved the problem.
The problem was(on 3.23.38) and Linux 2.2.18 or 2.4.0
This is a huge system, all SCSI, 2GB or RAM, 2PIII
x1000MHz processors and 37GB in the volume group
corresponding to /var/lib/mysql
There is an
Hi,
I am new to MySQL. I downloaded MySQL for Windows version 3.23.38. When
I installed in MyISAM mode, mysqld was running fine. Then I uncommented
the configure parameters for innoDB in my.cnf. Mysqld initialized the
database the folowing messages printed on screen. Can anyone help ?
Thanks,
On Wed, Apr 04, 2001 at 05:26:39PM +0200, Gunnar von Boehn wrote:
As I asked them why their mysql-server die so often, I got their
standard problem email-answer that claims "mysql is scaling rather
badly".
The truth is probably closer to "we are scaling mysql badly". A well
run MySQL server
To: mysql
Cc: gvb
Subject: Provider claims 'it's normal that mysql crashes', is that true?
Hello
My provider 11-Puretec (www.puretec.de)
hosting more than 1.000.000 domains
runs about 14 Databaseserver with MySQL 3.22.32-log
on Linux dual Penti-III 500Mhz machines.
In the last 6 month the average
No this is not true... a lot of the stability of the database server has
to do with the #1 the load, and #2 the design of the database. But no
MySQL should not be crashing this much.
Scott
At 05:26 PM 4/4/2001 +0200, Gunnar von Boehn wrote:
Hello
My provider 11-Puretec (www.puretec.de)
We've been running on RedHat distribution (starting with 5.2 or so) and
Slackware before that for the last few years (currently running mysql
3.23.32... that update bug introduced in 3.23.34 really spanked us hard,
we'll be moving to "latest" again soon).
Currently, we've got dual and quad PII
On Wed, 04 Apr 2001, Gunnar von Boehn wrote:
Hello
My provider 11-Puretec (www.puretec.de)
hosting more than 1.000.000 domains
runs about 14 Databaseserver with MySQL 3.22.32-log
on Linux dual Penti-III 500Mhz machines.
In the last 6 month the average uptime of the mysql-servers was
After further asking I got a personal answer that says:
"it's normal the mysql-servers die because of heavy load".
"We can't help that the mysql task keeps crashing if to many users access it.
That's totally normal for a mysql database"
Running 3.22.32 that's prehistoric (sort of).. I think I
Description:
Database:
total: about 500Mb now
mostly used table: about 300Mb data, about 150Mb index, about 6,7 millions of records,
two indexes(primary key contains 3 fields, and other index contains 2 fields)
other tables is negligible (U see)
How-To-Repeat:
we repeating
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
__ _ _
59 matches
Mail list logo