Bug 100384 - FILEOPEN: LibreOffice freezes when opening any .ods file (in Windows 10) for about seven minutes
Summary: FILEOPEN: LibreOffice freezes when opening any .ods file (in Windows 10) for ...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-06-15 01:05 UTC by mattg889
Modified: 2017-04-04 15:16 UTC (History)
2 users (show)

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 mattg889 2016-06-15 01:05:07 UTC
I just started having this problem yesterday where LibreOffice will not open any .ods documents.  I click a file to open it and the LibreOffice window comes up but it is blank and I have to kill LibreOffice to stop it.
I can start LibreOffice separately and it starts fine.  I can make a new calc document and save it.  But then when I go to re-open the newly saved document it does the same thing again.  The files work, I have opened them on a couple other computers.  I have deleted the .lock files that were left from the freezes, but that didn't change anything either.

Yesterday I wanted to restart my computer because I hadn't in a while and after I clicked restart it popped up saying LibreOffice was preventing it.  So I cancelled the restart and went to close LibreOffice, but it was frozen.  So I told it to force shutdown.  And upon the next startup the above problems started.

I think something is corrupt somewhere, but I have deleted the whole profile to reset it and nothing changed.  I have reinstalled with multiple different versions but all with the same result. I feel this is a bug because even if something got corrupted, reinstalling should fix that right?

The following thread says one should file a bug if resetting the profile doesn't fix it.
https://ask.libreoffice.org/en/question/2421/writer-crashes-on-loading/
Comment 1 Aron Budea 2016-06-15 01:29:58 UTC
I'm going to go by intuition here, have you run chkdsk since the freeze? If not, give it a try as described here: https://technet.microsoft.com/en-us/magazine/ee872425.aspx
Comment 2 mattg889 2016-06-15 01:47:37 UTC
I did not think of that.
So I ran chkdsk /f on drive C (OS) and drive D (data) and I also ran sfc /scannow too and no change.  Still freezes when I try to open any .ods file.
Comment 3 Aron Budea 2016-06-15 02:56:55 UTC
Oh well, it was worth a try.

See if this option is checked, if so, uncheck it, and try again after restarting LibreOffice:
Tools -> Options... -> LibreOffice -> View -> Use OpenGL for all rendering (on restart)

If that doesn't fix the freeze, try LibreOffice 5.2 beta2, available from the download page. It installs separately from the final releases, no need to uninstall the current version.
Comment 4 mattg889 2016-06-15 03:09:47 UTC
Ok, I unchecked the opengl box and it still froze.

I installed version 5.2 beta2 and I tried opening the file from the launcher to make sure I was using version 5.2 and as soon as I click open, the open dialog disappears and it is frozen again.  It says "Loading document" at the bottom.

I also tried unchecking the opengl box in 5.2.  And I saw there is a extra box below that to force it to use opengl even if it is blacklisted, so I tried it again with both opengl box's checked.(I restarted LibreOffice before each try) Still the same frozen result every time.
Comment 5 Aron Budea 2016-06-15 04:50:24 UTC
Hm... Does the happen with other LibreOffice applications/document types? If it was the same with Writer, I'd be curious to see what happens if you:
-save document in WordPad,
-open document in WordPad,
-open document in Writer.

Also, which Windows version are you using, and is there maybe a virus scanner running in the background?
My hunch is that this isn't a LibreOffice issue, since it was working before, and started freezing all of a sudden, with completely fresh installs as well. So be on the lookout for unexpected system behavior in the meantime.
Comment 6 mattg889 2016-06-15 21:40:49 UTC
Well, I didn't really find the problem, but it is working again.  You were thinking maybe it's not LibreOffice that's the problem.  So I did a system restore to about 2 weeks ago.  And after that, LibreOffice wouldn't open at all.  So I figured that was progress, so I reinstalled the latest release version and it is working again!

This is all on Windows 10.  The only antivirus I use is Malwarebytes and I did a full scan.  It was just LibreOffice calc that was having problems, writer worked fine.  

What part of windows does LibreOffice calc depend on that could have been the cause?  I didn't change anything on the computer recently.

I guess it will be just another one of the mysteries of windows.  Thanks for the help.
Comment 7 Aron Budea 2016-06-15 23:21:32 UTC
I honestly have no idea what could've been interfering with Calc, and only Calc.
Nevertheless, I'm glad it works now, thanks for the update.
Comment 8 mattg889 2016-07-10 02:08:30 UTC
The problem is back, it is on a different computer.  All the same symptoms except Writer also has the same problem too now.
I am now having the same problem on my laptop with windows 10.  I do not have system restore as a option because I disabled it a long time ago to save space and resources.
I know I haven't changed anything on my laptop in months.  I suspect that it is something within windows, probably from a recent update.  The laptop does receive automatic updates.  I have tried everything that I did when I had the problem on my desktop.
any other ideas?
Comment 9 mattg889 2016-07-10 02:27:09 UTC
I uninstalled the most recent update KB3163018,installed on 6-22-2016, no change

The next most recent update KB3149135 was installed on 6-19-2016 and it can not be uninstalled.

The next most recent update was installed way back in march, I know LibreOffice worked fine less than a month ago on this laptop so that and further back shouldn't be the problem.
Comment 10 Aron Budea 2016-07-10 21:07:52 UTC
That's unfortunate. I don't have a lot of ideas... maybe temporarily turning off Windows Defender could be worth a try:
http://www.tenforums.com/tutorials/3569-windows-defender-real-time-protection-turn-off-windows-10-a.html
Comment 11 mattg889 2016-07-16 05:01:12 UTC
Well now it is doing it on my desktop again.  I can't keep running system restore every couple weeks to fix it.  This is getting aggravating.  I'm running out of computers to open files on.  I have tried opening files with no antivirus running, including disabling windows defender.

I did notice in the task manager that there are two process that start when I try to open a file.  soffice.exe and soffice.bin.  When it freezes, soffice.bin is the process that changes it's status to "not responding".  
what's each files purpose?
It really does seem like it is something with windows, probably isolated to windows 10, but it is on 2 different computers now.
Comment 12 mattg889 2016-07-16 05:18:06 UTC
And evidently system restore no longer fixes it.
Comment 13 Buovjaga 2016-07-16 20:25:49 UTC
Do you have OpenCL enabled in LibreOffice settings? https://help.libreoffice.org/Common/Open_CL
If yes, what if you disable the setting?

OpenCL is used with Calc and in some cases the cause for problems is a bad OpenCL driver.
Comment 14 mattg889 2016-07-16 21:16:33 UTC
I just tried that again, I un-checked the box that says "allow use of opencl".  No change.  I tried it on both computers.
Comment 15 mattg889 2016-07-16 22:51:38 UTC
Well this is interesting.  I left my computer for a couple hours with a libreoffice calc window sitting frozen.  I cam back to it and my document was opened.  So I closed it and tried to open it again and it was frozen again.  
So I left it and watched it, it eventually opens the document after sitting frozen for about 7 minutes.
After waiting 7 minutes I can do anything to the document.  I guess for now I will have to just wait that long to edit my documents.  
And no my computer is not that slow, it usually opens the documents in about a second.  It is the same result on both my desktop and laptop, wait 7 minutes and it opens.
Comment 16 Aron Budea 2016-07-17 01:08:53 UTC
Do you have Cortana enabled? If you do, can you give it a try after disabling it? Saw quite some people having performance issues with Cortana+Excel, and while the symptoms don't fit completely, it could be worth a try.

Regarding the question you asked earlier about soffice.bin and .exe. There's a single LibreOffice application, soffice.bin.
soffice.exe, and a few other similar executables like swriter.exe or scalc.exe are only used to launch this main application so Writer/Calc/etc. comes up. It's normal to have both in task manager.
Comment 17 mattg889 2016-07-17 03:46:33 UTC
Cortana is and always was disabled on both computers.
Comment 18 Buovjaga 2016-07-22 09:27:54 UTC
I guess you could set up WinDbg debugging and then try with
!analyze -v -hang
instead of the usual !analyze -v
https://wiki.documentfoundation.org/How_to_get_a_backtrace_with_WinDbg

I don't guarantee it will get useful info, but it is worth a shot.
Comment 19 Carlos 2017-04-04 14:37:21 UTC Comment hidden (obsolete)
Comment 20 mattg889 2017-04-04 15:16:55 UTC
Hi Carlos,
Thank you for bringing this bug to my attention, I forgot all about having it open.  Libreoffice has been working fine for awhile now.  I just put up with waiting for documents to open, and then it was working fine again one day after windows updated without my permission again...

I think it was initially a windows update that broke something Libreoffice needed, and another update from Microsoft inadvertently fixed it.
At any rate, its working fine for me right now.
Thank you to everyone for their input.