Tuleap 16 est là ! Assistez à l'événement virtuel le 17 octobre à 10h30. Inscrivez-vous ici !

    •  
      request #10202 Duplicate key error while importing Gitolite logs in the new format
    Infos
    #10202
    Thomas Gerbet (tgerbet)
    2017-05-10 12:31
    2017-05-09 22:39
    10473
    Details
    Duplicate key error while importing Gitolite logs in the new format
    request #10106 has introduced a new storage format for the Git access logs and the deployment guide of Tuleap 9.7 advise to convert the existing data.

    However you are very likely to encounter the following error while trying to import the data:
    Fatal error: Uncaught exception 'DataAccessQueryException' with message 'DB error ==> INSERT INTO plugin_git_log_read_daily(repository_id, user_id, day, git_read)
    SELECT repository_id, user_id, DATE_FORMAT(FROM_UNIXTIME(time), '%Y%m%d') as day, count(*)
    FROM plugin_git_full_history
    WHERE time > YYYYYYYYYY AND time <= XXXXXXXXXXX
    GROUP BY repository_id, user_id, day @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 148' in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php:154
    Stack trace:
    #0 /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php(148): DataAccessObject->handleError(Object(DataAccessResult), 'INSERT INTO plu...')
    #1 /usr/share/tuleap/plugins/git/include/Git/Gitolite/GitoliteFullLogsToAggregatedLogs.php(68): DataAccessObject->update('INSERT INTO plu...')
    #2 /usr/share/tuleap/plugins/git/include/Git/Gitolite/GitoliteFullLogsToAggregatedLogs.php(50): Tuleap\Git\Gitolite\GitoliteFullLogsToAggregatedLogs->updateBetw in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 154
    SCM/Git
    9.7
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Closed
    2017-05-10
    Attachments
    Empty
    References

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2017-05-10 12:31
    This is a an artifact to track a specific issue. For questions about Tuleap Enterprise editions, please use your dedicated support channels.
    User avatar
    Hi,

    We are planning to upgrade to version 9.7.2 next week.
    I am wondering if there are any issues if we don't run the git access log update?

    Best regards,
    Seif