List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:September 16 2004 7:52am
Subject:Re: SV: Mysql goes down when executing query
View as plain text  
Mauricio,

please resolve the stack dump below.

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/



----- Original Message ----- 
From: "Mauricio Pellegrini" <hrrg-inf@stripped>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, September 15, 2004 3:46 PM
Subject: Re: SV: Mysql goes down when executing query


> Thanks, but already have innodb_buffer_pool_size=160M
> and I've raised innodb_additional_mem_pool_size from 2M to 10M
>
> And the problem remains the same.
>
> Any sugestions?
>
> Thanks
> Mauricio
>
>
>
>
>
> On Tue, 2004-09-14 at 18:05, Nickolai Nielsen wrote:
> > Hi
> >
> > Try setting these variables in you conf:
> > set-variable = innodb_buffer_pool_size=128M
> > set-variable = innodb_additional_mem_pool_size=10M
> >
> > you have to experiment with the size as it depends on how much ram you
> > hardware has.
> >
> > Nickolai Nielsen
> >
> > -----Oprindelig meddelelse-----
> > Fra: hrrg-inf@stripped [mailto:hrrg-inf@stripped]
> > Sendt: 14. september 2004 22:39
> > Til: MySql List
> > Emne: Mysql goes down when executing query
> >
> >
> > Hi, Sorry to disturb but Mysql 4.1.4 gamma goes down when executing this
> > query.
> >
> > I've tryed the same query without the coalesce function and the problem
> > persists.
> >
> > select
> >     coalesce(viehc,0),
> >     coalesce(vieapellido,0),
> >     coalesce(vienombres,0),
> >     coalesce(viedoc,0),
> >     coalesce(numero,0),
> >     coalesce(apellido,0),
> >     coalesce(nombres,0),
> >     coalesce(f_nacimiento,0),
> >     coalesce(sexo,0),
> >     coalesce(doc_numero,0)
> > from zzg_int.compara
> >  into outfile "/tmp/compa.txt"
> >  fields terminated by ','
> >  lines terminated by '\r\n';
> >
> > This is what the error log shows.
> >
> > Version: '4.1.4-gamma-standard-log'  socket: '/tmp/mysql.sock'  port:
> > 3306  Official MySQL-standard binary
> > mysqld got signal 11;
> > This could be because you hit a bug. It is also possible that this
> > binary
> > or one of the libraries it was linked against is corrupt, improperly
> > built,
> > or misconfigured. This error can also be caused by malfunctioning
> > hardware.
> > We will try our best to scrape up some info that will hopefully help
> > diagnose
> > the problem, but since we have already crashed, something is definitely
> > wrong
> > and this may fail.
> >
> > key_buffer_size=16777216
> > read_buffer_size=258048
> > max_used_connections=13
> > max_connections=100
> > threads_connected=10
> > It is possible that mysqld could use up to
> > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
> > = 92783 K
> > bytes of memory
> > Hope that's ok; if not, decrease some variables in the equation.
> >
> > thd=0x4b22efb8
> > Attempting backtrace. You can use the following information to find out
> > where mysqld died. If you see no messages after this, something went
> > terribly wrong...
> > Cannot determine thread, fp=0xbfddeb68, backtrace may not be correct.
> > Stack range sanity check OK, backtrace follows:
> > 0x808a183
> > 0x82d3cb8
> > 0x80ae46f
> > 0x809d894
> > 0x8097e4f
> > 0x80977d8
> > 0x8096f17
> > 0x82d146c
> > 0x82fa9fa
> > New value of fp=(nil) failed sanity check, terminating stack trace!
> > Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
> > follow instructions on how to resolve the stack trace. Resolved
> > stack trace is much more helpful in diagnosing the problem, so please do
> > resolve it
> > Trying to get some variables.
> > Some pointers may be invalid and cause the dump to abort...
> > thd->query at 0x86da708 = EXPLAIN select
> >
coalesce(viehc,0),coalesce(vieapellido,0),coalesce(vienombres,0),coalesce(vi
> > edoc,0),coalesce(numero,0),
> >
coalesce(apellido,0),coalesce(nombres,0),coalesce(f_nacimiento,0),coalesce(s
> > exo,0),coalesce(doc_numero,0)
> > from hrrg_int.compara
> > into outfile "/tmp/compa.txt" fields terminated by ',' lines terminated
> > by '\r\n'
> > thd->thread_id=632
> > The manual page at http://www.mysql.com/doc/en/Crashing.html contains
> > information that should help you find out what is causing the crash.
> >
> > Number of processes running now: 0
> > 040914 13:15:00  mysqld restarted
> > 040914 13:15:00  [ERROR] Warning: Asked for 196608 thread stack, but got
> > 126976
> > 040914 13:15:00  InnoDB: Database was not shut down normally!
> > InnoDB: Starting crash recovery.
> > InnoDB: Reading tablespace information from the .ibd files...
> > InnoDB: Restoring possible half-written data pages from the doublewrite
> > InnoDB: buffer...
> > 040914 13:15:00  InnoDB: Starting log scan based on checkpoint at
> > InnoDB: log sequence number 0 281648573.
> > InnoDB: Doing recovery: scanned up to log sequence number 0 281648583
> > InnoDB: Last MySQL binlog file position 0 79779, file name
> > ./hrrgp01-bin.000005
> > 040914 13:15:00  InnoDB: Flushing modified pages from the buffer pool...
> > 040914 13:15:00  InnoDB: Started; log sequence number 0 281648583
> > /usr/local/mysql/bin/mysqld: ready for connections.
> > Version: '4.1.4-gamma-standard-log'  socket: '/tmp/mysql.sock'  port:
> > 3306  Official MySQL-standard binary
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >
> >
> >
> >
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>

Thread
Mysql goes down when executing queryMauricio Pellegrini14 Sep
  • SV: Mysql goes down when executing queryNickolai Nielsen15 Sep
    • Re: SV: Mysql goes down when executing queryMauricio Pellegrini15 Sep
  • Re: Mysql goes down when executing queryEgor Egorov17 Sep
Re: SV: Mysql goes down when executing queryHeikki Tuuri16 Sep
  • Re: SV: Mysql goes down when executing queryMauricio Pellegrini16 Sep
Re: SV: Mysql goes down when executing queryHeikki Tuuri16 Sep
  • Re: SV: Mysql goes down when executing queryMauricio Pellegrini24 Sep
Re: SV: Mysql goes down when executing queryHeikki Tuuri27 Sep