More postgres woes.

From: Dan Moschuk <dan(at)freebsd(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: More postgres woes.
Date: 2000-10-13 02:13:42
Message-ID: 20001012221342.A5268@spirit.jaded.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


This time in the client library...

(gdb) bt
#0 0xff215dd0 in _poll ()
#1 0xff1ce79c in select ()
#2 0xff08b164 in select ()
#3 0xff338ec0 in PQgetResult (conn=0xa89c8) at fe-exec.c:1126
#4 0xff339168 in PQexec (conn=0xa89c8,
query=0xfe107b98 "UPDATE url SET total_os='4963.98|135037.3153|4731.63|23.2|0.0|211.2|720.10|', total_browser='125815.2813|19371.503|54.4|3.0|414.4|487.3|6.0|0.0|', total_country='0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|2."...)
at fe-exec.c:1231
#5 0x19778 in c2_pgdb_update_r (
query=0xfe107b98 "UPDATE url SET total_os='4963.98|135037.3153|4731.63|23.2|0.0|211.2|720.10|', total_browser='125815.2813|19371.503|54.4|3.0|414.4|487.3|6.0|0.0|', total_country='0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|0.0|2."...,
pgfd=0xfe109c0c) at pgdb.c:161
#6 0x145f0 in syncUrlSQL (pgfd=0xfe109c0c, rec=0xe835938) at db.c:251
#7 0x129e8 in command_server (sockmyballs=0x4) at command_server.c:181

67 Thread 44 (LWP 33) 0xff215dd0 in _poll ()
66 Thread 40 (LWP 30) 0xff215dd0 in _poll ()
65 Thread 39 (LWP 29) 0xff215dd0 in _poll ()
64 Thread 34 (LWP 28) 0xff215dd0 in _poll ()
63 Thread 30 (LWP 27) 0xff217bb4 in __lwp_sema_wait ()
62 Thread 27 (LWP 24) 0xff215dd0 in _poll ()
61 Thread 26 (LWP 25) 0xff215dd0 in _poll ()
60 Thread 25 (LWP 23) 0xff215dd0 in _poll ()
59 Thread 24 (LWP 22) 0xff215dd0 in _poll ()
58 Thread 23 (LWP 21) 0xff215dd0 in _poll ()
57 Thread 22 (LWP 20) 0xff215dd0 in _poll ()
56 Thread 21 (LWP 18) 0xff215dd0 in _poll ()
55 Thread 20 (LWP 19) 0xff215dd0 in _poll ()
54 Thread 19 (LWP 17) 0xff215dd0 in _poll ()
53 Thread 18 (LWP 16) 0xff215dd0 in _poll ()
52 Thread 17 (LWP 15) 0xff215dd0 in _poll ()
51 Thread 16 (LWP 14) 0xff215dd0 in _poll ()
50 Thread 15 (LWP 13) 0xff215dd0 in _poll ()
49 Thread 14 (LWP 12) 0xff215dd0 in _poll ()
48 Thread 13 (LWP 11) 0xff215dd0 in _poll ()
47 Thread 12 (LWP 9) 0xff215dd0 in _poll ()
46 Thread 11 (LWP 10) 0xff21488c in _so_accept ()
45 Thread 10 (LWP 7) 0xff21488c in _so_accept ()
44 Thread 9 (LWP 8) 0xff21488c in _so_accept ()
43 Thread 8 (LWP 4) 0xff21488c in _so_accept ()
42 Thread 7 (LWP 6) 0xff21488c in _so_accept ()
41 Thread 6 (LWP 5) 0xff21488c in _so_accept ()
40 Thread 5 (LWP 3) 0xff217050 in _read ()
39 Thread 4 (LWP 1) 0xff217050 in _read ()
38 Thread 3 0xff217bb4 in __lwp_sema_wait ()
37 Thread 2 (LWP 2) 0xff217584 in _signotifywait ()
36 Thread 1 0xff217bb4 in __lwp_sema_wait ()
35 Thread 28 0xff217bb4 in __lwp_sema_wait ()
34 LWP 35 0xff217bb4 in __lwp_sema_wait ()
33 LWP 34 0xff21515c in door_restart ()
32 LWP 33 0xff215dd0 in _poll ()
31 LWP 31 0xff217bb4 in __lwp_sema_wait ()
30 LWP 30 0xff215dd0 in _poll ()
29 LWP 29 0xff215dd0 in _poll ()
28 LWP 28 0xff215dd0 in _poll ()
27 LWP 27 0xff217bb4 in __lwp_sema_wait ()
26 LWP 26 0xff217bb4 in __lwp_sema_wait ()
25 LWP 25 0xff215dd0 in _poll ()
24 LWP 24 0xff215dd0 in _poll ()
23 LWP 23 0xff215dd0 in _poll ()
22 LWP 22 0xff215dd0 in _poll ()
21 LWP 21 0xff215dd0 in _poll ()
20 LWP 20 0xff215dd0 in _poll ()
19 LWP 19 0xff215dd0 in _poll ()
18 LWP 18 0xff215dd0 in _poll ()
17 LWP 17 0xff215dd0 in _poll ()
16 LWP 16 0xff215dd0 in _poll ()
15 LWP 15 0xff215dd0 in _poll ()
14 LWP 14 0xff215dd0 in _poll ()
13 LWP 13 0xff215dd0 in _poll ()
12 LWP 12 0xff215dd0 in _poll ()
* 11 LWP 11 0xff215dd0 in _poll ()
10 LWP 10 0xff21488c in _so_accept ()
9 LWP 9 0xff215dd0 in _poll ()
8 LWP 8 0xff21488c in _so_accept ()
7 LWP 7 0xff21488c in _so_accept ()
6 LWP 6 0xff21488c in _so_accept ()
5 LWP 5 0xff21488c in _so_accept ()
4 LWP 4 0xff21488c in _so_accept ()
3 LWP 3 0xff217050 in _read ()
2 LWP 2 0xff217584 in _signotifywait ()
1 LWP 1 0xff217050 in _read ()

Pretty much all my threads are stuck waiting for data. :(

--
Man is a rational animal who always loses his temper when he is called
upon to act in accordance with the dictates of reason.
-- Oscar Wilde

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-10-13 03:02:05 FreeBSD core team history
Previous Message Philip Warner 2000-10-13 01:59:09 Re: Small patch to replace 'idle' by 'trans' if transaction is still open