Hello,
I have an oracle DB-based data store serving half a dozen layers/feature types. One of the tables have >6000000 objects. When I config this feature type using the GUI, I can get as far as the Demo and I'm able to see the features. (I have defined the bbox manually as the generate button took ages.)
I then shut gs down, and try to restart it. It loads the other types, but doesn't get past the one with the large table.
I can, however, see the features with udig. (It's there, it's indexed, it's performing well.)
GS is 1.7.2. OS is Windows XP. DB is Oracle on Linux.
Does anyone have an idea about what's happening?
Cheers,
Ugo
--
Ugo Taddei
Fraunhofer Institut Intelligente Analyse- und Informationssysteme (FhG IAIS)
http://www.iais.fraunhofer.de
Department Knowledge Discovery - IAIS.KD -
Working Group Spatial Decision Support
http://www.iais.fraunhofer.de/kd.html
phone (+49)2241-14-2184 fax (+49)2241-14-2072
Schloss Birlinghoven, D-53754 Sankt Augustin, Germany
Hi Ugo,
Download the latest Geoserver and Oracle NG driver. I suppose you have a version that used to send
SELECT sdo_aggr_mbr(t.geom) when starting up.
-Jukka Rahkonen-
-----Alkuperäinen viesti-----
Lähettäjä: Ugo Taddei [mailto:ugo.taddei@anonymised.com]
Lähetetty: 26. helmikuuta 2009 12:38
Vastaanottaja: geoserver users
Aihe: [Geoserver-users] Slow or no start for large table
Hello,
I have an oracle DB-based data store serving half a dozen
layers/feature types. One of the tables have >6000000
objects. When I config this feature type using the GUI, I can
get as far as the Demo and I'm able to
see the features. (I have defined the bbox manually as the
generate button took ages.)
I then shut gs down, and try to restart it. It loads the
other types, but doesn't get past the one with the large table.
I can, however, see the features with udig. (It's there, it's
indexed, it's performing well.)
GS is 1.7.2. OS is Windows XP. DB is Oracle on Linux.
Does anyone have an idea about what's happening?
Cheers,
Ugo
--
Ugo Taddei
Fraunhofer Institut Intelligente Analyse- und
Informationssysteme (FhG IAIS) http://www.iais.fraunhofer.de
Department Knowledge Discovery - IAIS.KD - Working Group
Spatial Decision Support http://www.iais.fraunhofer.de/kd.html
phone (+49)2241-14-2184 fax (+49)2241-14-2072
Schloss Birlinghoven, D-53754 Sankt Augustin, Germany
--------------------------------------------------------------
----------------
Open Source Business Conference (OSBC), March 24-25, 2009,
San Francisco, CA -OSBC tackles the biggest issue in open
source: Open Sourcing the Enterprise -Strategies to boost
innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the
source code: SFAD http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Hallo Rahkonen,
Rahkonen Jukka wrote:
Hi Ugo,
Download the latest Geoserver and Oracle NG driver. I suppose you have a version that used to send SELECT sdo_aggr_mbr(t.geom) when starting up.
-Jukka Rahkonen-
thanks for the tip. I downloaded the NG jar from http://sourceforge.net/project/showfiles.php?group_id=25086&package_id=129885&release_id=271218
as described in
http://geoserver.org/display/GEOSDOC/2+DataStore+Config
Read the read_me and dropped the gt2-oracle.jar into lib/, having first deleted the previous version. Now gs doesn't start because of a class version incompatibility:
26 Feb 13:17:59 WARN [support.DisposableBeanAdapter] - Invocation of destroy method failed on bean with name 'geoServerL
oader': org.springframework.beans.factory.BeanCreationNotAllowedException: Error creating bean with name 'wcsLoader': Singleton bean creation not allowed while the singletons of this factory are in destruction (Do not request a bean from a BeanFactory in a destroy method implementation!)
26 Feb 13:17:59 ERROR [context.ContextLoader] - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'applicationState' defined in URL
[file:/C:/tmp/geoserver-1.7.2/webapps/geoserver/WEB-INF/classes/applicationContext.xml]: Cannot resolve reference to be
an 'data' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationExceptio
n: Error creating bean with name 'data' defined in URL [jar:file:/C:/tmp/geoserver-1.7.2/webapps/geoserver/WEB-INF/lib/m
ain-1.7.2.jar!/applicationContext.xml]: Cannot resolve reference to bean 'geoServer2' while setting constructor argument
; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'geoServer2
' defined in URL [jar:file:/C:/tmp/geoserver-1.7.2/webapps/geoserver/WEB-INF/lib/main-1.7.2.jar!/applicationContext.xml]
: Initialization of bean failed; nested exception is *java.lang.NoSuchMethodError: org.geotools.data.jdbc.JDBCDataStore.<
init>(Lorg/geotools/data/jdbc/ConnectionPool;Ljava/lang/String;Ljava/util/Map;Ljava/lang/String;)V*
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueRes
olver.java:275)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionV
alueResolver.java:104)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver
.java:495)
That is, I made no alteration to the config (catalog.xml or info.xml). Just dropped the new version. Looks like it's incompatible to the org.geotools.data.jdbc.JDBCDataStore I got on my geoserver. Which geotools version do I need?
By the way, I am using gs 1.7.2! (GeoServer 1.7.2 (January 19, 2008))
Cheers,
Ugo
-----Alkuperäinen viesti-----
Lähettäjä: Ugo Taddei [mailto:ugo.taddei@anonymised.com] Lähetetty: 26. helmikuuta 2009 12:38
Vastaanottaja: geoserver users
Aihe: [Geoserver-users] Slow or no start for large table
Hello,
I have an oracle DB-based data store serving half a dozen layers/feature types. One of the tables have >6000000 objects. When I config this feature type using the GUI, I can get as far as the Demo and I'm able to
see the features. (I have defined the bbox manually as the generate button took ages.)
I then shut gs down, and try to restart it. It loads the other types, but doesn't get past the one with the large table.
I can, however, see the features with udig. (It's there, it's indexed, it's performing well.)
GS is 1.7.2. OS is Windows XP. DB is Oracle on Linux.
Does anyone have an idea about what's happening?
Cheers,
Ugo
--
Ugo Taddei
Fraunhofer Institut Intelligente Analyse- und Informationssysteme (FhG IAIS) http://www.iais.fraunhofer.de Department Knowledge Discovery - IAIS.KD - Working Group Spatial Decision Support http://www.iais.fraunhofer.de/kd\.html
phone (+49)2241-14-2184 fax (+49)2241-14-2072
Schloss Birlinghoven, D-53754 Sankt Augustin, Germany
--------------------------------------------------------------
----------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Ugo Taddei
Fraunhofer Institut Intelligente Analyse- und Informationssysteme (FhG IAIS)
http://www.iais.fraunhofer.de
Department Knowledge Discovery - IAIS.KD -
Working Group Spatial Decision Support
http://www.iais.fraunhofer.de/kd.html
phone (+49)2241-14-2184 fax (+49)2241-14-2072
Schloss Birlinghoven, D-53754 Sankt Augustin, Germany
Hi,
Perhaps you need to update the Geoserver to the latest nightly build as well from here:
http://gridlock.openplans.org/geoserver/1.7.x/
Take both the latest Geoserver and ext-latest.
-Jukka-
-----Alkuperäinen viesti-----
Lähettäjä: Ugo Taddei [mailto:ugo.taddei@anonymised.com]
Lähetetty: 26. helmikuuta 2009 14:27
Vastaanottaja: Rahkonen Jukka
Kopio: geoserver users
Aihe: Re: [Geoserver-users] Slow or no start for large table
Hallo Rahkonen,
Rahkonen Jukka wrote:
> Hi Ugo,
>
> Download the latest Geoserver and Oracle NG driver. I
suppose you have
> a version that used to send SELECT sdo_aggr_mbr(t.geom)
when starting up.
>
> -Jukka Rahkonen-
thanks for the tip. I downloaded the NG jar from
http://sourceforge.net/project/showfiles.php?group_id=25086&pa
ckage_id=129885&release_id=271218
as described in
http://geoserver.org/display/GEOSDOC/2+DataStore+Config
Read the read_me and dropped the gt2-oracle.jar into lib/,
having first deleted the previous version. Now gs doesn't
start because of a class version incompatibility:
26 Feb 13:17:59 WARN [support.DisposableBeanAdapter] -
Invocation of destroy method failed on bean with name 'geoServerL
oader':
org.springframework.beans.factory.BeanCreationNotAllowedExcept
ion: Error creating bean with name 'wcsLoader': Singleton
bean creation not allowed while the singletons of this
factory are in destruction (Do not request a bean from a
BeanFactory in a destroy method implementation!)
26 Feb 13:17:59 ERROR [context.ContextLoader] - Context
initialization failed
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'applicationState' defined in URL
[file:/C:/tmp/geoserver-1.7.2/webapps/geoserver/WEB-INF/classe
s/applicationContext.xml]:
Cannot resolve reference to be
an 'data' while setting constructor argument; nested
exception is org.springframework.beans.factory.BeanCreationExceptio
n: Error creating bean with name 'data' defined in URL
[jar:file:/C:/tmp/geoserver-1.7.2/webapps/geoserver/WEB-INF/lib/m
ain-1.7.2.jar!/applicationContext.xml]: Cannot resolve
reference to bean 'geoServer2' while setting constructor
argument ; nested exception is
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'geoServer2 ' defined in URL
[jar:file:/C:/tmp/geoserver-1.7.2/webapps/geoserver/WEB-INF/li
b/main-1.7.2.jar!/applicationContext.xml]
: Initialization of bean failed; nested exception is
*java.lang.NoSuchMethodError: org.geotools.data.jdbc.JDBCDataStore.<
init>(Lorg/geotools/data/jdbc/ConnectionPool;Ljava/lang/String
;Ljava/uti
init>l/Map;Ljava/lang/String;)V*
at
org.springframework.beans.factory.support.BeanDefinitionValueR
esolver.resolveReference(BeanDefinitionValueRes
olver.java:275)
at
org.springframework.beans.factory.support.BeanDefinitionValueR
esolver.resolveValueIfNecessary(BeanDefinitionV
alueResolver.java:104)
at
org.springframework.beans.factory.support.ConstructorResolver.
resolveConstructorArguments(ConstructorResolver
.java:495)
That is, I made no alteration to the config (catalog.xml or
info.xml).
Just dropped the new version. Looks like it's incompatible to
the org.geotools.data.jdbc.JDBCDataStore I got on my
geoserver. Which geotools version do I need?
By the way, I am using gs 1.7.2! (GeoServer 1.7.2 (January 19, 2008))
Cheers,
Ugo
>
>> -----Alkuperäinen viesti-----
>> Lähettäjä: Ugo Taddei [mailto:ugo.taddei@anonymised.com]
>> Lähetetty: 26. helmikuuta 2009 12:38
>> Vastaanottaja: geoserver users
>> Aihe: [Geoserver-users] Slow or no start for large table
>>
>> Hello,
>>
>> I have an oracle DB-based data store serving half a dozen
>> layers/feature types. One of the tables have >6000000
objects. When I
>> config this feature type using the GUI, I can get as far
as the Demo
>> and I'm able to
>> see the features. (I have defined the bbox manually as
the generate
>> button took ages.)
>>
>> I then shut gs down, and try to restart it. It loads the
other types,
>> but doesn't get past the one with the large table.
>>
>> I can, however, see the features with udig. (It's there, it's
>> indexed, it's performing well.)
>>
>> GS is 1.7.2. OS is Windows XP. DB is Oracle on Linux.
>>
>> Does anyone have an idea about what's happening?
>>
>> Cheers,
>>
>> Ugo
>>
>> --
>> Ugo Taddei
>>
>> Fraunhofer Institut Intelligente Analyse- und Informationssysteme
>> (FhG IAIS) http://www.iais.fraunhofer.de Department Knowledge
>> Discovery - IAIS.KD - Working Group Spatial Decision Support
>> http://www.iais.fraunhofer.de/kd.html
>> phone (+49)2241-14-2184 fax (+49)2241-14-2072
>> Schloss Birlinghoven, D-53754 Sankt Augustin, Germany
>>
>> --------------------------------------------------------------
>> ----------------
>> Open Source Business Conference (OSBC), March 24-25, 2009, San
>> Francisco, CA -OSBC tackles the biggest issue in open
>> source: Open Sourcing the Enterprise -Strategies to boost
innovation
>> and cut costs with open source participation -Receive a
$600 discount
>> off the registration fee with the source code: SFAD
>> http://p.sf.net/sfu/XcvMzF8H
>> _______________________________________________
>> Geoserver-users mailing list
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
>
>
--
Ugo Taddei
Fraunhofer Institut Intelligente Analyse- und
Informationssysteme (FhG IAIS) http://www.iais.fraunhofer.de
Department Knowledge Discovery - IAIS.KD - Working Group
Spatial Decision Support http://www.iais.fraunhofer.de/kd.html
phone (+49)2241-14-2184 fax (+49)2241-14-2072
Schloss Birlinghoven, D-53754 Sankt Augustin, Germany
Hello,
just to say thanks again. I went for your suggestion and all went well.
I'm using the latest GS (1.7.x) and the ext-latest jars.
Cheers,
Ugo
Rahkonen Jukka wrote:
Hi,
Perhaps you need to update the Geoserver to the latest nightly build as well from here:
http://gridlock.openplans.org/geoserver/1.7.x/
Take both the latest Geoserver and ext-latest.
-Jukka-
-----Alkuperäinen viesti-----
Lähettäjä: Ugo Taddei [mailto:ugo.taddei@anonymised.com] Lähetetty: 26. helmikuuta 2009 14:27
Vastaanottaja: Rahkonen Jukka
Kopio: geoserver users
Aihe: Re: [Geoserver-users] Slow or no start for large table
Hallo Rahkonen,
Rahkonen Jukka wrote:
Hi Ugo,
Download the latest Geoserver and Oracle NG driver. I
suppose you have
a version that used to send SELECT sdo_aggr_mbr(t.geom)
when starting up.
-Jukka Rahkonen-
thanks for the tip. I downloaded the NG jar from
http://sourceforge.net/project/showfiles.php?group_id=25086&pa
ckage_id=129885&release_id=271218
as described in
http://geoserver.org/display/GEOSDOC/2+DataStore+Config
Read the read_me and dropped the gt2-oracle.jar into lib/, having first deleted the previous version. Now gs doesn't start because of a class version incompatibility:
26 Feb 13:17:59 WARN [support.DisposableBeanAdapter] - Invocation of destroy method failed on bean with name 'geoServerL
oader': org.springframework.beans.factory.BeanCreationNotAllowedExcept
ion: Error creating bean with name 'wcsLoader': Singleton bean creation not allowed while the singletons of this factory are in destruction (Do not request a bean from a BeanFactory in a destroy method implementation!)
26 Feb 13:17:59 ERROR [context.ContextLoader] - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'applicationState' defined in URL
[file:/C:/tmp/geoserver-1.7.2/webapps/geoserver/WEB-INF/classe
s/applicationContext.xml]: Cannot resolve reference to be
an 'data' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationExceptio
n: Error creating bean with name 'data' defined in URL [jar:file:/C:/tmp/geoserver-1.7.2/webapps/geoserver/WEB-INF/lib/m
ain-1.7.2.jar!/applicationContext.xml]: Cannot resolve reference to bean 'geoServer2' while setting constructor argument ; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'geoServer2 ' defined in URL [jar:file:/C:/tmp/geoserver-1.7.2/webapps/geoserver/WEB-INF/li
b/main-1.7.2.jar!/applicationContext.xml]
: Initialization of bean failed; nested exception is
*java.lang.NoSuchMethodError: org.geotools.data.jdbc.JDBCDataStore.<
init>(Lorg/geotools/data/jdbc/ConnectionPool;Ljava/lang/String
;Ljava/uti
init>l/Map;Ljava/lang/String;)V*
at
org.springframework.beans.factory.support.BeanDefinitionValueR
esolver.resolveReference(BeanDefinitionValueRes
olver.java:275)
at
org.springframework.beans.factory.support.BeanDefinitionValueR
esolver.resolveValueIfNecessary(BeanDefinitionV
alueResolver.java:104)
at
org.springframework.beans.factory.support.ConstructorResolver.
resolveConstructorArguments(ConstructorResolver
.java:495)
That is, I made no alteration to the config (catalog.xml or info.xml). Just dropped the new version. Looks like it's incompatible to the org.geotools.data.jdbc.JDBCDataStore I got on my geoserver. Which geotools version do I need?
By the way, I am using gs 1.7.2! (GeoServer 1.7.2 (January 19, 2008))
Cheers,
Ugo
-----Alkuperäinen viesti-----
Lähettäjä: Ugo Taddei [mailto:ugo.taddei@anonymised.com]
Lähetetty: 26. helmikuuta 2009 12:38
Vastaanottaja: geoserver users
Aihe: [Geoserver-users] Slow or no start for large table
Hello,
I have an oracle DB-based data store serving half a dozen layers/feature types. One of the tables have >6000000
objects. When I
config this feature type using the GUI, I can get as far
as the Demo
and I'm able to
see the features. (I have defined the bbox manually as
the generate
button took ages.)
I then shut gs down, and try to restart it. It loads the
other types,
but doesn't get past the one with the large table.
I can, however, see the features with udig. (It's there, it's indexed, it's performing well.)
GS is 1.7.2. OS is Windows XP. DB is Oracle on Linux.
Does anyone have an idea about what's happening?
Cheers,
Ugo
--
Ugo Taddei
Fraunhofer Institut Intelligente Analyse- und Informationssysteme (FhG IAIS) http://www.iais.fraunhofer.de Department Knowledge Discovery - IAIS.KD - Working Group Spatial Decision Support http://www.iais.fraunhofer.de/kd\.html
phone (+49)2241-14-2184 fax (+49)2241-14-2072
Schloss Birlinghoven, D-53754 Sankt Augustin, Germany
--------------------------------------------------------------
----------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open
source: Open Sourcing the Enterprise -Strategies to boost
innovation
and cut costs with open source participation -Receive a
$600 discount
off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Ugo Taddei
Fraunhofer Institut Intelligente Analyse- und Informationssysteme (FhG IAIS) http://www.iais.fraunhofer.de Department Knowledge Discovery - IAIS.KD - Working Group Spatial Decision Support http://www.iais.fraunhofer.de/kd\.html
phone (+49)2241-14-2184 fax (+49)2241-14-2072
Schloss Birlinghoven, D-53754 Sankt Augustin, Germany
--
Ugo Taddei
Fraunhofer Institut Intelligente Analyse- und Informationssysteme (FhG IAIS)
http://www.iais.fraunhofer.de
Department Knowledge Discovery - IAIS.KD -
Working Group Spatial Decision Support
http://www.iais.fraunhofer.de/kd.html
phone (+49)2241-14-2184 fax (+49)2241-14-2072
Schloss Birlinghoven, D-53754 Sankt Augustin, Germany
Ugo Taddei wrote:
Hello,
I have an oracle DB-based data store serving half a dozen layers/feature types. One of the tables have >6000000 objects. When I config this feature type using the GUI, I can get as far as the Demo and I'm able to see the features. (I have defined the bbox manually as the generate button took ages.)
I then shut gs down, and try to restart it. It loads the other types, but doesn't get past the one with the large table.
I can, however, see the features with udig. (It's there, it's indexed, it's performing well.)
GS is 1.7.2. OS is Windows XP. DB is Oracle on Linux.
Does anyone have an idea about what's happening?
Yes, GeoServer is computing the native bbox on startup, doing the long
and expensive query that you avoided by putting in the bbox manually
in the UI.
The issue has been solved and 1.7.3 should not suffer from it anymore.
Please try out a GeoServer nightly build here:
http://gridlock.openplans.org/geoserver/1.7.x/
If possible use the oracle-ng datastore, that also has native support
for maxFeatures for the first time, which means your GetFeature
requests won't be stuck forever computing the bounding box (if you
enable the output of the feature collection bounding box in the
wfs configuratino, and set a maxFeature limit that avoids massive
data extractions).
Let us know how this works for you
Cheers
Andrea
Ugo Taddei wrote:
Hello,
just to say thanks again. I went for your suggestion and all went well.
Very nice. Please ignore my previous mail, did not see the rest
of this thread when writing it.
Cheers
Andrea