I have opened a bug about this issue: http://bugs.mysql.com/bug.php?id=44914
Joel
On Tue, May 12, 2009 at 10:55 PM, Joel Heenan wrote:
> Mysql List,
>
> I have a crash that has occured a number of times on a production CentOS
> 4.4 machine. It occurs when using a product called Interspire Email
Mysql List,
I have a crash that has occured a number of times on a production CentOS 4.4
machine. It occurs when using a product called Interspire Email Marketer and
doing an import of some 30,000 email addresses. Unfortunately, I have not
been able to reproduce the crash myself (I have tried nume
David -
Sorry for the delayed response. ulimit is unlimited.
I am using the RPMs for RH EL3 downloaded from a
mirror so I would assumed they have been built to
allow > 2GB archives.
I am most likely going a different route at this point
as my query response time is much too slow even with a
1GB
Hello.
It is strange for me that there isn't a stack trace. If you can
- switch to the debug version of MySQL and run it under gdb
to find out where it is crashing. See:
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html
laide); mysql@lists.mysql.com
Subject: Re: mysqld crash with archive engine > 2gb
> Is there any message in the log files? or any error
> message from the OS?
David -
When the mysqld process restarts, there is nothing in
the logfile except the basic startup info. I have
listed it below:0:
> Is there any message in the log files? or any error
> message from the OS?
David -
When the mysqld process restarts, there is nothing in
the logfile except the basic startup info. I have
listed it below:0:33).
051116 10:06:33 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '5.0
: Marc Rossi [mailto:[EMAIL PROTECTED]
Sent: Thursday, 17 November 2005 3:16 PM
To: mysql@lists.mysql.com
Subject: mysqld crash with archive engine > 2gb
I am trying to populate a table using the archive
engine that I estimate will take up ~ 8gb of disk
space when finished. Right now I am crash
Marc:
Define "crashing the server". Does the whole machine shut down? The
mysqld process? What do error logs say? What version of MySQL are
you using? What's the create table statement? what's the current
avg_row_length and max_rows? What is ulimit -f as the MySQL user say?
-Sheeri
On 11/
I am trying to populate a table using the archive
engine that I estimate will take up ~ 8gb of disk
space when finished. Right now I am crashing the
server as soon as my file gets to the 2gb mark. OS is
linux and there are other files on the same filesystem
that are 30gb+ so I know the fs has sup
ilto:[EMAIL PROTECTED]
> Inviato: lunedi 14 giugno 2004 21.56
> A: Leonardo Francalanci
> Cc: [EMAIL PROTECTED]
> Oggetto: Re: R: query string make mysqld crash (mysqld 4.0.20)
>
>
> Leonardo Francalanci wrote:
> > I have a similar problem with a list of union(s) (see my
Leonardo Francalanci wrote:
I have a similar problem with a list of union(s) (see my email, one
hour before yours).
It seems there is something in the way mysql parses the string
that makes it crash. I tried with version 4.1.2 as well, but
it keeps on crashing.
Due to the architecture of the parser
[EMAIL PROTECTED]
> Inviato: lunedi 14 giugno 2004 16.49
> A: [EMAIL PROTECTED]
> Oggetto: query string make mysqld crash (mysqld 4.0.20)
>
>
> Hi,
>
> Using Mysql 4.0.20-standard-log since a few days
> I encontred an error that I had never seen before.
>
> Here is wha
(
JobStatus = 'xyz'
)
;
This imply a mysqld crash (and restart) each time I run the request !
I
. The query always appears to run successfully after the restart.
Fix:
The automatic restart of mysqld solves the problem, however the
server going down is now my problem.
Submitter-ID: RustyShanklin
Organization: Pikeville Medical Center
MySQL support: NONE
Synopsis: mysqld crash - Possible
>Description:
I'm experiencing a Linux-related only problem with a simple UDF which call
mysql_real_connect()
>How-To-Repeat:
A very simple function:
#include
#include
#include
Abdulla,
- Original Message -
From: ""Paizulaev Abdula"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, April 05, 2004 7:43 AM
Subject: mysqld crash, got following
> InnoDB: Error: record field 3 len 4294967207
> Heap no too big 5
InnoDB: Error: record field 3 len 4294967207
Heap no too big 5888 93
Error in page 117145 in index PRIMARY
Record has 654 fields, should have 24
InnoDB: record RECORD: info bits 0 0:
040405 8:36:56 InnoDB: Assertion failure in thread 9226 in file
../include/page0page.ic line 482
InnoDB: We intent
Hi!
On Jan 12, Holm Tiffe wrote:
> >Description:
> mysqld 4.0.17 crash on FreeBSD 5.1-current-alpha
> >How-To-Repeat:
> Any acces over IP (not domain socket) crashes mysqld:
> #/usr/local/bin/mysqladmin: connect to server at 'install' failed
> error: 'Lost connection to MySQL server during q
Hi!
On Jan 12, Holm Tiffe wrote:
> >Description:
> mysqld 4.0.17 crash on FreeBSD 5.1-current-alpha
> >How-To-Repeat:
> Any acces over IP (not domain socket) crashes mysqld:
> #/usr/local/bin/mysqladmin: connect to server at 'install' failed
> error: 'Lost connection to MySQL server during q
27;4.0.17' socket: '/tmp/mysql.sock' port: 3306
I've tried several versions of mysql, all with the same result.
PostgreSQL is running fine on this machine.
>Fix:
none known
>Submitter-Id: holm
>Originator:Holm Tiffe
>Organization:
FreibergNet I
AIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, October 03, 2003 4:24 PM
Subject: mysqld crash
> >Description:
> Upon starting mysql client with the following command:
> mysql -ppassword radiant
> Immediately error message where displayed, one per table, saying that
>Description:
Upon starting mysql client with the following command:
mysql -ppassword radiant
Immediately error message where displayed, one per table, saying that
the table existed, however no columns/fields where found.
Unfortunately I do not have the log
our current "situation" is a mysqld crash, it hits an assertion
in my_seek.c.
Assertion failed: pos != (~(my_off_t) 0), file
c:\build\build\mysql-4.0.14\mysys\my_seek.c, line 31
This is with a myisam table containing variable length text fields.
I'm not expecting any solution
At 17:13 16/01/2003 +0100, JC wrote:
Hi,
Hi,
I downloaded and compiled mysql 4.0.9 gamma this morning, and
still get the same error. This doesn't seem to be related to reverse
DNS. I've got the crash from both types of client hosts (with and without
reverse).
Was found that for some GLIBC syste
Hi,
I downloaded and compiled mysql 4.0.9 gamma this morning, and
still get the same error. This doesn't seem to be related to reverse
DNS. I've got the crash from both types of client hosts (with and without reverse).
The official 4.0.9 binary version seems to work well.
What did I miss ?
My
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christopher E. Brown wrote:
Description:
MySQL 4.0.8, both compiled my me and the official release version
crashes whenever receiving a network connection from a system without a DNS
entry. Connecting from a system that resolves on reverse (eithor f
Description:
MySQL 4.0.8, both compiled my me and the official release version
crashes whenever receiving a network connection from a system without a DNS
entry. Connecting from a system that resolves on reverse (eithor from DNS
or a local hosts file entry) works find. This system is a S
Diana Soares wrote:
>On Fri, 2002-07-26 at 18:43, Mike Wexler wrote:
>
>
>>Diana Soares wrote:
>>
>>
>>
>>>Hi, just sending a reply in case that someone else has the same problem.
>>>I solved the problem by decreasing the key-buffer from 320M to 288M.
>>>
>>>
>>>
>>We tried that am
On Fri, 2002-07-26 at 18:43, Mike Wexler wrote:
>
>
> Diana Soares wrote:
>
> >Hi, just sending a reply in case that someone else has the same problem.
> >I solved the problem by decreasing the key-buffer from 320M to 288M.
> >
> We tried that among many other things. It turns out that their i
Hi, just sending a reply in case that someone else has the same problem.
I solved the problem by decreasing the key-buffer from 320M to 288M.
On Wed, 2002-07-03 at 12:24, Diana Soares wrote:
> Hi,
>
> I have 2 machine dual-processor Pentium III, with 1G of memory.
> They have the same software
Diana Soares wrote:
>Hi, just sending a reply in case that someone else has the same problem.
>I solved the problem by decreasing the key-buffer from 320M to 288M.
>
We tried that among many other things. It turns out that their is some
kind of problem related to temporary tables. MySQL AB is
Diana,
Wednesday, July 03, 2002, 2:24:51 PM, you wrote:
DS> I have 2 machine dual-processor Pentium III, with 1G of memory.
DS> They have the same software, same architecture, with one-way replication
DS> beetween. Versions:
DS> [root@localhost tmp]# mysql -V
DS> mysql Ver 11.18 Distrib 3.23.51
Hi,
I have 2 machine dual-processor Pentium III, with 1G of memory.
They have the same software, same architecture, with one-way replication
beetween. Versions:
[root@localhost tmp]# mysql -V
mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686)
[root@localhost tmp]# cat /etc/redhat-release
Hi,
I'm trying to make use of the new(ish) merge table
type, and am running into two problems. The first is
unexpected behaviour, the second is a straight MySQL
server crash. I have tested 3.23.47, 3.23.49 and
3.23.51 with similar results. Details below refer to
3.23.51. I have also tested on Dar
On Mon, Feb 04, 2002 at 02:33:40PM -0700, Sasha Pachev wrote:
> On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
> > >?This does look like a libc bug. How did you build either one of the
> binaries?
> >
> > They're your binaries. ?I don't buld my own binaries on Linux to save
> > the h
On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
> >?This does look like a libc bug. How did you build either one of the
binaries?
>
> They're your binaries. ?I don't buld my own binaries on Linux to save
> the hassle of using libraries that are different from what you folks
> use. :-)
On Mon, Feb 04, 2002 at 10:08:37AM -0700, Sasha Pachev wrote:
> On Monday 04 February 2002 02:30 am, Jeremy Zawodny wrote:
> > 0x807bb5f handle_segfault__Fi + 383
> > 0x82a94aa pthread_sighandler + 154
> > 0x7cb80076 __evoke_link_warning_llseek + 1954074198
> > 0x7cb7fe19 __evoke_link_warning_llse
On Mon, Feb 04, 2002 at 07:15:33PM +0200, Sinisa Milivojevic wrote:
>
> Yes, this is troubling ...
>
> It could be hardware, though ...
>
> Can you find anything in MySQL log and especially in /var/log/dmesg
> or /var/log/messages.
Nope.
> Sometimes, not often, Linux kernel is capable of not
Jeremy Zawodny writes:
> On Mon, Feb 04, 2002 at 02:27:01PM +0200, Sinisa Milivojevic wrote:
>
> That was your binary on Linux.
>
> Strangely, I just started up that exact same copy of 3.23.47-max and
> it worked fine after a machine reboot.
>
> That's most unusual (and troubling).
>
> Thanks,
On Monday 04 February 2002 02:30 am, Jeremy Zawodny wrote:
> 0x807bb5f handle_segfault__Fi + 383
> 0x82a94aa pthread_sighandler + 154
> 0x7cb80076 __evoke_link_warning_llseek + 1954074198
> 0x7cb7fe19 __evoke_link_warning_llseek + 1954073593
> 0x7cb713e6 __evoke_link_warning_llseek + 1954013638
>
On Mon, Feb 04, 2002 at 02:27:01PM +0200, Sinisa Milivojevic wrote:
>
> Jeremy,
>
> It could also be a bug in glibc.
>
> As you are using Linux, can you try out binary ??
That was your binary on Linux.
Strangely, I just started up that exact same copy of 3.23.47-max and
it worked fine after
TECTED]>
Sent: Monday, February 04, 2002 1:49 PM
Subject: Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)
> jocelyn fournier writes:
> > Hi,
> >
> > About glibc, I saw the 2.2.5 release included the spinlock.c patch, part
of
> > the intern
jocelyn fournier writes:
> Hi,
>
> About glibc, I saw the 2.2.5 release included the spinlock.c patch, part of
> the internals.h (except the following part :
> -#define STACK_SIZE (2 * 1024 * 1024)
> +#define STACK_SIZE (128 * 1024)
> )
> The local_lim.h is also partially patched :
>
> The fol
ssage -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 1:27 PM
Subject: Re: mysqld crash & stack trace from 3.23.47-max (with InnoDB)
> Jeremy Zawodny writes:
> > I just atte
Hi!
InnoDB seems to have created the database and started ok. This does not look
like an InnoDB bug.
I think gethostbyaddr asks from a connection the hostname, and subsequent
code checks that the host has access rights to mysqld.
For some reason gethostbyaddr_r crashes.
Hmm.. if you could run
I just attempted to upgrade a 3.23.41-max server on Linux 2.4.12 to
3.23.47-max. Before starting up 3.23.47-max, I added several Innodb
options to the my.cnf file:
---snip---
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M
innodb_data_home_dir = /home/mysql/yahoo/
ntinue running
>
>> Fix:
>
> Don't fill up /tmp
>
>> Submitter-Id:
>> Originator: Mercury Admin
>> Organization:
>
> Infinity Solutions
>
>> MySQL support: [none at the moment
>> Synopsis:mysqld crash on full /t
]
>Description:
Crash with full /tmp
>How-To-Repeat:
Fill up /tmp and allow mysqld to continue running
>Fix:
Don't fill up /tmp
>Submitter-Id:
>Originator:Mercury Admin
>Organization:
Infinity Solutions
>MySQL support: [none at the moment
>Synopsis:
Heikki sent his response to the wrong address...
-- Forwarded Message --
Subject: Re: TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash
Date: 25 Apr 2001 17:18:06 -
From: Heikki Tuuri <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Alex,
MySQL obviously tries t
Alex,
MySQL obviously tries to drop the table when you exit
from the mysql client, since the table is temporary.
I have not tested TEMPORARY tables. I just tried on prerelease .38 and
it does not work in that version either.
I will fix it in .38 if Monty has not yet put out it.
Regards,
Heikki
Heikki,
Mysql-3.23.36, Solaris 2.8.
My mysqld crashes when I create a TEMPORARY InnoDB table from the console
if I do a SELECT COUNT(*) before exiting from the console.
No problem with MyISAM tables, no problem with no TEMPORARY table.
mysql> CREATE TEMPORARY TABLE mybuffer ( id int
EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, January 12, 2001 1:31
> Subject: index corruption and mysqld crash
>
> > Hello,
> >
> > I have switched this morning our Web server from mSQL to MySQL.
> > I am using MySQL 3.22.32 installed f
: index corruption and mysqld crash
> Hello,
>
> I have switched this morning our Web server from mSQL to MySQL.
> I am using MySQL 3.22.32 installed from MySQL-3.22.32-1.i386.rpm
> on a Linux server (RedHat 6.2).
>
> mysqld dies very ofen (uptime is between 2mn and 20mn) and
&g
Hello,
I have switched this morning our Web server from mSQL to MySQL.
I am using MySQL 3.22.32 installed from MySQL-3.22.32-1.i386.rpm
on a Linux server (RedHat 6.2).
mysqld dies very ofen (uptime is between 2mn and 20mn) and
the only messages I have in error file look like :
Number of process
54 matches
Mail list logo