Bug 872371

Summary: [abrt] gourmet-0.15.9-4.fc17: default.py:331:do_execute:IntegrityError: (IntegrityError) shopcats.ingkey may not be NULL u'INSERT INTO shopcats DEFAULT VALUES' ()
Product: [Fedora] Fedora Reporter: Adelino Saldanha, Eng. <adelinuz>
Component: gourmetAssignee: Jef Spaleta <jspaleta>
Status: CLOSED WONTFIX QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 17CC: jeff.raber, jspaleta
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Unspecified   
Whiteboard: abrt_hash:5792250189738289ab592413a6eef450dd6311de
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-08-01 01:58:06 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: dso_list
none
File: environ
none
File: smolt_data
none
File: core_backtrace none

Description Adelino Saldanha, Eng. 2012-11-01 23:36:29 UTC 
Version-Release number of selected component:
gourmet-0.15.9-4.fc17

Additional info:
libreport version: 2.0.16
abrt_version:   2.0.16
cmdline:        /usr/bin/python /usr/bin/gourmet
kernel:         3.6.3-1.fc17.x86_64

backtrace:
:default.py:331:do_execute:IntegrityError: (IntegrityError) shopcats.ingkey may not be NULL u'INSERT INTO shopcats DEFAULT VALUES' ()
:
:Traceback (most recent call last):
:  File "/usr/bin/gourmet", line 35, in <module>
:    gourmet.GourmetRecipeManager.startGUI()
:  File "/usr/lib/python2.7/site-packages/gourmet/GourmetRecipeManager.py", line 715, in startGUI
:    r=RecGui(splash_label=splash.label)
:  File "/usr/lib/python2.7/site-packages/gourmet/GourmetRecipeManager.py", line 918, in __init__
:    GourmetApplication.__init__(self, splash_label=splash_label)
:  File "/usr/lib/python2.7/site-packages/gourmet/GourmetRecipeManager.py", line 116, in __init__
:    self.setup_shopping()
:  File "/usr/lib/python2.7/site-packages/gourmet/GourmetRecipeManager.py", line 228, in setup_shopping
:    self.sl = shopgui.ShopGui()
:  File "/usr/lib/python2.7/site-packages/gourmet/shopgui.py", line 540, in __init__
:    ShoppingList.__init__(self)
:  File "/usr/lib/python2.7/site-packages/gourmet/shopping.py", line 266, in __init__
:    self.data,self.pantry=self.grabIngsFromRecs([])
:  File "/usr/lib/python2.7/site-packages/gourmet/shopping.py", line 282, in grabIngsFromRecs
:    return self.organize_list(self.lst)
:  File "/usr/lib/python2.7/site-packages/gourmet/shopping.py", line 285, in organize_list
:    self.sh = self.get_shopper(lst)
:  File "/usr/lib/python2.7/site-packages/gourmet/shopgui.py", line 572, in get_shopper
:    return recipeManager.DatabaseShopper(lst, self.rd)
:  File "/usr/lib/python2.7/site-packages/gourmet/recipeManager.py", line 25, in __init__
:    shopping.Shopper.__init__(self,lst)
:  File "/usr/lib/python2.7/site-packages/gourmet/shopping.py", line 46, in __init__
:    self.init_orgdic()
:  File "/usr/lib/python2.7/site-packages/gourmet/recipeManager.py", line 37, in init_orgdic
:    self.orgdic.initialize(dic)
:  File "/usr/lib/python2.7/site-packages/gourmet/backends/db.py", line 2006, in initialize
:    self.vw.insert().execute(*dics)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/expression.py", line 2826, in execute
:    return e._execute_clauseelement(self, multiparams, params)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2454, in _execute_clauseelement
:    return connection._execute_clauseelement(elem, multiparams, params)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
:    compiled_sql, distilled_params
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
:    context)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
:    context)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
:    cursor.execute(statement, parameters)
:IntegrityError: (IntegrityError) shopcats.ingkey may not be NULL u'INSERT INTO shopcats DEFAULT VALUES' ()
:
:Local variables in innermost frame:
:cursor: <sqlite3.Cursor object at 0x3143880>
:self: <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x2fe0550>
:statement: u'INSERT INTO shopcats DEFAULT VALUES'
:parameters: ()
:context: <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x3154950>
Comment 1 Adelino Saldanha, Eng. 2012-11-01 23:36:33 UTC 
Created attachment 636859 [details]
File: dso_list
Comment 2 Adelino Saldanha, Eng. 2012-11-01 23:36:35 UTC 
Created attachment 636860 [details]
File: environ
Comment 3 Adelino Saldanha, Eng. 2012-11-01 23:36:37 UTC 
Created attachment 636861 [details]
File: smolt_data
Comment 4 Adelino Saldanha, Eng. 2012-11-01 23:36:39 UTC 
Created attachment 636862 [details]
File: core_backtrace
Comment 5 Fedora End Of Life 2013-07-03 23:21:15 UTC 
This message is a reminder that Fedora 17 is nearing its end of life.
Approximately 4 (four) weeks from now Fedora will stop maintaining
and issuing updates for Fedora 17. It is Fedora's policy to close all
bug reports from releases that are no longer maintained. At that time
this bug will be closed as WONTFIX if it remains open with a Fedora 
'version' of '17'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version' 
to a later Fedora version prior to Fedora 17's end of life.

Bug Reporter:  Thank you for reporting this issue and we are sorry that 
we may not be able to fix it before Fedora 17 is end of life. If you 
would still like  to see this bug fixed and are able to reproduce it 
against a later version  of Fedora, you are encouraged  change the 
'version' to a later Fedora version prior to Fedora 17's end of life.

Although we aim to fix as many bugs as possible during every release's 
lifetime, sometimes those efforts are overtaken by events. Often a 
more recent Fedora release includes newer upstream software that fixes 
bugs or makes them obsolete.
Comment 6 Fedora End Of Life 2013-08-01 01:58:10 UTC 
Fedora 17 changed to end-of-life (EOL) status on 2013-07-30. Fedora 17 is 
no longer maintained, which means that it will not receive any further 
security or bug fix updates. As a result we are closing this bug.

If you can reproduce this bug against a currently maintained version of 
Fedora please feel free to reopen this bug against that version.

Thank you for reporting this bug and we are sorry it could not be fixed.