My Oracle Support Banner

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***



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 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

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


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

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


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.


To view full details, 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 a vibrant support community of peers and Oracle experts.