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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
