[R-sig-DB] RODBC and Netezza

[Cater, Kenneth]

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]]