Bug 131348 - CRASH: Mailmerge with ODBC Connection to sqlite3 when sending mailmerge as email with personalized greeting
Summary: CRASH: Mailmerge with ODBC Connection to sqlite3 when sending mailmerge as e...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
6.4.1.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-03-15 08:08 UTC by Tomi
Modified: 2020-11-26 03:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Hardcopy (101.27 KB, image/png)
2020-03-15 08:08 UTC, Tomi
Details
with email persionalization (100.35 KB, image/png)
2020-03-15 09:29 UTC, Tomi
Details
without email personalization (81.17 KB, image/png)
2020-03-15 09:30 UTC, Tomi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tomi 2020-03-15 08:08:07 UTC
Created attachment 158689 [details]
Hardcopy

Mailmerge with ODBC Connection to sqlite3.
When sending by email, the crash (see attachment) occurs, even in safe mode.
Comment 1 Tomi 2020-03-15 08:29:04 UTC
The error is only triggered if the submenu "E-Mail Nachricht" is selected. However, the content of each e-mail is incorrect. ALL recipient e-mails are attached to each e-mail.
Comment 2 Tomi 2020-03-15 09:27:50 UTC
The problem only occurs when the email is persionalized. See 2 more attachments. Does anyone have an idea where I should start? Is debugging possible?
Comment 3 Tomi 2020-03-15 09:29:32 UTC
Created attachment 158694 [details]
with email persionalization
Comment 4 Tomi 2020-03-15 09:30:48 UTC
Created attachment 158695 [details]
without email personalization
Comment 5 Alex Thurgood 2020-04-01 06:48:52 UTC
@Tomi : is this particular to using SQLite as a backend data source, or does the same thing happen with any data source ?

The reason I ask is because it would help us to triage this better.

If it occurs with any data source when you select a personalized greeting, then it is a mailmerge problem (python code probably, or mishandling of UI input), whereas if it only occurs when accessing SQLite data source over ODBC, the problem probably lies with the database code.
Comment 6 Tomi 2020-04-01 09:09:13 UTC
A test with a table (ods) and with a very simple HSQLDB data source shows the same behaviour.
Since I am a software engineer, I could also do deeper analysis. How should I approach debugging?
Comment 7 Alex Thurgood 2020-04-01 10:26:57 UTC
(In reply to Tomi from comment #6)
> A test with a table (ods) and with a very simple HSQLDB data source shows
> the same behaviour.
> Since I am a software engineer, I could also do deeper analysis. How should
> I approach debugging?

Usually debugging is done with a symbols enabled build of LO, so either you would have to build LO yourself with symbols enabled, or alternatively, if you are on Linux, you might be able to find a symbols package provided for your distribution and specific version of LO that you could install.

Not sure, how easy, or well, debugging a python script (for the mailmerge functionality is a python script) from within a running LO process would be, though, that's beyond my knowledge.
Comment 8 Julien Nabet 2020-04-28 22:06:30 UTC
Would it be possible you attach the minimum files to reproduce this (ideally with hsqldb embedded) + minimal step by step process to reproduce this?

Before this, you can give a try to 6.4.3 to be sure the pb is still there on 6.4 branch.

About building LO, it's quite easy on Linux (see https://wiki.documentfoundation.org/Development/GetInvolved) but if you want debug build, you need space (at least 30GB) + good cpu and at least 8GB for RAM.
Comment 9 QA Administrators 2020-10-26 04:13:13 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2020-11-26 03:49:18 UTC
Dear Tomi,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp