[ic] "Out of memory!" error on admin interface with large catalog

Brad Borevitz interchange-users@icdevgroup.org
Thu Jun 27 15:13:00 2002


sorry to repost this, but i was hoping someone might have an idea ...

We are running Interchange 4.8.5 on a virtual server at Verio which limits a
process to 20MB of memory. We are using mySQL for the database. Interchange
is running in "low traffic" mode.

Everything works perfectly until the products database holds more than 1000
records (we have 16,000 plus products). At that point, although the user
facing side of Interchange continues to work fine, some parts of the admin
interface result in 500 errors sent to the browser. with debug set to 1, the
log shows "Out of memory!" and the forked processes dies prematurely.
Interchange and catalog logs show nothing and the web server log shows
"Premature end of script headers".

The features that break are: "Merchandising", "Items" and
"Administration>Tables>Products>Edit Products"

i suspect it's the 'select * from products ' but what can i do?

this is an exerpt from the icdebug log:

    <- DESTROY= undef during global destruction
    <- DESTROY= undef at Server.pm line 962
    DBI::db=HASH(0x9267634) trace level set to 1 in DBI 1.25-nothread
    <- FETCH= DBI::dr=HASH(0x81d3d2c) at DBI.pm line 491
    <- STORE('PrintError' 0 ...)= 1 at DBI.pm line 512
    <- STORE('RaiseError' 1 ...)= 1 at DBI.pm line 512
    <- prepare('select * from products ' CODE)= DBI::st=HASH(0x92676dc) at
DBI.pm line 1470
    <- execute(CODE)= 1999 at DBI.pm line 1472
    <- fetchrow_arrayref= [ '1' '2034 NM/NM' 'Up Popped the Devil' '' '' ''
'' '' '15.00' '' '' '' 'jazz' '' '0.75' '' '' '' '' '' '' '' '' '' 'Enja'
'Waldron Mal' 'W' '3' '//' ] row1 at DBI.pm line 1475
    <- fetchrow_arrayref= undef row1999 at DBI.pm line 1475
    <- DESTROY= undef at DBI.pm line 1485
    <- DESTROY= undef during global destruction
Out of memory!