[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
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] Moving items to new collection
Dear colleagues, I want to move items from one collection to another in order to delete the old collection but still retain the handles on the items. One colleague suggested the following, but he stressed that he had not tried it before: I would try exporting the item ( you'll get the handle ), then deleting the collection and then reimport the item with the handle. Does this sound like the right approach? I've searched the documentation but have found nothing about moving items from one collection to another. Thanks in advance for your advice. David Reynolds Manager of Scholarly Digital Initiatives Johns Hopkins University 3400 N. Charles St. Baltimore, MD 21218-2683 [EMAIL PROTECTED] (410) 516-7220 - 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] Moving items to new collection
David: I would do this in SQL. Here is an example of the command I use: update collection2item set collection_id=new collection's id where item_id=item's id; Then I do the following: update item set owning_collection=new collection's id where item_id=item's id; OR run index_all after making the changes and it would fix the owning collections and communities. If you have a lot of items to move, then a PERL script could be used (if you have DBD::Pg compiled for your PERL module). At 09:58 AM 3/4/2008, David Reynolds wrote: Dear colleagues, I want to move items from one collection to another in order to delete the old collection but still retain the handles on the items. One colleague suggested the following, but he stressed that he had not tried it before: I would try exporting the item ( you'll get the handle ), then deleting the collection and then reimport the item with the handle. Does this sound like the right approach? I've searched the documentation but have found nothing about moving items from one collection to another. Thanks in advance for your advice. David Reynolds Manager of Scholarly Digital Initiatives Johns Hopkins University 3400 N. Charles St. Baltimore, MD 21218-2683 [EMAIL PROTECTED] (410) 516-7220 - 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 *** George Kozak Coordinator Web Development and Management Digital Media Group 501 Olin Library Cornell University 607-255-8924 *** [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
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
[Dspace-tech] Error in filter-media
We have recently been getting the following error in the filter-media cron: Exception in thread main java.lang.OutOfMemoryError: Java heap space I changed -Xmx256m in the java command in dsrun to -Xmx512m (documentation says that's the max you can set it to) and we're still getting the error. How can we get rid of this error? Here is the full command in our dsrun script: java -Xmx512m -classpath $FULLPATH $@ We are running a production instance of DSpace 1.4.2 with postgreSQL 7.3.4 on a Solaris 10 platform. Thanks in advance. Sue Sue Walker-Thornton ConITS Contract NASA Langley Research Center //Integrated Library Systems Application Administrator/DBA 130 Research Drive Hampton, VA 23666 Office: (757) 224-4074 Fax:(757) 224-4001 Pager: (757) 988-2547 Email: [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] Error in filter-media
Have you tried using the pdffilter.largepdfs and pdffilter.skiponmemoryexception parameters? Turning on largepdfs will tell pdfbox to use a temporary file while processing the pdf instead of keeping it all in memory. It will use the standard java.io.tmpdir directory to store them in. In addition using skip memory exception will allow the process to just continue instead of blocking everything else. Scott-- On Mar 4, 2008, at 3:12 PM, Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] wrote: We have recently been getting the following error in the filter- media cron: Exception in thread main java.lang.OutOfMemoryError: Java heap space I changed –Xmx256m in the java command in dsrun to –Xmx512m (documentation says that’s the max you can set it to) and we’re still getting the error. How can we get rid of this error? Here is the full command in our dsrun script: java -Xmx512m -classpath $FULLPATH $@ We are running a production instance of DSpace 1.4.2 with postgreSQL 7.3.4 on a Solaris 10 platform. Thanks in advance. Sue Sue Walker-Thornton ConITS Contract NASA Langley Research Center Integrated Library Systems Application Administrator/DBA 130 Research Drive Hampton, VA 23666 Office: (757) 224-4074 Fax:(757) 224-4001 Pager: (757) 988-2547 Email: [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 - 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] Error in filter-media
Oh, Sorry. The parameters go into your dspace.cfg. They are both boolean parameters so just add: pdffilter.largepdfs = true; or pdffilter.skiponmemoryexception = true; Then re-run your dsrun command and they will take effect. Scott-- On Mar 4, 2008, at 6:13 PM, Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] wrote: Hi Scott, Thanks for the info, but can you tell me exactly where to put/ how to format the parameters? Do they go on the dsrun command? Thanks again, Sue From: Scott Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 6:51 PM To: Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Error in filter-media Have you tried using the pdffilter.largepdfs and pdffilter.skiponmemoryexception parameters? Turning on largepdfs will tell pdfbox to use a temporary file while processing the pdf instead of keeping it all in memory. It will use the standard java.io.tmpdir directory to store them in. In addition using skip memory exception will allow the process to just continue instead of blocking everything else. Scott-- On Mar 4, 2008, at 3:12 PM, Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] wrote: We have recently been getting the following error in the filter- media cron: Exception in thread main java.lang.OutOfMemoryError: Java heap space I changed –Xmx256m in the java command in dsrun to –Xmx512m (documentation says that’s the max you can set it to) and we’re still getting the error. How can we get rid of this error? Here is the full command in our dsrun script: java -Xmx512m -classpath $FULLPATH $@ We are running a production instance of DSpace 1.4.2 with postgreSQL 7.3.4 on a Solaris 10 platform. Thanks in advance. Sue Sue Walker-Thornton ConITS Contract NASA Langley Research Center Integrated Library Systems Application Administrator/DBA 130 Research Drive Hampton, VA 23666 Office: (757) 224-4074 Fax:(757) 224-4001 Pager: (757) 988-2547 Email: [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 - 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] Error in filter-media
Hi again Scott, I added both of those to dspace.cfg and it didn't seem to have any effect - I got the same error again: Exception in thread main java.lang.OutOfMemoryError: Java heap space Are those parameters valid for DSpace 1.4.2? Thanks again, Sue -Original Message- From: Scott Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 7:28 PM To: Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Error in filter-media Oh, Sorry. The parameters go into your dspace.cfg. They are both boolean parameters so just add: pdffilter.largepdfs = true; or pdffilter.skiponmemoryexception = true; Then re-run your dsrun command and they will take effect. Scott-- On Mar 4, 2008, at 6:13 PM, Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] wrote: Hi Scott, Thanks for the info, but can you tell me exactly where to put/ how to format the parameters? Do they go on the dsrun command? Thanks again, Sue From: Scott Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 6:51 PM To: Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Error in filter-media Have you tried using the pdffilter.largepdfs and pdffilter.skiponmemoryexception parameters? Turning on largepdfs will tell pdfbox to use a temporary file while processing the pdf instead of keeping it all in memory. It will use the standard java.io.tmpdir directory to store them in. In addition using skip memory exception will allow the process to just continue instead of blocking everything else. Scott-- On Mar 4, 2008, at 3:12 PM, Thornton, Susan M. (LARC-B702)[NCI INFORMATION SYSTEMS] wrote: We have recently been getting the following error in the filter- media cron: Exception in thread main java.lang.OutOfMemoryError: Java heap space I changed -Xmx256m in the java command in dsrun to -Xmx512m (documentation says that's the max you can set it to) and we're still getting the error. How can we get rid of this error? Here is the full command in our dsrun script: java -Xmx512m -classpath $FULLPATH $@ We are running a production instance of DSpace 1.4.2 with postgreSQL 7.3.4 on a Solaris 10 platform. Thanks in advance. Sue Sue Walker-Thornton ConITS Contract NASA Langley Research Center Integrated Library Systems Application Administrator/DBA 130 Research Drive Hampton, VA 23666 Office: (757) 224-4074 Fax:(757) 224-4001 Pager: (757) 988-2547 Email: [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 - 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