# The db times out upon dropping a keyspace **URL:** \ **Category:** ScyllaDB\ **Tags:** open-source\ **Created:** [June 15, 2023, 11:01am UTC](https://forum.scylladb.com/t/the-db-times-out-upon-dropping-a-keyspace/618 "2023-06-15T11:01:20Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Bloodpriest](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/bloodpriest/32/347_2.png) [@Bloodpriest](https://forum.scylladb.com/u/Bloodpriest)\ **Post date:** [June 15, 2023, 11:01am UTC](https://forum.scylladb.com/t/the-db-times-out-upon-dropping-a-keyspace/618/1 "2023-06-15T11:01:20Z")
Whenever I try to drop a keyspace, the operation rarely gets executed at the db times out. I always get this error- `OperationTimedOut: errors={'172.17.0.2': 'Client request timeout. See Session.execute[_async](timeout)'}, last_host=172.17.0.2` Why is this happening? ---
**Author:** ![bhalevy](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/bhalevy/32/175_2.png) [@bhalevy](https://forum.scylladb.com/u/bhalevy)\ **Post date:** [June 17, 2023, 6:05pm UTC](https://forum.scylladb.com/t/the-db-times-out-upon-dropping-a-keyspace/618/2 "2023-06-17T18:05:26Z")
It’s impossible to know without more context. Are there related messages in system log? What is the timeouts configuration? What kind of disks are you using? Is auto\_snapshot enabled? ---
**Author:** ![Bloodpriest](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/bloodpriest/32/347_2.png) [@Bloodpriest](https://forum.scylladb.com/u/Bloodpriest)\ **Post date:** [June 19, 2023, 6:15am UTC](https://forum.scylladb.com/t/the-db-times-out-upon-dropping-a-keyspace/618/3 "2023-06-19T06:15:58Z")
> Are there related messages in system log? Not sure, what that means??? > What is the timeouts configuration? default 15s > What kind of disks are you using? My PC, default 256 ssd 1 tb hdd for storage. Its in dev mode > Is auto\_snapshot enabled? Nope I couldnt find the default option true in the config file. ---
**Author:** ![bhalevy](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/bhalevy/32/175_2.png) [@bhalevy](https://forum.scylladb.com/u/bhalevy)\ **Post date:** [June 19, 2023, 8:17am UTC](https://forum.scylladb.com/t/the-db-times-out-upon-dropping-a-keyspace/618/4 "2023-06-19T08:17:59Z")
> > Are there related messages in system log? > Not sure, what that means??? Scylla prints all kinds of messages to a system log. I’m not sure how you installed it. Anything under `/var/log/`? > > What is the timeouts configuration? > default 15s > > What kind of disks are you using? > My PC, default 256 ssd 1 tb hdd for storage. Its in dev mode > > Is auto\_snapshot enabled? > Nope I couldnt find the default option true in the config file. Then actually it is enabled by default. This means that scylla takes a snapshot of the dropped table(s) / keyspace before deleting it to be on the safe side. It is possible that this takes too long with a magnetic drive. Try setting `auto_snapshot: false` in `scylla.yaml` and restart scylla for it to take effect. Then retry dropping the keyspace / table. ---
**Author:** ![Bloodpriest](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/bloodpriest/32/347_2.png) [@Bloodpriest](https://forum.scylladb.com/u/Bloodpriest)\ **Post date:** [June 19, 2023, 1:33pm UTC](https://forum.scylladb.com/t/the-db-times-out-upon-dropping-a-keyspace/618/5 "2023-06-19T13:33:19Z")
Its installed via docker-compose on a linux system. Deepin to be precise. v4.something ig. Nothing relatedd to scylla under /var/logs tho at first glance, everything seems related to the internal FS. > Try setting `auto_snapshot: false` in `scylla.yaml` and restart scylla for it to take effect. > Then retry dropping the keyspace / table. aaah yes I saw that in the docs but I couldnt find that in my default scylla.yaml file. So I figured by default it mustve been false. Thats 1 thing ive gotta do for sure yep Thanks for the input, ill try to fix this once & for all