SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 07:07 PM
| ||||
| ||||
 Re: Problems displaying data from Query Tool and > -----Original Message----- > From: pgadmin-support-owner@postgresql.org > [mailto  gadmin-support-owner@postgresql.org] On Behalf Of> Steve Martin > Sent: 25 July 2005 22:33 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Problems displaying data from > Query Tool and > > Hello Dave, > > Thanks for your reply, I also suspected that it has something > to do with > the threading. > > I have compiled PostgreSQL with --enable-thread-safety > set and confirmed from the config.log that this option is set: > > : > : > It was created by PostgreSQL configure 8.0.3, which was > generated by GNU Autoconf 2.53. Invocation command line was > > $ ./configure --with-openssl --with-pam --enable-thread-safety > --enable-debug > > ## --------- ## > ## Platform. ## > ## --------- ## > > hostname = xxxxx > uname -m = sun4u > uname -r = 5.9 > uname -s = SunOS > uname -v = Generic_112233-07 > : > : > configure:18926: checking thread safety of required library functions > configure:18951: gcc -o conftest -O2 -Wall -Wmissing-prototypes > -Wpointer-arith -fno-strict-aliasing -g -pthreads -pthreads > -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DIN_CONFIGURE > -I/usr/local/ssl/include conftest.c -lpam -lssl -lcrypto -lz > -lreadline -ltermcap -lrt -lresolv -lgen -lsocket -lnsl -ldl -lm > -lpthread -lpthread >&5 > configure:18954: $? = 0 > configure:18956: ./conftest > Your errno is thread-safe. > Your system uses strerror() which is thread-safe. > Your system has getpwuid_r(); it does not need getpwuid(). > Your system has getaddrinfo(); it does not need gethostbyname() > or gethostbyname_r(). > > Your platform is thread-safe. > configure:18959: $? = 0 > configure:18961: result: yes > configure:19112: creating ./config.status > : > : > > I then re-made pgadmin, unfortunately, I still have the same > problems but I > suspect it has improved slightly. When using the Query > window, I now get > results more often than I did, but it still often fails. > Using the View > button > still results in 100% failure. > > I am using gdb to try and understand how this process works > but I can only > spend a short time at work looking at this problem. I have > no such problem > on my Linux (Fedora core 3) machine at home. > Hmm, you might also try increasing pgAdmin's debug level. I can remember how much logging is done by the query tools, but it might help. Look under File -> Options. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend      |
|
04-17-2008, 07:07 PM
| ||||
| ||||
| Re: Problems displaying data from Query Tool and > > >>-----Original Message----- >>From: pgadmin-support-owner@postgresql.org >>[mailto gadmin-support-owner@postgresql.org] On Behalf Of>>Steve Martin >>Sent: 25 July 2005 22:33 >>To: pgadmin-support@postgresql.org >>Subject: Re: [pgadmin-support] Problems displaying data from >>Query Tool and >> >>Hello Dave, >> >>Thanks for your reply, I also suspected that it has something >>to do with >>the threading. >> >>I have compiled PostgreSQL with --enable-thread-safety >>set and confirmed from the config.log that this option is set: >> >> : >> : >> It was created by PostgreSQL configure 8.0.3, which was >>generated by GNU Autoconf 2.53. Invocation command line was >> >> $ ./configure --with-openssl --with-pam --enable-thread-safety >>--enable-debug >> >>## --------- ## >>## Platform. ## >>## --------- ## >> >>hostname = xxxxx >>uname -m = sun4u >>uname -r = 5.9 >>uname -s = SunOS >>uname -v = Generic_112233-07 >> : >> : >>configure:18926: checking thread safety of required library functions >>configure:18951: gcc -o conftest -O2 -Wall -Wmissing-prototypes >>-Wpointer-arith -fno-strict-aliasing -g -pthreads -pthreads >>-D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DIN_CONFIGURE >>-I/usr/local/ssl/include conftest.c -lpam -lssl -lcrypto -lz >>-lreadline -ltermcap -lrt -lresolv -lgen -lsocket -lnsl -ldl -lm >>-lpthread -lpthread >&5 >>configure:18954: $? = 0 >>configure:18956: ./conftest >>Your errno is thread-safe. >>Your system uses strerror() which is thread-safe. >>Your system has getpwuid_r(); it does not need getpwuid(). >>Your system has getaddrinfo(); it does not need gethostbyname() >> or gethostbyname_r(). >> >>Your platform is thread-safe. >>configure:18959: $? = 0 >>configure:18961: result: yes >>configure:19112: creating ./config.status >> : >> : >> >>I then re-made pgadmin, unfortunately, I still have the same >>problems but I >>suspect it has improved slightly. When using the Query >>window, I now get >>results more often than I did, but it still often fails. >>Using the View >>button >>still results in 100% failure. >> >>I am using gdb to try and understand how this process works >>but I can only >>spend a short time at work looking at this problem. I have >>no such problem >>on my Linux (Fedora core 3) machine at home. >> >> >> > >Hmm, you might also try increasing pgAdmin's debug level. I can remember >how much logging is done by the query tools, but it might help. Look >under File -> Options. > >Regards, Dave. > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend > > > Thanks Dave for the advice, I have been using the log, it indicates the the query is sent, but there is no data received, I have confirmed that it is being sent. I now understand some of the code and will modify to get more information on what is happening. I am not a expert in threads, therefore it looks like a opportunity to learn. Regards, Steve -- \\|// From near to far, @ @ from here to there, ---oOOo-(_)-oOOo--- funny things are everywhere. (Dr. Seuss) xXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxX xXxXxXxXxXxXxXxXxXxXxXxXxXx Steve Martin < smartin@wlg.nec.co.nz > Cell 029-381 6291 Snail Mail Development, Telecom Unit, NEC New Zealand Ltd., PO Box 1936, Wellington, New Zealand. Voice: +64-4-381 1111 Fax: +64-4-381 6262 DDI +64-4-381 6291 NEC NZ web site: http://www.nec.co.nz xXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxX xXxXxXxXxXxXxXxXxXxXxXxXxXx |
Linear Mode
