ACSLS - acsdb_start.log is Getting Database Transaction Log Messages
(Doc ID 1918658.1)
Last updated on JULY 11, 2022
Applies to:
Sun StorageTek Auto Cartridge Sys Lib SW (ACSLS) High Availability - Version 8.0 Sun Cluster to 8.5 [Release 8.0]Information in this document applies to any platform.
Symptoms
The acsdb_start.log keeps on growing without log rotation. The log file size is +30GB after two weeks and have to be cleared manually to avoid haveing a full filesystem.
The Postgres service start up seems to associate the acsdb_start.log to Postgres debug outputs. By design, only /etc/init.d/acsdb script should be the only script that outputs to the acsdb_start.log.
Example of messages from Postgres that are sent to acsdb_start.log:
------
# tail -n 100 acsdb_start.log
:cteList <>
:rtable (
{RTE
:alias <>
:eref
{ALIAS
:aliasname event_identifier_table
:colnames ("event_sequence" "event_timestamp" "client_id" "event_type
" "event_status")
}
:rtekind 0
:relid 17810
:inh true
:inFromCl true
:requiredPerms 2
:checkAsUser 0
:selectedCols (b 10)
:modifiedCols (b)
}
)
:jointree
..
..
This is an example of the messages that we expect to be in acsdb_start.log:
----
# view ~acsss/log/acsdb_start.log
2014-06-25 18:55:22 GMT 2015 0 DEBUG: TERM=linux
2014-06-25 18:55:22 GMT 2015 0 DEBUG: SHELL=/bin/bash
2014-06-25 18:55:22 GMT 2015 0 DEBUG: USER=acsdb
2014-06-25 18:55:22 GMT 2015 0 DEBUG: SSLM_HOME=/export/home/SSLM
2014-06-25 18:55:22 GMT 2015 0 DEBUG: PATH=/usr/bin:/usr/bin:/export/home/ACSSS:/export/home/ACSSS/bin:/export/home/ACSSS/install:/export/home/ACSSS/utils:/export/home/ACSSS/diag/bin:/export/home/ACSSS/config:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin
2014-06-25 18:55:22 GMT 2015 0 DEBUG: RUNLEVEL=5
2014-06-25 18:55:22 GMT 2015 0 DEBUG: runlevel=5
2014-06-25 18:55:22 GMT 2015 0 DEBUG: _=/usr/bin/postgres
2014-06-25 18:55:22 GMT 2015 0 DEBUG: PWD=/
2014-06-25 18:55:22 GMT 2015 0 DEBUG: LANGSH_SOURCED=1
2014-06-25 18:55:22 GMT 2015 0 DEBUG: PGLOCALEDIR=/usr/share/locale
2014-06-25 18:55:22 GMT 2015 0 DEBUG: LANG=en_US.UTF-8
2014-06-25 18:55:22 GMT 2015 0 DEBUG: PREVLEVEL=N
2014-06-25 18:55:22 GMT 2015 0 DEBUG: previous=N
2014-06-25 18:55:22 GMT 2015 0 DEBUG: PGSYSCONFDIR=/etc/sysconfig/pgsql
2014-06-25 18:55:22 GMT 2015 0 DEBUG: ACSDBDIR=/export/home/acsdb/ACSDB1.0
2014-06-25 18:55:22 GMT 2015 0 DEBUG: CONSOLETYPE=vt
2014-06-25 18:55:22 GMT 2015 0 DEBUG: SHLVL=4
2014-06-25 18:55:22 GMT 2015 0 DEBUG: HOME=/export/home/acsdb/ACSDB1.0
2014-06-25 18:55:22 GMT 2015 0 DEBUG: UPSTART_INSTANCE=
2014-06-25 18:55:22 GMT 2015 0 DEBUG: UPSTART_EVENTS=runlevel
2014-06-25 18:55:22 GMT 2015 0 DEBUG: LOGNAME=acsdb
2014-06-25 18:55:22 GMT 2015 0 DEBUG: installDir=/export/home
2014-06-25 18:55:22 GMT 2015 0 DEBUG: PGDATA=/export/home/acsdb/ACSDB1.0/data
2014-06-25 18:55:22 GMT 2015 0 DEBUG: pgLibPath=/usr/lib
2014-06-25 18:55:22 GMT 2015 0 DEBUG: UPSTART_JOB=rc
2014-06-25 18:55:22 GMT 2015 0 DEBUG: ACS_HOME=/export/home/ACSSS
2014-06-25 18:55:22 GMT 2015 0 DEBUG: LC_COLLATE=en_US.UTF-8
2014-06-25 18:55:22 GMT 2015 0 DEBUG: LC_CTYPE=en_US.UTF-8
2014-06-25 18:55:22 GMT 2015 0 DEBUG: LC_MESSAGES=C
2014-06-25 18:55:22 GMT 2015 0 DEBUG: LC_MONETARY=C
2014-06-25 18:55:22 GMT 2015 0 DEBUG: LC_NUMERIC=C
2014-06-25 18:55:22 GMT 2015 0 DEBUG: LC_TIME=C
2014-06-25 18:55:22 GMT 2015 0 DEBUG: -----------------------------------------
waiting for server to start......2014-06-25 12:55:25 MDT 2015 0 DEBUG: invoking IpcMemoryCreate(size=12124160)
2014-06-25 12:55:25 MDT 2015 0 DEBUG: max_safe_fds = 984, usable_fds = 1000, already_open = 6
done
server started
Changes
Changed some settings in the /export/home/acsdb/ACSDB0.1/data/postgresql.conf file
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |