Re: [Dspace-tech] SQLException how can I see the offending raw SQL
Dear Charlotte, we are working on the same issue on a DSpace 1.3.2 installation. Typically, it occurs during the submission process. When we figure it out, we'll post it here. When you find a solution, we'd also be interested. regards, Bram Luyten On Tue, Mar 4, 2008 at 9:40 AM, Charlotte Pollock <[EMAIL PROTECTED]> wrote: > Hi > > I'm getting an the following intermittent error > > database_error:org.postgresql.util.PSQLException: ERROR: current > transaction > is aborted, commands ignored until end of transaction block > > With no clear pattern as to why > > What I really would like to do is to see the raw SQL that is causing > postgres to error > > Does anyone know of a way to debug this error? > > Many thnaks > > Charlotte > > > > -- > Gall y neges e-bost hon, ac unrhyw atodiadau a anfonwyd gyda hi, > gynnwys deunydd cyfrinachol ac wedi eu bwriadu i'w defnyddio'n unig > gan y sawl y cawsant eu cyfeirio ato (atynt). Os ydych wedi derbyn y > neges e-bost hon trwy gamgymeriad, rhowch wybod i'r anfonwr ar > unwaith a dilëwch y neges. Os na fwriadwyd anfon y neges atoch chi, > rhaid i chi beidio â defnyddio, cadw neu ddatgelu unrhyw wybodaeth a > gynhwysir ynddi. Mae unrhyw farn neu safbwynt yn eiddo i'r sawl a'i > hanfonodd yn unig ac nid yw o anghenraid yn cynrychioli barn > Prifysgol Bangor. Nid yw Prifysgol Bangor yn gwarantu > bod y neges e-bost hon neu unrhyw atodiadau yn rhydd rhag firysau neu > 100% yn ddiogel. Oni bai fod hyn wedi ei ddatgan yn uniongyrchol yn > nhestun yr e-bost, nid bwriad y neges e-bost hon yw ffurfio contract > rhwymol - mae rhestr o lofnodwyr awdurdodedig ar gael o Swyddfa > Cyllid Prifysgol Bangor. www.bangor.ac.uk > > This email and any attachments may contain confidential material and > is solely for the use of the intended recipient(s). If you have > received this email in error, please notify the sender immediately > and delete this email. If you are not the intended recipient(s), you > must not use, retain or disclose any information contained in this > email. Any views or opinions are solely those of the sender and do > not necessarily represent those of the Bangor University. > Bangor University does not guarantee that this email or > any attachments are free from viruses or 100% secure. Unless > expressly stated in the body of the text of the email, this email is > not intended to form a binding contract - a list of authorised > signatories is available from the Bangor University Finance > Office. www.bangor.ac.uk > > > > - > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ > ___ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > > -- @mire NV Romeinse Straat 18 3001 Heverlee Belgium +32 2 888 29 56 http://www.atmire.com - Institutional Repository Solutions http://www.togather.eu - Before getting together, get [EMAIL PROTECTED] - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] SQLException how can I see the offending raw SQL
If you're using a postgres database, then you can turn up the logging on the database server. http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html Cheers, Reuben >>> Charlotte Pollock <[EMAIL PROTECTED]> 3/4/2008 2:40 AM >>> Hi I'm getting an the following intermittent error database_error:org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block With no clear pattern as to why What I really would like to do is to see the raw SQL that is causing postgres to error Does anyone know of a way to debug this error? Many thnaks Charlotte -- Gall y neges e-bost hon, ac unrhyw atodiadau a anfonwyd gyda hi, gynnwys deunydd cyfrinachol ac wedi eu bwriadu i'w defnyddio'n unig gan y sawl y cawsant eu cyfeirio ato (atynt). Os ydych wedi derbyn y neges e-bost hon trwy gamgymeriad, rhowch wybod i'r anfonwr ar unwaith a dilδwch y neges. Os na fwriadwyd anfon y neges atoch chi, rhaid i chi beidio Γ defnyddio, cadw neu ddatgelu unrhyw wybodaeth a gynhwysir ynddi. Mae unrhyw farn neu safbwynt yn eiddo i'r sawl a'i hanfonodd yn unig ac nid yw o anghenraid yn cynrychioli barn Prifysgol Bangor. Nid yw Prifysgol Bangor yn gwarantu bod y neges e-bost hon neu unrhyw atodiadau yn rhydd rhag firysau neu 100% yn ddiogel. Oni bai fod hyn wedi ei ddatgan yn uniongyrchol yn nhestun yr e-bost, nid bwriad y neges e-bost hon yw ffurfio contract rhwymol - mae rhestr o lofnodwyr awdurdodedig ar gael o Swyddfa Cyllid Prifysgol Bangor. www.bangor.ac.uk This email and any attachments may contain confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately and delete this email. If you are not the intended recipient(s), you must not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of the Bangor University. Bangor University does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract - a list of authorised signatories is available from the Bangor University Finance Office. www.bangor.ac.uk - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] SQLException how can I see the offending raw SQL
Hi Charlotte, if you set your log level to DEBUG, the queries will appear in the dspace log files. In order to do so edit [dspace-source]/config/templates/log4j.properties change the line log4j.rootCategory=INFO, A1 to log4j.rootCategory=DEBUG, A1 then you got to run [dspace]/bin/install-configs and restart your servlet container. Note that running in DEBUG mode will have an impact on performance and the log files will increase in size. hope that helps Claudia Charlotte Pollock schrieb: > Hi > > I'm getting an the following intermittent error > > database_error:org.postgresql.util.PSQLException: ERROR: current transaction > is aborted, commands ignored until end of transaction block > > With no clear pattern as to why > > What I really would like to do is to see the raw SQL that is causing > postgres to error > > Does anyone know of a way to debug this error? > > Many thnaks > > Charlotte > > > > > > > > - > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ > > > > > ___ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] SQLException how can I see the offending raw SQL
On Tue, Mar 04, 2008 at 08:40:32AM +, Charlotte Pollock wrote: > I'm getting an the following intermittent error > > database_error:org.postgresql.util.PSQLException: ERROR: current transaction > is aborted, commands ignored until end of transaction block > > With no clear pattern as to why > > What I really would like to do is to see the raw SQL that is causing > postgres to error > > Does anyone know of a way to debug this error? The only way to do this is to change your logging level from INFO to DEBUG in your log4j.properties (you'll need to redeploy DSpace after making the change, of course). Once you've done that, your dspace.log should contain all the queries sent to the db. cheers, Jim -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] SQLException how can I see the offending raw SQL
Hi I'm getting an the following intermittent error database_error:org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block With no clear pattern as to why What I really would like to do is to see the raw SQL that is causing postgres to error Does anyone know of a way to debug this error? Many thnaks Charlotte -- Gall y neges e-bost hon, ac unrhyw atodiadau a anfonwyd gyda hi, gynnwys deunydd cyfrinachol ac wedi eu bwriadu i'w defnyddio'n unig gan y sawl y cawsant eu cyfeirio ato (atynt). Os ydych wedi derbyn y neges e-bost hon trwy gamgymeriad, rhowch wybod i'r anfonwr ar unwaith a dilëwch y neges. Os na fwriadwyd anfon y neges atoch chi, rhaid i chi beidio â defnyddio, cadw neu ddatgelu unrhyw wybodaeth a gynhwysir ynddi. Mae unrhyw farn neu safbwynt yn eiddo i'r sawl a'i hanfonodd yn unig ac nid yw o anghenraid yn cynrychioli barn Prifysgol Bangor. Nid yw Prifysgol Bangor yn gwarantu bod y neges e-bost hon neu unrhyw atodiadau yn rhydd rhag firysau neu 100% yn ddiogel. Oni bai fod hyn wedi ei ddatgan yn uniongyrchol yn nhestun yr e-bost, nid bwriad y neges e-bost hon yw ffurfio contract rhwymol - mae rhestr o lofnodwyr awdurdodedig ar gael o Swyddfa Cyllid Prifysgol Bangor. www.bangor.ac.uk This email and any attachments may contain confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately and delete this email. If you are not the intended recipient(s), you must not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of the Bangor University. Bangor University does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract - a list of authorised signatories is available from the Bangor University Finance Office. www.bangor.ac.uk - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech