Hi, Thanks,
I've never had any issues with it, but surely I could set up a PostgreSQL connection instead. Regards Roar > 21. apr. 2023 kl. 15:19 skrev Andrea Aime <andrea.a...@geosolutionsgroup.com>: > > Hi Roar, > H2 storage for disk quota is good for quick tests, but I'd avoid it like a > plague for production. > Better to use a PostgreSQL database instead. As far as I know, it has no side > effects on stored tiles. > > Cheers > Andrea > > On Thu, Apr 13, 2023 at 1:14 PM Roar Brænden <roar.brenden...@gmail.com > <mailto:roar.brenden...@gmail.com>> wrote: > Hi, > After an upgrade of GeoServer from 2.19 to 2.22, an error message appear at > the front page and at the Disk Quota page. We're using the "In process > database (H2)". The message is as follows: > > Loading quota store failed, the disk quota subsystem is disabled, please > re-configure: Failed to execute statement DELETE FROM TILESET WHERE > LAYER_NAME = :layerName with params: {layerName=no.niva:Marin}; nested > exception is org.springframework.jdbc.UncategorizedSQLException: > PreparedStatementCallback; uncategorized SQLException for SQL [DELETE FROM > TILESET WHERE LAYER_NAME = ?]; SQL state [HY000]; error code [50000]; General > error: java.lang.ArrayIndexOutOfBoundsException: Index 2590 out of bounds for > length 2590; SQL statement: DELETE FROM TILESET WHERE LAYER_NAME = ? > [50000-119]; nested exception is org.h2.jdbc.JdbcSQLException: General error: > java.lang.ArrayIndexOutOfBoundsException: Index 2590 out of bounds for length > 2590; SQL statement: DELETE FROM TILESET WHERE LAYER_NAME = ? [50000-119] > > Have anyone else seen this message? > > I think one way of getting past this is to delete the folder disk > quota_page_store_h2, and let GeoServer build a new one, but would that have > any ramification og the stored tiles? > > Any advice would be much appreciated. > > Best regards, > Roar Brænden > _______________________________________________ > 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#/ > <http://www.ianturton.com/talks/foss4g.html#/> > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > <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 > > <https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer> > > > Geoserver-users@lists.sourceforge.net > <mailto:Geoserver-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/geoserver-users > <https://lists.sourceforge.net/lists/listinfo/geoserver-users> > > > -- > Regards, > Andrea Aime > == > GeoServer Professional Services from the experts! > Visit http://bit.ly/gs-services-us <http://bit.ly/gs-services-us> for more > information. > == > > Ing. Andrea Aime > @geowolf > Technical Lead > > GeoSolutions Group > phone: +39 0584 962313 > fax: +39 0584 1660272 > mob: +39 339 8844549 > > https://www.geosolutionsgroup.com/ <https://www.geosolutionsgroup.com/> > http://twitter.com/geosolutions_it <http://twitter.com/geosolutions_it> > ------------------------------------------------------- > > Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE > 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa > che ogni circostanza inerente alla presente email (il suo contenuto, gli > eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i > destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per > errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei > comunque grato se potesse darmene notizia. > > This email is intended only for the person or entity to which it is addressed > and may contain information that is privileged, confidential or otherwise > protected from disclosure. We remind that - as provided by European > Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or > the information herein by anyone other than the intended recipient is > prohibited. If you have received this email by mistake, please notify us > immediately by telephone or e-mail
_______________________________________________ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
