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 displays it. 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 method variety. 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 well. Any ideas on what to try next? Roger Haase On Wednesday 10 July 2002 05:15 pm, Geoff Talvola wrote: > 15da > Roger, > > 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 > statement. > > - Geoff > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek PC Mods, Computing goodies, cases & more http://thinkgeek.com/sf _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss