Hi,
I have a problem with one of my DB's. The message in the trace file
is:
07-19 08:37:13 database: CREATE PRIMARY KEY ON PUBLIC.TRANSACTIONS
(TRANSACTION_ID)
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation:
PRIMARY_KEY_FE ON PUBLIC.TRANSACTIONS(TRANSACTION_ID); SQL statement:
CREATE PRIMARY KEY ON PUBLIC.TRANSACTIONS(TRANSACTION_ID) [23001-111]
at org.h2.message.Message.getSQLException(Message.java:107)
at org.h2.message.Message.getSQLException(Message.java:118)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:
160)
at org.h2.index.BtreeLeaf.add(BtreeLeaf.java:67)
I tried to run the Recovery Tool and this is part of the SQL file that
is created. I am using CIPHER=AES as the encryption so don't know if
this has anything to do with it?
CREATE ALIAS IF NOT EXISTS READ_CLOB FOR
"org.h2.tools.Recover.readClob";
CREATE ALIAS IF NOT EXISTS READ_BLOB FOR
"org.h2.tools.Recover.readBlob";
-- ERROR: blockCount<0 block: 0 blockCount: -11599953 storageId: -1
recordLength: -1 valueId: -1
-- dump: ?N??j??p??P?U????????S??\f\r??NW )??D???-??H??r?????}F<?
a1???????s+z????8?$??+?5?"(????{CE?????q?^\Zu?????B?y7A#?????
MOT????;???
-- dump: ff 4e ff af 6a e8 ed 70 11 cc 50 8d 55 a4 dc 93 c2 b9 9d 1e
96 53 cd fe 5c 66 5c 72 89 9b 4e 57 20 29 d1 de 44 da a8 a8 2d f4 cb
48 04 00 72 b3 e5 f9 16 8d 7d 46 3c 0e 61 31 f6 0a 0f 02 fc e9 18 73
2b 7a ae c2 06 ef 38 9a 24 a6 0d 2b 1d 35 e9 22 28 a5 d0 ce ea 7b 43
45 a3 f7 83 0f d6 71 1d 5e 5c 5a 75 a9 ac 94 f4 86 42 1d 79 37 41 23
8f d0 90 08 cd 4d 4f 54 0e 80 9a 1b 3b a1 1d d0
-- ERROR: blockCount<0 block: 1 blockCount: -1135969001 storageId: -1
recordLength: -1 valueId: -1
-- dump: ?J}???T?)?x??4?5)?[?)??~??KKA??3?z?t-y??Pr?$PT/??????E!??l?;v?
t?~?~cj?3?...@u?d??~ ?????'?W?C??.?n}-???:Q????;??l????#A???Y??Oh?
-- dump: bc 4a 7d 17 c4 cb 54 02 29 d2 78 05 ac 34 e3 35 29 08 5b 84
29 9d 10 7e 83 e8 4b 4b 41 13 b5 33 0e 7a 16 74 2d 79 8a c8 50 72 0c
24 50 54 2f c6 90 89 a1 8d c0 45 21 b2 e9 6c de 3b 76 1f 74 bf 7e 85
7e 63 6a e6 33 c0 3f 54 f6 40 75 1b 44 b6 e4 7e 20 0f a6 15 bb e4 27
07 57 b2 43 a4 bd 2e a4 6e 7d 2d ab d4 12 3a 51 00 9a e1 f0 3b aa 1c
6c ce 8e ad ab 23 41 d2 d4 96 59 c8 ce 4f 68 16
-- ERROR: blockCount=1716521608 block: 2 blockCount: 1716521608
storageId: -1 recordLength: -1 valueId: -1
-- dump: fP?????????I??.???QL??k$???Pr?k???m????$ERD%>????;mnw?:?.??i??
Z???S"g??F?eRs????7??;&??W? ???a???PVJ?]an?????=?,@z?l...@?k?e?v:?
-- dump: 66 50 0a 88 0c ef 96 19 83 dd 86 49 ac 99 2e fd d1 05 51 4c
fa 96 6b 24 0a 89 ce 50 72 b3 6b aa 1f 05 6d f6 8b de 02 24 45 52 44
25 3e 09 c8 a8 13 3b 6d 6e 77 c1 3a e7 2e f8 19 69 d1 e6 5a d1 be 97
53 22 67 c5 ed 46 99 65 52 73 b7 f4 0f af 37 1b f4 3b 26 92 0a 57 19
7f 03 8b 0d 61 f2 c8 a1 50 56 4a 1d 5d 61 6e 92 f2 16 bd 8f 3d 97 2c
40 7a 98 4c 52 7a b8 40 98 6b b3 65 cc 56 3a 15
-- ERROR: blockCount<0 block: 3 blockCount: -1957132334 storageId: -1
recordLength: -1 valueId: -1
-- dump: ?x??8???ta?k????p????$x????h???0o??x?...@?:???*??????????????
x????????s?h?m??zx??[?...@??*?%??[a?o?q???)??#???Z????~???A?^???-1]
-- dump: 8b 58 87 d2 38 ed bf cc 74 41 da 4b 0b d5 f5 b2 70 ee b8 d5
8f 24 78 cb 8e b3 b4 68 05 8b 0f 30 6f 90 b4 78 dc 9b 90 e2 40 18 3a
f7 ff 1b 2a e2 ad af a2 db d6 fd 8e b5 b0 c1 90 12 13 58 bc ac b4 b4
e4 14 a2 1a 73 07 68 a1 4d fe 94 7a 58 1a bd 5b f8 1f 18 ff 40 81 c1
2a ad 25 14 fb 5b 61 a1 4f f5 51 14 03 03 29 aa 8b 23 ac bc a6 5a df
1f cd d8 7e cc 08 83 41 b2 5e a9 89 8c 2d 31 5d
-- ERROR: blockCount<0 block: 4 blockCount: -603834247 storageId: -1
recordLength: -1 valueId: -1
-- dump: ??8yK1???)r?o??5s????2???o?}no?l???u...@?y??????;?_??Gi??0?(??
&???j#???????=???sW)?.?F ???4??/I?b????<^_vbg?????g?sa????i??...@?
-- dump: dc 02 38 79 4b 31 85 d8 0f 29 52 14 6f 0d a9 35 53 94 93 a1
1f 32 b9 18 84 6f d3 7d 4e 6f a1 6c 1c 06 fe 75 69 f8 36 40 cf 59 85
a7 84 9e a8 d3 3b f6 5f d8 e1 47 69 9f d0 30 e4 28 ee d8 26 9a 07 a9
6a 23 3f ef be db 8c cb ac 3d 8a 08 d4 73 57 29 c0 2e 0a 46 7f b0 ae
c3 34 1a f7 2f 49 b9 62 b0 c1 e7 87 3c 5e 5f 76 62 47 e9 82 b0 dd e9
67 99 73 41 8a dd 19 eb 49 a1 f5 60 65 75 40 fa
-- ERROR: blockCount<0 block: 5 blockCount: -1522126153 storageId: -1
recordLength: -1 valueId: -1
-- dump: ?F2??? ????????????oa?????z2???b???jrl??...@b<&??nc?? ??N|g???
5?c?9??x??y????f??5?^=?r??l?y???g9??w?????hf??????]i1???...@??;nl?
-- dump: a5 46 32 b7 82 a5 7f 03 ff 84 d8 81 df 07 b5 a9 bb dc eb 4f
61 c1 fb a8 e9 fe 5a 32 fb a5 f4 62 1c 04 ae 4a 72 6c a1 1c 21 ae 75
40 42 3c 26 c0 09 6e 63 ea aa 7f cd 9c 4e 7c 67 d6 a8 fd 35 81 63 10
39 9e 80 78 d0 fe 59 93 11 17 19 66 c5 b7 35 88 5e 3d d1 72 da d7 4c
b0 59 e0 01 10 67 39 de eb 57 ae d8 9b 19 be 48 66 d9 f5 05 ae ee aa
5d 49 31 cf 00 a1 f0 6b 50 40 d0 e2 3b 6e 6c bf
-- ERROR: blockCount<0 block: 6 blockCount: -434958986 storageId: -1
recordLength: -1 valueId: -1
-- dump: ???v???~??+c?;????p{?[?a??'?Y??U?"?{cdt?u?Z3? `?x~??<xh>-??
H????*+ ?????3??[????????????Lm??'??A?t?:-??.??R8????????????????????
-- dump: e6 13 0d 76 09 c6 ec 7e 1d 14 2b 63 ec 3b f2 ea 9c 07 70 7b
f9 5b 0c 61 04 f7 27 e8 59 e8 99 55 8c 22 a5 7b 63 64 74 ae 75 b3 5a
33 a0 7f 60 c0 78 7e f1 14 3c 78 68 3e 2d f7 9c 48 d9 ea 1f e5 2a 2b
20 fe 98 aa b6 1f 33 0b d9 5b d4 12 86 1d ae 8c 8e b1 10 e1 fa 80 4c
6d e6 82 27 0a 87 41 a0 74 ec 3a 2d a3 c4 2e 91 17 52 38 88 83 e7 fa
8f af b5 e5 a7 d7 c7 f8 f0 c0 03 fb c1 92 04 a1
-- ERROR: blockCount=91984534 block: 7 blockCount: 91984534 storageId:
-1 recordLength: -1 valueId: -1
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
