Christian Hammers wrote: >> MySQL crashes every time doing the query below with the following log >> entry: > > Can you provide a > SHOW CREATE TABLE xxxx;
CREATE TABLE `log` ( `id` int(11) NOT NULL auto_increment, `ip` varchar(15) default NULL, `agent` varchar(250) default NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `request` varchar(250) default NULL, `method` varchar(10) default NULL, `uid` int(11) default NULL, `ulogin` varchar(250) default NULL, `cid` int(11) default NULL, `module` varchar(250) default NULL, `fct` varchar(250) default NULL, `param` varchar(250) default NULL, `iid` int(11) default NULL, PRIMARY KEY (`id`), KEY `rid` (`cid`), KEY `timestamp` (`timestamp`) ) ENGINE=MyISAM AUTO_INCREMENT=4833261 DEFAULT CHARSET=latin1 > and the complete insert (if it was not in the output below)? Yes I think it was in the line starting with "thd->query". I tried to run the query in this line with the mysql client and it crashed too. The original crash was caused by a PHP script. > If the data is not private then the database files itself could > be helpful, too. Can you reproduce the problem after creating a fresh new > table and inserting the relevant query there (maybe it's just a filesystem > corruption on this one table). I tried that and it didn't crash. I could try to clear the other table and see if it still crashes. But maybe that would make the problem unreproduceable for me too. I would not be able to give any further information if it is needed. I think a segfault is not correct even if a table is damaged. > Please provide your /etc/mysql/my.cnf, too, in case it's a bug related to > charsets or special buffer sizes. Attached. I forgot to mention that this problem occured first after I upgraded MySQL to version 5. It was a 4.x version before. -- http://reboot.animeirc.de (Personal Homepage)
# # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "/var/lib/mysql/my.cnf" to set server-specific options or # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # This will be passed to all mysql clients [client] #password = my_password port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] err-log = /var/log/mysql/mysql.err socket = /var/run/mysqld/mysqld.sock [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 # # The preferred location for the log files is /var/log/mysql/ but the old # file /var/log/mysql.log still gets rotated by the cronjob. # log = /var/log/mysql.log log = /var/log/mysql/mysql.log log-error = /var/log/mysql/mysql.err basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-locking # # The skip-networkin option will no longer be set via debconf menu. # You have to manually change it if you want networking i.e. the server # listening on port 3306. The default is "disable" - for security reasons. # skip-networking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K # # Here you can see queries with especially long duration #log-slow-queries = /var/log/mysql/mysql-slow.log # # The following can be used as easy to replay backup logs or for replication server-id = 10001 #log-bin = /var/log/mysql/mysql-bin.log #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name # # Read the manual if you want to enable InnoDB! # skip-innodb # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # If you want to enable SSL support (recommended) read the manual or my # HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem # log-slave-updates skip-slave-start # replicate-do-db=nybria # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick set-variable = max_allowed_packet=1M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] set-variable = key_buffer=16M
signature.asc
Description: OpenPGP digital signature
