I've got the same settings as described below. I'm also using 4.1.4.2. I had the same problem up to 16th July 2013. But, then it stopped. Don't know why - sorry.
Even with the settings described above *Base* doesn't autosave whereas *Writer* and *Calc* does. 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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: [email protected] > >>>>>>>>> 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: [email protected] 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
