delta-cs / seminar-domjudge

DOMjudge programming contest jury system
https://www.domjudge.org
GNU General Public License v2.0
3 stars 0 forks source link

Cannot setup clean environment #127

Closed zapotocnylubos closed 6 months ago

zapotocnylubos commented 6 months ago

Out changes to the contest entity may have resulted in a non-working contest import.

This contest importing happened when domjudge first initializes.

From docker logs

Import contest metadata (from contest.yaml)? (Y/n) Importing contest.
{"code":500,"message":"Internal Server Error"}
zapotocnylubos commented 6 months ago

as expected, contest ranknumber

{"code":500,"message":"An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ranknumber' cannot be null","class":"Doctrine\\DBAL\\Exception\\NotNullConstraintViolationException","trace":[{"namespace":"","short_class":"","class":"","type":"","function":"","file":"/domjudge/lib/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","line":114,"args":[]},{"namespace":"Doctrine\\DBAL\\Driver\\API\\MySQL","short_class":"ExceptionConverter","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->","function":"convert","file":"/domjudge/lib/vendor/doctrine/dbal/src/Connection.php","line":1907,"args":[]},{"namespace":"Doctrine\\DBAL","short_class":"Connection","class":"Doctrine\\DBAL\\Connection","type":"->","function":"handleDriverException","file":"/domjudge/lib/vendor/doctrine/dbal/src/Connection.php","line":1850,"args":[]},{"namespace":"Doctrine\\DBAL","short_class":"Connection","class":"Doctrine\\DBAL\\Connection","type":"->","function":"convertExceptionDuringQuery","file":"/domjudge/lib/vendor/doctrine/dbal/src/Statement.php","line":194,"args":[]},{"namespace":"Doctrine\\DBAL","short_class":"Statement","class":"Doctrine\\DBAL\\Statement","type":"->","function":"execute","file":"/domjudge/lib/vendor/doctrine/dbal/src/Statement.php","line":249,"args":[]},{"namespace":"Doctrine\\DBAL","short_class":"Statement","class":"Doctrine\\DBAL\\Statement","type":"->","function":"executeStatement","file":"/domjudge/lib/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php","line":278,"args":[]},{"namespace":"Doctrine\\ORM\\Persisters\\Entity","short_class":"BasicEntityPersister","class":"Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister","type":"->","function":"executeInserts","file":"/domjudge/lib/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php","line":1145,"args":[]},{"namespace":"Doctrine\\ORM","short_class":"UnitOfWork","class":"Doctrine\\ORM\\UnitOfWork","type":"->","function":"executeInserts","file":"/domjudge/lib/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php","line":431,"args":[]},{"namespace":"Doctrine\\ORM","short_class":"UnitOfWork","class":"Doctrine\\ORM\\UnitOfWork","type":"->","function":"commit","file":"/domjudge/lib/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php","line":403,"args":[]},{"namespace":"Doctrine\\ORM","short_class":"EntityManager","class":"Doctrine\\ORM\\EntityManager","type":"->","function":"flush","file":"/domjudge/webapp/src/Service/ImportExportService.php","line":208,"args":[]},{"namespace":"App\\Service","short_class":"ImportExportService","class":"App\\Service\\ImportExportService","type":"->","function":"importContestData","file":"/domjudge/webapp/src/Controller/API/ContestController.php","line":112,"args":[]},{"namespace":"App\\Controller\\API","short_class":"ContestController","class":"App\\Controller\\API\\ContestController","type":"->","function":"addContestAction","file":"/domjudge/lib/vendor/symfony/http-kernel/HttpKernel.php","line":163,"args":[]},{"namespace":"Symfony\\Component\\HttpKernel","short_class":"HttpKernel","class":"Symfony\\Component\\HttpKernel\\HttpKernel","type":"->","function":"handleRaw","file":"/domjudge/lib/vendor/symfony/http-kernel/HttpKernel.php","line":75,"args":[]},{"namespace":"Symfony\\Component\\HttpKernel","short_class":"HttpKernel","class":"Symfony\\Component\\HttpKernel\\HttpKernel","type":"->","function":"handle","file":"/domjudge/webapp/src/Service/DOMJudgeService.php","line":625,"args":[]},{"namespace":"App\\Service","short_class":"DOMJudgeService","class":"App\\Service\\DOMJudgeService","type":"->","function":"internalApiRequest","file":"/domjudge/webapp/src/Command/CallApiActionCommand.php","line":150,"args":[]},{"namespace":"App\\Command","short_class":"CallApiActionCommand","class":"App\\Command\\CallApiActionCommand","type":"->","function":"App\\Command\\{closure}","file":"/domjudge/webapp/src/Service/DOMJudgeService.php","line":456,"args":[]},{"namespace":"App\\Service","short_class":"DOMJudgeService","class":"App\\Service\\DOMJudgeService","type":"->","function":"withAllRoles","file":"/domjudge/webapp/src/Command/CallApiActionCommand.php","line":149,"args":[]},{"namespace":"App\\Command","short_class":"CallApiActionCommand","class":"App\\Command\\CallApiActionCommand","type":"->","function":"execute","file":"/domjudge/lib/vendor/symfony/console/Command/Command.php","line":298,"args":[]},{"namespace":"Symfony\\Component\\Console\\Command","short_class":"Command","class":"Symfony\\Component\\Console\\Command\\Command","type":"->","function":"run","file":"/domjudge/lib/vendor/symfony/console/Application.php","line":1058,"args":[]},{"namespace":"Symfony\\Component\\Console","short_class":"Application","class":"Symfony\\Component\\Console\\Application","type":"->","function":"doRunCommand","file":"/domjudge/lib/vendor/symfony/framework-bundle/Console/Application.php","line":96,"args":[]},{"namespace":"Symfony\\Bundle\\FrameworkBundle\\Console","short_class":"Application","class":"Symfony\\Bundle\\FrameworkBundle\\Console\\Application","type":"->","function":"doRunCommand","file":"/domjudge/lib/vendor/symfony/console/Application.php","line":301,"args":[]},{"namespace":"Symfony\\Component\\Console","short_class":"Application","class":"Symfony\\Component\\Console\\Application","type":"->","function":"doRun","file":"/domjudge/lib/vendor/symfony/framework-bundle/Console/Application.php","line":82,"args":[]},{"namespace":"Symfony\\Bundle\\FrameworkBundle\\Console","short_class":"Application","class":"Symfony\\Bundle\\FrameworkBundle\\Console\\Application","type":"->","function":"doRun","file":"/domjudge/lib/vendor/symfony/console/Application.php","line":171,"args":[]},{"namespace":"Symfony\\Component\\Console","short_class":"Application","class":"Symfony\\Component\\Console\\Application","type":"->","function":"run","file":"/domjudge/webapp/bin/console","line":42,"args":[]}]}
matous-volf commented 6 months ago

yes, i remember we were planning to edit the import scripts