Hello. I’ve recently installed Nextcloud appliance on shared webhosting (Hostinger) and I’m having some troubles with it.
When I’m trying to upload any files larger than 60 MB via web interface or client, I get 500 Server Internal error.
Nextcloud logs here: {"reqId":"v8mDV5g8XcdtbYL9uSpb","level":3,"time":"2023-05-26T07:11:57+00:00","re - Pastebin.com
Since this is shared hosting I don’t have access to PHP config directly, however .htaccess seems to work: <IfModule mod_headers.c> <IfModule mod_setenvif.c> <IfModule mod_fcgid.c - Pastebin.com
I’ve previously had running Nextcloud on my own servers and never had such problems, so any help would be much appreciated. Thanks!
Edit: It seems like every time it fails, error of this type generated:
[no app in context] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT filecache
.fileid
, storage
, path
, path_hash
, filecache
.parent
, name
, mimetype
, mimepart
, size
, mtime
, storage_mtime
, encrypted
, etag
, permissions
, checksum
, metadata_etag
, creation_time
, upload_time
FROM d7xu_filecache
filecache
LEFT JOIN d7xu_filecache_extended
fe
ON filecache
.fileid
= fe
.fileid
WHERE (storage
= ?) AND (path_hash
= ?)’ with params [3, “45b963397aa40d4a0063e0d85e4fe7a1”]:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at <>
- /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(“An exception oc … y”, Doctrine\DBAL\Dr … ]}) - /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 149
Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “An exception oc … y”) - /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 914
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr … ]}, “SELECT `filecac … )”, {1: 3,2: "45b963 … "}) - /home/u254953274/domains/nabeg.in/public_html/cloud/lib/private/DB/Connection.php line 202
Doctrine\DBAL\Connection->executeQuery(“SELECT `filecac … )”, [3,“45b963397aa40d4a0063e0d85e4fe7a1”], [1,2], null) - /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 206
OC\DB\Connection->executeQuery(“SELECT `filecac … )”, {dcValue1: 3,dcV … "}, {dcValue1: 1,dcValue2: 2}) - /home/u254953274/domains/nabeg.in/public_html/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 217
Doctrine\DBAL\Query\QueryBuilder->execute() - /home/u254953274/domains/nabeg.in/public_html/cloud/lib/private/Files/Cache/Cache.php line 154
OC\DB\QueryBuilder\QueryBuilder->execute() - /home/u254953274/domains/nabeg.in/public_html/cloud/lib/private/Files/Cache/HomeCache.php line 85
OC\Files\Cache\Cache->get(“files”) - /home/u254953274/domains/nabeg.in/public_html/cloud/lib/private/Files/View.php line 1334
OC\Files\Cache\HomeCache->get(“files”) - /home/u254953274/domains/nabeg.in/public_html/cloud/lib/private/Files/View.php line 1389
OC\Files\View->getCacheEntry(OCA\Files_Trashb … l}, “files”, null) - /home/u254953274/domains/nabeg.in/public_html/cloud/lib/private/Files/Node/HookConnector.php line 228
OC\Files\View->getFileInfo(“/obrjadindusov/files”) - /home/u254953274/domains/nabeg.in/public_html/cloud/lib/private/Files/Node/HookConnector.php line 105
OC\Files\Node\HookConnector->getNodeForPath(null) - /home/u254953274/domains/nabeg.in/public_html/cloud/lib/private/legacy/OC_Hook.php line 110
OC\Files\Node\HookConnector->write({path: null,run: true}) - /home/u254953274/domains/nabeg.in/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php line 392
OC_Hook::emit(“OC_Filesystem”, “write”, {path: null,run: true}) - /home/u254953274/domains/nabeg.in/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php line 265
OCA\DAV\Connector\Sabre\File->emitPreHooks(false) - /home/u254953274/domains/nabeg.in/public_html/cloud/apps/dav/lib/Connector/Sabre/Directory.php line 156
OCA\DAV\Connector\Sabre\File->put(null) - /home/u254953274/domains/nabeg.in/public_html/cloud/apps/dav/lib/Upload/UploadFolder.php line 46
OCA\DAV\Connector\Sabre\Directory->createFile(“0000000000000000”, null) - /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 1104
OCA\DAV\Upload\UploadFolder->createFile(“0000000000000000”, null) - /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 527
Sabre\DAV\Server->createFile(“uploads/obrjadi … 0”, null, null) - /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
Sabre\DAV\CorePlugin->httpPut(Sabre\HTTP\Request {}, Sabre\HTTP\Response {}) - /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 474
Sabre\DAV\Server->emit(“method:PUT”, [Sabre\HTTP\Requ … }]) - /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 251
Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Request {}, Sabre\HTTP\Response {}) - /home/u254953274/domains/nabeg.in/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 319
Sabre\DAV\Server->start() - /home/u254953274/domains/nabeg.in/public_html/cloud/apps/dav/lib/Server.php line 332
Sabre\DAV\Server->exec() - /home/u254953274/domains/nabeg.in/public_html/cloud/apps/dav/appinfo/v2/remote.php line 35
OCA\DAV\Server->exec() - /home/u254953274/domains/nabeg.in/public_html/cloud/remote.php line 167
require_once(“/home/u25495327 … p”)
PUT /remote.php/dav/uploads/obrjadindusov/2391405875/0000000000000000
from 217.15.201.133 by obrjadindusov at 2023-05-26T08:59:34+00:00
If I understand correctly, error implies that MySQL server has crashed, but I don’t think that is entirely true because after this error Nextcloud instance continue to work and even able to upload files. Really confused by this behavior.