Error when using mariadb

ℹ️ Support
1

I Installed nextcloud in a shared webhosting
I cannot upload files bigger than 10MB when using mysql database. It throws “unkown error” without finishing uploading the file. When installing sqllite i have none problems. I have other apps in the hosting that use mysqldb without problem.
I installed several versions of nextcloud, 20, 19, 18 ,17 all of them with the same errors.
I dont know what to do to fix de error

2

Please provide DETAILED information about your installation, used software versions, Nextcloud configuration and any related Nextcloud error message which are logged when trying to use a MySQL database.

3

Thank You for your quick answer

This is the system server and there are so many errors in the log

Server configuration detail

Operating system: Linux 3.10.0-962.3.2.lve1.5.25.6.el7.x86_64 #1 SMP Thu Apr 18 06:40:26 EDT 2019 x86_64

Webserver: LiteSpeed (litespeed)

Database: mysql 10.4.14

PHP version: 7.3.20

Modules loaded: Core, date, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, gmp, SPL, iconv, pcntl, readline, Reflection, session, standard, shmop, SimpleXML, mbstring, tokenizer, xml, litespeed, bcmath, dom, fileinfo, gd, json, propro, raphf, http, imagick, imap, intl, exif, memcached, mysqlnd, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, soap, sockets, tidy, timezonedb, wddx, xmlreader, xmlrpc, xmlwriter, xsl, zip, ionCube Loader, Zend OPcache

Nextcloud version: 20.0.0 - 20.0.0.9

Updated from an older Nextcloud/ownCloud or fresh install:

Where did you install Nextcloud from: unknown

Signing status

Array ( )

List of activated apps 
Enabled:
 - accessibility: 1.6.0
 - activity: 2.13.1
 - bruteforcesettings: 2.0.1
 - cloud_federation_api: 1.3.0
 - comments: 1.10.0
 - contactsinteraction: 1.1.0
 - dashboard: 7.0.0
 - dav: 1.16.0
 - federatedfilesharing: 1.10.1
 - federation: 1.10.1
 - files: 1.15.0
 - files_pdfviewer: 2.0.1
 - files_rightclick: 0.17.0
 - files_sharing: 1.12.0
 - files_trashbin: 1.10.1
 - files_versions: 1.13.0
 - files_videoplayer: 1.9.0
 - firstrunwizard: 2.9.0
 - logreader: 2.5.0
 - lookup_server_connector: 1.8.0
 - nextcloud_announcements: 1.9.0
 - notifications: 2.8.0
 - oauth2: 1.8.0
 - password_policy: 1.10.1
 - photos: 1.2.0
 - privacy: 1.4.0
 - provisioning_api: 1.10.0
 - recommendations: 0.8.0
 - serverinfo: 1.10.0
 - settings: 1.2.0
 - sharebymail: 1.10.0
 - support: 1.3.0
 - survey_client: 1.8.0
 - systemtags: 1.10.0
 - text: 3.1.0
 - theming: 1.11.0
 - twofactor_backupcodes: 1.9.0
 - updatenotification: 1.10.0
 - user_status: 1.0.0
 - viewer: 1.4.0
 - weather_status: 1.0.0
 - workflowengine: 2.2.0
Disabled:
 - admin_audit
 - encryption
 - files_external
 - user_ldap
Configuration (config/config.php) 
{
    "instanceid": "***REMOVED SENSITIVE VALUE***",
    "passwordsalt": "***REMOVED SENSITIVE VALUE***",
    "secret": "***REMOVED SENSITIVE VALUE***",
    "trusted_domains": [
        "higseg.com.ar"
    ],
    "datadirectory": "***REMOVED SENSITIVE VALUE***",
    "dbtype": "mysql",
    "version": "20.0.0.9",
    "overwrite.cli.url": "https:\/\/higseg.com.ar\/cloud",
    "dbname": "***REMOVED SENSITIVE VALUE***",
    "dbhost": "***REMOVED SENSITIVE VALUE***",
    "dbport": "",
    "dbtableprefix": "oc_",
    "mysql.utf8mb4": true,
    "dbuser": "***REMOVED SENSITIVE VALUE***",
    "dbpassword": "***REMOVED SENSITIVE VALUE***",
    "installed": true
}

External storages: files_external is disabled

Encryption: no

User-backends:

  • OC\User\Database

Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36

Here there are a few errors (not all)

[PHP] Error: Error: shell_exec() has been disabled for security reasons at /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/serverinfo/lib/OperatingSystems/DefaultOs.php#134 at <>

  1. <>
    OC\Log\ErrorHandler::onError(2, “shell_exec() ha … s”, “/home/u33903089 … p”, 134, {servers: null})
  2. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/serverinfo/lib/OperatingSystems/DefaultOs.php line 134
    shell_exec("cat /etc/system … “”)
  3. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/serverinfo/lib/Os.php line 90
    OCA\ServerInfo\OperatingSystems\DefaultOs->getTimeServers()
  4. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/serverinfo/lib/Controller/ApiController.php line 118
    OCA\ServerInfo\Os->getTimeServers()
  5. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/AppFramework/Http/Dispatcher.php line 169
    OCA\ServerInfo\Controller\ApiController->BasicData()
  6. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/AppFramework/Http/Dispatcher.php line 100
    OC\AppFramework\Http\Dispatcher->executeController(OCA\ServerInfo\C … {}, “BasicData”)
  7. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/AppFramework/App.php line 152
    OC\AppFramework\Http\Dispatcher->dispatch(OCA\ServerInfo\C … {}, “BasicData”)
  8. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Route/Router.php line 308
    OC\AppFramework\App::main(“OCA\ServerInfo … r”, “BasicData”, OC\AppFramework\ … {}, {action: null,_r … "})
  9. /home/u339030895/domains/higseg.com.ar/public_html/cloud/ocs/v1.php line 88
    OC\Route\Router->match("/ocsapp/apps/se … a")
  10. /home/u339030895/domains/higseg.com.ar/public_html/cloud/ocs/v2.php line 24
    require_once("/home/u33903089 … p")

GET /cloud/ocs/v2.php/apps/serverinfo/api/v1//basicdata?format=json
from 190.7.50.124 by admin at 2020-10-06T20:56:08+00:00

[PHP] Error: Error: Cannot modify header information - headers already sent by (output started at /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/http/lib/Sapi.php:132) at /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php#691 at <>

  1. <>
    OC\Log\ErrorHandler::onError(2, “Cannot modify h … )”, “/home/u33903089 … p”, 691, {string: "X-Hash-MD5: "})
  2. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php line 691
    header("X-Hash-MD5: ")
  3. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php line 189
    OCA\DAV\Connector\Sabre\File->header("X-Hash-MD5: ")
  4. <>
    OCA\DAV\Connector\Sabre\File->OCA\DAV\Connector\Sabre{closure}("*** sensitive parameters replaced ***")
  5. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 71
    call_user_func(Closure {}, “*** sensitive parameter replaced ***”)
  6. <>
    OC\Files\Stream\HashWrapper->stream_close()
  7. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/icewind/streams/src/Wrapper.php line 132
    fclose(null)
  8. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 75
    Icewind\Streams\Wrapper->stream_close()
  9. <>
    OC\Files\Stream\HashWrapper->stream_close()
  10. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/icewind/streams/src/Wrapper.php line 132
    fclose(null)
  11. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 75
    Icewind\Streams\Wrapper->stream_close()
  12. <>
    OC\Files\Stream\HashWrapper->stream_close()

PUT /cloud/remote.php/dav/uploads/admin/web-file-upload-4bdfe25f43aa0865b5c60f141341a357-1601778222944/0
from 190.7.50.124 by admin at 2020-10-04T02:24:03+00:00

[PHP] Error: Error: hash_final(): supplied resource is not a valid Hash Context resource at /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php#71 at <>

  1. <>
    OC\Log\ErrorHandler::onError(2, “hash_final(): s … e”, “/home/u33903089 … p”, 71, [])
  2. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 71
    hash_final(HashContext {})
  3. <>
    OC\Files\Stream\HashWrapper->stream_close()
  4. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/icewind/streams/src/Wrapper.php line 132
    fclose(null)
  5. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 75
    Icewind\Streams\Wrapper->stream_close()
  6. <>
    OC\Files\Stream\HashWrapper->stream_close()
  7. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/icewind/streams/src/Wrapper.php line 132
    fclose(null)
  8. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Stream/HashWrapper.php line 75
    Icewind\Streams\Wrapper->stream_close()
  9. <>
    OC\Files\Stream\HashWrapper->stream_close()

PUT /cloud/remote.php/dav/uploads/admin/web-file-upload-4bdfe25f43aa0865b5c60f141341a357-1601778222944/0
from 190.7.50.124 by admin at 2020-10-04T02:24:03+00:00

[webdav] Fatal: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT fileid FROM oc_filecache WHERE (storage = ?) AND (path_hash = ?)’ with params [2, “162830e95b59626ee503c193b0f2f390”]:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at <>

  1. /home/u339030895/domains/higseg.com.ar/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 … ]})
  2. /home/u339030895/domains/higseg.com.ar/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”)
  3. /home/u339030895/domains/higseg.com.ar/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 fileid … )”, {1: 2,2: "162830 … "})
  4. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/DB/Connection.php line 194
    Doctrine\DBAL\Connection->executeQuery(“SELECT fileid … )”, [2,“162830e95b59626ee503c193b0f2f390”], [1,2], null)
  5. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 206
    OC\DB\Connection->executeQuery(“SELECT fileid … )”, {dcValue1: 2,dcV … "}, {dcValue1: 1,dcValue2: 2})
  6. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 217
    Doctrine\DBAL\Query\QueryBuilder->execute()
  7. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Cache.php line 470
    OC\DB\QueryBuilder\QueryBuilder->execute()
  8. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Cache.php line 485
    OC\Files\Cache\Cache->getId(“uploads/web-fil … 4”)
  9. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Scanner.php line 177
    OC\Files\Cache\Cache->getParentId("*** sensitive parameter replaced ***")
  10. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Scanner.php line 338
    OC\Files\Cache\Scanner->scanFile("*** sensitive parameter replaced ***", 3, -1, null, false)
  11. /home/u339030895/domains/higseg.com.ar/public_html/cloud/lib/private/Files/Cache/Updater.php line 126
    OC\Files\Cache\Scanner->scan("*** sensitive parameter replaced ***", false, 3, false)
  12. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/File.php line 310
    OC\Files\Cache\Updater->update("*** sensitive parameters replaced ***")
  13. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Connector/Sabre/Directory.php line 155
    OCA\DAV\Connector\Sabre\File->put(null)
  14. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Upload/UploadFolder.php line 46
    OCA\DAV\Connector\Sabre\Directory->createFile(“0”, null)
  15. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 1104
    OCA\DAV\Upload\UploadFolder->createFile(“0”, null)
  16. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 527
    Sabre\DAV\Server->createFile(“uploads/admin/w … 0”, null, null)
  17. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
    Sabre\DAV\CorePlugin->httpPut(Sabre\HTTP\Request {}, Sabre\HTTP\Response {})
  18. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 474
    Sabre\DAV\Server->emit(“method:PUT”, [Sabre\HTTP\Requ … }])
  19. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 251
    Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Request {}, Sabre\HTTP\Response {})
  20. /home/u339030895/domains/higseg.com.ar/public_html/cloud/3rdparty/sabre/dav/lib/DAV/Server.php line 319
    Sabre\DAV\Server->start()
  21. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/lib/Server.php line 325
    Sabre\DAV\Server->exec()
  22. /home/u339030895/domains/higseg.com.ar/public_html/cloud/apps/dav/appinfo/v2/remote.php line 35
    OCA\DAV\Server->exec()
  23. /home/u339030895/domains/higseg.com.ar/public_html/cloud/remote.php line 167
    require_once("/home/u33903089 … p")

PUT /cloud/remote.php/dav/uploads/admin/web-file-upload-4bdfe25f43aa0865b5c60f141341a357-1601778222944/0
from 190.7.50.124 by admin at 2020-10-04T02:24:03+00:00