| Summary: | Base crashes when closing hsqldb schema or system query in embedded hsqldb database | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Peter Toye <lo> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | serval2412 |
| Priority: | medium | ||
| Version: | 5.1.5.2 release | ||
| Hardware: | All | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Screenshot of error message | ||
It also happens for another query: SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_PROPERTIES" Other queries (from a fairly small sample) don't seem to give any problem - might it be something to do with querying the information schema? No repro with Version: 5.1.5.2 Build ID: 7a864d8825610a8c07cfc3bc01dd4fce6a9447e5 Threads CPU : 2; Version de l'OS :Mac OS X 10.12.1; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group using a test hslqdb embedded database. Possibly Windows only issue. Please provide version(s) and bit type of : JDK JRE and a test ODB file, as it might be the file itself that is causing the issue. Since 5.1 branch is EOL, would it be possible you give a try to last stable LO version 5.2.3? Could you also rename your LO directory profile? (see https://wiki.documentfoundation.org/UserProfile#Windows) Have in mind that if you use LO 64 bits (x86-64), you must have Java 64 bits and if you use LO 32 bits (x86), you must have Java 32 bits (In reply to Alex Thurgood from comment #2) > No repro with > > Version: 5.1.5.2 > Build ID: 7a864d8825610a8c07cfc3bc01dd4fce6a9447e5 > Threads CPU : 2; Version de l'OS :Mac OS X 10.12.1; UI Render : par défaut; > Locale : fr-FR (fr_FR.UTF-8); Calc: group > > using a test hslqdb embedded database. > > > Possibly Windows only issue. > > Please provide version(s) and bit type of : > > JDK > JRE > and a test ODB file, as it might be the file itself that is causing the > issue. First - the answers to your questions. I have various JDKs and JREs installed (and should get rid of some old ones): 64-bit JDK 1.8.0_91,101,112, JRE 1.8.0_111&112. 32-bit JRE 1.8.0_111. I run the 32-bit LO - info from the "about" page: Version: 5.1.5.2 Build ID: 7a864d8825610a8c07cfc3bc01dd4fce6a9447e5 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Locale: en-GB (en_GB); Calc: group The JRE used by LO is the 32-bit 1.8.0_111. As for a test database - this is very interesting. I loaded the database and saved it under a different name. The queries still crashed when closing the window. Then I deleted all the forms, reports and queries (apart from the failing ones) and the queries now close OK. I am obviously going to have to do a lot of experimentation to find out just which deletions change the situation, and I'm very busy with my real work at the moment, so won't be able to do much for the rest of this week, maybe even next week. But I'll be back with more data then. Sorry for the hold-up. but life calls. @Peter : thanks for the update. Ideally, an ODB file with the minimum crashing set up would be best, but we'll keep this in NEEDINFO for the moment. (In reply to Julien Nabet from comment #3) > Since 5.1 branch is EOL, would it be possible you give a try to last stable > LO version 5.2.3? > > Could you also rename your LO directory profile? (see > https://wiki.documentfoundation.org/UserProfile#Windows) > > Have in mind that if you use LO 64 bits (x86-64), you must have Java 64 bits > and if you use LO 32 bits (x86), you must have Java 32 bits I've downloaded 5.2.3 and it doesn't seem to be crashing on a quick test. Of course I now can't go back to 5.1.5 to see if that still crashes. So for the moment I suggest we mark is as Solved and I'll reopen it if the crash appears again. Not sure whether its Fixed or Invalid, though - you might want to change that. Thank you for your feedback. Let's put this one to WFM since there's no specific fix. |
Created attachment 128715 [details] Screenshot of error message Running the following query on Base produces the required information, but when I close the window it crashes.I don't recall this happening on earlier version, but it is some time since I ran the query. SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_COLUMNS" WHERE "TABLE_SCHEM" = 'PUBLIC' The error message is attached - it doesn't tell you much!