Not able to insert the large data to HP-UX IA machines

From: "Mavinakuli, Prasanna (STSD)" <prasanna(dot)b-m(at)hp(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Not able to insert the large data to HP-UX IA machines
Date: 2005-09-02 13:52:53
Message-ID: E84C4F56CA80174D8834825116CF247F011714CA@bgeexc05.asiapacific.cpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We are supposed to insert the large data which is around 200 k/row.
(Through libpq)

We are able to do it in HP-UX PA machines.not in HP-UX IA machines.
We can insert the data upto 46k in IA machines.(we have bytea field .and
most(all) of data go to this field)

When we try to insert the large data or data which is more than
47 k server will be waiting forever.(we are using pqexecparams to insert
the data)

Here is the sample output got using "tusc"

write(1, "\n", 1)
........................................................................
.............................. = 1
getuid()
........................................................................
....................................... = 0 (0)
stat("/etc/krb5.conf", 0x9ffffffffffef720)
........................................................................
..... ERR#2 ENOENT
stat("/usr/etc/krb5.conf", 0x9ffffffffffef720)
........................................................................
. ERR#2 ENOENT
getuid()
........................................................................
....................................... = 0 (0)
open("/var/spool/pwgr/status", O_RDONLY|0x800, 0)
...................................................................... =
3
mmap(NULL, 532, PROT_READ, MAP_SHARED|MAP_VARIABLE|MAP_FILE|MAP_ADDR32,
3, 0) .......................................... = 0xc1654000
close(3)
........................................................................
....................................... = 0
socket(AF_UNIX, SOCK_DGRAM, 0)
........................................................................
................. = 3
getpid()
........................................................................
....................................... = 12692101 (12692099)
unlink("/var/spool/sockets/pwgr/client12692101")
.......................................................................
ERR#2 ENOENT
bind(3, 0x9fffffffef77dba0, 41)
........................................................................
................ = 0
fcntl(3, F_SETFD, 1)
........................................................................
........................... = 0
time(NULL)
........................................................................
..................................... = 1125660775
stat("/etc/default/lugname", 0x9ffffffffffed3d0)
.......................................................................
ERR#2 ENOENT
poll(0x9ffffffffffee278, 1, 0)
........................................................................
................. = 1
sendto(3, "\0\0\00 \0\0\001\0\0\0\0\0\0\001".., 48, 0,
0x9fffffffef77dc00, 0x19) ....................................... = 48
poll(0x9ffffffffffee278, 1, 1000)
........................................................................
.............. = 1
recvfrom(3, "\0\0\03 \0\0\0\0\0\0\0\0\0\0\0# ".., 2064, 0,
0x9ffffffffffee320, 0x9ffffffffffee274) ..................... = 51
socket(AF_UNIX, SOCK_STREAM, 0)
........................................................................
................ = 4
fcntl(4, F_SETFL, 65536)
........................................................................
....................... = 0
connect(4, 0x6000000000033670, 94)
........................................................................
............. = 0### Buffer size ###write(1, "# # # B u f f e r s i
z e ".., 19)
..................................................................... =
19
60760write(1, "6 0 7 6 0 ", 5)
........................................................................
...................... = 5

write(1, "\n", 1)
........................................................................
.............................. = 1
entered****write(1, "e n t e r e d * * * * ", 11)
........................................................................
......... = 11

write(1, "\n", 1)
........................................................................
.............................. = 1
brk(0x6000000000100000)
........................................................................
........................ = 0
before calling pqexec dummy ******write(1, "b e f o r e c a l l i n g
p ".., 34) .........................................................
............ = 34

write(1, "\n", 1)
........................................................................
.............................. = 1
brk(0x6000000000120000)
........................................................................
........................ = 0
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
send(4, "P \0\0\0u \0i n s e r t i n t ".., 98304, 0)
................................................................ = 32768
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
recv(4, 0x600000000007acc0, 16384, 0)
........................................................................
.......... ERR#11 EAGAIN
poll(0x9fffffffffff00d0, 1, -1)
........................................................................
................ = 1
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
send(4, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0".., 65536, 0)
................................................................ = 32768
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
recv(4, 0x600000000007acc0, 16384, 0)
........................................................................
.......... ERR#11 EAGAIN
poll(0x9fffffffffff00d0, 1, -1)
........................................................................
................ = 1
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
send(4, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0".., 32768, 0)
................................................................ = 32768
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
sigaction(SIGPIPE, 0x9fffffffffff0090, 0x9fffffffffff00c0)
............................................................. = 0
send(4, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0".., 1888, 0)
................................................................. = 1888
sigaction(SIGPIPE, 0x9fffffffffff0090, 0x9fffffffffff00c0)
............................................................. = 0
poll(0x9fffffffffff01f0, 1, -1)
........................................................................
................ = 1
poll(0x9fffffffffff0300, 1, -1)
........................................................................
................ = 1
recv(4, "C \0\0\0\vC O M M I T \0Z \0\0\0".., 16384, 0)
................................................................ = 18
brk(0x6000000000140000)
........................................................................
........................ = 0
size of additional buffer *****write(1, "s i z e o f a d d i t i o n
".., 31) ............................................................
......... = 31
0write(1, "0 ", 1)
........................................................................
.............................. = 1

write(1, "\n", 1)
........................................................................
.............................. = 1
entered****write(1, "e n t e r e d * * * * ", 11)
........................................................................
......... = 11

write(1, "\n", 1)
........................................................................
.............................. = 1
before calling pqexec dummy ******write(1, "b e f o r e c a l l i n g
p ".., 34) .........................................................
............ = 34

rite(1, "\n", 1)
........................................................................
.............................. = 1
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
send(4, "P \0\0\0u \0i n s e r t i n t ".., 98304, 0)
................................................................ = 32768
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
recv(4, 0x600000000007acc0, 16384, 0)
........................................................................
.......... ERR#11 EAGAIN
poll(0x9fffffffffff00d0, 1, -1)
........................................................................
................ = 1
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
send(4, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0".., 65536, 0)
................................................................ = 8192
sigaction(SIGPIPE, 0x9fffffffffff0080, 0x9fffffffffff00b0)
............................................................. = 0
recv(4, 0x600000000007acc0, 16384, 0)
........................................................................
.......... ERR#11 EAGAIN
poll(0x9fffffffffff00d0, 1, -1)
........................................................................
................ [sleeping]
ksleep(PTH_CONDVAR_OBJECT, 0x9fffffffef7de4b8, 0x6000000000059388, NULL)
............................................... [sleeping]

***this is point where that hangs*****

Looking for u'r suggetions,
Thx in advance,
Prasanna.

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-09-02 14:15:16 Re: LOG: unexpected EOF within message length word
Previous Message Terry Lee Tucker 2005-09-02 13:29:36 Re: Question regarding FOUND