hello list,
I’ve seen this in the log file, when uploading a metadata file to GeoNetwork, running on Postgres :
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction blockThe effect for the user is that you stay on (or come back to) the file upload page, with no error reported to the user.
Now I’m not totally sure exactly how I managed to do this, it may have been something like uploading a file, hitting “back” and doing it again.
Two points about it :
(1) should we take a close look at transaction handling / connection opening and closing, to prevent this ?
(2) if it does happen, shouldn’t we return an error to the user, rather than displaying the same page ?
Anybody else encountered this ?
Kind regards
Heikki Doeleman
hi,
to point 2: I say that there have to be a notice/error to the user because
user don´t know that import failed.
regards
Sarah
Heikki Doeleman wrote:
hello list,
I've seen this in the log file, when uploading a metadata file to
GeoNetwork, running on Postgres :
org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
commands ignored until end of transaction blockThe effect for the user is
that you stay on (or come back to) the file upload page, with no error
reported to the user.
Now I'm not totally sure exactly how I managed to do this, it may have
been
something like uploading a file, hitting "back" and doing it again.
Two points about it :
(1) should we take a close look at transaction handling / connection
opening
and closing, to prevent this ?
(2) if it does happen, shouldn't we return an error to the user, rather
than
displaying the same page ?
Anybody else encountered this ?
Kind regards
Heikki Doeleman
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register
now!
http://p.sf.net/sfu/devconf
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
--
View this message in context: http://n2.nabble.com/Postgres-transaction-error-tp3674566p3698475.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.