Out of disk space exceptions in the WFAU Firethorn/TAP services

[stvoutsin]

Description:
Some queries to WFAU TAP services failing. The resulting VOTables has null as the error.
This doesn't occur consistently.

Steps to recreate:
wget "http://tap.roe.ac.uk/osa/sync?REQUEST=doQuery&QUERY=SELECT+TOP+1+*+from+ATLASDR1.Filter&LANG=ADQL"

FT Version: 2.1.36

VM: Eterathiel (trop02)

**OGSADAI Stack Trace: **
2021-01-28 16:08:22,383 DEBUG event.LoggingActivityListener [pool-1-thread-3187,debug:84] uk.org.ogsadai.activity.sql.ActivitySQLUserException: The activity encountered a problem while interacting with a relational database. at uk.ac.roe.wfau.firethorn.ogsadai.activity.server.jdbc.JdbcInsertDataActivity.processIteration(JdbcInsertDataActivity.java:419) at uk.org.ogsadai.activity.MatchedIterativeActivity.process(MatchedIterativeActivity.java:90) at uk.org.ogsadai.activity.event.EventfulActivity.process(EventfulActivity.java:78) at uk.org.ogsadai.activity.concurrency.ActivityProcessingTask.call(ActivityProcessingTask.java:81) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.BatchUpdateException: Could not allocate a new page for database 'FirethornUserdata20201210' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:1069) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at uk.ac.roe.wfau.firethorn.ogsadai.activity.server.jdbc.JdbcInsertDataActivity.processIteration(JdbcInsertDataActivity.java:317) ... 9 more

Notes:
Database running these services is created on ramses18 and files stored at: G:/Dave/..
G:/ has only about 70GB disk space left.

[Zarquan]

When you are working with Rob et al on this it might be good to get our databases moved from G:/Dave to a more generic G:/firethorn/sqlserver. That might help to make it clearer what the directory contains.