defunctになったsymbultbufを殺す
defunctになったsymbultbufを殺す
０．改訂履歴
１．はじめに
このドキュメントでは，Sybaseで，defaunctになったsymbultbufを消去する方法を手順を説明する．
２．defaunctを探し出す
- sybaseユーザでプロセス一覧を表示させてみる．
bash$ ps -ef|grep sybase
sybase 16559 1 0 Mar28 ? 00:00:00 sh /opt/sybase/install/RUN_SYBAS
sybase 16563 16559 10 Mar28 ? 12:30:43 /opt/sybase/bin/dataserver -d/op
sybase 333 1 0 Aug15 ? 00:00:00 sh /opt/sybase/install/RUN_SYBAS
sybase 334 333 0 Aug15 ? 00:00:15 /opt/sybase/bin/backupserver -SC
sybase 19963 334 0 13:15 ? 00:00:00 [sybmultbuf <defunct>]
sybase 20004 334 0 14:15 ? 00:00:00 [sybmultbuf <defunct>]
sybase 20066 334 0 15:15 ? 00:00:00 [sybmultbuf <defunct>]
sybase 20127 334 0 16:15 ? 00:00:00 [sybmultbuf <defunct>]
sybase 20170 334 0 17:15 ? 00:00:00 [sybmultbuf <defunct>]
sybase 20211 334 0 18:15 ? 00:00:00 [sybmultbuf <defunct>]
sybase 20254 334 0 19:15 ? 00:00:00 [sybmultbuf <defunct>]
root 20289 20288 0 19:36 pts/1 00:00:00 login -- sybase
sybase 20290 20289 0 19:36 pts/1 00:00:00 -bash
sybase 20315 20290 0 19:49 pts/1 00:00:00 ps -ef
sybase 20316 20290 0 19:49 pts/1 00:00:00 -bash
bash$
bash$
|
- sybmultbufという人が，defunctになっている．
- プロセスIDを確認すると，SybaseのBackupServerが原因だと確認できる．
３．BackupServerを停止してみる
- BackupServerのゴミなので，BackupServerを停止すればよい．
- プロセスを確認する．
bash$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
sybase 16563 10.2 62.7 787936 650380 ? S Mar28 22351:21 dataserver
sybase 334 0.0 0.6 7908 6464 ? S Aug15 0:15 backupserver
bash$
|
- isqlで接続し，BackupServerを停止する．
bash$ isql -Usa -Ppassword -SSYBASE -zus_english -Jsjis
1> shutdown SYB_BACKUP
2> go
Backup Server: 3.48.1.1: The Backup Server will go down immediately.
Terminating sessions.
1> quit
bash$
|
bash$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
sybase 16563 10.2 62.7 787936 650380 ? S Mar28 22351:27 dataserver
bash$
|
bash$ ps -ef|grep sybase
sybase 16559 1 0 Mar28 ? 00:00:00 sh /opt/sybase/install/RUN_SYBAS
sybase 16563 16559 10 Mar28 ? 12:31:38 /opt/sybase/bin/dataserver -d/op
root 20289 20288 0 19:36 pts/1 00:00:00 login -- sybase
sybase 20290 20289 0 19:36 pts/1 00:00:00 -bash
sybase 20376 20290 0 19:57 pts/1 00:00:00 ps -ef
sybase 20377 20290 0 19:57 pts/1 00:00:00 -bash
bash$
|
４．BackupServerを再度起動する
bash$ cd $SYBASE/install
bash$ ls -la
total 3668
drwxrwxr-x 3 sybase ASE 4096 Aug 8 15:58 .
drwx------ 16 sybase ASE 4096 Jul 29 11:52 ..
-rwxr-xr-x 1 sybase ASE 460 Oct 29 2001 RUN_SYBASE
-rwxr-xr-x 1 sybase ASE 614 Aug 8 15:58 RUN_SYBASE_BACK
drwxrwxr-x 2 sybase ASE 4096 Sep 17 2001 SPR
-r-xr-xr-x 1 sybase ASE 1435 Jan 7 2000 rc.sybase
-r-xr-xr-x 1 sybase ASE 4173 Jan 5 2000 setperm_all
-r--r--r-- 1 sybase ASE 386 Jan 7 2000 setperm_monserv
-r-xr-xr-x 1 sybase ASE 667 Mar 16 2000 showserver
-r-xr-xr-x 1 sybase ASE 16720 Mar 17 2000 startserver
-r-xr-xr-x 1 sybase ASE 2304 Jan 23 2000 sybdevices.sh
-r-xr-xr-x 1 sybase ASE 1009190 Mar 17 2000 sybinit
-r-xr-xr-x 1 sybase ASE 2661666 Mar 17 2000 sybinit.sym
-r-xr-xr-x 1 sybase ASE 5615 Jan 23 2000 sybinstall.sh
bash$
|
bash$ ./startserver -f ./RUN_SYBASE_BACK
bash$ Backup Server/11.0.3.3 ESD#6/P-FREE/Linux Intel/Linux 2.2.14 i686/1/OPT/Fri Mar 17 15:52:00 CET 2000
(c) Copyright 1987, 2000.
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.
This software contains confidential and trade secret information of Sybase,
Inc. Use, duplication or disclosure of the software and documentation by
the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and Sybase, Inc. or other written
agreement specifying the Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA.
Logging Backup Server messages in file '/opt/sybase/database/log/backup.log'
bash$
|
bash$ showserver
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
sybase 16563 10.2 62.7 787936 650380 ? S Mar28 22351:36 dataserver
sybase 20366 0.2 0.4 7708 4872 pts/1 S 19:57 0:00 backupserver
bash$
|
