Thread: postgres 7.0.3 hangs
Hi, Is there any known problem with postgres 7.0.3 on a linux box (2.4 kernel) hanging? I noticed it from time to time in the past, but it was infrequent enough that I didn't do anything about it, but its become a much more pervasive problem. I have multiple threads runing and one of them hangs on an INSERT (visible in the process listing). When I check the process status, it is sleeping. Other threads, presumably trying to access a locked resource also hang (though they are otherwise response, you can do other things so long as you don't access whatever resource is locked). Even if a I kill the sleeping process, the next one that comes in place after it (presumably waiting on that lock) blocks in the same way. I have to restart the whole database to get things to work again. I know this is not a very detailed analysis, but has anyone seen anything like it before? Is upgrading postgres likeley to solve the problem? Thanks, Sheer
Hello all! I hope you can help me with this.
I'm trying to configure as such:
./configure --with-tcl --with-perl --with-openssl --enable-odbc --enable-sys
log
Now to do this --with-tcl i needed to install the TCL/TK files.
TCL went ok without a hitch.
but whenever i try to do a make test with TK (v8.3.4) i get a load of
errors.
any help would be appreciates. below is the errors:
jonese
----------------
su-2.04# make test
gcc -pipe -c -O -Wall -Wconversion -Wno-implicit-int -fPIC -I/usr/home/jone
se/tk8.3.4/unix -I/usr/home/jonese/tk8.3.4/unix/../generic -I/usr/home/jone
se/tk8.3.4/unix/../bitmaps -I/usr/home/jonese/tcl8.3.4/generic -DHAVE_UNIS
TD_H=1 -DHAVE_LIMITS_H=1 -DSTDC_HEADERS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SY
S_TIME=1 -DHAVE_PW_GECOS=1 -DTCL_NO_DEPRECATED -DTK_TEST
/usr/home/jonese/tk8.3.4/unix/tkAppInit.c
In file included from /usr/home/jonese/tk8.3.4/unix/tkAppInit.c:16:
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:83: X11/Xlib.h: No such file
or directory
In file included from /usr/home/jonese/tk8.3.4/unix/tkAppInit.c:16:
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:581: syntax error before
`Bool'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:591: syntax error before
`Bool'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:597: syntax error before
`Bool'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:657: syntax error before
`Display'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:660: syntax error before
`Visual'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:662: syntax error before
`Window'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:671: syntax error before
`XWindowChanges'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:673: syntax error before
`XSetWindowAttributes'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:787: syntax error before
`XPoint'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:887: syntax error before
`Display'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:889: syntax error before
`Display'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:985: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1049: syntax error before `GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1061: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1091: syntax error before
`Display'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1094: syntax error before
`Display'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1337: syntax error before
`XErrorEvent'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1339: syntax error before
`XEvent'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1341: syntax error before
`XEvent'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1343: syntax error before
`XEvent'
/usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1348: syntax error before
`XEvent'
In file included from /usr/home/jonese/tk8.3.4/unix/../generic/tk.h:1361,
from /usr/home/jonese/tk8.3.4/unix/tkAppInit.c:16:
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:37: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:37: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:39: syntax error before
`Tk_3DBorderGC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:40: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:43: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:48: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:57: syntax error before
`XEvent'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:76: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:80: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:90: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:95: syntax error before
`GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:115: syntax error before
`XSetWindowAttributes'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:122: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:125: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:146: syntax error before
`XWindowChanges'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:164: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:185: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:229: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:239: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:244: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:248: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:254: syntax error before
`GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:256: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:262: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:267: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:274: syntax error before
`Tk_FontId'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:274: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:278: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:281: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:283: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:286: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:291: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:296: syntax error before
`Display'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:299: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:305: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:307: syntax error before
`Tk_GCForColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:307: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:308: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:324: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:330: syntax error before
`Tk_GetBitmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:331: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:333: syntax error before
`Tk_GetBitmapFromData'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:335: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:340: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:341: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:343: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:344: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:344: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:346: syntax error before
`Tk_GetColormap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:347: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:367: syntax error before
`Tk_GetGC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:369: syntax error before
`XGCValues'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:369: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:396: syntax error before
`Tk_GetPixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:396: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:397: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:414: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:419: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:421: syntax error before
`Colormap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:421: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:430: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:432: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:441: syntax error before
`Tk_InternAtom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:442: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:478: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:483: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:485: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:503: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:540: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:543: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:548: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:583: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:592: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:595: syntax error before
`Colormap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:598: syntax error before
`Visual'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:601: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:618: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:624: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:640: syntax error before
`Tk_AllocBitmapFromObj'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:642: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:648: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:650: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:693: syntax error before
`Tk_GetBitmapFromObj'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:694: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:696: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:697: warning: data
definition has no type or storage class
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:763: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:766: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:779: syntax error before
`GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:787: syntax error before
`GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:794: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:798: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:814: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:842: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:844: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:845: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:847: syntax error before
`XEvent'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:852: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:853: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:856: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:858: syntax error before
`GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:863: syntax error before
`XSetWindowAttributes'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:865: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:866: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:871: syntax error before
`XWindowChanges'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:876: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:882: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:894: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:898: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:899: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:900: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:901: syntax error before
`GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:902: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:903: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:904: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:906: syntax error before
`Font'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:908: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:909: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:910: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:911: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:913: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:915: syntax error before
`Display'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:916: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:918: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:924: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:926: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:929: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:937: syntax error before
`GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:946: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:951: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:953: syntax error before
`Visual'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:956: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:957: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:960: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:973: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:975: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:976: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:983: syntax error before
`Atom'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:994: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:995: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:996: syntax error before
`Drawable'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1007: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1010: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1011: syntax error before
`Colormap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1012: syntax error before
`Visual'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1013: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1019: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1020: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1026: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1028: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1042: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1063: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1064: syntax error before
`*'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1068: syntax error before
`GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1070: syntax error before
`GC'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1072: syntax error before
`Pixmap'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1073: syntax error before
`XColor'
/usr/home/jonese/tk8.3.4/unix/../generic/tkDecls.h:1077: syntax error before
`Pixmap'
*** Error code 1
Stop in /usr/home/jonese/tk8.3.4/unix.
Sheer El-Showk <sheer@saraf.com> writes:
> Is there any known problem with postgres 7.0.3
There are lots of known problems with 7.0.*. If you can reproduce this
behavior after updating to 7.1.3, though, I'd be interested in looking
into it ...
regards, tom lane