Looks like this is the failure:
java.sql.SQLException: Cannot add foreign key constraint
and
org.hibernate.HibernateException: Failed updating schema while executing
query [alter table activitystream_events_status add index
FKBF7104E8CB8C5002 (ases_eventid), add constraint FKBF7104E8CB8C5002
foreign key (ases_eventid) references activitystream_events (ase_eventid)]
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:652)
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:393)
So it appears to be the same problem as
https://jira.xwiki.org/browse/XWIKI-14225, however, this is *not *the case
for me, my activitystream table is already INNODB:
Thomas Mortagne
<https://jira.xwiki.org/secure/ViewProfile.jspa?name=tmortagne> added a
comment - 25/Apr/17 04:25
*The issue was that activitystream_events was still MyISAM for some reason.
Converting it to INNODB fix it.*
I don't know what I did wrong. I followed the same process that I always
do, but I'm getting this:
HTTP Status 500 - com.xpn.xwiki.XWikiException: Error number 11007 in 0:
Failed to extract Entity Resource Reference from URL [
https://wiki.pridedallas.com:8443/xwiki/bin/view/Main/]
*type* Exception report
*message* *com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to
extract Entity Resource Reference from URL
[https://wiki.pridedallas.com:8443/xwiki/bin/view/Main/
<https://wiki.pridedallas.com:8443/xwiki/bin/view/Main/>]*
*description* *The server encountered an internal error that prevented it
from fulfilling this request.*
*exception*
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error
number 11007 in 0: Failed to extract Entity Resource Reference from
URL [https://wiki.pridedallas.com:8443/xwiki/bin/view/Main/]
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:134)
*root cause*
com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to
extract Entity Resource Reference from URL
[https://wiki.pridedallas.com:8443/xwiki/bin/view/Main/]
com.xpn.xwiki.XWiki.initializeResourceFromURL(XWiki.java:926)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:793)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:255)
com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:210)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:127)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:134)
(There is more if I need to send that as well).
I rolled back to 9.2 and that works fine. I've looked in the Release
Notes and don't see anything that I need to change:
http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/Data/XWiki/9.3/http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/Data/XWiki/9.3.1/
--
Keith Davis
214-906-5183
