Bug 797572 - [abrt] gourmet-0.15.9-1.fc16: default.py:330:do_execute:OperationalError: (OperationalError) table usda_weights already exists u'\nCREATE TABLE usda_weights (\n\tid INTEGER NOT NULL, \n\tndbno INTEGER, \n\tseq FLOAT, \n\tamount FLOAT, \n\tunit VARCHAR(80)
Summary: [abrt] gourmet-0.15.9-1.fc16: default.py:330:do_execute:OperationalError: (Op...
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Fedora
Classification: Fedora
Component: gourmet
Version: 16
Hardware: x86_64
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Jef Spaleta
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard: abrt_hash:85adcc190190c313e5d062f1ed0...
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-02-26 19:37 UTC by Robert Kief
Modified: 2013-02-13 15:25 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-02-13 15:25:14 UTC
Type: ---


Attachments (Terms of Use)

Description Robert Kief 2012-02-26 19:37:55 UTC
libreport version: 2.0.8
abrt_version:   2.0.7
cmdline:        /usr/bin/python /usr/bin/gourmet
executable:     /usr/bin/gourmet
kernel:         3.2.7-1.fc16.x86_64
reason:         default.py:330:do_execute:OperationalError: (OperationalError) table usda_weights already exists u'\nCREATE TABLE usda_weights (\n\tid INTEGER NOT NULL, \n\tndbno INTEGER, \n\tseq FLOAT, \n\tamount FLOAT, \n\tunit VARCHAR(80), \n\tgramwt FLOAT, \n\tndata INTEGER, \n\tstdev FLOAT, \n\tPRIMARY KEY (id)\n)\n\n' ()
time:           Fri 24 Feb 2012 04:37:20 PM CST
uid:            1000
username:       rk00253

backtrace:
:default.py:330:do_execute:OperationalError: (OperationalError) table usda_weights already exists u'\nCREATE TABLE usda_weights (\n\tid INTEGER NOT NULL, \n\tndbno INTEGER, \n\tseq FLOAT, \n\tamount FLOAT, \n\tunit VARCHAR(80), \n\tgramwt FLOAT, \n\tndata INTEGER, \n\tstdev FLOAT, \n\tPRIMARY KEY (id)\n)\n\n' ()
:
: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 114, in __init__
:    self.setup_recipes() # Setup recipe database
:  File "/usr/lib/python2.7/site-packages/gourmet/GourmetRecipeManager.py", line 204, in setup_recipes
:    self.rd = recipeManager.default_rec_manager()
:  File "/usr/lib/python2.7/site-packages/gourmet/recipeManager.py", line 131, in default_rec_manager
:    return get_recipe_manager(**dbargs)
:  File "/usr/lib/python2.7/site-packages/gourmet/recipeManager.py", line 126, in get_recipe_manager
:    return RecipeManager(**args)
:  File "/usr/lib/python2.7/site-packages/gourmet/backends/db.py", line 1769, in __init__
:    RecData.__init__(self,*args,**kwargs)
:  File "/usr/lib/python2.7/site-packages/gourmet/backends/db.py", line 164, in __init__
:    self.metadata.create_all()
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/schema.py", line 2535, in create_all
:    tables=tables)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2234, in _run_visitor
:    conn._run_visitor(visitorcallable, element, **kwargs)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1904, in _run_visitor
:    **kwargs).traverse_single(element)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in traverse_single
:    return meth(obj, **kw)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/ddl.py", line 67, in visit_metadata
:    self.traverse_single(table, create_ok=True)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 86, in traverse_single
:    return meth(obj, **kw)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/ddl.py", line 86, in visit_table
:    self.connection.execute(schema.CreateTable(table))
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1405, in execute
:    params)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1496, in _execute_ddl
:    compiled
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1646, in _execute_context
:    context)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_context
:    context)
:  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 330, in do_execute
:    cursor.execute(statement, parameters)
:OperationalError: (OperationalError) table usda_weights already exists u'\nCREATE TABLE usda_weights (\n\tid INTEGER NOT NULL, \n\tndbno INTEGER, \n\tseq FLOAT, \n\tamount FLOAT, \n\tunit VARCHAR(80), \n\tgramwt FLOAT, \n\tndata INTEGER, \n\tstdev FLOAT, \n\tPRIMARY KEY (id)\n)\n\n' ()
:
:Local variables in innermost frame:
:cursor: <pysqlite2.dbapi2.Cursor object at 0x2e84190>
:self: <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0x2cfd4d0>
:statement: u'\nCREATE TABLE usda_weights (\n\tid INTEGER NOT NULL, \n\tndbno INTEGER, \n\tseq FLOAT, \n\tamount FLOAT, \n\tunit VARCHAR(80), \n\tgramwt FLOAT, \n\tndata INTEGER, \n\tstdev FLOAT, \n\tPRIMARY KEY (id)\n)\n\n'
:parameters: ()
:context: <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0x2e82c90>

smolt_data:
:
:
:General
:=================================
:UUID: f5086c99-2801-4221-8b8f-22c01249524c
:OS: Fedora release 16 (Verne)
:Default run level: Unknown
:Language: en_US.UTF-8
:Platform: x86_64
:BogoMIPS: 5666.23
:CPU Vendor: GenuineIntel
:CPU Model: Intel(R) Core(TM)2 Quad  CPU   Q9550  @ 2.83GHz
:CPU Stepping: 7
:CPU Family: 6
:CPU Model Num: 23
:Number of CPUs: 4
:CPU Speed: 2834
:System Memory: 7986
:System Swap: 10047
:Vendor: Gigabyte Technology Co., Ltd.
:System: X48-DQ6 
:Form factor: Desktop
:Kernel: 3.2.7-1.fc16.x86_64
:SELinux Enabled: 1
:SELinux Policy: targeted
:SELinux Enforce: Enforcing
:MythTV Remote: Unknown
:MythTV Role: Unknown
:MythTV Theme: Unknown
:MythTV Plugin: 
:MythTV Tuner: -1
:
:
:Devices
:=================================
:(32902:10729:5208:20480) pci, pcieport, PCI/PCI, 82X38/X48 Express Host-Secondary PCI Express Bridge
:(32902:10720:5208:20480) pci, x38_edac, HOST/PCI, 82X38/X48 Express DRAM Controller
:(32902:10721:5208:20480) pci, pcieport, PCI/PCI, 82X38/X48 Express Host-Primary PCI Express Bridge
:(6523:9059:5208:45056) pci, ahci, STORAGE, GA-EP45-DS5 Motherboard
:(6523:9059:5208:45056) pci, pata_jmicron, STORAGE, GA-EP45-DS5 Motherboard
:(32902:10544:5208:20481) pci, i801_smbus, SERIAL, 82801I (ICH9 Family) SMBus Controller
:(32902:10528:5208:45058) pci, ata_piix, STORAGE, 82801IR/IO/IH (ICH9R/DO/DH) 4 port SATA IDE Controller
:(32902:10518:5208:20481) pci, None, PCI/ISA, 82801IR (ICH9R) LPC Interface Controller
:(32902:10534:5208:45058) pci, ata_piix, STORAGE, 82801I (ICH9 Family) 2 port SATA IDE Controller
:(32902:9294:5208:20480) pci, None, PCI/PCI, GA-EP45-DS5 Motherboard
:(32902:10549:5208:20484) pci, uhci_hcd, USB, 82801I (ICH9 Family) USB UHCI Controller #2
:(32902:10548:5208:20484) pci, uhci_hcd, USB, 82801I (ICH9 Family) USB UHCI Controller #1
:(32902:10553:5208:20484) pci, uhci_hcd, USB, 82801I (ICH9 Family) USB UHCI Controller #6
:(32902:10550:5208:20484) pci, uhci_hcd, USB, 82801I (ICH9 Family) USB UHCI Controller #3
:(32902:10554:5208:20486) pci, ehci_hcd, USB, 82801I (ICH9 Family) USB2 EHCI Controller #1
:(32902:10556:5208:20486) pci, ehci_hcd, USB, 82801I (ICH9 Family) USB2 EHCI Controller #2
:(32902:10566:5208:20481) pci, pcieport, PCI/PCI, 82801I (ICH9 Family) PCI Express Port 4
:(32902:10560:5208:20481) pci, pcieport, PCI/PCI, 82801I (ICH9 Family) PCI Express Port 1
:(32902:10568:5208:20481) pci, pcieport, PCI/PCI, 82801I (ICH9 Family) PCI Express Port 5
:(32902:10558:5208:40994) pci, snd_hda_intel, MULTIMEDIA, 82801I (ICH9 Family) HD Audio Controller
:(4332:33128:5208:57344) pci, r8169, ETHERNET, GA-EP45-DS5 Motherboard
:(32902:10551:5208:20484) pci, uhci_hcd, USB, 82801I (ICH9 Family) USB UHCI Controller #4
:(32902:10552:5208:20484) pci, uhci_hcd, USB, 82801I (ICH9 Family) USB UHCI Controller #5
:(4098:43576:5963:43576) pci, snd_hda_intel, MULTIMEDIA, R700 Audio Device [Radeon HD 4000 Series]
:(4098:38223:5963:57606) pci, radeon, VIDEO, RV710 [Radeon HD 4350]
:(32902:10570:5208:20481) pci, pcieport, PCI/PCI, 82801I (ICH9 Family) PCI Express Port 6
:(4332:33128:5208:57344) pci, r8169, ETHERNET, GA-EP45-DS5 Motherboard
:(4172:32804:5208:4096) pci, firewire_ohci, FIREWIRE, GA-EP45-DS5 Motherboard
:
:
:Filesystem Information
:=================================
:device mtpt type bsize frsize blocks bfree bavail file ffree favail
:-------------------------------------------------------------------
:/dev/mapper/vg_homenet06-lv_root / ext4 4096 4096 13081819 8292357 7636997 3276800 2914641 2914641
:/dev/sda2 /boot ext4 1024 1024 508745 411112 385512 128016 127785 127785
:/dev/mapper/vg_homenet06-lv_home /home ext4 4096 4096 472110344 396646784 373018599 118145024 118044504 118044504
:

Comment 1 Fedora End Of Life 2013-01-16 14:24:43 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 2 Fedora End Of Life 2013-02-13 15:25:16 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.


Note You need to log in before you can comment on or make changes to this bug.