Hi Steve,
we have deployed application on GS 2.1.1 in the evening. No problems till now :-). It would be helpful for me, if you provide the details of oracle jar files to be copied to geoserver web-inf/lib. I will copy and test.
Thanking you,
Regards,
Hari.
On Wed, Sep 7, 2011 at 9:12 PM, Steve Way <Steve.Way@anonymised.com> wrote:
Hi Christian,
Not quite an expert just spent too much time getting annoyed with Oracle GR!
In answer to your questions below:
This method they are using a table, creating a LOB Locator and passing the LOB Locator to the function - this is still using the temp tablespace, but when you commit the change to the table, it will clear the temp.
Unfortunately not as we need to return the BLOB to the java code, if we freeTemporary before we return, we will get a blank image.
There is however, a way around this. The plugin I created, has two types of retrieval of georaster - one similar to yours using export to - the only limitation here is image size (I think max export is 64MB) and native (declared in config file). The native works brilliantly has no issues with creating or freeing temp space and performs really well - we have had it in production now for 6 months without any issues. Only problem is you need to bring some libs from your oracle db home to the geoserver web-inf/lib.
The exportTo method which we can use in our plugin is based on your code, except I placed the create and free temp methods using java calls - and there is also an After Logon trigger which needs to be created against the oracle schema user that will use the raster data. Here is a snippet of how we are doing the exportTo:
oracle.sql.BLOB blob = null;
…
String StmtTemplateExport = "declare " + "gr sdo_georaster; " + "lb blob; " + "begin "
- "dbms_lob.createTemporary(lb,false,DBMS_LOB.CALL); "
- "select a.%s into gr from %s a where a.%s.rasterid = ?; "
- "sdo_geor.exportTo(gr, ?, ‘%s’, lb); " + "?:=lb; "
- "end; ";
…
blob = (BLOB)callablestatement.getBlob(3);
…
blob.freeTemporary();
The trigger needs to be something like this:
create or replace
TRIGGER RASTER_LOGON
AFTER LOGON ON DATABASE
DECLARE
sqlstr VARCHAR2(200) := ‘alter session set events ‘‘60025 trace name context forever’’’;
BEGIN
if ( user = ‘RASTER’ )
then
execute immediate sqlstr;
end if;
END RASTER_LOGON;This is probably a good enough reason to have just one geoR plugin!
Hope I haven’t confused anyone even more!Cheers,
Steve
-----Original Message-----
From: christian.mueller@anonymised.com1968… [mailto:christian.mueller@anonymised.com]Sent: 07 September 2011 12:45
To: Steve Way
Cc: Harikumar Reddy; Simone Giannecchini; geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] Geoserver 2.1.0 stops very frequentlyYep, I see.
Steve, as you are an expert in the mean time I have 2 questions.
Looking here
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11827/geor_ref.htm#autoId12
I see some samples for exportTo without calling createTemporary. Would this work in our case ?
Looking at function getRasterData, I see an example
DECLARE
gr sdo_georaster;
lb blob;
BEGIN
SELECT georaster INTO gr FROM georaster_table WHERE georid=2;
dbms_lob.createTemporary(lb, FALSE);
sdo_geor.getRasterData(gr, 0, lb, ‘compress=JPEG-F’);
dbms_lob.freeTemporary(lb);
END;Is it possible to call freeTemporary when using exportTo instead of getRasterData ?
Some confusion here on my side
Zitat von Steve Way <Steve.Way@anonymised.com…3551…>:
Actually it is not an Oracle Issue as such but more as design.
When I first discovered this issue (when designing the GeoRaster
Plugin), I spent a lot of time trying to figure it out. It all
comes down to two functions called: createTemporary() and
freeTemporary().Christian, you will see from your code, that you are calling the
createTemporary() in your callable statement, but not the
freeTemporary(). With a callable statement like this, you cannot
call the freeTemporary() as you would need to do this AFTER you have
retrieved the blob from Oracle, and as with java, PL/SQL you are
unable to call a function after a return.Therefore, the only way to do this is use the Oracle Spatial Java
API to createTemporary and freeTemporary against an Oracle BLOB type.Regards,
Steve-----Original Message-----
From: christian.mueller@anonymised.com [mailto:christian.mueller@anonymised.com]
Sent: 06 September 2011 14:18
To: Harikumar Reddy
Cc: Simone Giannecchini; geoserver-users@lists.sourceforge.net; Steve
Way
Subject: Re: [Geoserver-users] Geoserver 2.1.0 stops very frequentlyHmmm, I would say you are sitting on a time bomb because there is a
good chance that the temp space becomes full again.Do you have a support contract with Oracle giving you the
possibility to open a ticket.@Steve, do you have the possibility to open a ticket
I fear that this problem will reoccur many times in the future.
Christian
Zitat von Harikumar Reddy <harik.gis@anonymised.com>:
Hi Christian,
Thankyou for georaster oracle function url. Yesterday, our oracle
admin has not restarted the database after temporary table space
creation. He has restarted the database today. I think now geoserver
is working fine., but i can only confirm myself about the geoserver
consistency by observing till this weekend.Regards,
Hari.On Tue, Sep 6, 2011 at 10:58 AM, <christian.mueller@anonymised.com> wrote:
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<http://download.oracle.com/docs/cd/E1188 2_01/appdev.112/e11827/geor_ref.htm#CHEDHBII>
Geoserver uses this function to export the image into a BLOB.
Cheers
ChristianZitat von Harikumar Reddy <harik.gis@anonymised.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.mueller@anonymised.com> wrote:
Hi Hari, I am not working with Oracle, as a consequence I have
lessexperience, 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
ChristianZitat von Harikumar Reddy <harik.gis@anonymised.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.mueller@anonymised.com> wrote:
Hi, I examined your log file and there is nothing special. There
is onlyone 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-<http://nabble.com/Questionabout-**>
GeoServer-or-GeoTools-support-*for-Oracle-Spatial-
td6283994.**html<
http://osgeo-org.1803224.n2.nabble.com/Question-about-
GeoServer-or-<http://org.1803224.n2.nabble.com/**Question-aboutGeoServer-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://o
s
geo-org.1803224.n2.nabble.com/Question-about-GeoServer-or-GeoTool s-support-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
ChristianZitat von Harikumar Reddy <harik.gis@anonymised.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@anonymised.com****solu**tions.it
<http://solutions.it>< simone.giannecchini@geo-solutions.it
<http://geo-solutions.it><
simone.**giannecchini@anonymised.com<simone.giannecchini@anonymised.com
s
olutions.it>wrote:
Ciao Hari,
I would need to know a bit more about how you configured this
dataand
about the server config otherwiser I would be alone in the dark.Regards,
Simone Giannecchini
------------------------------******-------------------------
Ing. Simone Giannecchini
GeoSolutions S.A.S.
FounderVia Poggio alle Viti 1187
55054 Massarosa (LU)
Italyphone: +39 0584 962313
fax: +39 0584 962313
mob: +39 333 8128928http://www.geo-solutions.it
http://geo-solutions.blogspot.******com/<http://geo-solutions.
blogspot.com/
<http://geo-solutions.**blogspot.com/<http://geo-solutions.blo
g
spot.com/>http://www.youtube.com/user/******GeoSolutionsIT<http://www.yo
<http://www.**youtube.com/user/****GeoSolutionsIT<http://www.y
<http://www.youtube.com/**user/**GeoSolutionsIT<http://youtu
b
e.com/user/**GeoSolutionsIT>
<http://www.youtube.com/user/**GeoSolutionsIT<http://www.you
t
ube.com/user/GeoSolutionsIT>http://www.linkedin.com/in/******simonegiannecchini<http://www.
linkedin.com/in/****simonegiannecchini><http://**www.linkedin.com/in/****simonegiannecchini<http://ww
w .linkedin.com/in/**simonegiannecchini><http://www.**linkedin.com/in/****simonegiannecchini<http://li
n kedin.com/in/**simonegiannecchini><http://**www.linkedin.com/in/**simonegiannecchini<http://www.
l inkedin.com/in/simonegiannecchini>------------------------------******-------------------------
On Fri, Sep 2, 2011 at 5:50 PM, Harikumar Reddy
<harik.gis@anonymised.comwrote:
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@anonymised.com4361…**solutions.it
<http://solutions.it <
simone.giannecchini@geo-solutions.it
<http://geo-solutions.it><
simone.**giannecchini@anonymised.com<simone.giannecchini@anonymised.com
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.
FounderVia Poggio alle Viti 1187
55054 Massarosa (LU)
Italyphone: +39 0584 962313
fax: +39 0584 962313
mob: +39 333 8128928http://geo-solutions.blogspot.**com/<http://geo-solutio
n
s.
**
blogspot.com/
<http://geo-solutions.blogspot.com/<http://geo-solutions.blo
ghttp://www.youtube.com/user/******GeoSolutionsIT<http://www.yo
<http://www.**youtube.com/user/****GeoSolutionsIT<http://www.y
<http://www.youtube.com/**user/**GeoSolutionsIT<http://youtu
b
e.com/user/**GeoSolutionsIT>
<http://www.youtube.com/user/**GeoSolutionsIT<http://www.you
t
ube.com/user/GeoSolutionsIT>http://www.linkedin.com/in/******simonegiannecchini<http://www.
linkedin.com/in/****simonegiannecchini><http://**www.linkedin.com/in/****simonegiannecchini<http://ww
w .linkedin.com/in/**simonegiannecchini><http://www.**linkedin.com/in/****simonegiannecchini<http://li
n kedin.com/in/**simonegiannecchini><http://**www.linkedin.com/in/**simonegiannecchini<http://www.
l inkedin.com/in/simonegiannecchini>------------------------------******-----------------------
On Fri, Sep 2, 2011 at 2:46 PM, Harikumar Reddy <
harik.gis@anonymised.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
/
****arcsisghtdev2dev>
<http://p.sf.**net/sfu/**arcsisghtdev2dev<http://p.sf.net/sfu/
*
*arcsisghtdev2dev><http://p.sf.**net/sfu/arcsisghtdev2dev<http://p.sf.
net/sfu/arcsisghtdev2dev
<http://p.sf.net/sfu/arcsisghtdev2dev>>_____________******
Geoserver-users mailing list
Geoserver-users@anonymised.com****source**forge.net <
http://sourceforge.net><
Geoserver-users@lists.sourceforge.net<http://lists.sourcef
o
rge.net>
<Geoserver-**users@lists.sourceforge.net<Geoserver-users@anonymised.com
sourceforge.net>https://lists.sourceforge.net/******lists/listinfo/geoserver
*users<https://lists.sourceforge.net/****lists/listinfo/geoser
v
er-users>
<https://lists.sourceforge.net/**lists/**listinfo/geoserver-
u
sers<https://lists.sourceforge.net/**lists/listinfo/geoserver-
u
sers><https://lists.**sourceforge.net/lists/listinfo/
geoserver-users<http://sourceforge.net/lists/**listinfo/geoser
v
er-users>
<https://lists.sourceforge.net/lists/**listinfo/geoserver-us
ers<https://lists.sourceforge.net/lists/listinfo/geoserver-user
s--------------------------------------------------------
––----
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.
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.Admin@anonymised.com and delete the original message.
This message was sent using IMP, the Internet Messaging Program.