{"action":"created","issue":{"url":"https://api.github.com/repos/quantopian/zipline/issues/1228","repository_url":"https://api.github.com/repos/quantopian/zipline","labels_url":"https://api.github.com/repos/quantopian/zipline/issues/1228/labels{/name}","comments_url":"https://api.github.com/repos/quantopian/zipline/issues/1228/comments","events_url":"https://api.github.com/repos/quantopian/zipline/issues/1228/events","html_url":"https://github.com/quantopian/zipline/issues/1228","id":156354789,"number":1228,"title":"yahoo bundle causes SQLiteAdjustmentWriter error - sqlite3.OperationalError: unable to open database file","user":{"login":"cwengc","id":5105334,"avatar_url":"https://avatars.githubusercontent.com/u/5105334?v=3","gravatar_id":"","url":"https://api.github.com/users/cwengc","html_url":"https://github.com/cwengc","followers_url":"https://api.github.com/users/cwengc/followers","following_url":"https://api.github.com/users/cwengc/following{/other_user}","gists_url":"https://api.github.com/users/cwengc/gists{/gist_id}","starred_url":"https://api.github.com/users/cwengc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cwengc/subscriptions","organizations_url":"https://api.github.com/users/cwengc/orgs","repos_url":"https://api.github.com/users/cwengc/repos","events_url":"https://api.github.com/users/cwengc/events{/privacy}","received_events_url":"https://api.github.com/users/cwengc/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/quantopian/zipline/labels/Bug","name":"Bug","color":"fc2929"},{"url":"https://api.github.com/repos/quantopian/zipline/labels/Data%20Bundle","name":"Data Bundle","color":"116184"},{"url":"https://api.github.com/repos/quantopian/zipline/labels/Windows","name":"Windows","color":"207de5"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-05-23T20:03:42Z","updated_at":"2016-07-30T05:21:14Z","closed_at":null,"body":"Dear Zipline Maintainers,\r\n\r\nBefore I tell you about my issue, let me describe my environment:\r\n\r\n# Environment\r\n\r\n* Operating System: Windows 7\r\n* Python Version: 3.4\r\n* Python Bitness: 64\r\n* How did you install Zipline: conda\r\n* Python packages: \r\n```\r\n_license                  1.1                      py34_0\r\nalabaster                 0.7.3                    py34_0\r\nanaconda                  2.3.0                np19py34_0\r\nargcomplete               0.8.9                    py34_0\r\nastropy                   1.0.3                np19py34_0\r\nbabel                     1.3                      py34_0\r\nbcolz                     0.12.1               np19py34_0\r\nbeautiful-soup            4.3.2                    py34_1\r\nbeautifulsoup4            4.3.2                     <pip>\r\nbinstar                   0.11.0                   py34_0\r\nbitarray                  0.8.1                    py34_1\r\nblaze                     0.8.0                     <pip>\r\nblaze-core                0.8.0                np19py34_0\r\nblz                       0.6.2                np19py34_1\r\nbokeh                     0.9.0                np19py34_0\r\nboto                      2.38.0                   py34_0\r\nbottleneck                1.0.0                np19py34_0\r\ncachetools                1.1.6                    py34_0\r\ncertifi                   14.05.14                 py34_0\r\ncffi                      1.1.0                    py34_0\r\nclick                     6.6                      py34_0\r\nclyent                    0.3.4                    py34_0\r\ncolorama                  0.3.3                    py34_0\r\nconda                     4.0.6                    py34_0\r\nconda-build               1.14.1                   py34_0\r\nconda-env                 2.4.5                    py34_0\r\nconfigobj                 5.0.6                    py34_0\r\ncontextlib2               0.4.0                    py34_0\r\ncryptography              0.9.1                    py34_0\r\ncyordereddict             0.2.2                    py34_0\r\ncython                    0.24                     py34_0\r\ncytoolz                   0.7.3                    py34_0\r\ndatashape                 0.4.5                np19py34_0\r\ndecorator                 4.0.9                    py34_0\r\ndocutils                  0.12                     py34_1\r\ndynd-python               0.6.5                np19py34_0\r\nfastcache                 1.0.2                    py34_0\r\nflask                     0.10.1                   py34_1\r\ngreenlet                  0.4.7                    py34_0\r\nh5py                      2.5.0                np19py34_1\r\nhdf5                      1.8.15.1                      2\r\nidna                      2.0                      py34_0\r\nintervaltree              2.1.0                    py34_0\r\nipython                   3.2.0                    py34_0\r\nipython-notebook          3.2.0                    py34_0\r\nipython-qtconsole         3.2.0                    py34_0\r\nitsdangerous              0.24                     py34_0\r\njdcal                     1.0                      py34_0\r\njedi                      0.8.1                    py34_0\r\njinja2                    2.7.3                    py34_2\r\njsonschema                2.4.0                    py34_0\r\nlauncher                  1.0.0                         1\r\nllvmlite                  0.5.0                    py34_0\r\nlogbook                   0.12.5                   py34_0\r\nlxml                      3.4.4                    py34_0\r\nmarkupsafe                0.23                     py34_0\r\nmatplotlib                1.4.3                np19py34_1\r\nmenuinst                  1.3.2                    py34_0\r\nmistune                   0.5.1                    py34_1\r\nmkl                       11.3.1                        0\r\nmock                      1.0.1                    py34_0\r\nmultipledispatch          0.4.8                    py34_0\r\nnetworkx                  1.11                     py34_0\r\nnltk                      3.0.3                np19py34_0\r\nnode-webkit               0.10.1                        0\r\nnose                      1.3.7                    py34_0\r\nnumba                     0.19.1               np19py34_0\r\nnumexpr                   2.4.6                np19py34_0\r\nnumpy                     1.9.3                    py34_1\r\nodo                       0.3.2                np19py34_0\r\nopenpyxl                  1.8.5                    py34_0\r\npandas                    0.16.1               np19py34_0\r\npandas-datareader         0.2.1                    py34_0\r\npatsy                     0.4.1                    py34_0\r\npep8                      1.6.2                    py34_0\r\npillow                    2.8.2                    py34_0\r\npip                       8.1.1                    py34_1\r\nply                       3.6                      py34_0\r\npsutil                    2.2.1                    py34_0\r\npy                        1.4.27                   py34_0\r\npyasn1                    0.1.7                    py34_0\r\npycosat                   0.6.1                    py34_0\r\npycparser                 2.14                     py34_0\r\npycrypto                  2.6.1                    py34_3\r\npyflakes                  0.9.2                    py34_0\r\npygments                  2.0.2                    py34_0\r\npyopenssl                 0.15.1                   py34_1\r\npyparsing                 2.0.3                    py34_0\r\npyqt                      4.10.4                   py34_1\r\npyreadline                2.0                      py34_0\r\npytables                  3.2.0                np19py34_0\r\npytest                    2.7.1                    py34_0\r\npython                    3.4.4                         4\r\npython-dateutil           2.5.3                    py34_0\r\npytz                      2016.4                   py34_0\r\npywin32                   219                      py34_0\r\npyyaml                    3.11                     py34_3\r\npyzmq                     14.7.0                   py34_0\r\nrequests                  2.9.1                    py34_0\r\nrequests-file             1.4                      py34_0\r\nrope                      0.9.4                    py34_1\r\nrope-py3k                 0.9.4.post1               <pip>\r\nrunipy                    0.1.3                    py34_0\r\nscikit-image              0.11.3               np19py34_0\r\nscikit-learn              0.16.1               np19py34_0\r\nscipy                     0.16.0               np19py34_0\r\nsetuptools                20.7.0                   py34_0\r\nsix                       1.10.0                   py34_0\r\nsnowballstemmer           1.2.0                    py34_0\r\nsockjs-tornado            1.0.1                    py34_0\r\nsortedcontainers          1.4.4                    py34_0\r\nsphinx                    1.3.1                    py34_0\r\nsphinx-rtd-theme          0.1.7                     <pip>\r\nsphinx_rtd_theme          0.1.7                    py34_0\r\nspyder                    2.3.5.2                  py34_0\r\nspyder-app                2.3.5.2                  py34_0\r\nsqlalchemy                1.0.12                   py34_0\r\nstatsmodels               0.6.1                np19py34_0\r\nswigibpy                  0.4.1                     <pip>\r\nsympy                     0.7.6                    py34_0\r\ntables                    3.2.0                     <pip>\r\ntoolz                     0.7.4                    py34_0\r\ntornado                   4.2                      py34_0\r\nujson                     1.33                     py34_0\r\nvs2010_runtime            10.00.40219.1                 0\r\nwerkzeug                  0.10.4                   py34_0\r\nwheel                     0.29.0                   py34_0\r\nxlrd                      0.9.3                    py34_0\r\nxlsxwriter                0.7.3                    py34_0\r\nxlwings                   0.3.5                    py34_0\r\nxlwt                      1.0.0                    py34_0\r\nzipline                   1.0.0                np19py34_0\r\nzlib                      1.2.8                    vc10_2\r\n```\r\nNow that you know a little about me, let me tell you about the issue I am\r\nhaving:\r\n\r\n# Description of Issue\r\nI'm running on windows, I'm getting an error when trying to write the asset to file. I have specified yahoo as the data source and registered the bundle followed by ingest.\r\n\r\nThis is the point where I'm encountering an issue:\r\n```python\r\nadjustment_db_writer = SQLiteAdjustmentWriter(\r\n    stack.enter_context(working_file(\r\n        adjustment_db_path(name, timestr, environ=environ),\r\n    )).path,\r\n    BcolzDailyBarReader(daily_bars_path),\r\n    bundle.calendar,\r\n    overwrite=True,\r\n```\r\n\r\nStacktrace\r\n```\r\n  File \"C:\\Anaconda3\\lib\\site-packages\\zipline\\data\\bundles\\core.py\", line 358, in ingest\r\n    overwrite=True,\r\n  File \"C:\\Anaconda3\\lib\\site-packages\\zipline\\data\\us_equity_pricing.py\", line 824, in __init__\r\n    self.conn = sqlite3.connect(conn_or_path)\r\nsqlite3.OperationalError: unable to open database file\r\n```\r\nconn_or_path is\r\n`'C:\\\\Users\\\\4770\\\\AppData\\\\Local\\\\Temp\\\\tmp73enzuii'`\r\n(Note that this changes on every run)\r\n\r\nHere is how you can reproduce this issue on your machine:\r\n\r\n## Reproduction Steps\r\n\r\n1. on windows machine, \r\n2. register yahoo bundle, start=\"2014-01-01\", end=\"2014-02-02\"\r\n3. ingest yahoo bundle\r\n...\r\n\r\n## What steps have you taken to resolve this already?\r\nstep through the code till the point where error occurs, with stack trace attached\r\n\r\n\r\n...\r\n\r\nSincerely,\r\nWayne\r\n"},"comment":{"url":"https://api.github.com/repos/quantopian/zipline/issues/comments/236343986","html_url":"https://github.com/quantopian/zipline/issues/1228#issuecomment-236343986","issue_url":"https://api.github.com/repos/quantopian/zipline/issues/1228","id":236343986,"user":{"login":"libname","id":9915498,"avatar_url":"https://avatars.githubusercontent.com/u/9915498?v=3","gravatar_id":"","url":"https://api.github.com/users/libname","html_url":"https://github.com/libname","followers_url":"https://api.github.com/users/libname/followers","following_url":"https://api.github.com/users/libname/following{/other_user}","gists_url":"https://api.github.com/users/libname/gists{/gist_id}","starred_url":"https://api.github.com/users/libname/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/libname/subscriptions","organizations_url":"https://api.github.com/users/libname/orgs","repos_url":"https://api.github.com/users/libname/repos","events_url":"https://api.github.com/users/libname/events{/privacy}","received_events_url":"https://api.github.com/users/libname/received_events","type":"User","site_admin":false},"created_at":"2016-07-30T05:21:14Z","updated_at":"2016-07-30T05:21:14Z","body":"@richafrank \r\nsame problem here, zipline ver 1.0.1. I could force us_equity_pricing to write temprary db file to sepcific location to avoid to \"unable to open database file\" problem. Does zipline ver1.0.1 already fix the work_file cache issue?\r\nThanks."}}
{"actor":{"display_login":"libname"}}