Hello all,
I am running dspace 1.4.1 on linux enterprise Version 3 update 6 have
just tried copying the data folder and assetstore folder form my test
server to the production server to test a Backup procedure. I am now
unable to start the postgres database. I Backed up the original
production data and assetstore folders then deleted them and copied over
the test server ones, I noted that I had to re assign the assetstore to
the dspace user as the root user for some reason came up as the owner
after the copy. I Also had to make the postgres user the owner of the
data folder again. Now when I return to the original data and assetstore
folders I get the same error...
I get this error when trying to start postgres database:
pg_ctl: another server may be running; trying to start server anyway
pg_ctl: could not start server
Examine the log output.
Also I am unable to locate the postgres log file, this is my postgres
start up command /usr/local/pgsql/bin/pg_ctl -D /dbdata/data -l logfile
start Can anyone point me in the direction of the postgres logfile?
The dspace log file reflects what looks like two general errors (Ive
pasted them below) when trying to run cronjobs for checksum / filter
media / DailyReportEmailer I'm not sure what cronjob is generating the
errors, but of course these errors are in response to my moving the data
and assetstore folders coupled with root taking ownership of the
folders. I am now unclear as to why I cannot restart postgres even after
restoring the original folders and ensuring the original owners are
assigned. Does anyone have any input on this issue??
Thanks,
Nigel
2008-02-12 20:00:08,121 WARN org.dspace.jsp @
anonymous:session_id=F3F09DDEDAC04171EF9B9991C178C8EA:ip_addr=192.168.25
4.3:database_error:org.postgresql.util.PSQLException: ERROR: could not
open relation 1663/16386/1259: Permission denied
org.postgresql.util.PSQLException: ERROR: could not open relation
1663/16386/1259: Permission denied
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1548)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1316)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
191)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:337)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:236)
at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getPrimaryKeys(Abstra
ctJdbc2DatabaseMetaData.java:2941)
at
org.dspace.storage.rdbms.DatabaseManager.retrieveColumnInfo(DatabaseMana
ger.java:1530)
at
org.dspace.storage.rdbms.DatabaseManager.getColumnInfoInternal(DatabaseM
anager.java:1498)
at
org.dspace.storage.rdbms.DatabaseManager.getColumnInfo(DatabaseManager.j
ava:890)
at
org.dspace.storage.rdbms.DatabaseManager.getColumnNames(DatabaseManager.
java:963)
at
org.dspace.storage.rdbms.DatabaseManager.process(DatabaseManager.java:12
23)
at
org.dspace.storage.rdbms.TableRowIterator.next(TableRowIterator.java:151
)
at org.dspace.content.Community.findAllTop(Community.java:275)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:92)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
va:384)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:228)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:175)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:104)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:2
16)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84
4)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(
Http11Protocol.java:634)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
at java.lang.Thread.run(Thread.java:595)
Nigel Pegus
Main Library, Systems Unit
The University of the West Indies
ext: 2241
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
