Improper use? Potential bug
Hi I am using BaseX version 9.5, i am getting error while doing Query in database below error i am getting
500 Unexpected error: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk at mailman.uni-konstanz.de Version: BaseX 9.5 Java: Oracle Corporation, 1.8.0_191 OS: Windows Server 2016, amd64 Stack Trace: java.lang.RuntimeException: Data Access out of bounds: - pre value: 234511809 - table size: 234511809 - first/next pre value: 234511724/234511809 - #total/used pages: 916434/916434 - accessed page: 916433 (916434 > 916433] at org.basex.util.Util.notExpected(Util.java:63) at org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:474) at org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:158) at org.basex.data.Data.kind(Data.java:312) at org.basex.query.value.node.DBNode$2.next(DBNode.java:295) at org.basex.query.value.node.DBNode$2.next(DBNode.java:288) at org.basex.query.expr.path.IterStep$1.next(IterStep.java:38) at org.basex.query.expr.path.IterStep$1.next(IterStep.java:32) at org.basex.query.QueryContext.next(QueryContext.java:352) at org.basex.query... 1567.06 ms
I tried to restore database but when any write operation happening then
after write operation same issue is occurring
Thanks
DharmendraDear Dharmendra,
Can you remember (do you see it in the logs) what was the latest update operation that was still successful? Did you possible run concurrent updates without a client/server architecture?
Version 9.5 is pretty old now. I recommend you to switch to the latest version.
Best, Christian
Quoted text · DK Singh · 30 lines
DK Singh <dharam.mahi at gmail.com> schrieb am Mi., 20. Nov. 2024, 07:36: > Hi I am using BaseX version 9.5, i am getting error while doing Query in > database below error i am getting > > > 500 Unexpected error: Improper use? Potential bug? Your feedback is > welcome: Contact: basex-talk at mailman.uni-konstanz.de Version: BaseX 9.5 > Java: Oracle Corporation, 1.8.0_191 OS: Windows Server 2016, amd64 Stack > Trace: java.lang.RuntimeException: Data Access out of bounds: - pre value: > 234511809 - table size: 234511809 - first/next pre value: > 234511724/234511809 - #total/used pages: 916434/916434 - accessed page: > 916433 (916434 > 916433] at org.basex.util.Util.notExpected(Util.java:63) > at org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:474) at > org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:158) at > org.basex.data.Data.kind(Data.java:312) at > org.basex.query.value.node.DBNode$2.next(DBNode.java:295) at > org.basex.query.value.node.DBNode$2.next(DBNode.java:288) at > org.basex.query.expr.path.IterStep$1.next(IterStep.java:38) at > org.basex.query.expr.path.IterStep$1.next(IterStep.java:32) at > org.basex.query.QueryContext.next(QueryContext.java:352) at > org.basex.query... 1567.06 ms > > ``` > > I tried to restore database but when any write operation happening then > after write operation same issue is occurring > > Thanks > Dharmendra >
@Christian Grün <christian.gruen at gmail.com> Thank you for your prompt response. Based on the logs, it appears that the latest write operation was successfully completed within the client/server architecture.
Can you please suggest what can i do for now i tired to run db:optimize('DB' , true()) via GUI but the same error i am getting, do i need to restore db from backup?
Thanks Dharmendra
Quoted text · Christian Grün · 47 lines
On Wed, Nov 20, 2024 at 1:13 PM Christian Grün <christian.gruen at gmail.com> wrote: > Dear Dharmendra, > > Can you remember (do you see it in the logs) what was the latest update > operation that was still successful? Did you possible run concurrent > updates without a client/server architecture? > > Version 9.5 is pretty old now. I recommend you to switch to the latest > version. > > Best, > Christian > > > DK Singh <dharam.mahi at gmail.com> schrieb am Mi., 20. Nov. 2024, 07:36: > >> Hi I am using BaseX version 9.5, i am getting error while doing Query in >> database below error i am getting >> >> >> 500 Unexpected error: Improper use? Potential bug? Your feedback is >> welcome: Contact: basex-talk at mailman.uni-konstanz.de Version: BaseX 9.5 >> Java: Oracle Corporation, 1.8.0_191 OS: Windows Server 2016, amd64 Stack >> Trace: java.lang.RuntimeException: Data Access out of bounds: - pre value: >> 234511809 - table size: 234511809 - first/next pre value: >> 234511724/234511809 - #total/used pages: 916434/916434 - accessed page: >> 916433 (916434 > 916433] at org.basex.util.Util.notExpected(Util.java:63) >> at org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:474) at >> org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:158) at >> org.basex.data.Data.kind(Data.java:312) at >> org.basex.query.value.node.DBNode$2.next(DBNode.java:295) at >> org.basex.query.value.node.DBNode$2.next(DBNode.java:288) at >> org.basex.query.expr.path.IterStep$1.next(IterStep.java:38) at >> org.basex.query.expr.path.IterStep$1.next(IterStep.java:32) at >> org.basex.query.QueryContext.next(QueryContext.java:352) at >> org.basex.query... 1567.06 ms >> >> ``` >> >> I tried to restore database but when any write operation happening then >> after write operation same issue is occurring >> >> Thanks >> Dharmendra >> >
Due to our limited resources, we can only provide support for older versions to customers. I recommend you to try the latest release.
Quoted text · DK Singh · 60 lines
DK Singh <dharam.mahi at gmail.com> schrieb am Mi., 20. Nov. 2024, 08:52: > @Christian Grün <christian.gruen at gmail.com> Thank you for your prompt > response. Based on the logs, it appears that the latest write operation was > successfully completed within the client/server architecture. > > Can you please suggest what can i do for now i tired to run db:optimize( > 'DB', true()) via GUI but the same error i am getting, do i need to > restore db from backup? > > Thanks > Dharmendra > > On Wed, Nov 20, 2024 at 1:13 PM Christian Grün <christian.gruen at gmail.com> > wrote: > >> Dear Dharmendra, >> >> Can you remember (do you see it in the logs) what was the latest update >> operation that was still successful? Did you possible run concurrent >> updates without a client/server architecture? >> >> Version 9.5 is pretty old now. I recommend you to switch to the latest >> version. >> >> Best, >> Christian >> >> >> DK Singh <dharam.mahi at gmail.com> schrieb am Mi., 20. Nov. 2024, 07:36: >> >>> Hi I am using BaseX version 9.5, i am getting error while doing Query in >>> database below error i am getting >>> >>> >>> 500 Unexpected error: Improper use? Potential bug? Your feedback is >>> welcome: Contact: basex-talk at mailman.uni-konstanz.de Version: BaseX 9.5 >>> Java: Oracle Corporation, 1.8.0_191 OS: Windows Server 2016, amd64 Stack >>> Trace: java.lang.RuntimeException: Data Access out of bounds: - pre value: >>> 234511809 - table size: 234511809 - first/next pre value: >>> 234511724/234511809 - #total/used pages: 916434/916434 - accessed page: >>> 916433 (916434 > 916433] at org.basex.util.Util.notExpected(Util.java:63) >>> at org.basex.io.random.TableDiskAccess.cursor(TableDiskAccess.java:474) at >>> org.basex.io.random.TableDiskAccess.read1(TableDiskAccess.java:158) at >>> org.basex.data.Data.kind(Data.java:312) at >>> org.basex.query.value.node.DBNode$2.next(DBNode.java:295) at >>> org.basex.query.value.node.DBNode$2.next(DBNode.java:288) at >>> org.basex.query.expr.path.IterStep$1.next(IterStep.java:38) at >>> org.basex.query.expr.path.IterStep$1.next(IterStep.java:32) at >>> org.basex.query.QueryContext.next(QueryContext.java:352) at >>> org.basex.query... 1567.06 ms >>> >>> ``` >>> >>> I tried to restore database but when any write operation happening then >>> after write operation same issue is occurring >>> >>> Thanks >>> Dharmendra >>> >>
Written for BaseX 11.5. BaseX may have changed since: please check the current documentation.