Problem description: Libreoffice crash on exit all time that i use a Basic Macro to access to a database connected to a sheet of calc (sorry for my english...) Steps to reproduce: 1. Create a simple document in calc anda save it. Cod Description Price 1 test1 10 2 test2 20 3 test3 30 2. Create and register a Database connected to a calc file 3. Created the macro and execute Sub TEST DatabaseContext = createUnoService(“com.sun.star.sdb.DatabaseContext”) DataSource = DatabaseContext.getByName(“TEST”) If Not DataSource.IsPasswordRequired Then Connection = DataSource.GetConnection(”“,”“) Else InteractionHandler = createUnoService(“com.sun.star.sdb.InteractionHandler”) Connection = DataSource.ConnectWithCompletion(InteractionHandler) End If end sub Current behavior: Now libreoffice crash on exit Expected behavior: Operating System: Windows 8 Version: 4.2.5.2 release
When trying to run the macro I get: BASIC syntax error. Unexpected symbol: . It highlights the first “ in the second line. Doesn't crash on exit either. Can you test on 4.3.2.2 or a daily build from here http://dev-builds.libreoffice.org/daily/master/Win-x86@39/ ? Tested on: Version: 4.4.0.0.alpha1+ Build ID: 0a82645c360158f9cc0fdabe2a52f1ff8f981bed TinderBox: Win-x86@39, Branch:master, Time: 2014-10-24_06:59:23
Thanks for your replay. I have tested now with libo 4.3.2.2 and the problem persist. BASIC syntax error. is caused by a problem with copy and past of "" try this code: Sub TEST Dim DatabaseContext As Object Dim DataSource As Object DatabaseContext = CreateUnoService("com.sun.star.sdb.DatabaseContext") DataSource = DatabaseContext.getByName("TEST") If Not DataSource.IsPasswordRequired Then Connection = DataSource.GetConnection("","") Else InteractionHandler = createUnoService("com.sun.star.sdb.InteractionHandler") Connection = DataSource.ConnectWithCompletion(InteractionHandler) End If end sub If problem persist rewrite "". Thanks and sorry for my english.
All right, thanks! I managed to reproduce this (same dev version as comment 1) so setting to NEW.
Created attachment 108487 [details] Linux 4.3.2.2 backtrace The attached is a backtrace from a binary package of 4.3.2.2. I can't however reproduce this on current master
Created attachment 108499 [details] Linux 4.4 master backtrace I take the above back, I did eventually manage to get the attached crash on 4.4 master - it looks completely different, so the two issues may be unrelated
Adding self to CC if not already on
I have the same crash on exit when connecting to a sheet of Calc using Mail Merge (Mail Merge creates a database connection). LibreOffice version: 4.4.1.2 Operating system: Windows XP Professional SP3 Italian
Any update with last stable LO version 5.0.3?
This is confirmed, so no need to change the status.
(In reply to Beluga from comment #9) > This is confirmed, so no need to change the status. It's confirmed with a version belonging to a branch soon EOL.
(In reply to Julien Nabet from comment #10) > (In reply to Beluga from comment #9) > > This is confirmed, so no need to change the status. > > It's confirmed with a version belonging to a branch soon EOL. Mass pings are done regularly for old bugs, but they are never set to NEEDINFO, only a comment is added.
If you add a Connection.dispose() when you are finished with the Connection then it'll not crash on exit
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=45e01be11111213f689ba5f1fa319e3dc48ea9c5 Resolves: tdf#81883 dispose OCalcConnection's doc before shutdown It will be available in 5.3.0. 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.
Hi Sorry I still reproduce the crash on windows 7/64 & Version: 5.3.0.0.alpha1+ Build ID: 8a796410ec8f440b4163b15b928347c499da7a8f CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-10-20_23:07:21 Locale: fr-FR (fr_FR); Calc: group I have tested without & with Connection.dispose() I join a windbg backtrace. Regards
Created attachment 128129 [details] windbg backtrace
@Pierre-Yves can you still confirm this issue with 5.3.0 final release or 5.3.1 release candidates?
Hi > @Pierre-Yves > can you still confirm this issue with 5.3.0 final release or 5.3.1 release > candidates? I no longer reproduce the crash on Windows 7/64 with : Version: 5.3.1.2 Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2 CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; Layout Engine: new; Locale: fr-FR (fr_FR); Calc: group Regards Pierre-Yves
Closing as RESOLVED WORKSFORME as per comment 17