Hi,
Got error:
Value too long for column GRIDSET_ID VARCHAR(32): 'WGS 84 / UTM Zone 34N
(EPSG:32634)' (34);
in GeoServer 2.18.0 used with integrated GWC. Full error:
Loading quota store failed, the disk quota subsystem is disabled, please
re-configure: Failed to create or locate tileset
TileSet[messir:countries_and_water#WGS 84 / UTM Zone 34N
(EPSG:32634)#image/png#408a9289e97a734867475b5c5178621c355e6e28] after 100
attempts; nested exception is
org.geowebcache.diskquota.jdbc.ParametricDataAccessException: Failed to execute
statement INSERT INTO TILESET select :key, :layerName, :gridSetId, :blobFormat,
:parametersId, 0 WHERE NOT EXISTS(SELECT 1 FROM TILESET WHERE KEY = :key) with
params: {blobFormat=image/png, gridSetId=WGS 84 / UTM Zone 34N (EPSG:32634),
layerName=messir:countries_and_water,
parametersId=408a9289e97a734867475b5c5178621c355e6e28,
key=messir:countries_and_water#WGS 84 / UTM Zone 34N
(EPSG:32634)#image/png#408a9289e97a734867475b5c5178621c355e6e28}; nested
exception is org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO
TILESET select ?, ?, ?, ?, ?, 0 WHERE NOT EXISTS(SELECT 1 FROM TILESET WHERE
KEY = ?)]; SQL state [90005]; error code [90005]; Value too long for column
GRIDSET_ID VARCHAR(32): 'WGS 84 / UTM Zone 34N (EPSG:32634)' (34); SQL
statement: INSERT INTO TILESET select ?, ?, ?, ?, ?, 0 WHERE NOT EXISTS(SELECT
1 FROM TILESET WHERE KEY = ?) [90005-119]; nested exception is
org.h2.jdbc.JdbcSQLException: Value too long for column GRIDSET_ID VARCHAR(32):
'WGS 84 / UTM Zone 34N (EPSG:32634)' (34); SQL statement: INSERT INTO TILESET
select ?, ?, ?, ?, ?, 0 WHERE NOT EXISTS(SELECT 1 FROM TILESET WHERE KEY = ?)
[90005-119]
Actually, GeoWebCache has value GIDSET_ID VARCHAR(32) hardocoded (see below),
while obviously GeoServer has values with length > 32 chars.
Any idea on how to fix this (without rebulding GeoServer)?
Many thanks,
Victor
\geowebcache-master\geowebcache\diskquota\jdbc\src\main\java\org\geowebcache\diskquota\jdbc\SQLDialect.java
// size guesses: 128 characters should be more than enough for layer name,
the gridset id
// is normally an epsg code so 32 is way more than enough, the blob format
// is normally a mime plus some extras, again 64 should fit, a param id is
// a SHA-1 sum that uses 41 chars, the id is the sum of all the above plus
// connecting chars, 320 is again more than enough
// bytes is going to be less than a zettabyte(one million petabytes, 10^21)
for the
// foreseeable future
....
protected static final int GRIDSET_ID_SIZE = 32;
.....
protected final Map<String, List<String>> TABLE_CREATION_MAP =
new LinkedHashMap<String, List<String>>() {
{
put(
"TILESET",
Arrays.asList( //
"CREATE TABLE ${schema}TILESET (\n"
+ //
....
" GRIDSET_ID VARCHAR("
+ GRIDSET_ID_SIZE
+ "),\n"
.....
________________________________
This message is subject to and does not create or vary any contractual
relationship between Campbell Scientific Limited, its subsidiaries or
affiliates ("CSL") and you. Internet communications are not secure and
therefore CSL does not accept legal responsibility for the contents of this
message. The message is intended for the addressee only and its contents and
any attached files are strictly confidential. If you have received it in error,
please telephone +44 (0)1509 601141 or email [email protected].
Thank you.
Campbell Scientific Ltd.
Company Registration Number: 1933935 (England and Wales) Registered Address:
Campbell Park, 80 Hathern Road, Shepshed, Loughborough, Leicestershire LE12
9GX, UK
Tel: +44 (0) 1509 601141
Fax: +44 (0) 1509 601091
Web: www.campbellsci.co.uk
________________________________
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
