sqlite3.OperationalError: unable to open database file

451 views
Skip to first unread message

vitsin

unread,
Jul 14, 2011, 3:39:20 PM7/14/11
to scrapy-users
sudo scrapy deploy scrapyd2 -p default
Building egg of default-1310672147
Deploying default-1310672147 to http://localhost:6800/addversion.json
2011-07-14 15:35:47-0400 [HTTPChannel,5,127.0.0.1] 127.0.0.1 - - [14/
Jul/2011:19:35:46 +0000] "POST /addversion.json HTTP/1.1" 200 724 "-"
"Python-urllib/2.6"
Server response (200):
Traceback (most recent call last):
File "/usr/lib/pymodules/python2.6/scrapyd/webservice.py", line 17,
in render
return JsonResource.render(self, txrequest)
File "/usr/lib/pymodules/python2.6/scrapy/utils/txweb.py", line 10,
in render
r = resource.Resource.render(self, txrequest)
File "/usr/lib/python2.6/dist-packages/twisted/web/resource.py",
line 210, in render
return m(request)
File "/usr/lib/pymodules/python2.6/scrapyd/webservice.py", line 46,
in render_POST
spiders = get_spider_list(project)
File "/usr/lib/pymodules/python2.6/scrapyd/utils.py", line 59, in
get_spider_list
raise RuntimeError(msg.splitlines()[-1])
RuntimeError: sqlite3.OperationalError: unable to open database file


What file is it trying to open and why in all sudden no permissions
please?
Its a brand new installation of ubuntu + Scrapy + Scrapyd.

vitsin

unread,
Jul 14, 2011, 3:58:34 PM7/14/11
to scrapy-users
This is a first time ever I see such error, all the installations were
completely fine.
Scrapy version: Scrapy 0.12.0.2543.



On Jul 14, 3:39 pm, vitsin <vitaly.sinit...@gmail.com> wrote:
> sudo scrapy deploy scrapyd2 -p default
> Building egg of default-1310672147
> Deploying default-1310672147 tohttp://localhost:6800/addversion.json

Ensnap

unread,
Jul 15, 2011, 4:29:06 PM7/15/11
to scrapy-users
There's a scrapy.db file in .scrapy folder in your project. Is that
accessible?
http://doc.scrapy.org/topics/settings.html#sqlite-db

The spider queue is stored here. Looks like the trace includes
get_spider_list(project)

vitsin

unread,
Jul 15, 2011, 5:08:17 PM7/15/11
to scrapy-users
thanks, solved it.
The issue was: 2 different path projects has the same scrapy.cfg
[deploy:the_name] and default = the_name.settings, so instead of clear
error, I've got previously described Exception.
10x.

On Jul 15, 4:29 pm, Ensnap <ens...@gmail.com> wrote:
> There's a scrapy.db file in .scrapy folder in your project. Is that
> accessible?http://doc.scrapy.org/topics/settings.html#sqlite-db
Reply all
Reply to author
Forward
0 new messages