database call interupted even with signal handler

Question

I have a script that loops infinitely and makes an Oracle call through cx_oracle every X seconds. I also have a signal handler which should allow the script to exit gracefully after it finishes running the oracle procedure. The problem I am running into is the oracle call appears to be interupted by a sigint or a sigterm even though I am handling these.

It is throwing the following error: ORA-01013: user requested cancel of current operation

Here is a sample code (trimmed):

def signal_handler(signum, frame):
        print time.strftime(settings.FDATE) + " - Quitting safely..."
        global exit
        try:
                exit = 1
        except KeyboardInterrupt:
                exit = 1
                print 'Script is quitting safely, please wait...'

signal.signal(signal.SIGINT, signal_handler)
signal.signal(signal.SIGTERM, signal_handler)

while not exit:
    #database call here
    sleep 5 #actually taking this value from a settings file

I'm not sure if it makes a difference but I am also multithreading based on the results of the database call but the error still happens within the main while loop.

Look at https://docs.oracle.com/en/database/oracle/oracle-database/18/netrf/parameters-for-the-sqlnet-ora-file.html#GUID-3F3AC8BD-F643-427A-BD6A-9B88CF42B972 — Christopher Jones, Jan 14 '19 at 01:01
@ChristopherJones That actually fixed my problem. If you write it in an answer I'll upvote and accept it. — Mocking, Jan 15 '19 at 00:39

score 1 · Answer 1 · answered Jan 22 '19 at 22:53

1

You are right that Oracle does use SININT to cancel the current operation. To avoid conflict you may want to consider using other signals such as SIGQUIT or SIGSTOP.

answered Jan 22 '19 at 22:53

nwoo

11
1

SIGINT is thrown by unix to kill a service. I do not have control over this. – Mocking Jan 24 '19 at 02:53

database call interupted even with signal handler

1 Answers1