ACSLS - acsdb_start.log is getting database transaction log messages (Doc ID 1918658.1)

Last updated on AUGUST 20, 2014

Applies to:

Sun StorageTek Auto Cartridge Sys Lib SW (ACSLS) High Availability - Version 8.3 to 8.3 [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 version of ACSLS is ACSLS 8.3.0 running on Linux 2.6.39-200.24.1.el6uek.x86_64.

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:
------
root@ACSLSVM01 log]# tail -n 100 acsdb_start.log
           :cteList <>
           :rtable (
              {RTE
              :alias <>
              :eref
                 {ALIAS
                 :aliasname event_identifier_table
                 :colnames ("event_sequence" "event_timestamp" "client_id" "even
t_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:
----
[root@tape-x4200b data]# 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

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