http://www.perlmonks.org?node_id=809913


in reply to Re: fetchall_arrayref with slice and row count
in thread fetchall_arrayref with slice and row count

Not a bug. So wrong usage.
while ( $sth->{Active} and $rowcache=$sth->fetchall_arrayref({}, $max_rows) ) { ... }
See the DBI documentation: the last possible fetch in a fetchall will call $sth->finish.