Hi Hari, Christian is correct. When dealing with BLOB data, Oracle uses the Temp tablespace and does not free it up until the user who created the BLOB session is closed. As you can imagine, in a JNDI scenario this could be an issue as there could be a situation where the connection is open for a very long time.
I have created a plugin which resolves this issue for georaster - but I was waiting on the outcome of the merge between Christian and Simones code before releasing - I believe I may have sent this to you already? >From my testing, it works with 10g and 11g, and most importantly, the BLOB >issue in the TEMP tablespace is not present. Regards, Steve -----Original Message----- From: christian.muel...@nvoe.at [mailto:christian.muel...@nvoe.at] Sent: 06 September 2011 06:29 To: Harikumar Reddy Cc: Simone Giannecchini; geoserver-users@lists.sourceforge.net; Steve Way Subject: Re: [Geoserver-users] Geoserver 2.1.0 stops very frequently Some additional Info. Here is the Oracle Function causing the problem http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11827/geor_ref.htm#CHEDHBII Geoserver uses this function to export the image into a BLOB. Cheers Christian Zitat von Harikumar Reddy <harik....@gmail.com>: > Hi Christian, > > Thankyou for response. Oracle admin freed up oracle temporary table > space (when they checked free space was zero kb as you have expected) > and created new temporary table space also., but it didnt corrected geoserver > problem. > > we may need to do R & D and observe the results, from image processing > & oracle side (with oracle admin). > > Regards, > Hari. > > On Mon, Sep 5, 2011 at 10:53 PM, <christian.muel...@nvoe.at> wrote: > >> Hi Hari, I am not working with Oracle, as a consequence I have less >> experience, but: >> >> creating an extra Oracle table space is ok, the question was if the >> table space was full at the moment geoserver refuses work. >> >> Was it ? >> >> If the temp tablespace is full then we have the reason but no >> solution. You have to open an oracle ticket because this seems to be >> an Oracle problem. Of course I can assist you in describing the >> situation since I developed the georaster plugin. >> >> >> Cheers >> Christian >> >> >> >> >> Zitat von Harikumar Reddy <harik....@gmail.com>: >> >> Hi Christian, >>> >>> Our oracle admin has created oracle temporary table space, but still >>> this problem exists. Any further investigation i need to do...Please >>> advise me, if you have any idea...The geoserver error is not >>> specific to the problem in log file. >>> >>> Thanking you, >>> >>> Regards, >>> Hari. >>> >>> >>> On Sat, Sep 3, 2011 at 12:38 PM, <christian.muel...@nvoe.at> wrote: >>> >>> Hi, I examined your log file and there is nothing special. There is >>> only >>>> one exception which has nothing to do with our problem here. >>>> >>>> Another user, Steve Way had similar problems and did >>>> investigations. Look here >>>> http://osgeo-org.1803224.n2.****nabble.com/Question-about-**<http:/ >>>> /nabble.com/Question-about-**> >>>> GeoServer-or-GeoTools-support-****for-Oracle-Spatial-**td6283994.** >>>> html< >>>> http://osgeo-**org.1803224.n2.nabble.com/**Question-about-GeoServer >>>> -or-* >>>> *GeoTools-support-for-Oracle-**Spatial-td6283994.html<http://osgeo- >>>> org.1803224.n2.nabble.com/Question-about-GeoServer-or-GeoTools-supp >>>> ort-for-Oracle-Spatial-td6283994.html> >>>> > >>>> >>>> >>>> The important fact: >>>> It seems that Oracle uses its temporary table space to create the image. >>>> Unfortunately it does not release this space afterwards and as a >>>> consequence, the temporary table space reaches its limit. >>>> >>>> Please do the following: >>>> Wait for the next geoserver stop and have an Oracle admin ready to >>>> look at the temporary table space. If it is filled up we may have >>>> found the reason. >>>> >>>> Cheers >>>> Christian >>>> >>>> >>>> >>>> >>>> Zitat von Harikumar Reddy <harik....@gmail.com>: >>>> >>>> >>>> Hi Simone, >>>> >>>>> >>>>> I have imported raster data into oracle spatial 11g r2 as >>>>> georaster and configured with ImageMosaicJDBC plugin datastore. >>>>> >>>>> - Geoserver version is 2.1.0. >>>>> - Connections: 5 >>>>> - GeoServer RAM 4GB >>>>> - JAI Memory 1GB >>>>> - Environment : Linux Cent OS >>>>> - Dervlet container : Tomcat 6.0 >>>>> - deployment environment : Springsource TCserver environment >>>>> - Database : Oracle spatial 11g R2 >>>>> - Raster images type : Georaster (SPOT images) >>>>> - Jai & Jai Image IO are still showing false even after >>>>> successful installation. >>>>> >>>>> I am a pure geotechnician, so i have less knowledge on hardware >>>>> configuration side. Please let me know, if you need any other >>>>> information. >>>>> >>>>> Thanking you, >>>>> >>>>> Regards, >>>>> Hari. >>>>> >>>>> On Fri, Sep 2, 2011 at 10:34 PM, Simone Giannecchini < >>>>> simone.giannecchini@geo-**solu**tions.it <http://solutions.it>< >>>>> simone.giannecchini@**geo-solutions.it<simone.giannecchini@geo-sol >>>>> utions.it> >>>>> >> >>>>> wrote: >>>>> >>>>> Ciao Hari, >>>>> >>>>>> I would need to know a bit more about how you configured this >>>>>> data and about the server config otherwiser I would be alone in the dark. >>>>>> >>>>>> Regards, >>>>>> Simone Giannecchini >>>>>> ------------------------------****------------------------- >>>>>> Ing. Simone Giannecchini >>>>>> GeoSolutions S.A.S. >>>>>> Founder >>>>>> >>>>>> Via Poggio alle Viti 1187 >>>>>> 55054 Massarosa (LU) >>>>>> Italy >>>>>> >>>>>> phone: +39 0584 962313 >>>>>> fax: +39 0584 962313 >>>>>> mob: +39 333 8128928 >>>>>> >>>>>> http://www.geo-solutions.it >>>>>> http://geo-solutions.blogspot.****com/<http://geo-solutions.** >>>>>> blogspot.com/ <http://geo-solutions.blogspot.com/>> >>>>>> http://www.youtube.com/user/****GeoSolutionsIT<http://www.youtube >>>>>> .com/user/**GeoSolutionsIT> >>>>>> <http://www.**youtube.com/user/**GeoSolutionsIT<http://www.youtub >>>>>> e.com/user/GeoSolutionsIT> >>>>>> > >>>>>> http://www.linkedin.com/in/****simonegiannecchini<http://www.link >>>>>> edin.com/in/**simonegiannecchini> >>>>>> <http://www.**linkedin.com/in/**simonegiannecchini<http://www.lin >>>>>> kedin.com/in/simonegiannecchini> >>>>>> > >>>>>> >>>>>> http://twitter.com/simogeo >>>>>> >>>>>> ------------------------------****------------------------- >>>>>> >>>>>> >>>>>> >>>>>> On Fri, Sep 2, 2011 at 5:50 PM, Harikumar Reddy >>>>>> <harik....@gmail.com> >>>>>> wrote: >>>>>> > Hi Simone, >>>>>> > >>>>>> > Thankyou for quick reply. >>>>>> > >>>>>> > I am working directly in production environment (only for imageries). >>>>>> So >>>>>> I >>>>>> > need to inform client priorly. If newer version will surely >>>>>> > solve the problem, then i can request them. For checking >>>>>> > locally, we dont have >>>>>> those >>>>>> > imageries with us. We are working through secured gateways. I >>>>>> > haven't observed this problem before in 2.0.2 version. I have >>>>>> > configured >>>>>> around >>>>>> 110 >>>>>> > GB SPOT imageries 2 months before (now also i have to remove >>>>>> > old and >>>>>> need >>>>>> to >>>>>> > configure same area with updated imageries). Any work around is >>>>>> possible >>>>>> ? >>>>>> > >>>>>> > Could you please suggest me that is it caused due to memory >>>>>> > problems (hardware side or geoserver side). From logs URI not >>>>>> > receiving error >>>>>> i >>>>>> have >>>>>> > seen...but i need to investigate this problem. >>>>>> > >>>>>> > Regards, >>>>>> > Hari. >>>>>> > >>>>>> > On Fri, Sep 2, 2011 at 8:11 PM, Simone Giannecchini >>>>>> > <simone.giannecchini@geo-**sol**utions.it >>>>>> > <http://solutions.it>< >>>>>> simone.giannecchini@**geo-solutions.it<simone.giannecchini@geo-so >>>>>> lutions.it> >>>>>> >> >>>>>> >>>>>> wrote: >>>>>> >> >>>>>> >> Ciao Hari, >>>>>> >> quick suggestion since we fixed a few glitches with raster >>>>>> >> data in 2,1.0, can you try to upgrade to 2.1.1 or even to >>>>>> >> 2.1.x nightly and then check this issues again? >>>>>> >> >>>>>> >> Regards, >>>>>> >> Simone Giannecchini >>>>>> >> ------------------------------****------------------------- >>>>>> >> Ing. Simone Giannecchini >>>>>> >> GeoSolutions S.A.S. >>>>>> >> Founder >>>>>> >> >>>>>> >> Via Poggio alle Viti 1187 >>>>>> >> 55054 Massarosa (LU) >>>>>> >> Italy >>>>>> >> >>>>>> >> phone: +39 0584 962313 >>>>>> >> fax: +39 0584 962313 >>>>>> >> mob: +39 333 8128928 >>>>>> >> >>>>>> >> http://www.geo-solutions.it >>>>>> >> >>>>>> >> http://geo-solutions.blogspot.****com/<http://geo-solutions.** >>>>>> blogspot.com/ <http://geo-solutions.blogspot.com/>> >>>>>> >> >>>>>> http://www.youtube.com/user/****GeoSolutionsIT<http://www.youtube >>>>>> .com/user/**GeoSolutionsIT> >>>>>> <http://www.**youtube.com/user/**GeoSolutionsIT<http://www.youtub >>>>>> e.com/user/GeoSolutionsIT> >>>>>> > >>>>>> >> >>>>>> http://www.linkedin.com/in/****simonegiannecchini<http://www.link >>>>>> edin.com/in/**simonegiannecchini> >>>>>> <http://www.**linkedin.com/in/**simonegiannecchini<http://www.lin >>>>>> kedin.com/in/simonegiannecchini> >>>>>> > >>>>>> >>>>>> >> http://twitter.com/simogeo >>>>>> >> >>>>>> >> ------------------------------****------------------------- >>>>>> >> >>>>>> >> >>>>>> >> >>>>>> >> On Fri, Sep 2, 2011 at 2:46 PM, Harikumar Reddy < >>>>>> harik....@gmail.com> >>>>>> >> wrote: >>>>>> >> > Hari >>>>>> > >>>>>> > >>>>>> > >>>>>> ------------------------------****----------------------------**- >>>>>> -** >>>>>> ------------------ >>>>>> > Special Offer -- Download ArcSight Logger for FREE! >>>>>> > Finally, a world-class log management solution at an even >>>>>> > better price-free! And you'll get a free "Love Thy Logs" >>>>>> > t-shirt when you download Logger. Secure your free ArcSight Logger >>>>>> > TODAY! >>>>>> > >>>>>> http://p.sf.net/sfu/****arcsisghtdev2dev<http://p.sf.net/sfu/**ar >>>>>> csisghtdev2dev> >>>>>> <http://p.sf.**net/sfu/arcsisghtdev2dev<http://p.sf.net/sfu/arcsi >>>>>> sghtdev2dev> >>>>>> > >>>>>> > ______________________________****_________________ >>>>>> > Geoserver-users mailing list >>>>>> > Geoserver-users@lists.**source**forge.net >>>>>> > <http://sourceforge.net>< >>>>>> Geoserver-users@**lists.sourceforge.net<geoserver-us...@lists.sou >>>>>> rceforge.net> >>>>>> > >>>>>> > >>>>>> https://lists.sourceforge.net/****lists/listinfo/geoserver-**user >>>>>> s<https://lists.sourceforge.net/**lists/listinfo/geoserver-users> >>>>>> <https://lists.**sourceforge.net/lists/**listinfo/geoserver-users >>>>>> <https://lists.sourceforge.net/lists/listinfo/geoserver-users> >>>>>> > >>>>>> > >>>>>> > >>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> ------------------------------****----------------------------**--* >>>> *---- This message was sent using IMP, the Internet Messaging >>>> Program. >>>> >>>> >>>> >>>> >>> >> >> >> ------------------------------**------------------------------**---- >> This message was sent using IMP, the Internet Messaging Program. >> >> >> > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. DISCLAIMER: This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or mail.ad...@infotech-enterprises.com and delete the original message. ------------------------------------------------------------------------------ Special Offer -- Download ArcSight Logger for FREE! Finally, a world-class log management solution at an even better price-free! And you'll get a free "Love Thy Logs" t-shirt when you download Logger. Secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsisghtdev2dev _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
