Bug 118401 - close-and-open-file loses intervening changes by other programs
Summary: close-and-open-file loses intervening changes by other programs
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss
Depends on:
Blocks:
 
Reported: 2018-06-26 18:58 UTC by Terrence Enger
Modified: 2019-07-16 23:49 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Terrence Enger 2018-06-26 18:58:06 UTC
I am working on debian-buster with daily Linux dbgutil bibisect repository version 2018-06-25.

The example here uses embedded Firebird, but embedded HSQLDB gives essentially the same result with complication of having to decline migration to Firebird.


STR

( 1) Download a02_fb.odb
     <https://bugs.documentfoundation.org/attachment.cgi?id=138737>
     attached to bug 114755.  It an embedded Firebird database with
     one empty table.

( 2) At command line, copy a02_fb.odb to a03.odb.
 
( 3) In LO, open a03.odb.

( 4) Open table Table1.  Observe zero data rows.

( 5) Into Table1 key a data row, for example:
         1 one

( 6) Close Table1.

( 7) Close Base window and save data.  Program presents Start Center.

( 8) At command line
         losf | grep a03.odb

( 9) Observe 7 or 8 lines of output.

(10) At command line, copy a02_fb.odb to a03.odb.

(11) In LO, open a03.odb.

(12) Open Table1.
     Expected : zero data rows
     Observed : one data row
Comment 1 Drew Jensen 2018-06-30 18:11:27 UTC
Confirmed with Ubuntu 18.04 using 6.2 Alpha0 build from 06-28

I did it slightly differently. 
Downloaded the odb file.
Open and add record.
Close ODB leave start center open.
Download the odb file overwrite the one on local drive.
Open the odb in libo
Still have 1 record where there should be none.

Close the ODB, end the session
Restart Libo
Open ODB, zero records.
Comment 2 QA Administrators 2019-07-01 02:46:18 UTC Comment hidden (obsolete)
Comment 3 Terrence Enger 2019-07-16 23:49:47 UTC
I see the bug is gone in Linux 64-6.4 bibisect repository commit
4d524947, s-h 9b7729c6, 2019-07-08, running on debian-buster.

Reverse bibisect in Linux 64-6.3 bibisect repository locates:

    commit 7d582d1f9767c0ebd5e319f2fd11711e60cd72fa
    Author:     Michael Stahl <Michael.Stahl@cib.de>
    AuthorDate: Wed May 29 14:42:06 2019 +0200
    Commit:     Michael Stahl <Michael.Stahl@cib.de>
    CommitDate: Fri May 31 13:22:58 2019 +0200

        dbaccess: fix more memory leaks caused by circular Reference
    
        Followup to 96ae2a3300811897c24cccb20f8c2faf382483df; more overridden
        acquire() creating cycles in dbaccess.
    
        (regression from 2660d24a07866e083c5135ea263030f3e3a2e729)
    
        Change-Id: I134343b3afbcd5ee3f71212ec18e551455eaee5b
        Reviewed-on: https://gerrit.libreoffice.org/73158
        Reviewed-by: Michael Stahl <Michael.Stahl@cib.de>
        Tested-by: Michael Stahl <Michael.Stahl@cib.de>

Thank you, Michael.  I am setting status RESOLVED FIXED.