Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.IllegalStateException: Chunk 42008 not found [1.4.200/9]" [50000-200] #4019

Open
2019karl opened this issue Mar 4, 2024 · 1 comment

Comments

@2019karl
Copy link

2019karl commented Mar 4, 2024

This issue suddenly occurred in a springboot run,I tried using the 'Recover' script but it didn't work:

create connection SQLException, url: jdbc:h2:/home/db/yq.h2, errorCode 50000, state HY000

org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.IllegalStateException: Negative position -845; p=11547071115111632, c=chunk:a418,block:7fffffffffffffff,len:7fffffff,liveMax:0,livePages:0,map:7b7,max:2f580,next:2e9d,pages:2c4,root:2906000097ca93,time:23b44c030,unused:23b60aa4e,unusedAtVersion:a41a,version:a418,pinCount:0 [1.4.200/6]" [50000-200]

this is sql:
-- MVStore
CREATE ALIAS IF NOT EXISTS READ_BLOB FOR "org.h2.tools.Recover.readBlob";
CREATE ALIAS IF NOT EXISTS READ_CLOB FOR "org.h2.tools.Recover.readClob";
CREATE ALIAS IF NOT EXISTS READ_BLOB_DB FOR "org.h2.tools.Recover.readBlobDb";
CREATE ALIAS IF NOT EXISTS READ_CLOB_DB FOR "org.h2.tools.Recover.readClobDb";
CREATE ALIAS IF NOT EXISTS READ_BLOB_MAP FOR "org.h2.tools.Recover.readBlobMap";
CREATE ALIAS IF NOT EXISTS READ_CLOB_MAP FOR "org.h2.tools.Recover.readClobMap";
-- Meta
-- chunk.3134 = chunk:3134,block:17b,len:793,liveMax:918310,livePages:541,map:32c,max:923310,pages:5e2,root:c4d001e3ea853,time:bc5dfcdd,unusedAtVersion:313e,version:3134,pinCount:0
-- chunk.3135 = chunk:3135,block:90e,len:248,liveMax:2f2100,livePages:2f9,map:32c,max:2f5880,pages:301,root:c4d4009142553,time:bc5dfd04,unusedAtVersion:3137,version:3135,pinCount:0
-- chunk.3136 = chunk:3136,block:b56,len:21c,liveMax:2b7d40,livePages:519,map:32c,max:2c2700,pages:52b,root:c4d8008639493,time:bc5dfd23,unusedAtVersion:3147,version:3136,pinCount:0
-- chunk.3137 = chunk:3137,block:d72,len:10a,liveMax:12a650,livePages:b7d,map:32c,max:1340d0,pages:ba6,root:c4dc0041b6ed3,time:bc5dfd40,unusedAtVersion:3147,version:3137,pinCount:0
-- chunk.3138 = chunk:3138,block:13f,len:16,liveMax:139c0,livePages:a9,map:32c,max:191c0,pages:be,root:c4e00003c2ed3,time:bc5dfd4b,unusedAtVersion:313f,version:3138,pinCount:0
-- chunk.313d = chunk:313d,block:f,len:9,liveMax:400,livePages:1,map:32c,max:9eb0,next:18,pages:40,root:c4f40001e8791,time:bc634463,unusedAtVersion:3147,version:313d,pinCount:0
-- chunk.3140 = chunk:3140,block:2f,len:a,liveMax:1000,livePages:1,map:32c,max:c4c0,next:39,pages:32,root:c5000002191d1,time:bc667a96,unusedAtVersion:3142,version:3140,pinCount:0
-- chunk.3141 = chunk:3141,block:2,len:8,liveMax:1800,livePages:1,map:32c,max:9080,next:39,pages:21,root:c50400018b9d1,time:bc668301,unusedAtVersion:3143,version:3141,pinCount:0
-- chunk.3142 = chunk:3142,block:39,len:8,liveMax:c00,livePages:4,map:32c,max:97e0,next:41,pages:35,root:c5080001abc51,time:bc6684f7,unusedAtVersion:3144,version:3142,pinCount:0
-- chunk.3143 = chunk:3143,block:41,len:10,liveMax:2000,livePages:1,map:32c,max:13320,next:51,pages:cc,root:c50c000391bd1,time:bc6d8e73,unusedAtVersion:314c,version:3143,pinCount:0
-- chunk.3144 = chunk:3144,block:18,len:7,liveMax:c0,livePages:1,map:32c,max:7ac0,next:51,pages:21,root:c510000153a91,time:bc6d9075,unusedAtVersion:3149,version:3144,pinCount:0
-- chunk.3145 = chunk:3145,block:51,len:8,liveMax:a00,livePages:2,map:32c,max:95e0,next:59,pages:2e,root:c514000198051,time:bc6d92cf,unusedAtVersion:314a,version:3145,pinCount:0
-- chunk.3148 = chunk:3148,block:59,len:b,liveMax:4440,livePages:17,map:32c,max:cfd0,next:64,pages:41,root:c520000246311,time:bc74237e,unusedAtVersion:314c,version:3148,pinCount:0
-- chunk.3149 = chunk:3149,block:64,len:3,liveMax:0,livePages:0,map:32c,max:2620,next:67,pages:e,root:c524000036011,time:bc7429c2,unused:bc778464,unusedAtVersion:314c,version:3149,pinCount:0
-- chunk.314b = chunk:314b,block:6f,len:9,liveMax:900,livePages:2,map:32c,max:a460,next:78,pages:3c,root:c52c0001d5591,time:bc7437dc,unusedAtVersion:314c,version:314b,pinCount:0
-- chunk.314c = chunk:314c,block:78,len:8,liveMax:700,livePages:2,map:32c,max:8580,next:80,pages:20,root:c530000171b91,time:bc77826f,unusedAtVersion:314c,version:314c,pinCount:0
-- chunk.314d = chunk:314d,block:80,len:11,liveMax:b480,livePages:4d,map:32c,max:13830,next:91,pages:c6,root:c534000397451,time:bc778464,unusedAtVersion:314d,version:314d,pinCount:0
-- map.1 = name:openTransactions
-- map.10 = name:index.16,createVersion:2
-- map.100 = name:index.310,createVersion:9
-- map.101 = name:index.311,createVersion:9
-- map.102 = name:index.312,createVersion:9
-- map.103 = name:index.313,createVersion:9
-- map.104 = name:index.314,createVersion:9
-- map.105 = name:index.315,createVersion:9
-- map.106 = name:index.316,createVersion:9
-- map.107 = name:index.317,createVersion:9
-- map.108 = name:index.318,createVersion:9
-- map.109 = name:index.319,createVersion:9
-- map.10a = name:index.320,createVersion:9
-- map.10b = name:index.321,createVersion:9
-- map.10c = name:index.322,createVersion:9
-- map.10d = name:index.323,createVersion:9
-- name.index.16 = 10
-- name.index.310 = 100
-- name.index.311 = 101
-- name.index.312 = 102
-- name.index.313 = 103
-- name.index.314 = 104
-- name.index.315 = 105
-- name.index.316 = 106
-- name.index.317 = 107
-- name.index.318 = 108
-- name.index.319 = 109
-- name.index.320 = 10a
-- name.index.321 = 10b
-- name.index.322 = 10c
-- name.index.323 = 10d
-- name.openTransactions = 1
-- Tables
---- Schema SET ----
---- Table Data ----
---- Schema ----
DROP ALIAS READ_BLOB;
DROP ALIAS READ_CLOB;
DROP ALIAS READ_BLOB_DB;
DROP ALIAS READ_CLOB_DB;
DROP ALIAS READ_BLOB_MAP;
DROP ALIAS READ_CLOB_MAP;
DROP TABLE IF EXISTS INFORMATION_SCHEMA.LOB_BLOCKS;

@cdprete
Copy link

cdprete commented May 2, 2024

Maybe #4012 helps here as well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants