Apache OpenOffice (AOO) Bugzilla – Issue 111624
OOo crashes with invalid SET TABLE INDEX statement in script file
Last modified: 2017-05-20 10:22:11 UTC
- OOo version is 3.2.0 (german), Java Version is jre-6u20-windows-i586-s - Opening the file "Bandfinanzen.05.defekt.odb" - Click on "Tables" view --> OOo crashes
Created attachment 69463 [details] OOo 3.2.0 crashes with this odb file
The crash happens when click into table area. Need more details about your file. How did you created this file? It created in OOo 2.x versions? This file worked in earlier versions of OOo? You opened in mixed versions 2.x and 3.x? You copied data from other file?
I tried unzipping the file today and got an CRC error from my ZIP software??? - The File was originally created 2008-12-11 with an older version of OOo (I think it was 3.0) but recently I added some Tables/Views with version 3.2.0. - I think I never opened it with OOo 2.x but I am not sure about that. - Earlier modifications of this file did not cause any trouble. - I did not copy data from other file; all content was created in direct interaction with OOo Base and some SQL statements.
Another thing that may relate here: I remember that I manipulated the embedded HSQLD database through SQL statements before (CREATE VIEW, for instance) so I *knew* the file had to be saved. But the OOo "Save" button stayed disabled. So maybe I finally got an insane/incosonsistent file, which caused the app the crash when opened next time.
I can open with zipper and found that database/data file not contain real database data, and it cause crash. data file content: /*C1*/SET WRITE_DELAY 0 SET AUTOCOMMIT FALSE SET AUTOCOMMIT TRUE What you did last time with this file, I see no problem in database/script with Views. May be you deleted your data with some SQL script.
> May be you deleted your data with some SQL script. No I didnt. Would it be okay for OOo to crash if I did? Last steps I did before was - opening the previous modification of this file (which I still have and which also causes OOo to crash when clicking into "table" area) - NOT click into "table" area - click on "Save as..." because my hope was that this operation would somehow stabilize/cleanup the odb file content. I think the problem has two parts and maybe we need two issues here. (a) Why did OOo Base produce invalid/inconsistent odb file content? (which could be the topic of a new issue) (b) Why did OOo Base crash on opening this invalid odb file content instead of reporting an "invalid data error" or similar? (which is my issue here)
OO.o crashes when during initialization of the HSQL engine an invalid ALTER TABLE INDEX statement is executed. The command that causes the crash is embedded in the attached test document. In the embedded script file, within the ODB file is this line: SET TABLE "Transactions" INDEX'87920 90456 86704 89512 43' Which brings the question; What sequence of steps causes that invalid line to end up in the script file?
Created attachment 69487 [details] forerunner of Bandfinanzen.05.defekt.odb
toa7d9->atjensen: 'Bandfinanzen.05.defekt.odb' is actually the result of executing 'Save as...' on the opened document 'Bandfinanzen.04.defekt.odb' which also causes OOo to crash when clicking into the 'tables' area. Maybe the comparison of the two files may help you with your question. If I can be of further assistance let me know.
Fixed in cws dba33g. I don't know why hsqldb ask to read in the stream for a length of -4. Now we throw an IOException but hsqldb seems to fine with that.
Forgot to set target
Please verify. Thanks. - open attached 05 - click on tables => crash
verified in CWS dba33g find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33g