Bug 140484 - LibreOffice 7.1 cannot save odb files created in previous versions on cifs filesystem (see steps in comment 6)
Summary: LibreOffice 7.1 cannot save odb files created in previous versions on cifs fi...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Network
  Show dependency treegraph
 
Reported: 2021-02-17 18:21 UTC by Lionel Elie Mamane
Modified: 2022-04-09 04:13 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
reproduction case (51.33 KB, application/vnd.oasis.opendocument.database)
2021-02-17 18:22 UTC, Lionel Elie Mamane
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Lionel Elie Mamane 2021-02-17 18:21:29 UTC
Description:
It looks like some ODB files created by previous versions open OK in 7.1, but then cannot be saved anymore. The "save" button just has no action, and if one asks to save on quit, LibreOffice doesn't quit.

Steps to Reproduce:
1. open attached crm.odb
2. if asked, don't enable macros
3. the "save" icon has no red dot because no change has been made.
4. in "Forms", right click on "contacts"
5. in the context menu, click "rename"
6. change name to "ccontacts"
7. click OK
8. in main window, the "save" icon now has a red dot.
9. click the "save" icon
10. menu file, close
11. question appears: save changes to document "crm" before closing
12. answer "save" to the question 

Actual Results:
After step 9: nothing happens. The odb file is not changed, and the save icon still has a red dot.

After step 12:  nothing happens. The odb file is not changed, the odb file is not closed and the save icon still has a red dot.

Expected Results:
After step 9: The odb file should be rewritten on disk, and the save icon should not have a red dot.

At step 11: no question should be asked, since the file should already be saved. The file should be closed. 

After step 12: the file is closed


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.1.0.3 / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.utf8); UI: en-GB
Calc: threaded
Comment 1 Lionel Elie Mamane 2021-02-17 18:22:06 UTC
Created attachment 169835 [details]
reproduction case
Comment 2 Lionel Elie Mamane 2021-02-17 18:43:29 UTC
Version: 7.1.0.1.0+
Build ID: 2bd03b6de32a8bd6ff7d075752eda051a43e4add
CPU threads: 8; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.utf8); UI: en-GB
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:libreoffice-7-1, Time: 2020-12-23_08:03:21
Calc: threaded

gives on stdout/stderr:

warn:legacy.osl:18986:18986:dbaccess/source/core/dataaccess/ModelImpl.cxx:772: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the storage from!
warn:legacy.osl:18986:18986:dbaccess/source/core/dataaccess/ModelImpl.cxx:772: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the storage from!
warn:legacy.osl:18986:18986:dbaccess/source/core/dataaccess/ModelImpl.cxx:772: ODatabaseModelImpl::getOrCreateRootStorage: no source to create the storage from!
warn:dbaccess:18986:18986:dbaccess/source/filter/xml/xmlComponent.cxx:70: unknown attribute http://www.w3.org/1999/xlink xlink:type=simple
warn:dbaccess:18986:18986:dbaccess/source/filter/xml/xmlComponent.cxx:70: unknown attribute http://www.w3.org/1999/xlink xlink:type=simple
warn:dbaccess:18986:18986:dbaccess/source/filter/xml/xmlComponent.cxx:70: unknown attribute http://www.w3.org/1999/xlink xlink:type=simple

This might be or not be linked.
Comment 3 Alex Thurgood 2021-02-18 11:28:23 UTC
Hmm, no repro for me with

Version: 7.1.0.3 / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded

I get a macro execution error in the Basic IDE when loading the file, but that appears to be due to the variables and paths set (which appear to be WinOS limited) in the macro rather than anything else.

I can rename the form contacts, to ccontacts, see that the Save icon gets a little coloured star (in my icon set Sakapura), indicating that something has changed, and save the changes to the ODB file.
Comment 4 [REDACTED] 2021-02-18 12:29:18 UTC
no repro

Version: 7.1.0.3 / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 5 Lionel Elie Mamane 2021-02-18 12:44:34 UTC
(In reply to Alex Thurgood from comment #3)
> Hmm, no repro for me with

> I get a macro execution error in the Basic IDE when loading the file, but
> that appears to be due to the variables and paths set (which appear to be
> WinOS limited) in the macro rather than anything else.

Reproduction does not require macro execution. It doesn't happen with all odb files either.

Following your, and Uwe's, no-repro I made more testing. Indeed, if the odb file is on an ext4 filesystem it works for me too! So it seems the issue is specific to saving in-place to a cifs filesystem (with a Windows server as storage backend; didn't test with a Linux/Samba backend).

So:
 * "save" and "save as" both work when the file is on ext4 
 * "save as" works when the target is on cifs
 * "save" does _not_ work when the file is on cifs
Comment 6 Lionel Elie Mamane 2021-02-18 12:46:41 UTC
New reproduction steps:

Steps to Reproduce:
1. save attachment 169835 [details] to a CIFS filesystem
2. open saved crm.odb in LibreOffice 7.1
3. if asked, don't enable macros
4. the "save" icon has no red dot because no change has been made.
5. in "Forms", right click on "contacts"
6. in the context menu, click "rename"
7. change name to "ccontacts"
8. click OK
9. in main window, the "save" icon now has a red dot.
10. click the "save" icon
11. menu file, close
12. question appears: save changes to document "crm" before closing
13. answer "save" to the question 

Actual Results:
After step 10: nothing happens. The odb file is not changed, and the save icon still has a red dot.

After step 13:  nothing happens. The odb file is not changed, the odb file is not closed and the save icon still has a red dot.

Expected Results:
After step 10: The odb file should be rewritten on disk, and the save icon should not have a red dot.

At step 12: no question should be asked, since the file should already be saved. The file should be closed. 

After step 13: the file is closed
Comment 7 Lionel Elie Mamane 2021-02-18 12:49:39 UTC
In case it matters:

Anonymised CIFS mounting options type cifs (rw,relatime,vers=3.0,cache=strict,username=XXXX,uid=XXXX,forceuid,gid=XXXX,forcegid,addr=X.X.X.,file_mode=0600,dir_mode=0700,soft,nounix,mapposix,rsize=4194304,wsize=4194304,bsize=1048576,echo_interval=60,actimeo=1,user=XXXXX)

Linux kernel 5.7.0-1

Storage backend (server) is Microsoft Windows Server 2012 R2
Comment 8 [REDACTED] 2021-02-18 23:29:09 UTC
(In reply to Lionel Elie Mamane from comment #6)
> New reproduction steps:
> 
> Steps to Reproduce:
> 1. save attachment 169835 [details] to a CIFS filesystem

CIFS - this clearly may obsolete everything before.
Comment 9 Xisco Faulí 2021-02-25 14:18:31 UTC
Hi Lionel,
any chance you could bisect this issue ?
Comment 10 Xisco Faulí 2021-03-30 11:54:19 UTC
(In reply to Xisco Faulí from comment #9)
> Hi Lionel,
> any chance you could bisect this issue ?

ping
Comment 11 Jessica 2021-09-09 07:09:56 UTC Comment hidden (spam)
Comment 12 QA Administrators 2022-03-09 03:46:48 UTC Comment hidden (obsolete)
Comment 13 QA Administrators 2022-04-09 04:13:02 UTC
Dear Lionel Elie Mamane,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp