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
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)
Current behavior: Now libreoffice crash on exit
Operating System: Windows 8
Version: 188.8.131.52 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 184.108.40.206 or a daily build from here http://dev-builds.libreoffice.org/daily/master/Win-x86@39/ ?
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 220.127.116.11 and the problem persist.
BASIC syntax error. is caused by a problem with copy and past of ""
try this code:
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("","")
InteractionHandler = createUnoService("com.sun.star.sdb.InteractionHandler")
Connection = DataSource.ConnectWithCompletion(InteractionHandler)
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 18.104.22.168 backtrace
The attached is a backtrace from a binary package of 22.214.171.124. 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: 126.96.36.199
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
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":
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:
Affected users are encouraged to test the fix and report feedback.
Sorry I still reproduce the crash on windows 7/64 & Version: 188.8.131.52.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.
Created attachment 128129 [details]
can you still confirm this issue with 5.3.0 final release or 5.3.1 release candidates?
> can you still confirm this issue with 5.3.0 final release or 5.3.1 release
I no longer reproduce the crash on Windows 7/64 with :
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; Layout Engine: new;
Locale: fr-FR (fr_FR); Calc: group
Closing as RESOLVED WORKSFORME as per comment 17