Sponsored Content
Top Forums Shell Programming and Scripting exit on error - is it possible? Post 94689 by ahmedwaseem2000 on Tuesday 3rd of January 2006 05:46:01 AM
Old 01-03-2006
exit on error - is it possible?

Hi , i have shell scripts that run the mysql directly by echoing and redirecting the output to the mysql logins. whenever the query executes successfully then the script runs fine and nothing has to be done there.

Now, when there is an error executing the query then it will generate the error something similar to the below one

Code:
 
ERROR 1146 at line 1: Table 'XXXXXX' doesn't exist

User time 0.01, System time 0.01
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 98, Physical pagefaults 0, Swaps 0
Blocks in 0 out 1, Messages in 3 out 6, Signals 0
Voluntary context switches 1, Involuntary context switches 6
--------------
select * from XXXXX
--------------

Bye

I know i could always redirect the output to a new temp file and grep for error. but i would prefer to do it using variables. is it possible???? since there are multiple lines so i am finiding it difficult to do it with variables

Any sort of help is appreciated.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Where can I find a list of exit codes? (Exit code 64)

I'm receiving an exit code 64 in our batch scheduler (BMC product control-m) executing a PERL script on UX-HP. Can you tell me where I can find a list of exit codes and their meaning. I'm assuming the exit code is from the Unix operating system not PERL. (3 Replies)
Discussion started by: jkuchar747
3 Replies

2. UNIX for Advanced & Expert Users

SAM Error non-zero exit status

Our machines HP-UX 10.20 Ace, Attempting to run various areas of SAM such as Backup and Restore, Printers and Plotters any areas of Time, etc give errors like the following: unexpected exit: process /usr/sam/lbin/samx/ -C -p 1358 -s br_sa_bdevs /usr/sam/lib///br.ui exited with a non-zero exit... (0 Replies)
Discussion started by: real-chess
0 Replies

3. Linux

tar error exit delayed form pervious error

Hi when use "tar cpvzf /dev/st0 --exclude=/proc --exclude-/lost+found --exclude=/mnt --exclude=/media --exclude=/sys /" to tape, get the following message "tar: error exit delayed form pervious error", What is the mean ? Please suggest some solution for these errors. thx (1 Reply)
Discussion started by: chayato
1 Replies

4. Shell Programming and Scripting

exit out of a while loop with error

im running a while loop as a file watcher, with incremental counter on the retries..however when the retries reach it's limit i want it exit and echo and error and stop the batch. Im not sure the code i have will do that already... Here is what i have that works: #!/usr/bin/ksh count=0... (2 Replies)
Discussion started by: sigh2010
2 Replies

5. UNIX for Dummies Questions & Answers

aCC exit error

Hi guys I would just like to know if aCC supports the command exit(0); in c++? I am always getting the error below: Error 328: "ac5.C", line 37 # Function 'exit' has not been defined yet; cannot call. exit(0); ^^^^ Anyone had this problem? Thanks! (2 Replies)
Discussion started by: khestoi
2 Replies

6. Shell Programming and Scripting

If Error then Exit

HI I am just using cd Command and i want exit if error. Ex. cd /hp/pp/0720 If above folder in not available then stop the script Folder is change every day Thanks (3 Replies)
Discussion started by: asavaliya
3 Replies

7. Shell Programming and Scripting

How to exit a script with error ?

Hi, I have a script ABC which calls another script XYZ. Function of XYZ is to ftp a file from one server to another. code for ABC: #!/bin/ksh PATH=/usr/bin home/user/xyz "$@" exit $? ~ code for xyz: #!/bin/ksh HOSTNAME=$1 SRCNAME=$2 DSTNAME=$3 (4 Replies)
Discussion started by: Salil Gupta
4 Replies

8. Shell Programming and Scripting

FTP exit and error codes

I have a script which connects to a remote server via FTP and gets some file from there. #!/bin/bash /usr/bin/ftp -n remote.hostname.com <<EOF quote USER user123 quote PASS password123 lcd /dir1/dir2/dir3 cd / mget file_pattern* close bye EOF rc=$? if ] ... (7 Replies)
Discussion started by: dhruuv369
7 Replies

9. Shell Programming and Scripting

Detect error and exit

Hi, I am using Jenkins and have integrated JMeter for testing. JMeter is generating a file with results properly using shell script. I have to validate the results and exit the shell with non-zero so my jenkins job gets failed. I tried multiple ways to grep the output file and read the results... (2 Replies)
Discussion started by: sitaram
2 Replies
getrusage(3C)						   Standard C Library Functions 					     getrusage(3C)

NAME
getrusage - get information about resource utilization SYNOPSIS
#include <sys/resource.h> int getrusage(int who, struct rusage *r_usage); DESCRIPTION
The getrusage() function provides measures of the resources used by the current process, its terminated and waited-for child processes, or the current light weight process (LWP). If the value of the who argument is RUSAGE_SELF, information is returned about resources used by the current process. If the value of the who argument is RUSAGE_CHILDREN, information is returned about resources used by the terminated and waited-for children of the current process. If the child is never waited for (for instance, if the parent has SA_NOCLDWAIT set or sets SIGCHLD to SIG_IGN), the resource information for the child process is discarded and not included in the resource information provided by getrusage(). If the value of the who argument is RUSAGE_LWP, information is returned about resources used by the current LWP. The r_usage argument is a pointer to an object of type struct rusage in which the returned information is stored. The members of rusage are as follows: struct timeval ru_utime; /* user time used */ struct timeval ru_stime; /* system time used */ long ru_maxrss; /* maximum resident set size */ long ru_idrss; /* integral resident set size */ long ru_minflt; /* page faults not requiring physical I/O */ long ru_majflt; /* page faults requiring physical I/O */ long ru_nswap; /* swaps */ long ru_inblock; /* block input operations */ long ru_oublock; /* block output operations */ long ru_msgsnd; /* messages sent */ long ru_msgrcv; /* messages received */ long ru_nsignals; /* signals received */ long ru_nvcsw; /* voluntary context switches */ long ru_nivcsw; /* involuntary context switches */ The structure members are interpreted as follows: ru_utime The total amount of time spent executing in user mode. Time is given in seconds and microseconds. ru_stime The total amount of time spent executing in system mode. Time is given in seconds and microseconds. ru_maxrss The maximum resident set size. Size is given in pages (the size of a page, in bytes, is given by the getpagesize(3C) func- tion). See the NOTES section of this page. ru_idrss An "integral" value indicating the amount of memory in use by a process while the process is running. This value is the sum of the resident set sizes of the process running when a clock tick occurs. The value is given in pages times clock ticks. It does not take sharing into account. See the NOTES section of this page. ru_minflt The number of page faults serviced which did not require any physical I/O activity. See the NOTES section of this page. ru_majflt The number of page faults serviced which required physical I/O activity. This could include page ahead operations by the kernel. See the NOTES section of this page. ru_nswap The number of times a process was swapped out of main memory. ru_inblock The number of times the file system had to perform input in servicing a read(2) request. ru_oublock The number of times the file system had to perform output in servicing a write(2) request. ru_msgsnd The number of messages sent over sockets. ru_msgrcv The number of messages received from sockets. ru_nsignals The number of signals delivered. ru_nvcsw The number of times a context switch resulted due to a process voluntarily giving up the processor before its time slice was completed (usually to await availability of a resource). ru_nivcsw The number of times a context switch resulted due to a higher priority process becoming runnable or because the current process exceeded its time slice. RETURN VALUES
Upon successful completion, getrusage() returns 0. Otherwise, -1 is returned and errno is set to indicate the error. ERRORS
The getrusage() function will fail if: EFAULT The address specified by the r_usage argument is not in a valid portion of the process' address space. EINVAL The who parameter is not a valid value. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Standard | +-----------------------------+-----------------------------+ SEE ALSO
sar(1M), read(2), times(2), write(2), getpagesize(3C), gettimeofday(3C), wait(3C), attributes(5), standards(5) NOTES
The ru_maxrss, ru_ixrss, ru_idrss, and ru_isrss members of the rusage structure are set to 0 in this implementation. The numbers ru_inblock and ru_oublock account only for real I/O, and are approximate measures at best. Data supplied by the cache mechanism is charged only to the first process to read and the last process to write the data. The way resident set size is calculated is an approximation, and could misrepresent the true resident set size. Page faults can be generated from a variety of sources and for a variety of reasons. The customary cause for a page fault is a direct ref- erence by the program to a page which is not in memory. Now, however, the kernel can generate page faults on behalf of the user, for exam- ple, servicing read(2) and write(2) functions. Also, a page fault can be caused by an absent hardware translation to a page, even though the page is in physical memory. In addition to hardware detected page faults, the kernel may cause pseudo page faults in order to perform some housekeeping. For example, the kernel may generate page faults, even if the pages exist in physical memory, in order to lock down pages involved in a raw I/O request. By definition, major page faults require physical I/O, while minor page faults do not require physical I/O. For example, reclaiming the page from the free list would avoid I/O and generate a minor page fault. More commonly, minor page faults occur during process startup as references to pages which are already in memory. For example, if an address space faults on some "hot" executable or shared library, this results in a minor page fault for the address space. Also, any one doing a read(2) or write(2) to something that is in the page cache will get a minor page fault(s) as well. There is no way to obtain information about a child process which has not yet terminated. SunOS 5.10 2 Jul 2004 getrusage(3C)
All times are GMT -4. The time now is 10:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy