S03003

Error Code

S03003

Error Message

All subscriptions to the stream table <xxx> must be canceled before it can be dropped. Call getStreamingStat().pubTables to get the status of all stream tables. RefId: S03003

Probable Causes

A stream table can be subscribed by:

  • the node where the table is located

  • other nodes in the cluster

  • an API client

The aforementioned three subscriptions will prevent the stream table from being undefined or destroyed. Only when all subscriptions to the table are canceled, can it be dropped with the dropStreamTable function or the drop statement.

Solutions

Call the getStreamingStat function to monitor the subscriptions to the stream table:

  • Check the subscriptions to the table with getStreamingStat().pubTables.

  • Check the connections between the local publisher node and all of its subscriber nodes with getStreamingStat().pubConns.

Then, use the unsubscribeTable function to cancel the subscriptions. Once all subscriptions are canceled, the stream table can be dropped.