gourmet recipe manager crashes loading nutritional data

[Esther]

Just after launching gourmet recipe manager, the window pops up stating it is "parsing nutritional data". This changes to another window which states the nutritional data is loading. The progress indicator freezes at 100 of 7413 items. I am unable to select the pause or stop options making my recipes inaccessible. I am able to click the X button which brings up a crash window which forces the application to close.

I would have expected the nutritional info to be processed quickly so that I can access my recipes. Either that or I should have been able to stop the action. As an aside, why does the software do this in the first place? It creates a usability problem...

I am using Xubuntu 12.04.

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: gourmet 0.15.9-1ubuntu1
ProcVersionSignature: Ubuntu 3.2.0-29.46-generic 3.2.24
Uname: Linux 3.2.0-29-generic i686
NonfreeKernelModules: fglrx
ApportVersion: 2.0.1-0ubuntu12
Architecture: i386
Date: Thu Aug 30 11:31:27 2012
InstallationMedia: Xubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012)
PackageArchitecture: all
ProcEnviron:
 LANGUAGE=en_US:en
 PATH=(custom, no user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: gourmet
UpgradeStatus: Upgraded to precise on 2012-04-28 (123 days ago)

[Esther (melanes)]

Just an update. Originally I thought the program had crashed because the progress bar hadn't moved at all. But I left the program open and discovered, it is just really, really slow. So far, Gourmet Recipe Manager has been loading the nutritional data for about 8 hours and is now up to 5300 of 7413 entries.

[Esther (melanes)]

Another update. I ran gourmet recipe manager all night and it finally finished loading the nutritional data. I then shutdown and restarted the program several times and it started right up without the nutritional data needing to be loaded. Perhaps a bug in the nutritional plugin after an update? In any event, I don't think it should take 24 hours to load nutritional data.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Mark Preston (emarkpreston)]

I have the same problem:

mark@Lexington:~$ gourmet
sqlite:////home/mark/.gourmet/recipes.db
RECREATE USDA WEIGHTS TABLE
Attempting to alter usda_weights <bound method NutritionDataPlugin.setup_usda_weights_table of <nutritional_information.data_plugin.NutritionDataPlugin instance at 0x9259bcc>> {} ['ndbno', 'seq', 'amount', 'unit', 'gramwt', 'ndata', 'stdev']
Traceback (most recent call last):
  File "/usr/share/gourmet/gourmet/backends/db.py", line 931, in alter_table
    self.db.execute('ALTER TABLE %(t)s RENAME TO %(t)s_temp'%{'t':table_name})
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2297, in execute
    return connection.execute(statement, *multiparams, **params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in execute
    params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1582, in _execute_text
    statement, parameters
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1639, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 330, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) there is already another table or index with this name: usda_weights_temp 'ALTER TABLE usda_weights RENAME TO usda_weights_temp' ()
Problem updating plugin <nutritional_information.data_plugin.NutritionDataPlugin instance at 0x9259bcc> nutritondata
Traceback (most recent call last):
  File "/usr/bin/gourmet", line 35, in <module>
    gourmet.GourmetRecipeManager.startGUI()
  File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 715, in startGUI
    r=RecGui(splash_label=splash.label)
  File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 918, in __init__
    GourmetApplication.__init__(self, splash_label=splash_label)
  File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 114, in __init__
    self.setup_recipes() # Setup recipe database
  File "/usr/share/gourmet/gourmet/GourmetRecipeManager.py", line 204, in setup_recipes
    self.rd = recipeManager.default_rec_manager()
  File "/usr/share/gourmet/gourmet/recipeManager.py", line 131, in default_rec_manager
    return get_recipe_manager(**dbargs)
  File "/usr/share/gourmet/gourmet/recipeManager.py", line 126, in get_recipe_manager
    return RecipeManager(**args)
  File "/usr/share/gourmet/gourmet/backends/db.py", line 1769, in __init__
    RecData.__init__(self,*args,**kwargs)
  File "/usr/share/gourmet/gourmet/backends/db.py", line 165, in __init__
    self.update_version_info(gourmet.version.version)
  File "/usr/share/gourmet/gourmet/backends/db.py", line 598, in update_version_info
    (current_super,current_major,current_minor)
  File "/usr/share/gourmet/gourmet/backends/db.py", line 640, in update_plugin_version
    plugin_current = plugin.version,
  File "/usr/share/gourmet/gourmet/plugins/nutritional_information/data_plugin.py", line 68, in update_version
    [name for lname,name,typ in parser_data.WEIGHT_FIELDS])
  File "/usr/share/gourmet...