{"action":"closed","issue":{"url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe/issues/735","repository_url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe","labels_url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe/issues/735/labels{/name}","comments_url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe/issues/735/comments","events_url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe/issues/735/events","html_url":"https://github.com/BjerknesClimateDataCentre/QuinCe/issues/735","id":299264575,"number":735,"title":"Duplicate standards error","user":{"login":"squaregoldfish","id":733650,"avatar_url":"https://avatars1.githubusercontent.com/u/733650?v=4","gravatar_id":"","url":"https://api.github.com/users/squaregoldfish","html_url":"https://github.com/squaregoldfish","followers_url":"https://api.github.com/users/squaregoldfish/followers","following_url":"https://api.github.com/users/squaregoldfish/following{/other_user}","gists_url":"https://api.github.com/users/squaregoldfish/gists{/gist_id}","starred_url":"https://api.github.com/users/squaregoldfish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/squaregoldfish/subscriptions","organizations_url":"https://api.github.com/users/squaregoldfish/orgs","repos_url":"https://api.github.com/users/squaregoldfish/repos","events_url":"https://api.github.com/users/squaregoldfish/events{/privacy}","received_events_url":"https://api.github.com/users/squaregoldfish/received_events","type":"User","site_admin":false},"labels":[{"id":889810009,"url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe/labels/PR","name":"PR","color":"c470e5","default":false},{"id":196680931,"url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe/labels/bug","name":"bug","color":"fc2929","default":true},{"id":689264190,"url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe/labels/calibration","name":"calibration","color":"bfd4f2","default":false}],"state":"closed","locked":false,"assignee":{"login":"squaregoldfish","id":733650,"avatar_url":"https://avatars1.githubusercontent.com/u/733650?v=4","gravatar_id":"","url":"https://api.github.com/users/squaregoldfish","html_url":"https://github.com/squaregoldfish","followers_url":"https://api.github.com/users/squaregoldfish/followers","following_url":"https://api.github.com/users/squaregoldfish/following{/other_user}","gists_url":"https://api.github.com/users/squaregoldfish/gists{/gist_id}","starred_url":"https://api.github.com/users/squaregoldfish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/squaregoldfish/subscriptions","organizations_url":"https://api.github.com/users/squaregoldfish/orgs","repos_url":"https://api.github.com/users/squaregoldfish/repos","events_url":"https://api.github.com/users/squaregoldfish/events{/privacy}","received_events_url":"https://api.github.com/users/squaregoldfish/received_events","type":"User","site_admin":false},"assignees":[{"login":"squaregoldfish","id":733650,"avatar_url":"https://avatars1.githubusercontent.com/u/733650?v=4","gravatar_id":"","url":"https://api.github.com/users/squaregoldfish","html_url":"https://github.com/squaregoldfish","followers_url":"https://api.github.com/users/squaregoldfish/followers","following_url":"https://api.github.com/users/squaregoldfish/following{/other_user}","gists_url":"https://api.github.com/users/squaregoldfish/gists{/gist_id}","starred_url":"https://api.github.com/users/squaregoldfish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/squaregoldfish/subscriptions","organizations_url":"https://api.github.com/users/squaregoldfish/orgs","repos_url":"https://api.github.com/users/squaregoldfish/repos","events_url":"https://api.github.com/users/squaregoldfish/events{/privacy}","received_events_url":"https://api.github.com/users/squaregoldfish/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe/milestones/22","html_url":"https://github.com/BjerknesClimateDataCentre/QuinCe/milestone/22","labels_url":"https://api.github.com/repos/BjerknesClimateDataCentre/QuinCe/milestones/22/labels","id":3135684,"number":22,"title":"v 0.2.4","description":"","creator":{"login":"squaregoldfish","id":733650,"avatar_url":"https://avatars1.githubusercontent.com/u/733650?v=4","gravatar_id":"","url":"https://api.github.com/users/squaregoldfish","html_url":"https://github.com/squaregoldfish","followers_url":"https://api.github.com/users/squaregoldfish/followers","following_url":"https://api.github.com/users/squaregoldfish/following{/other_user}","gists_url":"https://api.github.com/users/squaregoldfish/gists{/gist_id}","starred_url":"https://api.github.com/users/squaregoldfish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/squaregoldfish/subscriptions","organizations_url":"https://api.github.com/users/squaregoldfish/orgs","repos_url":"https://api.github.com/users/squaregoldfish/repos","events_url":"https://api.github.com/users/squaregoldfish/events{/privacy}","received_events_url":"https://api.github.com/users/squaregoldfish/received_events","type":"User","site_admin":false},"open_issues":8,"closed_issues":30,"state":"open","created_at":"2018-02-22T08:46:44Z","updated_at":"2018-04-25T13:14:06Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2018-02-22T08:45:17Z","updated_at":"2018-04-25T13:14:06Z","closed_at":"2018-04-25T13:14:06Z","author_association":"COLLABORATOR","body":"Adding a standard deployment at the same date/time as a previous deployment for that same standard throws an error. I assume this is the same for sensor calibrations too.\r\n\r\n\r\n```\r\nSomething horrible has happened. Please accept my apologies. Details of the horrible thing are below. If the horrible thing keeps happening, please copy the details into an email and send it to quince@uib.no.\r\nuk.ac.exeter.QuinCe.utils.DatabaseException: Error while storing calibration at uk.ac.exeter.QuinCe.data.Instrument.Calibration.CalibrationDB.addCalibration(CalibrationDB.java:85) at uk.ac.exeter.QuinCe.web.Instrument.CalibrationBean.storeEnteredCalibration(CalibrationBean.java:159) at uk.ac.exeter.QuinCe.web.Instrument.CalibrationBean.addCalibration(CalibrationBean.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.el.parser.AstValue.invoke(AstValue.java:247) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:267) at org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96) at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74) at javax.faces.component.UICommand.broadcast(UICommand.java:120) at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1172) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:365) at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1658) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:862) at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:42) at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:196) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:143) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at uk.ac.exeter.QuinCe.web.User.AuthenticatedFilter.doFilter(AuthenticatedFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '6-EXTERNAL_STANDARD-STD2-1483228800000' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1193) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) at uk.ac.exeter.QuinCe.data.Instrument.Calibration.CalibrationDB.addCalibration(CalibrationDB.java:83) ... 43 more\r\ncom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '6-EXTERNAL_STANDARD-STD2-1483228800000' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1193) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) at uk.ac.exeter.QuinCe.data.Instrument.Calibration.CalibrationDB.addCalibration(CalibrationDB.java:83) at uk.ac.exeter.QuinCe.web.Instrument.CalibrationBean.storeEnteredCalibration(CalibrationBean.java:159) at uk.ac.exeter.QuinCe.web.Instrument.CalibrationBean.addCalibration(CalibrationBean.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.el.parser.AstValue.invoke(AstValue.java:247) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:267) at org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96) at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74) at javax.faces.component.UICommand.broadcast(UICommand.java:120) at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1172) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:365) at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1658) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:862) at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:42) at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:196) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:143) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at uk.ac.exeter.QuinCe.web.User.AuthenticatedFilter.doFilter(AuthenticatedFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)\r\n```"}}
{"actor":{"display_login":"squaregoldfish"}}