Nextcloud Ubuntu server is acting up, don't know where to start, it's slow and won't sync right

My Problem

Hey all, I use an older computer that’s from around 2010 that my family used as a desktop. It’s never been fast but I use it for “lightweight” tasks. It functions as NAS, Plex Media Server, recently Pi-Hole, and Nextcloud. Recently I had to reset my desktop, and getting data from the server ten feet away was awful, eventually I just made a temporary samba to rsync all the data over and nextcloud has been failing at syncing the data to recognize it’s the same data for the past week. I checked top on the server, www-data is using only about 20-40% of the cpu, and not a lot of ram. Yet my dns queries are slow on my home network because of pi-hole on the hung up server, sudo apt-get update times out, ssh takes a good 30 seconnds or more to log in, etc. None of this was an issue, until I needed nextcloud to sync the 150GB of data. I’m not great with databases / nextcloud, I’ve got a pretty basic config that was spoonfed to me through guides from googling, “setting up a self hosted cloud on nextcloud”, but I’m okay at linux and following instructions and can provide necessary info, just need to know what to give

Nextcloud version: 21.0.0
Operating system and version: Description: Ubuntu 20.04.3 LTS
Apache or nginx version: Server version: Apache/2.4.41 (Ubuntu)
PHP version: PHP 7.4.24

The issue you are facing:
Files aren’t syncing 100% through, it eventually fails, and eventually starts back up, it will fail on a different set of files every time
Screenshot_20211026_112620

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Try to sync files by leaving Nextcloud desktop client open
  2. Wait
  3. Picture posted above happens, go back to step 1

The output of your Nextcloud log in Admin > Logging:

Error	index	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_553_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")	
2021-10-27T13:21:52-0400
Error	no app in context	Dashboard widget mail took 3.42 seconds to load.	
2021-10-27T13:05:52-0400
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_553_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")	
2021-10-27T10:03:22-0400
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_553_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")	
2021-10-26T21:19:17-0400
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_553_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")	
2021-10-26T19:53:51-0400
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_553_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")	
2021-10-26T07:08:32-0400
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_553_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")	
2021-10-25T21:40:18-0400
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_553_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")	
2021-10-25T19:32:52-0400
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_553_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")	
2021-10-25T19:06:07-0400
Error	index	Exception: Argument 1 passed to OC\Core\Controller\ClientFlowLoginV2Controller::grantPage() must be of the type string, null given, called in /var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php on line 218	
2021-10-25T11:24:52-0400
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_557_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")	
2021-10-22T16:54:46-0400
Error	no app in context	Sabre\DAV\Exception\BadRequest: Expected filesize of 32982728 bytes but read (from Nextcloud client) and wrote (to Nextcloud storage) 18997248 bytes. Could either be a network problem on the sending side or a problem writing to the storage on the server side.	
2021-10-22T14:20:21-0400
Error	PHP	Error: fread(): write of 8192 bytes failed with errno=28 No space left on device at /var/www/html/nextcloud/3rdparty/icewind/streams/src/Wrapper.php#55	
2021-10-22T14:20:21-0400
Warning	no app in context	Invalid data provided to provideInitialState by files	
2021-10-21T14:56:56-0400
Warning	no app in context	Invalid data provided to provideInitialState by files	
2021-10-21T13:52:10-0400
Error	no app in context	Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-cd23da6e138b7afff89e069432a02b93' for key 'fs_storage_path_hash'	
2021-10-16T12:22:53-0400
Warning	no app in context	Invalid data provided to provideInitialState by files	
2021-10-07T13:15:08-0400
Warning	no app in context	Invalid data provided to provideInitialState by files	
2021-09-22T19:57:28-

The output of your config.php file in /path/to/nextcloud:

<?php
$CONFIG = array (
  'instanceid' => 'oc83rdaogq84',
  'passwordsalt' => '[REDACTED]',
  'secret' => '[REDACTED]',
  'trusted_domains' => 
  array (
    0 => '[REDACTED]',
    1 => '[REDACTED]',
    2 => '[REDACTED]',
  ),
  'datadirectory' => '/new-pool/nextcloud',
  'dbtype' => 'mysql',
  'version' => '21.0.0.18',
  'overwrite.cli.url' => '[REDACTED]',
  'dbname' => 'nextclouddb',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => '[REDACTED]',
  'dbpassword' => '[REDACTED]',
  'installed' => true,
  'updater.secret' => '[REDACTED]',
);

The output of your Apache/nginx/system log in /var/log/____, this log is blank, I’ve got a bunch of compressed ones though, this is access.log.1, which is from september and seems useless to include all of it:

192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/change.svg HTTP/1.1" 200 1029 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/change.svg HTTP/1.1" 200 1029 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/change.svg HTTP/1.1" 200 1029 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/change.svg HTTP/1.1" 200 1029 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/change.svg HTTP/1.1" 200 1029 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - jamess7995 [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/ocs/v2.php/apps/activity/api/v2/activity?since=44856&limit=50&format=json HTTP/1.1" 200 3759 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - jamess7995 [06/Sep/2021:04:51:54 +0000] "GET /nextcloud/ocs/v2.php/apps/activity/api/v2/activity?since=44806&limit=50&format=json HTTP/1.1" 200 3823 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - jamess7995 [06/Sep/2021:04:51:55 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1020 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.1 - jamess7995 [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/ocs/v2.php/apps/activity/api/v2/activity?since=44756&limit=50&format=json HTTP/1.1" 200 3429 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/change.svg HTTP/1.1" 200 1029 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/delete-color.svg HTTP/1.1" 200 842 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/delete-color.svg HTTP/1.1" 200 842 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/delete-color.svg HTTP/1.1" 200 842 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/delete-color.svg HTTP/1.1" 200 842 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/add-color.svg HTTP/1.1" 200 714 "-" "Mozilla/5.0"
192.168.50.1 - - [06/Sep/2021:04:51:55 +0000] "GET /nextcloud/apps/files/img/change.svg HTTP/1.1" 200 1029 "-" "Mozilla/5.0"
::1 - - [06/Sep/2021:04:52:01 +0000] "OPTIONS * HTTP/1.0" 200 126 "-" "Apache/2.4.41 (Ubuntu) (internal dummy connection)"
192.168.50.1 - jamess7995 [06/Sep/2021:04:52:15 +0000] "GET /nextcloud/ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 935 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.1 - jamess7995 [06/Sep/2021:04:52:15 +0000] "GET /nextcloud/ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 286 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.1 - jamess7995 [06/Sep/2021:04:52:36 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1021 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.1 - jamess7995 [06/Sep/2021:04:52:45 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1012 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.1 - jamess7995 [06/Sep/2021:04:53:15 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1012 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.207 - - [06/Sep/2021:04:53:23 +0000] "POST /admin/scripts/pi-hole/php/groups.php HTTP/1.1" 500 347 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/groups-adlists.php HTTP/1.1" 200 5787 "http://192.168.50.112/admin/index.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/SourceSansPro/SourceSansPro.css?v=1630902391 HTTP/1.1" 200 937 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/select2.min.css?v=1630902391 HTTP/1.1" 200 2336 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/daterangepicker.min.css?v=1630902391 HTTP/1.1" 200 1828 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/datatables.min.css?v=1630902391 HTTP/1.1" 200 1459 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/AdminLTE.min.css?v=1630902391 HTTP/1.1" 200 17219 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/bootstrap/css/bootstrap.min.css?v=1630902391 HTTP/1.1" 200 20081 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/animate.min.css?v=1630902391 HTTP/1.1" 200 4596 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/bootstrap-toggle.min.css?v=1630902391 HTTP/1.1" 200 878 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/bootstrap-select.min.css?v=1630902391 HTTP/1.1" 200 2584 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/pi-hole.css?v=1630902391 HTTP/1.1" 200 2512 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/themes/default-light.css?v=1630902391 HTTP/1.1" 200 1588 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/bootstrap/js/bootstrap.min.js?v=1630902391 HTTP/1.1" 200 11292 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/vendor/bootstrap-notify.min.js?v=1630902391 HTTP/1.1" 200 3002 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/vendor/adminlte.min.js?v=1630902391 HTTP/1.1" 200 3865 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/vendor/moment.min.js?v=1630902391 HTTP/1.1" 200 17465 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/vendor/datatables.min.js?v=1630902391 HTTP/1.1" 200 30689 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/vendor/bootstrap-toggle.min.js?v=1630902391 HTTP/1.1" 200 1678 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/vendor/bootstrap-select.min.js?v=1630902391 HTTP/1.1" 200 16148 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/vendor/jquery.min.js?v=1630902391 HTTP/1.1" 200 31263 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/vendor/select2.min.js?v=1630902391 HTTP/1.1" 200 20257 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/pi-hole/js/utils.js?v=1630902391 HTTP/1.1" 200 3464 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/pi-hole/js/groups-adlists.js?v=1630902391 HTTP/1.1" 200 4743 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/pi-hole/js/footer.js?v=1630902391 HTTP/1.1" 200 3113 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/scripts/vendor/Chart.min.js?v=1630902391 HTTP/1.1" 200 53164 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/style/vendor/font-awesome/js/all.min.js?v=1630902391 HTTP/1.1" 200 444324 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/img/donate.gif HTTP/1.1" 304 180 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/img/boxed-bg.jpg HTTP/1.1" 304 182 "http://192.168.50.112/admin/style/pi-hole.css?v=1630902391" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/img/logo.svg HTTP/1.1" 304 180 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/img/favicons/favicon-16x16.png HTTP/1.1" 200 792 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:27 +0000] "GET /admin/img/favicons/apple-touch-icon.png HTTP/1.1" 200 4061 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:28 +0000] "GET /admin/style/vendor/icheck-bootstrap.min.css HTTP/1.1" 200 1934 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:28 +0000] "POST /admin/scripts/pi-hole/php/groups.php HTTP/1.1" 500 347 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:28 +0000] "GET /admin/api_db.php?status HTTP/1.1" 500 436 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:53:33 +0000] "GET /admin/api_db.php?status HTTP/1.1" 500 436 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.1 - jamess7995 [06/Sep/2021:04:53:45 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1012 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.207 - - [06/Sep/2021:04:54:03 +0000] "POST /admin/scripts/pi-hole/php/groups.php HTTP/1.1" 500 347 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.1 - jamess7995 [06/Sep/2021:04:54:15 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1012 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.207 - - [06/Sep/2021:04:54:36 +0000] "POST /admin/scripts/pi-hole/php/groups.php HTTP/1.1" 500 347 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.1 - jamess7995 [06/Sep/2021:04:54:45 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1012 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.207 - - [06/Sep/2021:04:55:04 +0000] "POST /admin/scripts/pi-hole/php/groups.php HTTP/1.1" 500 347 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:06 +0000] "GET /admin/groups-adlists.php?logout HTTP/1.1" 302 424 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:06 +0000] "GET /admin/index.php HTTP/1.1" 200 3561 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:08 +0000] "GET /admin/index.php?login HTTP/1.1" 200 4651 "http://192.168.50.112/admin/index.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:09 +0000] "GET /admin/api_db.php?status HTTP/1.1" 500 287 "http://192.168.50.112/admin/index.php?login" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:14 +0000] "GET /admin/api_db.php?status HTTP/1.1" 500 287 "http://192.168.50.112/admin/index.php?login" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.1 - jamess7995 [06/Sep/2021:04:55:15 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1012 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.207 - - [06/Sep/2021:04:55:17 +0000] "POST /admin/index.php?login HTTP/1.1" 302 554 "http://192.168.50.112/admin/index.php?login" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:17 +0000] "GET /admin/index.php HTTP/1.1" 200 4728 "http://192.168.50.112/admin/index.php?login" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:21 +0000] "GET /admin/groups-adlists.php HTTP/1.1" 200 5783 "http://192.168.50.112/admin/index.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:21 +0000] "POST /admin/scripts/pi-hole/php/groups.php HTTP/1.1" 500 347 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:21 +0000] "GET /admin/api_db.php?status HTTP/1.1" 500 436 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:26 +0000] "GET /admin/api_db.php?status HTTP/1.1" 500 436 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.207 - - [06/Sep/2021:04:55:27 +0000] "POST /admin/scripts/pi-hole/php/groups.php HTTP/1.1" 500 347 "http://192.168.50.112/admin/groups-adlists.php" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
192.168.50.1 - jamess7995 [06/Sep/2021:04:55:45 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1012 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"
192.168.50.1 - jamess7995 [06/Sep/2021:04:56:15 +0000] "PROPFIND /nextcloud/remote.php/dav/files/jamess7995/ HTTP/1.1" 207 1012 "-" "Mozilla/5.0 (Linux) mirall/3.2.4git (Nextcloud, fedora-5.12.5-zen+ ClientArchitecture: x86_64 OsArchitecture: x86_64)"

i think this

 (errno: 28 "No space left on device")	
2021-10-27T10:03:22-0400

part of your log tells you everything :wink:
GOOD LUCK!

I’ve got plenty space though? I’m running the OS off of a flash drive so 72% is high but not for the flash drive I don’t think. I think the loop devices are okay being full since they’re just snap, I don’t know enough to understand why snap is even involved, I know a lot of linux users hate it.

jamess7995@leviathan:~$ df -h
Filesystem          Size  Used Avail Use% Mounted on
udev                1.7G     0  1.7G   0% /dev
tmpfs               352M  2.9M  349M   1% /run
/dev/sdc2            28G   19G  7.4G  72% /
tmpfs               1.8G  3.8M  1.8G   1% /dev/shm
tmpfs               5.0M     0  5.0M   0% /run/lock
tmpfs               1.8G     0  1.8G   0% /sys/fs/cgroup
/dev/sdc1           511M  5.3M  506M   2% /boot/efi
new-pool            1.8T  128K  1.8T   1% /new-pool
new-pool/Parents    1.8T  128K  1.8T   1% /new-pool/Parents
new-pool/Scipio     1.8T  4.8G  1.8T   1% /new-pool/Scipio
new-pool/Highwind   2.5T  684G  1.8T  28% /new-pool/Highwind
new-pool/nextcloud  2.0T  164G  1.8T   9% /new-pool/nextcloud
new-pool/Home       1.9T   16G  1.8T   1% /new-pool/Home
/dev/loop0          100M  100M     0 100% /snap/core/11798
/dev/loop1          100M  100M     0 100% /snap/core/11993
/dev/loop2           56M   56M     0 100% /snap/core18/2128
/dev/loop3           62M   62M     0 100% /snap/core20/1169
/dev/loop4           56M   56M     0 100% /snap/core18/2246
/dev/loop5           62M   62M     0 100% /snap/core20/1081
/dev/loop6           68M   68M     0 100% /snap/lxd/21545
/dev/loop7           33M   33M     0 100% /snap/snapd/13270
/dev/loop8           33M   33M     0 100% /snap/snapd/13640
/dev/loop9           71M   71M     0 100% /snap/lxd/21029
tmpfs               352M     0  352M   0% /run/user/996
tmpfs               352M     0  352M   0% /run/user/1000

I don’t know if this is more of a linux question than a nextcloud, but it does seem like I could clear up 3GB by removing these cache’s, seems like theres thousands of 1MB cache files

jamess7995@leviathan:~$ sudo du -hax --max-depth=3 /var/cache/lighttpd/uploads | sort -rh | head -20
3.5G    /var/cache/lighttpd/uploads
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-ZzyRKo
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-ZzqeLq
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zZc6qq
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zzalWp
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-Zz9Imp
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-ZZ5tep
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zywcoo
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zYqnmr
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-Zyfeto
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-Zy4qWo
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-Zxynnp
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-ZXskzq
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zxQU7m
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zxqNgo
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zxQEbo
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-ZxmtUn
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zXE9Jo
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zxCPOo
1.1M    /var/cache/lighttpd/uploads/lighttpd-upload-zWtyQn
jamess7995@leviathan:~$ ls /var/cache/lighttpd/uploads | wc -l
ls: cannot access '/var/cache/lighttpd/uploads': Permission denied
0
jamess7995@leviathan:~$ sudo !!
sudo ls /var/cache/lighttpd/uploads | wc -l
3566

so this pobably concerns the db itself. you should check in the filesystem where the db keeps its files. are there any quotas/filesystem-constraints in place for snap? i do not use snap, so i cannot help you there (exactly for this reason: at first it seems easy to install and use, but when there are errors they can be much harder th debug)
which filesystem do you use? if it is btrfs, it can be “full” even if df shows plenty of space. it this case it might help to balance it: info here
deleting sth in/var/cache might help, but better double-check before that the stuff is really not needed anymore.
GOOD LUCK!

So here’s the info about the top level drives, there’s loop devices we ignore cause snap, there’s 3 drives part of a raid via zfs/zpool, and then the OS Flash Drive

jamess7995@leviathan:~$ lsblk -o name,fstype,uuid,mountpoint
NAME   FSTYPE     UUID                                 MOUNTPOINT
loop0  squashfs                                        /snap/core/11798
loop1  squashfs                                        /snap/core/11993
loop2  squashfs                                        /snap/core18/2246
loop3  squashfs                                        /snap/core18/2128
loop4  squashfs                                        /snap/core20/1081
loop5  squashfs                                        /snap/core20/1169
loop6  squashfs                                        /snap/snapd/13270
loop7  squashfs                                        /snap/lxd/21029
loop8  squashfs                                        /snap/lxd/21545
loop9  squashfs                                        /snap/snapd/13640
sda                                                    
├─sda1 zfs_member 4102115073815531652                  
└─sda9                                                 
sdb                                                    
├─sdb1 zfs_member 4102115073815531652                  
└─sdb9                                                 
sdc                                                    
├─sdc1 zfs_member 4102115073815531652                  
└─sdc9                                                 
sdd                                                    
├─sdd1 vfat       366A-995D                            /boot/efi
└─sdd2 ext4       518c3f54-2064-4455-868e-73828695b572 /

Next, checking at least the tmp directory per your latest reply, all storage is good, there’s no fancy setup with different directories are given set amounts of space

jamess7995@leviathan:~$ df -h /tmp/
Filesystem      Size  Used Avail Use% Mounted on
/dev/sdd2        28G   23G  3.5G  87% /
jamess7995@leviathan:~$ df -h /tmp
Filesystem      Size  Used Avail Use% Mounted on
/dev/sdd2        28G   23G  3.5G  87% /
jamess7995@leviathan:~$ df -h /
Filesystem      Size  Used Avail Use% Mounted on
/dev/sdd2        28G   23G  3.5G  87% /
jamess7995@leviathan:~$ df -h 
Filesystem          Size  Used Avail Use% Mounted on
udev                1.7G     0  1.7G   0% /dev
tmpfs               352M  2.9M  349M   1% /run
/dev/sdd2            28G   23G  3.5G  87% /
tmpfs               1.8G  3.6M  1.8G   1% /dev/shm
tmpfs               5.0M     0  5.0M   0% /run/lock
tmpfs               1.8G     0  1.8G   0% /sys/fs/cgroup
/dev/sdd1           511M  5.3M  506M   2% /boot/efi
/dev/loop1          100M  100M     0 100% /snap/core/11993
/dev/loop3           56M   56M     0 100% /snap/core18/2128
/dev/loop0          100M  100M     0 100% /snap/core/11798
/dev/loop2           56M   56M     0 100% /snap/core18/2246
/dev/loop6           33M   33M     0 100% /snap/snapd/13270
/dev/loop4           62M   62M     0 100% /snap/core20/1081
/dev/loop5           62M   62M     0 100% /snap/core20/1169
/dev/loop7           71M   71M     0 100% /snap/lxd/21029
/dev/loop8           68M   68M     0 100% /snap/lxd/21545
/dev/loop9           33M   33M     0 100% /snap/snapd/13640
tmpfs               352M     0  352M   0% /run/user/996
new-pool            1.8T  128K  1.8T   1% /new-pool
new-pool/Scipio     1.8T  4.8G  1.8T   1% /new-pool/Scipio
new-pool/nextcloud  2.0T  164G  1.8T   9% /new-pool/nextcloud
new-pool/Parents    1.8T  128K  1.8T   1% /new-pool/Parents
new-pool/Home       1.9T   16G  1.8T   1% /new-pool/Home
new-pool/Highwind   2.5T  684G  1.8T  28% /new-pool/Highwind
tmpfs               352M     0  352M   0% /run/user/1000

It’s not btrfs so that won’t be relevant. I tired to google if I could clear that cache but I couldn’t find definitive info.