Internal Server Error The server was unable to complete your request - max_binlog_cache_size

Nextcloud version Nextcloud Hub 8 (29.0.4)
Operating system and version: Installation via webhost (allinkl)
Apache or nginx version (eg, Apache 2.4.25): apache - unknown version (not viewable in hoster backend)
PHP version (eg, 8.3): 8.3.8-nmm1
MariaDB-Version: 10.6.18

The issue you are facing:

main user login times out.

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

Steps to replicate it:

  1. try to login as main user
  2. wait
  3. login times out with error message " [Internal Server Error The server was unable to complete your request. If this happens again, please send the technical details below to the server administrator. More details can be found in the server log"

The output of your Nextcloud log in Admin > Logging:

[index] Fehler: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1197 Multi-statement transaction required more than ‘max_binlog_cache_size’ bytes of storage; increase this mariadbd variable and try again
POST /nextcloud/index.php/login
von IP.xxx.xxx.xxx von user.name um 26.07.2024, 07:46:21

[no app in context] Warnung: Temporary directory /www/htdocs/foldername/domainfolder/nextcloud/tmp/ is not present or writable
GET /nextcloud/index.php/apps/logreader/api/log?offset=110&query=
von IP.xxx.xxx.xxx von nc-admin um 26.07.2024, 07:55:31

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

PASTE HERE

The output of your Apache/nginx/system log in /var/log/____:

PASTE HERE

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

  GNU nano 6.2                                                                                                                                             config.php                                                                                                                                                       
<?php
$CONFIG = array (
  'instanceid' => 'something',
  'passwordsalt' => 'something',
  'secret' => 'something',
  'trusted_domains' => 
  array (
    0 => 'mydomain.de',
    1 => 'www.mydomain.de',
  ),
  'datadirectory' => '/www/htdocs/foldername/domainfolder/nextcloud/data',
  'overwrite.cli.url' => 'http://mydomain.de/nextcloud',
  'dbtype' => 'mysql',
  'version' => '29.0.4.1',
  'dbname' => 'db-name',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'Q0yAx_',
  'mysql.utf8mb4' => false,
  'dbuser' => 'db-name',
  'dbpassword' => 'db-password',
  'installed' => true,
  'tempdirectory' => '/www/htdocs/foldername/domainfolder/nextcloud/tmp/',
  'mail_smtpmode' => 'smtp',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpsecure' => 'tls',
  'mail_from_address' => 'mailadress',
  'mail_domain' => 'mydomain.com',
  'mail_smtpauth' => 1,
  'mail_smtphost' => 'name.kasserver.com',
  'mail_smtpname' => 'smtp-name',
  'mail_smtppassword' => 'smtp-pw',
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'updater.release.channel' => 'stable',
  'updater.secret' => 'something',
  'encryption.legacy_format_support' => false,
  'encryption.key_storage_migrated' => false,
  'app_install_overwrite' => 
  array (
    0 => 'integration_suitecrm',
  ),
  'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
);

Copying the details of the error from the log gives 2 errors regarding the info given in the technical details:

{"reqId":"ZqM559IsQOxIpoJdVeGT_QAAnBs","level":2,"time":"2024-07-26T05:53:43+00:00","remoteAddr":"IP.xxx.xxx.xxx","user":"--","app":"no app in context","method":"POST","url":"/nextcloud/index.php/login","message":"Temporary directory /www/htdocs/foldername/domainfolder/nextcloud/tmp/ is not present or writable","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0","version":"29.0.4.1","data":[]}

{"reqId":"ZqM559IsQOxIpoJdVeGT_QAAnBs","level":3,"time":"2024-07-26T05:55:30+00:00","remoteAddr":"IP.xxx.xxx.xxx","user":"user.name","app":"index","method":"POST","url":"/nextcloud/index.php/login","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mariadbd variable and try again","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0","version":"29.0.4.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mariadbd variable and try again","Code":1197,"Trace":[{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":328,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[["Doctrine\\DBAL\\Exception\\DriverException"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenMapper.php","line":249,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","line":559,"function":"updateHashesForUser","class":"OC\\Authentication\\Token\\PublicKeyTokenMapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OC\\Authentication\\Token\\{closure}","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","line":561,"function":"atomic","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/Manager.php","line":249,"function":"updatePasswords","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Listeners/UserLoggedInListener.php","line":60,"function":"updatePasswords","class":"OC\\Authentication\\Token\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OC\\Authentication\\Listeners\\UserLoggedInListener","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"],"OCP\\User\\Events\\PostLoginEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"]],"OCP\\User\\Events\\PostLoginEvent",["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":86,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"],"OCP\\User\\Events\\PostLoginEvent"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":98,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\User\\Events\\PostLoginEvent",["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/User/Session.php","line":375,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/CompleteLoginCommand.php","line":43,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\CompleteLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/LoggedInCheckCommand.php","line":60,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\LoggedInCheckCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/EmailLoginCommand.php","line":68,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\EmailLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/UidLoginCommand.php","line":53,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\UidLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/UserDisabledCheckCommand.php","line":57,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\UserDisabledCheckCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/PreLoginHookCommand.php","line":52,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/Chain.php","line":107,"function":"process","class":"OC\\Authentication\\Login\\PreLoginHookCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/core/Controller/LoginController.php","line":352,"function":"process","class":"OC\\Authentication\\Login\\Chain","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"tryLogin","class":"OC\\Core\\Controller\\LoginController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\LoginController"],"tryLogin"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\LoginController"],"tryLogin"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\LoginController","tryLogin",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["core.login.trylogin"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/login"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/Exceptions/DbalException.php","Line":71,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mariadbd variable and try again","Code":1197,"Trace":[{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1943,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1885,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\
Query"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1213,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"UPDATE `Q0yAx_authtoken` SET `password_hash` = ? WHERE `uid` = ?",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `Q0yAx_authtoken` SET `password_hash` = ? WHERE `uid` = ?",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/Connection.php","line":373,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["UPDATE `Q0yAx_authtoken` SET `password_hash` = :dcValue1 WHERE `uid` = :dcValue2",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":393,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `Q0yAx_authtoken` SET `password_hash` = :dcValue1 WHERE `uid` = :dcValue2",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenMapper.php","line":249,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","line":559,"function":"updateHashesForUser","class":"OC\\Authentication\\Token\\PublicKeyTokenMapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OC\\Authentication\\Token\\{closure}","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","line":561,"function":"atomic","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/Manager.php","line":249,"function":"updatePasswords","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Listeners/UserLoggedInListener.php","line":60,"function":"updatePasswords","class":"OC\\Authentication\\Token\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OC\\Authentication\\Listeners\\UserLoggedInListener","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"],"OCP\\User\\Events\\PostLoginEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"]],"OCP\\User\\Events\\PostLoginEvent",["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":86,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"],"OCP\\User\\Events\\PostLoginEvent"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":98,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\User\\Events\\PostLoginEvent",["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/User/Session.php","line":375,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/CompleteLoginCommand.php","line":43,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\CompleteLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/LoggedInCheckCommand.php","line":60,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\LoggedInCheckCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/EmailLoginCommand.php","line":68,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\EmailLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/UidLoginCommand.php","line":53,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\UidLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/UserDisabledCheckCommand.php","line":57,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\UserDisabledCheckCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/PreLoginHookCommand.php","line":52,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/Chain.php","line":107,"function":"process","class":"OC\\Authentication\\Login\\PreLoginHookCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/core/Controller/LoginController.php","line":352,"function":"process","class":"OC\\Authentication\\Login\\Chain","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"tryLogin","class":"OC\\Core\\Controller\\LoginController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\LoginController"],"tryLogin"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\LoginController"],"tryLogin"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\LoginController","tryLogin",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["core.login.trylogin"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/login"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":117,"
Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[HY000]: General error: 1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mariadbd variable and try again","Code":1197,"Trace":[{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[["PDOException",["HY000",1197,"Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mariadbd variable and try again"]]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1207,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `Q0yAx_authtoken` SET `password_hash` = ? WHERE `uid` = ?",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/Connection.php","line":373,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["UPDATE `Q0yAx_authtoken` SET `password_hash` = :dcValue1 WHERE `uid` = :dcValue2",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":393,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `Q0yAx_authtoken` SET `password_hash` = :dcValue1 WHERE `uid` = :dcValue2",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenMapper.php","line":249,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","line":559,"function":"updateHashesForUser","class":"OC\\Authentication\\Token\\PublicKeyTokenMapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OC\\Authentication\\Token\\{closure}","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","line":561,"function":"atomic","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/Manager.php","line":249,"function":"updatePasswords","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Listeners/UserLoggedInListener.php","line":60,"function":"updatePasswords","class":"OC\\Authentication\\Token\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OC\\Authentication\\Listeners\\UserLoggedInListener","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"],"OCP\\User\\Events\\PostLoginEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"]],"OCP\\User\\Events\\PostLoginEvent",["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":86,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"],"OCP\\User\\Events\\PostLoginEvent"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":98,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\User\\Events\\PostLoginEvent",["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/User/Session.php","line":375,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/CompleteLoginCommand.php","line":43,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\CompleteLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/LoggedInCheckCommand.php","line":60,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\LoggedInCheckCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/EmailLoginCommand.php","line":68,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\EmailLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/UidLoginCommand.php","line":53,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\UidLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/UserDisabledCheckCommand.php","line":57,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\UserDisabledCheckCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/PreLoginHookCommand.php","line":52,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/Chain.php","line":107,"function":"process","class":"OC\\Authentication\\Login\\PreLoginHookCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/core/Controller/LoginController.php","line":352,"function":"process","class":"OC\\Authentication\\Login\\Chain","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"tryLogin","class":"OC\\Core\\Controller\\LoginController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\LoginController"],"tryLogin"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\LoginController"],"tryLogin"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\LoginController","tryLogin",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["core.login.trylogin"]]},{
"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/login"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[HY000]: General error: 1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mariadbd variable and try again","Code":"HY000","Trace":[{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1207,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php","line":292,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `Q0yAx_authtoken` SET `password_hash` = ? WHERE `uid` = ?",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/Connection.php","line":373,"function":"executeStatement","class":"Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection","type":"->","args":["UPDATE `Q0yAx_authtoken` SET `password_hash` = :dcValue1 WHERE `uid` = :dcValue2",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":393,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `Q0yAx_authtoken` SET `password_hash` = :dcValue1 WHERE `uid` = :dcValue2",["*** sensitive parameters replaced ***","*** sensitive parameters replaced ***"],[2,2]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenMapper.php","line":249,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","line":559,"function":"updateHashesForUser","class":"OC\\Authentication\\Token\\PublicKeyTokenMapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/public/AppFramework/Db/TTransactional.php","line":63,"function":"OC\\Authentication\\Token\\{closure}","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/PublicKeyTokenProvider.php","line":561,"function":"atomic","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":[["Closure"],["OC\\DB\\ConnectionAdapter"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Token/Manager.php","line":249,"function":"updatePasswords","class":"OC\\Authentication\\Token\\PublicKeyTokenProvider","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Listeners/UserLoggedInListener.php","line":60,"function":"updatePasswords","class":"OC\\Authentication\\Token\\Manager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OC\\Authentication\\Listeners\\UserLoggedInListener","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":230,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"],"OCP\\User\\Events\\PostLoginEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":59,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"]],"OCP\\User\\Events\\PostLoginEvent",["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":86,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"],"OCP\\User\\Events\\PostLoginEvent"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":98,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\User\\Events\\PostLoginEvent",["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/User/Session.php","line":375,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\PostLoginEvent"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/CompleteLoginCommand.php","line":43,"function":"completeLogin","class":"OC\\User\\Session","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\CompleteLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/LoggedInCheckCommand.php","line":60,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\LoggedInCheckCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/EmailLoginCommand.php","line":68,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\EmailLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/UidLoginCommand.php","line":53,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\UidLoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/UserDisabledCheckCommand.php","line":57,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/ALoginCommand.php","line":39,"function":"process","class":"OC\\Authentication\\Login\\UserDisabledCheckCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/PreLoginHookCommand.php","line":52,"function":"processNextOrFinishSuccessfully","class":"OC\\Authentication\\Login\\ALoginCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/Authentication/Login/Chain.php","line":107,"function":"process","class":"OC\\Authentication\\Login\\PreLoginHookCommand","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/core/Controller/LoginController.php","line":352,"function":"process","class":"OC\\Authentication\\Login\\Chain","type":"->","args":[["OC\\Authentication\\Login\\LoginData"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"tryLogin","class":"OC\\Core\\Controller\\LoginController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\LoginController"],"tryLogin"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\LoginController"],"tryLogin"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/private/
Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\LoginController","tryLogin",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["core.login.trylogin"]]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/login"]},{"file":"/www/htdocs/foldername/domainfolder/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/www/htdocs/foldername/domainfolder/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}}},"message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mariadbd variable and try again","exception":{},"CustomMessage":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1197 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mariadbd variable and try again"}}

I searched a little for this error - but all i could come up with how to ask for sql info via phpmyadmin:

select @@binlog_cache_size, @@max_binlog_cache_size, @@binlog_format;

@@binlog_cache_size 	@@max_binlog_cache_size 	@@binlog_format
32768 	4294967296 	MIXED

I can not increase/change that values as Super Rights are needed - which i do not have on my webhost solution.

Based on value you have here, you may be on a 32-bit platform, which has a much lower default (and maximum) default for this parameter.

Wild guess based on the area of code where this is occurring for you: You may have a lot of auth tokens / sessions. Normally you could check this under Personal->Security but since you can’t log-in… you can use occ user:auth-tokens:list USERNAME to see them.

I coulndt find any info about the platforum type - as said it is a webhoster where i installed nextcloud via php - so i can only influence some settings via the webhost backend (php-version etc.)

I dont know about the average amount - but the occ command gives a list of about 1000 tokens - which almost all of them looking like:
212009 | Mozilla/5.0 | 2021-06-21T11:16:03+00:00 | temporary | filesystem

I have to check that - i found another thread regarding this that shows this may be a result of a bad cron job .

Right. Since you can’t adjust the parameter, I would clear out those sessions. I suspect that will reduce the transaction size and workaround your situation.

Re: cron. It’s possible those sessions aren’t getting cleared out. I don’t recall offhand the clean-up handling for old sessions.