Vince
In respect of the empty files -
* Which version of LibreOffice are you using?
* Which distro are you using?
* Which desktop?
* Is it causing you any hardship?
Alex
On Thursday 16 Jan 2014 10:10:31 Vince Radice wrote:
> 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
> >>>>>>>>>
>