pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedinvalid lo descriptorc in begin commit fraze
5+ messages / 3 participants
[nested] [flat]
* invalid lo descriptorc in begin commit fraze
@ 2000-02-15 17:12 M.Mazurek@poznan.multinet.pl
0 siblings, 0 replies; 5+ messages in thread
From: M.Mazurek@poznan.multinet.pl @ 2000-02-15 17:12 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
I have a servlet which some lo (images) from postgres and ouputs them to
the web page. If I start only one instatnce of that servlet - no
problem. When there are serveral servlets reading lo -
FastPath call returned ERROR: lo_read: invalid large obj descriptor (1)
I have db.AutoCommit(false) at opening the connection, and
db.commit() after reading data.
How to read serveral lo, even the same one in the same time from various
servlets avoiding that error?
linux2.0.13, jserv1.1, postgresql6.3.5, jsdk2.0, jdk1.2.2
thx
mazek
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] invalid lo descriptorc in begin commit fraze
@ 2000-02-16 08:52 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 1 reply; 5+ messages in thread
From: Peter Mount @ 2000-02-16 08:52 UTC (permalink / raw)
To: 'M.Mazurek@poznan.multinet.pl' <M.Mazurek@poznan.multinet.pl>; pgsql-interfaces
I'll look into it. There shouldn't be anything in the driver to limit
the number of concurrent objects.
Does anyone else see this type of problem (I'm thinking of those who use
libpq rather than JDBC)?
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: M.Mazurek@poznan.multinet.pl [mailto:M.Mazurek@poznan.multinet.pl]
Sent: Tuesday, February 15, 2000 5:12 PM
To: pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] invalid lo descriptorc in begin commit fraze
Hi,
I have a servlet which some lo (images) from postgres and ouputs them to
the web page. If I start only one instatnce of that servlet - no
problem. When there are serveral servlets reading lo -
FastPath call returned ERROR: lo_read: invalid large obj descriptor (1)
I have db.AutoCommit(false) at opening the connection, and
db.commit() after reading data.
How to read serveral lo, even the same one in the same time from various
servlets avoiding that error?
linux2.0.13, jserv1.1, postgresql6.3.5, jsdk2.0, jdk1.2.2
thx
mazek
************
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] invalid lo descriptorc in begin commit fraze
@ 2000-02-16 15:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2000-02-16 15:10 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: 'M.Mazurek@poznan.multinet.pl' <M.Mazurek@poznan.multinet.pl>; pgsql-interfaces
Peter Mount <petermount@it.maidstone.gov.uk> writes:
> I'll look into it. There shouldn't be anything in the driver to limit
> the number of concurrent objects.
> Does anyone else see this type of problem (I'm thinking of those who use
> libpq rather than JDBC)?
I got the impression that what he was talking about was multiple
independent threads issuing commands across a single backend connection.
When one thread commits its transaction, all the others lose their open
LO descriptors. I don't see any way to fix that short of changing the
client code so that each thread is talking to a different backend.
If I'm all wrong about this, I'll crawl back in my hole now...
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] invalid lo descriptorc in begin commit fraze
@ 2000-02-17 09:11 M.Mazurek@poznan.multinet.pl
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: M.Mazurek@poznan.multinet.pl @ 2000-02-17 09:11 UTC (permalink / raw)
To: pgsql-interfaces
On Wed, 16 Feb 2000, Tom Lane wrote:
> I got the impression that what he was talking about was multiple
> independent threads issuing commands across a single backend connection.
NO, evry servlet starts his own connection. Is not to be very occupied
site, so I allowed my self for such a simplicity:).
It's enough to have three starting servlets, and lo_read error is
generated.
mazek
Marcin Mazurek
--
administrator
MULTINET SA o/Poznan
http://www.multinet.pl/
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: [INTERFACES] invalid lo descriptorc in begin commit fraze
@ 2000-02-17 09:21 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Peter Mount @ 2000-02-17 09:21 UTC (permalink / raw)
To: 'M.Mazurek@poznan.multinet.pl' <M.Mazurek@poznan.multinet.pl>; pgsql-interfaces
Hmmm, as these are on separate connections, it sounds like its the
backend having problems, not JDBC.
Sorry, I seem to have missed part of the thread amist the chaos here at
work :-(
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: M.Mazurek@poznan.multinet.pl [mailto:M.Mazurek@poznan.multinet.pl]
Sent: Thursday, February 17, 2000 9:12 AM
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] invalid lo descriptorc in begin commit fraze
On Wed, 16 Feb 2000, Tom Lane wrote:
> I got the impression that what he was talking about was multiple
> independent threads issuing commands across a single backend
connection.
NO, evry servlet starts his own connection. Is not to be very occupied
site, so I allowed my self for such a simplicity:).
It's enough to have three starting servlets, and lo_read error is
generated.
mazek
Marcin Mazurek
--
administrator
MULTINET SA o/Poznan
http://www.multinet.pl/
************
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2000-02-17 09:21 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-15 17:12 invalid lo descriptorc in begin commit fraze M.Mazurek@poznan.multinet.pl
2000-02-16 08:52 RE: [INTERFACES] invalid lo descriptorc in begin commit fraze Peter Mount <petermount@it.maidstone.gov.uk>
2000-02-16 15:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-02-17 09:11 ` M.Mazurek@poznan.multinet.pl
2000-02-17 09:21 RE: [INTERFACES] invalid lo descriptorc in begin commit fraze Peter Mount <petermount@it.maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox