Can states go into debt indefinitely?

In reality, no state ever repays its debts. And yet, insolvency doesn't necessarily lead to bankruptcy. Public debt isn't just numbers; it also depends on growth, interest rates, policy, and, above all, confidence. When does debt become useful, and how can it become a threat?