Medhit

Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by Medhit

  1. I've try and it was the wrong value, i dont' know why.... Then i run: SET GLOBAL binlog_format = 'MIXED'; FLUSH LOGS; UNLOCK TABLES; And now everything works fine, but i don't undersand why when I reboot the system it reset that value to "STATEMENT" (also try to put it on [galera] ) Is there any other config file to ceck?
  2. I've just reboot the server and now my nexcloud installation is broken.... Here is my error Dettagli tecnici Indirizzo remoto: 192.168.54.101 ID richiesta: yevT4A3V9moenE73Y7ec Tipo: Doctrine\DBAL\Exception\DriverException Codice: 0 Messaggio: An exception occurred while executing 'DELETE FROM `oc_authtoken` WHERE `token` = ?' with params ["4fe7541de86a17d9e336e7369019ae46ff62feb5e151437919955ddd1ece70293b0777d79d33bb0ab7ca6bd0b0d33fd16cc5e4c38e2a60819078fe34edaf4390"]: SQLSTATE[HY000]: General error: 1665 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. File: /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php Riga: 115 Traccia #0 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException)) #1 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1015): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'DELETE FROM `oc...', Array) #2 /config/www/nextcloud/lib/private/DB/Connection.php(216): Doctrine\DBAL\Connection->executeUpdate('DELETE FROM `oc...', Array, Array) #3 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): OC\DB\Connection->executeUpdate('DELETE FROM `oc...', Array, Array) #4 /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute() #5 /config/www/nextcloud/lib/private/Authentication/Token/DefaultTokenMapper.php(54): OC\DB\QueryBuilder\QueryBuilder->execute() #6 /config/www/nextcloud/lib/private/Authentication/Token/DefaultTokenProvider.php(259): OC\Authentication\Token\DefaultTokenMapper->invalidate('4fe7541de86a17d...') #7 /config/www/nextcloud/lib/private/User/Session.php(839): OC\Authentication\Token\DefaultTokenProvider->invalidateToken('bierg1ljuhglp09...') #8 /config/www/nextcloud/lib/private/User/Session.php(259): OC\User\Session->logout() #9 /config/www/nextcloud/lib/private/User/Session.php(232): OC\User\Session->validateSession() #10 /config/www/nextcloud/lib/private/legacy/app.php(336): OC\User\Session->getUser() #11 /config/www/nextcloud/lib/private/legacy/app.php(113): OC_App::getEnabledApps() #12 /config/www/nextcloud/lib/private/legacy/user.php(131): OC_App::loadApps(Array) #13 /config/www/nextcloud/lib/base.php(729): OC_User::setupBackends() #14 /config/www/nextcloud/lib/base.php(1081): OC::init() #15 /config/www/nextcloud/index.php(40): require_once('/config/www/nex...') #16 {main} I use mariaDb as sql docker and this is my custom.cnf ## custom configuration file, please be aware that changing options here may break things [mysqld_safe] nice = 0 [mysqld] max_connections = 100 connect_timeout = 50 wait_timeout = 600 max_allowed_packet = 32M thread_cache_size = 128 sort_buffer_size = 8M bulk_insert_buffer_size = 32M tmp_table_size = 64M max_heap_table_size = 64M binlog_format = mixed # # * MyISAM # # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched. On error, make copy and try a repair. myisam_recover_options = BACKUP key_buffer_size = 128M #open-files-limit = 2000 table_open_cache = 400 myisam_sort_buffer_size = 512M concurrent_insert = 2 read_buffer_size = 2M read_rnd_buffer_size = 1M # # * Query Cache Configuration # # Cache only tiny result sets, so we can fit more in the query cache. query_cache_limit = 128K query_cache_size = 64M # for more write intensive setups, set to DEMAND or OFF #query_cache_type = DEMAND # # * Logging and Replication # Does anyone have any idea what happened?