On 3/1/21 12:58 PM, dancab@caltech.edu wrote:
Ok, thanks. I'll need to reproduce what happened somehow.
Any suggestions on how to clear this "held message" notification from the database?
If necessary I can just re-initialize everything but it would be helpful to know if there's just a row I could drop.
I would d delete rows from 3 tables. I would first
SELECT * from message WHERE path = 'XC/DU/XCDUNGGCTVSN7RGCW5F3WXM5T2WEHCCJ';
then
SELECT * from pendedkeyvalue WHERE type = 'id AND value = <the id of the message table>;
Then
SELECT * from pendedkeyvalue WHERE pended_id = <the pended_id from above>;
This should return 2 rows, the type = id from above and a type = 'held message'
Then I would delete the row from the pended table with id = that pended_id and the two rows from the pendedkeyvalue table and the row from the message table.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan