PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Katherine Kratter <kathy at columbia dot edu>
Subject: SQL/BackTrack Job Hung
Date: Nov 12 1997 5:17PM

Every night I backup 20 databases using SQL/BackTrack.  SQL/BT is called
from a wrapper program written in perl.  The name of the wrapper is
dtsbackup.   The wrapper has been running for several weeks and this is
the first time this problem has occurred.  The backup is initiated from
cron in AIX 3.2.5.1.  

I'm running  SQL-BackTrack Sybase Backup Utility (DTSBACKUP) Version 
3.0.1, serial number BT-00126892-4474, and  the version of the SQL Server
is  SQL Server/10.0.2.4/P/RS6000/AIX3.2/EBF 5591 Rollup/OPT/Fri Dec  8
23:57:23 PST 1995.

The problem is that a backup started at 22:40 last night and has not
completed.  The backup of this database usually takes about 25 minutes.
The backup is written to disk and there is no backup file on disk.  I've
collected info below which may be helpful.  I can be reached by phone at
(212) 854-1362 or email.  Thank you for looking into this.

Kathy Kratter


sybase id Crontab Entry:

   40 22 * * 1-6 /usr/local/dba/bin/dtsbackup sis             >/dev/null 2>&1


Command Issued by Wrapper (from wrapper log):

   11/11/97 22:40:17 : dtsbackup command:
      /usr/local/datatools/sbacktrack/bin/dtsbackup
      /usr/local/datatools/sbackups.physical/SYBASE@CUAIX06/sis -verbose
      -noprompt -tasks 3 -options ' -contents -no_logical_header '


>From dtwatch:

   Active:
     Tue 22:40 dtsbackup 21673: Backing up 1 control file.
     Tue 22:40 dtsdump 16555: SYBASE@CUAIX06 sis: 1.60M B/s: 49.5%  604,000 Of 1,220,779 blocks unloaded.
     Tue 22:40 obsi/disk 23980: Written 392.75M bytes to /usr/lcl/sybase/backup/sis/sis-0.11-11-1997.22:40-23980
     Tue 22:40 dtdumpcmd 22701: DUMP DATABASE command active.
     Tue 22:40 dtstripe2 19378: SYBASE@CUAIX06 sis: 640K B/s: 46.8%  571,360 Of 1,220,779 blocks unloaded.
     Tue 22:40 obsi/disk 20659: Written 370.25M bytes to /usr/lcl/sybase/backup/sis/stripe0/sis-0.11-11-1997.22:40-20659


>From ps -ef command:

  sybase 22158 11405   0 22:40:00      -  0:02 perl -wT /dev/fd/3//usr/local/dba/bin/dtsbackup sis 
     sybase 23720 22158   0 22:40:17      -  0:00 sh sh sh 
        sybase 21673 23720       0 22:40:17 -  0:33 /usr/local/datatools/sbacktrack/bin/dtsbackup /usr/local/datatools/sbackups.phys
           sybase 16555 21673    0 22:40:18 -  9:57 dtsdump -physical -server SYBASE@CUAIX06 -database sis -contents -no_logical_hea
              sybase 22701 16555 0 22:40:34 -  0:04 dtsdump -physical -server SYBASE@CUAIX06 -database sis -contents -no_logical_hea
              sybase 19378 16555 0 22:40:38 -  9:17 dtsdump -physical -server SYBASE@CUAIX06 -database sis -contents -no_logical_hea
           sybase 23980 21673    0 22:40:25 -  0:20 disk 
           sybase 20659 21673    0 22:40:39 -  0:18 disk 


>From SQL Server sp_who command:

   1> sp_who
   2> go
    spid   status       loginame                       hostname   blk  
            dbname                         cmd              
    ------ ------------ ------------------------------ ---------- ----- 
           ------------------------------ ---------------- 
         1 recv sleep   sa                                        0    
            master                         AWAITING COMMAND 
         6 sleeping     NULL                           cuaix06    0    
            sis                            DUMP DATABASE    


>From SQL Server sysprocesses table:

   1> select * from sysprocesses where spid = 1
   2> go
    spid   kpid        enginenum   status       suid   hostname   program_name    
         1    49152017           0 recv sleep        1            dtsbackup       
            hostprocess cmd              cpu         physical_io memusage   
            22158       AWAITING COMMAND           2           2           1
            blocked dbid   uid    gid   
                  0      1      1      0
            tran_name                                                       
            NULL                                                            
            time_blocked network_pktsz 
                    NULL           512 
   (1 row affected)
   1> select * from sysprocesses where spid = 6
   2> go
    spid   kpid        enginenum   status       suid   hostname   program_name    
         6    49414180           0 sleeping          0 cuaix06    SQL-BackTrack   
            hostprocess cmd              cpu         physical_io memusage   
            22701       DUMP DATABASE              0         299          14
            blocked dbid   uid    gid   
                  0      7      1      0
            tran_name                                                       
            NULL                                                            
            time_blocked network_pktsz 
                    NULL           512 
   (1 row affected)