
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

Thu, 12 Oct 2000 22:13:42 -0400
Dan Moschuk <dan@freebsd.org>
More postgres woes.