[R-sig-DB] RODBC and Netezza
Cater, Kenneth
kenneth@c@ter @end|ng |rom b@nko|@mer|c@@com
Wed Jul 1 21:52:37 CEST 2009
I've been trying to discover the root cause of an issue I've observed
using RODBC to connect to a Netezza appliance; from the system calls
below I can see that the Netezza is responding to the query, but for
whatever reason the connection dies before completion and R terminates
execution with no results. Has anyone else seen this behavior? Since
I'm seeing data being returned via ODBC it appears to be an issue with
RODBC, if I'm mistaken or if there is another test I could perform to
isolate the underlying issue, please let me know, thank you.
recvfrom(3,
"\0\0\0\0\0\0\0\0\0\0\320\7\0\0\v\0\0\0\306\20\3\0\7\00010900\0\5\0"...,
16384, 0, NULL, NULL) = 8192
recvfrom(3, "esa-Scottsdale, AZ\0Y\0\0\0\6\0\0\0\310\0\0\0\304"...,
16384, 0, NULL, NULL) = 8192
recvfrom(3, "\0\5\0AUT\0\7\00037620\0$\0Parkersburg-Mar"..., 16384, 0,
NULL, NULL) = 8192
recvfrom(3,
"\0\0\0\0\0\0\0\302]\360\t\0\0\0\0\0\0\0\0\0\0\0\0\6\220\0\0\0\0\0\0\0".
.., 16384, 0, NULL, NULL) = 9144
recvfrom(3,
"\0\305\1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
16384, 0, NULL, NULL) = 2669
select(4, [3], NULL, NULL, {0, 0}) = 0 (Timeout)
sendto(3, "X", 1, 0, NULL, 0) = 1
close(3) = 0
semop(32997381, 0x7fff9adb96a0, 2) = 0
semop(32997381, 0x7fff9adb96a0, 1) = 0
write(1, "> ", 2) = 2
write(1, "\n", 1) = 1
write(1, "> ", 2) = 2
write(1, "summary(SampleData)\n", 20) = 20
getrusage(RUSAGE_SELF, {ru_utime={0, 625904}, ru_stime={9, 49624}, ...})
= 0
getrusage(RUSAGE_CHILDREN, {ru_utime={0, 0}, ru_stime={0, 1999}, ...}) =
0
write(1, " Length ", 10) = 10
write(1, " Class ", 10) = 10
write(1, " Mode ", 10) = 10
write(1, "\n", 1) = 1
write(1, " 0 ", 10) = 10
write(1, "character ", 10) = 10
write(1, "character ", 10) = 10
write(1, "\n", 1) = 1
write(1, "> ", 2) = 2
read(0, "", 4096) = 0
write(1, "\n", 1) = 1
rt_sigaction(SIGINT, {SIG_IGN}, {0x41c690, [INT],
SA_RESTORER|SA_RESTART, 0x2aaaab8af0b0}, 8) = 0
rt_sigaction(SIGQUIT, {SIG_IGN}, {SIG_IGN}, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
clone(child_stack=0, flags=CLONE_PARENT_SETTID|SIGCHLD,
parent_tidptr=0x7fff9adbbb08) = 2275
wait4(2275, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 2275
rt_sigaction(SIGINT, {0x41c690, [INT], SA_RESTORER|SA_RESTART,
0x2aaaab8af0b0}, NULL, 8) = 0
rt_sigaction(SIGQUIT, {SIG_IGN}, NULL, 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
close(0) = 0
Thank you,
Kenneth Cater
Quantitative Risk Technology
Bank of America
980.683.4832
[[alternative HTML version deleted]]
More information about the R-sig-DB
mailing list