search

linagora / Twake

Twake is a secure open source collaboration platform to improve organizational productivity.
https://twake.app
GNU Affero General Public License v3.0
1.77k stars 191 forks source link

Cassandra startup fatal errors #2797

Open richardDobron opened 1 year ago

richardDobron commented 1 year ago

Describe the bug At the initial execution of the command ./start.sh, these errors are displayed in the log, but the application otherwise works properly but applications are not imported.

Release Twake v2023.Q1.1223

Additional context logs from twake_php_1 container

2023-05-05 07:42:28 ⏳Waiting for ScyllaDB/Cassandra connection
2023-05-05 07:42:28 INFO: Installation configured without elastic search
2023-05-05 07:42:28 FrontObject
2023-05-05 07:42:28 INFO (IGNORING TABLE) ! Tables names MUST be snakecase and lowercase ! (Twake\Core\Entity\FrontObject)
2023-05-05 07:42:28 SearchableObject
2023-05-05 07:42:28 INFO (IGNORING TABLE) ! Tables names MUST be snakecase and lowercase ! (Twake\Core\Entity\SearchableObject)
2023-05-05 07:42:28 drive_file
2023-05-05 07:42:28 uploadstate
2023-05-05 07:42:28 drive_file_version
2023-05-05 07:42:28 tasks_list
2023-05-05 07:42:29 tasks_task_notification
2023-05-05 07:42:29 board
2023-05-05 07:42:29 task_user
2023-05-05 07:42:29 task_export_token
2023-05-05 07:42:29 tasks_task
2023-05-05 07:42:30 mail
2023-05-05 07:42:31 device
2023-05-05 07:42:31 external_user_repository
2023-05-05 07:42:37 
2023-05-05 07:42:37 Fatal error: Uncaught Cassandra\Exception\ConfigurationException: Cannot change level from type bigint to type int: types are incompatible. in /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php:472
2023-05-05 07:42:37 Stack trace:
2023-05-05 07:42:37 #0 /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php(472): Cassandra\FutureRows->get()
2023-05-05 07:42:37 #1 /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php(396): Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\CassandraConnection->query('ALTER TABLE twa...', NULL)
2023-05-05 07:42:37 #2 /twake-core/src/Twake/Core/Command/TwakeSchemaUpdateCommand.php(285): Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\CassandraConnection->exec('ALTER TABLE twa...')
2023-05-05 07:42:37 #3 /twake-core/app/Common/Commands/ContainerAwareCommand.php(27): Twake\Core\Command\TwakeSchemaUpdateCommand->execute()
2023-05-05 07:42:37 #4 /twake-core/app/Common/CommandsManager.php(46): Common\Commands\ContainerAwareCommand->executeFromManager( in /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php on line 472
2023-05-05 07:42:31 user
2023-05-05 07:42:35 verification_number_mail
2023-05-05 07:42:35 channel_tab
2023-05-05 07:42:35 channel
2023-05-05 07:42:35 channel_member
2023-05-05 07:42:35 scheduled_queue_counter
2023-05-05 07:42:35 websockets_route
2023-05-05 07:42:35 twake_sessions
2023-05-05 07:42:35 cached_from_node
2023-05-05 07:42:35 scheduled_queue_task
2023-05-05 07:42:35 mail_task
2023-05-05 07:42:35 searchhistory
2023-05-05 07:42:35 workspacetag
2023-05-05 07:42:35 bloc
2023-05-05 07:42:35 app_pricing
2023-05-05 07:42:36 workspace_level
2023-05-05 07:42:36 workspace_user_by_mail
2023-05-05 07:42:37 group_app
2023-05-05 07:42:37 group_user
2023-05-05 07:42:37 Failed loading /usr/local/lib/php/extensions/no-debug-non-zts-20160303/xdebug.so:  /usr/local/lib/php/extensions/no-debug-non-zts-20160303/xdebug.so: cannot open shared object file: No such file or directory
2023-05-05 07:42:37 PHP Warning:  Module 'apcu' already loaded in Unknown on line 0
2023-05-05 07:42:37 INFO: Installation configured without elastic search
2023-05-05 07:42:37 > Creating basic apps
2023-05-05 07:42:37 SCYLLADB > AN ERROR OCCURED WITH THIS QUERY : SELECT id  AS [...] FROM application  WHERE simple_name  =  'encrypted_eNdPoYrEHPI64rrA96inPA==' LIMIT 1
2023-05-05 07:42:37 Cassandra\Exception\InvalidQueryException: unconfigured table application in /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php:472
2023-05-05 07:42:37 Stack trace:
2023-05-05 07:42:37 #0 /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php(472): Cassandra\FutureRows->get()
2023-05-05 07:42:37 #1 /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php(396): Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\CassandraConnection->query('SELECT id  AS i...', Object(Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\PDOStatementAdapter))
2023-05-05 07:42:37 #2 /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php(238): Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\CassandraConnection->exec('SELECT id  AS i...', Object(Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\PDOStatementAdapter))
2023-05-05 07:42:37 #3 /twake-core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(905): Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\PDOStatementAdapter->execute()
2023-05-05 07:42:37 #4 /twake-core/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(718): Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS...', Array, Array)
2023-05-05 07:42:37 #5 /twake-core/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(193): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
2023-05-05 07:42:37 #6 /twake-core/src/Twake/Core/Services/DoctrineAdapter/RepositoryAdapter.php(41): Doctrine\ORM\EntityRepository->findOneBy(Array, NULL)
2023-05-05 07:42:37 #7 /twake-core/src/Twake/Core/Command/InitCommand.php(51): Twake\Core\Services\DoctrineAdapter\RepositoryAdapter->findOneBy(Array)
2023-05-05 07:42:37 #8 /twake-core/app/Common/Commands/ContainerAwareCommand.php(27): Twake\Core\Command\InitCommand->execute()
2023-05-05 07:42:37 #9 /twake-core/app/Common/CommandsManager.php(46): Common\Commands\ContainerAwareCommand->executeFromManager()
2023-05-05 07:42:37 #10 /twake-core/app/Common/CommandsManager.php(27): Common\CommandsManager->execute(Object(Twake\Core\Command\InitCommand), Array)
2023-05-05 07:42:37 #11 /twake-core/app/App.php(146): Common\CommandsManager->run()
2023-05-05 07:42:37 #12 /twake-core/bin/console(9): App\App->runCli()
2023-05-05 07:42:37 #13 {main}
2023-05-05 07:42:37 SCYLLADB > AN ERROR OCCURED WITH THIS QUERY : INSERT INTO application (id, group_id, is_default, app_group_name, name, simple_name, description, website, categories, icon_url, public, twake_team_validation, is_available_to_public, install_count, creation_date, api_events_url, api_allowed_ip, api_private_key, privileges_capabilities_last_update, privileges, capabilities, hooks, display_configuration, es_indexed, front_id) values  ( a47a06d0-eb07-11ed-889d-0242ac120004, 00000000-0000-1000-0000-000000000000, 1, 'encrypted_DJ4HPJg84QuwJKs3cugNLg==', 'encrypted_Y3nJ+5v17BbXr4zRhs66RA==_f638a50a5731af10730347d1aea37df9_QVjiBaZh2DVCtRwrPYksaA==', 'encrypted_eNdPoYrEHPI64rrA96inPA==', 'encrypted_X0727wgpRXNIfeoTphHzSzAJzB9qT1woVDHkfV1bWkE=_fe03a022151ba08c4eeb56be9f867f7a_1lfuHQPIIqhMzRvRsWdJZg==', 'encrypted_HPY7adRTPcoEc63y6gYdV+EijdRrsVCYj+yc1gPChjo=_d1e38ff528041503cab837aa7bdd1aae_s6EuPG2xo5jlTBJOSthd6g==', NULL, 'encrypted_Y2RzrcHtuxmwdoYJJt0NDdbGIJ2hXhjhP3lR810TcEptiCgpaIptmUuj6ZyTEVFp_e0a911b06b11b522b89fcb933b283f21_1yk0wEb4Gmh6FvtvtUTuvQ==', 1, 1, 1, NULL, '2023-05-05 05:42:37+0000', NULL, NULL, 'encrypted_XWF9WnOIvxIoj38cjZ8M/bYudw18F3afoE+QvsXJo92SV58Tio2lUxzMqzdIFbS7PKu3aT1238inyZMq/byCMCWtUDg1UJwX3X5r3QDUnSof5YQ5uRcKt4X6f8jBTnPInK1b6vPA8wDeAnqB/NRCu2Igm+maSn1c/cfJAQp9BNkaXJgl8ZsUMVq08nBLk1r1_ff58847113be8deebba4f8f4957dcc1c_A86cL4TfRXFHZGXdLn4inw==', NULL, 'encrypted_xns5eGz1f9mSuE5Vg+NOng==_abd60540a382ce583288ec0686d569f9_PJhIcOyjhkJlruLUEp/3Gg==', 'encrypted_ozNfHzsrfzxtNx5tv0dl4w==_48a0c9179c0637cf01f34a8694ecc739_DB39innMDTZWYFOfGQrjPQ==', 'encrypted_5i0hwyC27OUkdzX8w19Ebw==_3424e5c8ec7795cf8a2879f5ab71fe5b_6+aN53CIiRbvzxEBrWTwhQ==', 'encrypted_I/8WuomU4ZALX6NhLb+1W05JAGslCtZaFr26TJGUziwe9+Tx65HNunTtvUFLCp3NWrzAWEFeK3YYdThH6HAJdMSCgPbzt5PEZnF8UbswpLw=_a6619830abb3770d4b68f3696a5da411_EKw6ljzyAz2aKLyZBqKODA==', 1, '16832653576bb87a4cfc1cb06622481d197d8e8def6c1002d4')
2023-05-05 07:42:37 Cassandra\Exception\InvalidQueryException: unconfigured table application in /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php:472
2023-05-05 07:42:37 Stack trace:
2023-05-05 07:42:37 #0 /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php(472): Cassandra\FutureRows->get()
2023-05-05 07:42:37 #1 /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php(396): Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\CassandraConnection->query('INSERT INTO app...', Object(Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\PDOStatementAdapter))
2023-05-05 07:42:37 #2 /twake-core/src/Twake/Core/Services/DoctrineAdapter/DBAL/Driver/PDOCassandra/CassandraConnection.php(238): Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\CassandraConnection->exec('INSERT INTO app...', Object(Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\PDOStatementAdapter))
2023-05-05 07:42:37 #3 /twake-core/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(153): Twake\Core\Services\DoctrineAdapter\DBAL\Driver\PDOCassandra\PDOStatementAdapter->execute(NULL)
2023-05-05 07:42:37 #4 /twake-core/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(287): Doctrine\DBAL\Statement->execute()
2023-05-05 07:42:37 #5 /twake-core/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1087): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
2023-05-05 07:42:37 #6 /twake-core/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(400): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))
2023-05-05 07:42:37 #7 /twake-core/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(368): Doctrine\ORM\UnitOfWork->commit(NULL)
2023-05-05 07:42:37 #8 /twake-core/src/Twake/Core/Services/DoctrineAdapter/ManagerAdapter.php(155): Doctrine\ORM\EntityManager->flush()
2023-05-05 07:42:37 #9 /twake-core/src/Twake/Core/Command/InitCommand.php(68): Twake\Core\Services\DoctrineAdapter\ManagerAdapter->flush()
2023-05-05 07:42:37 #10 /twake-core/app/Common/Commands/ContainerAwareCommand.php(27): Twake\Core\Command\InitCommand->execute()
2023-05-05 07:42:37 #11 /twake-core/app/Common/CommandsManager.php(46): Common\Commands\ContainerAwareCommand->executeFromManager()
2023-05-05 07:42:37 #12 /twake-core/app/Common/CommandsManager.php(27): Common\CommandsManager->execute(Object(Twake\Core\Command\InitCommand), Array)
2023-05-05 07:42:37 #13 /twake-core/app/App.php(146): Common\CommandsManager->run()
2023-05-05 07:42:37 #14 /twake-core/bin/console(9): App\App->runCli()
2023-05-05 07:42:37 #15 {main}