Re: select... timeout...sgbd ?

Un petit peu plus d'infos. J'ai essayé de lancer le strace tout de suite au lancement du processus

# ps faux
root 3202 0.0 0.0 65584 456 ? Ss Oct09 0:00 /usr/bin/rsync --daemon
root 7067 0.0 0.0 68868 3388 ? S 10:52 0:00 \_ /usr/bin/rsync --daemon
# strace -p 3202
Process 3202 attached - interrupt to quit
select(6, [4 5], NULL, NULL, NULL) = 1 (in [5])
accept(5, {sa_family=AF_INET, sin_port=htons(48786), sin_addr=inet_addr("192.168.5.32")}, [10573888983702437904]) = 3
rt_sigaction(SIGCHLD, {0x42c660, [], SA_RESTORER|SA_NOCLDSTOP, 0x3dce4302d0}, NULL, 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x2ba35d3ea3f0) = 7067
close(3) = 0
select(6, [4 5], NULL, NULL, NULL
# strace -p 7067
Process 7067 attached - interrupt to quit
select(4, [3], [], NULL, {56, 672000}) = 1 (in [3], left {48, 396000})
read(3, "232円 0円0円R\t0円0円0円10円0円0円2円0円0円0円|6円0円0円Cc336円! 737円(304円211円\n3円"..., 8184) = 8184
select(4, [3], [], NULL, {60, 0}) = 1 (in [3], left {60, 0})
read(3, "316円312円237円24円310円341円G\r;26円N275円254円W376円23円307円335円D373円]24円22円203円274円335円245円24円]364円325円353円"..., 8184) = 6156
open("product/10.2.0/db_1/network/log/listener.log", O_RDONLY) = 5
fstat(5, {st_mode=S_IFREG|0640, st_size=4905087, ...}) = 0
mmap(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ba360c28000
mmap(NULL, 266240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ba360c69000
read(5, "24-SEP-2012 14:12:45 * ping * 0\n"..., 262144) = 262144
brk(0x27c5000) = 0x27c5000
brk(0x27f5000) = 0x27f5000
read(5, " * service_update * HILTEST * 0\n"..., 262143) = 262143
read(5, "t currently know of SID given in"..., 260096) = 260096
read(5, "s not currently know of SID give"..., 260096) = 260096
read(5, "ently know of SID given in conne"..., 260096) = 260096
read(5, "currently know of SID given in c"..., 260096) = 260096
read(5, "CT-2012 18:42:34 * service_updat"..., 260096) = 260096
read(5, "07:46:06 * service_update * HILT"..., 260096) = 260096
read(5, "5 * service_update * HILTEST * 0"..., 260096) = 260096
read(5, "8 * service_update * HILTEST * 0"..., 260096) = 260096
read(5, "13 04:25:52 * service_update * H"..., 260096) = 260096
read(5, "2013 22:54:03 * service_update *"..., 260096) = 260096
read(5, "LTEST * 0\n26-MAR-2013 19:16:01 *"..., 260096) = 260096
read(5, "8:30 * service_update * HILTEST "..., 260096) = 260096
read(5, "e_update * HILTEST * 0\n23-MAY-20"..., 260096) = 260096
read(5, "ce_update * HILTEST * 0\n03-JUL-2"..., 260096) = 260096
read(5, "54:08 * service_update * HILTEST"..., 260096) = 260096
read(5, "3 19:48:17 * service_update * HI"..., 260096) = 260096
read(5, "vice_update * HILTEST * 0\n19-SEP"..., 219264) = 219264
munmap(0x2ba360c69000, 266240) = 0
close(5) = 0
select(4, NULL, [3], [3], {60, 0}) = 1 (out [3], left {60, 0})
write(3, "34円7円0円7円", 4) = 4
select(4, NULL, [3], [3], {60, 0}) = 1 (out [3], left {60, 0})
write(3, "232円 0円0円R\t0円0円0円10円0円0円2円0円0円0円|6円0円0円300円P\tF362円314円235円K16円3446円\f"..., 1820) = 1820
select(4, NULL, [3], [3], {60, 0}) = 1 (out [3], left {60, 0})
write(3, "4円0円0円7円377円377円377円377円", 8) = 8
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}) = 0 (Timeout)
select(4, [3], [], NULL, {60, 0}
....

Au bout de 20mn j'ai arrêté le strace sur le pid 7067. J'ai l'impression qu'il bloc sur le fichier listener.log qui est le fichier log du processus oracle listener qui forcement n'est pas arrêté au moment de la sauvegarde. Par curiosité j'ai fais un rsync directement dessus

rsync -av listener.log /tmp
sending incremental file list
listener.log
sent 4905886 bytes received 31 bytes 9811834.00 bytes/sec
total size is 4905191 speedup is 1.00

Pas d'erreur.

Born to Kill EndUser !