search

weecology / retriever

Quickly download, clean up, and install public datasets into a database management system
http://data-retriever.org
Other
306 stars 132 forks source link

Retriever crashes when trying to reimport some databases in MS Access #66

Closed ethanwhite closed 11 years ago

ethanwhite commented 12 years ago

To replicate:

  1. Create an empty Access database
  2. Start the Retriever and install either Portal or Gentry
  3. Close the Retriever
  4. Open the Retriever and try to reinstall the dataset

This failure does not occur for all datasets. Portal and Gentry are the only two I have confirmed. It is not strictly a multi-table issues as Adler et al. 2007 does not appear to have this problem.

Access databases do remained locked after the Retriever closes, but this does not appear to be the problem as opening and closing the database to get rid of the lock does not solve the issue.

The error appears to occur about the time the first table is dropped and recreated both based on timing and the fact that the first table to be imported is left blank following the failure.

This is not an issue for SQLite or CSV. I have not checked it on MySQL or PostgreSQL.

bendmorris commented 11 years ago

This is no longer happening for me. It may have been incidentally fixed when I switched from pyodbc to pypyodbc.

ethanwhite commented 11 years ago

I can confirm that this now works both building from source and using the .exe.