Nickolai, this very much sounds like a hardware fault. No MySQL or InnoDB bug should be able to freeze the WHOLE operating system. And SELECT ... INTO OUTFILE ... is a very basic operation in the database.
Regards, Heikki ----- Original Message ----- From: ""Nickolai Nielsen"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, July 08, 2004 8:33 PM Subject: MySQL/InnoDB crashes system > hi > > this SQL frezes the system: > SELECT * FROM journal into OUTFILE 'c:/Backup/current/journal.asc' FIELDS > terminated by '|' LINES terminated by '\r\n' > > this started after the table was converted to InnoDB, usualy it runs normaly > the first time, but on 2-5 run it frezes the system so i have to reboot the > server. > > System: > Windows 2000 Server > MySQL 4.0.18 > commandline: > mysqld --console --log --log-warnings --debug=d,info,error,query,general,whe > re:O,/mysqld_3.trace > > this is a trace output: > > do_command: info: Command on TCP/IP (17560) = 3 (Query) > dispatch_command: query: SELECT * FROM ptanamid into OUTFILE > 'c:/30Min-Backup/current_stress/ptanamid.asc' FIELDS terminated by '|' LINES > terminated by '\r\n' > openfrm: info: i_count: 0 i_parts: 0 index: 3 n_length: 19 int_length: 0 > open_table: info: inserting table 02A5B348 into the cache > mi_lock_database: info: lock_type: 2 > mi_get_status: info: key_file: 258048 data_file: 126648 > init_io_cache: info: init_io_cache: cachesize = 131072 > > Info about JOIN > ptanamid type: ALL q_keys: 0 refs: 0 key: -1 len: 0 > init_read_record: info: using rr_sequential > init_io_cache: info: init_io_cache: cachesize = 131072 > mi_lock_database: info: lock_type: 0 > mi_lock_database: info: old lock: 2 > mi_lock_database: info: changed: 0 w_locks: 0 > do_select: info: 5277 records output > dispatch_command: info: query ready > close_thread_tables: info: thd->open_tables=02A5B348 > do_command: info: Command on TCP/IP (17560) = 3 (Query) > dispatch_command: query: SELECT * FROM ptanamnese into OUTFILE > 'c:/30Min-Backup/current_stress/ptanamnese.asc' FIELDS terminated by '|' > LINES terminated by '\r\n' > openfrm: info: i_count: 0 i_parts: 0 index: 4 n_length: 53 int_length: 0 > open_table: info: inserting table 02A5AC40 into the cache > mi_lock_database: info: lock_type: 2 > mi_get_status: info: key_file: 9187328 data_file: 9766188 > init_io_cache: info: init_io_cache: cachesize = 131072 > > Info about JOIN > ptanamnese type: ALL q_keys: 0 refs: 0 key: -1 len: 0 > init_read_record: info: using rr_sequential > init_io_cache: info: init_io_cache: cachesize = 131072 > *** here it crashed *** > > Thanks > Nickolai Nielsen > > > > -- > 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]
