Skip to content

Instantly share code, notes, and snippets.

@eduherraiz
Created October 28, 2014 08:42
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save eduherraiz/8b03eb4f9d47f7cd2f25 to your computer and use it in GitHub Desktop.
############################
POSTGRESQL LOGS WAL-E
############################
## SUBIDA CORRECTA
wal_e.worker.upload INFO MSG: begin archiving a file
DETAIL: Uploading "pg_xlog/00000001000000000000000C" to "s3://cursopostgres-wale/test-edu/wal_005/00000001000000000000000C.lzo".
STRUCTURED: time=2014-10-28T08:33:49.736120-00 pid=11210 action=push-wal key=s3://cursopostgres-wale/test-edu/wal_005/00000001000000000000000C.lzo prefix=test-edu/ seg=00000001000000000000000C state=begin
wal_e.worker.upload INFO MSG: completed archiving to a file
DETAIL: Archiving to "s3://cursopostgres-wale/test-edu/wal_005/00000001000000000000000C.lzo" complete at 147.875KiB/s.
STRUCTURED: time=2014-10-28T08:33:50.342584-00 pid=11210 action=push-wal key=s3://cursopostgres-wale/test-edu/wal_005/00000001000000000000000C.lzo prefix=test-edu/ rate=147.875 seg=00000001000000000000000C state=complete
## SUBIDA ERRONEA POR CREDENCIALES INCORRECTAS
wal_e.worker.upload INFO MSG: begin archiving a file
DETAIL: Uploading "pg_xlog/00000001000000000000000D" to "s3://cursopostgres-wale/test-edu/wal_005/00000001000000000000000D.lzo".
STRUCTURED: time=2014-10-28T08:37:55.202324-00 pid=11450 action=push-wal key=s3://cursopostgres-wale/test-edu/wal_005/00000001000000000000000D.lzo prefix=test-edu/ seg=00000001000000000000000D state=begin
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/gevent/greenlet.py", line 327, in run
result = self._run(*self.args, **self.kwargs)
File "/usr/local/lib/python2.7/dist-packages/wal_e/worker/upload.py", line 43, in __call__
self.gpg_key_id)
File "/usr/local/lib/python2.7/dist-packages/wal_e/worker/worker_util.py", line 40, in do_lzop_put
k = blobstore.uri_put_file(creds, url, tf)
File "/usr/local/lib/python2.7/dist-packages/wal_e/blobstore/s3/s3_util.py", line 54, in uri_put_file
k.set_contents_from_file(fp)
File "/usr/local/lib/python2.7/dist-packages/boto/s3/key.py", line 1246, in set_contents_from_file
chunked_transfer=chunked_transfer, size=size)
File "/usr/local/lib/python2.7/dist-packages/boto/s3/key.py", line 725, in send_file
chunked_transfer=chunked_transfer, size=size)
File "/usr/local/lib/python2.7/dist-packages/boto/s3/key.py", line 914, in _send_file_internal
query_args=query_args
File "/usr/local/lib/python2.7/dist-packages/boto/s3/connection.py", line 633, in make_request
retry_handler=retry_handler
File "/usr/local/lib/python2.7/dist-packages/boto/connection.py", line 1046, in make_request
retry_handler=retry_handler)
File "/usr/local/lib/python2.7/dist-packages/boto/connection.py", line 919, in _mexe
request.body, request.headers)
File "/usr/local/lib/python2.7/dist-packages/boto/s3/key.py", line 815, in sender
http_conn.send(chunk)
File "/usr/lib/python2.7/httplib.py", line 805, in send
self.sock.sendall(data)
File "/usr/local/lib/python2.7/dist-packages/gevent/socket.py", line 464, in sendall
data_sent += self.send(_get_memory(data, data_sent), flags, timeout=timeleft)
File "/usr/local/lib/python2.7/dist-packages/gevent/ssl.py", line 173, in send
v = self._sslobj.write(data)
error: [Errno 104] Connection reset by peer
<Greenlet at 0x7f9f772b2870: <wal_e.worker.upload.WalUploader object at 0x7f9f77047e90>(<wal_e.worker.pg.wal_transfer.WalSegment object at)> failed with error
wal_e.main CRITICAL MSG: An unprocessed exception has avoided all error handling
DETAIL: Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/wal_e/cmd.py", line 553, in main
concurrency=args.pool_size)
File "/usr/local/lib/python2.7/dist-packages/wal_e/operator/backup.py", line 281, in wal_archive
group.join()
File "/usr/local/lib/python2.7/dist-packages/wal_e/worker/pg/wal_transfer.py", line 121, in join
raise val
error: [Errno 104] Connection reset by peer
STRUCTURED: time=2014-10-28T08:38:52.922706-00 pid=11450
2014-10-28 09:38:52 CET LOG: archive command failed with exit code 2
2014-10-28 09:38:52 CET DETAIL: The failed archive command was: /usr/bin/envdir /etc/wal-e.d/env /usr/local/bin/wal-e wal-push pg_xlog/00000001000000000000000D
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment