Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #10202 Duplicate key error while importing Gitolite logs in the new format
    Actions
    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
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #10116 Tuleap Releases 9.8 Delivered 2017-05-29 12:23 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #10202

    Git commit

    tuleap/tuleap/stable

    Merge commit 'refs/changes/50/8350/2' of ssh://gerrit.tuleap.net:29418/tuleap into HEAD aac80ba03a
    User avatar Yannis ROSSETTO (rossettoy) , 2017-05-10 09:04
    request #10202: Duplicate key error while importing Gitolite logs in the new format 85b3535461
    User avatar Thomas Gerbet (tgerbet) , 2017-05-09 22:39
    Display settings

    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
    Seif Eddine Gamoudi (gamoudis)2017-05-10 12:20
    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