Thread: Errors

Errors

From
J Norfleet
Date:
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

Re: Errors

From
"Nigel J. Andrews"
Date:
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


Re: Errors

From
"Nigel J. Andrews"
Date:
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


PgAccess patching

From
"Nigel J. Andrews"
Date:

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


Re: PgAccess patching

From
Bruce Momjian
Date:
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