Session times-out after 30 minutes about officeonline HOT 5 CLOSED

I have the same problem.
The connector or office must update file lock but it does not happen.

X-WOPI-Override – The string REFRESH_LOCK. Required.

from officeonline.

Hello,
I have the same problem too.

Do you find solution or workaround?

from officeonline.

I'm seeing that the locks in the oc_officeonline_locks table are being refreshed every ten minutes, extending the lock by 30 minutes. However, the token never gets extended. When the token expires, you can't edit anymore. However, since the file is still locked, we start seeing locking errors as others try to re-open and edit the file after the token expires. Expired tokens only seems to be removed from oc_officeonline_wopi when a new token is requested. Also, it seems that a lot of the time the lock isn't removed until the original opener of the file closes the window. This causes havoc periodically for us as we end up with files that stay locked data is lost as it seems there is fighting over the locks.

Currently, my workaround is a few things:

• I upgraded to PHP 7.4 and REFRESH_LOCK started getting called.
• I edited lib/Db/WopiMapper.php and changed TOKEN_LIFETIME_SECONDS to a longer lifetime (I set it to 4 hours).
• I put together a quick script that runs every 5 minutes and removes entries from oc_officeonline_locks that don't have a matching token in oc_officeonline_wopi.

So far, this allows the file to be opened long enough that it doesn't die in the middle of editing during group meetings. The 4 hour setting seems to set an upper-limit on the time the file can be opened, but because of the lock cleanup script I'm using, we don't seem to be having weird locking issues and data loss.

My edits are just a bunch of hacks to get this working in my organization. What I think needs to be done:

• The token lifetime should be extended along with the lock lifetime when REFRESH_LOCK is called.
• Every time oc_officeonline_locks and oc_officeonline_wopi is updated, locks should be removed when the associated token is no longer being used in the wopi table. Also, all expired tokens should be removed from the wopi table whenever the table is read or written.

I haven't had the time to try editing the app to how these changes would affect it.

Also, I take no responsibility as to whether these would work or not in your setup. I just know that since I implemented these changes a week ago, we haven't had any errors or data loss in our configuration, and that was happening almost every day before.

from officeonline.

Thank you.
I tried your workaround. It helped.
Now the documents do not fall off during the meeting.

from officeonline.

Let's track this in #155

from officeonline.