Capture Error and output to log in Bash script

Question

I have a script which is checking a database for errors based on a text file of record ids.

When an error occurs such as the connection is lost,it writes the offending id ($line) to a log file as well as the error message ($OP).

Problem is the error message is always null although the error is displayed on the console, only the id is written to the log file.

How can I capture the error and also output that to the log file ??

while read line
do
    OP=$(mysql $DB -u root --password=$PW -e "select * from properties where hierarchyid = $line")
    printf "\r$line"
    #if [ $? -gt 0 ]; then
    if [[ ! $OP =~ "hierarchyid" ]]; then
        echo
        echo $line $OP >> errors.log
        sleep 10    
        echo
    fi
done < $IDS

Ignacio Vazquez-Abrams · Accepted Answer · 2012-09-14 01:12:17Z

3

Redirect stderr to stdout.

OP=$(mysql ... 2>&1)

answered Sep 14, 2012 at 1:12

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Capture Error and output to log in Bash script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related