Bug 124128 - Base hangs when opening relationships window
Summary: Base hangs when opening relationships window
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-17 15:44 UTC by Allan Macdonald
Modified: 2019-03-19 00:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
File that hangs. (5.70 KB, application/vnd.oasis.opendocument.database)
2019-03-17 15:45 UTC, Allan Macdonald
Details
File also hangs with fewer tables. (4.34 KB, application/vnd.oasis.opendocument.database)
2019-03-17 15:46 UTC, Allan Macdonald
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Allan Macdonald 2019-03-17 15:44:02 UTC
Description:
When selecting tools->relationships, Base hangs, requiring the application to be forced to quit.

Steps to Reproduce:
1. Follow the tutorial in the LibreOffice Getting Started Guide, Chapter 8, Getting Started with Base.

2. After building up the "automobile.odb" database, and finally arriving at the section entitled "Defining relationships", select Tools->Relationships as instructed in the tutorial.




Actual Results:
LibreOffice Base hangs after bringing up the Relation Design window.  The Add Tables dialog does not appear and the mouse pointer busy indicator keeps spinning forever.  The program has hung, has stopped responding to input and has to be forced to quit. 


Expected Results:
The program should never hang, even if the information entered is incorrect.


Reproducible: Always


User Profile Reset: No



Additional Info:
If I remove the two tables named "CD-Collection" and "CD-Jazz" and save the database, the program no longer hangs as before.

Version: 6.2.0.3
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3; 
Locale: en-CA (en_CA.UTF-8); UI-Language: en-US
Calc: threaded

OS: Ubuntu 18.04 LTS
Comment 1 Allan Macdonald 2019-03-17 15:45:23 UTC
Created attachment 150022 [details]
File that hangs.
Comment 2 Allan Macdonald 2019-03-17 15:46:32 UTC
Created attachment 150023 [details]
File also hangs with fewer tables.
Comment 3 Allan Macdonald 2019-03-17 15:54:27 UTC
(In reply to Allan Macdonald from comment #1)
> Created attachment 150022 [details]
> File that crashes.

Sorry, meant to say "Hang"
Comment 4 Allan Macdonald 2019-03-17 16:27:01 UTC
More info:

The file that I said doesn't hang, actually does.  However, if I copy a table and remove the old table, it stops hanging.  After closing and opening the database, it starts hanging again.

Steps to reproduce:

1. Copy the table named "Fuel"
2. Paste the table, naming it "Fuel2"
3. Copy all fields.  Keep all defaults.
4. Save the table.
5. Delete the old table named "Fuel"
6. Save the database file.
7. Confirm that the program doesn't hang when selecting tools->relationships.
8. Close the add table dialog and the relation design window.
8. Close the database file.
7. Open the database again.
8. Right away, select tools->relationshps.

HANG!
Comment 5 Drew Jensen 2019-03-18 15:56:13 UTC
Can confirm that the error happens using LO 6.2.0.3.

However using: Version: 6.2.3.0.0+
Build ID: bd5ef0f1ecb445021fc693bfd3cab0979a4c4c28
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
(downloaded from daily build yesterday) 

I can not reproduce with either file. 
The relationship window appears to be functioning properly again.

Not sure what status to set for the issue, fixed?
Comment 6 Drew Jensen 2019-03-18 16:55:58 UTC
OK - Works for me, makes more sense..so
Comment 7 Allan Macdonald 2019-03-18 19:39:42 UTC
(In reply to Drew Jensen from comment #6)
> OK - Works for me, makes more sense..so

Is it appropriate to resolve this bug when the bug is not fixed in an official release?  The problem still happens with LibreOffice 6.2.1.2.
Comment 8 Drew Jensen 2019-03-18 20:59:43 UTC
(In reply to Allan Macdonald from comment #7)
> (In reply to Drew Jensen from comment #6)
> > OK - Works for me, makes more sense..so
> 
> Is it appropriate to resolve this bug when the bug is not fixed in an
> official release?  The problem still happens with LibreOffice 6.2.1.2.

Nor is it fixed in the RC1 pre-release of 6.2.2.1 (just downloading that now to try and the bug is there) but is fixed in the very latest 6.2.3.0 build.

IDK what the chances are that this alone would be a showstopper bug for the 6.2.2;
I do know that for myself it would not.
Comment 9 Allan Macdonald 2019-03-19 00:03:48 UTC
(In reply to Drew Jensen from comment #8)
> (In reply to Allan Macdonald from comment #7)
> > (In reply to Drew Jensen from comment #6)
> > > OK - Works for me, makes more sense..so
> > 
> > Is it appropriate to resolve this bug when the bug is not fixed in an
> > official release?  The problem still happens with LibreOffice 6.2.1.2.
> 
> Nor is it fixed in the RC1 pre-release of 6.2.2.1 (just downloading that now
> to try and the bug is there) but is fixed in the very latest 6.2.3.0 build.
> 
> IDK what the chances are that this alone would be a showstopper bug for the
> 6.2.2;
> I do know that for myself it would not.

I think you missed my point. As far as a general user is concerned, this is a bug that still exists in the normal release that is available at libreoffice.org and the presence of this bug might preclude any sensible person from trying to use that version of software for any critical purpose.  As such, I am suggesting that perhaps marking this bug as resolved is premature until a fix is available for normal releases.  I am not willing to go so far as go and change the resolution myself and will defer to those in better authority to state what the policy is for LibreOffice develpment community regarding bug resolution.

Nevertheless, whether the bug is a "showstopper" or not is irrelevant with respect to whether or not the bug is fixed in the normal release.  If I am off base, please do not hesitate to let me know.
Comment 10 Allan Macdonald 2019-03-19 00:19:13 UTC
(In reply to Allan Macdonald from comment #9)
> (In reply to Drew Jensen from comment #8)
> > (In reply to Allan Macdonald from comment #7)
> > > (In reply to Drew Jensen from comment #6)
> > > > OK - Works for me, makes more sense..so
> > > 
> > > Is it appropriate to resolve this bug when the bug is not fixed in an
> > > official release?  The problem still happens with LibreOffice 6.2.1.2.
> > 
> > Nor is it fixed in the RC1 pre-release of 6.2.2.1 (just downloading that now
> > to try and the bug is there) but is fixed in the very latest 6.2.3.0 build.
> > 
> > IDK what the chances are that this alone would be a showstopper bug for the
> > 6.2.2;
> > I do know that for myself it would not.
> 
> I think you missed my point. As far as a general user is concerned, this is
> a bug that still exists in the normal release that is available at
> libreoffice.org and the presence of this bug might preclude any sensible
> person from trying to use that version of software for any critical purpose.
> As such, I am suggesting that perhaps marking this bug as resolved is
> premature until a fix is available for normal releases.  I am not willing to
> go so far as go and change the resolution myself and will defer to those in
> better authority to state what the policy is for LibreOffice develpment
> community regarding bug resolution.
> 
> Nevertheless, whether the bug is a "showstopper" or not is irrelevant with
> respect to whether or not the bug is fixed in the normal release.  If I am
> off base, please do not hesitate to let me know.

Never mind; I guess I AM off base:

https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/RESOLVED#The_Meaning_of_RESOLVED

I'll shut up now.