This is the error
Exception happened during processing of request from ('178.63.69.203', 49828)
Traceback (most recent call last):
File "/usr/lib/python2.7/SocketServer.py", line 295, in _handle_request_noblock
self.process_request(request, client_address)
File "/usr/lib/python2.7/SocketServer.py", line 321, in process_request
self.finish_request(request, client_address)
File "/usr/lib/python2.7/SocketServer.py", line 334, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/lib/python2.7/SocketServer.py", line 651, in __init__
self.finish()
File "/usr/lib/python2.7/SocketServer.py", line 704, in finish
self.wfile.flush()
File "/usr/lib/python2.7/socket.py", line 303, in flush
self._sock.sendall(view[write_offset:write_offset+buffer_size])
error: [Errno 32] Broken pipe
(I think nginx (load-balancing here) or the client times out because it's taking too long)
No Abe stack frames here, so I don't have much to go by.
on AuroraCoind debug.log I see this:
22478 ThreadRPCServer method=getrawtransaction
22479 ThreadRPCServer method=getrawtransaction
22480 ThreadRPCServer method=getrawtransaction
22481 ThreadRPCServer method=getrawtransaction
22482 ThreadRPCServer method=getrawtransaction
22483 ThreadRPCServer method=getrawtransaction
22484 ThreadRPCServer method=getrawtransaction
22485 ThreadRPCServer method=getrawtransaction
22486 ThreadRPCServer method=getrawtransaction
22487 ThreadRPCServer method=getrawtransaction
22488 ThreadRPCServer method=getrawtransaction
22489 ThreadRPCServer method=getrawtransaction
22490 ThreadRPCServer method=getrawtransaction
22491 ThreadRPCServer method=getrawtransaction
22492 ThreadRPCServer method=getrawtransaction
22493 ThreadRPCServer method=getrawtransaction
22494 ThreadRPCServer method=getrawtransaction
22495 ThreadRPCServer method=getrawtransaction
22496 ThreadRPCServer method=getrawtransaction
22497 ThreadRPCServer method=getrawtransaction
22498 ThreadRPCServer method=getrawtransaction
22499 ThreadRPCServer method=getrawtransaction
22500 ThreadRPCServer method=getrawtransaction
22501 ThreadRPCServer method=getrawtransaction
22502 ThreadRPCServer method=getrawtransaction
22503 ThreadRPCServer method=getrawtransaction
22504 ThreadRPCServer method=getrawtransaction
about 500 per secondspsql> select * from pg_stat_activity;
reports only one IDLE connection
Perhaps the HTTP request is triggering a catch-up which takes too long. Have you tried separating the loader from the server? One process runs Abe in an infinite loop passing --no-serve, and the web process uses --no-load (or datadir=[]). Then the web requests will not wait for data to load.