Skip to content

Instantly share code, notes, and snippets.

@lpiob
Created November 16, 2020 09:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lpiob/09088d9b0d9becebe3a213fe6f15b5ed to your computer and use it in GitHub Desktop.
Save lpiob/09088d9b0d9becebe3a213fe6f15b5ed to your computer and use it in GitHub Desktop.
31 - WAL file
9 - postgresql socket
pread64(31, "X\0\0\0\0\0\0\0\20=:\377\16\0\0\0\2\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2870796) = 88
pread64(31, "", 0, 2870884) = 0
pread64(31, "X\0\0\0\0\0\0\0H=:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2870884) = 88
pread64(31, "", 0, 2870972) = 0
pread64(31, "X\0\0\0\0\0\0\0\210=:\377\16\0\0\0\2\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2870972) = 88
pread64(31, "", 0, 2871060) = 0
pread64(31, "X\0\0\0\0\0\0\0\300=:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871060) = 88
pread64(31, "", 0, 2871148) = 0
pread64(31, "X\0\0\0\0\0\0\0\0>:\377\16\0\0\0\2\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871148) = 88
pread64(31, "", 0, 2871236) = 0
pread64(31, "X\0\0\0\0\0\0\0008>:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871236) = 88
pread64(31, "", 0, 2871324) = 0
pread64(31, "X\0\0\0\0\0\0\0x>:\377\16\0\0\0\2\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871324) = 88
pread64(31, "", 0, 2871412) = 0
pread64(31, "X\0\0\0\0\0\0\0\260>:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871412) = 88
pread64(31, "", 0, 2871500) = 0
pread64(31, "X\0\0\0\0\0\0\0\360>:\377\16\0\0\0\2\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871500) = 88
pread64(31, "", 0, 2871588) = 0
pread64(31, "X\0\0\0\0\0\0\0(?:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871588) = 88
pread64(31, "", 0, 2871676) = 0
pread64(31, "X\0\0\0\0\0\0\0h?:\377\16\0\0\0\2\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871676) = 88
pread64(31, "", 0, 2871764) = 0
pread64(31, "X\0\0\0\0\0\0\0\240?:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871764) = 88
pread64(31, "", 0, 2871852) = 0
pread64(31, "X\0\0\0\0\0\0\0H\\:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871852) = 88
pread64(31, "", 0, 2871940) = 0
pread64(31, "X\0\0\0\0\0\0\0\210\\:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2871940) = 88
pread64(31, "", 0, 2872028) = 0
pread64(31, "X\0\0\0\0\0\0\0\310\\:\377\16\0\0\0\1\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2872028) = 88
pread64(31, "", 0, 2872116) = 0
pread64(31, "X\0\0\0\0\0\0\0\370u:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2872116) = 88
pread64(31, "", 0, 2872204) = 0
pread64(31, "X\0\0\0\0\0\0\0008v:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2872204) = 88
pread64(31, "", 0, 2872292) = 0
pread64(31, "X\0\0\0\0\0\0\0xv:\377\16\0\0\0\1\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2872292) = 88
pread64(31, "", 0, 2872380) = 0
pread64(31, "X\0\0\0\0\0\0\0\270\217:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2872380) = 88
pread64(31, "", 0, 2872468) = 0
pread64(31, "X\0\0\0\0\0\0\0\370\217:\377\16\0\0\0\5\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2872468) = 88
pread64(31, "", 0, 2872556) = 0
pread64(31, "X\0\0\0\0\0\0\0008\220:\377\16\0\0\0\1\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2872556) = 88
pread64(31, "", 0, 2872644) = 0
pread64(31, "\350\0\0\0\0\0\0\0p\221:\377\16\0\0\0\4\0\0\0\0\0\0\0\250ny5#V\0\0"..., 88, 2872644) = 88
pread64(31, "\5\0\0\0\37.\17\0~:\17\0\0\0\0\0`6~5#V\0\0\n\0\0\0\0\0\0\0"..., 144, 2872732) = 144
pread64(31, "", 88, 2872876) = 0
close(31) = 0
sendto(9, "d\0\0\0007w\0\0\0\16\377:\352\230\0\0\0\16\377:\352\230\0\2W!Z.\231OC\0"..., 56, 0, NULL, 0) = 56
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D0000000.spill") = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D1000000.spill") = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D2000000.spill") = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D3000000.spill") = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D4000000.spill") = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D5000000.spill") = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D6000000.spill") = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D7000000.spill") = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D8000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-D9000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-DA000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-DB000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-DC000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-DD000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-DE000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-DF000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E0000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E1000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E2000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E3000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E4000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E5000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E6000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E7000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E8000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-E9000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-EA000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-EB000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-EC000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-ED000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-EE000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-EF000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F0000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F1000000.spill") = 0
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F2000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F3000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F4000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F5000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F6000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F7000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F8000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-F9000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-FA000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-FB000000.spill") = -1 ENOENT (No such file or directory)
unlink("pg_replslot/sub_cz/xid-994847-lsn-E-FC000000.spill") = -1 ENOENT (No such file or directory)
gettimeofday({tv_sec=1605435511, tv_usec=986510}, NULL) = 0
recvfrom(9, "d", 1, 0, NULL, NULL) = 1
recvfrom(9, "\0\0\0&r\0\0\0\16\3774\267\270\0\0\0\16\3774\267\270\0\0\0\16\3774\267\270\0\2W"..., 8192, 0, NULL, NULL) = 77
gettimeofday({tv_sec=1605435511, tv_usec=986700}, NULL) = 0
gettimeofday({tv_sec=1605435511, tv_usec=986750}, NULL) = 0
recvfrom(9, 0x7ffee248a537, 1, 0, NULL, NULL) = -1 EAGAIN (Resource temporarily unavailable)
gettimeofday({tv_sec=1605435511, tv_usec=986871}, NULL) = 0
recvfrom(9, 0x7ffee248a537, 1, 0, NULL, NULL) = -1 EAGAIN (Resource temporarily unavailable)
open("pg_replslot/sub_cz/xid-1005073-lsn-E-FF000000.spill", O_WRONLY|O_CREAT|O_APPEND, 0600) = 31
write(31, "\301\0\0\0\0\0\0\0\270X:\377\16\0\0\0\1\0\0\0\0\0\0\0\240oy5#V\0\0"..., 193) = 193
write(31, "\350\0\0\0\0\0\0\0p\221:\377\16\0\0\0\4\0\0\0\0\0\0\0\240oy5#V\0\0"..., 232) = 232
write(31, "\330\1\0\0\0\0\0\0\360\352:\377\16\0\0\0\1\0\0\0\0\0\0\0\240oy5#V\0\0"..., 472) = 472
close(31) = 0
--- SIGUSR1 {si_signo=SIGUSR1, si_code=SI_USER, si_pid=4791, si_uid=113} ---
rt_sigreturn({mask=[]}) = 0
<process 'hangs' here without making any calls>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment