Issue 45466: Multiple LSID matches from ExperimentServiceImpl.findType()

issues
Status:closed
Assigned To:Guest
Type:Defect
Area:Experiment
Priority:3
Milestone:22.07
Opened:2022-05-09 12:52 by jeckels
Changed:2022-05-09 17:44 by jeckels
Resolved:2022-05-09 17:44 by jeckels
Resolution:Fixed
Support Ticket: 
Pull Requests:platform#3333
Closed:2022-05-09 17:44 by jeckels
2022-05-09 12:52 jeckels
Title»Multiple LSID matches from ExperimentServiceImpl.findType()
Assigned To»jeckels
Type»Defect
Area»Experiment
Priority»3
Milestone»22.07
Created from crash report: https://www.labkey.org/_mothership/mothership-showStackTraceDetail.view?exceptionStackTraceId=31579

org.springframework.jdbc.UncategorizedSQLException: ExecutingSelector; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Query returned 2 String objects; expected 1 or 0.; nested exception is java.sql.SQLException: Query returned 2 String objects; expected 1 or 0.
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:90)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
    at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:37)
    at org.labkey.api.data.ExceptionFramework$1.translate(ExceptionFramework.java:31)
    at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.handleSqlException(SqlExecutingSelector.java:563)
    at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.handleResultSet(SqlExecutingSelector.java:472)
    at org.labkey.api.data.BaseSelector.getObject(BaseSelector.java:335)
    at org.labkey.api.data.BaseSelector.getObject(BaseSelector.java:169)
    at org.labkey.experiment.api.ExperimentServiceImpl.findType(ExperimentServiceImpl.java:3530)
    at org.labkey.experiment.api.ExperimentServiceImpl.getObject(ExperimentServiceImpl.java:3506)
    at org.labkey.api.exp.LsidManager.getObject(LsidManager.java:355)
    at org.labkey.api.exp.LsidManager.getObject(LsidManager.java:269)
    at org.labkey.experiment.controllers.exp.ExperimentController$BaseResolveLsidApiAction.validateForm(ExperimentController.java:6513)
    at org.labkey.experiment.controllers.exp.ExperimentController$LineageAction.validateForm(ExperimentController.java:6547)
    at org.labkey.experiment.controllers.exp.ExperimentController$BaseResolveLsidApiAction.validateForm(ExperimentController.java:6501)
    at org.labkey.api.action.BaseApiAction.validate(BaseApiAction.java:545)
    at org.labkey.api.action.BaseApiAction.handlePost(BaseApiAction.java:169)
    at org.labkey.api.action.ReadOnlyApiAction.handleGet(ReadOnlyApiAction.java:34)
    at org.labkey.api.action.BaseApiAction.handleRequest(BaseApiAction.java:131)
    at org.labkey.api.action.BaseViewAction.handleRequest(BaseViewAction.java:176)
    at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:511)
    at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1118)
    at org.labkey.api.view.ViewServlet._service(ViewServlet.java:218)
    at org.labkey.api.view.ViewServlet.service(ViewServlet.java:142)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:40)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:1352)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:218)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:120)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.sql.SQLException: Query returned 2 String objects; expected 1 or 0.
    at org.labkey.api.data.BaseSelector$3.handle(BaseSelector.java:342)
    at org.labkey.api.data.BaseSelector$3.handle(BaseSelector.java:335)
    at org.labkey.api.data.SqlExecutingSelector$ExecutingResultSetFactory.handleResultSet(SqlExecutingSelector.java:455)
    ... 53 more

2022-05-09 13:20 jeckels
Pull Requests»https://github.com/LabKey/platform/pull/3333

2022-05-09 17:44 jeckels
resolve as Fixed
Statusopen»resolved
No good repro but now resolved in develop.

2022-05-09 17:44 jeckels
close
Statusresolved»closed
Assigned Tojeckels»Guest