Nextcloud MySQL Error の履歴(No.1)

履歴一覧
差分を表示
現在との差分を表示
ソースを表示
Nextcloud MySQL Error へ行く。
- 1 (2019-02-13 (水) 03:15:15)
CONTENTS
Nextcloud MySQL Error
Lastmodified　2019-02-13 (水) 03:48:31
Nextcloud MySQL Error†

Starting mysql.
Warning: Using a password on the command line interface can be insecure.
Looking for 'mysql' as: /usr/local/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/bin/mysqlcheck
This installation of MySQL is already upgraded to 5.6.43, use --force if you still need to run mysql_upgrade
An unhandled exception has been thrown:
PDOException: 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. in /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
Stack trace:
#0 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOStatement->execute(NULL)
#1 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1006): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /usr/local/www/nextcloud/lib/private/DB/Connection.php(216): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)
#3 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): OC\DB\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)
#4 /usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /usr/local/www/nextcloud/lib/private/Lock/DBLockingProvider.php(144): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /usr/local/www/nextcloud/lib/private/Lock/DBLockingProvider.php(207): OC\Lock\DBLockingProvider->initLockField('files/fe49696f2...', -1)
#7 /usr/local/www/nextcloud/lib/private/Files/Storage/Common.php(714): OC\Lock\DBLockingProvider->acquireLock('files/fe49696f2...', 2)
#8 /usr/local/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php(593): OC\Files\Storage\Common->acquireLock('scanner::appdat...', 2, Object(OC\Lock\DBLockingProvider))
#9 /usr/local/www/nextcloud/lib/private/Files/Cache/Scanner.php(331): OC\Files\Storage\Wrapper\Wrapper->acquireLock('scanner::appdat...', 2, Object(OC\Lock\DBLockingProvider))
#10 /usr/local/www/nextcloud/lib/private/Files/View.php(1324): OC\Files\Cache\Scanner->scan('appdata_oci90hz...', false)
#11 /usr/local/www/nextcloud/lib/private/Files/View.php(1368): OC\Files\View->getCacheEntry(Object(OCA\Files_Trashbin\Storage), 'appdata_oci90hz...', '/appdata_oci90h...')
#12 /usr/local/www/nextcloud/lib/private/Files/Node/Root.php(198): OC\Files\View->getFileInfo('/appdata_oci90h...')
#13 [internal function]: OC\Files\Node\Root->get('/appdata_oci90h...')
#14 /usr/local/www/nextcloud/lib/private/Files/Node/LazyRoot.php(64): call_user_func_array(Array, Array)
#15 /usr/local/www/nextcloud/lib/private/Files/Node/LazyRoot.php(141): OC\Files\Node\LazyRoot->__call('get', Array)
#16 /usr/local/www/nextcloud/lib/private/Files/AppData/AppData.php(81): OC\Files\Node\LazyRoot->get('appdata_oci90hz...')
#17 /usr/local/www/nextcloud/lib/private/Files/AppData/AppData.php(107): OC\Files\AppData\AppData->getAppDataFolder()
#18 /usr/local/www/nextcloud/lib/private/Template/IconsCacher.php(78): OC\Files\AppData\AppData->getFolder('icons')
#19 [internal function]: OC\Template\IconsCacher->__construct(Object(OC\Log), Object(OC\Files\AppData\Factory), Object(OC\URLGenerator), Object(OC\AppFramework\Utility\TimeFactory))
#20 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(81): ReflectionClass->newInstanceArgs(Array)
#21 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#22 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Template\\Ico...')
#23 /usr/local/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Template\\Ico...')
#24 /usr/local/www/nextcloud/lib/private/Server.php(980): OC\ServerContainer->query('OC\\Template\\Ico...')
#25 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#26 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('OC\\Template\\SCS...')
#27 /usr/local/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Template\\SCS...')
#28 /usr/local/www/nextcloud/lib/private/Repair.php(145): OC\ServerContainer->query('OC\\Template\\SCS...')
#29 /usr/local/www/nextcloud/core/register_command.php(143): OC\Repair::getRepairSteps()
#30 /usr/local/www/nextcloud/lib/private/Console/Application.php(118): require_once('/usr/local/www/...')
#31 /usr/local/www/nextcloud/console.php(95): OC\Console\Application->loadCommands(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#32 /usr/local/www/nextcloud/occ(11): require_once('/usr/local/www/...')
#33 {main}

Next Doctrine\DBAL\Driver\PDOException: 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. in /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107
Stack trace:
#0 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1006): Doctrine\DBAL\Driver\PDOStatement->execute()
#1 /usr/local/www/nextcloud/lib/private/DB/Connection.php(216): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)
#2 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): OC\DB\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)
#3 /usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /usr/local/www/nextcloud/lib/private/Lock/DBLockingProvider.php(144): OC\DB\QueryBuilder\QueryBuilder->execute()
#5 /usr/local/www/nextcloud/lib/private/Lock/DBLockingProvider.php(207): OC\Lock\DBLockingProvider->initLockField('files/fe49696f2...', -1)
#6 /usr/local/www/nextcloud/lib/private/Files/Storage/Common.php(714): OC\Lock\DBLockingProvider->acquireLock('files/fe49696f2...', 2)
#7 /usr/local/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php(593): OC\Files\Storage\Common->acquireLock('scanner::appdat...', 2, Object(OC\Lock\DBLockingProvider))
#8 /usr/local/www/nextcloud/lib/private/Files/Cache/Scanner.php(331): OC\Files\Storage\Wrapper\Wrapper->acquireLock('scanner::appdat...', 2, Object(OC\Lock\DBLockingProvider))
#9 /usr/local/www/nextcloud/lib/private/Files/View.php(1324): OC\Files\Cache\Scanner->scan('appdata_oci90hz...', false)
#10 /usr/local/www/nextcloud/lib/private/Files/View.php(1368): OC\Files\View->getCacheEntry(Object(OCA\Files_Trashbin\Storage), 'appdata_oci90hz...', '/appdata_oci90h...')
#11 /usr/local/www/nextcloud/lib/private/Files/Node/Root.php(198): OC\Files\View->getFileInfo('/appdata_oci90h...')
#12 [internal function]: OC\Files\Node\Root->get('/appdata_oci90h...')
#13 /usr/local/www/nextcloud/lib/private/Files/Node/LazyRoot.php(64): call_user_func_array(Array, Array)
#14 /usr/local/www/nextcloud/lib/private/Files/Node/LazyRoot.php(141): OC\Files\Node\LazyRoot->__call('get', Array)
#15 /usr/local/www/nextcloud/lib/private/Files/AppData/AppData.php(81): OC\Files\Node\LazyRoot->get('appdata_oci90hz...')
#16 /usr/local/www/nextcloud/lib/private/Files/AppData/AppData.php(107): OC\Files\AppData\AppData->getAppDataFolder()
#17 /usr/local/www/nextcloud/lib/private/Template/IconsCacher.php(78): OC\Files\AppData\AppData->getFolder('icons')
#18 [internal function]: OC\Template\IconsCacher->__construct(Object(OC\Log), Object(OC\Files\AppData\Factory), Object(OC\URLGenerator), Object(OC\AppFramework\Utility\TimeFactory))
#19 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(81): ReflectionClass->newInstanceArgs(Array)
#20 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#21 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Template\\Ico...')
#22 /usr/local/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Template\\Ico...')
#23 /usr/local/www/nextcloud/lib/private/Server.php(980): OC\ServerContainer->query('OC\\Template\\Ico...')
#24 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#25 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('OC\\Template\\SCS...')
#26 /usr/local/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Template\\SCS...')
#27 /usr/local/www/nextcloud/lib/private/Repair.php(145): OC\ServerContainer->query('OC\\Template\\SCS...')
#28 /usr/local/www/nextcloud/core/register_command.php(143): OC\Repair::getRepairSteps()
#29 /usr/local/www/nextcloud/lib/private/Console/Application.php(118): require_once('/usr/local/www/...')
#30 /usr/local/www/nextcloud/console.php(95): OC\Console\Application->loadCommands(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#31 /usr/local/www/nextcloud/occ(11): require_once('/usr/local/www/...')
#32 {main}

Next Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_file_locks` (`key`, `lock`, `ttl`) VALUES(?, ?, ?)' with params ["files\/fe49696f2583cd0bda588f1f14c4c186", -1, 1549998574]:

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. in /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
Stack trace:
#0 /usr/local/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 /usr/local/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), 'INSERT INTO `oc...', Array)
#2 /usr/local/www/nextcloud/lib/private/DB/Connection.php(216): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)
#3 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): OC\DB\Connection->executeUpdate('INSERT INTO `oc...', Array, Array)
#4 /usr/local/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /usr/local/www/nextcloud/lib/private/Lock/DBLockingProvider.php(144): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /usr/local/www/nextcloud/lib/private/Lock/DBLockingProvider.php(207): OC\Lock\DBLockingProvider->initLockField('files/fe49696f2...', -1)
#7 /usr/local/www/nextcloud/lib/private/Files/Storage/Common.php(714): OC\Lock\DBLockingProvider->acquireLock('files/fe49696f2...', 2)
#8 /usr/local/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php(593): OC\Files\Storage\Common->acquireLock('scanner::appdat...', 2, Object(OC\Lock\DBLockingProvider))
#9 /usr/local/www/nextcloud/lib/private/Files/Cache/Scanner.php(331): OC\Files\Storage\Wrapper\Wrapper->acquireLock('scanner::appdat...', 2, Object(OC\Lock\DBLockingProvider))
#10 /usr/local/www/nextcloud/lib/private/Files/View.php(1324): OC\Files\Cache\Scanner->scan('appdata_oci90hz...', false)
#11 /usr/local/www/nextcloud/lib/private/Files/View.php(1368): OC\Files\View->getCacheEntry(Object(OCA\Files_Trashbin\Storage), 'appdata_oci90hz...', '/appdata_oci90h...')
#12 /usr/local/www/nextcloud/lib/private/Files/Node/Root.php(198): OC\Files\View->getFileInfo('/appdata_oci90h...')
#13 [internal function]: OC\Files\Node\Root->get('/appdata_oci90h...')
#14 /usr/local/www/nextcloud/lib/private/Files/Node/LazyRoot.php(64): call_user_func_array(Array, Array)
#15 /usr/local/www/nextcloud/lib/private/Files/Node/LazyRoot.php(141): OC\Files\Node\LazyRoot->__call('get', Array)
#16 /usr/local/www/nextcloud/lib/private/Files/AppData/AppData.php(81): OC\Files\Node\LazyRoot->get('appdata_oci90hz...')
#17 /usr/local/www/nextcloud/lib/private/Files/AppData/AppData.php(107): OC\Files\AppData\AppData->getAppDataFolder()
#18 /usr/local/www/nextcloud/lib/private/Template/IconsCacher.php(78): OC\Files\AppData\AppData->getFolder('icons')
#19 [internal function]: OC\Template\IconsCacher->__construct(Object(OC\Log), Object(OC\Files\AppData\Factory), Object(OC\URLGenerator), Object(OC\AppFramework\Utility\TimeFactory))
#20 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(81): ReflectionClass->newInstanceArgs(Array)
#21 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#22 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve('OC\\Template\\Ico...')
#23 /usr/local/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Template\\Ico...')
#24 /usr/local/www/nextcloud/lib/private/Server.php(980): OC\ServerContainer->query('OC\\Template\\Ico...')
#25 /usr/local/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#26 /usr/local/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(117): Pimple\Container->offsetGet('OC\\Template\\SCS...')
#27 /usr/local/www/nextcloud/lib/private/ServerContainer.php(132): OC\AppFramework\Utility\SimpleContainer->query('OC\\Template\\SCS...')
#28 /usr/local/www/nextcloud/lib/private/Repair.php(145): OC\ServerContainer->query('OC\\Template\\SCS...')
#29 /usr/local/www/nextcloud/core/register_command.php(143): OC\Repair::getRepairSteps()
#30 /usr/local/www/nextcloud/lib/private/Console/Application.php(118): require_once('/usr/local/www/...')
#31 /usr/local/www/nextcloud/console.php(95): OC\Console\Application->loadCommands(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#32 /usr/local/www/nextcloud/occ(11): require_once('/usr/local/www/...')
Total access 790：本日 1：昨日 0
Counter: 790, today: 1, yesterday: 0