Hi,
can you shed some light on why we cannot delete data from the attached DB file. A delete attempt with DB explorer results in the following exception:
[ObjectDB 2.6.3] Unexpected exception (Error 990) Generated by Java HotSpot(TM) 64-Bit Server VM 1.7.0_80 (on Linux 2.6.32-279.9.1.el6.x86_64). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: null com.objectdb.o.InternalException at com.objectdb.o.InternalException.f(InternalException.java:236) at com.objectdb.o.SPW.an(SPW.java:109) at com.objectdb.o.PGW.aj(PGW.java:220) at com.objectdb.o.UPT.C(UPT.java:134) at com.objectdb.o.UPT.l(UPT.java:110) at com.objectdb.o.TSK.i(TSK.java:145) at com.objectdb.o.TSK.f(TSK.java:95) at com.objectdb.o.UPT.s(UPT.java:157) at com.objectdb.o.PGT.q(PGT.java:109) at com.objectdb.o.UPT.C(UPT.java:121) at com.objectdb.o.UPT.l(UPT.java:110) at com.objectdb.o.TSK.i(TSK.java:145) at com.objectdb.o.TSK.f(TSK.java:95) at com.objectdb.o.UPT.s(UPT.java:157) at com.objectdb.o.PGT.q(PGT.java:109) at com.objectdb.o.UPT.C(UPT.java:121) at com.objectdb.o.URT.l(URT.java:171) at com.objectdb.o.TSK.i(TSK.java:145) at com.objectdb.o.TSK.f(TSK.java:95) at com.objectdb.o.TSM.e(TSM.java:86) at com.objectdb.o.UTT.A(UTT.java:370) at com.objectdb.o.UTT.l(UTT.java:223) at com.objectdb.o.TSK.i(TSK.java:145) at com.objectdb.o.TSK.f(TSK.java:95) at com.objectdb.o.MST.Vg(MST.java:1337) at com.objectdb.o.PRG.ak(PRG.java:952) at com.objectdb.o.PRG.ag(PRG.java:659) at com.objectdb.o.PRG.af(PRG.java:553) at com.objectdb.o.QRM.Vb(QRM.java:286) at com.objectdb.o.MST.Vb(MST.java:988) at com.objectdb.o.WRA.Vb(WRA.java:311) at com.objectdb.o.WSM.Vb(WSM.java:115) at com.objectdb.o.QRR.g(QRR.java:247) at com.objectdb.o.QRR.f(QRR.java:153) at com.objectdb.jpa.JpaQuery.executeUpdate(JpaQuery.java:776) at com.objectdb.o.QRP.L(QRP.java:251) at com.objectdb.o.QRP.T(QRP.java:723) at com.objectdb.o.QRP.actionPerformed(QRP.java:686) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
The problem started happening without any obvious reason.
I should mention that running DB Doctor on it shows the following issues:
root@localhost totalrecall]# ./dbDoctor.sh db/SystemDB.odb db/SystemDB.odb.rpmnew ObjectDB Doctor [version 2.6.3] Copyright (c) 2015, ObjectDB Software. All rights reserved. Scanning the database file... .................................................. 100MB .................................................. 200MB .................................................. 300MB .................................................. 400MB .................................................. 500MB .................................................. 600MB .................................................. 700MB .................................................. 800MB .................................................. 900MB .................................................. 1000MB ........... 1024MB (total) Analyzing database structure... 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Page Relation Errors -------------------- [1] Page #12592 last key is 2015-10-24 03:00:00|1:71540, parent page #10513 next key is 2015-10-24 03:00:00 [2] Page #12804 last key is 2015-10-24 03:00:00|1:72811, parent page #10513 next key is 2015-10-24 03:00:00|1:71594 Page Content Errors ------------------- [1] Page #12750 has unsorted entries [2] Page #12750 has unsorted entries [3] Page #12750 has unsorted entries [4] Page #12750 has unsorted entries [5] Page #12750 has unsorted entries [6] Page #12750 has unsorted entries [7] Page #12750 has unsorted entries [8] Page #12750 has unsorted entries [9] Page #12750 has unsorted entries [10] Page #12750 has unsorted entries [11] Page #12750 has unsorted entries [12] Page #12750 has unsorted entries [13] Page #12750 has unsorted entries [14] Page #12750 has unsorted entries [15] Page #12750 has unsorted entries [16] Page #12750 has unsorted entries [17] Page #12750 has unsorted entries [18] Page #12750 has unsorted entries [19] Page #12750 has unsorted entries [20] Page #12750 has unsorted entries [21] Page #12750 has unsorted entries [22] Page #12750 has unsorted entries [23] Page #12750 has unsorted entries [24] Page #12750 has unsorted entries [25] Page #12750 has unsorted entries [26] Page #12750 has unsorted entries [27] Page #12750 has unsorted entries [28] Page #12750 has unsorted entries [29] Page #12750 has unsorted entries [30] Page #12750 has unsorted entries [31] Page #12750 has unsorted entries [32] Page #12750 has unsorted entries [33] Page #12750 has unsorted entries [34] Page #12750 has unsorted entries [35] Page #12750 has unsorted entries [36] Page #12750 has unsorted entries [37] Page #12750 has unsorted entries [38] Page #12750 has unsorted entries [39] Page #12750 has unsorted entries [40] Page #12750 has unsorted entries [41] Page #12750 has unsorted entries [42] Page #12750 has unsorted entries [43] Page #12750 has unsorted entries [44] Page #12750 has unsorted entries [45] Page #12750 has unsorted entries [46] Page #12750 has unsorted entries [47] Page #12776 has unsorted entries [48] Page #12776 has unsorted entries [49] Page #12776 has unsorted entries [50] Page #12776 has unsorted entries [51] Page #12776 has unsorted entries [52] Page #12776 has unsorted entries [53] Page #12776 has unsorted entries [54] Page #12776 has unsorted entries [55] Page #12776 has unsorted entries [56] Page #12776 has unsorted entries [57] Page #12776 has unsorted entries [58] Page #12776 has unsorted entries [59] Page #12776 has unsorted entries [60] Page #12776 has unsorted entries [61] Page #12776 has unsorted entries [62] Page #12776 has unsorted entries [63] Page #12776 has unsorted entries [64] Page #12776 has unsorted entries [65] Page #12776 has unsorted entries [66] Page #12776 has unsorted entries [67] Page #12776 has unsorted entries [68] Page #12776 has unsorted entries [69] Page #12776 has unsorted entries [70] Page #12776 has unsorted entries [71] Page #12776 has unsorted entries [72] Page #12776 has unsorted entries [73] Page #12776 has unsorted entries [74] Page #12776 has unsorted entries [75] Page #12776 has unsorted entries [76] Page #12776 has unsorted entries [77] Page #12776 has unsorted entries [78] Page #12793 has unsorted entries [79] Page #12793 has unsorted entries [80] Page #12793 has unsorted entries [81] Page #12793 has unsorted entries [82] Page #12793 has unsorted entries [83] Page #12793 has unsorted entries [84] Page #12793 has unsorted entries [85] Page #12793 has unsorted entries [86] Page #12793 has unsorted entries [87] Page #12793 has unsorted entries [88] Page #12793 has unsorted entries [89] Page #12793 has unsorted entries [90] Page #12793 has unsorted entries [91] Page #12793 has unsorted entries [92] Page #12793 has unsorted entries [93] Page #12793 has unsorted entries [94] Page #12793 has unsorted entries [95] Page #12793 has unsorted entries [96] Page #12793 has unsorted entries [97] Page #12793 has unsorted entries [98] Page #12793 has unsorted entries [99] Page #12793 has unsorted entries [100] Page #12793 has unsorted entries [101] Page #12793 has unsorted entries [102] Page #12793 has unsorted entries [103] Page #12793 has unsorted entries [104] Page #12793 has unsorted entries [105] Page #12793 has unsorted entries [106] Page #12793 has unsorted entries [107] Page #12793 has unsorted entries [108] Page #12793 has unsorted entries [109] Page #12793 has unsorted entries [110] Page #12793 has unsorted entries [111] Page #12793 has unsorted entries [112] Page #12793 has unsorted entries [113] Page #12793 has unsorted entries [114] Page #12793 has unsorted entries [115] Page #12793 has unsorted entries [116] Page #12793 has unsorted entries [117] Page #12793 has unsorted entries [118] Page #12793 has unsorted entries [119] Page #12793 has unsorted entries [120] Page #12793 has unsorted entries [121] Page #12793 has unsorted entries [122] Page #12793 has unsorted entries [123] Page #12793 has unsorted entries [124] Page #12793 has unsorted entries [125] Page #12793 has unsorted entries [126] Page #12794 has unsorted entries [127] Page #12794 has unsorted entries [128] Page #12794 has unsorted entries [129] Page #12794 has unsorted entries [130] Page #12794 has unsorted entries [131] Page #12794 has unsorted entries [132] Page #12794 has unsorted entries [133] Page #12794 has unsorted entries [134] Page #12794 has unsorted entries [135] Page #12794 has unsorted entries [136] Page #12794 has unsorted entries [137] Page #12794 has unsorted entries [138] Page #12794 has unsorted entries [139] Page #12794 has unsorted entries [140] Page #12794 has unsorted entries [141] Page #12794 has unsorted entries [142] Page #12794 has unsorted entries [143] Page #12794 has unsorted entries [144] Page #12794 has unsorted entries [145] Page #12794 has unsorted entries [146] Page #12794 has unsorted entries [147] Page #12794 has unsorted entries [148] Page #12794 has unsorted entries [149] Page #12794 has unsorted entries [150] Page #12794 has unsorted entries [151] Page #12794 has unsorted entries [152] Page #12794 has unsorted entries [153] Page #12794 has unsorted entries [154] Page #12794 has unsorted entries [155] Page #12794 has unsorted entries [156] Page #12794 has unsorted entries [157] Page #12794 has unsorted entries [158] Page #12794 has unsorted entries [159] Page #12794 has unsorted entries [160] Page #12794 has unsorted entries [161] Page #12794 has unsorted entries [162] Page #12794 has unsorted entries [163] Page #12794 has unsorted entries [164] Page #12794 has unsorted entries [165] Page #12794 has unsorted entries [166] Page #12794 has unsorted entries [167] Page #12794 has unsorted entries [168] Page #12794 has unsorted entries [169] Page #12794 has unsorted entries [170] Page #12794 has unsorted entries [171] Page #12794 has unsorted entries [172] Page #12794 has unsorted entries [173] Page #12794 has unsorted entries [174] Page #12795 has unsorted entries [175] Page #12795 has unsorted entries [176] Page #12795 has unsorted entries [177] Page #12795 has unsorted entries [178] Page #12795 has unsorted entries [179] Page #12795 has unsorted entries [180] Page #12795 has unsorted entries [181] Page #12795 has unsorted entries [182] Page #12795 has unsorted entries [183] Page #12795 has unsorted entries [184] Page #12795 has unsorted entries [185] Page #12795 has unsorted entries [186] Page #12795 has unsorted entries [187] Page #12795 has unsorted entries [188] Page #12795 has unsorted entries [189] Page #12795 has unsorted entries [190] Page #12795 has unsorted entries [191] Page #12795 has unsorted entries [192] Page #12795 has unsorted entries [193] Page #12795 has unsorted entries [194] Page #12795 has unsorted entries [195] Page #12795 has unsorted entries [196] Page #12795 has unsorted entries [197] Page #12795 has unsorted entries [198] Page #12795 has unsorted entries [199] Page #12795 has unsorted entries [200] Page #12795 has unsorted entries [201] Page #12795 has unsorted entries [202] Page #12795 has unsorted entries [203] Page #12795 has unsorted entries [204] Page #12795 has unsorted entries [205] Page #12795 has unsorted entries [206] Page #12795 has unsorted entries [207] Page #12795 has unsorted entries [208] Page #12795 has unsorted entries [209] Page #12795 has unsorted entries [210] Page #12795 has unsorted entries [211] Page #12795 has unsorted entries [212] Page #12795 has unsorted entries [213] Page #12795 has unsorted entries [214] Page #12795 has unsorted entries [215] Page #12795 has unsorted entries [216] Page #12795 has unsorted entries [217] Page #12795 has unsorted entries [218] Page #12795 has unsorted entries [219] Page #12795 has unsorted entries [220] Page #12795 has unsorted entries [221] Page #12795 has unsorted entries [222] Page #12802 has unsorted entries [223] Page #12802 has unsorted entries [224] Page #12802 has unsorted entries [225] Page #12802 has unsorted entries [226] Page #12803 has unsorted entries [227] Page #12803 has unsorted entries [228] Page #12803 has unsorted entries [229] Page #12803 has unsorted entries [230] Page #12804 has unsorted entries [231] Page #12804 has unsorted entries [232] Page #12804 has unsorted entries [233] Page #12804 has unsorted entries [234] Page #12804 has unsorted entries [235] Page #12804 has unsorted entries [236] Page #12804 has unsorted entries [237] Page #12804 has unsorted entries [238] Page #12804 has unsorted entries [239] Page #12804 has unsorted entries [240] Page #12804 has unsorted entries [241] Page #12804 has unsorted entries [242] Page #12804 has unsorted entries [243] Page #12804 has unsorted entries [244] Page #12804 has unsorted entries [245] Page #12806 has unsorted entries [246] Page #12806 has unsorted entries [247] Page #12806 has unsorted entries [248] Page #12806 has unsorted entries Creating a database copy... 820 entity objects (total) have been migrated. New database copy is ready at: db/SystemDB.odb.rpmnew
Thank you
Emil