Servoy 2020.03.1_LTS

[huber]

Error in log file is as below. The strange thing is there is no index named 'i18n_messages_m_l'. I have expected to find an index with this name, hence the "not unique" info. There is no index on the column message_key at all. Could it have to do that we have more than one i18_message_xxx tables?

Code: Select all

2020-08-12 11:32:08,133 ERROR [http-nio-8080-exec-9] com.servoy.j2db.persistence.XMLInMemoryImportHandlerVersions11AndHigher - Failed to create an index on the messages table [ ]
com.servoy.j2db.persistence.RepositoryException: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -111: Index name 'i18n_messages_m_l' not unique
   at com.servoy.j2db.server.persistence.Zn.createIndex(Zn.java:1563) ~[j2dbdev.jar:2020.3.1.3563_LTS]
   at com.servoy.j2db.server.Za.Zl.importDatabaseInfo(Zl.java:869) [j2dbdev.jar:2020.3.1.3563_LTS]
   at com.servoy.j2db.server.Za.Zag.Za(Zag.java:87) [j2dbdev.jar:2020.3.1.3563_LTS]
   at com.servoy.j2db.server.Za.Zag.importFromJarFile(Zag.java:557) [j2dbdev.jar:2020.3.1.3563_LTS]
   at com.servoy.j2db.server.servlets.ConfigServlet.Za(ConfigServlet.java:5850) [j2dbdev.jar:2020.3.1.3563_LTS]
   at com.servoy.j2db.server.servlets.ConfigServlet.service(ConfigServlet.java:326) [j2dbdev.jar:2020.3.1.3563_LTS]
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [servlet-api.jar:?]
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:9.0.26]
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.26]
   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.26]
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.26]
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.26]
   at org.sablo.filter.SecurityFilter.doFilter(SecurityFilter.java:48) [sablo_2020.3.1.3563_LTS.jar:?]
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.26]
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.26]
   at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.2.jar:2.11.2]
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.26]
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.26]
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.26]
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.26]
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526) [catalina.jar:9.0.26]
   at org.apache.catalina.valves.rewrite.RewriteValve.invoke(RewriteValve.java:289) [catalina.jar:9.0.26]
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.26]
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.26]
   at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) [catalina.jar:9.0.26]
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.26]
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.26]
   at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-coyote.jar:9.0.26]
   at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:9.0.26]
   at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860) [tomcat-coyote.jar:9.0.26]
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote.jar:9.0.26]
   at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.26]
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_221]
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_221]
   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.26]
   at java.lang.Thread.run(Thread.java:748) [?:1.8.0_221]


[jcompagner]

so there is already an index named "i18n_messages_m_l" in that database..
is that then on a different table?

[huber]

No, there is no index named "i18n_messages_m_l" in that database. That's the strange thing.

so there is already an index named "i18n_messages_m_l" in that database..
is that then on a different table?