Bug 148431 - document recovery includes file which failed previously
Summary: document recovery includes file which failed previously
Status: RESOLVED DUPLICATE of bug 136172
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.1.3 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoSave-AutoRecovery-Backup Document-Recovery
  Show dependency treegraph
 
Reported: 2022-04-06 20:44 UTC by Pierre Fortin
Modified: 2023-05-28 23:12 UTC (History)
1 user (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 Pierre Fortin 2022-04-06 20:44:15 UTC
During normal operation, tried to load a file that was too big for calc.  OK, ignore and move on.  To test for another bug, "kill"ed office. On starting oocalc, got the Document Recovery with 10 documents.  One of those docs was the one that failed to load days earlier. Got the "The data could not be loaded completely because the maximum number of rows per sheet was exceeded."
This file, having failed previously and the load cancelled, should not appear in the Document Recovery.
Comment 1 Pierre Fortin 2022-05-13 03:05:23 UTC
See https://bugs.mageia.org/show_bug.cgi?id=30155
Comment 2 Pierre Fortin 2022-05-15 17:22:28 UTC
Edited registrymodifications.xcu to remove references to the non-existent file; suspected this may not work because there were 2 references to this missing file which appeared identical. Starting oocalc after deleting these <item> records results in LO going to 100% CPU.

Since LO doesn't like a modified registrymodifications.xcu; restored original and created an empty file.  LO offers to open with an empty Text Import dialog; OK results in 100% CPU.  Killed.

Try again; but hit Cancel on Text Import dialog leads to successfully opening several documents.

Exit LO without saving any documents finally cleans up the recovery process.

Obviously not a user friendly way to get out of crashing...
Comment 3 Rafael Lima 2022-07-03 13:16:17 UTC
AFAIK loading a file does not change its internal contents, so there's no point recovering the file.
Comment 4 Pierre Fortin 2022-07-03 13:47:02 UTC
(In reply to Rafael Lima from comment #3)
> AFAIK loading a file does not change its internal contents, so there's no
> point recovering the file.

"recovering" in this context has nothing to do with contents; it's simply about restoring the session -- like a browser restoring all the open tabs. In this case, OO failed loading a file; yet put it on the recovery (restore) list.  A file which fails to load is not part of a session to restore; because it failed and is not loaded when the session is saved for later restore. HTH
Comment 5 Stéphane Guillou (stragu) 2022-12-20 22:34:28 UTC
Pierre, do you have an example file that we could use to test Calc failing to open it? Do you mean too big in file size, or too big in number of columns and/or rows?

We'd also need the info copied from Help > About LibreOffice.

Thank you!
Comment 6 Pierre Fortin 2022-12-21 04:00:50 UTC
(In reply to Stéphane Guillou (stragu) from comment #5)
> Pierre, do you have an example file that we could use to test Calc failing
> to open it? Do you mean too big in file size, or too big in number of
> columns and/or rows?
> 
> We'd also need the info copied from Help > About LibreOffice.
> 
> Thank you!

This is now a quite old bug.  I've not seen it in months.  It had to do with too many rows.   Even the jumbo mode of Calc is sometimes to small for our needs; just yesterday, I opened a couple files with just under 17M records each. OK to close.
Comment 7 QA Administrators 2022-12-22 03:36:31 UTC Comment hidden (obsolete)
Comment 8 Stéphane Guillou (stragu) 2023-05-28 23:08:14 UTC

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