Comment 26 for bug 1931737

Revision history for this message
Jason Stephenson (jstephenson) wrote (last edit ):

I am rescinding my signoff and changing the pullrequest tag to needwork. The database server filled up while running pingest while using the --delay-symspell option:

DBD::Pg::db do failed: ERROR: could not write to file "base/pgsql_tmp/pgsql_tmp232233.1084": No space left on device
CONTEXT: SQL function "symspell_dictionary_full_reify" statement 1 at /openils/bin/pingest.pl line 269.

The above happened on a database server with 1.1TB of free space in a database that is normally 400GB in size.

I am reconfiguring the server over the weekend and will delete several unnecessary databases to free up some space. However, this would have crashed on our production database server as it has a 1.4TB SSD for the same database.