Bug 131128 - Office does not run when there is no internet connection
Summary: Office does not run when there is no internet connection
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
6.2.8.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 133621 137217 (view as bug list)
Depends on:
Blocks:
 
Reported: 2020-03-04 17:03 UTC by alan
Modified: 2021-07-22 13:33 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Image displayed when Libre Office hangs (64.19 KB, image/jpeg)
2020-03-04 17:03 UTC, alan
Details
Image when Libre Office hangs. Router connection but no internet (392.43 KB, image/jpeg)
2020-03-07 20:14 UTC, alan
Details
Splash screen displays permanently - no connection router to internet (306.61 KB, image/jpeg)
2020-12-16 01:39 UTC, alan
Details
LibreOffice is not responding. Hangs (4.27 MB, image/jpeg)
2020-12-16 01:42 UTC, alan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description alan 2020-03-04 17:03:27 UTC
Created attachment 158390 [details]
Image displayed when Libre Office hangs

I am running Libre Office 6.2.8.2 (x64)on Windows 7 pro 64 bit.

When there is no internet connection and I start Libre Office it hangs after displaying the attached image.

If Libre Office is running when the connection is lost, there is no problem. It will continue running and new documents can be opened.

It is only when there are no Libre Office processes running when the internet connection is lost and an attempt is then made to either open Libre Office or open a Libre Office document that it hangs.

Note: I do not auto-start Libre Office as part of my login. So if I am not running Libre Office and lose my internet connection, I can not open any of my documents until my internet connection is restored. This is a major problem - especially when travelling.
Comment 1 Oliver Brinzing 2020-03-06 18:00:19 UTC
Thank you for reporting the bug. 

To be certain the reported issue is not
related to corruption in the user profile, could you please reset your
Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and
re-test?

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the issue is still present
Comment 2 alan 2020-03-07 20:14:37 UTC
Created attachment 158479 [details]
Image when Libre Office hangs. Router connection but no internet

Did as requested and reset my profile. LibreOffice still hangs when there is no connection to the internet. The only difference is that it is displaying its initial screen when it hangs.

Let me be more specific about when the issue occurs. If there is NO connection to the router (and therefore no connection to the internet). LibreOffice runs fine.

When there is a connection to the router but NOT to the internet, LibreOffice hangs. 

See the attached file. The wireless utility shows there is a strong connection to the router. The control panel also indicates that there is a connection to the router. However, there is no connection to the internet. LibreOffice is ghosted and indicates that it is "not responding".

Other programs work fine (obviously browsers are unable to connect to the internet but they don't hang).
Comment 3 Oliver Brinzing 2020-03-08 09:25:13 UTC
(In reply to alan from comment #2)

Have you tried to run LO in SafeMode - maybe disabling OpenGL?
https://wiki.documentfoundation.org/OpenGL

You may also try with latest LO 6.3.5/LO 6.4.1, disabling the "Online-Update" feature in the installation wizard.
Comment 4 alan 2020-03-08 19:49:05 UTC
The page you reference does indicate that certain hardware/drive combos will cause a crash. I would expect those to be graphic card related, not network, especially when the crash only occurs when there is no connection from the router to the internet - which has NOTHING to do with hardware or drivers. It could be OPENGL if it attempts an internet access on initial startup.

I strongly suspect that there is a section of code in LO that, ON INITIAL startup, checks for an active port and attempts to access the internet without using a timeout.

To reiterate, the crash ONLY occurs on initial startup of LO when no LO processes are active, there is a connection to the router and no connection to the internet. 

LO works perfectly when there is no connection to the router. It works perfectly when there is a connection to the internet. It works perfectly when it is already running when the internet connection is lost.

Are you unable to recreate the issue by unplugging your router from the cable to your ISP and attempting to run LO (after first ensuring that no LO processes are running)? If you have not attempted this, please do so.

In the meantime, when there is no one else using the router, I will disable OPENGL, disconnect the router from the internet and see if the crash still happens.
Comment 5 Timur 2020-03-31 15:41:12 UTC
First you were asked to turn off check for updates, Tools-Options-Online update and to turn off that component on next install.
You may also monitor packets, like with Wireshark.

Uconfirmed bug draws QA but hardly will anyone reproduce this. 
So I set Needinfo and ask you to change only if you find the cause yourself.
Comment 6 Timur 2020-06-11 12:37:27 UTC
*** Bug 133621 has been marked as a duplicate of this bug. ***
Comment 7 QA Administrators 2020-12-09 03:39:25 UTC Comment hidden (obsolete)
Comment 8 alan 2020-12-16 01:39:40 UTC
Created attachment 168212 [details]
Splash screen displays permanently - no connection router to internet

NOTE: connection exists to router. No connection to internet.
Comment 9 alan 2020-12-16 01:42:00 UTC
Created attachment 168213 [details]
LibreOffice is not responding. Hangs

Splash screen displays permanently.
Comment 10 alan 2020-12-16 01:57:18 UTC
This is not related to settings on the computer or a corrupted profile. I have recreated the bug on a desktop running Windows 7 and on a laptop running Windows 10.

Look at the first of the two images provided.

1. "Splash screen displays permanently - no connection router to internet": NOTE that there is a connection to the router from the desktop. When there is no connection to the router from the desktop, Libre Office starts without an issue. 

It is ONLY when there is a connection to the router but NOT to the INTERNET that Libre Office hangs on startup.

2. "Libre Office is not responding. Hangs": After letting the splash screen display for several minutes, when one left clicks on the splash screen, ones gets the dialog that Libre Office is not responding.

*** To reproduce the bug you must 
1. have no Libre Office processing running.
2. be connected from the desktop to the router.
3. NOT be connected from the router to the Internet.
4. start Libre Office.
Comment 11 QA Administrators 2020-12-16 03:58:42 UTC Comment hidden (obsolete)
Comment 12 Laurynas 2021-01-10 15:32:45 UTC
I can not reproduce the bug in

Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: default; VCL: win; 
Locale: en-GB (en_GB); UI-Language: en-US
Calc: threaded
Comment 13 alan 2021-01-11 18:27:15 UTC
I take it that you ended the process tree of all Libre Office processes that were running on your computer. 

You disconnected your router from the internet.

Your computer remained connected to the router and you verified that it had a valid connection to the router but not from the router to the internet (as shown in the image I provided).

You verified that no Libre Office processes were automatically restarted.

Then you started Libre Office and it did not hang?

If that is the case, and you did each of the above steps in the above order, and you were unable to recreate the issue; than I am totally baffled since this happens every time I test it on both Windows 7 and Windows 10....
Comment 14 Timur 2021-03-17 08:02:03 UTC
*** Bug 137217 has been marked as a duplicate of this bug. ***
Comment 15 Timur 2021-03-17 08:04:58 UTC
New by duplicates. 
Please test with changing proxy to No proxy, if possible (there's another bug for that).
Comment 16 axadasf 2021-03-18 15:04:02 UTC
Hi,
I posted a startup freeze bug for LibreOffice and the people respoding to the bugs marked it as a duplicate to this:

The link to that bug is: https://bugs.documentfoundation.org/show_bug.cgi?id=137217
Its name is:
"LibreOffice -> 6 seconds startup freeze when Internet Connection is Off"

For me the freeze happens on Windows 7 but not on Windows 10 x64.

"
The freeze doesn't happen for me on Windows 10 x64:

Windows 10 Pro version 10.0.10240 Build 10240
On Intel i7-412MQ, LibreOffice 7.0.4.2 x64, connecting to internet using a PPPOE Broadband connection,

tested with .xls and .ods files, like before,
I tested many times and there was no freeze.

internet off, cable NOT Connected - always very fast starts
internet off, cable connected - always very fast starts
internet on - always very fast starts
"
Comment 17 axadasf 2021-03-18 15:24:12 UTC
For me, LibreOffice only starts slowly, but runs after that.
This also happened to the person who filed 'Bug 133621'. alan maybe you should check and see if LibreOffice runs for you too, but it only starts slowly, and maybe change the title of the bug, because it is not a good name if LibreOffice only freezes.
Comment 18 alan 2021-03-18 16:46:02 UTC
My description is accurate. Libre Office does NOT freeze for a few seconds and then run. It hangs. It does this running Windows 7 on a desktop and Windows 10 on a laptop. I will be testing this again with the Proxy set to "None" (instead of System) to see if that "fixes" the problem.

If you have Libre Office processes running in the background when you start it, that may explain why you are only having a momentary freeze. I do not auto-start Libre Office on login. So no processes are running in the background when I start it.

My description of the issue is very clear on this. The program hang only occurs when there is a connection to the router from the computer, no connection from the router to the internet, and no Libre Offices processes running in the background.
Comment 19 axadasf 2021-03-18 17:16:41 UTC
Hi alan,
Did you wait 1 or 2 minutes to see if LibreOffice becomes responsive and works normally. That would mean that it's a temporary freeze not a final one.

I tested a couple of different settings for LibreOffice and I got the same results (for example with Updates on or off).

When doing more thorough testing I used the settings from the default installation process, that doesn't load LibreOffice at startup and I don't get any LibreOffice processes  still running after closing the .xls document and soffice.exe closes.

I didn't get the freeze using LibreOffice on a laptop running Windows 10 x64, using a PPPOE Connection (cable connection), but I had the Wi-fi off (the Wi-fi capability was SHUT DOWN, using the button on the laptop case, next to the keyboard).
On the same laptop, running windows 7 with Wi-fi off, I got the freeze using the PPPOE connection.
Comment 20 axadasf 2021-03-18 17:17:41 UTC
Sometimes I got freezes that lasted about 1 minute 40 seconds
Comment 21 axadasf 2021-03-18 17:21:16 UTC
I didn't test to see if the freeze happens when using an USB tethering connection to connect to the internet from a mobile phone (With other types of Internet Connections present or without other connections present). maybe I'll test this some time.
Comment 22 axadasf 2021-03-18 17:35:25 UTC
Hi alan,
I don't know if this helps you or makes sense for you, but maybe you can try a Linux live iso using an USB stick to test if LibreOffice freezes/doesn't run.
I used PCLinuxOS, installed on an SSD and I didn't get any freeze for LibreOffice.
Comment 23 axadasf 2021-03-19 09:33:15 UTC
Hi,
On Windows 10, I tested LibreOffice startup times when using an internet connection with usb tethering and after that with wi-fi.
I don't get longer startup times with wi-fi active, but I do get slightly longer startup times when the computer is connected to the internet using USB tethering using a mobile phone with Android.

i7-412MQ, Windows 10, LibreOffice 7.0.4.2 x64

usb tethering on

4 sec
6 sec
4.3 sec
4.6 sec
3.4 sec
2.7 sec
2.5 sec
3.4 sec
3.3 sec
3.4 sec

usb tethering off
1.3 - fast start, tested many times


usb tethering on

5.1 sec
5.1 sec
3.8 sec
3.8 sec
3.5 sec
4.2 sec
3.1 sec
3.6 sec
3.6 sec

----------------------------------------------------

wi-fi on or Off - oly fast starts (1.4 sec)
2.7 sec
1.4 sec
1.5 sec
Comment 24 alan 2021-03-26 08:15:21 UTC
Changed the Proxy in Libre Office from System to None. Opened Libre Office with a connection to the router but no connection to the Internet. It ran with a slight (trivial) delay on startup. Problem is resolved on both Windows 7 and Windows 10.

Thank you for the suggestion to change the Proxy to None! Would never have guessed that that was the issue.
Comment 25 axadasf 2021-04-01 06:39:16 UTC
Changing the Proxy server settings from System to None fixed my startup freezes, too.
Tools > Options > Internet > Proxy > Proxy server = None