Nextcloud 27.0.0_1.6.33 - unable to finish installation

stillka

stillka

Explorer
Joined
Nov 15, 2014
Messages
55
Hello,

after installing official Nextcloud app (27.0.0_1.6.33) with default settings on latest TrueNAS-SCALE-22.12.3.2, I am not able to finish installation
in the Nextcloud web interface:

"Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "oc_migrations" already exists"

Any hints?

Thanks.
 
stillka

stillka

Explorer
Joined
Nov 15, 2014
Messages
55
postgresql:

2023-07-11 07:29:29.256473+00:002023-07-11 07:29:29.256 UTC [1] LOG: starting PostgreSQL 13.1 (Debian 13.1-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2023-07-11 07:29:29.256966+00:002023-07-11 07:29:29.256 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2023-07-11 07:29:29.257033+00:002023-07-11 07:29:29.256 UTC [1] LOG: listening on IPv6 address "::", port 5432
2023-07-11 07:29:29.277940+00:002023-07-11 07:29:29.277 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-07-11 07:29:29.303879+00:002023-07-11 07:29:29.303 UTC [76] LOG: database system was shut down at 2023-07-11 07:29:29 UTC
2023-07-11 07:29:29.329877+00:002023-07-11 07:29:29.329 UTC [1] LOG: database system is ready to accept connections
2023-07-11 07:31:54.943571+00:002023-07-11 07:31:54.940 UTC [232] LOG: could not receive data from client: Connection reset by peer
2023-07-11 07:36:11.302369+00:002023-07-11 07:36:11.302 UTC [863] ERROR: relation "oc_migrations" already exists


manual install from "nextcloud" container:
Code:
root@nextcloudng-6dfccbbf86-4zhtp:/var/www/html# sudo -u www-data php occ maintenance:install

Warning: Failed to set memory limit to 0 bytes (Current memory usage is 2097152 bytes) in Unknown on line 0
The current PHP memory limit is below the recommended value of 512MB.
What is the password you like to use for the admin account <admin>?
Error while trying to initialise the database: An exception occurred while executing a query: SQLSTATE[42P07]: Duplicate table: 7 ERROR:  relation "oc_migrations" already exists
Trace: #0 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1814): Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))
#1 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1749): Doctrine\DBAL\Connection->handleDriverException(Object(Doctrine\DBAL\Driver\PDO\Exception), Object(Doctrine\DBAL\Query))
#2 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1055): Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDO\Exception), 'CREATE TABLE oc...', Array, Array)
#3 /var/www/html/lib/private/DB/Connection.php(262): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE oc...', Array, Array, NULL)
#4 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1843): OC\DB\Connection->executeQuery('CREATE TABLE oc...')
#5 /var/www/html/lib/private/DB/Migrator.php(162): Doctrine\DBAL\Connection->query('CREATE TABLE oc...')
#6 /var/www/html/lib/private/DB/Migrator.php(68): OC\DB\Migrator->applySchema(Object(Doctrine\DBAL\Schema\Schema))
#7 /var/www/html/lib/private/DB/Connection.php(589): OC\DB\Migrator->migrate(Object(Doctrine\DBAL\Schema\Schema))
#8 /var/www/html/lib/private/DB/MigrationService.php(169): OC\DB\Connection->migrateToSchema(Object(Doctrine\DBAL\Schema\Schema))
#9 /var/www/html/lib/private/DB/MigrationService.php(183): OC\DB\MigrationService->createMigrationTable()
#10 /var/www/html/lib/private/DB/MigrationService.php(256): OC\DB\MigrationService->getMigratedVersions()
#11 /var/www/html/lib/private/DB/MigrationService.php(434): OC\DB\MigrationService->getMigrationsToExecute('latest')
#12 /var/www/html/lib/private/DB/MigrationService.php(409): OC\DB\MigrationService->migrateSchemaOnly('latest')
#13 /var/www/html/lib/private/Setup/AbstractDatabase.php(158): OC\DB\MigrationService->migrate('latest', true)
#14 /var/www/html/lib/private/Setup.php(371): OC\Setup\AbstractDatabase->runMigrations()
#15 /var/www/html/core/Command/Maintenance/Install.php(104): OC\Setup->install(Array)
#16 /var/www/html/3rdparty/symfony/console/Command/Command.php(298): OC\Core\Command\Maintenance\Install->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#17 /var/www/html/3rdparty/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#18 /var/www/html/3rdparty/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\Maintenance\Install), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#19 /var/www/html/3rdparty/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#20 /var/www/html/lib/private/Console/Application.php(211): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#21 /var/www/html/console.php(100): OC\Console\Application->run()
#22 /var/www/html/occ(11): require_once('/var/www/html/c...')
#23 {main}

Previous: Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42P07]: Duplicate table: 7 ERROR:  relation "oc_migrations" already exists
Trace: #0 /var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php(77): Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1050): Doctrine\DBAL\Driver\PDO\Connection->query('CREATE TABLE oc...')
#2 /var/www/html/lib/private/DB/Connection.php(262): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE oc...', Array, Array, NULL)
#3 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1843): OC\DB\Connection->executeQuery('CREATE TABLE oc...')
#4 /var/www/html/lib/private/DB/Migrator.php(162): Doctrine\DBAL\Connection->query('CREATE TABLE oc...')
#5 /var/www/html/lib/private/DB/Migrator.php(68): OC\DB\Migrator->applySchema(Object(Doctrine\DBAL\Schema\Schema))
#6 /var/www/html/lib/private/DB/Connection.php(589): OC\DB\Migrator->migrate(Object(Doctrine\DBAL\Schema\Schema))
#7 /var/www/html/lib/private/DB/MigrationService.php(169): OC\DB\Connection->migrateToSchema(Object(Doctrine\DBAL\Schema\Schema))
#8 /var/www/html/lib/private/DB/MigrationService.php(183): OC\DB\MigrationService->createMigrationTable()
#9 /var/www/html/lib/private/DB/MigrationService.php(256): OC\DB\MigrationService->getMigratedVersions()
#10 /var/www/html/lib/private/DB/MigrationService.php(434): OC\DB\MigrationService->getMigrationsToExecute('latest')
#11 /var/www/html/lib/private/DB/MigrationService.php(409): OC\DB\MigrationService->migrateSchemaOnly('latest')
#12 /var/www/html/lib/private/Setup/AbstractDatabase.php(158): OC\DB\MigrationService->migrate('latest', true)
#13 /var/www/html/lib/private/Setup.php(371): OC\Setup\AbstractDatabase->runMigrations()
#14 /var/www/html/core/Command/Maintenance/Install.php(104): OC\Setup->install(Array)
#15 /var/www/html/3rdparty/symfony/console/Command/Command.php(298): OC\Core\Command\Maintenance\Install->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 /var/www/html/3rdparty/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#17 /var/www/html/3rdparty/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\Maintenance\Install), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#18 /var/www/html/3rdparty/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#19 /var/www/html/lib/private/Console/Application.php(211): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#20 /var/www/html/console.php(100): OC\Console\Application->run()
#21 /var/www/html/occ(11): require_once('/var/www/html/c...')
#22 {main}

Previous: PDOException: SQLSTATE[42P07]: Duplicate table: 7 ERROR:  relation "oc_migrations" already exists
Trace: #0 /var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php(72): PDO->query('CREATE TABLE oc...')
#1 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1050): Doctrine\DBAL\Driver\PDO\Connection->query('CREATE TABLE oc...')
#2 /var/www/html/lib/private/DB/Connection.php(262): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE oc...', Array, Array, NULL)
#3 /var/www/html/3rdparty/doctrine/dbal/src/Connection.php(1843): OC\DB\Connection->executeQuery('CREATE TABLE oc...')
#4 /var/www/html/lib/private/DB/Migrator.php(162): Doctrine\DBAL\Connection->query('CREATE TABLE oc...')
#5 /var/www/html/lib/private/DB/Migrator.php(68): OC\DB\Migrator->applySchema(Object(Doctrine\DBAL\Schema\Schema))
#6 /var/www/html/lib/private/DB/Connection.php(589): OC\DB\Migrator->migrate(Object(Doctrine\DBAL\Schema\Schema))
#7 /var/www/html/lib/private/DB/MigrationService.php(169): OC\DB\Connection->migrateToSchema(Object(Doctrine\DBAL\Schema\Schema))
#8 /var/www/html/lib/private/DB/MigrationService.php(183): OC\DB\MigrationService->createMigrationTable()
#9 /var/www/html/lib/private/DB/MigrationService.php(256): OC\DB\MigrationService->getMigratedVersions()
#10 /var/www/html/lib/private/DB/MigrationService.php(434): OC\DB\MigrationService->getMigrationsToExecute('latest')
#11 /var/www/html/lib/private/DB/MigrationService.php(409): OC\DB\MigrationService->migrateSchemaOnly('latest')
#12 /var/www/html/lib/private/Setup/AbstractDatabase.php(158): OC\DB\MigrationService->migrate('latest', true)
#13 /var/www/html/lib/private/Setup.php(371): OC\Setup\AbstractDatabase->runMigrations()
#14 /var/www/html/core/Command/Maintenance/Install.php(104): OC\Setup->install(Array)
#15 /var/www/html/3rdparty/symfony/console/Command/Command.php(298): OC\Core\Command\Maintenance\Install->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 /var/www/html/3rdparty/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#17 /var/www/html/3rdparty/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\Maintenance\Install), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#18 /var/www/html/3rdparty/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#19 /var/www/html/lib/private/Console/Application.php(211): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#20 /var/www/html/console.php(100): OC\Console\Application->run()
#21 /var/www/html/occ(11): require_once('/var/www/html/c...')
#22 {main}
root@nextcloudng-6dfccbbf86-4zhtp:/var/www/html#
 
Last edited:
You must log in or register to reply here.

Similar threads

F
Connection error to the database while creating nextcloud instance on freenas 11.3 with iocage
Replies
2
Views
2K
freebsd-server-configurator
F
B
NextCloud Upgrade to version 21 broken
Replies
3
Views
2K
ddaenen1
D
Nicky-
Migration from Official Nextcloud app to external docker
Replies
1
Views
587
victort
victort
D
Nextcloud: error while trying to create admin user
2
Replies
21
Views
19K
nadovich
N
K
Nextcloud can't see database, unlike all guides
Replies
2
Views
3K
pc-magic
pc-magic
Top