I've been using DBD-MySQL for a long time and I just ran across this
error. So I get an error (two + exit code actually) when I execute the
following code.
$sth = $sakai_dbh->prepare("SELECT s.SHORT_DESC ".
"FROM SAKAI_SITE s " .
"WHERE s.TYPE='course' ");
$sth->execute();
while (($curr) = $sth->fetchrow_array()) { ### WE DIE HERE ON THE
FIRST ITERATION! ###
...
}
$sth->finish();
s.SHORT_DESC is a of type LONGTEXT, and when I select other entities of
that type I get the same error. Though, I can select anything not of
type LONGTEXT from this database no problem.
The error:
Out of memory!
Out of memory!
Callback called exit.
I am using Perl 5.8.8, on Fedora Core 5 Linux 2.6, MySQL 4.1, Perl:DBI
1.51, and DBD-mysql-3.0006_1. Modifying the database is out of the
question in this particular case.
Has anyone seen, fixed, or gotten around this? Should I file a bug report?
Thanks in advance,
.Gerow
1 message in com.mysql.lists.perlout of memory error when selecting co...