[ic] 500 error on design link

[interchange-users@icdevgroup.org (Dan Browning)]

At 12:31 PM 10/29/2002 -0600, you wrote:
>On Tue, 2002-10-29 at 12:05, Brian Kosick wrote:
> > Richard Watson wrote:
> >
> > >"Kevin Walsh" <kevin@cursor.biz> writes:
> > >
> > >
> > >
> > >>Hmmm, that's two reports of what appears to be the same problem, from
> > >>two different people, on the same day.
> > >>
> > >>
> > >
> > >Make that 3 - but I've had this problem intermittently for a few
> > >weeks. It seems to sort out if you remove the .gdbm files and restart
> > >interchange. At the moment I'm putting it down to too many open files
> > >for the server, but I might well be wrong there. I've tried increasing
> > >/proc/sys/fs/file-max so we'll see if that helps.
> > >
> > >Certainly it's not a problem for all the catalogs, only one in
> > >particular.
> > >
> > >In my logs I'm getting:
> > >
> > >213.208.86.139 ss57s46r:213.208.86.139 - [29/October/2002:15:58:00
> > >           +0100] cat1 /cgi-bin/ic/cat1/admin/layout.html Died
> > >           in server spawn: Could not tie to
> > >           '/var/lib/interchange/catalogs/cat1/products/area.gdbm':
> > >           Resource temporarily unavailable at
> > >           /usr/lib/interchange/Vend/Table/GDBM.pm line 115.
> > >
> > >
> > >
> > >>  2. Which version of Interchange are you using?
> > >>
> > >>
> > >
> > >4.8.6 on Debian.
> > >
> > >
> > >
> > >>  3. Which version of Perl are you using?
> > >>
> > >>
> > >
> > >5.6.1
> > >
> > >
> > >
> > >>  4. Has this just started happening, or did it never work for you?
> > >>     If it's a new problem, then what has changed recently?
> > >>
> > >>
> > >
> > >Recently, and only in this one machine which hasn't been running IC
> > >for that long. Fortunately it's just our test server.
> > >
> > >
> > >
> > >>  5. Can you re-create the problem on the "live demo" and/or provide a
> > >>     step-by-step list of what to do for others to follow in order to
> > >>     recreate the problem.
> > >>
> > >>
> > >
> > >No I can't recreate the problem, but over time it will happen again.
> > >
> > >
> > >
> > Funny, I've noticed this too with the area.gdbm  restarting the server
> > fixes it for me.  this is on a 4SMP, redhat7.3, perl5.6.x, 1GB RAM.
> > Doesn't occur on all of our IC installations either....
> >
> >
> > I'm am running, at home, redhat 8.0, interchange 4.8.6, and apache 2.x
> > and have expereinced no problems.....
> >
>
>When I first starting using Interchange (a month and a half ago) I tried
>importing our inventory via the Excel importer.  Every single time, no
>matter what hardware I was on (testing on three separate machines) it
>would crash.  The spreadsheet is 16,000 rows.  So I broke it up into
>smaller chunks, and sure enough, at 4,000 rows per sheet it worked.

FYI, I have some clients that routinely import 30,000 row Excel files.

--

/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
| Dan Browning, Kavod Technologies      <dan.browning@kavod.com> |
| (360) 882-7872 x7, 6700 NE 162nd Ave, Suite 210, Vancouver, WA |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
The grand leap of the whale up the Fall of Niagara is esteemed, by all
who have seen it, as one of the finest spectacles in nature.
                 -- Benjamin Franklin.