- 🇷🇺Russia APolitsin
Thanks @geek-merlin
```sh
drush php:eval "\Drupal\Core\Database\Database::getConnection('default', NULL)->query('vacuum;');"
```
I've spotted this issue while trying to vacuum sqlite3 database (it grew to over 440 Mb), while sqlite3_analyze reported only 20 Mb of data and over 95% of freelist. Upon vacum, sqlite3 reported `Error: no such collation sequence: NOCASE_UTF8`. Apparently NOCASE_UTF8 is custom collation for PDO driver, but it is invalid in sqlite3. Simple replacing NOCASE_UTF8 with NOCASE on db file solves the issue. This likely affects auto vacuum and in the result db file gets really huge with time.
More info here: https://bioinfoexpert.com/2019/02/28/investigate-reduce-the-size-of-drup...
Also reported in
https://www.drupal.org/project/drupal/issues/2462175#comment-12991687 →
Active
11.0 🔥
Enhances developer experience.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Thanks @geek-merlin
```sh
drush php:eval "\Drupal\Core\Database\Database::getConnection('default', NULL)->query('vacuum;');"
```