Обсуждение: Errors
Not sure how general this is but when trying to connect to the server via either a remote application or even a local php script, I get the following error. (It was working?) ERROR: No such attribute or function 'fio' pg_recvbuf: unexpected EOF on client connection Any help is much appreciated. Thanks
On Mon, 22 Apr 2002, J Norfleet wrote: > Not sure how general this is but when trying to connect to the server via > either a remote application or even a local php script, I get the following > error. (It was working?) > > ERROR: No such attribute or function 'fio' > pg_recvbuf: unexpected EOF on client connection > > Any help is much appreciated. > Thanks What changed or happened? What version of postgres are you running? What is the host system (of less interest)? What happens when you try connecting with psql? Try increasing the debug level of the postmaster, see postgres.conf file in the data directory, and see what messages appears. Though the answer to the first question is presumably going to be a good starting place since something must have changed or happened. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants
On Mon, 22 Apr 2002, J Norfleet wrote:
> On Monday 22 April 2002 3:15, you wrote:
> > On Mon, 22 Apr 2002, J Norfleet wrote:
> > > Not sure how general this is but when trying to connect to the server via
> > > either a remote application or even a local php script, I get the
> > > following error. (It was working?)
> > >
> > > ERROR: No such attribute or function 'fio'
> > > pg_recvbuf: unexpected EOF on client connection
> > >
> > > Any help is much appreciated.
> > > Thanks
> >
> > What changed or happened?
>
> Not sure. This project was handed to me a couple of months back and have had
> to learn sql as such. Not counting trying to document everything else.
>
> >
> > What version of postgres are you running? What is the host system (of less
> > interest)?
>
> postgressql 7.0.2. Running on slackware 7.
>
> >
> > What happens when you try connecting with psql?
>
> It connects fine. I can open all of the tables and edit them with no problem.
>
> > Try increasing the debug level of the postmaster, see postgres.conf file in
> > the data directory, and see what messages appears. Though the answer to the
> > first question is presumably going to be a good starting place since
> > something must have changed or happened.
>
> I have upped the error reporting to 5 and the fio error is the only report
> that seemed relevant. granted I'm still learning what the rest of it means :)
>
> I was told to try "grant all on <table> to nobody" but that still didn't
> help...
Ok, so does it matter what your remote client is trying to do? As in have all
your remote/PHP tests attempted to use something called fio? (Simple questions
sometimes lead in the direction of the problem) If so does the attribute or
function exists where your programs expect it to be? It may be the function or
column has been dropped.
Something may be causing your clients to exit, for example a SEGV, since the
message is definitely from the backend reporting an unexpected loss of
connection (I'm assuming that the client/server protocol has something in it to
'manage' a clean closing of a connection).
Are your clients using the correct version of the libraries etc.?
Do the local PHP tests use the same libraries as the local psql? Do you get
error reports in the clients' logs?
Do you get any core files from the clients?
I'm not sure what else to suggest at the moment. I've scanned the 7.0.2 source
tree and the only occurance of fio as a string is where the configure scripts
are checking for the sfio (safe fast IO) library.
Everyone else feel free to chime in :)
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants
I've looked at a bit of the reports stuff in PgAccess but am a little confused where to send changes. Do changes here go to the main Postgres CVS repository, i.e. pgsql-patches, or to Constantin Teodorescu <teo@flex.ro> whose site reportedly holds the latest version of the utility? The packaging as a separate entity on a separate site seems to indicate that pgaccess is maintained separately to the main postgres code and yet it's presence in the main source tree seems to indicate that it's not a maintained separately. Thinking about it, the contrib/ stuff would seem to be quite similar in this regard. Please forgive my asking here but my hackers lists subscription hasn't been completed yet. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants
Nigel J. Andrews wrote: > > > I've looked at a bit of the reports stuff in PgAccess but am a little confused > where to send changes. Do changes here go to the main Postgres CVS repository, > i.e. pgsql-patches, or to Constantin Teodorescu <teo@flex.ro> whose site > reportedly holds the latest version of the utility? > > The packaging as a separate entity on a separate site seems to indicate that > pgaccess is maintained separately to the main postgres code and yet it's > presence in the main source tree seems to indicate that it's not a maintained > separately. Thinking about it, the contrib/ stuff would seem to be quite > similar in this regard. > > Please forgive my asking here but my hackers lists subscription hasn't been > completed yet. You can send to patches and we will review it. If it looks questionable, we will ask Constantin for comments. Of course, you can send it to one and CC the other. We certainly are looking for pgaccess improvements. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026