Re: [libreoffice-users] Similar Problem?

It is Thursday morning.  I looked and there were 10 empty files in the 
backup directory from 10:49 pm to 10:50 pm.  When I tried to bring the 
database down this morning, it would not come down - Starter was not 
responding.  I waited several times to see if it would clear up and 
end.  Nothing.  I finally terminated the application.  Started Calc to 
cause the recovery procedure to work. Recovery was successful and no 
data was lost.

I still cannot figure out what is causing the problem.  I had thought 
that leaving it up overnight would create the files.

Any suggestions as to what to do next?  Any options that might need to 
be changed.

Here is a link to a screen print of my LO Load/Save options.

https://drive.google.com/file/d/0Bw7LR6zNWsAKRHY2dS1BdTNYQW8/edit?usp=sharing

As for the change to a different backend, I am open to suggestions. The 
size of my database now is about 900k.  I make a few additions each 
week.  So a small and fast is appropriate.  I am open to suggestions.

Thanks,
Vince





On 01/16/2014 06:17 AM, Tom Davies wrote:
> Hi :)
> This mailing list might be able to help you migrate your existing
> tables to an external back-end.  There was a looong thread about this
> a few years ago when Ian (err can't remember his surname [hangs head
> in shame]).  It is roughly what i hope to do = start with the internal
> back-end and then migrate it.
>
> To be fair it's not Hsql that is the problem.  It's the ancient
> version that got twisted and squeezed into being the internal back-end
> in Base and then didn't get enough further developments.  As an
> external back-end, if you grab any of their newer versions straight
> from their website, then it apparently works like a dream (errr as in
> super fast and smooth, not as in imaginary).  On the other hand it
> might be good to choose a different back-end and there are plenty to
> choose from.
>
> When choosing a back-end it might be worth considering what sort of
> size are you talking about.  MySql/MariaDb, Postgresql and other big
> names are meant for huge amounts of data.  I mean really vast and
> quite complex.  For an address book for a small-medium sized business
> it's over kill and you might find them comparatively sluggish when
> handling that little data.  What i need is something small and fast
> but that often points to java-based ones such as Hsql and java makes
> me shudder.
>
> Regards from
> Tom :)
>
>
>
>
>
>
>
>
>
>
> On 16 January 2014 01:19, Vince Radice <vhradice@cfl.rr.com> wrote:
> > Unfortunately, I don't know what causes the problem and, thus, I can't
> > recreate it.
> >
> > I am trying something now.  I brought it up, updated a record but did not
> > save it (I have a saved copy someplace else).  I intend to let it be up
> > overnight and check in the morning for the files.  I had already cleared out
> > all of the empty ones.  I noted the time I brought is up and made the
> > change.
> >
> > I want to see if it reoccurs. if so, then when.  I also intend to save it
> > and close it in the morning.  If the files are there, see if the creation
> > stops.  Hopefully, this will lead to why it is happening.
> >
> >
> > On another tangent, I had lost data and had to recreate the db. During that
> > process, I read a few things indicating that using HSQL could lead to losing
> > data.  The recommendation was to use an external db.  I spent several weeks
> > last year trying to get Mysql to work.  I followed the conversion guidelines
> > that I had found but was unable to get it to work.  I created the Mysql
> > database and was able to create and load the tables (I think) but I could
> > never get Base to recognize and use it.  All of my queries and reports are
> > in Base.  I may have to try again if I can find the time.  This time I will
> > record what I install and what I do.
> >
> > Vince Radice
> >
> > On 01/15/2014 11:46 AM, Alex Kempshall wrote:
> > > Having said all that. It would appear that I've never had  auto backup
> > > switched on.
> > >
> > > Having switched it on I now see backups and autobackups for writer and
> > > calc documents. Nothing at all for base documents.
> > >
> > > Alex
> > >
> > >
> > >
> > > On Wednesday 15 Jan 2014 14:35:33 Alex McMurchy wrote:
> > > > I used to have that problem. It seems to have stopped around about 16th
> > > > July 2013. Not sure why!
> > > >
> > > > Either -
> > > >
> > > > I upgraded LibreOffice which stopped the feature
> > > > or I did something else which I can't remember!
> > > >
> > > > I'm currently on 4.1.4.2.
> > > >
> > > > Alex
> > > >
> > > >
> > > >
> > > >
> > > > On Wednesday 15 Jan 2014 07:38:25 Tom Davies wrote:
> > > > > Hi :)
> > > > > Errr, is it possible to switch the auto-save and auto-backups off for
> > > > > a while and see if that improves things?  The thing i find difficult
> > > > > about doing that is remembering to save properly and frequently
> > > > > enough.  With Base i think it's also important to close properly.
> > > > >
> > > > > There is some documentation and a handbook at
> > > > > https://wiki.documentfoundation.org/Documentation/Publications
> > > > > and the Faq at
> > > > > https://wiki.documentfoundation.org/Faq
> > > > > might be able to help too but the best place seems to be this mailing
> > > > > list or the Base forums at Apache OpenOffice.
> > > > > Regards from
> > > > > Tom :)
> > > > >
> > > > > On 15 January 2014 07:30, Tom Davies <tomcecf@gmail.com> wrote:
> > > > > > Hi :)
> > > > > > Errr, are you using the internal back-end?  You haven't connected to
> > > > > > an external back-end have you?  You should really be keeping your data
> > > > > > in an external back-end instead of having the whole database as a
> > > > > > single file.
> > > > > >
> > > > > > Being able to do that is one of the main things that makes Base so
> > > > > > much more powerful than Access.  The internal back-end got tacked on
> > > > > > to make Base more familiar to people who have picked up bad habits by
> > > > > > using Access.  It seems to be a bit broken though.  Annoyingly the
> > > > > > Marketing Mailing List and all our flyers, posters and leaflets (at
> > > > > > least all the ones that mention Base at all) keep pushing people into
> > > > > > using the internal back-end despite the fact that users have even
> > > > > > experienced data-loss by doing so.  I'm tempted to ask you to take
> > > > > > this problem to the marketing list to get them to solve it but the
> > > > > > experts in Base are mostly on this list and will hopefully be able to
> > > > > > help with this issue.
> > > > > >
> > > > > > It should be possible to export your existing tables into an external
> > > > > > back-end and this mailing list (note, not the marketing list) might be
> > > > > > able to help you with that.
> > > > > >
> > > > > > The next smart thing about Base is that forms and reports can be, and
> > > > > > are best made in Writer or/and (i think) Calc.  So normal users who
> > > > > > are clueless about databases can read the data in a familiar setting
> > > > > > and use familiar tools to format and edit things around the
> > > > > > data-fields.  The forms and reports inside Base seem to be for
> > > > > > data-entry and people who have some clue about databases.
> > > > > >
> > > > > > However i have never quite got around to getting to grips with all
> > > > > > this.  So hopefully some of the experts might wade in and set me
> > > > > > straight (again)
> > > > > > Regards from
> > > > > > Tom :)
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > On 15 January 2014 05:57, Vince Radice <vhradice@cfl.rr.com> wrote:
> > > > > > > I am running Fedora FC19-64 bit. Libreoffice Version: 4.1.4.2
> > > > > > > Build ID: 4.1.4.2-2.fc19
> > > > > > >
> > > > > > > Here are some lines of a ls -la command
> > > > > > >
> > > > > > > -rw-------.  1 vince root       0 Dec 13 13:10 GRNew odb_0.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:58 GRNew odb_1000.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:58 GRNew odb_1001.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:58 GRNew odb_1002.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:58 GRNew odb_1003.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:58 GRNew odb_1004.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:58 GRNew odb_1005.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:59 GRNew odb_1006.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:59 GRNew odb_1007.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:59 GRNew odb_1008.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:59 GRNew odb_1009.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 13:26 GRNew odb_100.odb
> > > > > > > -rw-------.  1 vince root       0 Dec 13 15:59 GRNew odb_1010.odb
> > > > > > >
> > > > > > > My database name is GRNew,odb.
> > > > > > > I was looking at some of the recent messages that were talking about
> > > > > > > LO
> > > > > > > looping saving backups of untitled documents.  It mentioned Calc and
> > > > > > > Write
> > > > > > > as being involved.  Could this be related to my problem?
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Vince Radice
> > > > > > >
> > > > > > >
> > > > > > > On 01/14/2014 12:44 PM, Tom Davies wrote:
> > > > > > > > Hi :)
> > > > > > > > On Ubuntu 12.04 i have no files in there.  Do the file-names start
> > > > > > > > with a ~ or with "lock"?  In either of those cases i think you can
> > > > > > > > delete the files without worry but it might be worth testing that for
> > > > > > > > 1 or 2 files.
> > > > > > > >
> > > > > > > > Going off on a tangent i do have a non-LibreOffice folder with a load
> > > > > > > > of crash reports from when i don't close Xbmc properly and i
> > > > > > > > routinely
> > > > > > > > delete all of them from time-to-time.  I'm not sure if this is
> > > > > > > > similar
> > > > > > > > or not.
> > > > > > > > Regards from
> > > > > > > > Tom :)
> > > > > > > >
> > > > > > > >
> > > > > > > > On 14 January 2014 04:12, Vince Radice <vhradice@cfl.rr.com> wrote:
> > > > > > > > > I am seeing something and I don't know if it is a problem or
> > > > > > > > > something I
> > > > > > > > > have to live with.
> > > > > > > > >
> > > > > > > > > In the ~/.config/libreoffice/4/user/backup  directory, I have 3,000+
> > > > > > > > > files
> > > > > > > > > with 0 bytes.  I assume that this means the files are empty. There
> > > > > > > > > are
> > > > > > > > > other
> > > > > > > > > files there which are not empty.  The non-empty ones appear to be
> > > > > > > > > backups
> > > > > > > > > of
> > > > > > > > > files I have worked on.  The empty files all appear to be attempts
> > > > > > > > > to
> > > > > > > > > backup
> > > > > > > > > a Base database that I have created using the built in hsql engine.
> > > > > > > > > The
> > > > > > > > > file is stored on my computer. The time stamps on the files are
> > > > > > > > > unusual.
> > > > > > > > > There are 6 files with a time stamp of 15:58, 6 with 15:59, 6 with
> > > > > > > > > 16:00
> > > > > > > > > and
> > > > > > > > > the pattern continues for the other 3,500 empty files.
> > > > > > > > >
> > > > > > > > > Does any one else have the same situation?  I have the save/backup
> > > > > > > > > time
> > > > > > > > > in
> > > > > > > > > the general options set to 15 minutes.
> > > > > > > > >
> > > > > > > > > I have a listing of all of the files if anyone wants to see it.
> > > > > > > > >
> > > > > > > > > Thank you,
> > > > > > > > > Vince Radice
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > > > > > > > Problems?
> > > > > > > > >
> > > > > > > > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > > > > > > > Posting guidelines + more:
> > > > > > > > > http://wiki.documentfoundation.org/Netiquette
> > > > > > > > > List archive: http://listarchives.libreoffice.org/global/users/
> > > > > > > > > All messages sent to this list will be publicly archived and cannot
> > > > > > > > > be
> > > > > > > > > deleted


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted