Crashes with "Execute Batch-Files"

[Smeagle]

Hi,

I tried to execetue a large SQL-batch created with “import from ODBC”, this was quite slow and randomly crashed after ~1.500-5.000 rows. The dump has ~100MB and ~350.000 rows. Importing the .sql with “mysqlc” took only 10 Seconds and worked.

Here are the first few lines of the dump:

Code:

/*
Data Generated By – SQLyog v3.63
*/

use `fte`;

create table `fte`.`web` (
 `typnr` int (10)   NOT NULL ,
`genartnr` int (10)   NOT NULL ,
`artikelnr` varchar (100)   NOT NULL ,
`einbau` varchar (100)   NOT NULL ,
`produktinfo` text   NOT NULL ,
`sortnr` int (10)   NOT NULL ,
`tb400` text   NOT NULL ,
`kriterien` varchar (200)   NOT NULL ,
`ps` char (10)   NOT NULL ,
`gruppe` int (10)   NOT NULL ,
`nkw` char (1)   NOT NULL ,
`sprache` int (10)   NOT NULL  
);
insert into `web` (`typnr`, `genartnr`, `artikelnr`, `einbau`, `produktinfo`, `sortnr`, `tb400`, `kriterien`, `ps`, `gruppe`, `nkw`, `sprache` ) values (1, 258, 'H22736.0.0', '', 'Ø 22,2mm', 2, '', 'CH042866-CH145736', '44        ', 2, 1, 1);
insert into `web` (`typnr`, `genartnr`, `artikelnr`, `einbau`, `produktinfo`, `sortnr`, `tb400`, `kriterien`, `ps`, `gruppe`, `nkw`, `sprache` ) values (1, 258, 'H22918.0.1', '', 'S5215
Ø 22,2mm', 3, '', 'CH162734-12.1980', '44        ', 2, 1, 1);
insert into `web` (`typnr`, `genartnr`, `artikelnr`, `einbau`, `produktinfo`, `sortnr`, `tb400`, `kriterien`, `ps`, `gruppe`, `nkw`, `sprache` ) values (1, 276, 'RK22217', '', 'Rep.Satz Hz
Ø 22,2mm
+ Kolben', 6, '', 'CH042866-CH145736', '44        ', 2, 1, 1);
insert into `web` (`typnr`, `genartnr`, `artikelnr`, `einbau`, `produktinfo`, `sortnr`, `tb400`, `kriterien`, `ps`, `gruppe`, `nkw`, `sprache` ) values (1, 276, 'RK22224', '', 'Rep.Satz Hz
Ø 22,2mm
+ Kolben', 7, '', 'CH162734-12.1980', '44        ', 2, 1, 1);
insert into `web` (`typnr`, `genartnr`, `artikelnr`, `einbau`, `produktinfo`, `sortnr`, `tb400`, `kriterien`, `ps`, `gruppe`, `nkw`, `sprache` ) values (1, 277, 'R22088A1', '', 'S6545
Bohrung Ø 22,2mm', 10, '', 'CH018261-12.1980', '44        ', 4, 1, 1);
insert into `web` (`typnr`, `genartnr`, `artikelnr`, `einbau`, `produktinfo`, `sortnr`, `tb400`, `kriterien`, `ps`, `gruppe`, `nkw`, `sprache` ) values (1, 278, 'RK22323K', '', 'Rep.Satz Rz
Ø 22,2mm
+ Kolben', 14, '', 'CH018261-12.1980', '44        ', 4, 1, 1);
insert into `web` (`typnr`, `genartnr`, `artikelnr`, `einbau`, `produktinfo`, `sortnr`, `tb400`, `kriterien`, `ps`, `gruppe`, `nkw`, `sprache` ) values (1, 83, '500.56.3', '', 'Länge 500mm
2 Stück', 18, '', '01.1972-12.1980', '44        ', 12, 1, 1);

Thanks,

– Oliver

[Smeagle]

Hi,

do you need further input on this?

i noticed, the sql-batch hangs/crashes everytime, the status-windows looses focus.

– Oliver

[Ritesh]

Actually the app is not hanging. Since the option is running on the main thread it is not able to process any other GUI events.

Can you send me a .zip of the sql file?

[Smeagle]

You got mail 🙂

[Ritesh]

Nope.

Can you send it again? Do a BCC to [email protected].

[Smeagle]

Hmm, got it back.

Error: [email protected] am 29.01.2004 17:35

< fw0.dmz.local #5.7.1 SMTP; 554 5.7.1 The server sending your mail [194.172.224.2] does not have a reverse DNS entry. Connection Rejected. Please contact your ISP >

I sent it again using another ISP.

– Oliver

[Ritesh]

I have received the file. Will revert back soon.

[Smeagle]

Hmm, the same thing happens when using the odbc-Import Wizard. As soon, as the status-window looses focus, it hangs and cannot be resumed by giving it focus, again. 🙁

Any idea? I have to do a large import every day and would like to have it running in background…

– Oliver

[Ritesh]

What a coincidence I was just going to mail you 🙂

We tried uploading the data ( around .3 million records ) that you sent us. It worked fine for us. It takes some time to insert .3 million rows. All of this happens in one thread and the GUI is not able to respond to events. This gives an impression that the system is not responding.

[Smeagle]

Ack.

It just takes a very long time. Sorry. 🙂

But… If I run the batch with mysqld its _much_ faster, so I thought, it must be hanging…

– Oliver

[Ritesh]

Thanks for pointing that out 🙂

We are working on the feature.

[Author]

Posts