10-25-2011 05:04 PM - edited 03-01-2019 02:29 PM
We have problems with Sybase Database for Collection Manager in a SCE2020. The status is:
[root@btl-sce-cm log]# ~scmscm/setup/alive.sh STATUS OK [root@btl-sce-cm monitor]# ./monitor.sh -a -d Test: 01db_up.sh. Status: FAIL. Message: DB is not running Test: 02cm_up.sh. Status: PASS. Message: CM is running Test: 03free_db.sh. Status: PASS. Message: 99% free space in data db Test: 04free_log.sh. Status: PASS. Message: 99% free space in log db Test: 05cm_persistent_buffers.sh. Status: FAIL. Message: The following directory/ies have more than 500 files in them - JDBCAdapter TAAdapter [root@btl-sce-cm monitor]# ~scmscm/scripts/dbtables.sh /home/scmscm/scripts/common.sh: line 43: /root/cm/bin/cm: is a directory Executing query ... /home/scmscm/scripts/dbtables.sh: line 83: /root/cm/bin/cm: is a directory [root@btl-sce-cm monitor]# df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/mapper/VolGroup00-LogVol00 149559596 138280700 3681636 98% / /dev/sda1 101086 20685 75182 22% /boot none 1036624 0 1036624 0% /dev/shm
We restored the Sybase database, but we have problems to access the database from Collection Manager and we can't obtain reports from SCE 2020. Here is the info: Problem Details: The SCA Reporter cannot generate Reports, the CM diagnostics show the following: [root@btl-sce-cm ~]# ~scmscm/setup/alive.sh STATUS OK [root@btl-sce-cm ~]# ~scmscm/scripts/dbfree.sh Name % Data Free % Log Free ---------------------- ----------- ---------- Database 55 99 [root@btl-sce-cm ~]# ~scmscm/scripts/dbtables.sh /home/scmscm/scripts/common.sh: line 43: /root/cm/bin/cm: No such file or directory Executing query ... /home/scmscm/scripts/dbtables.sh: line 83: /root/cm/bin/cm: No such file or directory [root@btl-sce-cm ~]# ~scmscm/setup/monitor/monitor.sh -d -a Test: 01db_up.sh. Status: FAIL. Message: DB is not running Test: 02cm_up.sh. Status: PASS. Message: CM is running Test: 03free_db.sh. Status: PASS. Message: 55% free space in data db Test: 04free_log.sh. Status: PASS. Message: 99% free space in log db Test: 05cm_persistent_buffers.sh. Status: FAIL. Message: The following directory/ies have more than 500 files in them - JDBCAdapter Message was edited by: EMILIO MENCIA
09-13-2012 01:32 AM
My problem repeat every day after 23:15 o'clock. SCA BB don't show graphics (Global Bandwidth per Service) and other
(user scmscm)
Test: 01db_up.sh. Status: PASS. Message: db is up
Test: 02cm_up.sh. Status: PASS. Message: CM is running
test 03free_db.sh output was invalid, cannot parse status/message
Test: 03free_db.sh. STATUS: Unknown. Message: Unknown state returned
test 04free_log.sh output was invalid, cannot parse status/message
Test: 04free_log.sh. STATUS: Unknown. Message: Unknown state returned
Test: 05cm_persistent_buffers.sh. Status: FAIL. Message: The following directory/ies have more than 500 files in them - JDBCAdapter
(from root)
Test: 01db_up.sh. Status: FAIL. Message: DB is not running
Test: 02cm_up.sh. Status: PASS. Message: CM is running
test 03free_db.sh output was invalid, cannot parse status/message
Test: 03free_db.sh. STATUS: Unknown. Message: Unknown state returned
test 04free_log.sh output was invalid, cannot parse status/message
Test: 04free_log.sh. STATUS: Unknown. Message: Unknown state returned
Test: 05cm_persistent_buffers.sh. Status: FAIL. Message: The following directory/ies have more than 500 files in them - JDBCAdapter
I do this -
(user scmscm)
/home/scmscm/cm/bin/cm restart --- solve my problem but restart cm every day bad idea
after cm restart
Test: 01db_up.sh. Status: PASS. Message: db is up
Test: 02cm_up.sh. Status: PASS. Message: CM is running
test 03free_db.sh output was invalid, cannot parse status/message
Test: 03free_db.sh. STATUS: Unknown. Message: Unknown state returned
test 04free_log.sh output was invalid, cannot parse status/message
Test: 04free_log.sh. STATUS: Unknown. Message: Unknown state returned
Test: 05cm_persistent_buffers.sh. Status: PASS. Message: All Adapter persistent buffers are in Normal state
vi /home/scmscm/cm/logs/cm.log
.................many message like that...
2012-09-13 09:53:41,491 [Thread-9] WARN com.cisco.scmscm.buffer.PersistentBuffer - Persistent Buffer: deleting before read: /home/scmscm/cm/adapters/JDBCAdapter/74.rdr
2012-09-13 09:53:42,544 [Thread-9] WARN com.cisco.scmscm.buffer.PersistentBuffer - Persistent Buffer: deleting before read: /home/scmscm/cm/adapters/JDBCAdapter/75.rdr
I have low experience with CM . What shoud I do?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide