Join the conversation
Powered by Linen
06/28/2022, 3:41 AM
drop table 'data_monitor' Could not lock 'data_monitor' [reason='ilpUdp'] TRUNCATE table 'data_monitor' table 'data_monitor' could not be truncated: : table busy [reason=ilpUdp]
06/28/2022, 6:45 AM
hi terry, please see this FAQ item:
TRUNCATE is not INSERT, but it has the same cause.
it seems your ILP client keeps pushing data in.
06/28/2022, 1:50 PM
yes but pushing data into another table not the one i want drop or truncate
06/28/2022, 1:58 PM
are you positive? the error message says the table you are trying to truncate is busy processing ILP messages.
06/28/2022, 2:00 PM
yes i confirm have stop push data into the table i want drop
View count: 12
Back to #users-public
Join thread in Slack