[Hsqldb-user] HSQL database size limit reached

[Guillaume Eynard Bontemps]

Hi everyone,

I'm new to HSQL, and I am currently trying to use it in order to store a
lot of logs from an application. I'm working with version 2.2.8. I just hit
a problem I wasn't aware of, a size limitation of the database, which seems
to be 16GB in my version of the software. I checked into the script file of
the database, and I have the files size parameter set to 8, so this is
matching with what is told into the documentation.

The problem is that I cannot open the database anymore since I've reached
this limit. Using HSQL Database Manager tool, it is complaining with the
following exception:
org.hsqldb.HsqlException: file input/output errorerror
org.hsqldb.HsqlException: wrong database file version: requires large
database support opening file - file
/GFS_SAGA/THALES/GEY/Investigation/spectro2004/logmsg_hsql_tablespace_ci_pp_spectro.data
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.persist.DataFileCache.open(Unknown Source)
at org.hsqldb.persist.Log.getCache(Unknown Source)
at org.hsqldb.persist.Logger.getCache(Unknown Source)
at org.hsqldb.persist.Logger.newStore(Unknown Source)
at org.hsqldb.Table.createDefaultStore(Unknown Source)
at org.hsqldb.Table.<init>(Unknown Source)
at org.hsqldb.ParserDDL.compileCreateTable(Unknown Source)
at org.hsqldb.ParserDDL.compileCreate(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
at org.hsqldb.Session.compileStatement(Unknown Source)
... 64 more
Caused by: org.hsqldb.HsqlException: wrong database file version: requires
large database support
at org.hsqldb.error.Error.error(Unknown Source)
... 76 more

I've tried to modify the file scale to increase it, but sadly it causes
problem then with the indexes set in the script file. Has anyone any idea
of what I could try to open this database ?

Guillaume.

[Fred Toussi]

Large Data support has been introduced in the latest version and allows
the .data file to grow to 128 times the default maximum.

If you use version 2.2.9, or the latest jar snapshot, it should open
this database. Also see the Guide on the hsqldb.large_data property,
which you can before the database reaches the default limit.

Fred

I'm working with version 2.2.8. I just hit a problem I wasn't aware of,
a size limitation of the database, which seems to be 16GB in my version
of the software. I checked into the script file of the database, and I
have the files size parameter set to 8, so this is matching with what is
told into the documentation.

[Guillaume Eynard Bontemps]

Thank you for the answer.

I use a solution a little bit more complicated to open the database. I got
the source of hsqldb 2.2.8, modified the class DataFileCache.java that was
causing the problem, by increasing the default maximum size limit. Then I
rebuild the hsqldb jar, adding the newly compiled class instead of the old
one. With this new jar, I was able to open my database.

Post by Fred Toussi
Large Data support has been introduced in the latest version and allows
the .data file to grow to 128 times the default maximum.
If you use version 2.2.9, or the latest jar snapshot, it should open
this database. Also see the Guide on the hsqldb.large_data property,
which you can before the database reaches the default limit.
Fred

I'm working with version 2.2.8. I just hit a problem I wasn't aware of,
a size limitation of the database, which seems to be 16GB in my version
of the software. I checked into the script file of the database, and I
have the files size parameter set to 8, so this is matching with what is
told into the documentation.

------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

[Fred Toussi]

Your 'solution' will cause database corruption if you start modifying
the data!

Large data is not supported in 2.2.8. You must use 2.2.9 or later.

Fred

On Thu, Nov 22, 2012, at 14:05, Guillaume Eynard Bontemps wrote:

Thank you for the answer.



I use a solution a little bit more complicated to open the database. I
got the source of hsqldb 2.2.8, modified the class DataFileCache.java
that was causing the problem, by increasing the default maximum size
limit. Then I rebuild the hsqldb jar, adding the newly compiled class
instead of the old one. With this new jar, I was able to open my
database.

2012/11/22 Fred Toussi <[1]***@users.sourceforge.net>

Large Data support has been introduced in the latest version and
allows
the .data file to grow to 128 times the default maximum.
If you use version 2.2.9, or the latest jar snapshot, it should open
this database. Also see the Guide on the hsqldb.large_data property,
which you can before the database reaches the default limit.
Fred

I'm working with version 2.2.8. I just hit a problem I wasn't

aware of,

a size limitation of the database, which seems to be 16GB in my version
of the software. I checked into the script file of the database, and I
have the files size parameter set to 8, so this is matching with what is
told into the documentation.

--------------------------------------------------------------------
----------
Monitor your physical, virtual and cloud infrastructure from a
single
web console. Get in-depth insight into apps, servers, databases,
vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
[2]http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Hsqldb-user mailing list
[3]Hsqldb-***@lists.sourceforge.net
[4]https://lists.sourceforge.net/lists/listinfo/hsqldb-user

-----------------------------------------------------------------------
-------

Monitor your physical, virtual and cloud infrastructure from a single

web console. Get in-depth insight into apps, servers, databases,
vmware,

SAP, cloud infrastructure, etc. Download 30-day Free Trial.

Pricing starts from $795 for 25 servers or applications!

[5]http://p.sf.net/sfu/zoho_dev2dev_nov

_______________________________________________

Hsqldb-user mailing list

[6]Hsqldb-***@lists.sourceforge.net

[7]https://lists.sourceforge.net/lists/listinfo/hsqldb-user

References

1. mailto:***@users.sourceforge.net
2. http://p.sf.net/sfu/zoho_dev2dev_nov
3. mailto:Hsqldb-***@lists.sourceforge.net
4. https://lists.sourceforge.net/lists/listinfo/hsqldb-user
5. http://p.sf.net/sfu/zoho_dev2dev_nov
6. mailto:Hsqldb-***@lists.sourceforge.net
7. https://lists.sourceforge.net/lists/listinfo/hsqldb-user

[Guillaume Eynard Bontemps]

Ok thanks for the advice, I actually just needed to open the database to
see what was inside. But I will use the version 2.2.9 of HSQL from now.

Post by Fred Toussi
Your 'solution' will cause database corruption if you start modifying
the data!
Large data is not supported in 2.2.8. You must use 2.2.9 or later.
Fred
Thank you for the answer.
I use a solution a little bit more complicated to open the database. I
got the source of hsqldb 2.2.8, modified the class DataFileCache.java that
was causing the problem, by increasing the default maximum size limit. Then
I rebuild the hsqldb jar, adding the newly compiled class instead of the
old one. With this new jar, I was able to open my database.
Large Data support has been introduced in the latest version and allows
the .data file to grow to 128 times the default maximum.
If you use version 2.2.9, or the latest jar snapshot, it should open
this database. Also see the Guide on the hsqldb.large_data property,
which you can before the database reaches the default limit.
Fred

I'm working with version 2.2.8. I just hit a problem I wasn't aware of,
a size limitation of the database, which seems to be 16GB in my version
of the software. I checked into the script file of the database, and I
have the files size parameter set to 8, so this is matching with what is
told into the documentation.

------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
*_______________________________________________*
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user