[PHP-DB] 2008 Mysql client run out of memory !?!
Hello, I use PHP 4.0.6 with mySQL 3.23.40 and I have the error 2008 (client run out of memory) performing this query : select i2f.item_id, i2f.value, f.id from features as f, item2feature as i2f, items as i where i.scat_id = '244d713abba5f2ffb8d0ba8c858111ef' and i.id = i2f.item_id and f.id = i2f.feat_id That query works perfectly with phpMyAdmin - It returns 2 rows - and is also performed several times in the program using loops. I tried unbuffered queries but I had an error 0 (?). I think It is not the query that goes wrong but I don't understant why the mysql client run out of memory like that ! How can I find the cause of the problem ? Is there a way to see what's in the mysql client memory ? Thank you ! PS : If you want to reply me directly remove the name between brackets from the subject.. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] 2008 : MySQL client run out of memory
Hello, I tried with unbuffered queries and It doesn't solve the problem at all. I have an weird error performing "select id from categories where name = 'Hifi'". The error is now : '0 : ' (nothing). There's an error but it is not defined ?!? Note that only the crashing query is unbuffered so there's no problem with mysql_num_rows(). Le jeu, 09 aoû 2001, vous avez écrit : > guess: try mysql_unbuffered_query . . . also im assuming you arent doing a > limit on the query where phpmyadmin is . . . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] 2008 : MySQL client run out of memory
Not at all. The exact error is : 2008 : MySQL client run out of memory On the mysql online support they say It may happen when a query returns to much rows. But It's not the case. Moreover the query works with phpMyAdmin, which gives me a bit of hope... That's all. Le jeu, 09 aoû 2001, vous avez écrit : > hello patrice, > > please cut & paste exact error here.. is this related to script timeout > > bye > sandeep > - Original Message - > From: "Patrice Garbe" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, August 09, 2001 3:53 PM > Subject: [PHP-DB] 2008 : MySQL client run out of memory > > > Hello, > > I have this error (2008 : MySQL client run out of memory) performing > a request in a script. > However that request works perfectly under phpMyAdmin ! > > I tried to do a lot of mysql_free_result() in my script (because there are > a lot of requests) but I doesn't work and I think It is useless. > > I looked on the PHP site to see if there's not a bug but I didn't > configured my PHP with the --enable-memory-limit option. > I have the version 4.0.6 with the mysql built-in support. Note that I first > compiled PHP with the external mysql support and I had the same error. > > What's the problem ? How to find the cause ? > I tried a debugger called Body but It is so slow that I could die before. > > Thank you > > Patrice > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] 2008 : MySQL client run out of memory
I thought I was an answer to my question...I'm disappointed. Anyway did you try "make clean" before "make" ? But theses parse errors are strange. You should check (if you not already did so) your gcc version and if all the gcc components are installed. I had the same problem compiling "linuxthreads" and It was because my system wasn't completely installed. Le jeu, 09 aoû 2001, vous avez écrit : > I am trying to install PHP 4.0.5 on previous version of php 4.01 on cobalt > raq 4server. we are getting following error > > __ > Making all in mysql > make[2]: Entering directory `/home/src/php-4.0.5/ext/mysql' > Making all in libmysql > make[3]: Entering directory `/home/src/php-4.0.5/ext/mysql/libmysql' > make[4]: Entering directory `/home/src/php-4.0.5/ext/mysql/libmysql' > /bin/sh /home/src/php-4.0.5/libtool --silent --mode=compile > gcc -I. -I/home/src/php-4.0.5/ext/mysql/libmysql > -I/home/src/php-4.0.5/main -I/home/src/php-4.0.5 -I/usr/include/apache > -I/home/src/php-4.0.5/Zend -I/u sr/include/freetype -I/usr/include/imap > -I/usr/interbase/include -I/home/src /php-4.0.5/ext/mysql/libmysql > -I/home/src/php-4.0.5/ext/xml/expat/xmltok -I/ > home/src/php-4.0.5/ext/xml/expat/xmlparse -I/home/src/php-4.0.5/TSRM > -DLINU X=2 -DMOD_SSL=206104 -DMOD_PERL -DUSE_PERL_SSI -Dbool=char > -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED -DSUPPORT_UTF8 > -DXML_BYTE_ORDER=12 -g -O2 -c libmysql.c > In file included from libmysql.c:9: > global.h:240: warning: redefinition of `uint' > /usr/include/sys/types.h:131: warning: `uint' previously declared here > global.h:241: warning: redefinition of `ushort' > /usr/include/sys/types.h:130: warning: `ushort' previously declared here > In file included from libmysql.c:12: > m_string.h:180: parse error before `__extension__' > m_string.h:180: parse error before `&&' > make[4]: *** [libmysql.lo] Error 1 > make[4]: Leaving directory `/home/src/php-4.0.5/ext/mysql/libmysql' > make[3]: *** [all-recursive] Error 1 > make[3]: Leaving directory `/home/src/php-4.0.5/ext/mysql/libmysql' > make[2]: *** [all-recursive] Error 1 > make[2]: Leaving directory `/home/src/php-4.0.5/ext/mysql' > make[1]: *** [all-recursive] Error 1 > make[1]: Leaving directory `/home/src/php-4.0.5/ext' > make: *** [all-recursive] Error 1 > __ > > > > This is the copy of debug.php > > CONFIGURE: './configure' '--prefix=/usr' '--with-apxs=/usr/sbin/apxs' > '--with-gd' '--enable-safe-mode' '--with-config-file-path=/etc/httpd' > '--with-mysql' '--with-exec-dir=/usr/bin' '--enable-magic-quotes' > '--with-regex=system' '--with-ttf=/usr/lib/libttf.so' '--enable-track-vars' > '--enable-xml' '--disable-debug' '--with-interbase=shared' > '--with-pgsql=shared' '--with-ldap' '--with-imap' '--enable-sockets' > CC: gcc > CFLAGS: -g -O2 > CPPFLAGS:-DLINUX=2 -DMOD_SSL=206104 -DMOD_PERL -DUSE_PERL_SSI > -Dbool=cha r -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED > -DSUPPORT_UTF8 CXX: > CXXFLAGS: > INCLUDES:-I/usr/include/apache -I$(top_builddir)/Zend > -I/usr/include/fr eetype -I/usr/include/imap -I/usr/interbase/include > -I/home/src/php-4.0.5/ex t/mysql/libmysql > LDFLAGS: > LIBS: -lldap -llber -lttf -lgd -lresolv -lm -ldl -lcrypt -lnsl > -lreso lv > DLIBS: -lc-client > SAPI: apache > PHP_RPATHS: > uname -a: Linux www.hikanoo.com 2.2.14C11 #2 Wed Jun 28 00:55:51 PDT 2000 > i586 unknown > > gcc -o > conftest -g -O2 -DLINUX=2 -DMOD_SSL=206104 -DMOD_PERL -DUSE_PERL_SSI > -Dbool =char -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED > -DSUPPORT_UTF8 conftest.c -lldap -llber -lttf -lgd -lresolv -lm -ldl > -lcrypt -lnsl -lresol v 1>&5 > /usr/bin/ld: cannot find -lgd > collect2: ld returned 1 exit status > === > > regards, > sandeep > > Indianic Infotech Limited > 91-79-6404208/09/10 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] 2008 : MySQL client run out of memory
I am trying to install PHP 4.0.5 on previous version of php 4.01 on cobalt raq 4server. we are getting following error __ Making all in mysql make[2]: Entering directory `/home/src/php-4.0.5/ext/mysql' Making all in libmysql make[3]: Entering directory `/home/src/php-4.0.5/ext/mysql/libmysql' make[4]: Entering directory `/home/src/php-4.0.5/ext/mysql/libmysql' /bin/sh /home/src/php-4.0.5/libtool --silent --mode=compile gcc -I. -I/home/src/php-4.0.5/ext/mysql/libmysql -I/home/src/php-4.0.5/main -I/home/src/php-4.0.5 -I/usr/include/apache -I/home/src/php-4.0.5/Zend -I/u sr/include/freetype -I/usr/include/imap -I/usr/interbase/include -I/home/src /php-4.0.5/ext/mysql/libmysql -I/home/src/php-4.0.5/ext/xml/expat/xmltok -I/ home/src/php-4.0.5/ext/xml/expat/xmlparse -I/home/src/php-4.0.5/TSRM -DLINU X=2 -DMOD_SSL=206104 -DMOD_PERL -DUSE_PERL_SSI -Dbool=char -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED -DSUPPORT_UTF8 -DXML_BYTE_ORDER=12 -g -O2 -c libmysql.c In file included from libmysql.c:9: global.h:240: warning: redefinition of `uint' /usr/include/sys/types.h:131: warning: `uint' previously declared here global.h:241: warning: redefinition of `ushort' /usr/include/sys/types.h:130: warning: `ushort' previously declared here In file included from libmysql.c:12: m_string.h:180: parse error before `__extension__' m_string.h:180: parse error before `&&' make[4]: *** [libmysql.lo] Error 1 make[4]: Leaving directory `/home/src/php-4.0.5/ext/mysql/libmysql' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/home/src/php-4.0.5/ext/mysql/libmysql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/home/src/php-4.0.5/ext/mysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/src/php-4.0.5/ext' make: *** [all-recursive] Error 1 __ This is the copy of debug.php CONFIGURE: './configure' '--prefix=/usr' '--with-apxs=/usr/sbin/apxs' '--with-gd' '--enable-safe-mode' '--with-config-file-path=/etc/httpd' '--with-mysql' '--with-exec-dir=/usr/bin' '--enable-magic-quotes' '--with-regex=system' '--with-ttf=/usr/lib/libttf.so' '--enable-track-vars' '--enable-xml' '--disable-debug' '--with-interbase=shared' '--with-pgsql=shared' '--with-ldap' '--with-imap' '--enable-sockets' CC: gcc CFLAGS: -g -O2 CPPFLAGS:-DLINUX=2 -DMOD_SSL=206104 -DMOD_PERL -DUSE_PERL_SSI -Dbool=cha r -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED -DSUPPORT_UTF8 CXX: CXXFLAGS: INCLUDES:-I/usr/include/apache -I$(top_builddir)/Zend -I/usr/include/fr eetype -I/usr/include/imap -I/usr/interbase/include -I/home/src/php-4.0.5/ex t/mysql/libmysql LDFLAGS: LIBS: -lldap -llber -lttf -lgd -lresolv -lm -ldl -lcrypt -lnsl -lreso lv DLIBS: -lc-client SAPI: apache PHP_RPATHS: uname -a: Linux www.hikanoo.com 2.2.14C11 #2 Wed Jun 28 00:55:51 PDT 2000 i586 unknown gcc -o conftest -g -O2 -DLINUX=2 -DMOD_SSL=206104 -DMOD_PERL -DUSE_PERL_SSI -Dbool =char -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED -DSUPPORT_UTF8 conftest.c -lldap -llber -lttf -lgd -lresolv -lm -ldl -lcrypt -lnsl -lresol v 1>&5 /usr/bin/ld: cannot find -lgd collect2: ld returned 1 exit status === regards, sandeep Indianic Infotech Limited 91-79-6404208/09/10 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] 2008 : MySQL client run out of memory
Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think It is useless. I looked on the PHP site to see if there's not a bug but I didn't configured my PHP with the --enable-memory-limit option. I have the version 4.0.6 with the mysql built-in support. Note that I first compiled PHP with the external mysql support and I had the same error. What's the problem ? How to find the cause ? I tried a debugger called Body but It is so slow that I could die before. Thank you Patrice -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]