- Article Type: General
- Product: Aleph
- Product Version: 17.01
Using the basic search, results are found but they are not displayed. The short-a-body-abc01 file is not rendered as part of the short results page. We experienced some bizarre search results earlier this morning (separate searches for Erwin Rommel and New Zealand returned the same results set full of results about Islam, including several results that were completely blank) so I restarted Aleph's WWW server (using the UTIL command line tool). After that, the short-a-body problem started. I also restarted the z39 server and z39 gate but nothing changed.
I found this message in the $LOGDIR/www_server log:
ORA-01653: unable to extend table VIR01.Z110 by 1024 in tablespace TS0
io_z110_write: REATTEMPTING TO WRITE Z110...
util o/14/1 showed only 8 meg. free in the TS0 tablespace.
I found that thousands of Z110, Z05, Z63:
SQL> select count(*) from z110;
had been accumulating since clear_vir01 has not been running.
I found that the vir01 batch queue has been stopped and hundreds of clear_vir01 jobs were in the util c/7 batch queue, waiting to be executed:
VIR01-ALEPH>>grep -c clear_vir01 que_batch
This is like KB 5167.
I did the following:
1. dlib vir01
rm que_batch (this emptied out the huge queue)
2. ran clear_vir01 (this freed up 580 meg in the TS0 tablespace)
3. added vir01 to the aleph_startup (to make it so the vir01 batch queue will start automatically when aleph is restarted):
setenv QUE_STARTUP_LIBS "usm01 usm50 vir01"
- Article last edited: 10/8/2013