DBs corrupted; Unparseable date.

On Tue, Dec 12, 2023 at 10:22 AM France Baril <france.baril at architextus.com> wrote: > Hi, > > My databases are corrupted in a strange way. Everything worked yesterday > and I have not upgraded my system (automatic updates are NOT set on my OS). > > In the WebDAV connector, all DB names except 6 appear as a date, > examples: 2023-06-14T07:37:56.294Z, 2023-12-12T09:56:02.722Z. > > In the console, I get this error: > > [qtp289639718-19] INFO com.bradmcevoy.http.HttpManager - PROPFIND :: > http://localhost:8972/webdav/ - http://localhost:8972/webdav/ > bx_1 | Unparseable date: "app-pub-templates" > bx_1 | Unparseable date: "app-pubs" > bx_1 | Unparseable date: "app-tests" > bx_1 | Unparseable date: "ar-eg" > bx_1 | Unparseable date: "as-in" > bx_1 | Unparseable date: "az-az" > bx_1 | Unparseable date: "be-by" > bx_1 | Unparseable date: "bg-bg" > bx_1 | Unparseable date: "bn-bd" > ... > > It seems that the names and dates of the DBs have been interchanged. > > I tried restoring the DBS from my backups (newer and older back ups). I > also tried restarting the server. Same difference. I am using Basex 10.7 > (beta) and have been for a few months. I could update BaseX to the > official release, but I would prefer to upgrade with healthy DBs to avoid > adding a layer of complexity to the issue. I have not had a similar problem > in a decade of using BaseX, so I am a bit clueless about how else to try. > > Thanks in advance for your help, > > > -- > France Baril > Architecte documentaire / Documentation architect > france.baril at architextus.com >

On Tue, Dec 12, 2023 at 11:28 AM France Baril <france.baril at architextus.com> wrote: > I just noticed that I didn't include the full trace as I was trying to not > list all our DBs. Here it is: > > ... more unparseable DB names.... > bx_1 | Unparseable date: "zh-tw" > bx_1 | Unparseable date: "zu-za" > bx_1 | [qtp289639718-34] INFO com.bradmcevoy.http.HttpManager > - PROPFIND :: http://localhost:8972/webdav/2023-06-14T07:37:56.294Z/ - > http://localhost:8972/webdav/2023-06-14T07:37:56.294Z/ > bx_1 | org.basex.core.BaseXException: Stopped at /srv/basex/, > 1/41: > bx_1 | [db:name] Invalid name: 2023-06-14T07:37:56.294Z. > bx_1 | at org.basex.core.Command.execute(Command.java:94) > bx_1 | at > org.basex.api.client.LocalSession.execute(LocalSession.java:131) > bx_1 | at > org.basex.api.client.Session.execute(Session.java:36) > bx_1 | at > org.basex.http.webdav.WebDAVQuery.execute(WebDAVQuery.java:70) > bx_1 | at > org.basex.http.webdav.WebDAVService.dbExists(WebDAVService.java:84) > bx_1 | at > org.basex.http.webdav.WebDAVFactory.getResource(WebDAVFactory.java:51) > bx_1 | at > com.bradmcevoy.http.ResourceHandlerHelper.process(ResourceHandlerHelper.java:86) > bx_1 | at > com.bradmcevoy.http.webdav.PropFindHandler.process(PropFindHandler.java:97) > bx_1 | at > com.bradmcevoy.http.StandardFilter.process(StandardFilter.java:52) > bx_1 | at > com.bradmcevoy.http.FilterChain.process(FilterChain.java:40) > bx_1 | at > com.bradmcevoy.http.HttpManager.process(HttpManager.java:228) > bx_1 | at > org.basex.http.webdav.WebDAVServlet.run(WebDAVServlet.java:36) > bx_1 | at > org.basex.http.BaseXServlet.service(BaseXServlet.java:69) > bx_1 | at > javax.servlet.http.HttpServlet.service(HttpServlet.java:790) > bx_1 | at > org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1459) > bx_1 | at > org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) > bx_1 | at > org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1656) > bx_1 | at > org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:319) > bx_1 | at > org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:273) > bx_1 | at > org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:201) > bx_1 | at > org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) > bx_1 | at > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:552) > bx_1 | at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) > bx_1 | at > org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600) > bx_1 | at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) > bx_1 | at > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) > bx_1 | at > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) > bx_1 | at > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) > bx_1 | at > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440) > bx_1 | at > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) > bx_1 | at > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:505) > bx_1 | at > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) > bx_1 | at > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) > bx_1 | at > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355) > bx_1 | at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) > bx_1 | at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) > bx_1 | at > org.eclipse.jetty.server.Server.handle(Server.java:516) > bx_1 | at > org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487) > bx_1 | at > org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732) > bx_1 | at > org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479) > bx_1 | at > org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) > bx_1 | at > org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) > bx_1 | at > org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) > bx_1 | at > org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) > bx_1 | at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) > bx_1 | at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) > bx_1 | at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) > bx_1 | at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) > bx_1 | at > org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) > bx_1 | at > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) > bx_1 | at > org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) > bx_1 | at java.base/java.lang.Thread.run(Thread.java:829) > bx_1 | Caused by: org.basex.query.QueryException: Invalid > name: 2023-06-14T07:37:56.294Z. > bx_1 | at org.basex.query.QueryError.get(QueryError.java:1462) > bx_1 | at > org.basex.query.func.StandardFunc.toName(StandardFunc.java:609) > bx_1 | at > org.basex.query.func.StandardFunc.toData(StandardFunc.java:551) > bx_1 | at > org.basex.query.func.StandardFunc.compileData(StandardFunc.java:249) > bx_1 | at > org.basex.query.func.db.DbExists.opt(DbExists.java:41) > bx_1 | at > org.basex.query.func.StandardFunc.optimize(StandardFunc.java:80) > bx_1 | at org.basex.query.expr.Arr.compile(Arr.java:50) > bx_1 | at > org.basex.query.scope.MainModule.compile(MainModule.java:33) > bx_1 | at > org.basex.query.QueryCompiler.compile(QueryCompiler.java:99) > bx_1 | at > org.basex.query.QueryContext.compile(QueryContext.java:336) > bx_1 | at > org.basex.query.QueryContext.lambda$3(QueryContext.java:310) > bx_1 | at > org.basex.query.QueryContext.run(QueryContext.java:766) > bx_1 | at > org.basex.query.QueryContext.optimize(QueryContext.java:299) > bx_1 | at > org.basex.query.QueryProcessor.optimize(QueryProcessor.java:84) > bx_1 | at org.basex.core.cmd.AQuery.run(AQuery.java:75) > bx_1 | at org.basex.core.Command.run(Command.java:233) > bx_1 | at org.basex.core.Command.execute(Command.java:93) > bx_1 | ... 51 more > > On Tue, Dec 12, 2023 at 10:22 AM France Baril < > france.baril at architextus.com> wrote: > >> Hi, >> >> My databases are corrupted in a strange way. Everything worked yesterday >> and I have not upgraded my system (automatic updates are NOT set on my OS). >> >> In the WebDAV connector, all DB names except 6 appear as a date, >> examples: 2023-06-14T07:37:56.294Z, 2023-12-12T09:56:02.722Z. >> >> In the console, I get this error: >> >> [qtp289639718-19] INFO com.bradmcevoy.http.HttpManager - PROPFIND :: >> http://localhost:8972/webdav/ - http://localhost:8972/webdav/ >> bx_1 | Unparseable date: "app-pub-templates" >> bx_1 | Unparseable date: "app-pubs" >> bx_1 | Unparseable date: "app-tests" >> bx_1 | Unparseable date: "ar-eg" >> bx_1 | Unparseable date: "as-in" >> bx_1 | Unparseable date: "az-az" >> bx_1 | Unparseable date: "be-by" >> bx_1 | Unparseable date: "bg-bg" >> bx_1 | Unparseable date: "bn-bd" >> ... >> >> It seems that the names and dates of the DBs have been interchanged. >> >> I tried restoring the DBS from my backups (newer and older back ups). I >> also tried restarting the server. Same difference. I am using Basex 10.7 >> (beta) and have been for a few months. I could update BaseX to the >> official release, but I would prefer to upgrade with healthy DBs to avoid >> adding a layer of complexity to the issue. I have not had a similar problem >> in a decade of using BaseX, so I am a bit clueless about how else to try. >> >> Thanks in advance for your help, >> >> >> -- >> France Baril >> Architecte documentaire / Documentation architect >> france.baril at architextus.com >> > > > -- > France Baril > Architecte documentaire / Documentation architect > france.baril at architextus.com >