Skip to main content
Tweeted twitter.com/StackGIS/status/867839920471199746
deleted 81 characters in body
Source Link
PolyGeo
  • 65.4k
  • 29
  • 114
  • 345

I have Geoserver 2.8.2 running on a Windows server in Tomcat. I have a drive specifically setup just for GeoWebCache. All has been fine until today, I restarted the machine, and discover that drive is out of disk space. It is 126GB in size, and was using about 6GB. I discovered that the "diskquota.index.db" file is 120GB in size. The diskquota.data.db is only 37MB. Clearly something has gone wrong.

I think I need to somehow reset / delete / recreate this database, but I'm not entirely sure what the proper procedures would be to do so. Any suggestions or pointers to the proper documentation would be appreciated.

Here is the directory listing for that folder:

05/22/2017  12:03 PM    <DIR>          .
05/22/2017  12:03 PM    <DIR>          ..
05/22/2017  12:03 PM        38,584,368 diskquota.data.db
05/22/2017  12:03 PM   123,511,767,088 diskquota.index.db
05/22/2017  12:03 PM           705,672 diskquota.trace.db
           3 File(s) 123,551,057,128 bytes
           2 Dir(s)         565,248 bytes free

I have Geoserver 2.8.2 running on a Windows server in Tomcat. I have a drive specifically setup just for GeoWebCache. All has been fine until today, I restarted the machine, and discover that drive is out of disk space. It is 126GB in size, and was using about 6GB. I discovered that the "diskquota.index.db" file is 120GB in size. The diskquota.data.db is only 37MB. Clearly something has gone wrong.

I think I need to somehow reset / delete / recreate this database, but I'm not entirely sure what the proper procedures would be to do so. Any suggestions or pointers to the proper documentation would be appreciated.

Here is the directory listing for that folder:

05/22/2017  12:03 PM    <DIR>          .
05/22/2017  12:03 PM    <DIR>          ..
05/22/2017  12:03 PM        38,584,368 diskquota.data.db
05/22/2017  12:03 PM   123,511,767,088 diskquota.index.db
05/22/2017  12:03 PM           705,672 diskquota.trace.db
           3 File(s) 123,551,057,128 bytes
           2 Dir(s)         565,248 bytes free

I have Geoserver 2.8.2 running on a Windows server in Tomcat. I have a drive specifically setup just for GeoWebCache. All has been fine until today, I restarted the machine, and discover that drive is out of disk space. It is 126GB in size, and was using about 6GB. I discovered that the "diskquota.index.db" file is 120GB in size. The diskquota.data.db is only 37MB. Clearly something has gone wrong.

I think I need to somehow reset / delete / recreate this database, but I'm not entirely sure what the proper procedures would be to do so.

Here is the directory listing for that folder:

05/22/2017  12:03 PM    <DIR>          .
05/22/2017  12:03 PM    <DIR>          ..
05/22/2017  12:03 PM        38,584,368 diskquota.data.db
05/22/2017  12:03 PM   123,511,767,088 diskquota.index.db
05/22/2017  12:03 PM           705,672 diskquota.trace.db
           3 File(s) 123,551,057,128 bytes
           2 Dir(s)         565,248 bytes free
Source Link
Brian B
  • 825
  • 8
  • 19

Geoserver / Geowebcache diskquota.index.db H2 quota database file is 120GB, how to reorg / shrink or delete/rebuild?

I have Geoserver 2.8.2 running on a Windows server in Tomcat. I have a drive specifically setup just for GeoWebCache. All has been fine until today, I restarted the machine, and discover that drive is out of disk space. It is 126GB in size, and was using about 6GB. I discovered that the "diskquota.index.db" file is 120GB in size. The diskquota.data.db is only 37MB. Clearly something has gone wrong.

I think I need to somehow reset / delete / recreate this database, but I'm not entirely sure what the proper procedures would be to do so. Any suggestions or pointers to the proper documentation would be appreciated.

Here is the directory listing for that folder:

05/22/2017  12:03 PM    <DIR>          .
05/22/2017  12:03 PM    <DIR>          ..
05/22/2017  12:03 PM        38,584,368 diskquota.data.db
05/22/2017  12:03 PM   123,511,767,088 diskquota.index.db
05/22/2017  12:03 PM           705,672 diskquota.trace.db
           3 File(s) 123,551,057,128 bytes
           2 Dir(s)         565,248 bytes free