Main Page » Mailing List » April 2018

OPTIMIZE command error

Friday, 6 April 2018 · 6 messages · last reply 10 Apr 2018
AF
Andrey Fedosenko6 Apr 2018 12:27 #

Hello, I have the following error while executing the "OPTIMIZE ALL" command:

mproper use? Potential bug? Your feedback is welcome: Contact: basex-talk at mailman.uni-konstanz.de Version: BaseX 8.6.7 Java: Oracle Corporation, 1.7.0_151 OS: Linux, amd64 Stack Trace:

java.lang.ArrayIndexOutOfBoundsException: 3
    at org.basex.util.Compress.unpack(Compress.java:120)
    at org.basex.data.DiskData.txt(DiskData.java:284)
    at org.basex.data.DiskData.text(DiskData.java:251)
    at org.basex.io.serial.Serializer.node(Serializer.java:415)
    at org.basex.io.serial.Serializer.node(Serializer.java:158)
    at org.basex.io.serial.Serializer.node(Serializer.java:345)
    at org.basex.io.serial.Serializer.node(Serializer.java:158)
    at org.basex.io.serial.Serializer.serialize(Serializer.java:109)
    at org.basex.core.cmd.OptimizeAll$DBParser.parse(OptimizeAll.java:200)
    at org.basex.build.Builder.parse(Builder.java:77)
    at org.basex.build.DiskBuilder.build(DiskBuilder.java:77)
    at org.basex.core.cmd.OptimizeAll.optimizeAll(OptimizeAll.java:122)
    at org.basex.core.cmd.OptimizeAll$1.run(OptimizeAll.java:42)
    at org.basex.core.cmd.ACreate.update(ACreate.java:90)
    at org.basex.core.cmd.OptimizeAll.run(OptimizeAll.java:38)
    at org.basex.core.Command.run(Command.java:257)
    at org.basex.core.Command.execute(Command.java:93)
    at org.basex.server.ClientListener.run(ClientListener.java:139)
CG
Christian Grün6 Apr 2018 13:29 #

Hi Andrey,

Does the problem also occur with 9.0?

Thanks in advance, Christian

Quoted text · Andrey Fedosenko · 30 lines
On Fri, Apr 6, 2018 at 12:27 PM, Andrey Fedosenko <andrey.fedosenko at startmatter.com> wrote: > Hello, > I have the following error while executing the "OPTIMIZE ALL" command: > > mproper use? Potential bug? Your feedback is welcome: > Contact: basex-talk at mailman.uni-konstanz.de > Version: BaseX 8.6.7 > Java: Oracle Corporation, 1.7.0_151 > OS: Linux, amd64 > Stack Trace: > java.lang.ArrayIndexOutOfBoundsException: 3 > at org.basex.util.Compress.unpack(Compress.java:120) > at org.basex.data.DiskData.txt(DiskData.java:284) > at org.basex.data.DiskData.text(DiskData.java:251) > at org.basex.io.serial.Serializer.node(Serializer.java:415) > at org.basex.io.serial.Serializer.node(Serializer.java:158) > at org.basex.io.serial.Serializer.node(Serializer.java:345) > at org.basex.io.serial.Serializer.node(Serializer.java:158) > at org.basex.io.serial.Serializer.serialize(Serializer.java:109) > at org.basex.core.cmd.OptimizeAll$DBParser.parse(OptimizeAll.java:200) > at org.basex.build.Builder.parse(Builder.java:77) > at org.basex.build.DiskBuilder.build(DiskBuilder.java:77) > at org.basex.core.cmd.OptimizeAll.optimizeAll(OptimizeAll.java:122) > at org.basex.core.cmd.OptimizeAll$1.run(OptimizeAll.java:42) > at org.basex.core.cmd.ACreate.update(ACreate.java:90) > at org.basex.core.cmd.OptimizeAll.run(OptimizeAll.java:38) > at org.basex.core.Command.run(Command.java:257) > at org.basex.core.Command.execute(Command.java:93) > at org.basex.server.ClientListener.run(ClientListener.java:139)
AF
Andrey Fedosenko9 Apr 2018 15:32 #

Hi Christian,

Quoted text · Christian Grün · 1 line
> optimize

Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk at mailman.uni-konstanz.de Version: BaseX 9.0 Java: Oracle Corporation, 1.8.0_161 OS: Linux, amd64 Stack Trace:

java.lang.ArrayIndexOutOfBoundsException: 257
        at org.basex.util.Compress.isSet(Compress.java:148)
        at org.basex.util.Compress.unpack(Compress.java:110)
        at org.basex.data.DiskData.txt(DiskData.java:307)
        at org.basex.data.DiskData.text(DiskData.java:273)
        at org.basex.core.cmd.Optimize.optimize(Optimize.java:145)
        at org.basex.core.cmd.Optimize.optimize(Optimize.java:92)
        at org.basex.core.cmd.Optimize$1.run(Optimize.java:50)
        at org.basex.core.cmd.ACreate.update(ACreate.java:90)
        at org.basex.core.cmd.Optimize.run(Optimize.java:41)
        at org.basex.core.Command.run(Command.java:257)
        at org.basex.core.Command.execute(Command.java:93)
        at org.basex.server.ClientListener.run(ClientListener.java:140)

2018-04-06 14:29 GMT+03:00 Christian Grün <christian.gruen at gmail.com>:

Quoted text · Christian Grün · 39 lines
> Hi Andrey, > > Does the problem also occur with 9.0? > > Thanks in advance, > Christian > > > > On Fri, Apr 6, 2018 at 12:27 PM, Andrey Fedosenko > <andrey.fedosenko at startmatter.com> wrote: >> Hello, >> I have the following error while executing the "OPTIMIZE ALL" command: >> >> mproper use? Potential bug? Your feedback is welcome: >> Contact: basex-talk at mailman.uni-konstanz.de >> Version: BaseX 8.6.7 >> Java: Oracle Corporation, 1.7.0_151 >> OS: Linux, amd64 >> Stack Trace: >> java.lang.ArrayIndexOutOfBoundsException: 3 >> at org.basex.util.Compress.unpack(Compress.java:120) >> at org.basex.data.DiskData.txt(DiskData.java:284) >> at org.basex.data.DiskData.text(DiskData.java:251) >> at org.basex.io.serial.Serializer.node(Serializer.java:415) >> at org.basex.io.serial.Serializer.node(Serializer.java:158) >> at org.basex.io.serial.Serializer.node(Serializer.java:345) >> at org.basex.io.serial.Serializer.node(Serializer.java:158) >> at org.basex.io.serial.Serializer.serialize(Serializer.java:109) >> at org.basex.core.cmd.OptimizeAll$DBParser.parse(OptimizeAll.java:200) >> at org.basex.build.Builder.parse(Builder.java:77) >> at org.basex.build.DiskBuilder.build(DiskBuilder.java:77) >> at org.basex.core.cmd.OptimizeAll.optimizeAll(OptimizeAll.java:122) >> at org.basex.core.cmd.OptimizeAll$1.run(OptimizeAll.java:42) >> at org.basex.core.cmd.ACreate.update(ACreate.java:90) >> at org.basex.core.cmd.OptimizeAll.run(OptimizeAll.java:38) >> at org.basex.core.Command.run(Command.java:257) >> at org.basex.core.Command.execute(Command.java:93) >> at org.basex.server.ClientListener.run(ClientListener.java:139)
CG
Christian Grün9 Apr 2018 17:36 #

Hi Andrey,

Maybe your database has been damaged in an earlier state. The INSPECT command might give you a hint. You can use EXPORT and CREATE to generate a completely new database instance.

If you get the same error with a completely new instance, feel free to give us an update.

Hope this helps, Christian

Quoted text · Andrey Fedosenko · 65 lines
On Mon, Apr 9, 2018 at 3:32 PM, Andrey Fedosenko <andrey.fedosenko at startmatter.com> wrote: > Hi Christian, > >> optimize > Improper use? Potential bug? Your feedback is welcome: > Contact: basex-talk at mailman.uni-konstanz.de > Version: BaseX 9.0 > Java: Oracle Corporation, 1.8.0_161 > OS: Linux, amd64 > Stack Trace: > java.lang.ArrayIndexOutOfBoundsException: 257 > at org.basex.util.Compress.isSet(Compress.java:148) > at org.basex.util.Compress.unpack(Compress.java:110) > at org.basex.data.DiskData.txt(DiskData.java:307) > at org.basex.data.DiskData.text(DiskData.java:273) > at org.basex.core.cmd.Optimize.optimize(Optimize.java:145) > at org.basex.core.cmd.Optimize.optimize(Optimize.java:92) > at org.basex.core.cmd.Optimize$1.run(Optimize.java:50) > at org.basex.core.cmd.ACreate.update(ACreate.java:90) > at org.basex.core.cmd.Optimize.run(Optimize.java:41) > at org.basex.core.Command.run(Command.java:257) > at org.basex.core.Command.execute(Command.java:93) > at org.basex.server.ClientListener.run(ClientListener.java:140) > > 2018-04-06 14:29 GMT+03:00 Christian Grün <christian.gruen at gmail.com>: >> Hi Andrey, >> >> Does the problem also occur with 9.0? >> >> Thanks in advance, >> Christian >> >> >> >> On Fri, Apr 6, 2018 at 12:27 PM, Andrey Fedosenko >> <andrey.fedosenko at startmatter.com> wrote: >>> Hello, >>> I have the following error while executing the "OPTIMIZE ALL" command: >>> >>> mproper use? Potential bug? Your feedback is welcome: >>> Contact: basex-talk at mailman.uni-konstanz.de >>> Version: BaseX 8.6.7 >>> Java: Oracle Corporation, 1.7.0_151 >>> OS: Linux, amd64 >>> Stack Trace: >>> java.lang.ArrayIndexOutOfBoundsException: 3 >>> at org.basex.util.Compress.unpack(Compress.java:120) >>> at org.basex.data.DiskData.txt(DiskData.java:284) >>> at org.basex.data.DiskData.text(DiskData.java:251) >>> at org.basex.io.serial.Serializer.node(Serializer.java:415) >>> at org.basex.io.serial.Serializer.node(Serializer.java:158) >>> at org.basex.io.serial.Serializer.node(Serializer.java:345) >>> at org.basex.io.serial.Serializer.node(Serializer.java:158) >>> at org.basex.io.serial.Serializer.serialize(Serializer.java:109) >>> at org.basex.core.cmd.OptimizeAll$DBParser.parse(OptimizeAll.java:200) >>> at org.basex.build.Builder.parse(Builder.java:77) >>> at org.basex.build.DiskBuilder.build(DiskBuilder.java:77) >>> at org.basex.core.cmd.OptimizeAll.optimizeAll(OptimizeAll.java:122) >>> at org.basex.core.cmd.OptimizeAll$1.run(OptimizeAll.java:42) >>> at org.basex.core.cmd.ACreate.update(ACreate.java:90) >>> at org.basex.core.cmd.OptimizeAll.run(OptimizeAll.java:38) >>> at org.basex.core.Command.run(Command.java:257) >>> at org.basex.core.Command.execute(Command.java:93) >>> at org.basex.server.ClientListener.run(ClientListener.java:139)
AF
Andrey Fedosenko10 Apr 2018 10:23 #

Hi Christian, I have the following error while executing the "EXPORT" command:

Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk at mailman.uni-konstanz.de Version: BaseX 9.0 Java: Oracle Corporation, 1.8.0_161 OS: Linux, amd64 Stack Trace:

java.lang.ArrayIndexOutOfBoundsException: 257
       at org.basex.util.Compress.isSet(Compress.java:148)
       at org.basex.util.Compress.unpack(Compress.java:110)
       at org.basex.data.DiskData.txt(DiskData.java:307)
       at org.basex.data.DiskData.text(DiskData.java:273)
       at org.basex.io.serial.Serializer.node(Serializer.java:370)
       at org.basex.io.serial.Serializer.node(Serializer.java:158)
       at org.basex.io.serial.StandardSerializer.node(StandardSerializer.java:108)
       at org.basex.io.serial.Serializer.node(Serializer.java:345)
       at org.basex.io.serial.Serializer.node(Serializer.java:158)
       at org.basex.io.serial.StandardSerializer.node(StandardSerializer.java:108)
       at org.basex.io.serial.AdaptiveSerializer.node(AdaptiveSerializer.java:78)
       at org.basex.io.serial.Serializer.serialize(Serializer.java:109)
       at org.basex.io.serial.AdaptiveSerializer.serialize(AdaptiveSerializer.java:69)
       at org.basex.core.cmd.Export.export(Export.java:122)
       at org.basex.core.cmd.Export.export(Export.java:69)
       at org.basex.core.cmd.Export.run(Export.java:46)
       at org.basex.core.Command.run(Command.java:257)
       at org.basex.core.Command.execute(Command.java:93)
       at org.basex.server.ClientListener.run(ClientListener.java:140)

2018-04-09 18:36 GMT+03:00 Christian Grün <christian.gruen at gmail.com>:

Quoted text · Christian Grün · 79 lines
> Hi Andrey, > > Maybe your database has been damaged in an earlier state. The INSPECT > command might give you a hint. You can use EXPORT and CREATE to > generate a completely new database instance. > > If you get the same error with a completely new instance, feel free to > give us an update. > > Hope this helps, > Christian > > > > On Mon, Apr 9, 2018 at 3:32 PM, Andrey Fedosenko > <andrey.fedosenko at startmatter.com> wrote: >> Hi Christian, >> >>> optimize >> Improper use? Potential bug? Your feedback is welcome: >> Contact: basex-talk at mailman.uni-konstanz.de >> Version: BaseX 9.0 >> Java: Oracle Corporation, 1.8.0_161 >> OS: Linux, amd64 >> Stack Trace: >> java.lang.ArrayIndexOutOfBoundsException: 257 >> at org.basex.util.Compress.isSet(Compress.java:148) >> at org.basex.util.Compress.unpack(Compress.java:110) >> at org.basex.data.DiskData.txt(DiskData.java:307) >> at org.basex.data.DiskData.text(DiskData.java:273) >> at org.basex.core.cmd.Optimize.optimize(Optimize.java:145) >> at org.basex.core.cmd.Optimize.optimize(Optimize.java:92) >> at org.basex.core.cmd.Optimize$1.run(Optimize.java:50) >> at org.basex.core.cmd.ACreate.update(ACreate.java:90) >> at org.basex.core.cmd.Optimize.run(Optimize.java:41) >> at org.basex.core.Command.run(Command.java:257) >> at org.basex.core.Command.execute(Command.java:93) >> at org.basex.server.ClientListener.run(ClientListener.java:140) >> >> 2018-04-06 14:29 GMT+03:00 Christian Grün <christian.gruen at gmail.com>: >>> Hi Andrey, >>> >>> Does the problem also occur with 9.0? >>> >>> Thanks in advance, >>> Christian >>> >>> >>> >>> On Fri, Apr 6, 2018 at 12:27 PM, Andrey Fedosenko >>> <andrey.fedosenko at startmatter.com> wrote: >>>> Hello, >>>> I have the following error while executing the "OPTIMIZE ALL" command: >>>> >>>> mproper use? Potential bug? Your feedback is welcome: >>>> Contact: basex-talk at mailman.uni-konstanz.de >>>> Version: BaseX 8.6.7 >>>> Java: Oracle Corporation, 1.7.0_151 >>>> OS: Linux, amd64 >>>> Stack Trace: >>>> java.lang.ArrayIndexOutOfBoundsException: 3 >>>> at org.basex.util.Compress.unpack(Compress.java:120) >>>> at org.basex.data.DiskData.txt(DiskData.java:284) >>>> at org.basex.data.DiskData.text(DiskData.java:251) >>>> at org.basex.io.serial.Serializer.node(Serializer.java:415) >>>> at org.basex.io.serial.Serializer.node(Serializer.java:158) >>>> at org.basex.io.serial.Serializer.node(Serializer.java:345) >>>> at org.basex.io.serial.Serializer.node(Serializer.java:158) >>>> at org.basex.io.serial.Serializer.serialize(Serializer.java:109) >>>> at org.basex.core.cmd.OptimizeAll$DBParser.parse(OptimizeAll.java:200) >>>> at org.basex.build.Builder.parse(Builder.java:77) >>>> at org.basex.build.DiskBuilder.build(DiskBuilder.java:77) >>>> at org.basex.core.cmd.OptimizeAll.optimizeAll(OptimizeAll.java:122) >>>> at org.basex.core.cmd.OptimizeAll$1.run(OptimizeAll.java:42) >>>> at org.basex.core.cmd.ACreate.update(ACreate.java:90) >>>> at org.basex.core.cmd.OptimizeAll.run(OptimizeAll.java:38) >>>> at org.basex.core.Command.run(Command.java:257) >>>> at org.basex.core.Command.execute(Command.java:93) >>>> at org.basex.server.ClientListener.run(ClientListener.java:139)
CG
Christian Grün10 Apr 2018 10:31 #

Hi Andrey,

This clearly indicates that something has gone wrong with your database in the past. If you need to recover the data, you can try to export all documents one by one using XQuery.

Best, Christian

Andrey Fedosenko <andrey.fedosenko at startmatter.com> schrieb am Di., 10. Apr. 2018, 10:23:

Quoted text · Andrey Fedosenko · 117 lines
> Hi Christian, > I have the following error while executing the "EXPORT" command: > > Improper use? Potential bug? Your feedback is welcome: > Contact: basex-talk at mailman.uni-konstanz.de > Version: BaseX 9.0 > Java: Oracle Corporation, 1.8.0_161 > OS: Linux, amd64 > Stack Trace: > java.lang.ArrayIndexOutOfBoundsException: 257 > at org.basex.util.Compress.isSet(Compress.java:148) > at org.basex.util.Compress.unpack(Compress.java:110) > at org.basex.data.DiskData.txt(DiskData.java:307) > at org.basex.data.DiskData.text(DiskData.java:273) > at org.basex.io.serial.Serializer.node(Serializer.java:370) > at org.basex.io.serial.Serializer.node(Serializer.java:158) > at > org.basex.io.serial.StandardSerializer.node(StandardSerializer.java:108) > at org.basex.io.serial.Serializer.node(Serializer.java:345) > at org.basex.io.serial.Serializer.node(Serializer.java:158) > at > org.basex.io.serial.StandardSerializer.node(StandardSerializer.java:108) > at > org.basex.io.serial.AdaptiveSerializer.node(AdaptiveSerializer.java:78) > at org.basex.io.serial.Serializer.serialize(Serializer.java:109) > at > org.basex.io.serial.AdaptiveSerializer.serialize(AdaptiveSerializer.java:69) > at org.basex.core.cmd.Export.export(Export.java:122) > at org.basex.core.cmd.Export.export(Export.java:69) > at org.basex.core.cmd.Export.run(Export.java:46) > at org.basex.core.Command.run(Command.java:257) > at org.basex.core.Command.execute(Command.java:93) > at org.basex.server.ClientListener.run(ClientListener.java:140) > > 2018-04-09 18:36 GMT+03:00 Christian Grün <christian.gruen at gmail.com>: > > Hi Andrey, > > > > Maybe your database has been damaged in an earlier state. The INSPECT > > command might give you a hint. You can use EXPORT and CREATE to > > generate a completely new database instance. > > > > If you get the same error with a completely new instance, feel free to > > give us an update. > > > > Hope this helps, > > Christian > > > > > > > > On Mon, Apr 9, 2018 at 3:32 PM, Andrey Fedosenko > > <andrey.fedosenko at startmatter.com> wrote: > >> Hi Christian, > >> > >>> optimize > >> Improper use? Potential bug? Your feedback is welcome: > >> Contact: basex-talk at mailman.uni-konstanz.de > >> Version: BaseX 9.0 > >> Java: Oracle Corporation, 1.8.0_161 > >> OS: Linux, amd64 > >> Stack Trace: > >> java.lang.ArrayIndexOutOfBoundsException: 257 > >> at org.basex.util.Compress.isSet(Compress.java:148) > >> at org.basex.util.Compress.unpack(Compress.java:110) > >> at org.basex.data.DiskData.txt(DiskData.java:307) > >> at org.basex.data.DiskData.text(DiskData.java:273) > >> at org.basex.core.cmd.Optimize.optimize(Optimize.java:145) > >> at org.basex.core.cmd.Optimize.optimize(Optimize.java:92) > >> at org.basex.core.cmd.Optimize$1.run(Optimize.java:50) > >> at org.basex.core.cmd.ACreate.update(ACreate.java:90) > >> at org.basex.core.cmd.Optimize.run(Optimize.java:41) > >> at org.basex.core.Command.run(Command.java:257) > >> at org.basex.core.Command.execute(Command.java:93) > >> at org.basex.server.ClientListener.run(ClientListener.java:140) > >> > >> 2018-04-06 14:29 GMT+03:00 Christian Grün <christian.gruen at gmail.com>: > >>> Hi Andrey, > >>> > >>> Does the problem also occur with 9.0? > >>> > >>> Thanks in advance, > >>> Christian > >>> > >>> > >>> > >>> On Fri, Apr 6, 2018 at 12:27 PM, Andrey Fedosenko > >>> <andrey.fedosenko at startmatter.com> wrote: > >>>> Hello, > >>>> I have the following error while executing the "OPTIMIZE ALL" command: > >>>> > >>>> mproper use? Potential bug? Your feedback is welcome: > >>>> Contact: basex-talk at mailman.uni-konstanz.de > >>>> Version: BaseX 8.6.7 > >>>> Java: Oracle Corporation, 1.7.0_151 > >>>> OS: Linux, amd64 > >>>> Stack Trace: > >>>> java.lang.ArrayIndexOutOfBoundsException: 3 > >>>> at org.basex.util.Compress.unpack(Compress.java:120) > >>>> at org.basex.data.DiskData.txt(DiskData.java:284) > >>>> at org.basex.data.DiskData.text(DiskData.java:251) > >>>> at org.basex.io.serial.Serializer.node(Serializer.java:415) > >>>> at org.basex.io.serial.Serializer.node(Serializer.java:158) > >>>> at org.basex.io.serial.Serializer.node(Serializer.java:345) > >>>> at org.basex.io.serial.Serializer.node(Serializer.java:158) > >>>> at org.basex.io.serial.Serializer.serialize(Serializer.java:109) > >>>> at > org.basex.core.cmd.OptimizeAll$DBParser.parse(OptimizeAll.java:200) > >>>> at org.basex.build.Builder.parse(Builder.java:77) > >>>> at org.basex.build.DiskBuilder.build(DiskBuilder.java:77) > >>>> at > org.basex.core.cmd.OptimizeAll.optimizeAll(OptimizeAll.java:122) > >>>> at org.basex.core.cmd.OptimizeAll$1.run(OptimizeAll.java:42) > >>>> at org.basex.core.cmd.ACreate.update(ACreate.java:90) > >>>> at org.basex.core.cmd.OptimizeAll.run(OptimizeAll.java:38) > >>>> at org.basex.core.Command.run(Command.java:257) > >>>> at org.basex.core.Command.execute(Command.java:93) > >>>> at org.basex.server.ClientListener.run(ClientListener.java:139) >

Written for BaseX 9.0. BaseX may have changed since: please check the current documentation.

« Multipart and charsetXSLT Module: feature request - XSLT 3.0 support »
⚡Generated with XQuery