Hi Again i forgot to mention that this table has 527101 rows, and takes 90mb when it is dumped to the disk. I dont have this freeze problem when i dump the smaller smaller tables that also uses InnoDB.
i Also discovered that it is not on the same posistion ind the dump file the lockup happens. Nickolai -----Oprindelig meddelelse----- Fra: Nickolai Nielsen [mailto:[EMAIL PROTECTED] Sendt: 10. juli 2004 16:28 Til: [EMAIL PROTECTED] Emne: SV: MySQL/InnoDB crashes system Hi I still got this freeze problem, i have found out that this bug is related to InnoDB, i converted the table that gives problems back to MyISAM, and the dump operation runs fine just as it did before, but as soon as i convert it to InnoDB and dump this table my system freezes but not the first time, usually i can do a dump 2-10 times before it goes wrong. I am certain that it is not a heat problem, or any other hardware problem it could be a conflict between a driver and MySQL. I got 2 identical servers running in a replication setup, i do the testing on my backup server but i can create the freeze on both servers, we run on MySQL 4.0.18, but i have also tried 4.0.20a and 4.1.3-beta. the servers config: Intel Pentium 4 2.53 Ghz QDI Superb 4E-A 533 motherboard 1gb DDR333 ram 2x Seagate CHEETAH 73.5 gb U160 SCSI in Raid 1 Adaptec 2110S Raid controller Windows 2000 Server UK 3Com 996B Gigabit NIC The servers have SP4 and all updates if anyone have an idea on how to troubleshoot this? Thanks Nickolai Nielsen -----Oprindelig meddelelse----- Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sendt: 9. juli 2004 05:07 Til: [EMAIL PROTECTED] Emne: Re: MySQL/InnoDB crashes system 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] -- 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]
