Re: [Dspace-tech] Postgres optimizations
Hi! Mika, I was able to try backup and reinstate dspace. Thanks. I deleted few items from DSpace. I believe their handle details still exist in postgres. I executed VACUUMDB and then the display in the DOS command line was VACCUM. I hope the command was executed successfully. IS there any way to flush out the items that are permanently deleted from DSPace. Does vacuumdb remove deleted collections/items which are permanently deleted and not shown on the DSpace GUI collection/item interface. Please suggest. Thanks, jayan -Original Message- From: Mika Stenberg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 5:40 PM To: Jayan Chirayath Kurian Subject: Re: [Dspace-tech] Postgres optimizations Hi, Im using pg_dump to backup db: pg_dump dspace /dspace/dbbackup/dspace.db And rsync to backup dspace-directory and assetsore rsync -av --delete /usr/local/dspace-1.4/ /usr/local/dspace_backup/weekly/dspace-1.4/ Then my local backups are transferred to another server via WinScp script, which if very useful. You can actually skip rsync if you use Winscp with /synchronize option. You could also Zip the contents to save some space. Did this help? -Mika Hi! Mika, Could you please suggest regarding how to take backups for DSpace instances. I am using Dspace 1.4.1 on windows 2003. Thanks, Jayan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mika Stenberg Sent: Tuesday, May 29, 2007 4:13 PM To: 'dspace-tech@lists.sourceforge.net' Subject: [Dspace-tech] Postgres optimizations Im hoping to get some hints for postgres performance optimization. Our DSpace (1.4.1) has started to run really slow after the number of items exceeded 40 000 (mainly metadata, few full texts only). I tried increasing work_memory and max_fsm_pages in postgres.conf but with little help. Im also running regular vacuum and reindex for the db. Any help would be appreaciated, -Mika - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Mika Stenberg IT-asiantuntija Terveystieteiden Keskuskirjasto Lääketieteellinen tdk PL 61 (Haartmaninkatu 4) Helsingin Yliopisto 00290 Helsinki puh. +358-9-191 26807 - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] back up and restore help
http://wiki.dspace.org/index.php/BackupRestore From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shali 9846303531 Sent: Friday, July 13, 2007 2:41 PM To: dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] back up and restore help Dear Sir, Anybody tell me how to backup dspace server in Ubuntu and how to restore it in a new system??? Thanking you, -- Shali.K.R Asst.Librarian(Digital) Vidya Academy of Science Technology Thrissur, Kerala. Mob:9847593531,9846303531 - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] back up and restore help
Dear Sir, Anybody tell me how to backup dspace server in Ubuntu and how to restore it in a new system??? Thanking you, -- Shali.K.R Asst.Librarian(Digital) Vidya Academy of Science Technology Thrissur, Kerala. Mob:9847593531,9846303531 - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Postgres optimizations
Hi Jayan! Postgresql ANALYZE option is very useful: it calculate statistics for the query optimizer. It is very speedy. VACUUM is a lot slower and reclaims internal unused space. It is useful if you have deleted a lot of data. It does not make any data change or logical change. If the DSpace delete does not clean its data correctly, VACUUM will not change anything. I suspect DSpace may keep handle records to never reallocate handles to different documents. One way to do anything you want (at your own risks) is to use pgAdmin III to make any change you need at SQL level. Just remind that items are also indexed by Lucene and you will have to run the DSIndexer if you change any text field. Have a nice week-end! Christophe Jayan Chirayath Kurian a écrit : Hi! Mika, I was able to try backup and reinstate dspace. Thanks. I deleted few items from DSpace. I believe their handle details still exist in postgres. I executed VACUUMDB and then the display in the DOS command line was VACCUM. I hope the command was executed successfully. IS there any way to flush out the items that are permanently deleted from DSPace. Does vacuumdb remove deleted collections/items which are permanently deleted and not shown on the DSpace GUI collection/item interface. Please suggest. Thanks, jayan -Original Message- From: Mika Stenberg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 5:40 PM To: Jayan Chirayath Kurian Subject: Re: [Dspace-tech] Postgres optimizations Hi, Im using pg_dump to backup db: pg_dump dspace /dspace/dbbackup/dspace.db And rsync to backup dspace-directory and assetsore rsync -av --delete /usr/local/dspace-1.4/ /usr/local/dspace_backup/weekly/dspace-1.4/ Then my local backups are transferred to another server via WinScp script, which if very useful. You can actually skip rsync if you use Winscp with /synchronize option. You could also Zip the contents to save some space. Did this help? -Mika Hi! Mika, Could you please suggest regarding how to take backups for DSpace instances. I am using Dspace 1.4.1 on windows 2003. Thanks, Jayan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mika Stenberg Sent: Tuesday, May 29, 2007 4:13 PM To: 'dspace-tech@lists.sourceforge.net' Subject: [Dspace-tech] Postgres optimizations Im hoping to get some hints for postgres performance optimization. Our DSpace (1.4.1) has started to run really slow after the number of items exceeded 40 000 (mainly metadata, few full texts only). I tried increasing work_memory and max_fsm_pages in postgres.conf but with little help. Im also running regular vacuum and reindex for the db. Any help would be appreaciated, -Mika - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech begin:vcard fn:Christophe Dupriez n:Dupriez;Christophe org:DESTIN inc. SSEB adr;quoted-printable:;;rue des Palais 44, bo=C3=AEte 1;Bruxelles;;B-1030;Belgique email;internet:[EMAIL PROTECTED] title:Informaticien tel;work:+32/2/216.66.15 tel;fax:+32/2/242.97.25 tel;cell:+32/475.77.62.11 note;quoted-printable:D=C3=A9veloppement de Syst=C3=A8mes de Traitement de l'Information x-mozilla-html:TRUE url:http://www.destin.be version:2.1 end:vcard - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] InitializeBrowse Exception
Hi! I have uploaded almost 100,000 records into DSpace (1.4.1 on windows). While giving the InitializeBrowse command, the following error appears. This went well when there were only 3000 records. Could you please suggest how to proceed. Thanks, Jayan E:\DSpace\bindsrun org.dspace.browse.InitializeBrowse Using DSpace installation in: E:\DSpace Indexing all Items in DSpaceException in thread main java.lang.OutOfMemory Error: Java heap space at java.lang.StringCoding$StringDecoder.decode(Unknown Source) at java.lang.StringCoding.decode(Unknown Source) at java.lang.String.init(Unknown Source) at java.lang.String.init(Unknown Source) at org.dspace.storage.rdbms.DatabaseManager.process(DatabaseManager.java :1257) at org.dspace.storage.rdbms.TableRowIterator.next(TableRowIterator.java: 151) at org.dspace.content.Item.init(Item.java:145) at org.dspace.content.ItemIterator.next(ItemIterator.java:117) at org.dspace.browse.Browse.indexAll(Browse.java:606) at org.dspace.browse.InitializeBrowse.main(InitializeBrowse.java:74) org.postgresql.util.PSQLException: An I/O error occured while sending to the bac kend. Exception: java.net.SocketException: Socket closed Stack Trace: java.net.SocketException: Socket closed at java.net.SocketOutputStream.socketWrite(Unknown Source) at java.net.SocketOutputStream.write(Unknown Source) at java.io.BufferedOutputStream.flushBuffer(Unknown Source) at java.io.BufferedOutputStream.flush(Unknown Source) at org.postgresql.core.PGStream.flush(PGStream.java:508) at org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.j ava:675) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:190) at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionComman d(AbstractJdbc2Connection.java:653) at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Co nnection.java:690) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConne ction.java:265) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConne ction.java:265) at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.roll back(PoolingDriver.java:348) at org.dspace.core.Context.abort(Context.java:251) at org.dspace.core.Context.finalize(Context.java:384) at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) at java.lang.ref.Finalizer.runFinalizer(Unknown Source) at java.lang.ref.Finalizer.access$100(Unknown Source) at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source) End of Stack Trace at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja va:217) at org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionComman d(AbstractJdbc2Connection.java:653) at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Co nnection.java:690) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConne ction.java:265) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConne ction.java:265) at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.roll back(PoolingDriver.java:348) at org.dspace.core.Context.abort(Context.java:251) at org.dspace.core.Context.finalize(Context.java:384) at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) at java.lang.ref.Finalizer.runFinalizer(Unknown Source) at java.lang.ref.Finalizer.access$100(Unknown Source) at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source) java.sql.SQLException: Already closed. at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.j ava:77) at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.clos e(PoolingDriver.java:240) at org.dspace.storage.rdbms.DatabaseManager.freeConnection(DatabaseManag er.java:733) at org.dspace.core.Context.abort(Context.java:260) at org.dspace.core.Context.finalize(Context.java:384) at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) at java.lang.ref.Finalizer.runFinalizer(Unknown Source) at java.lang.ref.Finalizer.access$100(Unknown Source) at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source) - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net
[Dspace-tech] Dspace vs Greenstone
Hi alll, Good day!. I would like to know which is the best between Dspace and Greenstone in terms of easy to install and configure,learning curve,performance and usability in Library. Thank you for your help udd - Need a vacation? Get great deals to amazing places on Yahoo! Travel. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Dspace vs Greenstone
Twaha: We at Cornell University use both DSpace and Greenstone, but for different purposes. DSpace is our institutional repository where we store videos, presentations, papers and books. Greenstone is used as a Newspaper archive for our Campus Newspaper. So, they are used very differently. At 11:03 AM 7/13/2007, Twaha Daudi wrote: Hi alll, Good day!. I would like to know which is the best between Dspace and Greenstone in terms of easy to install and configure,learning curve,performance and usability in Library. Thank you for your help udd Need a vacation? http://us.rd.yahoo.com/evt=48256/*http://travel.yahoo.com/;_ylc=X3oDMTFhN2hucjlpBF9TAzk3NDA3NTg5BHBvcwM1BHNlYwNncm91cHMEc2xrA2VtYWlsLW5jbQ--Get great deals to amazing places on Yahoo! Travel. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ 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 DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] need your help again - internal system error
Ok i tried now but i doesnt work, it killed my dspace.cfg file L Content of the file is now: Unable to locate tools.jar. Expected to find it in /usr/lib/jvm/java-1.4.2-gcj-4.1-1.4.2.0/lib/tools.jar Apache Ant version 1.6.5 compiled on October 26 2005 Buildfile: build.xml does not exist! In my /usr/lib/jvm/java-1.4.2-gcj-4.1-1.4.2.0 folder a directory lib doesn't exist! Really confused now Von: George Kozak [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 13. Juli 2007 17:46 An: Felix Mayerhofer Betreff: Re: [Dspace-tech] need your help again - internal system error Felix: It looks to me like you need to change the DSPace hostname dspace.cfg file to what you are really using and then do an ant -Dconfig=(path-to-config file)/dspace.cfg update At 11:32 AM 7/13/2007, you wrote: Hi folks! Just testing around with my new installation, and it seems dspace doesn't run properly, evey time I try to make an upload I get an internal server error Could this happen when visit the site via ip address, cuz the hostname I provided doesn't exist yet? Hope somebody can help! Here's the email alert: An internal server error occurred on http://dspace.myhost.com/dspace: Date: 12.07.07 09:32 Session ID: E7EA989FF6CF5E948DB68CC33AD0621D -- URL Was: http://192.168.36.175:8080/dspace/submit -- Method: POST -- Parameters were: -- dc_identifier_value_0: -- step: 2 -- dc_relation_ispartofseries_1: -- dc_identifier_qualifier_0: issn -- dc_relation_ispartofseries_0: -- dc_contributor_author_last_0: 45645 -- dc_language_iso: -- submit_next: Next -- dc_title: zrtztrztrzrtzrz -- dc_contributor_author_first_0: ertrzrtztr -- workspace_item_id: 10 -- dc_type: Book Exception: java.sql.SQLException: bad_dublin_core SchemaID=1, contributor author at org.dspace.content.Item.update(Item.java:1463) at org.dspace.content.WorkspaceItem.update(WorkspaceItem.java:473) at org.dspace.app.webui.servlet.SubmitServlet.userHasReached(SubmitServlet. java:2209) at org.dspace.app.webui.servlet.SubmitServlet.processEditMetadata(SubmitSer vlet.java:963) at org.dspace.app.webui.servlet.SubmitServlet.doDSPost(SubmitServlet.java:3 82) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet. java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105 ) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnly Filter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon textValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo ntext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5 20) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:79 9) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:57 7) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:684) at
Re: [Dspace-tech] need your help again - internal system error
Felix: I'm confused as well. How did you compile your DSpace to begin with? At 11:59 AM 7/13/2007, Felix Mayerhofer wrote: Ok i tried now but i doesnt work, it killed my dspace.cfg file L Content of the file is now: Unable to locate tools.jar. Expected to find it in /usr/lib/jvm/java-1.4.2-gcj-4.1-1.4.2.0/lib/tools.jar Apache Ant version 1.6.5 compiled on October 26 2005 Buildfile: build.xml does not exist! In my /usr/lib/jvm/java-1.4.2-gcj-4.1-1.4.2.0 folder a directory lib doesn't exist! Really confused now Von: George Kozak [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 13. Juli 2007 17:46 An: Felix Mayerhofer Betreff: Re: [Dspace-tech] need your help again - internal system error Felix: It looks to me like you need to change the DSPace hostname dspace.cfg file to what you are really using and then do an ant -Dconfig=(path-to-config file)/dspace.cfg update At 11:32 AM 7/13/2007, you wrote: Hi folks! Just testing around with my new installation, and it seems dspace doesn't run properly, evey time I try to make an upload I get an internal server error Could this happen when visit the site via ip address, cuz the hostname I provided doesn't exist yet? Hope somebody can help! Here's the email alert: An internal server error occurred on http://dspace.myhost.com/dspacehttp://dspace.myhost.com/dspace: Date: 12.07.07 09:32 Session ID: E7EA989FF6CF5E948DB68CC33AD0621D -- URL Was: http://192.168.36.175:8080/dspace/submithttp://192.168.36.175:8080/dspace/submit -- Method: POST -- Parameters were: -- dc_identifier_value_0: -- step: 2 -- dc_relation_ispartofseries_1: -- dc_identifier_qualifier_0: issn -- dc_relation_ispartofseries_0: -- dc_contributor_author_last_0: 45645 -- dc_language_iso: -- submit_next: Next -- dc_title: zrtztrztrzrtzrz -- dc_contributor_author_first_0: ertrzrtztr -- workspace_item_id: 10 -- dc_type: Book Exception: java.sql.SQLException: bad_dublin_core SchemaID=1, contributor author at org.dspace.content.Item.update(Item.java:1463) at org.dspace.content.WorkspaceItem.update(WorkspaceItem.java:473) at org.dspace.app.webui.servlet.SubmitServlet.userHasReached(SubmitServlet.java:2209) at org.dspace.app.webui.servlet.SubmitServlet.processEditMetadata(SubmitServlet.java:963) at org.dspace.app.webui.servlet.SubmitServlet.doDSPost(SubmitServlet.java:382) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at
[Dspace-tech] Another Internal System Error
I too need some analysis of an Internal System Error (Dspace 1.4.2). In attempting to submit something to my test instance, after filling out the items on the second step and selecting next I got the DEBUG error below. I'm using Oracle and understand the JDBC refers to a problem with the Oracle tables. Not sure which table, data type, etc I should be investigating. An internal server error occurred on http://cassandra.usc.edu:8180/dspace: Date: 7/13/07 9:25 AM Session ID: B9B08D52FA84D1E7B4D4EE95A2BF9EF0 -- URL Was: http://cassandra.usc.edu:8180/dspace/submit -- Method: POST -- Parameters were: -- dc_type: Article -- dc_contributor_author_last_0: Helstien -- dc_relation_ispartofseries_1: 5678 -- submit_next: Next -- dc_title: My Test Submission -- dc_contributor_author_first_0: Brian -- dc_identifier_value_0: 1234-5678 -- dc_identifier_qualifier_0: issn -- workspace_item_id: 82 -- dc_relation_ispartofseries_0: 1234 -- step: 2 -- dc_language_iso: en_US Exception: java.lang.IllegalArgumentException: Unsupported JDBC type: at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:14 87) at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:815 ) at org.dspace.content.MetadataValue.create(MetadataValue.java:253) at org.dspace.content.Item.update(Item.java:1493) at org.dspace.content.WorkspaceItem.update(WorkspaceItem.java:473) at org.dspace.app.webui.servlet.SubmitServlet.userHasReached(SubmitServlet. java:2209) at org.dspace.app.webui.servlet.SubmitServlet.processEditMetadata(SubmitSer vlet.java:963) at org.dspace.app.webui.servlet.SubmitServlet.doDSPost(SubmitServlet.java:3 82) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet. java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105 ) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnly Filter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 48) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86 9) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc essConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow erWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .java:684) at java.lang.Thread.run(Thread.java:595) Brian A. Helstien, SISD, MLS, Director, Special Technologies Initiatives, IDM, University Libraries x06913 University of Southern California, (213) 740-6913 Los Angeles, California, 90089 [EMAIL PROTECTED] Information is independent of media or format -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, July 13, 2007 8:59 AM To: dspace-tech@lists.sourceforge.net Subject: DSpace-tech Digest, Vol 15, Issue 28 Send DSpace-tech mailing list submissions to dspace-tech@lists.sourceforge.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/dspace-tech or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than Re: Contents of DSpace-tech digest... Today's Topics: 1. need your help again - internal system error (Felix Mayerhofer) 2. Re: Dspace vs Greenstone (George Kozak) 3. Re: need your help again - internal system error (Felix Mayerhofer) --
