1) Open a database and create a new query in query editor. 2) Click in Activate/Deactivate design view (the button with the yellow ruler) to change to the SQL editor. 3) Type a simple input like this: SELECT "tblEmployees"."EmployeeName" FROM "tblEmployees" ORDER BY "EmployeeName" 4) Run the query. It works fine. Now add this code after that one: SELECT " 5) Base crashes when you type double quotes after the words SELECT. I know nothing about SQL, but even though this code may not be correct, it was not supposed to crash. Thanks.
On pc x86-64, I don't reproduce this on 3.5 branch. - could you try to reproduce this on a brand new file ? - could you try to reproduce it on 3.5.0 ?
Hello Julien, sorry for delaying the answer. By the way, I am the original author of the question, just with a different username (because I lost the data from the other account, created with a disposable email lol) So, regarding your questions the answers are: yes and yes! This bug persists in version 3.5.1 running in ArchLinux x86_64. Here you can reproduce it with a new file: 1) Open LibreOffice Base and create a new file. (I didn't register the database) 2) With the empty database (no tables), go to Queries and Create a new query in the editor. 3) It will ask you to choose between Tables or Queries. As you don't have any, just close it. 4) Change to SQL mode where you can insert the code directly (clicking on the button with the yellow rule) 5) Type this: SELECT " " " " 6) Base crashes in the 4th double quote (don't forget to respect the blank line). This error does not occur in LibreOffice 3.5.1 in Windows XP. By the way, I use PT-BR langpack in Linux and Windows XP. Tell me if you can reproduce the error now. Thanks!
Created attachment 58609 [details] Log file running LibreOffice 3.5.1 with OpenJDK6 This is the log file with the bug reproduced running LibreOffice 3.5.1 with OpenJDK 6 in Arch Linux x86_64. Here the program crashes when I open an existing file, click in Queries and click in Create query in the SQL editor. I can't even enter in the SQL editor.
Created attachment 58610 [details] Log file running LibreOffice 3.5.1 with OpenJDK 7 And this is the log file running it with OpenJDK 7. It happens exactly as it happened with OpenJDK 6. I'm just posting it because it can be helpful too.
I still don't reproduce it on master or on 3.5 branch (both updated today) (Forgot to say in previous message, I'm on Debian). Did you try to remove/backup your LO profile (see ~/.config/libreoffice or ~/.libreoffice check both) ? Have you got any extension ? If yes, could you disable them just for the test ? If you still reproduce it, above all with OpenJdk 6 (cause I think there are still problems with Java 7), could you install the debug symbol package (in Debian it's called "libreoffice-dbg") ? So you could attach the logs with symbols.
Created attachment 58645 [details] Valgrind log This is the Valgrind log. I've opened LibreOffice and chose Base, opened a blank document, clicked in "Queries", clicked in "Create Query in SQL View..." and typed this: SELECT " " " " It crashed after typing the fourth double quote.
Created attachment 58646 [details] Strace log This is the Strace log. I've opened LibreOffice and chose Base, opened a blank document, clicked in "Queries", clicked in "Create Query in SQL View..." and typed this: SELECT " " " " It crashed after typing the fourth double quote.
I've also downloaded Linux Mint 12 (LiveCD - 64 bits) and could reproduce the bug exactly like in Arch Linux. I suppose this bug only happens in Linux 64 bits, since some people using x686 could not reproduce it: https://bbs.archlinux.org/viewtopic.php?id=137842 Althought you Julien could not reproduce it using Debian 64 bits. Thanks!
I took a look at valgrind.log, found a lot of invalid write and quite often it was linked to a call of Javavm. Here are information about the OpenJdk I use : java version "1.6.0_24" OpenJDK Runtime Environment (IcedTea6 1.11.1) (6b24-1.11.1-3) OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode) Could you give your version ?
Hello Julien, my Java version is the same of yours: java version "1.6.0_24" OpenJDK Runtime Environment (IcedTea6 1.11.1) (ArchLinux-6.b24_1.11.1-3-x86_64) OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode) I couldn't test it in Debian Squeeze LiveCD because it uses OpenOffice.org and it gave an error when I clicked in Tables, probably because it's necessary to install additional packages. If you tell me how to install LibreOffice with Debian, maybe I can try to reproduce this error there as well. Thanks.
(In reply to comment #10) ... > If you tell me how to install LibreOffice with Debian, maybe I can try to > reproduce this error there as well. > I use Debian testing. If you do an apt-cache search libreoffice, you should see the LO packages. Then just install it. Suggestion : before installing LO, I would remove Openoffice with apt-get remove --purge so there are not conflicts or something. Check profiles (~/.config/libreoffice, ~/.config/openoffice, ~/.openoffice, ~/.libreoffice)
Can not reproduce on LinuxMint 12, 64bit with LO 3.4.4 and JVM 1.6.0_24 Alex
Reproduced with LO 3.5, but ONLY IF I enter 2 new line carriage return key presses in the SQL editor and then type the SELECT " string sequence : LibreOffice 3.5.5.2 Build ID: 24b32b4-b87ec2e-85c8e98-87a4e20-9a1b8c1 alex@Aspire-T180 ~ $ /opt/libreoffice3.5/program/soffice --base # # A fatal error has been detected by the Java Runtime Environment: # # SIGSEGV (0xb) at pc=0x00007f758bc8fbcd, pid=32246, tid=140142879820032 # # JRE version: 6.0_26-b03 # Java VM: Java HotSpot(TM) 64-Bit Server VM (20.1-b02 mixed mode linux-amd64 compressed oops) # Problematic frame: # C [libsvtlo.so+0x257bcd] MultiLineEditSyntaxHighlight::DoBracketHilight(unsigned short)+0x10d # # An error report file with more information is saved as: # /home/alex/hs_err_pid32246.log # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # [error occurred during error reporting , id 0xb]
Created attachment 64484 [details] strace log from LO 3.5.5.2 on Linux Mint 12 64 bit
Confirming as I can reproduce the behaviour.
Julien, This should be assigned to Lionel, or do you want to take it ? I'll adjust the "assigned to" accordingly. At the moment, this is incorrectly assigned to the OP. Alex
@lionel : care to take a look ? Alex
Also reported on the German discuss list this afternoon by another user. Alex
Cannot reproduce on my 3.5 dev tree (debug build with symbols). Can reproduce on official 3.5.5.3 binaries. Can reproduce on official 3.6.1.4 binaries. Can anybody reproduce in a build with symbols, and show a detailed backtrace (gdb command "bt full")? Can anybody reproduce in a debug build?
I'll give a try after my daytime job tonight. I've got 3.5, 3.6 and master sources.
Cannot reproduce in my 3.6 dev tree either.
I didn't try on 3.6 or master, only on 3.5 (updated today) for the moment but I still don't reproduce it. Now what the exact thing to type? I try this: - 2 blank lines - SELECT " " + return carriage - " " + 1 return carriage nothing Lionel: since you can't reproduce it on 3.6 branch, it may be ok in master. Anyway, do you reproduce it on 3.5 branch?
(In reply to comment #22) > Now what the exact thing to type? > I try this: > - 2 blank lines > - SELECT " " + return carriage > - " " + 1 return carriage > nothing For me, I do: SELECT "baz"."bar", "baz"."foo" FROM "baz" SELECT " " Where baz, bar and foo are real table and column names from the database > Lionel: since you can't reproduce it on 3.6 branch, it may be ok in master. > Anyway, do you reproduce it on 3.5 branch? I reproduce on official builds, also of 3.6 branch, but not on any development (debug) build.
I create a table ("baz") with only 2 columns "foo" and "bar" ("TEXT VARCHAR") both, no primary key, default options, no lines in it. I used each time "Create Query in SQL View". Copy pasted or typed it, still nothing. I opened the base with 3.5.4.2 Debian package too, the same... Nothing special in console too.
Version 3.7.0.0.alpha0+ (Build ID: 4deb9d4) Can no longer reproduce with the above build from master on OSX 10.8.1, this is WFM. Alex
(In reply to comment #25) Hi Alex and Julien, what´s your opinion: can status be changed to "RESOLVED FIXED/WORKSFORME"?
(In reply to comment #26) > (In reply to comment #25) > > Hi Alex and Julien, > > what´s your opinion: can status be changed to "RESOLVED FIXED/WORKSFORME"? Since I never succeeded in reproducing it, perhaps I missed something so I let Alex or Lionel decide about this. If it depended on me only, I would put WFM and indicate to not hesitate to reopen if it can be reproduced (+ give steps how to reproduce)
(In reply to comment #26) > (In reply to comment #25) > what´s your opinion: can status be changed to "RESOLVED FIXED/WORKSFORME"? No, since I reproduce, unless we check it is fixed in a new *official* (non-debug) *build*.
Yep, still broken on LOdev daily build 64bit from 13/09. Enclosing log and following output message on console : /opt/lodev3.6/program/soffice # # A fatal error has been detected by the Java Runtime Environment: # # SIGSEGV (0xb) at pc=0x00007fc8baf55dbd, pid=3516, tid=140500156614912 # # JRE version: 6.0_26-b03 # Java VM: Java HotSpot(TM) 64-Bit Server VM (20.1-b02 mixed mode linux-amd64 compressed oops) # Problematic frame: # C [libsvtlo.so+0x27adbd] MultiLineEditSyntaxHighlight::DoBracketHilight(unsigned short)+0x10d # # An error report file with more information is saved as: # /home/alex/hs_err_pid3516.log # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # [error occurred during error reporting , id 0xb]
Created attachment 67238 [details] hs pid error log
Created attachment 67239 [details] backtrace no symbols
I can reproduce this
Caolan McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=02917cb57e2c2e9fcab2db8f72960023f3e4edaf Resolves: fdo#47209 and rhbz#927223 syntax highlighter crash The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
patch proposed in gerrit for 4-0 and 3-6
Caolan McNamara committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=02da63878e7cfbc85e6bce74e1b7b0fb71a8ebec&h=libreoffice-3-6 Resolves: fdo#47209 and rhbz#927223 syntax highlighter crash It will be available in LibreOffice 3.6.7. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Caolan McNamara committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a4e27ec2be678fe126e49a5c8a9be4adc5cd6159&h=libreoffice-4-0 Resolves: fdo#47209 and rhbz#927223 syntax highlighter crash It will be available in LibreOffice 4.0.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.