Re: hsqldb 2.74 problem: loosing tables and data of a database

Fred Toussi via Hsqldb-user <[email protected]> Sat, 18 Jan 2025 17:57:28 +0000
Newsgroups	gmane.comp.java.hsqldb.user
Message-ID	<[email protected]>
--===============8862040837223085456==
Content-Type: multipart/alternative;
 boundary=068c8c6dae08452fae5dae4aa900cb31

--068c8c6dae08452fae5dae4aa900cb31
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Thanks for reporting.

There are checks against this kind of error, but it looks like they were not adequate in this case.

Will review the code for future versions.

Fred

On Sat, Jan 18, 2025, at 17:32, Dan Lewis wrote:
> My database engine was LibreOffice 25.2 accessing my databases through HSQLDB 2.74. I opened my database and did some work and closed it. Later, I accessed it again and noticed that the tables were missing. Then I open the Script file as a text document. This is when I noticed that the bottom of this file was missing. 
> 
> *What it should look like:*
> 
> 
> 
> CREATE SCHEMA PUBLIC AUTHORIZATION DBA
> 
> ... MANY LINES REMOVED 
> 
> INSERT INTO BLOCKS VALUES(0,2147483647,0)
> 
> 
> *What it did look like*
> 
> 
> 
> SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC
> GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC
> GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC
> GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC
> GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
> GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC
> GRANT DBA TO SA
> SET SCHEMA SYSTEM_LOBS
> INSERT INTO BLOCKS VALUES(0,2147483647,0).
> 
> 
> I was using LibreOffice 25.2.01 with 2.73 before 2.74 came out. When 2.74 came out, I used LibreOffice to switch to 2.74 in late October. I got the results as above. Since that time I have switch LibreOffice to 24.8.4 with HSQLDB 2.73. I rebuilt the database using a back up of it, and I have had no further problems.
> 
> *What happened?*
> 
> *Dan*
> 
> 
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> 

--068c8c6dae08452fae5dae4aa900cb31
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html><html><head><title></title><style type=3D"text/css">p.Mso=
Normal,p.MsoNoSpacing{margin:0}</style></head><body><div style=3D"font-f=
amily:Arial;">Thanks for reporting.<br></div><div style=3D"font-family:A=
rial;"><br></div><div style=3D"font-family:Arial;">There are checks agai=
nst this kind of error, but it looks like they were not adequate in this=
 case.<br></div><div style=3D"font-family:Arial;"><br></div><div style=3D=
"font-family:Arial;">Will review the code for future versions.<br></div>=
<div style=3D"font-family:Arial;"><br></div><div style=3D"font-family:Ar=
ial;">Fred<br></div><div style=3D"font-family:Arial;"><br></div><div>On =
Sat, Jan 18, 2025, at 17:32, Dan Lewis wrote:<br></div><blockquote type=3D=
"cite" id=3D"qt" style=3D""><p>My database engine was LibreOffice 25.2 a=
ccessing my databases=0A      through HSQLDB 2.74. I opened my database =
and did some work and=0A      closed it. Later, I accessed it again and =
noticed that the tables=0A      were missing. Then I open the Script fil=
e as a text document. This=0A      is when I noticed that the bottom of =
this file was missing.&nbsp;<br></p><p><b>What it should look like:</b><=
br></p><p><br></p><div>CREATE SCHEMA PUBLIC AUTHORIZATION DBA<br></div><=
div><br></div><div style=3D"font-family:Arial;">... MANY LINES REMOVED <=
br></div><div style=3D"font-family:Arial;"><br></div><div> INSERT INTO B=
LOCKS VALUES(0,2147483647,0)<br></div><p><br></p><p><b>What it did look =
like</b><br></p><p><br></p><div>SET DATABASE DEFAULT INITIAL SCHEMA PUBL=
IC<br></div><div> GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMB=
ER TO PUBLIC<br></div><div> GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES=
_OR_NO TO PUBLIC<br></div><div> GRANT USAGE ON DOMAIN INFORMATION_SCHEMA=
.CHARACTER_DATA TO PUBLIC<br></div><div> GRANT USAGE ON DOMAIN INFORMATI=
ON_SCHEMA.SQL_IDENTIFIER TO PUBLIC<br></div><div> GRANT USAGE ON DOMAIN =
INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC<br></div><div> GRANT DBA TO SA<b=
r></div><div> SET SCHEMA SYSTEM_LOBS<br></div><div> INSERT INTO BLOCKS V=
ALUES(0,2147483647,0).<br></div><p><br></p><p>I was using LibreOffice 25=
.2.01 with 2.73 before 2.74 came out.=0A      When 2.74 came out, I used=
 LibreOffice to switch to 2.74 in late=0A      October. I got the result=
s as above. Since that time I have switch=0A      LibreOffice to 24.8.4 =
with HSQLDB 2.73. I rebuilt the database=0A      using a back up of it, =
and I have had no further problems.<br></p><p><b>What happened?</b><br><=
/p><p><b>Dan</b><br></p><div><br></div><div>____________________________=
___________________<br></div><div>Hsqldb-user mailing list<br></div><div=
><a href=3D"mailto:[email protected]">Hsqldb-user@lists.=
sourceforge.net</a><br></div><div><a href=3D"https://lists.sourceforge.n=
et/lists/listinfo/hsqldb-user">https://lists.sourceforge.net/lists/listi=
nfo/hsqldb-user</a><br></div><div><br></div></blockquote><div style=3D"f=
ont-family:Arial;"><br></div></body></html>
--068c8c6dae08452fae5dae4aa900cb31--


--===============8862040837223085456==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============8862040837223085456==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--===============8862040837223085456==--