libreoffice calc hangs when opening an xls file shared over cifs

Description of problem:
Libreoffice locks up and is unable to be stopped or restarted when opening a file from an SMB share. I do not know if the problem occurs with other types of network shares, but I suspect it does. If I copy the file locally and then open it, Libreoffice works fine.

Version-Release number of selected component (if applicable):
libreoffice-3.6.3.2-8.fc18.x86_64

How reproducible:
Try and open a word doc or excel spreadsheet from an SMB share

Steps to Reproduce:
1.
2.
3.

Actual results:
Libreofffice locks up while starting and cannot be restarted until after a reboot

Expected results:
File opens in Libreoffice

Additional info:

Created attachment 71435
part of kern.log

Problem description:
freeze splash (soffice.bin) when i try open file located on samba share. And i can not to kill it

Steps to reproduce:
1. My Xubuntu starts. And autostart:thunderbird, psi-plus, gigolo(whith automount samba shares), remmina
2. I open gigolo window, open share, click on file (some.ods)
3. Appears libreoffice splash.. that`s all.
4. I trying kill process soffice.bin (as user & as root) but it is.

Current behavior:
Reboot computer.
I copy file to my computer and open. All fine.
or
reboot, just open libreoffice blank. Then drag&drop file from thunar window. libre ask me password, I enter password and document opens.
Expected behavior:
I want that file opens with double click

Operating System: Ubuntu
Last worked in: 3.3.4 release

Unusual interaction with the Ubuntu kernel / fuse module - Bjoern - can you chase ?

What precise version of Ubuntu are you using ? and could you do:

pkill -9 -f soffice.bin
strace -f -ttt -s 256 -o /tmp/slog soffice -writer

and gzip & attach the /tmp/slog as/when it has frozen for a bit ? Thanks ! :-)

possibly related to bug#58320

taking over, waiting for log ...

Created attachment 72467
slog openoffice smb problem

Same problem, Ubuntu 12.10, libreoffice 1:3.6.2~rc2-0ubuntu4

I created this slog following instruction in comment #2

Slog from reporter at https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1070963

+1 from me and someone please flag this as a high priority if not critical. Libreoffice is currently useless for me. Same version as OP.

aneil2 4690 1 0 Jan15 ? 00:00:00 /usr/lib64/libreoffice/program/soffice.bin --calc /home/aneil2/Documents/Scoring Grid.xlsx --splash-pipe=7
aneil2 4867 1 0 Jan15 ? 00:00:00 /usr/lib64/libreoffice/program/oosplash --calc /run/user/72599/gvfs/smb-share:server=xxx.xxx.gmu.edu,share=aneil2/shared/Scoring Grid.xlsx
aneil2 4881 4867 0 Jan15 ? 00:00:01 /usr/lib64/libreoffice/program/soffice.bin --calc /run/user/72599/gvfs/smb-share:server=xxx.xxx.gmu.edu,share=aneil2/shared/Scoring Grid.xlsx --splash-pipe=7
aneil2 25381 1 0 09:58 ? 00:00:00 /usr/lib64/libreoffice/program/oosplash --impress /home/aneil2/Download/New Graduate Student Orientation PT2-Fall 2012.ppt
aneil2 25393 1 0 09:58 ? 00:00:00 /usr/lib64/libreoffice/program/oosplash --impress /home/aneil2/Download/New Graduate Student Orientation PT2-Fall 2012.ppt

with strace I see the process try and access this file descriptor and then hangs
connect(4, {sa_family=AF_FILE, sun_path="/tmp/OSL_PIPE_72599_SingleOfficeIPC_1e335fd5c08a9e1735b1de20675f196"}, 110)

presumably this is to try and contact an existing instance of libreoffice. If I remove this file then I can run the application. I agree with the OP that is seems to be triggered by trying to save a document on a SMB share.

When you start multiple instances of soffice (which calls oosplash, which calls soffice.bin) concurrently, all but the first instance hand off their command line arguments to the first instance (via IPC involving that /tmp/OSL_PIPE_*_SingleOfficeIPC_*), wait for confirmation from the first instance that it processed the arguments, and then terminate again.

What happened in comment 1 is that the first instance (soffice.bin 4690) is hung and so any newly started instances (oosplash 25381 and 25393) hang, too. One oddity is that two instances managed to go from oosplash to soffice.bin (4690 and 4881), this smells like the race conditions addressed with <http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-0&id=8376da60d5d272cf6b3ebee91934bbcd970c7658> "startup: more reliable startup of multiple instances" and <http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-0&id=6527b8a135c20e223a6fcf7c49835205a99ff02a> "Related fdo#33484: Terminate OfficeIPCThread by closing the accepting pipe" for LibreOffice 4.0, but never backported to LibreOffice 3.6. Lets see if backporting them solves the problem.

I installed the released version of Fedora 18 x86_64, same problem with LibreOffice. I will be glad to apply any updates from the testing repository when this is backported and released.

deadlock during startup sounds like bug 33484;
can you try if it still happens in a 4.0 RC2 or later build or
a build from the 3.6 branch that is newer than 3.6.5 release?

libreoffice-3.6.5.2-2.fc18 has been submitted as an update for Fedora 18.
https://admin.fedoraproject.org/updates/libreoffice-3.6.5.2-2.fc18

Package libreoffice-3.6.5.2-2.fc18:
* should fix your issue,
* was pushed to the Fedora 18 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing libreoffice-3.6.5.2-2.fc18'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2013-2042/libreoffice-3.6.5.2-2.fc18
then log in and leave karma (feedback).

I have updated to the following RPMs:

libreoffice-graphicfilter-3.6.5.2-2.fc18.x86_64
libreoffice-langpack-en-3.6.5.2-2.fc18.x86_64
libreoffice-math-3.6.5.2-2.fc18.x86_64
libreoffice-writer-3.6.5.2-2.fc18.x86_64
libreoffice-calc-3.6.5.2-2.fc18.x86_64
libreoffice-presenter-screen-3.6.5.2-2.fc18.x86_64
libreoffice-ure-3.6.5.2-2.fc18.x86_64
libreoffice-draw-3.6.5.2-2.fc18.x86_64
libreoffice-core-3.6.5.2-2.fc18.x86_64
libreoffice-xsltfilter-3.6.5.2-2.fc18.x86_64
libreoffice-opensymbol-fonts-3.6.5.2-2.fc18.noarch
libreoffice-impress-3.6.5.2-2.fc18.x86_64
libreoffice-pdfimport-3.6.5.2-2.fc18.x86_64

I still experience exactly the same behavior. Here is what appears to be running in LibreOffice:

walkerb 1893 0.1 0.3 230784 3304 ? Sl 13:18 0:00 /usr/lib64/libreoffice/program/oosplash --calc /run/user/1000/gvfs/smb-share:server=mlknrmc1,share=rmc1dv04/MIS/SAP Tech/Basis/2008 PE1.XLS
walkerb 1907 0.2 5.7 758608 58444 ? Dl 13:18 0:00 /usr/lib64/libreoffice/program/soffice.bin --calc /run/user/1000/gvfs/smb-share:server=mlknrmc1,share=rmc1dv04/MIS/SAP Tech/Basis/2008 PE1.XLS --splash-pipe=6

LibreOffice is as hung as ever.

So your problem must be something other than what is addressed with the fix in comment 2. Once LibreOffice is hung, and <N> is the PID of the hung soffice.bin process, please in a terminal run "gdb - <N>", and then at the gdb prompt "thread apply all backtrace" and attach the output here (and then "kill" and "quit"). Another useful piece of information could be to run "strace -f /usr/bin/soffice '/run/user/1000/gvfs/smb-share:server=mlknrmc1,share=rmc1dv04/MIS/SAP Tech/Basis/2008 PE1.XLS' >log.txt 2>&1" from a terminal and, once LibreOffice hangs, attach the generated log.txt.

Created attachment 696232
strace log

I've attached the log from strace. Unfortunately the gdb command did not seem to work.

The relevant lines from the attached strace log are

> [pid 2068] open("/run/user/1000/gvfs/smb-share:server=mlknrmc1,share=rmc1dv04/MIS/SAP Tech/Basis/2008 PE1.XLS", O_RDWR|O_EXCL) = 24
> [pid 2068] fstat(24, {st_mode=S_IFREG|0700, st_size=117248, ...}) = 0
> [pid 2068] fcntl(24, F_SETLK, {type=F_WRLCK, whence=SEEK_SET, start=0, len=0}) = 0
...
> [pid 2068] pread(24, <unfinished ...>

that show that the soffice.bin process is blocking on the pread system call, trying to read the file on the SMB share.

This might have to do with the advisory locking (the fcntl(F_SETLK) system call) that LibreOffice routinely uses. You can check that by (temporarily) disabling LibreOffice's advisory file locking by unsetting the SAL_ENABLE_FILE_LOCKING environment variable, by commenting out two lines near the head of /usr/lib64/libreoffice/program/soffice like so (adding the "#" characters at the start of the two lines):

  #SAL_ENABLE_FILE_LOCKING=1
  #export SAL_ENABLE_FILE_LOCKING

@gdaschner: Is any such problem known with Samba, or is this even more likely related to gvfs (given the mention of "gvfs" in the pathname), or is there anything else we should ask the reporter to help track this down?

Created attachment 696601
strace log again

Ran another strace after changing /usr/lib64/libreoffice/program/soffice to values:

# file locking now enabled by default
#SAL_ENABLE_FILE_LOCKING=1
#export SAL_ENABLE_FILE_LOCKING

Unfortunately LibreOffice still hung

libreoffice-3.6.5.2-2.fc18 has been pushed to the Fedora 18 stable repository. If problems still persist, please make note of it in this bug report.

(In reply to comment #11)
> Ran another strace after changing /usr/lib64/libreoffice/program/soffice to
> values:
>
> # file locking now enabled by default
> #SAL_ENABLE_FILE_LOCKING=1
> #export SAL_ENABLE_FILE_LOCKING
>
> Unfortunately LibreOffice still hung

...and the fcntl(24, F_SETLK, {type=F_WRLCK, whence=SEEK_SET, start=0, len=0}) call is indeed gone from the log, so the hung pread appears unrelated to any locking. I'm out of ideas what might cause this, but it might help if you give us the line of "mount" output that shows how exactly that /run/user/1000/gvfs/smb-share:server=mlknrmc1,share=rmc1dv04/MIS/SAP Tech/Basis/2008 PE1.XLS file is mounted, so we can dispatch this issue to the relevant component.

Here is the output of the mount command:

[root@localhost walkerb]# mount
proc on /proc type proc (rw,nosuid,nodev,noexec,relatime)
sysfs on /sys type sysfs (rw,nosuid,nodev,noexec,relatime)
devtmpfs on /dev type devtmpfs (rw,nosuid,size=497508k,nr_inodes=124377,mode=755)
securityfs on /sys/kernel/security type securityfs (rw,nosuid,nodev,noexec,relatime)
tmpfs on /dev/shm type tmpfs (rw,nosuid,nodev)
devpts on /dev/pts type devpts (rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000)
tmpfs on /run type tmpfs (rw,nosuid,nodev,mode=755)
tmpfs on /sys/fs/cgroup type tmpfs (rw,nosuid,nodev,noexec,mode=755)
cgroup on /sys/fs/cgroup/systemd type cgroup (rw,nosuid,nodev,noexec,relatime,release_agent=/usr/lib/systemd/systemd-cgroups-agent,name=systemd)
cgroup on /sys/fs/cgroup/cpuset type cgroup (rw,nosuid,nodev,noexec,relatime,cpuset)
cgroup on /sys/fs/cgroup/cpu,cpuacct type cgroup (rw,nosuid,nodev,noexec,relatime,cpuacct,cpu)
cgroup on /sys/fs/cgroup/memory type cgroup (rw,nosuid,nodev,noexec,relatime,memory)
cgroup on /sys/fs/cgroup/devices type cgroup (rw,nosuid,nodev,noexec,relatime,devices)
cgroup on /sys/fs/cgroup/freezer type cgroup (rw,nosuid,nodev,noexec,relatime,freezer)
cgroup on /sys/fs/cgroup/net_cls type cgroup (rw,nosuid,nodev,noexec,relatime,net_cls)
cgroup on /sys/fs/cgroup/blkio type cgroup (rw,nosuid,nodev,noexec,relatime,blkio)
cgroup on /sys/fs/cgroup/perf_event type cgroup (rw,nosuid,nodev,noexec,relatime,perf_event)
/dev/mapper/fedora-root on / type ext4 (rw,relatime,data=ordered)
systemd-1 on /proc/sys/fs/binfmt_misc type autofs (rw,relatime,fd=29,pgrp=1,timeout=300,minproto=5,maxproto=5,direct)
debugfs on /sys/kernel/debug type debugfs (rw,relatime)
hugetlbfs on /dev/hugepages type hugetlbfs (rw,relatime)
mqueue on /dev/mqueue type mqueue (rw,relatime)
tmpfs on /tmp type tmpfs (rw)
configfs on /sys/kernel/config type configfs (rw,relatime)
/dev/sda1 on /boot type ext4 (rw,relatime,data=ordered)
gvfsd-fuse on /run/user/1000/gvfs type fuse.gvfsd-fuse (rw,nosuid,nodev,relatime,user_id=1000,group_id=1000)

It doesn't appear that anything for the SMB share shows up. What I do is to use the file manager (nautilus, nemo, caja) to browse to a bookmarked SMB share, enter my credentials for the share, and then try and open the XLS file. Unfortunately I am not very familiar with gvfs and how it works or mounts filesystems. If I copy the file locally and then open it, LibreOffice works fine.

@tbzatek, please take over. (One additional data point as discussed on IRC is that /usr/share/applications/libreoffice-writer.desktop contains X-GIO-NoFuse=true so that soffice should not be passed a/run/user/1000/gvfs/smb-share:server=mlknrmc1,share=rmc1dv04/MIS/SAP Tech/Basis/2008 PE1.XLS pathname.)

Any update or additional testing required from my end?

I've been keeping my Fedora 18 x86_64 system up to date. This issue still occurs, so I was wondering if there is any update on where it stands or what else to try.

I just tried using the rpms for LibreOffice 4.0 from the official download site. These also fail with the same lockup.

Zaphod Beeblebrox: We tracked this down to LibreOffice erroneously being called from the file manager with a "bad" pathname for accessing the file on the SMB share. That is, the issue cannot be solved on the LibreOffice side and is now assigned to the gvfs component.

A workaround might be to open the document from within LibreOffice via "File - Open...", maybe after first setting "Tools - Options... - LibreOffice - General - Open/Save dialogs - Use LibreOffice dialogs".

Thanks for that information. I went back to the LibreOffice 3.6.5 rpms from Fedora 18. When I use the file/open in LibreOffice itself after browsing to an SMB bookmark in the file manager, the files open without issue. I did not even have to change the open/save dialog setting.

Any idea when the issue with gvfs and the file manager might be resolved?

Can you test again with a LibreOffice 4.0.2 pre-release from:

http://www.libreoffice.org/download/pre-releases/

My hope is that this is another dup of bug#54275 or bug#59022 - both fixed there.

Thanks.

trying to install this but not sure if i got it...
i uninstalled my prev version of libreoffice then did dpkg -i *.deb on the DEBS directory
but after all that, i check with:

libreoffice --version
and i get "LibreOffice 3.6" which is probably not right...

where is the 4.0.2 binary installed at?

Hello?

Hello. Im using Linux Mint 14 Mate. LibreOffice 3.6 right now, but tried with newest version 4.0 and had same problem. With some computers when i try to open any LO Calc or Writer files in samba server LibreOffice freezes during splash screen. Not everytime, sometimes i need to open that file 10 or more times until it freezes. After freeze i cannot kill soffice.bin process it becomes zombie and only reboot helps. I can still open any Calc or Writer files on my computer, but it doesnt start samba. I just noticed that, if i kill process "gvfs-fuse", the "soffice.bin" process dissapears. But after that i need to reboot pc anyway, because samba doesnt work proberly, i get another error if i try to open something.

I just managed to avoid rebooting pc. At first i killed oosplash process (libre office splash screen), then unmounted samba server volume, by rightclicking on it on desktop and pressing unmount. soffice.bin process dissapeared and now i can open that file on samba until it freezes again.

3126 1357235495.356292 connect(3, {sa_family=AF_FILE, path="/tmp/OSL_PIPE_1000_SingleOfficeIPC_29564c0f238622cbf196bdbd1cd3df2"}, 110) = 0
3126 1357235495.377358 getcwd("/home/zuidj", 4096) = 12
3126 1357235495.377474 write(3, "InternalIPC::Arguments1file:///home/zuidj,-writer\0", 50) = 50
3126 1357235495.377543 read(3, <unfinished ...>
3138 1357235505.351796 <... futex resumed> ) = -1 ETIMEDOUT (Connection timed out)
3138 1357235505.351887 gettimeofday({1357235505, 351902}, NULL) = 0

Looks like some IPC evil to the factory process - which is failing to respond.

You'd need to pkill -9 -f soffice.bin before running to get a better strace.

Thanks ! :-)

This package has changed ownership in the Fedora Package Database. Reassigning to the new owner of this component.

Any update?

I'm running LO 4.1.0.4 from your PPA on Ubuntu 12.04 64bit - libreoffice (1:4.1.0-0ubuntu1~precise1~ppa1)

After the last update to 4.1.0.4 I can't open odt, ods & xlsx (can be more extensions that I haven't found yet) over SMB within Nautilus. However .doc works fine.

If I open any of the others i get that the file is corrupt and the possibility to repair the file. Problem is that it's not corrupt, my colleagues can open them (other OS and software), and if I copy the file to my local computer I'm able to open them without a problem.

Doesn't matter if I start Writer and use the open file option there.

Even if i use this with terminal it's no problem:
$ libreoffice --writer /home/user/.gvfs/path/to/document.odt

So I don't know how to give you more information since I can't reproduce it through the terminal. Is there any way to debug with GUI or get a log file? Can't find any answers on Google for that.

To reproduce:
Nautilus -> Browse Network -> Windows network -> SHARE -> double click *.odt

Can not save or change .odb file over smb/nautilus mount, work fine in LO4.0.
It look like it is the same source problem you have.

Created attachment 83298
Can edit and save

Created attachment 83299
Can not edit or save

The problem is that libreoffice is accessing the smb file via the gvfs fuse filesystem, which is not supported. libreoffice-writer.desktop has:

X-GIO-NoFuse=true

which means that it should pass the smb:// uri, not the fuse path when the file is opened. I just tested (on F19) that this does still happen for me if i open a file from nautilus. It seems this is broken on your system though, i wonder why.

I can reproduce the problem when I copy /usr/share/applications/libreoffice-writer.desktop to ~/.local/share/applications/libreoffice-writer.desktop and remove the line

  X-GIO-NoFuse=true

from the latter.

Zaphod, do you have any such overriding *.desktop files in ~/.local/share/applications/ or /usr/local/share/applications/?

No, I am just using the standard menu and I don't have any desktop shortcuts. I've since moved on to F19 and the problem doesn't seem to exist there.

Zaphod

possible another fallout from fdo bug 67527?

(In reply to comment #11)
> possible another fallout from fdo bug 67527?

Sounds very much like <https://bugzilla.redhat.com/show_bug.cgi?id=885156> "Libreoffice locks up when opening Microsoft Office file over SMB share," where LO locks up when it is called with a /run/user/*/gvfs/smb-share:... pathname rather than an smb:... URL.

*** Bug 1021572 has been marked as a duplicate of this bug. ***

This message is a reminder that Fedora 18 is nearing its end of life.
Approximately 4 (four) weeks from now Fedora will stop maintaining
and issuing updates for Fedora 18. It is Fedora's policy to close all
bug reports from releases that are no longer maintained. At that time
this bug will be closed as WONTFIX if it remains open with a Fedora
'version' of '18'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version'
to a later Fedora version prior to Fedora 18's end of life.

Thank you for reporting this issue and we are sorry that we may not be
able to fix it before Fedora 18 is end of life. If you would still like
to see this bug fixed and are able to reproduce it against a later version
of Fedora, you are encouraged change the 'version' to a later Fedora
version prior to Fedora 18's end of life.

Although we aim to fix as many bugs as possible during every release's
lifetime, sometimes those efforts are overtaken by events. Often a
more recent Fedora release includes newer upstream software that fixes
bugs or makes them obsolete.

Fedora 18 changed to end-of-life (EOL) status on 2014-01-14. Fedora 18 is
no longer maintained, which means that it will not receive any further
security or bug fix updates. As a result we are closing this bug.

If you can reproduce this bug against a currently maintained version of
Fedora please feel free to reopen this bug against that version. If you
are unable to reopen this bug, please file a new report against the
current release. If you experience problems, please add a comment to this
bug.

Thank you for reporting this bug and we are sorry it could not be fixed.

Same problem on Ubuntu 12.04/64 with LibreOffice 4.2.1.1 (download from LO site)

*** Bug 75055 has been marked as a duplicate of this bug. ***

Closing remaining issues as dupe of 67527.

*** This bug has been marked as a duplicate of bug 67527 ***

*** Bug 58236 has been marked as a duplicate of this bug. ***

(In reply to comment #59)
> @iveand, Bryan Berndt: Too bad you didn't read carefully the whole thread.
> Anyway, here is a summary:
>
> - The repair dialog is an Ubuntu 12.04 specific bug, related to glib
> package. See https://launchpad.net/bugs/1214352
>
> The problem with KDE is another problem, mostly related to missing packages:
>
> - For the build from distro repositories, you should also install 'gvfs' and
> 'gvfs-smb' packages for Fedora, or 'gvfs', 'gvfs-backends',
> 'libreoffice-gnome' for Ubuntu.
>
> - For the build from libreoffice.org, you should also install 'gnome-vfs2',
> 'gnome-vfs2-smb', 'ORBit2' for Fedora, or 'libgnomevfs2-0',
> 'libgnomevfs2-extra', 'liborbit2'. You should also export
> 'OOO_FORCE_DESKTOP=gnome', otherwise it won't work.

Upgraded to LO 4.3 with the rpm's from the LO web site. (rpm -U.....) Problem is recreated, as with every upgrade so far (comment 15). Most of the packages you mention were already installed. Then added the export to a KDE environment script: http://forums.opensuse.org/showthread.php/478619-LibreOffice-looks-ugly-in-SUSE-KDE ; vairation of post #3.

I log into the SMB file server, and then when I double click the file I want to opem it asks to log in again, I assume that this is GVFS asking that. Once I do, then file opens.

Again: This one doesn't need bibisecting.

Scoping this bug clearly only on the missing deps for KDE thanks to the excellent summary in comment 59. Everything else is fdo#49776. Please dont scope-creep this bug, thanks.

(In reply to Björn Michaelsen from comment #68)
> Scoping this bug clearly only on the missing deps for KDE thanks to the
> excellent summary in comment 59.

...which has become moot with <http://cgit.freedesktop.org/libreoffice/core/commit/?id=f9f9aa9873c5851da86d33ca75e937ac022206a3> "Remove smb from X-KDE-Protocols lines," see <http://lists.freedesktop.org/archives/libreoffice/2014-October/063904.html> "Re: X-KDE-Protocols=...,smb,..."