I added a print statement to my SitePage - it is only being loaded once with
each start of the AppServer. My SitePage contains several variables which
get modified as users logon. Reloading the SitePage will cause servlets to
abend, so I am sure SitePage is not being reloaded.
I had the "TypeError: unbound method" problem again last night while running
with the 'SQLConnectionPoolSize': 20 parameter. I did not notice an increase
in speed (takes 14 seconds to load 100 pictures with or without the
parameter), but I am pretty sure my PC is CPU bound while processing all the
images so I did not expect a speed increase.
I did some more testing this morning with the SQLConnection... parameter back
out (I intend to put it back in and leave it). My testing was with a single
PC under W/ME with an Intel 1.5 and an older WD 30 GB hard drive. To
reiterate, my problem is with a servlet called ShowPix which does 4 calls to
MySQL, loads a JPG file from the file system, manipulates the image and
Out of 13 starts and stops of the AppServer, I had the unbound method problem
5 times. I seem to be able to cause the problem to occur by starting or
stopping other applications such as MS Excel and MS Word while the AppServer
is running, stopping the AppServer, and the problem is likely to occur after
the start of the next AppServer. Personally, I find this hard to believe and
it is not true 100% of the time, just 10 of the 13 tests this morning were
consistent with having/not having the problem based on whether or not I
started or stopped other applications while AppServer was running. On the
other hand, when the problem refused to appear with my first few tests, I
thought of trying it.
Of the five times I had the problem, once only the first ShowPix servlet
to execute abended, and I was unable to get another abend after numerous
tries (using that particular AppServer).
Of the other 4 problem AppServer starts, I had numerous ShowPix abends. I
have a transaction that displays the contents of a directory with 146 JPG
files. The first 100 JPG files are displayed in minature (which results in
100 ShowPix transactions), hitting a next page button displays 46 images,
hitting a previous page button displays the first 100 images again...
(A pretty screwy application, I admit. The images are photographs of
prehistoric rock art panels, my application is trying to identify and extract
individual rock art figures from the photographs and provide a means to
search for a particular type of figure, such as deer with open mouths,
counter-clockwise spirals, etc.)
Back to the 4 problem AppServer starts, in one instance I had 19 ShowPix
abends trying to show 100 images. On the next page I had 10 abends trying to
show 46 images. Doing a previous page, I had 18 abends redisplaying the
first 100 images again. Next page 8 of 46, previous page 21 of 100. While
the numbers are pretty consistent, the individual images causing the abends
are much different each time, and the abends are scattered evenly throughout
the 100 image display. Results for the other three AppServer starts are
similar. The servlet can also display fewer images on a page - when
displaying 9 images per page, only 1 or 2 abend.
Of the several hundred ShowPix abends generated, almost all were the unbound
When I shut down the AppServer with a ctl-c, I do get a Error (9, Bad File
Descripter) message. I think I read here other people were getting that as
Any ideas on what to try next?
On Wednesday 10 July 2002 05:15 pm, Geoff Talvola wrote:
> Can you add a print statement to the place in your SitePage module where
> you create the object store? It sounds to me like the module is getting
> reloaded for some reason. You can tell for sure by adding the print
> - Geoff