Bug 1634305

Summary: [abrt] dnf: __init__(): transaction.py:729:__init__:RuntimeError: C++ std::exception: Step: UNIQUE constraint failed: comps_environment_group.environment_id, comps_environment_group.groupid in
Product: [Fedora] Fedora Reporter: Ankur Sinha (FranciscoD) <sanjay.ankur>
Component: dnfAssignee: rpm-software-management
Status: CLOSED DUPLICATE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 29CC: awilliam, dmach, mblaha, mhatina, packaging-team-maint, rpm-software-management, vmukhame
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Unspecified   
URL: https://retrace.fedoraproject.org/faf/reports/bthash/ecb677312b921f5915a4f8c8467d4a11f922ade6
Whiteboard: abrt_hash:bb15e6dffd809dad808602885aa9729b0e37c75c;VARIANT_ID=workstation;
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-09-30 16:30:53 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
File: _var_log_dnf.log
none
File: backtrace
none
File: cgroup
none
File: cpuinfo
none
File: dnf-makecache.log
none
File: environ
none
File: mountinfo
none
File: namespaces
none
File: open_fds none

Description Ankur Sinha (FranciscoD) 2018-09-29 15:51:29 UTC
Description of problem:
I ran `sudo dnf list extras`.

Version-Release number of selected component:
dnf-3.5.1-1.fc29

Additional info:
reporter:       libreport-2.9.5
cmdline:        /usr/bin/python3 /usr/bin/dnf list extras
crash_function: __init__
exception_type: RuntimeError
executable:     /usr/bin/dnf
interpreter:    python3-3.7.0-9.fc29.x86_64
kernel:         4.18.5-300.fc29.x86_64
runlevel:       N 5
type:           Python3
uid:            0

Truncated backtrace:
transaction.py:729:__init__:RuntimeError: C++ std::exception: Step: UNIQUE constraint failed: comps_environment_group.environment_id, comps_environment_group.groupid in

        INSERT INTO
            comps_environment_group (
                environment_id,
                groupid,
                installed,
                group_type
            )
        VALUES
            (43799, 'base-x', 1, 4)
    

Traceback (most recent call last):
  File "/usr/bin/dnf", line 58, in <module>
    main.user_main(sys.argv[1:], exit_code=True)
  File "/usr/lib/python3.7/site-packages/dnf/cli/main.py", line 179, in user_main
    errcode = main(args)
  File "/usr/lib/python3.7/site-packages/dnf/cli/main.py", line 64, in main
    return _main(base, args, cli_class, option_parser_class)
  File "/usr/lib/python3.7/site-packages/dnf/cli/main.py", line 99, in _main
    return cli_run(cli, base)
  File "/usr/lib/python3.7/site-packages/dnf/cli/main.py", line 115, in cli_run
    cli.run()
  File "/usr/lib/python3.7/site-packages/dnf/cli/cli.py", line 1049, in run
    return self.command.run()
  File "/usr/lib/python3.7/site-packages/dnf/cli/commands/__init__.py", line 232, in run
    self.opts.packages)
  File "/usr/lib/python3.7/site-packages/dnf/cli/cli.py", line 403, in output_packages
    columns = _list_cmd_calc_columns(self.output, ypl)
  File "/usr/lib/python3.7/site-packages/dnf/cli/cli.py", line 105, in _list_cmd_calc_columns
    _add_pkg_simple_list_lens(data, pkg)
  File "/usr/lib/python3.7/site-packages/dnf/cli/cli.py", line 93, in _add_pkg_simple_list_lens
    rid = len(pkg._from_repo)
  File "/usr/lib/python3.7/site-packages/dnf/package.py", line 84, in _from_repo
    pkgrepo = self.base.history.repo(self)
  File "/usr/lib/python3.7/site-packages/dnf/db/history.py", line 362, in repo
    return self.swdb.getRPMRepo(str(pkg))
  File "/usr/lib/python3.7/site-packages/dnf/db/history.py", line 291, in swdb
    self._swdb = libdnf.transaction.Swdb(self.dbpath)
  File "/usr/lib64/python3.7/site-packages/libdnf/transaction.py", line 729, in __init__
    this = _transaction.new_Swdb(*args)
RuntimeError: C++ std::exception: Step: UNIQUE constraint failed: comps_environment_group.environment_id, comps_environment_group.groupid in

        INSERT INTO
            comps_environment_group (
                environment_id,
                groupid,
                installed,
                group_type
            )
        VALUES
            (43799, 'base-x', 1, 4)
    

Local variables in innermost frame:
self: <libdnf.transaction.Swdb;  >
args: ('/var/lib/dnf/history.sqlite',)

Comment 1 Ankur Sinha (FranciscoD) 2018-09-29 15:51:51 UTC
Created attachment 1488430 [details]
File: _var_log_dnf.log

Comment 2 Ankur Sinha (FranciscoD) 2018-09-29 15:51:53 UTC
Created attachment 1488431 [details]
File: backtrace

Comment 3 Ankur Sinha (FranciscoD) 2018-09-29 15:51:54 UTC
Created attachment 1488432 [details]
File: cgroup

Comment 4 Ankur Sinha (FranciscoD) 2018-09-29 15:51:56 UTC
Created attachment 1488433 [details]
File: cpuinfo

Comment 5 Ankur Sinha (FranciscoD) 2018-09-29 15:51:58 UTC
Created attachment 1488434 [details]
File: dnf-makecache.log

Comment 6 Ankur Sinha (FranciscoD) 2018-09-29 15:52:00 UTC
Created attachment 1488435 [details]
File: environ

Comment 7 Ankur Sinha (FranciscoD) 2018-09-29 15:52:01 UTC
Created attachment 1488436 [details]
File: mountinfo

Comment 8 Ankur Sinha (FranciscoD) 2018-09-29 15:52:02 UTC
Created attachment 1488437 [details]
File: namespaces

Comment 9 Ankur Sinha (FranciscoD) 2018-09-29 15:52:04 UTC
Created attachment 1488438 [details]
File: open_fds

Comment 10 Adam Williamson 2018-09-30 16:30:53 UTC

*** This bug has been marked as a duplicate of bug 1596827 ***