[prev in list] [next in list] [prev in thread] [next in thread]
List: hsqldb-user
Subject: Re: [Hsqldb-user] Odd lines in script file
From: Dean Oemcke <dean () kitomba ! com>
Date: 2012-11-11 22:47:26
Message-ID: CACTjWF1sN2Baha9kC8m9gRASc9u=5WAvPedOdRNfrK-iTvqxUw () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Good to know.
Cheers Fred.
On Mon, Nov 12, 2012 at 10:40 AM, Fred Toussi
<fredt@users.sourceforge.net>wrote:
> Each CACHED table has one of these lines, which links the table to the
> data in the .data file.
>
> If the database does not start and reports an error on one of these
> lines, the .data or .backup file may have been deleted or damaged. In
> that case, you need to use a backup file set of the database.
>
> Fred
>
> On Sun, Nov 11, 2012, at 20:27, Dean Oemcke wrote:
>
> Hi All,
>
> Every now and then I've noticed some strange lines in my script file
> that will then seem to break the database load on next startup.
>
>
>
> SET TABLE PUBLIC.CUSTOMER INDEX '18572 18122 18165 18558 17938 0 0 0 0
> 0 19'
>
> SET TABLE PUBLIC.ADDRESS INDEX '122 122 0 0 17'
>
> ...
>
>
>
> I'm using v2.2.9.
> Any idea what causes this and how to avoid this happening in future?
>
>
> Cheers,
> Dean
>
> -----------------------------------------------------------------------
> -------
>
> Everyone hates slow websites. So do we.
>
> Make your web apps faster with AppDynamics
>
> Download AppDynamics Lite for free today:
>
> [1]http://p.sf.net/sfu/appdyn_d2d_nov
>
> _______________________________________________
>
> Hsqldb-user mailing list
>
> [2]Hsqldb-user@lists.sourceforge.net
>
> [3]https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
> References
>
> 1. http://p.sf.net/sfu/appdyn_d2d_nov
> 2. mailto:Hsqldb-user@lists.sourceforge.net
> 3. https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_nov
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
[Attachment #5 (text/html)]
Good to know.<div><br><div>Cheers Fred.</div></div><div \
class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Nov 12, 2012 at 10:40 \
AM, Fred Toussi <span dir="ltr"><<a href="mailto:fredt@users.sourceforge.net" \
target="_blank">fredt@users.sourceforge.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Each CACHED table has one of these lines, which links the \
table to the<br> data in the .data file.<br>
<br>
If the database does not start and reports an error on one of these<br>
lines, the .data or .backup file may have been deleted or damaged. In<br>
that case, you need to use a backup file set of the database.<br>
<br>
Fred<br>
<div><div class="h5"><br>
On Sun, Nov 11, 2012, at 20:27, Dean Oemcke wrote:<br>
<br>
Hi All,<br>
<br>
Every now and then I've noticed some strange lines in my script file<br>
that will then seem to break the database load on next startup.<br>
<br>
<br>
<br>
SET TABLE PUBLIC.CUSTOMER INDEX '18572 18122 18165 18558 17938 0 0 0 0<br>
0 19'<br>
<br>
SET TABLE PUBLIC.ADDRESS INDEX '122 122 0 0 17'<br>
<br>
...<br>
<br>
<br>
<br>
I'm using v2.2.9.<br>
Any idea what causes this and how to avoid this happening in future?<br>
<br>
<br>
Cheers,<br>
Dean<br>
<br>
</div></div>-----------------------------------------------------------------------<br>
-------<br>
<br>
Everyone hates slow websites. So do we.<br>
<br>
Make your web apps faster with AppDynamics<br>
<br>
Download AppDynamics Lite for free today:<br>
<br>
[1]<a href="http://p.sf.net/sfu/appdyn_d2d_nov" \
target="_blank">http://p.sf.net/sfu/appdyn_d2d_nov</a><br> <br>
_______________________________________________<br>
<br>
Hsqldb-user mailing list<br>
<br>
[2]<a href="mailto:Hsqldb-user@lists.sourceforge.net">Hsqldb-user@lists.sourceforge.net</a><br>
<br>
[3]<a href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/hsqldb-user</a><br> <br>
References<br>
<br>
1. <a href="http://p.sf.net/sfu/appdyn_d2d_nov" \
target="_blank">http://p.sf.net/sfu/appdyn_d2d_nov</a><br> 2. mailto:<a \
href="mailto:Hsqldb-user@lists.sourceforge.net">Hsqldb-user@lists.sourceforge.net</a><br>
3. <a href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/hsqldb-user</a><br> <br>
------------------------------------------------------------------------------<br>
Everyone hates slow websites. So do we.<br>
Make your web apps faster with AppDynamics<br>
Download AppDynamics Lite for free today:<br>
<a href="http://p.sf.net/sfu/appdyn_d2d_nov" \
target="_blank">http://p.sf.net/sfu/appdyn_d2d_nov</a><br> \
_______________________________________________<br> Hsqldb-user mailing list<br>
<a href="mailto:Hsqldb-user@lists.sourceforge.net">Hsqldb-user@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/hsqldb-user" \
target="_blank">https://lists.sourceforge.net/lists/listinfo/hsqldb-user</a><br> \
</blockquote></div><br></div>
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_nov
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic