Can't log on to OPAC; www_server log: "io_z63_write ... object no longer exists"

Last updated
Save as PDF
Share
1. Share
2. Share
3. Tweet
4. Share

Article Type: General
Product: Aleph
Product Version: 20

Description:
After recovering from a disk problem with our database, we are unable to log-in to the OPAC and get the following messages in the www_server log:

Oracle error: io_z63_write
ORA-08103: object no longer exists

WRITE ERROR Q5UUL1AQ6IKQ3JFXNMEEK362H5N7C1SC8BMDCERFXPTUNAGCYM

and

Oracle error: update_cursor z63
ORA-01410: invalid ROWID

Resolution:
Since the z63 is a temporary table, I decided to drop/recreate it. Thinking that there might be similar problems with other vir01 tables, I ran clear_vir01 to drop/recreate *all* of the vir01 tables. After which, the above messages no longer appeared and we could log in OK.

Article last edited: 10/8/2013