https://questdb.io logo
  • terry

    terry

    1 month ago
    drop table 'data_monitor' Could not lock 'data_monitor' [reason='ilpUdp'] TRUNCATE table 'data_monitor' table 'data_monitor' could not be truncated: [0]: table busy [reason=ilpUdp]
  • Jaromir Hamala

    Jaromir Hamala

    1 month ago
    hi terry, please see this FAQ item: https://questdb.io/docs/troubleshooting/faq/#why-do-i-get-table-busy-error-messages-when-inserting-data-over-postgresql-wire-protocol TRUNCATE is not INSERT, but it has the same cause.
  • it seems your ILP client keeps pushing data in.
  • terry

    terry

    1 month ago
    yes but pushing data into another table not the one i want drop or truncate
  • Jaromir Hamala

    Jaromir Hamala

    1 month ago
    are you positive? the error message says the table you are trying to truncate is busy processing ILP messages.
  • terry

    terry

    1 month ago
    yes i confirm have stop push data into the table i want drop