[[Support] Linuxserver.io - Nextcloud]

On 8/2/2018 at 8:10 PM, Gog said:

 

From your logs:  impossible to write to binary log since BINLOG_FORMAT = STATEMENT

 

But that should not happen since you set binlog_format=mixed

 

I don't know why but in my config, that variable is under the [galera] section.  I think I just uncommented there but the default config has it in [mysqld] like you.

 

In any case, can you run the sql command "show variables like 'binlog_format'" on the DB, it will print the actual value of the parameter.

 

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?

[[Support] Linuxserver.io - Nextcloud]

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?