Error 90030 when adding an column

Before submitting a bug, please check the FAQ:
http://www.h2database.com/html/faq.html

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1. On a great table with more then 6 mio. entries i do this:
2. alter table schema.table add testcolumn varchar(1)

What is the expected output? What do you see instead?
Error: Datei fehlerhaft beim Lesen des Datensatzes: "page[532492] data leaf 
table:31 ALL_RSC_DATA_COPY_2_0 entries:30 parent:532503 keys:[191111, 191112, 
191113, 191114, 191115, 191116, 191117, 191118, 191119, 191120, 191121, 191122, 
191123, 191124, 191125, 191126, 191127, 191128, 191129, 191130, 191131, 191132, 
191133, 191134, 191135, 191136, 191137, 191138, 191139, 191140] offsets:[2010, 
1977, 1938, 1899, 1861, 1823, 1783, 1751, 1712, 1673, 1634, 1595, 1557, 1517, 
1479, 1446, 1407, 1368, 1329, 1290, 1250, 1210, 1180, 1140, 1108, 1076, 1037, 
997, 965, 925]". Mögliche Lösung: Recovery Werkzeug verwenden
File corrupted while reading record: "page[532492] data leaf table:31 
ALL_RSC_DATA_COPY_2_0 entries:30 parent:532503 keys:[191111, 191112, 191113, 
191114, 191115, 191116, 191117, 191118, 191119, 191120, 191121, 191122, 191123, 
191124, 191125, 191126, 191127, 191128, 191129, 191130, 191131, 191132, 191133, 
191134, 191135, 191136, 191137, 191138, 191139, 191140] offsets:[2010, 1977, 
1938, 1899, 1861, 1823, 1783, 1751, 1712, 1673, 1634, 1595, 1557, 1517, 1479, 
1446, 1407, 1368, 1329, 1290, 1250, 1210, 1180, 1140, 1108, 1076, 1037, 997, 
965, 925]". Possible solution: use the recovery tool; SQL statement:
alter table hts.all_rsc_data add col varchar(1) [90030-162]
SQLState:  90030
ErrorCode: 90030

What version of the product are you using? On what operating system, file
system, and virtual machine?
I am using mac os x 10.7.

Do you know a workaround?
No.

What is your use case, meaning why do you need this feature?
I need an extra column..:-)

How important/urgent is the problem for you?
Very important

Please provide any additional information below.
I am using SquirreSQL 3.3.0
Original issue reported on code.google.com by joc...@googlemail.com on 12 Dec 2011 at 9:13
sagarswathi / h2database

Error 90030 when adding an column #364
