From Tom, 4 Months ago, written in Plain Text.
This paste will croak in 1 Second.
Embed
  1. root@sv-lx-jz-01:/# sudo -u www-data php /var/www/nextcloud/occ maintenance:install --database "mysql" --database-name "nextcloud" --database-user "ncuser" --database-pass "ncpass" --admin-user "tescher" --admin-pass "testpilot" --data-dir "/var/nc_data"
  2. Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
  3. Trace: #0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1780): Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
  4. #1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1719): Doctrine\DBAL\Connection->handleDriverException()
  5. #2 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1067): Doctrine\DBAL\Connection->convertExceptionDuringQuery()
  6. #3 /var/www/nextcloud/lib/private/DB/Connection.php(236): Doctrine\DBAL\Connection->executeQuery()
  7. #4 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1809): OC\DB\Connection->executeQuery()
  8. #5 /var/www/nextcloud/lib/private/DB/Migrator.php(175): Doctrine\DBAL\Connection->query()
  9. #6 /var/www/nextcloud/lib/private/DB/Migrator.php(76): OC\DB\Migrator->applySchema()
  10. #7 /var/www/nextcloud/lib/private/DB/Connection.php(532): OC\DB\Migrator->migrate()
  11. #8 /var/www/nextcloud/lib/private/DB/MigrationService.php(177): OC\DB\Connection->migrateToSchema()
  12. #9 /var/www/nextcloud/lib/private/DB/MigrationService.php(191): OC\DB\MigrationService->createMigrationTable()
  13. #10 /var/www/nextcloud/lib/private/DB/MigrationService.php(264): OC\DB\MigrationService->getMigratedVersions()
  14. #11 /var/www/nextcloud/lib/private/DB/MigrationService.php(442): OC\DB\MigrationService->getMigrationsToExecute()
  15. #12 /var/www/nextcloud/lib/private/DB/MigrationService.php(417): OC\DB\MigrationService->migrateSchemaOnly()
  16. #13 /var/www/nextcloud/lib/private/Setup/AbstractDatabase.php(153): OC\DB\MigrationService->migrate()
  17. #14 /var/www/nextcloud/lib/private/Setup.php(372): OC\Setup\AbstractDatabase->runMigrations()
  18. #15 /var/www/nextcloud/core/Command/Maintenance/Install.php(108): OC\Setup->install()
  19. #16 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OC\Core\Command\Maintenance\Install->execute()
  20. #17 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run()
  21. #18 /var/www/nextcloud/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()
  22. #19 /var/www/nextcloud/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()
  23. #20 /var/www/nextcloud/lib/private/Console/Application.php(211): Symfony\Component\Console\Application->run()
  24. #21 /var/www/nextcloud/console.php(99): OC\Console\Application->run()
  25. #22 /var/www/nextcloud/occ(11): require_once('...')
  26. #23 {main}
  27.  
  28. Previous: Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
  29. Trace: #0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php(87): Doctrine\DBAL\Driver\PDO\Exception::new()
  30. #1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1062): Doctrine\DBAL\Driver\PDO\Connection->query()
  31. #2 /var/www/nextcloud/lib/private/DB/Connection.php(236): Doctrine\DBAL\Connection->executeQuery()
  32. #3 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1809): OC\DB\Connection->executeQuery()
  33. #4 /var/www/nextcloud/lib/private/DB/Migrator.php(175): Doctrine\DBAL\Connection->query()
  34. #5 /var/www/nextcloud/lib/private/DB/Migrator.php(76): OC\DB\Migrator->applySchema()
  35. #6 /var/www/nextcloud/lib/private/DB/Connection.php(532): OC\DB\Migrator->migrate()
  36. #7 /var/www/nextcloud/lib/private/DB/MigrationService.php(177): OC\DB\Connection->migrateToSchema()
  37. #8 /var/www/nextcloud/lib/private/DB/MigrationService.php(191): OC\DB\MigrationService->createMigrationTable()
  38. #9 /var/www/nextcloud/lib/private/DB/MigrationService.php(264): OC\DB\MigrationService->getMigratedVersions()
  39. #10 /var/www/nextcloud/lib/private/DB/MigrationService.php(442): OC\DB\MigrationService->getMigrationsToExecute()
  40. #11 /var/www/nextcloud/lib/private/DB/MigrationService.php(417): OC\DB\MigrationService->migrateSchemaOnly()
  41. #12 /var/www/nextcloud/lib/private/Setup/AbstractDatabase.php(153): OC\DB\MigrationService->migrate()
  42. #13 /var/www/nextcloud/lib/private/Setup.php(372): OC\Setup\AbstractDatabase->runMigrations()
  43. #14 /var/www/nextcloud/core/Command/Maintenance/Install.php(108): OC\Setup->install()
  44. #15 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OC\Core\Command\Maintenance\Install->execute()
  45. #16 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run()
  46. #17 /var/www/nextcloud/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()
  47. #18 /var/www/nextcloud/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()
  48. #19 /var/www/nextcloud/lib/private/Console/Application.php(211): Symfony\Component\Console\Application->run()
  49. #20 /var/www/nextcloud/console.php(99): OC\Console\Application->run()
  50. #21 /var/www/nextcloud/occ(11): require_once('...')
  51. #22 {main}
  52.  
  53. Previous: PDOException: SQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
  54. Trace: #0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php(82): PDO->query()
  55. #1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1062): Doctrine\DBAL\Driver\PDO\Connection->query()
  56. #2 /var/www/nextcloud/lib/private/DB/Connection.php(236): Doctrine\DBAL\Connection->executeQuery()
  57. #3 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1809): OC\DB\Connection->executeQuery()
  58. #4 /var/www/nextcloud/lib/private/DB/Migrator.php(175): Doctrine\DBAL\Connection->query()
  59. #5 /var/www/nextcloud/lib/private/DB/Migrator.php(76): OC\DB\Migrator->applySchema()
  60. #6 /var/www/nextcloud/lib/private/DB/Connection.php(532): OC\DB\Migrator->migrate()
  61. #7 /var/www/nextcloud/lib/private/DB/MigrationService.php(177): OC\DB\Connection->migrateToSchema()
  62. #8 /var/www/nextcloud/lib/private/DB/MigrationService.php(191): OC\DB\MigrationService->createMigrationTable()
  63. #9 /var/www/nextcloud/lib/private/DB/MigrationService.php(264): OC\DB\MigrationService->getMigratedVersions()
  64. #10 /var/www/nextcloud/lib/private/DB/MigrationService.php(442): OC\DB\MigrationService->getMigrationsToExecute()
  65. #11 /var/www/nextcloud/lib/private/DB/MigrationService.php(417): OC\DB\MigrationService->migrateSchemaOnly()
  66. #12 /var/www/nextcloud/lib/private/Setup/AbstractDatabase.php(153): OC\DB\MigrationService->migrate()
  67. #13 /var/www/nextcloud/lib/private/Setup.php(372): OC\Setup\AbstractDatabase->runMigrations()
  68. #14 /var/www/nextcloud/core/Command/Maintenance/Install.php(108): OC\Setup->install()
  69. #15 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OC\Core\Command\Maintenance\Install->execute()
  70. #16 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run()
  71. #17 /var/www/nextcloud/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()
  72. #18 /var/www/nextcloud/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()
  73. #19 /var/www/nextcloud/lib/private/Console/Application.php(211): Symfony\Component\Console\Application->run()
  74. #20 /var/www/nextcloud/console.php(99): OC\Console\Application->run()
  75. #21 /var/www/nextcloud/occ(11): require_once('...')
  76. #22 {main}
  77. root@sv-lx-jz-01:/#
  78.