Bug 902015

Summary: [abrt] gourmet-0.15.9-4.fc17: default.py:331:do_execute:OperationalError: (OperationalError) table pantry already exists u'\nCREATE TABLE pantry (\n\tingkey TEXT NOT NULL, \n\tpantry BOOLEAN, \n\tPRIMARY KEY (ingkey), \n\tCHECK (pantry IN (0, ...
Product: [Fedora] Fedora Reporter: Woody <juanwoody>
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: i686   
OS: Unspecified   
Whiteboard: abrt_hash:6219d776abd3ce7ce68eca29977832aa72569557
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-08-01 01:59:03 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: environ
none
File: executable
none
File: dso_list
none
File: smolt_data
none
File: core_backtrace none

Description Woody 2013-01-20 13:15:01 UTC 
Version-Release number of selected component:
gourmet-0.15.9-4.fc17

Additional info:
libreport version: 2.0.18
abrt_version:   2.0.18
cmdline:        /usr/bin/python /usr/bin/gourmet
kernel:         3.6.11-1.fc17.i686

backtrace:
:default.py:331:do_execute:OperationalError: (OperationalError) table pantry already exists u'\nCREATE TABLE pantry (\n\tingkey TEXT NOT NULL, \n\tpantry BOOLEAN, \n\tPRIMARY KEY (ingkey), \n\tCHECK (pantry IN (0, 1))\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/lib/python2.7/site-packages/sqlalchemy/schema.py", line 2571, in create_all
:    tables=tables)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2302, in _run_visitor
:    conn._run_visitor(visitorcallable, element, **kwargs)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1972, in _run_visitor
:    **kwargs).traverse_single(element)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 106, in traverse_single
:    return meth(obj, **kw)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/ddl.py", line 67, in visit_metadata
:    self.traverse_single(table, create_ok=True)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 106, in traverse_single
:    return meth(obj, **kw)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/ddl.py", line 86, in visit_table
:    self.connection.execute(schema.CreateTable(table))
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
:    params)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1542, in _execute_ddl
:    compiled
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
:    context)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
:    context)
:  File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
:    cursor.execute(statement, parameters)
:OperationalError: (OperationalError) table pantry already exists u'\nCREATE TABLE pantry (\n\tingkey TEXT NOT NULL, \n\tpantry BOOLEAN, \n\tPRIMARY KEY (ingkey), \n\tCHECK (pantry IN (0, 1))\n)\n\n' ()
:
:Local variables in innermost frame:
:cursor: <sqlite3.Cursor object at 0xa207d60>
:self: <sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite object at 0xa20eaec>
:statement: u'\nCREATE TABLE pantry (\n\tingkey TEXT NOT NULL, \n\tpantry BOOLEAN, \n\tPRIMARY KEY (ingkey), \n\tCHECK (pantry IN (0, 1))\n)\n\n'
:parameters: ()
:context: <sqlalchemy.dialects.sqlite.base.SQLiteExecutionContext object at 0xa2937ec>
Comment 1 Woody 2013-01-20 13:15:06 UTC 
Created attachment 683543 [details]
File: environ
Comment 2 Woody 2013-01-20 13:15:07 UTC 
Created attachment 683544 [details]
File: executable
Comment 3 Woody 2013-01-20 13:15:09 UTC 
Created attachment 683545 [details]
File: dso_list
Comment 4 Woody 2013-01-20 13:15:10 UTC 
Created attachment 683546 [details]
File: smolt_data
Comment 5 Woody 2013-01-20 13:15:12 UTC 
Created attachment 683547 [details]
File: core_backtrace
Comment 6 Fedora End Of Life 2013-07-03 23:21:45 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 7 Fedora End Of Life 2013-08-01 01:59:07 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.