Not supported event type in CQN when shutdown and startup database · Issue #102 · oracle/odpi (original) (raw)

I ran TestCQN under the sample directory. When I shutted down and started up the database, it printed ERROR: DPI-1013: not supported (dpiSubscr__callback: event type).

Here is the output.

$ pwd
/home/kubo/odpi/samples
$ LD_LIBRARY_PATH=../lib ./build/TestCQN  # shutdown and startup the database in another terminal
Registered query with id 101

In another session, modify the results of the query

select * from TestTempTable

Use Ctrl-C to terminate or wait for 100 seconds
Waiting for notifications...
Waiting for notifications...
ERROR: DPI-1013: not supported (dpiSubscr__callback: event type)
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
ERROR: DPI-1013: not supported (dpiSubscr__callback: event type)
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Waiting for notifications...
Done.

The values of message->eventType were 'DPI_EVENT_SHUTDOWNandDPI_EVENT_STARTUP` when DPI-1013 errors were reported.

The following code should be added just next of this line

    case DPI_EVENT_STARTUP:
    case DPI_EVENT_SHUTDOWN:
    case DPI_EVENT_SHUTDOWN_ANY:
        break;

ODPI-C version: The latest in the github repository.
Oracle version: Oracle 18.3
OS: Linux