[prev in list] [next in list] [prev in thread] [next in thread]
List: hsqldb-user
Subject: Re: [Hsqldb-user] HSQLDB-Cached tables
From: "Fred Toussi" <fredt () users ! sourceforge ! net>
Date: 2011-05-18 15:42:14
Message-ID: 1305733334.22663.1453345877 () webmail ! messagingengine ! com
[Download RAW message or body]
The backup is documented in the Guide. The DbBackup class is used
offline.
SET FILES INCREMENT BACKUP TRUE is for internal "backup" during
operations. This is the default setting since version 2.0.0 and should
be used, especially if your database is large. This setting does not
create a database backup for the user.
Fred
On Wed, 18 May 2011 08:27 -0700, "iceDice" <nmilasinovic@gmail.com>
wrote:
>
> Hello,
>
> I experienced reported issue with version 2.0 and beacuse of that we
> decided
> to migrate
> to version 2.2.
>
> Regarding to internal backup feature, do i need to use DbBackup class
> from
> org.hsqldb.lib.tar package
> or use SET FILES INCREMENT BACKUP TRUE command?
>
> Best regards.
>
>
> Fred Toussi-2 wrote:
> >
> > We have an offline backup feature. You can use this before you open the
> > database. This is probably faster and the most reliable for of backup.
> > The backup files are dated and you should keep the latest two.
> >
> > You previously reported you were using version 2.0.0. We found a
> > potential issue there with similar symptoms and fixed it earlier this
> > year. The latest versions include this fix. Obviously I don't know if
> > you hit the same issue or not.
> >
> > Fred
> >
> > On Wed, 18 May 2011 05:48 -0700, "iceDice" <nmilasinovic@gmail.com>
> > wrote:
> >>
> >> Hi Fred,
> >>
> >> I already use backup of all database files, however somehow i copied
> >> damaged
> >> script file
> >> to backup also.
> >> So i guess there is no way to get valid script file after it was damaged?
> >> -
> >> i am pretty sure
> >> that only some indexrootPos values are invalid and .data file is valid.
> >>
> >> I quess i am not using backup of database on right place, because i got
> >> backup corrupted
> >> also.
> >> Which is proper stage to backup database files in application? At First
> >> place i use backup just
> >> before some insert/delete/update operations, but now i am thinking of
> >> backuping database
> >> every time i successfully open database.
> >>
> >> Best regards and thank you for fast reply.
> >>
> >>
> >>
> >>
> >> Fred Toussi-2 wrote:
> >> >
> >> > You should use a bckup of the database if something like this happens.
> >> >
> >> > Fred
> >> >
> >> > On Wed, 18 May 2011 05:11 -0700, "iceDice" <nmilasinovic@gmail.com>
> >> > wrote:
> >> >>
> >> >> Hello,
> >> >>
> >> >> I am using hsqldb with cached tables.
> >> >> Recently i got invalid database script files somehow. I don't know why
> >> >> this
> >> >> happens and why script files are damaged.
> >> >> However problem is that values for indexes in commands:
> >> >> SET TABLE PUBLIC.ACT INDEX '931552 12552 0 0 21305'
> >> >> SET TABLE PUBLIC.ACTVERSION INDEX '3515904 2388384 2107840 1683832 0 0
> >> 0
> >> >> 0
> >> >> 28221'
> >> >> SET TABLE PUBLIC.DOCUMENT INDEX '23170776 4888824 4881456 6301040 0 0
> >> 0 0
> >> >> 122694'
> >> >> ...
> >> >> are invalid, and i cannot re-open such database (load cached tables
> >> from
> >> >> data file).
> >> >>
> >> >> Is there any way to recreate those indexes, as .data file where all
> >> >> cached
> >> >> tables are stored is
> >> >> still valid?
> >> >> If there is a way to generate valid indexes again it will repair
> >> >> database.
> >> >>
> >> >> I also tried to delete all SET TABLE tablename INDEX commands and
> >> after
> >> >> that
> >> >> i succeed to
> >> >> open database, but all cached tables are empty!
> >> >>
> >> >> Full stack trace of exception when trying to load cached tables
> >> >> http://old.nabble.com/file/p31646271/ExceptionStackTrace.txt
> >> >> ExceptionStackTrace.txt from data file when script file is damaged
> >> are
> >> >> in
> >> >> attachment.
> >> >>
> >> >> Best regards.
> >> >> --
> >> >> View this message in context:
> >> >> http://old.nabble.com/HSQLDB-Cached-tables-tp31646271p31646271.html
> >> >> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> >> >>
> >> >>
> >> >>
> >> ------------------------------------------------------------------------------
> >> >> What Every C/C++ and Fortran developer Should Know!
> >> >> Read this article and learn how Intel has extended the reach of its
> >> >> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> >> >> developers boost performance applications - including clusters.
> >> >> http://p.sf.net/sfu/intel-dev2devmay
> >> >> _______________________________________________
> >> >> Hsqldb-user mailing list
> >> >> Hsqldb-user@lists.sourceforge.net
> >> >> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >> >>
> >> >
> >> >
> >> ------------------------------------------------------------------------------
> >> > What Every C/C++ and Fortran developer Should Know!
> >> > Read this article and learn how Intel has extended the reach of its
> >> > next-generation tools to help Windows* and Linux* C/C++ and Fortran
> >> > developers boost performance applications - including clusters.
> >> > http://p.sf.net/sfu/intel-dev2devmay
> >> > _______________________________________________
> >> > Hsqldb-user mailing list
> >> > Hsqldb-user@lists.sourceforge.net
> >> > https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >> http://old.nabble.com/HSQLDB-Cached-tables-tp31646271p31646555.html
> >> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> >>
> >>
> >> ------------------------------------------------------------------------------
> >> What Every C/C++ and Fortran developer Should Know!
> >> Read this article and learn how Intel has extended the reach of its
> >> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> >> developers boost performance applications - including clusters.
> >> http://p.sf.net/sfu/intel-dev2devmay
> >> _______________________________________________
> >> Hsqldb-user mailing list
> >> Hsqldb-user@lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >>
> >
> > ------------------------------------------------------------------------------
> > What Every C/C++ and Fortran developer Should Know!
> > Read this article and learn how Intel has extended the reach of its
> > next-generation tools to help Windows* and Linux* C/C++ and Fortran
> > developers boost performance applications - including clusters.
> > http://p.sf.net/sfu/intel-dev2devmay
> > _______________________________________________
> > Hsqldb-user mailing list
> > Hsqldb-user@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/HSQLDB-Cached-tables-tp31646271p31647947.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> What Every C/C++ and Fortran developer Should Know!
> Read this article and learn how Intel has extended the reach of its
> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> developers boost performance applications - including clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
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