Skip to content

SQLite db creation not completing #109

@Medwynd

Description

@Medwynd

Ran the download script several times and after waiting 20 or 30 minutes each time I force broke the process. Each time I get this error:

INFO:gamecache.sqlite_indexer:Initialized SQLite database: gamecache.sqlite
Traceback (most recent call last):
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\socket.py", line 837, in create_connection
TimeoutError: [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "D:\gamecache-master\scripts\download_and_index.py", line 117, in
main(args)
File "D:\gamecache-master\scripts\download_and_index.py", line 51, in main
indexer.add_objects(collection)
File "D:\gamecache-master\scripts\gamecache\sqlite_indexer.py", line 108, in add_objects
image_data = self.fetch_image(game["image"])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\gamecache-master\scripts\gamecache\sqlite_indexer.py", line 76, in fetch_image
response = make_http_request(url)
^^^^^^^^^^^^^^^^^^^^^^
File "D:\gamecache-master\scripts\gamecache\http_client.py", line 34, in make_http_request
with urllib.request.urlopen(request, timeout=timeout) as response:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\urllib\request.py", line 215, in urlopen
return opener.open(url, data, timeout)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\urllib\request.py", line 515, in open
response = self._open(req, data)
^^^^^^^^^^^^^^^^^^^^^
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\urllib\request.py", line 532, in _open
result = self._call_chain(self.handle_open, protocol, protocol +
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\urllib\request.py", line 492, in _call_chain
result = func(*args)
^^^^^^^^^^^
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\urllib\request.py", line 1392, in https_open
return self.do_open(http.client.HTTPSConnection, req,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\urllib\request.py", line 1344, in do_open
h.request(req.get_method(), req.selector, req.data, headers,
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\http\client.py", line 1319, in request
self._send_request(method, url, body, headers, encode_chunked)
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\http\client.py", line 1365, in _send_request
self.endheaders(body, encode_chunked=encode_chunked)
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\http\client.py", line 1314, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked)
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\http\client.py", line 1074, in _send_output
self.send(msg)
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\http\client.py", line 1018, in send
self.connect()
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\http\client.py", line 1453, in connect
super().connect()
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\http\client.py", line 984, in connect
self.sock = self._create_connection(
^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\Users\User\AppData\Local\Programs\Python\Python312\Lib\socket.py", line 844, in create_connection
exceptions.clear() # raise only the last error
^^^^^^^^^^^^^^^^^^
KeyboardInterrupt

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions