[Geoserver-users] Tile Caching Quota Store Problem

Langford_Robert1 · May 22, 2013, 10:46am

Hi all,

A couple of weeks ago I was looking into Tile Caching on our Geoserver 2.3.0 on Win 2008 Server, but hit a bit of a brick wall.

I’ve gone back to it today and when I’ve gone into the admin page I’m getting the below error message:

Loading quota store failed, the disk quota subsystem is disabled, please re-configure: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (General error: java.lang.RuntimeException: double allocation in file C:\Geoserver_data_dir\gwc\diskquota_page_store_h2\diskquota.index.db page 78 blocks 4992-5055 [50000-119])

I haven’t a clue what’s happened or why, could any please shed any light on this matter?

Kind regards,

Rob

<br>DISCLAIMER: The information contained in this communication/message from Robert.Langford@anonymised.com..5490... sent on Wed May 22 11:46:19 2013 is confidential and may be legally privileged. It is intended solely for the addressee(s) geoserver-users@anonymised.comists.sourceforge.net<br><br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act.<br>Please immediately contact the sender, Robert.Langford@anonymised.com if you have received this message in error.<br><br>For the full disclaimer please access http://www.salford.gov.uk/e-mail.  Thank you.<br>

Andrea_Aime4 · May 22, 2013, 12:17pm

On Wed, May 22, 2013 at 12:46 PM, Langford, Robert <
Robert.Langford@anonymised.com> wrote:

Hi all,****

** **

A couple of weeks ago I was looking into Tile Caching on our Geoserver
2.3.0 on Win 2008 Server, but hit a bit of a brick wall.****

** **

I’ve gone back to it today and when I’ve gone into the admin page I’m
getting the below error message:****

** **

Loading quota store failed, the disk quota subsystem is disabled, please
re-configure: Could not open JDBC Connection for transaction; nested
exception is org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (General error: java.lang.RuntimeException:
double allocation in file
C:\Geoserver_data_dir\gwc\diskquota_page_store_h2\diskquota.index.db page
78 blocks 4992-5055 [50000-119])****

** **

I haven’t a clue what’s happened or why, could any please shed any light
on this matter?

Seems to be an issue with H2:
https://code.google.com/p/h2database/issues/detail?id=88

GeoServer is using an old version of H2 because of difficulties in
upgrading it (we'd have to upgrade all of its
users at the same time, which would require testing a few subsystems).
I guess we can try to raise the priority of the upgrade, but without
funding addressed to it it's still
going to fall in developers spare time among a lot of other things.

Cheers
Andrea

--

GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

Langford_Robert1 · May 23, 2013, 7:35am

Andrea,

Thanks for the info.

So I’ve just removed the “diskquota.index.db” file and restarted Geoserver, seems to be ok now. Is this all I can/should do?

Regards,

Rob

From: andrea.aime@anonymised.com [mailto:andrea.aime@anonymised.com] On Behalf Of Andrea Aime
Sent: 22 May 2013 13:18
To: Langford, Robert
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Tile Caching Quota Store Problem

On Wed, May 22, 2013 at 12:46 PM, Langford, Robert <Robert.Langford@anonymised.com> wrote:

Hi all,

A couple of weeks ago I was looking into Tile Caching on our Geoserver 2.3.0 on Win 2008 Server, but hit a bit of a brick wall.

I’ve gone back to it today and when I’ve gone into the admin page I’m getting the below error message:

Loading quota store failed, the disk quota subsystem is disabled, please re-configure: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (General error: java.lang.RuntimeException: double allocation in file C:\Geoserver_data_dir\gwc\diskquota_page_store_h2\diskquota.index.db page 78 blocks 4992-5055 [50000-119])

I haven’t a clue what’s happened or why, could any please shed any light on this matter?

Seems to be an issue with H2:

https://code.google.com/p/h2database/issues/detail?id=88

GeoServer is using an old version of H2 because of difficulties in upgrading it (we’d have to upgrade all of its

users at the same time, which would require testing a few subsystems).

I guess we can try to raise the priority of the upgrade, but without funding addressed to it it’s still

going to fall in developers spare time among a lot of other things.

Cheers

Andrea

–

==

GeoServer training in Milan, 6th & 7th June 2013! Visit http://geoserver.geo-solutions.it for more information.

Ing. Andrea Aime

@geowolf

Technical Lead

GeoSolutions S.A.S.

Via Poggio alle Viti 1187

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

http://www.geo-solutions.it

http://twitter.com/geosolutions_it

<br>DISCLAIMER: The information contained in this communication/message from Robert.Langford@anonymised.com..5490... sent on Thu May 23 08:35:13 2013 is confidential and may be legally privileged. It is intended solely for the addressee(s) andrea.aime@anonymised.com07...;geoserver-users@lists.sourceforge.net<br><br>Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful.<br>As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act.<br>Please immediately contact the sender, Robert.Langford@anonymised.com if you have received this message in error.<br><br>For the full disclaimer please access http://www.salford.gov.uk/e-mail.  Thank you.<br>

Andrea_Aime4 · May 23, 2013, 8:10am

On Thu, May 23, 2013 at 9:35 AM, Langford, Robert <
Robert.Langford@anonymised.com> wrote:

Andrea,****

** **

Thanks for the info.****

** **

So I’ve just removed the “diskquota.index.db” file and restarted
Geoserver, seems to be ok now. Is this all I can/should do?

Yes, I believe so