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,
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@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@architextus.com
Hi France,
I’m sorry to hear that.
Times are busy, especially with the end of the year approaching. As the number of our clients has increased, and as we want to do justice to everyone, our consulting is now based on SLAs that give you guaranteed response times. Are you interested in a quote?
All the best, Christian
On Tue, Dec 12, 2023 at 11:28 AM France Baril france.baril@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@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@architextus.com
-- France Baril Architecte documentaire / Documentation architect france.baril@architextus.com
basex-talk@mailman.uni-konstanz.de
-
Christian Grün -
France Baril