Nextcloud MySQL Error の履歴差分(No.1)

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

• 追加された行はこの色です。
• 削除された行はこの色です。

#author("2019-02-13T03:15:15+09:00","default:kuji","kuji")
CONTENTS
#contents
----
Lastmodified　&lastmod;
----
*Nextcloud MySQL Error [#m62a2e86]


 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 &counter(total);：本日 &counter(today);：昨日 &counter(yesterday);
#counter([total|today|yesterday]);