Thread: More postgres woes.

More postgres woes.

From
Dan Moschuk
Date:
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)
0xff215dd0in _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 ()
52Thread 17 (LWP 15)  0xff215dd0 in _poll () 51 Thread 16 (LWP 14)  0xff215dd0 in _poll () 50 Thread 15 (LWP 13)
0xff215dd0in _poll () 49 Thread 14 (LWP 12)  0xff215dd0 in _poll () 48 Thread 13 (LWP 11)  0xff215dd0 in _poll () 47
Thread12 (LWP 9)  0xff215dd0 in _poll () 46 Thread 11 (LWP 10)  0xff21488c in _so_accept () 45 Thread 10 (LWP 7)
0xff21488cin _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
Thread5 (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
0xff215dd0in _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
0xff215dd0in _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
0xff21488cin _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