Strangely corrupted .script file
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
Strangely corrupted .script file
by Janis Blank
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
Hello
I just got the database files from a client who
could not acces his database anymore.
When I looked at the .script file, the beginning of the statement-section dealing with the creation of my DB-structure was deleted. One statement was even cut in half. Instead I found the settings which should normally be in the .properties file. The rest of the file was intact. See below: // from .script file //
#HSQL Database Engine 1.8.0.7
#Sat Apr 12 11:37:11 CEST 2008 hsqldb.script_format=0 runtime.gc_interval=0 sql.enforce_strict_size=false hsqldb.cache_size_scale=8 readonly=false hsqldb.nio_data_file=true hsqldb.cache_scale=14 version=1.8.0 hsqldb.default_table_type=memory hsqldb.cache_file_scale=1 hsqldb.log_size=200 modified=no hsqldb.cache_version=1.7.0 hsqldb.original_version=1.8.0 hsqldb.compatible_version=1.8.0 WITH 0) NOT NULL PRIMARY KEY,T_NAME VARCHAR) CREATE MEMORY TABLE BOXES(BOX_NUMBER INTEGER NOT NULL PRIMARY KEY,BOX_TIMING INTEGER) ALTER TABLE CARDS ALTER COLUMN C_ID RESTART WITH 461 ALTER TABLE ANSWERS ALTER COLUMN A_ID RESTART WITH 504 ALTER TABLE TOPIC ALTER COLUMN T_ID RESTART WITH 5 CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 10 SET SCHEMA PUBLIC INSERT INTO... Since my DB-structure doesn't change during
runtime, I had no problems repairing it. Anyway, I'd like to know what
happened.
The client accessed the DB from a Java-Program
running on Windows 2000 with JRE 1.6.0_03. HSQLDB version is 1.8.0.7. He
couldn't tell me exactly what his last actions were.
Along with the .script and .properties files i got a .log file, which contained several INSERT-statements. Hope I provided enough information. Let me know if
you need any more.
Thanks in advance
Janis
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: Strangely corrupted .script file
by Luiz_Gustavo
::
Rate this Message:
|
|
|
Re: Strangely corrupted .script file
by fredt
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
I have checked the code that saves the .script and .properties
files. There is absolutely no overlap or sharing of the file and the stream used
for writing the data. This is obviously caused by the OS.
Fred
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: Strangely corrupted .script file
by Luiz_Gustavo
::
Rate this Message:
|
|
|
Re: Strangely corrupted .script file
by fredt
::
Rate this Message:
Some parts of this message have been removed.
Learn more about Nabble's security policy.
The information in the .script file is not recorded
elsewhere.
Fred
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
| Free Forum Powered by Nabble | Forum Help |