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:
>
> >
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
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
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
or
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
>
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
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
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 running
sley Wajon [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 m
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 a
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
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 th
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 atte
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
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)
T
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:
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
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 alter
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
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 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 c
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]> w
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
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
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 suggestions
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: 0.
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
-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 ou
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.
>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:
>Originator:Hans-Joerg Wolff
>Organization:
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,
..
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,
..
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
]>
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.
> >
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
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));
CREAT
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
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,
> connec
>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.
r doesn't always crash. When I type "slave start/slave stop", I maybe see a
crash 10% of the time.
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: m
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
>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
AIL PROTECTED]>
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 proces
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 alre
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. I
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 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
download
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 optimizat
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 AHA2916
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,
Wo
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 ser
1:27 AM
To: mysql
Cc: gvb
Subject: Provider claims 'it's normal that mysql crashes', is that true?
Hello
My provider 1&1-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 machi
>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
On Wed, 04 Apr 2001, Gunnar von Boehn wrote:
> Hello
>
>
> My provider 1&1-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-serv
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 an
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 1&1-Puretec (www.puretec.d
Hello
My provider 1&1-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 around 8 hours.
As I asked them why their mysql-serve
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
__ _ _
>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 repeatin
60 matches
Mail list logo
