search

shirosaidev / stocksight

Stock market analyzer and predictor using Elasticsearch, Twitter, News headlines and Python natural language processing and sentiment analysis
https://shirosaidev.github.io/stocksight/
Apache License 2.0
2.12k stars 463 forks source link

[elasticsearch] PUT http://localhost:9200/stocksight [status:N/A request:4.576s] #36

Closed glitchawy closed 1 year ago

glitchawy commented 1 year ago

2023-08-08 14:05:45,887 [INFO][stocksight] Creating new Elasticsearch index or using existing stocksight
2023-08-08 14:05:50,462 [WARNING][elasticsearch] PUT http://localhost:9200/stocksight [status:N/A request:4.576s] Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 203, in _new_conn sock = connection.create_connection( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 85, in create_connection raise err File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 73, in create_connection sock.connect(sa) ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\elasticsearch\connection\http_urllib3.py", line 115, in perform_request response = self.pool.urlopen(method, url, body, retries=False, headers=self.headers, **kw) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 844, in urlopen retries = retries.increment( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\retry.py", line 445, in increment raise reraise(type(error), error, _stacktrace) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\util.py", line 39, in reraise raise value File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 790, in urlopen response = self._make_request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 496, in _make_request conn.request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 395, in request self.endheaders() File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1280, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1040, in _send_output self.send(msg) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 980, in send self.connect() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 243, in connect self.sock = self._new_conn() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 218, in _new_conn raise NewConnectionError( urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x000001B681972C40>: Fail ed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refused it 2023-08-08 14:05:50,748 [DEBUG][elasticsearch] > {"mappings": {"stock": {"properties": {"symbol": {"type": "k eyword"}, "price_last": {"type": "float"}, "date": {"type": "date"}, "change": {"type": "float"}, "price_high": {"type": "float"}, "price_low": {"type": "float"}, "vol": {"type": "integer"}}}}} 2023-08-08 14:05:55,561 [WARNING][elasticsearch] PUT http://localhost:9200/stocksight [status:N/A request:4.811s] Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 203, in _new_conn sock = connection.create_connection( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 85, in create_connection raise err File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 73, in create_connection sock.connect(sa) ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\elasticsearch\connection\http_urllib3.py", line 115, in perform_request response = self.pool.urlopen(method, url, body, retries=False, headers=self.headers, **kw) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 844, in urlopen retries = retries.increment( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\retry.py", line 445, in increment raise reraise(type(error), error, _stacktrace) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\util.py", line 39, in reraise raise value File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 790, in urlopen response = self._make_request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 496, in _make_request conn.request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 395, in request self.endheaders() File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1280, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1040, in _send_output self.send(msg) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 980, in send self.connect() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 243, in connect self.sock = self._new_conn() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 218, in _new_conn raise NewConnectionError( urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x000001B681972E50>: Fail ed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refused it 2023-08-08 14:05:55,685 [DEBUG][elasticsearch] > {"mappings": {"stock": {"properties": {"symbol": {"type": "k eyword"}, "price_last": {"type": "float"}, "date": {"type": "date"}, "change": {"type": "float"}, "price_high": {"type": "float"}, "price_low": {"type": "float"}, "vol": {"type": "integer"}}}}} 2023-08-08 14:06:00,331 [WARNING][elasticsearch] PUT http://localhost:9200/stocksight [status:N/A request:4.646s] Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 203, in _new_conn sock = connection.create_connection( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 85, in create_connection raise err File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 73, in create_connection sock.connect(sa) ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\elasticsearch\connection\http_urllib3.py", line 115, in perform_request response = self.pool.urlopen(method, url, body, retries=False, headers=self.headers, **kw) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 844, in urlopen retries = retries.increment( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\retry.py", line 445, in increment raise reraise(type(error), error, _stacktrace) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\util.py", line 39, in reraise raise value File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 790, in urlopen response = self._make_request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 496, in _make_request conn.request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 395, in request self.endheaders() File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1280, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1040, in _send_output self.send(msg) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 980, in send self.connect() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 243, in connect self.sock = self._new_conn() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 218, in _new_conn raise NewConnectionError( urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x000001B681989100>: Fail ed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refused it 2023-08-08 14:06:00,396 [DEBUG][elasticsearch] > {"mappings": {"stock": {"properties": {"symbol": {"type": "k eyword"}, "price_last": {"type": "float"}, "date": {"type": "date"}, "change": {"type": "float"}, "price_high": {"type": "float"}, "price_low": {"type": "float"}, "vol": {"type": "integer"}}}}} 2023-08-08 14:06:05,012 [WARNING][elasticsearch] PUT http://localhost:9200/stocksight [status:N/A request:4.614s] Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 203, in _new_conn sock = connection.create_connection( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 85, in create_connection raise err File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 73, in create_connection sock.connect(sa) ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\elasticsearch\connection\http_urllib3.py", line 115, in perform_request response = self.pool.urlopen(method, url, body, retries=False, headers=self.headers, **kw) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 844, in urlopen retries = retries.increment( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\retry.py", line 445, in increment raise reraise(type(error), error, _stacktrace) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\util.py", line 39, in reraise raise value File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 790, in urlopen response = self._make_request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 496, in _make_request conn.request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 395, in request self.endheaders() File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1280, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1040, in _send_output self.send(msg) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 980, in send self.connect() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 243, in connect self.sock = self._new_conn() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 218, in _new_conn raise NewConnectionError( urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x000001B681989280>: Fail ed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refused it 2023-08-08 14:06:05,017 [DEBUG][elasticsearch] > {"mappings": {"stock": {"properties": {"symbol": {"type": "k eyword"}, "price_last": {"type": "float"}, "date": {"type": "date"}, "change": {"type": "float"}, "price_high": {"type": "float"}, "price_low": {"type": "float"}, "vol": {"type": "integer"}}}}} Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 203, in _new_conn sock = connection.create_connection( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 85, in create_connection raise err File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\connection.py", line 73, in create_connection sock.connect(sa) ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\elasticsearch\connection\http_urllib3.py", line 115, in perform_request response = self.pool.urlopen(method, url, body, retries=False, headers=self.headers, **kw) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 844, in urlopen retries = retries.increment( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\retry.py", line 445, in increment raise reraise(type(error), error, _stacktrace) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\util\util.py", line 39, in reraise raise value File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 790, in urlopen response = self._make_request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connectionpool.py", line 496, in _make_request conn.request( File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 395, in request self.endheaders() File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1280, in endheaders
self._send_output(message_body, encode_chunked=encode_chunked) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 1040, in _send_output self.send(msg) File "C:\Users\moham\AppData\Local\Programs\Python\Python39\lib\http\client.py", line 980, in send self.connect() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 243, in connect self.sock = self._new_conn() File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\urllib3\connection.py", line 218, in _new_conn raise NewConnectionError( urllib3.exceptions.NewConnectionError: <urllib3.connection.HTTPConnection object at 0x000001B681989280>: Fail ed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refused it

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "D:\Recent Projects\stocks_prediction\stocksight\stockprice.py", line 234, in es.indices.create(index=args.index, body=mappings, ignore=[400, 404]) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\elasticsearch\client\utils.py", line 73, in _wrapped return func(*args, params=params, **kwargs) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\elasticsearch\client\indices.py", line 106, in create return self.transport.perform_request('PUT', _make_path(index), File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\elasticsearch\transport.py", line 312, in perform_request status, headers, data = connection.perform_request(method, url, params, body, ignore=ignore, timeout=timeout) File "D:\Recent Projects\stocks_prediction\venv\lib\site-packages\elasticsearch\connection\http_urllib3.py", line 124, in perform_request raise ConnectionError('N/A', str(e), e) elasticsearch.exceptions.ConnectionError: ConnectionError(<urllib3.connection.HTTPConnection object at 0x0000 01B681989280>: Failed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refused it) caused by: NewConnectionError(<urllib3.connection.HTTPConnection object at 0x000001B681989280>: Failed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refused it)

can someone help me with this .. i tried to change the "localhost" to my device hostname and changing the port also and nothing works