Project

General

Profile

Actions
Copy link

Feature #100

closed

HouseKeeping script

Added by Chooi-Mey over 13 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Low
Assignee:
chin-yeh
Start date:
04/18/2011
Due date:
05/05/2011
% Done:

100%

Estimated time:
4:00 h
Resolution:
Fixed

Description

Housekeeping on event_log table:
1) Purge/delete records with age older than 2 month, from database.

Housekeeping on logging:
1) Remove/delete logging files with age older than 2 months, from file system.
2) List of files to be cleaned:
- QConnector Server: [Application Log]<../server/default/log/qconnector/>debug/error/info.log.xxxxx
- QConnector Server: [Daemon Log] </var/ecwyconnector>qconnector-batch-debug/error/info.log.xxxxx
- QConnector Server: [Event Report] </usr/ecosway/daemon/qconnector/reports/>xxx.csv
- US Mall Server: [Application Log] <../server/default/log/qconnector/>debug/error/info.log.xxxxx

Setting: Housekeep log file with age older than Y days. Y - 30 days.

Actions
Copy link
 #1

Updated by Chooi-Mey over 13 years ago

  • Assignee set to chin-yeh

Chooi-Mey wrote:

Housekeeping on event_log table:
1) Purge/delete records with age older than 2 month, from database.

Housekeeping on logging:
1) Remove/delete logging files with age older than 2 months, from file system.
2) List of files to be cleaned:
- QConnector Server: <..\server\default\log\qconnector\>debug/error/info.log.xxxxx
- QConnector Server: </var/ecwyconnector>qconnector-batch-debug/error/info.log.xxxxx
- US Mall Server: Incomplete list <TBD>
...to be updated.

Note: Low priority.

Actions
Copy link
 #2

Updated by chin-yeh over 13 years ago

  • Due date set to 05/05/2011
  • Status changed from New to In Progress
  • Estimated time set to 4:00 h
Actions
Copy link
 #3

Updated by chin-yeh over 13 years ago

  • Status changed from In Progress to Feedback
  • % Done changed from 0 to 100
  • Resolution set to Fixed
Done. In cwydb1(192.168.2.68) (execute as root user):
  • remove daemon log: 
    /usr/ecosway/housekeeping/scripts/delete_old_daemon_log_files.sh
  • remove old report:
    /usr/ecosway/housekeeping/scripts/delete_old_report_files.sh
  • remove old application log:
    /usr/ecosway/housekeeping/scripts/delete_old_webapp_log_files.sh
In cwyrnd3-server(192.168.2.13) (execute as root or jboss user):
  • remove old application log: (both jboss-4.2.2 & jboss-5.1)
    /usr/ecosway/housekeeping/scripts/delete_old_webapp_log_files.sh
Actions
Copy link
 #4

Updated by Soh Keong over 11 years ago

  • Status changed from Feedback to Closed
Actions
Copy link

Also available in: Atom PDF