fetchrow_array() hangs at same record

[Kosie Poggenpoel]

Hi,

I have a simple loop in a perl script like such:

while (my($a)=$sth->fetchrow_array()) {

do stuff;

}

Now, I read about 600K records like this, and it works great except at some point,
at the exact same record, the next iteration of the while loop just hangs at the next fetchrow_array.

Setting DB_TRACE=2, the last lines in the logfile shows:

-> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x2b322e7259b0)~0x1481a150) thr#14090010
-> dbd_st_fetch for 148dba50, chopblanks 0


And that is where it just hangs.

Any idea what can be happening here?


Regards
Kosie



Edited 1 time(s). Last edit at 05/27/2010 12:04PM by Kosie Poggenpoel.