Bug 149928

Summary: Crash when using base
Product: LibreOffice Reporter: DJLConsulting <dlanger>
Component: LibreOfficeAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: serval2412
Priority: medium    
Version: 7.3.2.2 release   
Hardware: All   
OS: macOS (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description DJLConsulting 2022-07-09 15:26:53 UTC
Libreoffice Database crashes repeatedly making it unusable 

Exception Type:        EXC_BAD_ACCESS (SIGILL)
Exception Codes:       KERN_PROTECTION_FAILURE at 0x00007ff7b98d6f78
Exception Codes:       0x0000000000000002, 0x00007ff7b98d6f78
Exception Note:        EXC_CORPSE_NOTIFY

Termination Reason:    Namespace SIGNAL, Code 4 Illegal instruction: 4
Terminating Process:   soffice [1463]
Comment 1 Julien Nabet 2022-07-09 17:05:16 UTC
What's the processor of the machine, ARM or Intel?
What's the macos version?
Which LO version did you use? (there's Intel or Apple Silicon version).
Could you give a try at 7.3.4 (the last LO version) ?

What precise Java version do you have? 32 bits or 64 bits?
What type of database do you use?
At which moment does it crash?
Comment 2 DJLConsulting 2022-07-09 17:26:19 UTC
(In reply to Julien Nabet from comment #1)
> What's the processor of the machine, ARM or Intel?
> What's the macos version?
> Which LO version did you use? (there's Intel or Apple Silicon version).
> Could you give a try at 7.3.4 (the last LO version) ?
> 
> What precise Java version do you have? 32 bits or 64 bits?
> What type of database do you use?
> At which moment does it crash?

Identifier:            org.libreoffice.script
Version:               7.3.2.2 (7.3.2.2) Intel ver.
Code Type:             X86-64 (Native)
Parent Process:        launchd [1]
User ID:               501

Date/Time:             2022-07-08 07:53:44.3586 -0400
OS Version:            macOS 12.4 (21F79)

java 13.0.2 2020-01-14
Java(TM) SE Runtime Environment (build 13.0.2+8)
Java HotSpot(TM) 64-Bit Server VM (build 13.0.2+8, mixed mode, sharing)

I just downloaded and installed LO 7.3.4 and the database crashed when I was asked whether LO should create a primary key for me. These were precisely the conditions for the crash the last time.
Comment 3 Julien Nabet 2022-07-09 17:29:22 UTC
Ok what type of database do you use?
embedded HSQLdb, Mysql, MariaDb, Postgresql?

Could you give a try at https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile ? (I don't think it's related but just to be sure)
Comment 4 DJLConsulting 2022-07-09 17:48:28 UTC
(In reply to Julien Nabet from comment #3)
> Ok what type of database do you use?
> embedded HSQLdb, Mysql, MariaDb, Postgresql?
> 
> Could you give a try at
> https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile ?
> (I don't think it's related but just to be sure)

Postgresql
Comment 5 Julien Nabet 2022-07-09 18:05:58 UTC
On pc Debian testing x86-64 with master sources updated today + Postgresql 12.4, I don't reproduce this.

Here are the steps I did:
- launched Base
- clicked "connect to an existing database"
- chose "PostgreSQL"
- for DBMS, I put:
host=127.0.0.1 dbname=test_db
- filled "User name"
- etc.
=> file created
- clicked on "Tables"
- clicked on "Create Table in Design View..."
- Field Name => id / Field Type => Integer [int4]
- clicked "Save" icon
=> dialog appeared asking schema + Table Name
- chose schema "public" and "test" for table name
=> dialog appeared asking "Should a primary key  be created now?"
- clicked "Yes"
=> No crash

Did you do something different from my step by step process?
Do you use direct connection to Postgresql or JDBC?
What's the version of Postgresql you use?
Comment 6 DJLConsulting 2022-07-09 18:48:42 UTC
(In reply to Julien Nabet from comment #5)
> On pc Debian testing x86-64 with master sources updated today + Postgresql
> 12.4, I don't reproduce this.
> 
> Here are the steps I did:
> - launched Base
> - clicked "connect to an existing database"
> - chose "PostgreSQL"
> - for DBMS, I put:
> host=127.0.0.1 dbname=test_db
> - filled "User name"
> - etc.
> => file created
> - clicked on "Tables"
> - clicked on "Create Table in Design View..."
> - Field Name => id / Field Type => Integer [int4]
> - clicked "Save" icon
> => dialog appeared asking schema + Table Name
> - chose schema "public" and "test" for table name
> => dialog appeared asking "Should a primary key  be created now?"
> - clicked "Yes"
> => No crash
> 
> Did you do something different from my step by step process?
> Do you use direct connection to Postgresql or JDBC?
> What's the version of Postgresql you use?

Yes, that works perfectly.
Comment 7 Julien Nabet 2022-07-09 19:56:59 UTC
(In reply to DJLConsulting from comment #6)
> ...
> Yes, that works perfectly.

So everything is ok for you and we can close this tracker?
If it's not the case, would it be possible you describe precisely how to reproduce the crash?
Comment 8 Julien Nabet 2022-07-10 12:29:42 UTC
Let's put this one to WFM.
Don't hesitate to reopen this tracker if you still reproduce this.
In this case, please describe precisely how to reproduce the crash.