out of memory error when selecting column type longtext 2006-07-07 - By A. Gerow
Back
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 (See http://sql-3.ora-code.com).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
--
Aaron Gerow
Open Source Developer
Digital Media - Information and Technology Services
Pacific Lutheran University
Tacoma, Washington
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=mysql@(protected)
|
|
