ACSLS - Database Will Not Start Because Informix Logical Logs are Full (Doc ID 1015768.1)

Last updated on APRIL 28, 2014

Applies to:

Sun StorageTek Auto Cartridge Sys Lib SW (ACSLS) - Version 6.x to 7.1.1 [Release 6.x to 7.0]
All Platforms
***Checked for relevance on 15-Mar-2012***
***Checked for relevance on 28-Apr-2014***


Symptoms

 

This solution is designed for ACSLS 7.1 and earlier versions of ACSLS. This solution does not apply to ACSLS 7.2 and later releases of ACSLS that use PostgreSQL to manage its database.


 
- Database will not start
- ACSLS is not starting
- ACSLS is hanging
- ACSLS nightly backups are failing
- acsss_event.log shows database failure errors
- lib6_online.log, lib6_bar_act.log and/or timed_bkup.sh.log show backup or
database error messages

The Informix command "onstat -l" shows that the logical logs are not being backed up:
(i.e., there is no "B" flag in position 3 of the flags-column)

For example:

$ onstat -l
Informix Dynamic Server Version 7.31.UC7 -- On-Line -- Up 6 days 19:24:17 --
12128 Kbytes
....
address number flags uniqid begin size used %used
a154c6c 1 U------ 1 100a03 500 500 100.00
a154c88 2 U------ 2 100bf7 500 500 100.00
a154ca4 3 U------ 3 100deb 500 500 100.00
a154cc0 4 U------ 4 100fdf 500 500 100.00
a154cdc 5 U------ 5 1011d3 500 500 100.00
a154cf8 6 U---C-L 0 1013c7 500 500 100.00



Examples of database errors in the event log:
2006-05-31 06:43:41 QUERY[13471]:
985 N qu_count.c 1 200
qu_count: EXEC SQL select
[DI_S_TIMEOUT]

< FONT>
2006-05-31 06:43:41 ACSSA[0]:
1423 N sa_demux.c 1 278
Data base failure.



or:


2006-05-31 05:27:36 ACSCR[0]:
2420 E cr_proc_state.c 1 888
cr_proc_state[0.1.670]:
EXEC SQL failed to fetch from cr_cursor
[DI_S_SUCCESS]:

2006-05-31 05:27:36 ACSSA[0]:
1423 N sa_demux.c 1 278
Data base failure.

Changes

Password for the informix or acsss user may have automatically expired

Hardening the server's security features of installing a security application may have inadvertently changed the permissions and ownerships of some ACSLS files and directories.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms