exp.propertyvalidator" does not exist

LabKey Support Forum (Inactive)
exp.propertyvalidator" does not exist wnels2  2009-06-26 12:04
Status: Closed
 

I just did an update rebuild on the trunk, then went into the admin console>site settings to set the address of my Mascot server. When I clicked save it threw the exception below:

Thanks,
Bill


500: Unexpected server error

ERROR: relation "exp.propertyvalidator" does not exist
org.postgresql.util.PSQLException: ERROR: relation "exp.propertyvalidator" does not exist
       at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
       at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
       at org.labkey.api.data.ConnectionWrapper$StatementWrapper.executeQuery(ConnectionWrapper.java:984)
       at org.labkey.api.data.Table._executeQuery(Table.java:117)
       at org.labkey.api.data.Table._executeQuery(Table.java:89)
       at org.labkey.api.data.Table.internalExecuteQueryArray(Table.java:323)
       at org.labkey.api.data.Table.executeQuery(Table.java:310)
       at org.labkey.experiment.api.property.DomainPropertyManager._getValidators(DomainPropertyManager.java:80)
       at org.labkey.experiment.api.property.DomainPropertyManager.getValidators(DomainPropertyManager.java:66)
       at org.labkey.experiment.api.property.PropertyServiceImpl.getPropertyValidators(PropertyServiceImpl.java:132)
       at org.labkey.api.exp.OntologyManager.insertProperties(OntologyManager.java:1361)
       at org.labkey.api.exp.OntologyManager.insertProperties(OntologyManager.java:1517)
       at org.labkey.audit.AuditLogImpl.addEventProperties(AuditLogImpl.java:435)
       at org.labkey.audit.AuditLogImpl.addEvent(AuditLogImpl.java:391)
       at org.labkey.api.settings.AbstractWriteableSettingsGroup.writeAuditLogEvent(AbstractWriteableSettingsGroup.java:113)
       at org.labkey.core.admin.AdminController$ShowCustomizeSiteAction.handlePost(AdminController.java:1265)
       at org.labkey.core.admin.AdminController$ShowCustomizeSiteAction.handlePost(AdminController.java:1086)
       at org.labkey.api.action.FormViewAction.handleRequest(FormViewAction.java:91)
       at org.labkey.api.action.FormViewAction.handleRequest(FormViewAction.java:75)
       at org.labkey.api.action.BaseViewAction.handleRequestInternal(BaseViewAction.java:167)
       at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
       at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:336)
       at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:726)
       at org.labkey.api.view.ViewServlet.service(ViewServlet.java:140)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
       at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:36)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
       at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:124)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
       at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:651)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
       at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:101)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
       at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
       at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
       at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
       at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
       at java.lang.Thread.run(Thread.java:619)
request attributes
LABKEY.StartTime = 1246042657209
LABKEY.container = /
LABKEY.action = showCustomizeSite
LABKEY.RequestURL = /labkey/admin/showCustomizeSite.view?upgradeInProgress=1
LABKEY.controller = admin
LABKEY.OriginalURL = http://californium:8080/labkey/admin/showCustomizeSite.view?upgradeInProgress=1

core schema database configuration
Server URL    jdbc:postgresql://localhost/labkey
Product Name    PostgreSQL
Product Version    8.3.5
Driver Name    PostgreSQL Native Driver
Driver Version    PostgreSQL 8.3 JDBC3 with SSL (build 604)
 
 
wnels2 responded:  2009-06-26 12:28
I just ran the drts and I got the exception below. The database scripts did run ok when I restarted labkey after the rebuild. I'm running rebuild again to double check that it was cleaned but pretty sure it was. It is Friday afternoon though.
Thanks,
Bill


ERROR Table 2009-06-26 15:16:13,037 http-8080-Processor25 : SQL Exception
org.postgresql.util.PSQLException: ERROR: relation "exp.list" does not exist
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
    at org.labkey.api.data.ConnectionWrapper$StatementWrapper.executeQuery(ConnectionWrapper.java:984)
    at org.labkey.api.data.Table._executeQuery(Table.java:117)
    at org.labkey.api.data.Table._executeQuery(Table.java:89)
    at org.labkey.api.data.Table.internalExecuteQueryArray(Table.java:323)
    at org.labkey.api.data.Table.select(Table.java:1220)
 
wnels2 responded:  2009-06-26 13:04
I think I had damaged my database experimenting with table recovery. Sorry, just in a hurry to start the weekend.
Thanks,
Bill