•  
      request #47805 tuleap-launch-daily-event.service should have a stack trace
    Infos
    #47805
    Florian KOZMIK (fkozmik)
    2026-08-21 15:00
    2026-08-20 11:41
    49551
    Details
    tuleap-launch-daily-event.service should have a stack trace

    Right now all we have is this :

    Aug 19 08:15:55 tuleap.net tuleap[83693]: In EasyDB.php line 1458:
    Aug 19 08:15:55 tuleap.net tuleap[83693]:                                                                                
    Aug 19 08:15:55 tuleap.net tuleap[83693]:   SQLSTATE[HY000]: General error: 1390 Prepared statement contains too many p
    Aug 19 08:15:55 tuleap.net tuleap[83693]:   laceholders
    Aug 19 08:15:55 tuleap.net tuleap[83693]:                                                                                
    Aug 19 08:15:55 tuleap.net tuleap[83693]: daily-job
    Aug 19 08:15:55 tuleap.net systemd[1]: tuleap-launch-daily-event.service: Main process exited, code=exited, status=1/FAILURE
    

    I don't know how to handle the issue, seems like it's a Tuleap / DB problem

    Empty
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Manuel Vacelet (vaceletm)
    Under implementation
    Empty
    Attachments
    References
    Referenced by request #47805

    Follow-ups

    User avatar

    So issue come from a large number of users that consumes all the available invitations. A first fix is needed to help with the purge, a structural fix should be done to avoid the whole workflow.

    User avatar

    Here's the trace :

    Aug 21 08:46:52 tuleap.net tuleap[325615]: In EasyDB.php line 1458:
    Aug 21 08:46:52 tuleap.net tuleap[325615]:                                                                                
    Aug 21 08:46:52 tuleap.net tuleap[325615]:   [PDOException (HY000)]
    Aug 21 08:46:52 tuleap.net tuleap[325615]:   SQLSTATE[HY000]: General error: 1390 Prepared statement contains too many p
    Aug 21 08:46:52 tuleap.net tuleap[325615]:   laceholders
    Aug 21 08:46:52 tuleap.net tuleap[325615]:                                                                                
    Aug 21 08:46:52 tuleap.net tuleap[325615]: Exception trace:
    Aug 21 08:46:52 tuleap.net tuleap[325615]:   at /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php:1458
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  PDO->prepare() at /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php:1458
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  ParagonIE\EasyDB\EasyDB->prepare() at /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php:1004
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  ParagonIE\EasyDB\EasyDB->safeQuery() at /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php:245
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  ParagonIE\EasyDB\EasyDB->deleteWhereStatement() at /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php:130
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  ParagonIE\EasyDB\EasyDB->delete() at /usr/share/tuleap/src/common/InviteBuddy/InvitationDao.php:215
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Tuleap\InviteBuddy\InvitationDao->{closure:Tuleap\InviteBuddy\InvitationDao::purgeObsoleteInvitations():201}() at /usr/share/tuleap/src/vendor/paragonie/easydb/src/EasyDB.php:1263
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  ParagonIE\EasyDB\EasyDB->tryFlatTransaction() at /usr/share/tuleap/src/common/InviteBuddy/InvitationDao.php:200
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Tuleap\InviteBuddy\InvitationDao->purgeObsoleteInvitations() at /usr/share/tuleap/src/common/InviteBuddy/InvitationCleaner.php:49
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Tuleap\InviteBuddy\InvitationCleaner->cleanObsoleteInvitations() at /usr/share/tuleap/src/common/CLI/Command/DailyJobCommand.php:71
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Tuleap\CLI\Command\DailyJobCommand->{closure:Tuleap\CLI\Command\DailyJobCommand::execute():62}() at /usr/share/tuleap/src/common/CLI/DelayExecution/ExecutionDelayedLauncher.php:43
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Tuleap\CLI\DelayExecution\ExecutionDelayedLauncher->execute() at /usr/share/tuleap/src/common/CLI/Command/DailyJobCommand.php:62
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Tuleap\CLI\Command\DailyJobCommand->execute() at /usr/share/tuleap/src/vendor/symfony/console/Command/Command.php:341
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Symfony\Component\Console\Command\Command->run() at /usr/share/tuleap/src/vendor/symfony/console/Application.php:1094
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Symfony\Component\Console\Application->doRunCommand() at /usr/share/tuleap/src/vendor/symfony/console/Application.php:356
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Symfony\Component\Console\Application->doRun() at /usr/share/tuleap/src/common/CLI/Application.php:91
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Tuleap\CLI\Application->doRun() at /usr/share/tuleap/src/vendor/symfony/console/Application.php:195
    Aug 21 08:46:52 tuleap.net tuleap[325615]:  Symfony\Component\Console\Application->run() at /usr/share/tuleap/src/utils/tuleap.php:347
    Aug 21 08:46:52 tuleap.net tuleap[325615]: daily-job
    Aug 21 08:46:52 tuleap.net systemd[1]: tuleap-launch-daily-event.service: Main process exited, code=exited, status=1/FAILURE
    Aug 21 08:46:52 tuleap.net systemd[1]: tuleap-launch-daily-event.service: Failed with result 'exit-code'.
    Aug 21 08:46:52 tuleap.net systemd[1]: tuleap-launch-daily-event.service: Consumed 2.514s CPU time.
    
    User avatar
    • Status changed from New to Under implementation
    • Assigned to changed from None to Manuel Vacelet (vaceletm)