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

Last updated on JULY 11, 2022

Applies to:

Symptoms

 
- 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