Re: Questions regarding notify processing.

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Questions regarding notify processing.
Date: 2005-02-25 11:00:19
Message-ID: 200502250600.33826.terry@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

See partial output from strace below. On this particular run, the command
locked up during the second edit operation. The notify message, move_update,
was delivered, but the PQsendquery never returns.

Any ideas Tom?

recv(3, "A\0\0\0\25\0\0~3move_update\0\0C\0\0\0\rUPDAT"..., 16384, 0) = 42
write(2, "CheckForNotifies: ASYNC NOTIFY o"..., 82CheckForNotifies: ASYNC
NOTIFY of 'move_update' from backend pid '32307' received
) = 82
write(2, "main/main.c: 1638: backEndNotify"..., 54main/main.c: 1638:
backEndNotify (32307: move_update)
) = 54
write(2, "main/main.c: 1655: backEndNotify"..., 43main/main.c: 1655:
backEndNotify (leaving)
) = 43
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
ioctl(4, FIONREAD, [32]) = 0
read(4, "\34\364_\264\311\4\300\7<\1\0\0\304\243G\22\0\0\0\0\304"..., 32) = 32
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
ioctl(4, FIONREAD, [32]) = 0
read(4, "\34\364_\264\311\4\300\7\f\1\0\0\305\243G\22\0\4\300\7"..., 32) = 32
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
ioctl(4, FIONREAD, [384]) = 0
read(4, "\34\364_\264\311\4\300\7\365\0\0\0\306\243G\22\0\0\0\0"..., 384) =
384
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
ioctl(4, FIONREAD, [32]) = 0
read(4, "\226\252_\264\311\4\300\7\311\4\300\7\0\0\0\0\370\0\177"..., 32) = 32
write(4, "\2\2\4\0\314\4\300\7\0\10\0\0}\240 \0", 16) = 16
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
write(4, "8\2\4\0\32\0\300\7\0\0\10\0\0\0\0\0>\5\7\0\312\4\300\7"..., 500) =
500
read(4, 0xbffff040, 32) = -1 EAGAIN (Resource temporarily
unavailable)
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
read(4, "\1\1t\264\0\0\0\0\304\364\3\1\370\0\177\1\320\2460\t`\347"..., 32) =
32
write(4, "\17\2\2\0\314\4\300\7", 8) = 8
read(4, 0xbffff120, 32) = -1 EAGAIN (Resource temporarily
unavailable)
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
read(4, "\1ku\264\0\0\0\0\257\0\0\0\311\4\300\7\0\0\0\0\0\0\0\0"..., 32) = 32
write(4, "B\2\7\0\314\4\300\7\24\0\300\7\256\0(at)\0\3\1@\0\256\0A\0"..., 64) =
64
read(4, 0xbffff0b0, 32) = -1 EAGAIN (Resource temporarily
unavailable)
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
read(4, "\1tx\264\0\0\0\0\257\0\0\0\311\4\300\7\0\0;\t\260\267\343"..., 32) =
32
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
ioctl(4, FIONREAD, [0]) = 0
write(4, "F\2\v\0\314\4\300\7\r\0\300\7\252\0<\0^\0\2\0\252\0j\0"..., 44) = 44
ioctl(4, FIONREAD, [0]) = 0
gettimeofday({1109328767, 349228}, NULL) = 0
select(5, [3 4], [], [], NULL) = 1 (in [4])
ioctl(4, FIONREAD, [32]) = 0
read(4, "\36\203y\264\0\0\0\0\247\3\300\7]\1`\1\1\0\0\0^\1\0\0%"..., 32) = 32
write(4, "\24\0\6\0]\1`\1%\1\0\0\0\0\0\0\0\0\0\0\200\226\230\0", 24) = 24
read(4, 0xbffff2f0, 32) = -1 EAGAIN (Resource temporarily
unavailable)
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
read(4, "\1\0z\264\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 32) = 32
write(4, "+\0\1\0", 4) = 4
read(4, 0xbffff2e0, 32) = -1 EAGAIN (Resource temporarily
unavailable)
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
read(4, "\1\1{\264\0\0\0\0\311\4\300\7\0\0\0\0\1\0\0\0\2\0\0\0@"..., 32) = 32
write(4, "\22\0\25\0]\1`\1%\1\0\0\4\0\0\0 \0\0\0\17\0\0\0^\1\0\0"..., 132) =
132
read(4, 0xbffff440, 32) = -1 EAGAIN (Resource temporarily
unavailable)
select(5, [4], NULL, NULL, NULL) = 1 (in [4])
read(4, "\1\1~\264\0\0\0\0\311\4\300\7\0\0\0\0\0\0\0\0\2\0\0\0@"..., 32) = 32
select(5, [3], [], [], {0, 0}) = 0 (Timeout)
ioctl(4, FIONREAD, [0]) = 0
ioctl(4, FIONREAD, [0]) = 0
gettimeofday({1109328768, 129317}, NULL) = 0
select(5, [3 4], [], [], NULL) = 1 (in [4])

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Venkatesh Babu 2005-02-25 11:17:47 Table UPDATE statement
Previous Message Richard Huxton 2005-02-25 10:18:33 Re: Maximum size for varchar