# Failed to drop bins

**URL:** <https://discuss.aerospike.com/t/failed-to-drop-bins/8055>\
**Category:** Tuning\
**Tags:** query\
**Created:** [December 5, 2020, 11:24am UTC](https://discuss.aerospike.com/t/failed-to-drop-bins/8055 "2020-12-05T11:24:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![totola](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@totola](https://discuss.aerospike.com/u/totola)\
**Post date:** [December 5, 2020, 11:24am UTC](https://discuss.aerospike.com/t/failed-to-drop-bins/8055/1 "2020-12-05T11:24:28Z")

</div>

Our program write many bins unexpectedly cause by bugs , and bin number get the maximum numbers , we try to delete bins ,but failed .

we truncate the sets ,but the bins still remain from `show bins` we reset bins to null in insert caluse using aql tools ` insert into namespaces.sets (keys, bin) value('key',null)` and bins still there how to drop set and bins without cold restart ,AS version 4.5.3.10

---

<div class="post-metadata">

**Author:** ![Albot](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/albot/32/2076_2.png) [@Albot](https://discuss.aerospike.com/u/Albot)\
**Post date:** [December 5, 2020, 9:17pm UTC](https://discuss.aerospike.com/t/failed-to-drop-bins/8055/2 "2020-12-05T21:17:58Z")

</div>

You can’t without a rolling cold restart. [How to clear up set and bin names when it exceeds the maximum set limit](https://discuss.aerospike.com/t/how-to-clear-up-set-and-bin-names-when-it-exceeds-the-maximum-set-limit/3122)

---

<div class="post-metadata">

**Author:** ![totola](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@totola](https://discuss.aerospike.com/u/totola)\
**Post date:** [December 7, 2020, 5:03am UTC](https://discuss.aerospike.com/t/failed-to-drop-bins/8055/3 "2020-12-07T05:03:19Z")

</div>

thank you very much , after rolling restart , the sets and bins gone

---

<div class="post-metadata">

**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/system/32/2274_2.png) [@system](https://discuss.aerospike.com/u/system)\
**Post date:** [March 1, 2021, 5:03am UTC](https://discuss.aerospike.com/t/failed-to-drop-bins/8055/4 "2021-03-01T05:03:24Z")

</div>

Closed on March 1, 2021, 5:03am UTC

This topic was automatically closed 84 days after the last reply. New replies are no longer allowed.
