ACSLS - Database Failure - ACSLS Will Not Start Up (Doc ID 1015711.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

On an ACSLS 7.x system, the following symptoms may exist:

- "EXEC SQL open lsm_cursor" error in the acsss_event.log

- various STATUS_DATABASE_ERROR and/or STATUS_PROCESS_FAILURE messages in the acsss_event.log

- There is no sm_versions file in $INFORMIXDIR/etc directory as indicated in the lib6_bar_act.log

- Backups have been failing since after the upgrade.


Error messages in the acsss_event.log:
2005-09-01 21:50:49 ACSSV[0]:
664 N cl_lsm_read.c 1 256
cl_lsm_read:
EXEC SQL open lsm_cursor
[DI_S_TIMEOUT]:

2005-09-01 21:50:49 ACSSV[0]:
1 E cl_lsm_qlist.c 1 138
cl_lsm_qlist: cl_lsm_read:ALL() unexpected status = STATUS_DATABASE_ERROR

2005-09-01 21:50:49 ACSSV[0]:
1 E sv_scratch.c 1 120
sv_scratch: cl_lsm_list() unexpected status = STATUS_DATABASE_ERROR

2005-09-01 21:50:49 ACSSA[0]:
1423 N sa_demux.c 1 278
Data base failure.

2005-09-01 21:51:51 ACSSA[0]:
1423 N sa_demux.c 1 278
Data base failure.

2005-09-01 21:51:51 DISMOUNT[0]:
663 N cl_lsm_read.c 1 230
cl_lsm_read:
EXEC SQL select from lsmtable where LSM = 0, 0
[DI_S_TIMEOUT]:

2005-09-01 21:51:51 DISMOUNT[0]:
1 E mt_resv_dm.c 1 372
mt_resv_dm: cl_lsm_update() unexpected status = STATUS_DATABASE_ERROR

2005-09-01 21:51:51 MOUNT[0]:
1 E mt_action_ms.c 1 465
ms_select_fail: acssv response() unexpected status = STATUS_PROCESS_FAILURE



Messages in the lib6_bar_act.log:
2005-08-28 00:00:06 14260 14204 onsmsync: process exit 142 (0x8e)
2005-08-28 00:00:08 14286 14262 onsmsync
2005-08-28 00:00:08 14286 14262 Open or close failed on file '/export/home/informix/IDS7.3/etc/ixbar.2', errno = 2
2005-08-28 00:00:08 14286 14262 The problem just reported is not fatal; processing will continue.
2005-08-28 00:00:08 14286 14262 ERROR: Unable to open file /export/home/informix/IDS7.3/etc/sm_versions No such file or directory

Changes

ACSLS upgrade

Cause