SQL Guide : solidDB® SQL statements : MESSAGE : MESSAGE DELETE
  
MESSAGE DELETE
MESSAGE message_name [FROM REPLICA replica_name] DELETE
Usage
The MESSAGE DELETE statement deletes a message from the database to recover from an error. For example, the execution of a message can be terminated because of an error. The MESSAGE DELETE statement is applicable only in advanced replication configurations. It can be issued both on the master and replica databases.
When issued on the master database, the node name of the replica database that forwarded the message must be specified with the FROM REPLICA replica_name clause.
Note The current transaction and all subsequent transactions that were propagated to the master in this message are permanently lost when the message is deleted.
When deleting messages, the autocommit mode must always be switched off.
To use this statement, you must have SYS_SYNC_ADMIN_ROLE access.
Note As an alternative, the MESSAGE DELETE CURRENT TRANSACTION command can provide better recovery because it lets you delete only the offending transaction.
Return values from replica
Error code
Description
25005
Message message_name is already active
25013
Message message_name not found
25035
Message message_name is in use.
A user is currently creating or forwarding this message.
25056
Autocommit not allowed
Return values from master
Error code
Description
13047
No privilege for operation
25009
Replica replica_name not found
25013
Message message_name not found
25020
Database is not a master database
25035
Message message_name is in use.
A user is currently executing this message.
25056
Autocommit not allowed
Examples
MESSAGE MyMsg0000 DELETE;
MESSAGE MyMsg0001 FROM REPLICA bills_laptop DELETE;
Related reference
MESSAGE DELETE
See also
MESSAGE