I'm also having issues with h2 1.4.92 where the database will grow every
time a LOB is saved. The workaround is to do the RUNSCRIPT command but I'm
getting this error when trying to reimport:
RUNSCRIPT FROM 'D:\tmp\toolkit.sql';
Table "SYSTEM_LOB_STREAM" already exists; SQL statement:
CREATE CACHED TABLE PUBLIC.SYSTEM_LOB_STREAM(
ID INT NOT NULL,
PART INT NOT NULL,
CDATA VARCHAR,
BDATA BINARY
) [42101-192]
<http://localhost:8082/query.do?jsessionid=72312f3b8ad4570dca0cf3c76f396ece#>
42S01/42101 (Help)
<http://h2database.com/javadoc/org/h2/api/ErrorCode.html#c42101>
I then have to manually remove the duplicate creation of the SYS LOB STREAM
table and index to get it to work. But the same error occurs later making
it a frustrating process.
The database in question goes to about 300 meg but once cleaned it's about
10 meg. Not been able to work a fix so far unfortunately as the
transactions (Spring MVC) look to be working ok. And I've got the compress
on close enabled.
On Thursday, 24 November 2016 17:04:12 UTC, Thomas Mueller Graf wrote:
>
> Hi,
>
> This last time there was also an index corruption, so we could not do a
>> dump and restore.
>>
>
> Hm, you should still be able to use "script to...". Did this not work?
>
>>
>> Do you have any suggestions on how to investigate the cause of this? E.g.
>> I have seen some threads mentioning the Recover script? If so, what should
>> we look for after running this script?
>>
>
> The Recover script should generate a very large file, I would investigate
> what is in that file, in addition to the "real" data you expect.
>
> My guess it that it's LOB data (CLOB, BLOB).
>
> Regards,
> Thomas
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
