Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Error merging databases #1214

Closed
jpschewe opened this issue Dec 11, 2024 · 1 comment
Closed

Error merging databases #1214

jpschewe opened this issue Dec 11, 2024 · 1 comment
Labels
bug
Milestone
19.1

Comments

@jpschewe
Copy link
Owner

I was trying to merge the datafiles onto FLL1 and received the error below.

It asked me about accepting changes regarding the script and i told it to maintain what was in the Destination datafile. Not sure if that is what caused it or not.

Error messages:

Error talking to the database
integrity constraint violation: foreign key no action ; SCHEDULE_FK3 table: SCHEDULE
integrity constraint violation: foreign key no action ; SCHEDULE_FK3 table: SCHEDULE
Full exception trace:

Error talking to the database
fll.web.developer.importdb.ExecuteImport.processRequest(ExecuteImport.java:103)
fll.web.BaseFLLServlet.doGet(BaseFLLServlet.java:37)
jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
fll.web.InitFilter.doFilter(InitFilter.java:110)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
fll.web.FooterFilter.doFilter(FooterFilter.java:57)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:391)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1736)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
java.base/java.lang.Thread.run(Thread.java:1583)
integrity constraint violation: foreign key no action ; SCHEDULE_FK3 table: SCHEDULE
org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
fll.db.ImportDB.importTournamentTeams(ImportDB.java:2640)
fll.db.ImportDB.importTournamentData(ImportDB.java:2165)
fll.db.ImportDB.importDatabase(ImportDB.java:1990)
fll.web.developer.importdb.ExecuteImport.processRequest(ExecuteImport.java:82)
fll.web.BaseFLLServlet.doGet(BaseFLLServlet.java:37)
jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
fll.web.InitFilter.doFilter(InitFilter.java:110)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
fll.web.FooterFilter.doFilter(FooterFilter.java:57)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:391)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1736)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
java.base/java.lang.Thread.run(Thread.java:1583)
integrity constraint violation: foreign key no action ; SCHEDULE_FK3 table: SCHEDULE
org.hsqldb.error.Error.error(Unknown Source)
org.hsqldb.StatementDML.performReferentialActions(Unknown Source)
org.hsqldb.StatementDML.delete(Unknown Source)
org.hsqldb.StatementDML.executeDeleteStatement(Unknown Source)
org.hsqldb.StatementDML.getResult(Unknown Source)
org.hsqldb.StatementDMQL.execute(Unknown Source)
org.hsqldb.Session.executeCompiledStatement(Unknown Source)
org.hsqldb.Session.execute(Unknown Source)
org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
fll.db.ImportDB.importTournamentTeams(ImportDB.java:2640)
fll.db.ImportDB.importTournamentData(ImportDB.java:2165)
fll.db.ImportDB.importDatabase(ImportDB.java:1990)
fll.web.developer.importdb.ExecuteImport.processRequest(ExecuteImport.java:82)
fll.web.BaseFLLServlet.doGet(BaseFLLServlet.java:37)
jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
fll.web.InitFilter.doFilter(InitFilter.java:110)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
fll.web.FooterFilter.doFilter(FooterFilter.java:57)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:391)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1736)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
java.base/java.lang.Thread.run(Thread.java:1583)
@jpschewe jpschewe added the bug label Dec 11, 2024
@jpschewe jpschewe added this to the 19.1 milestone Dec 11, 2024
@jpschewe
Copy link
Owner Author

I can reproduce the error locally.

jpschewe added a commit that referenced this issue Dec 14, 2024
@jpschewe
Fix problems importing tournament teams
3a15563 
When teams are deleted, delete the corresponding schedule entries
automatically.

Issue #1214
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
19.1
Development

No branches or pull requests
1 participant
@jpschewe