Bug 770763

Summary: [abrt] gourmet-0.15.9-1.fc16: default.py:330:do_execute:IntegrityError: (IntegrityError) shopcats.ingkey may not be NULL u'INSERT INTO shopcats DEFAULT VALUES' ()
Product: [Fedora] Fedora Reporter: Miguel Sousa <migueljorgesousa>
Component: gourmetAssignee: Jef Spaleta <jspaleta>
Status: CLOSED WONTFIX QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 16CC: hc00000, jeff.raber, jspaleta
Target Milestone: ---   
Target Release: ---   
Hardware: i686   
OS: Unspecified   
Whiteboard: abrt_hash:65444d78e1214dde1c8dbd88b6f43444a452e27a
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-02-13 15:23:55 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Miguel Sousa 2011-12-29 01:44:54 UTC
libreport version: 2.0.8
abrt_version:   2.0.7
cmdline:        /usr/bin/python /usr/bin/gourmet
comment:        On open in KDE
executable:     /usr/bin/gourmet
kernel:         3.1.6-1.fc16.i686
reason:         default.py:330:do_execute:IntegrityError: (IntegrityError) shopcats.ingkey may not be NULL u'INSERT INTO shopcats DEFAULT VALUES' ()
time:           Qui 29 Dez 2011 01:25:45 WET
uid:            500
username:       miguel

backtrace:
:default.py:330: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/lib/python2.7/site-packages/sqlalchemy/sql/expression.py", line 2667, in execute
:    return e._execute_clauseelement(self, multiparams, params)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2298, in _execute_clauseelement
:    return connection._execute_clauseelement(elem, multiparams, params)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1532, in _execute_clauseelement
:    compiled_sql, distilled_params
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_context
:    context)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1633, in _execute_context
:    context)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 330, 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: <pysqlite2.dbapi2.Cursor object at 0xa297ef0>
:self: <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0xa1ef62c>
:statement: u'INSERT INTO shopcats DEFAULT VALUES'
:parameters: ()
:context: <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0xa2da9ec>

event_log:
:2011-12-29-01:42:42> Smolt profile successfully saved
:2011-12-29-01:43:23> A iniciar sessão no Bugzilla em https://bugzilla.redhat.com
:2011-12-29-01:43:25  fatal: XML-RPC(300): RPC failed at server.  The username or password you entered is not valid.
:2011-12-29-01:43:25* (exited with 1)
:2011-12-29-01:43:48> Smolt profile successfully saved

smolt_data:
:
:
:Geral
:=================================
:UUID: e29f996e-7833-4c3e-85b4-e7748c5ac1fc
:SO: Fedora release 16 (Verne)
:Nível de execução por omissão: 5
:Língua: pt_PT.utf8
:Plataforma: i686
:BogoMIPS: 4419.32
:Fabricante do CPU: AuthenticAMD
:Modelo do CPU: AMD Sempron(tm) Processor 3800+
:Versão do CPU: 2
:Família do CPU: 15
:Número do modelo do CPU: 79
:Número de CPUs: 1
:Velocidade do CPU: 2200
:Memória do sistema: 875
:Swap do sistema: 1759
:Fabricante: FOXCONN
:Sistema: RS690M2MA 0A
:Dimensões: Desktop
:Kernel: 3.1.6-1.fc16.i686
:SELinux activo: 1
:Política do SELinux: targeted
:SELinux Obrigatório: Enforcing
:MythTV Remote: Unknown
:MythTV Role: Unknown
:MythTV Theme: Unknown
:MythTV Plugin: 
:MythTV Tuner: -1
:
:
:Dispositivos
:=================================
:(4332:33081:4187:3213) pci, 8139too, ETHERNET, RTL-8139/8139C/8139C+
:(4098:17292:4187:3213) pci, pata_atiixp, STORAGE, SB600 IDE
:(4098:17285:4187:3213) pci, piix4_smbus, SERIAL, SBx00 SMBus Controller
:(4098:17293:4187:3213) pci, None, PCI/ISA, SB600 PCI to LPC Bridge
:(4098:17283:4187:3212) pci, snd_hda_intel, MULTIMEDIA, SBx00 Azalia (Intel HDA)
:(4098:17284:0:0) pci, None, PCI/PCI, SBx00 PCI to PCI Bridge
:(4098:17286:4187:3213) pci, ehci_hcd, USB, SB600 USB Controller (EHCI)
:(4098:30994:4098:30992) pci, None, PCI/PCI, RS690 PCI to PCI Bridge (Internal gfx)
:(4098:31006:4187:3213) pci, radeon, VIDEO, RS690 [Radeon X1200 Series]
:(4098:31004:4187:31004) pci, None, VIDEO, N/A
:(4130:4353:0:0) pci, None, HOST/PCI, K8 [Athlon64/Opteron] Address Map
:(4130:4352:0:0) pci, None, HOST/PCI, K8 [Athlon64/Opteron] HyperTransport Technology Configuration
:(4130:4355:0:0) pci, k8temp, HOST/PCI, K8 [Athlon64/Opteron] Miscellaneous Control
:(4130:4354:0:0) pci, None, HOST/PCI, K8 [Athlon64/Opteron] DRAM Controller
:(4098:17289:4187:3213) pci, ohci_hcd, USB, SB600 USB (OHCI2)
:(4098:17290:4187:3213) pci, ohci_hcd, USB, SB600 USB (OHCI3)
:(4098:30992:4098:30992) pci, None, HOST/PCI, RS690 Host Bridge
:(4098:17288:4187:3213) pci, ohci_hcd, USB, SB600 USB (OHCI1)
:(4098:17287:4187:3213) pci, ohci_hcd, USB, SB600 USB (OHCI0)
:(4098:17291:4187:3213) pci, ohci_hcd, USB, SB600 USB (OHCI4)
:(4098:17280:4187:3213) pci, ahci, STORAGE, SB600 Non-Raid-5 SATA
:
:
:Informação do sistema de ficheiros
:=================================
:device mtpt type bsize frsize blocks bfree bavail file ffree favail
:-------------------------------------------------------------------
:/dev/mapper/vg_pcfedora-lv_root / ext4 4096 4096 12901535 8644103 7988743 3276800 2711181 2711181
:/dev/sda1 /boot ext4 1024 1024 495844 409647 384047 128016 127771 127771
:/dev/mapper/vg_pcfedora-lv_home /home ext4 4096 4096 24980346 13140642 11871702 6348800 6309803 6309803
:

Comment 1 Miguel Sousa 2011-12-29 01:52:55 UTC
on open in kde

rating: (null)
Package: gourmet-0.15.9-1.fc16
Architecture: i686
OS Release: Fedora release 16 (Verne)

Comment 2 Fedora End Of Life 2013-01-16 14:24:18 UTC
This message is a reminder that Fedora 16 is nearing its end of life.
Approximately 4 (four) weeks from now Fedora will stop maintaining
and issuing updates for Fedora 16. 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 '16'.

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 16'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 16 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 to click on 
"Clone This Bug" and open it against that version of Fedora.

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.

The process we are following is described here: 
http://fedoraproject.org/wiki/BugZappers/HouseKeeping

Comment 3 Fedora End Of Life 2013-02-13 15:23:57 UTC
Fedora 16 changed to end-of-life (EOL) status on 2013-02-12. Fedora 16 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.