Bug 42673 - With disconnected network printers, Calc hangs opening some files waiting on the Windows print spooler
Summary: With disconnected network printers, Calc hangs opening some files waiting on ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: All All
: low major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 116559 (view as bug list)
Depends on:
Blocks: Network Print
  Show dependency treegraph
 
Reported: 2011-11-07 09:56 UTC by erikmjacobs@gmail.com
Modified: 2019-08-04 11:57 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file that causes Calc to hang (45.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-11-07 10:09 UTC, erikmjacobs@gmail.com
Details
soffice.bin wait chain with spoolsv.exe (11.79 KB, image/png)
2019-07-07 12:05 UTC, drakkai
Details

Note You need to log in before you can comment on or make changes to this bug.
Description erikmjacobs@gmail.com 2011-11-07 09:56:40 UTC
Recently went to open .ods files that I have never had problems with.  When trying to open, calc will come up but hang and never completes opening the file. The files open fine with zip utilities as well as with LibreOffice on other OS (Linux).

It appears to be this computer and not necessarily LibreOffice itself.  If there are any ways to debug please let me know and I will provide additional information.  I will upload a sample file shortly that suffers from this issue.  Note that new files that are saved and some old files do not appear to be affected.
Comment 1 erikmjacobs@gmail.com 2011-11-07 10:09:09 UTC
Created attachment 53252 [details]
Example file that causes Calc to hang

I have an .xls that opens fine.  I saved said .xls as an .ods and tried to re-open it with Calc, and Calc hangs.  This file opens fine in Calc on Linux.
Comment 2 Markus Mohrhard 2011-11-07 11:44:27 UTC
try to backup your user profile, delete the existing one and thenre start calc and try to open the file again

might just be a corrupted user profile dir
Comment 3 erikmjacobs@gmail.com 2011-11-07 11:55:53 UTC
Where is the user profile stored in Windows 7?

I attempted a complete uninstall/reinstall before I posted the bug:
- Uninstall all Libreoffice
- Uninstall all Visual C++
- Uninstall all Java
- Remove everything I could find (Program Files (x86), Program Data/Libre Office, AppData/Roaming/Libreoffice, etc).
- Reinstall

The problem persisted, which is then why I posted the bug.

Are there any debug modes or other logging that I can do on Windows here?
Comment 4 erikmjacobs@gmail.com 2011-11-07 13:54:48 UTC
I had also run cccleaner and performed windows updates before reinstalling Libre.
Comment 5 erikmjacobs@gmail.com 2011-11-07 13:58:04 UTC
Application Log:
Fault bucket , type 0
Event Name: AppHangXProcB1
Response: Not available
Cab Id: 0

Problem signature:
P1: soffice.bin
P2: 3.3.9556.500
P3: 4d061efd
P4: cc55
P5: 128
P6: spoolsv.exe:spoolss
P7: 0.0.0.0
P8: 
P9: 
P10: 

Attached files:
C:\Users\Erik\AppData\Local\Temp\WER4F61.tmp.appcompat.txt
C:\Users\Erik\AppData\Local\Temp\WER4FEF.tmp.WERInternalMetadata.xml

These files may be available here:
C:\Users\Erik\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppHang_soffice.bin_382fd4bb4058dfcac8c381bbdeadb355723166b3_08c0509a

Analysis symbol: 
Rechecking for solution: 0
Report Id: 32fb2eb2-098b-11e1-a8d7-0030675a3caf
Report Status: 1
Comment 6 erikmjacobs@gmail.com 2011-11-07 15:10:35 UTC
What an annoying problem.  I figured out the fix.

Someone on IRC suggested that spoolsv had to do with printers:
17:09 <julien2412> spoolsv.exe is a Microsoft Windows system executable which
handles the printing process to your local printers.

After some sleuthing, I realized that I have a network-connected printer that
was offline.  Apparently this makes Windows 7 *extremely* angry.  After much
dorking around, I was able to remove this printer.

Guess what?  Calc starts up just fine!

This leads me to believe that there is a more sinister issue at hand.  Why
would .xls files and .odt files open just fine, but .ods files hang?  What was
it about this particular file that caused Calc to really want to get down with
the printers and to hang because this printer was not connected?

I will change the title of the bug.
Comment 7 erikmjacobs@gmail.com 2011-11-07 15:46:51 UTC
This is on Win7 x64 Ultimate.
Comment 8 Mas 2012-09-13 10:15:07 UTC
Hello, 

I am marking this ticket as resolved. The issue was resolved by you removing the printer on your network. 

The application have been unable to open the file due to an existing lock on the file by another application.
Comment 9 erikmjacobs@gmail.com 2012-09-13 13:39:25 UTC
"The application have been unable to open the file due to an existing lock on
the file by another application."

Which application?  Calc was the only program not able to open the file, and calc hung hard.  If the file was simply locked, the expectation would be for calc to report that "this file is in use by another application."

At best, this is an issue with how Calc handles file locking.

At worst, this is an issue with how Calc interacts with the print stack on Windows.

Saying that it's not a bug because removing the printer fixed the issue is folly.  The resultant implications are that:

* Temporary printer outages mean that Calc may at any moment be unusable. I guess printers never go down?

* Users who travel between multiple locations (home/office, etc) and have printers in each location will have to remove and reinstall printers before leaving the previous location so that calc will work.

Does this sound like it makes any sense to you?
Comment 10 Tyson Whitehead 2015-04-29 04:05:28 UTC
I would add that the latest version of calc hangs for a long time and then crashes on loading an ods file unless your network printer is turned on.

Took me most of the night to figure out what the heck was wrong as it was working fine earlier in the week (when the printer was on).  I tried upgrading and bunch of other stuff to no avail.

It wasn't until I accidentally picked print in another application that sitting there watching the pin wheel to time out triggered a memory about issues that power point has with off network printer

http://www.pptfaq.com/FAQ00035_General_PowerPoint_troubleshooting_procedures.htm

and made me think maybe that we my libreoffce problem too.  Sure enough.

I'm re-opening in hopes you will reconsider if for no other reason that libreoffice doesn't just hang but actually crashes now too.

Cheers!  -Tyson

PS:  I'm running 4.4.2.2 Build ID: c4c7d32d0d49... on Windows Vista.
Comment 11 Buovjaga 2015-10-09 18:08:08 UTC Comment hidden (obsolete)
Comment 12 Xisco Faulí 2016-09-11 19:50:04 UTC Comment hidden (obsolete)
Comment 13 Heinz Repp 2016-10-04 12:15:51 UTC
Hello, jumping in because I have this issue with Windows 10 Pro v1607 and LibO 5.2.2. 64bit (that's why I changed Hardware from x32 to all).

When opening local simple ods files, Libreoffice shows an undecorated empty and unresponsive window for about one minute. Digging with sysinternals Process Monitor, I see it continuing right after having loaded the printer spooler dll (ps5ui.dll), having dealt with printers when starting to be unresponsive. I have network printers not connected at this moment, that use the Postscript interface, so I guess Libreoffice hangs waiting for Windows loading the spooler ui dll, but that is clearly not the intended behavior.

I would expect to load the spooler dll from a non blocking thread while proceeding to open the file would solve this issue - showing an empty hanging windows to the user should never happen.
Comment 14 frugal 2017-06-16 04:18:01 UTC
I am having the same issue with LibreOffice_5.2.7_Win_x86 under Windows 8 x64.

When I load a file in Calc, it hangs for up to 2 minutes with the windows "Loading wheel icon" and becomes completely unresponsive. Afterwards it works
as normal.

My main printer is a network printer that is usually offline. No issues if the printer is online.

Here is someone else with the same issue - 
Like them, If I stop the windows process splwow64.exe as Calc is being unresponsive, calc resumes instantly (it becomes responsive) - 

Or, if I do "ipconfig /release" while Calc is being unrespnsive, it instantly becomes responsive.

https://ask.libreoffice.org/en/question/18138/calc-hangs-on-opening-ods-file-seems-related-to-printer-availability/
Comment 15 frugal 2017-06-16 04:20:43 UTC
To be clear, loading any Calc file in Calc causes this, not a specific file. Also, this freezing does not seem to happen if I load Libreoffice and click CREATE - Calc Spreadsheet.
Only loading an existing file.
Comment 16 frugal 2017-06-18 08:45:41 UTC
Also, this does NOT happen if I load an existing .xlsx file in Calc, only .ods
Comment 17 szz 2017-08-24 18:38:22 UTC
I could fix an ods whcih hangs when network printer was unavailable.
There is a section in ods (renamed to zip and extract settings.xml file from it) where the printer related option stored.

My netowork printer adreess was:  \\192.168.1.11\lp

If I delete printer related data section from settings.xml ods file opens like a charm even the network printer is unavailable :)

So delete XML data tags: PrinterName and PrinterSetup (whole xml data tags)
(of course make a backup from ods 1st)

<config:config-item config:name="PrinterName" config:type="string">\\192.168.1.11\lp</config:config-item><config:config-item config:name="PrinterSetup" config:type="base64Binary">ZQX+/1cvfgsdhdfzjdtzjdtzjdtzjfzhukgijhlAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAbbbbbbbbbbbbbbbbbbAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAARXBzb24gRVNDL1AtUiBWNCBDbGFzcyBEcffffffffffffffffffffffffAAEAAhSAAAEdAAAM1ROVwAAAAAKAFwAXAAxADkAMgAuAfafasdffasdfalésfdAs,dfÉSAD,fgksdmfgasmdfgsdfgsdaaaaaaaaaaaaaaaaaaBAMG3AfgsdfgsdfgsdfgsdfgsdfgsdfgsdfgsdfgsdfgfffffffffffffffffffffffAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAQAAAAIAAAABAAAA/////0dJfgQAAAAAAAAAAAAAAAsdfgsdffffffffffffffffffffffffffffffffffAAAAAAAAAAAAAAAAAAAAkAAAAAAAAAAAAAAAEAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAsdfgAAAAAAAAdsfgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAsdfgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAsAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAsdAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAdfgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAfgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddgggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggsdfgg==</config:config-item>


In My case the printer was an usb printer connected to my NAS and it was used by some Windows machines on home network.
When the NAS was turned off (or its LAN cable unplugged)
ods files freezed at opening.

In Calc File/Printer settings without deletion I could see the old network printer IP, after deletion there I could see my current default printer (also a network printer but connected to my router) however the settings.xml did not have the deleted tags.

So the final fix should be using some timeout at opening or a popup window about unavailable network printer and an option to delete old printer info from ods.

LO version 5.3.4.2 x64 & WIN10 Pro
Comment 18 frugal 2017-12-16 23:22:58 UTC
I wanted to add that this freezing can happen with an opened document that I'm editing, when I do certain tasks like highlight data and Ctrl-Rightclick-Format cells. Sometimes (not always) that action can freeze for 30 seconds before the Format cells dialog comes up. Again this won't happen if my network printer is ONLINE only when it is OFFLINE.


szz, I tried your trick but it did not work for me. (Although I do see mentions of an offline printer in many of my .ods files)
Comment 19 frugal 2017-12-16 23:39:00 UTC
szz, actually I think I spoke too soon. I think you're right. If I set my default printer to the "windows XPS writer" and create a new .ods, that file loads fine and has no issues. Only the files I created when my network printer was default have freezing issues .
Comment 20 frugal 2017-12-17 03:20:20 UTC
a partial fix: Load the file, pick File-> Printer Settings and select "Microsoft XPS Document Writer" or some other non-network printer, then re-save the file.

however there is still some freezing if your windows default printer is set to a offline network printer, despite doing the above. But it helps somewhat.
Comment 21 Tim 2018-01-21 12:24:30 UTC
Calc hang on open any ods files until I cleared print queue and completely removed virtual printer (ImagePrinter) from OS. The queue appeared from some bug in that printer during printing a .pdf file into images by other software (not LO).

Win7 x32
Calc 5.2.7.2
Comment 22 Jean-Baptiste Faure 2018-04-14 16:00:19 UTC
*** Bug 116559 has been marked as a duplicate of this bug. ***
Comment 23 Jean-Baptiste Faure 2019-02-04 14:23:10 UTC
I have the same problem under Linux (Ubuntu 16.04 x86-64) with LO 6.1.4 and network printers not reachable. If I disconnect my PC from the network, Calc opens the file instantly.

Best regards. JBF
Comment 24 drakkai 2019-07-07 12:02:56 UTC
I have the same problem on Windows 10 (version 1903 and 1809). When network printer is disconnected Calc hangs opening any files, I've tried couple version 6.2.x, 6.1.x and 6.0.x.
Comment 25 drakkai 2019-07-07 12:05:52 UTC
Created attachment 152615 [details]
soffice.bin wait chain with spoolsv.exe