Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Same results repeated for all searches; short-a-body file not being displayed

    • Article Type: General
    • Product: Aleph
    • Product Version: 17.01

    Description:
    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.

    Our short-a-body-abc01 file makes calls to the x-server to gather holdings information as well as receiving the standard holdings information. That javascript is currently housed in meta-tags and no javascript error is being reported by either Firefox or IE 7.

    Resolution:
    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;


    COUNT(*)
    ----------
    292420

    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
    405

    This is like KB 5167.

    I did the following:

    1. dlib vir01
    rm que_batch (this emptied out the huge queue)
    touch que_batch

    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