Problems displaying data from Query Tool and View/Edit Data Tool.

Hi All,

I have problems when using the "Edit Window" and "Query Window". It
seems that for some reason the recv is exiting early with the
reception of a EAGAIN (Resource temporarily unavailable) signal.
Refer to the truss output below. This results in no data being
displayed. For the query window, data will be intermittently be
displayed. There is 3 rows of data. For the "Edit Data" window, if
selected via the menu (Tools->View Data), data will sometimes be
displayed, but when the "View Data" bottom is pressed, the Edit Window
is displayed with no column or row data and the text "aborting" is
displayed at the bottom left of the window.

Has anyone any ideas whether what would cause this and/or how to
isolate the cause. There seems to be no problem with gathering data
on the set-up of the database.

This were obtained when "F5" (Execute) was pressed in the sql query
window, no data displayed. The following is a truss of the pgadmin
process.

23191: lwp_create(0xFFBFD868, LWP_SUSPENDED, 0xFFBFD864) = 102
23191/1: lwp_continue(102) = 0
23191/102: lwp_create() (returning as new lwp ...) = 0
23191/102: lwp_schedctl(SC_STATE|SC_PREEMPT, 0, 0xFE0FBBBC) = 0
23191/102: time() = 1122264710
23191/102: getpid() = 23191
[23441]
23191/102: open64("pgadmin.log", O_WRONLY|O_APPEND|O_CREAT, 0666) = 9
23191/102: llseek(9, 0, SEEK_END) = 2255822
23191/102: fstat64(9, 0xFE0FB948) = 0
23191/102: fstat64(9, 0xFE0FB7F0) = 0
23191/102: ioctl(9, TCGETA, 0xFE0FB8D4) Err#25
ENOTTY
23191/102: write(9, 0x011B3074, 65) = 65
23191/102: 2 0 0 5 - 0 7 - 2 5 1 6 : 1 1 : 5 0 I N F O
: R u n
23191/102: n i n g q u e r y s e l e c t * f r o m w e
a t h e r
23191/102: \n
23191/102: close(9) = 0
23191/102: time() = 1122264710
23191/102: getpid() = 23191
[23441]
23191/102: open64("pgadmin.log", O_WRONLY|O_APPEND|O_CREAT, 0666) = 9
23191/102: llseek(9, 0, SEEK_END) = 2255887
23191/102: fstat64(9, 0xFE0FB958) = 0
23191/102: fstat64(9, 0xFE0FB800) = 0
23191/102: ioctl(9, TCGETA, 0xFE0FB8E4) Err#25
ENOTTY
23191/102: write(9, 0x011B3074, 64) = 64
23191/102: 2 0 0 5 - 0 7 - 2 5 1 6 : 1 1 : 5 0 Q U E R Y
: T h r
23191/102: e a d Q u e r y s e l e c t * f r o m w e a
t h e r\n
23191/1: write(6, 0x00BA8A08, 2832) = 2832
23191/1: 12\0\007\0 x L O\0\001AD\0\0\006 03\004\0\0\001 L 089
y 8 x\005
23191/1: \0 x\0 E\0\b80\0\0\0\0\0\0\0\0\0 8FF\004\0 x\0
F\0\b\0\0\0\0\0\0
:
:
23191/1: 02 ?\0D4 ;03\005\0 x\0 #\0\0\0\0\0\0\0\002 P\0E6
>03\007\0 x ` k
23191/1: \0 x L g\0 x\0 #\0\0\0\0\0\0\0\002 P\0E6 8\0\004\0 x\0
#\0\b\0\0
23191/1: \0\0\0\0 6 x\002\0 x ` k +9B\001
23191/102: close(9) = 0
23191/102: sigaction(SIGPIPE, 0xFE0FB9E0, 0xFE0FBB00) = 0
23191/102: send(8, 0x0105E878, 27, 0) = 27
23191/102: Q\0\0\01A s e l e c t * f r o m w e a t h e r\0
23191/102: sigaction(SIGPIPE, 0xFE0FB9E0, 0xFE0FBB00) = 0
23191/102: recv(8, 0x0105A870, 16384, 0) = 304
23191/102: T\0\0\07F\005 c i t y\0\012 NC4\001\0\00413FFFF\0\0\0
T\0\0 t e
23191/102: m p _ l o\0\012 NC4\002\0\0\017\004FFFFFFFF\0\0 t e m
p _ h i\0
23191/102: \012 NC4\003\0\0\017\004FFFFFFFF\0\0 p r c p\0\012
NC4\004\0\002
23191/102: BC\004FFFFFFFF\0\0 d a t e\0\012 NC4\005\0\004
:\004FFFFFFFF\0\0
23191/102: D\0\0\0 6\005\0\0\0\r S a n F r a n c i s c
o\0\0\002 4 1\0\0
23191/102: \002 5 5\0\0\001 0\0\0\0\n 1 9 9 4 - 1 1 - 2 9 D\0\0\0
/\005\0\0
23191/102: \007 H a y w a r d\0\0\002 3 5\0\0\002 5
2FFFFFFFF\0\0\0\n 1 9 9
23191/102: 4 - 1 1 - 2 9 D\0\0\0 6\005\0\0\0\r S a n F r a n c
i s c o\0
23191/102: \0\002 4 1\0\0\002 5 5\0\0\001 0\0\0\0\n 1 9 9 4 - 1 1
- 2 9 C\0
23191/102: \0\0\v S E L E C T\0 Z\0\0\005 I
23191/102: recv(8, 0x0105A876, 16378, 0) Err#11
EAGAIN
23191/102: sigprocmask(SIG_SETMASK, 0xFE34A074, 0xFE0FBDA0) = 0
23191/102: sigprocmask(SIG_SETMASK, 0xFE0FBD8C, 0x00000000) = 0
23191/102: sigprocmask(SIG_SETMASK, 0xFE34A074, 0x00000000) = 0
23191/102: lwp_exit()
23191: read(6, 0xFFBFDAF8, 32) Err#11 EAGAIN
23191: poll(0xFFBFD848, 1, -1) = 1
23191: read(6, 0xFFBFDAF8, 32) = 32

Slightly different example, same result:

23191/1: \0\0\0\0\0\0\0\002 P\0E6 >9B\007\0 x ` ~\0 x L g\0 x\0
#\0\0\0\0
23191/1: \0\0\0\002 P\0E6 8 x\004\0 x\0 #\0\b\0\0\0\0\0\0 6
x\002\0 x ` ~
23191/1: +\0\001
23191/103: getpid() = 23191
[23441]
23191/1: read(6, 0xFFBFDAF8, 32) Err#11
EAGAIN
23191/103: open64("pgadmin.log", O_WRONLY|O_APPEND|O_CREAT, 0666) = 9
23191/103: llseek(9, 0, SEEK_END) = 2255951
23191/103: fstat64(9, 0xFE0FB948) = 0
23191/103: fstat64(9, 0xFE0FB7F0) = 0
23191/103: ioctl(9, TCGETA, 0xFE0FB8D4) Err#25
ENOTTY
23191/103: write(9, 0x011B3A84, 65) = 65
23191/103: 2 0 0 5 - 0 7 - 2 5 1 6 : 1 1 : 5 2 I N F O
: R u n
23191/103: n i n g q u e r y s e l e c t * f r o m w e
a t h e r
23191/103: \n
23191/103: close(9) = 0
23191/103: time() = 1122264712
23191/103: getpid() = 23191
[23441]
23191/103: open64("pgadmin.log", O_WRONLY|O_APPEND|O_CREAT, 0666) = 9
23191/103: llseek(9, 0, SEEK_END) = 2256016
23191/103: fstat64(9, 0xFE0FB958) = 0
23191/103: fstat64(9, 0xFE0FB800) = 0
23191/103: ioctl(9, TCGETA, 0xFE0FB8E4) Err#25
ENOTTY
23191/103: write(9, 0x011B3A84, 64) = 64
23191/103: 2 0 0 5 - 0 7 - 2 5 1 6 : 1 1 : 5 2 Q U E R Y
: T h r
23191/103: e a d Q u e r y s e l e c t * f r o m w e a
t h e r\n
23191/1: poll(0xFFBFD848, 1, -1) = 1
23191/1: read(6, 0xFFBFDAF8, 32) = 32
:
:
23191/1: ioctl(6, FIONREAD, 0xFFBFD70C) = 0
23191/1: ioctl(6, FIONREAD, 0xFFBFD864) = 0
23191/1: poll(0x00B98350, 2, 0) = 0
23191/1: ioctl(6, FIONREAD, 0xFFBFD864) = 0
23191/103: close(9) = 0
23191/103: sigaction(SIGPIPE, 0xFE0FB900, 0xFE0FBA20) = 0
23191/103: send(8, 0x0105E878, 15, 0) = 15
23191/103: Q\0\0\00E S E L E C T 1 ;\0
23191/103: sigaction(SIGPIPE, 0xFE0FB900, 0xFE0FBA20) = 0
23191/1: poll(0x00B98350, 2, 0) = 0
23191/1: ioctl(6, FIONREAD, 0xFFBFD864) = 0
23191/1: poll(0x00B98350, 2, 0) = 0
23191/1: ioctl(6, FIONREAD, 0xFFBFD864) = 0
23191/1: poll(0x00B98350, 2, 0) = 0
23191/103: poll(0xFE0FBA58, 1, -1) = 1
23191/103: recv(8, 0x0105A870, 16384, 0) = 64
23191/103: T\0\0\0 !\001 ? c o l u m n
?\0\0\0\0\0\0\0\0\0\017\004FFFFFFFF
23191/103: \0\0 D\0\0\0\v\001\0\0\001 1 C\0\0\0\v S E L E C T\0
Z\0\0\005 I
23191/103: sigprocmask(SIG_SETMASK, 0xFE34A074, 0xFE0FBDA0) = 0
23191/103: sigprocmask(SIG_SETMASK, 0xFE0FBD8C, 0x00000000) = 0
23191/103: sigprocmask(SIG_SETMASK, 0xFE34A074, 0x00000000) = 0
23191/103: lwp_exit()
23191: write(6, 0x00BA8A08, 5660) = 5660
23191: \b\0\002\0 x L j 518\004\0 x `7F\0 x L e02 R\01F ;03\005\0 x\0 #
23191: \0\0\0\0\0\0\0\002 R\01F 8\0\005\0 x\0 #\0\0 0\0FFFFFFFEFFFFFE7F
23191: F\0\005\0 x `7F\0 x\0 #\0\0\0\002 R\01F 8 x\004\0 x\0 #\0\b\0\0
23191: \0\0\0\0 8 x\005\0 x\0 E\0\b80\0\0\0\0\0\0\0\0\0 8\0\004\0 x\0 F

Setup details.

postgresql-8.0.3
pgadmin3-1.2.2
wxWidgets 2.6.1
gtk+-2.6.8
gcc 3.2.3

Hardware
Sun sparc with Solaris 9 installed.

Regards - Steve Martin