Summary: | Calc freezes when saving file after running macros: Assertion `nIndex >= 0 && "coverity#1438402"' failed | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Petr Neudek <neutr> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | major | CC: | 79045_79045, kamlan, neutr, rb.henschel, stephane.guillou |
Priority: | medium | Keywords: | bibisected, bisected, regression |
Version: | 7.1.0.0.alpha1+ | ||
Hardware: | x86-64 (AMD64) | ||
OS: | All | ||
URL: | http://kombinatorika.esagil.cz/partition-numerorum/prakticke-zalezitosti/home-page-templates-paragraph-cipher-pnbt-0-simple-8bit/ | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | Regina Henschel | |
Bug Depends on: | |||
Bug Blocks: | 105537, 108908 | ||
Attachments: |
Modul Basic
error message image test ODS test ODS Test My folder |
Description
Petr Neudek
2023-04-08 06:14:14 UTC
Created attachment 186540 [details]
Modul Basic
No warning anywhere - a very insidious bug.
no problem in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 185cf4496d8750c9e4905c4e384252b01b85d130 CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: CL threaded Could you please paste here the information copied from Help > About LibreOffice? And the link to your forum question? Thank you. For Stéphane Guillou (stragu) here is my forum post translated into English. Original https://forum.openoffice.cz/viewtopic.php?pid=25750#p25750 I have been experiencing a strange phenomenon for the past 4 days. I programmed a template for educational purposes on the topic of sorting algorithms. Everything was good in the beginning, but after a certain point I couldn't save the work. No error was visible in IDE Basic and I could test repeatedly. I just couldn't save the work. At that moment, LO stopped communicating. So I waited and when there was no change even after an hour, I had to turn off the LO. I tested everything possible. I reinstalled the installed version of LO 7.4.6 to 7.5.2 on two of my computers with W10. No luck - it behaved the same on both machines. I got around the problem by exporting Basic, which I immediately imported back after the crash. I was irritated by the information about the crash from the LO system: - "The Libre Office program is not responding. Please wait until the Windows system reports the problem to Microsoft". Also unusual behavior of LO after a crash, for example "lu5620ciyh3.tmp", which remain in the folder even after recovery. Now that I've come to terms with the fact that I'll be storing Basic externally. There was a message from Petr Valach that a new version of Apache OpenOffice 4.1.14 was released. I installed it and lo and behold. The macro immediately reported an error in the code. It was a code for a button in a cell where I would certainly not expect it: Dim oObjAnchor as object oShape.Size = oSize oDrawPage.add(oShape) oObjAnchor = oShape.Anchor with oShape .Anchor = oObjAnchor.getCellByPosition(17,5) end with LO didn't report any error and the button worked fine - just couldn't save it. I solved the problem easily. I used a hyperlink instead of the button that started the replay of the demonstration and the problem was solved. But such a tricky mistake must be solved. The error is that LO does not detect its own error and sleeps after the save command. I've experienced something similar before. Specifically, an error in "generalFunction.COUNT". I rewrote various macros for half a year and when I was done with the corrections, the LO correction came - nothing but a big waste of time and nerves. Created attachment 186594 [details]
error message image
Message translation : LibreOffice is not responding. Please wait while Windows reports the problem to Microsoft...
When running the main macro, the new sheet populates as expected, no error reported. However, it doesn't create the button. That's because "ButtonInToCellBubble" is commented out in the Preparation sub. Once it is uncommented, running the main macro does create the button. I could save the file, with or without button. Then, to test the button, I had to rename the module to "BubbleSort_Clasic" otherwise it wouldn't find the macro. Once I pressed the button and the bubble sort was run again, then I could not save. Saving the file hangs LibreOffice at 100% of one core. A .tmp file remains in the file's directory after attempting a save. Tested with: Version: 7.5.2.2 (X86_64) / LibreOffice Community Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Petr, in the future, it would make it easier if you shared an ODS file that contains everything, the macros ready to use, for us to test and avoid the guesswork. Created attachment 186604 [details]
test ODS
Steps:
1. Open attachment
2. Tools > Macros > Run macros > bubble.ods > Standard > BubbleSort_Clasic > Main. Click Run.
3. It is possible to save the ODS at this stage.
4. Press the "Repeat the BubbleSort demo" button
5. Once completed, try to save again
Result: freeze at 100% of one core. Temp file in directory.
Created attachment 186605 [details]
test ODS
Steps:
1. Open attachment
2. Tools > Macros > Run macros > bubble.ods > Standard > BubbleSort_Clasic > Main. Click Run.
3. It is possible to save the ODS at this stage.
4. Press the "Repeat the BubbleSort demo" button
5. Once completed, try to save again
Result: freeze at 100% of one core. Temp file in directory.
With a debug build, I get a failed assertion: warn:xmloff:40095:40095:xmloff/source/text/XMLTextListAutoStylePool.cxx:163: getStyleFamilies() from XModel failed for export! warn:xmloff:40095:40095:xmloff/source/style/impastpl.cxx:369: Adding duplicate family table-column with mismatching mapper ! P25SvXMLExportPropertyMapper 25SvXMLExportPropertyMapper warn:xmloff:40095:40095:xmloff/source/style/impastpl.cxx:369: Adding duplicate family table-row with mismatching mapper ! P25SvXMLExportPropertyMapper 25SvXMLExportPropertyMapper warn:xmloff:40095:40095:xmloff/source/style/impastpl.cxx:369: Adding duplicate family table-cell with mismatching mapper ! P25SvXMLExportPropertyMapper 28XMLShapeExportPropertyMapper warn:sc:40095:40095:sc/source/filter/xml/xmlexprt.cxx:549: not anchored to current sheet! warn:xmloff:40095:40095:xmloff/source/text/XMLTextListAutoStylePool.cxx:163: getStyleFamilies() from XModel failed for export! warn:xmloff:40095:40095:xmloff/source/style/impastpl.cxx:369: Adding duplicate family table-column with mismatching mapper ! P25SvXMLExportPropertyMapper 25SvXMLExportPropertyMapper warn:xmloff:40095:40095:xmloff/source/style/impastpl.cxx:369: Adding duplicate family table-row with mismatching mapper ! P25SvXMLExportPropertyMapper 25SvXMLExportPropertyMapper warn:xmloff:40095:40095:xmloff/source/style/impastpl.cxx:369: Adding duplicate family table-cell with mismatching mapper ! P25SvXMLExportPropertyMapper 28XMLShapeExportPropertyMapper warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 5 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 2 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 5 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 10 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 2 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 3 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 5 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 2 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 5 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 10 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 2 warn:editeng:40095:40095:editeng/source/uno/unofield.cxx:375: Id service unknown: 3 warn:xmloff:40095:40095:xmloff/source/text/XMLTextListAutoStylePool.cxx:163: getStyleFamilies() from XModel failed for export! warn:xmloff:40095:40095:xmloff/source/style/impastpl.cxx:369: Adding duplicate family table-column with mismatching mapper ! P25SvXMLExportPropertyMapper 25SvXMLExportPropertyMapper warn:xmloff:40095:40095:xmloff/source/style/impastpl.cxx:369: Adding duplicate family table-row with mismatching mapper ! P25SvXMLExportPropertyMapper 25SvXMLExportPropertyMapper warn:xmloff:40095:40095:xmloff/source/style/impastpl.cxx:369: Adding duplicate family table-cell with mismatching mapper ! P25SvXMLExportPropertyMapper 28XMLShapeExportPropertyMapper soffice.bin: /home/tdf/lode/jenkins/workspace/lo_gerrit/tb/src_master/sc/source/filter/xml/xmlexprt.cxx:1513: void ScXMLExport::OpenRow(sal_Int32, sal_Int32, sal_Int32, ScXMLCachedRowAttrAccess&): Assertion `nIndex >= 0 && "coverity#1438402"' failed. Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1b463f697405e64a03378fb38a32172c4d3c25e6 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Freeze also in 7.4: Version: 7.4.6.2 / LibreOffice Community Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Started crashing / freezing in 7.1. Bibisected with linux-64-7.1 repo to first bad commit 25b3c957bfcb95a1da27a6021d1514495fd7df51 which points to core commit: commit 1f0b3c7a40edfa81bbc7a58d123a6a2dfd83e4ca author Regina Henschel <rb.henschel@t-online.de> Sat Oct 10 17:55:31 2020 +0200 committer Regina Henschel <rb.henschel@t-online.de> Sat Oct 31 15:36:00 2020 +0100 Improve 'resize with cell' handling Reviewed-on: https://gerrit.libreoffice.org/c/core/+/104643 Reviewed-by: Regina Henschel <rb.henschel@t-online.de> Regina, can you please have a look? I now believe this error may be related to my attachment today. It is the Work folder in the Test folder. I will not comment here, only that this is not a LO error, but an attack on my computer from the outside. Therefore, I strongly warn - The attachment may contain a virus. The folder itself contains a new bug, but now I believe it may have already appeared in this bug. The attachment contains a file on which you can demonstrate what is happening to me, as well as screenshots. From these it should be possible to understand what the subject of the problem is just by the fact that the screens are numbered. Sorry about that. I already suspected this when reporting this bug and that's why I didn't show the source file. If it's an outside attack, the attacker can program at a developer level, he's checking my OS, and now I'm documenting the attack on my phone. Now I'm afraid it could be anyone, even from this site. Now I'm working on a second computer completely off the network, wifi and all dangerous settings are turned off. Also, it is probably more about my website where I list various things that may be of interest to scumbags. For example Temlate in Libre Office "paragraph cipher PNBT 8bit simple" which I put in this post as a default link, but I deal with many other things. So I have no idea who it could be, although I can guess. sorry Created attachment 187011 [details] Test My folder I'm not sure so here's a link to an external repository https://uloz.to/tamhle/SMTG3hGxxOjj#!ZGZ0AwR2ZwIwBQMwMGEyZwqxBGp4ZJcdG3unERIzBJcQAmEzAD== PLEASE NOTE - THE FILES MAY BE VIRUS INFECTED Comment on attachment 186594 [details] error message image I'm not sure so here's a link to an external repository https://uloz.to/tamhle/SMTG3hGxxOjj#!ZGZ0AwR2ZwIwBQMwMGEyZwqxBGp4ZJcdG3unERIzBJcQAmEzAD== PLEASE NOTE - THE FILES MAY BE VIRUS INFECTED I'm not sure, but I can't seem to upload the attachment as a folder, nor as a zip archive. There's always something different coming up here. So a link to an external repository: https://uloz.to/tamhle/SMTG3hGxxOjj#!ZGZ0AwR2ZwIwBQMwMGEyZwqxBGp4ZJcdG3unERIzBJcQAmEzAD== PLEASE NOTE - FILES MAY CONTAIN VIRUSES. |