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







> 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.15-standard'  socket:

> '/var/lib/mysql/mysql.sock'  port: 3306  MySQL

> Community Edition - Standard (GPL)

>   Number of processes running now: 0

>   051116 20:33:05  mysqld restarted

>   051116 20:33:05  InnoDB: Started; log sequence

> number 0 43665

>   051116 20:33:05 [Note] /usr/sbin/mysqld: ready for

> connections.

>   Version: '5.0.15-standard'  socket:

> '/var/lib/mysql/mysql.sock'  port: 3306  MySQL

> Community Edition - Standard (GPL)

> 

> As you can see from the log I am running 5.0.15.  I

> installed using the provided RPMs on a RH ES3 box. 

> 

> Below is the tablestatus.

> 

> mysql> show table status like 'trade' \G

> *************************** 1. row

> ***************************

>            Name: trade

>          Engine: ARCHIVE

>         Version: 10

>      Row_format: Compressed

>            Rows: 0

>  Avg_row_length: 4137

>     Data_length: 2147483647

> Max_data_length: 0

>    Index_length: 0

>       Data_free: 0

>  Auto_increment: NULL

>     Create_time: 2005-11-16 20:33:05

>     Update_time: 2005-11-16 20:33:05

>      Check_time: NULL

>       Collation: latin1_swedish_ci

>        Checksum: NULL

>  Create_options: max_rows=4294967295

> avg_row_length=4137

>         Comment:

> 1 row in set (0.01 sec)

>  

> Thanks for any assistance you can give.  I am also

> looking at alternative solutions in which I use

> multiple ARCHIVE dbs with each being < 2 gb.

> 

> Marc

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to