A. Gerow | 7 Jul 21:05 2006

out of memory error when selecting column type longtext

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
(Continue reading)

yasinti | 13 Jul 04:08 2006
Picon

DBD::mysql installing error

Hi,
  I got a lot of error when I tried to install DBD::mysql module using DBD-mysql-2.9008.tar.gz. 
  When I ran a command 'make' after I ran 'perl Makefile.PL', errors came up.
  The errors like bellow:
  =====================================================
  dbdimp.c:713: (near initialization for `SQL_GET_TYPE_INFO_values[53].native_type
')
dbdimp.c:714: initializer element is not constant
dbdimp.c:714: (near initialization for `SQL_GET_TYPE_INFO_values[53]')
dbdimp.c:720: `FIELD_TYPE_LONGLONG' undeclared here (not in a function)
dbdimp.c:720: initializer element is not constant
dbdimp.c:720: (near initialization for `SQL_GET_TYPE_INFO_values[54].native_type
')
dbdimp.c:721: initializer element is not constant
dbdimp.c:721: (near initialization for `SQL_GET_TYPE_INFO_values[54]')
dbdimp.c: In function `native2sql':
dbdimp.c:729: `FIELD_TYPE_VAR_STRING' undeclared (first use in this function)
  .
  .
  .
  dbdimp.c: In function `mysql_dr_connect':
dbdimp.c:855: `MYSQL' undeclared (first use in this function)
dbdimp.c:855: `result' undeclared (first use in this function)
dbdimp.c:857: `host' undeclared (first use in this function)
dbdimp.c:858: `port' undeclared (first use in this function)
dbdimp.c:863: `user' undeclared (first use in this function)
dbdimp.c:864: `password' undeclared (first use in this function)
dbdimp.c:878: `CLIENT_FOUND_ROWS' undeclared (first use in this function)
dbdimp.c:880: `sock' undeclared (first use in this function)
dbdimp.c:882: `imp_dbh' undeclared (first use in this function)
(Continue reading)

Martin J. Evans | 13 Jul 10:34 2006

RE: DBD::mysql installing error

Looks like DBD::mysql 2.9008 is out of sync with your DBI version.

What does 
perl -MDBI -e 'print $DBI::VERSION,"\n"'
output?

If it later than 1.4n I would get a more recent DBD::mysql like
DBD-mysql-3.0006 and try again.

The latest DBI is 1.51.

Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com

On 13-Jul-2006 yasinti wrote:
> Hi,
>   I got a lot of error when I tried to install DBD::mysql module using
> DBD-mysql-2.9008.tar.gz. 
>   When I ran a command 'make' after I ran 'perl Makefile.PL', errors came up.
>   The errors like bellow:
>   =====================================================
>   dbdimp.c:713: (near initialization for
> `SQL_GET_TYPE_INFO_values[53].native_type
> ')
> dbdimp.c:714: initializer element is not constant
> dbdimp.c:714: (near initialization for `SQL_GET_TYPE_INFO_values[53]')
> dbdimp.c:720: `FIELD_TYPE_LONGLONG' undeclared here (not in a function)
(Continue reading)

yasinti | 13 Jul 12:21 2006
Picon

Re: DBD::mysql installing error

Hi,
  when I run  perl -MDBI -e 'print $DBI::VERSION,"\n"' , it's 1.51. That's my DBI version.
  I've had DBD-mysql-3.0006, extracted it and ran 'make', but still got the same error.
  Thanks and regards,

  sinti
  ----- Original Message -----   From: "Martin J. Evans" <martin.evans <at> easysoft.com>
  To: <perl <at> lists.mysql.com>
  Sent: Thursday, July 13, 2006 3:34 PM
  Subject: RE: DBD::mysql installing error

  > Looks like DBD::mysql 2.9008 is out of sync with your DBI version.
> 
> What does 
> perl -MDBI -e 'print $DBI::VERSION,"\n"'
> output?
> 
> If it later than 1.4n I would get a more recent DBD::mysql like
> DBD-mysql-3.0006 and try again.
> 
> The latest DBI is 1.51.
> 
> Martin
> --
> Martin J. Evans
> Easysoft Ltd, UK
> http://www.easysoft.com
> 
> 
> On 13-Jul-2006 yasinti wrote:
(Continue reading)

Dave Howorth | 13 Jul 13:09 2006
Picon
Picon

error installing DBD-mysql-3.0006

Hello,

I'm having a problem trying to install DBD-mysql-3.0006. It fails like this:

   t/prepare_noerror....FAILED test 2
         Failed 1/3 tests, 66.67% okay

All the other tests are OK. Has anybody see this problem?

Thanks and regards, Dave

My software versions:

MySQL server version: 4.0.21-Max

# perl -MDBI -e 'print $DBI::VERSION,"\n"'
1.51
# perl -V
Summary of my perl5 (revision 5 version 8 subversion 5) configuration:
   Platform:
     osname=linux, osvers=2.6.8.1, archname=x86_64-linux-thread-multi
     uname='linux salieri 2.6.8.1 #1 smp fri jan 14 15:41:33 utc 2005 
x86_64 x86_64 x86_64 gnulinux '
     config_args='-ds -e -Dprefix=/usr -Dvendorprefix=/usr 
-Dinstallusrbinperl -Dusethreads -Di_db -Di_dbm -Di_ndbm -Di_gdbm 
-Duseshrplib=true -Doptimize=-O2 -fmessage-length=0 -Wall -Wall -pipe'
     hint=recommended, useposix=true, d_sigaction=define
     usethreads=define use5005threads=undef useithreads=define 
usemultiplicity=define
     useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
(Continue reading)

Martin J. Evans | 13 Jul 15:20 2006

Re: DBD::mysql installing error

Did you mention what versions of mysql you are building against?
It looks like it might be MySQL 5.0.15.

Have you got the file mysql_com.h and does it contain
a definition for FIELD_TYPE_LONGLONG etc (as per the errors below)?

Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com

On 13-Jul-2006 yasinti wrote:
> Hi,
>   when I run  perl -MDBI -e 'print $DBI::VERSION,"\n"' , it's 1.51. That's my
> DBI version.
>   I've had DBD-mysql-3.0006, extracted it and ran 'make', but still got the
> same error.
>   Thanks and regards,
>    
>   sinti
>   ----- Original Message -----   From: "Martin J. Evans"
> <martin.evans <at> easysoft.com>
>   To: <perl <at> lists.mysql.com>
>   Sent: Thursday, July 13, 2006 3:34 PM
>   Subject: RE: DBD::mysql installing error
> 
>   
> 
>   > Looks like DBD::mysql 2.9008 is out of sync with your DBI version.
(Continue reading)

Martin J. Evans | 13 Jul 15:32 2006

RE: error installing DBD-mysql-3.0006

Dave,

This may have been a mistake of mine that was later fixed
see http://lists.mysql.com/perl/3851

I think what follows is the must up to date prepare_noerror.t:

# Test problem in 3.0002_4 and 3.0005 where if a statement is prepared
# and multiple executes are performed, if any execute fails all subsequent
# executes report an error but may have worked.

use strict;
use DBI ();

use vars qw($test_dsn $test_user $test_password $state);
require "t/lib.pl";

while (Testing()) {
  my ($dbh, $sth);
  #
  # Connect to the database
  Test($state or
       ($dbh = DBI->connect("$test_dsn;mysql_server_prepare=1", $test_user,
$test_password,
                           {RaiseError => 0})));

  #
  # execute invalid SQL to make sure we get an error
  #
  my $q = "select select select";       # invalid SQL
(Continue reading)

Dave Howorth | 13 Jul 15:58 2006
Picon
Picon

Re: error installing DBD-mysql-3.0006

Martin J. Evans wrote:
> Dave,
> 
> This may have been a mistake of mine that was later fixed
> see http://lists.mysql.com/perl/3851

Ah, OK. See below ...

> I think what follows is the must up to date prepare_noerror.t:
> 
> # Test problem in 3.0002_4 and 3.0005 where if a statement is prepared
> # and multiple executes are performed, if any execute fails all subsequent
> # executes report an error but may have worked.
> 
> use strict;
> use DBI ();
> 
> use vars qw($test_dsn $test_user $test_password $state);
> require "t/lib.pl";
> 
> while (Testing()) {
>   my ($dbh, $sth);
>   #
>   # Connect to the database
>   Test($state or
>        ($dbh = DBI->connect("$test_dsn;mysql_server_prepare=1", $test_user,
> $test_password,
>                            {RaiseError => 0})));
> 
>   #
(Continue reading)

Benjamin Natal | 13 Jul 21:39 2006

Need help with DBD-mysql on Solaris 9

To Whom It May Concern:

 I'm currently running Solaris 9 running MySQL, Apache and Perl. I'm
getting the following error messages below when running my Perl/CGI
scripts which make DBI calls to MySQL DB. I followed your instructions
in the README and INSTALL file for configuring DBD::mysql, but still
have not been able to successfully get this to work. I also read up on
your "KNOWN PROBLEMS" section in the INSTALLS file, and tried to
statically link to libgcc and libmysqlclient with no success.

Any additional information or help you can provide would be greatly
appreciated. Below is the error message that I continue to get when
running our Perl scripts. Also, below you will find the output of my
compilation. Again, any suggestion or clues to resolve this issue would
be very helpful.

Thanks,

Ben

Wed Jul 12 23:11:59 2006] [error] [client 192.168.50.254]
install_driver(mysql) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBD/mysql/mysql.
so' for module DBD::mysql: ld.so.1: perl5.8.0: fatal: libgcc_s.so.1:
open failed: No such file or directory at
/usr/local/lib/perl5/5.8.0/sun4-solaris/DynaLoader.pm line 229.

[Wed Jul 12 23:11:59 2006] [error] [client 192.168.50.254]  at (eval 5)
line 3

(Continue reading)

Marco Wise | 14 Jul 00:07 2006
Picon

Re: Need help with DBD-mysql on Solaris 9

Hi Ben,

Can you run this script on the command line? If yes, maybe your  
LD_LIBRARY_PATH environment variable is set in the shell and it can  
find libgcc_s.so, but not in the web environment.

I'm not well versed in Solaris, but I think there's a program called  
crle that allows you to administer library paths.

- marco

On Jul 13, 2006, at 12:39 PM, Benjamin Natal wrote:

> To Whom It May Concern:
>
>
>
>  I'm currently running Solaris 9 running MySQL, Apache and Perl. I'm
> getting the following error messages below when running my Perl/CGI
> scripts which make DBI calls to MySQL DB. I followed your instructions
> in the README and INSTALL file for configuring DBD::mysql, but still
> have not been able to successfully get this to work. I also read up on
> your "KNOWN PROBLEMS" section in the INSTALLS file, and tried to
> statically link to libgcc and libmysqlclient with no success.
>
>
>
> Any additional information or help you can provide would be greatly
> appreciated. Below is the error message that I continue to get when
> running our Perl scripts. Also, below you will find the output of my
(Continue reading)


Gmane