This problem is perfectly reproducible. Take Database with blobs created with H2 1.3.155 or earlier, use Recover tools from H2 1.3.156 to create dump and then try to RunScript, it will definitely fail with above message. It looks that table LOB_MAP has been extended with a field "OFFSET" in version 1.3.156, but generated recovery dump contains both definitions. Attribute "Hidden" is also missing in the recovery script.
I noticed that in some cases opening older database with a 1.3.156 engine corrupts the database so that it cannot be opened by any version of the H2. And since recovery tool seems to be broken there is no easy way to repair database, I spent an hour correcting recovery dump in editor. -- 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.
