Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > linux.debian.user > #186667 > unrolled thread

libreoffice base crashes when writing HSQLDB

Started byFlo <debianflo@gmx.at>
First post2017-09-10 23:10 +0200
Last post2017-09-12 18:40 +0200
Articles 8 — 5 participants

Back to article view | Back to linux.debian.user


Contents

  libreoffice base crashes when writing HSQLDB Flo <debianflo@gmx.at> - 2017-09-10 23:10 +0200
    Re: libreoffice base crashes when writing HSQLDB Joe <joe@jretrading.com> - 2017-09-11 10:30 +0200
      Re: libreoffice base crashes when writing HSQLDB Rene Engelhard <rene@debian.org> - 2017-09-11 15:10 +0200
        Re: libreoffice base crashes when writing HSQLDB Joe <joe@jretrading.com> - 2017-09-11 18:10 +0200
        Re: libreoffice base crashes when writing HSQLDB Flo <debianflo@gmx.at> - 2017-09-12 18:40 +0200
          Re: libreoffice base crashes when writing HSQLDB Curt <curty@free.fr> - 2017-09-17 12:00 +0200
    Re: libreoffice base crashes when writing HSQLDB Cindy-Sue Causey <butterflybytes@gmail.com> - 2017-09-11 19:30 +0200
      Re: libreoffice base crashes when writing HSQLDB Flo <debianflo@gmx.at> - 2017-09-12 18:40 +0200

#186667 — libreoffice base crashes when writing HSQLDB

FromFlo <debianflo@gmx.at>
Date2017-09-10 23:10 +0200
Subjectlibreoffice base crashes when writing HSQLDB
Message-ID<uohEm-18i-19@gated-at.bofh.it>
Dear all,

Libreoffice is working for me except for Base.

This means when I want to create a (or use an existing) database 
libreoffice crashes immediately without giving any information.

I open libreoffice and click to open a new database (HSQLDB Embedded).
Then Finish and I am asked about the name of the database. I enter the 
name, click Save and then comes the crash. A database file is created, 
though.

I am using Debian testing.

I haven't found anything in the web. Can anyone help me?

Best regards,
Flo

[toc] | [next] | [standalone]


#186672

FromJoe <joe@jretrading.com>
Date2017-09-11 10:30 +0200
Message-ID<uosgp-nx-7@gated-at.bofh.it>
In reply to#186667
On Sun, 10 Sep 2017 23:00:49 +0200
Flo <debianflo@gmx.at> wrote:

> Dear all,
> 
> Libreoffice is working for me except for Base.
> 
> This means when I want to create a (or use an existing) database 
> libreoffice crashes immediately without giving any information.
> 
> I open libreoffice and click to open a new database (HSQLDB Embedded).
> Then Finish and I am asked about the name of the database. I enter
> the name, click Save and then comes the crash. A database file is
> created, though.
> 
> I am using Debian testing.
> 
> I haven't found anything in the web. Can anyone help me?
> 

Sadly, no, Base is extremely flaky, and doesn't seem to have many
users. Chicken and egg.

Is there a possibility of using a different data type, or of also
running mysql/mariadb? I have reasonable success with data access using
mysql, the part I have major trouble with is report writing, which
stopped altogether for a couple of weeks recently. I had to resort to
writing a php report generator for the specific one I needed quickly.

Has this ever worked for you?

-- 
Joe

[toc] | [prev] | [next] | [standalone]


#186675

FromRene Engelhard <rene@debian.org>
Date2017-09-11 15:10 +0200
Message-ID<uowDn-3I9-9@gated-at.bofh.it>
In reply to#186672
On Mon, Sep 11, 2017 at 09:21:00AM +0100, Joe wrote:
> On Sun, 10 Sep 2017 23:00:49 +0200
> Flo <debianflo@gmx.at> wrote:
> 
> > Dear all,
> > 
> > Libreoffice is working for me except for Base.
> > 
> > This means when I want to create a (or use an existing) database 
> > libreoffice crashes immediately without giving any information.
> > 
> > I open libreoffice and click to open a new database (HSQLDB Embedded).
                                                        ^^^^^^^^^^^^^^^^^
> > Then Finish and I am asked about the name of the database. I enter
> > the name, click Save and then comes the crash. A database file is
> > created, though.
> > 
> > I am using Debian testing.
> > 
> > I haven't found anything in the web. Can anyone help me?
> > 
> 
> Sadly, no, Base is extremely flaky, and doesn't seem to have many
> users. Chicken and egg.

And beides Base being flaky, if you run i386 you run into the still unfixed
regression in the kernel breaking Java (well, stuff embedding the JVM) on
i386. (not on amd64).

And given the internal db is hsqldb - so *is* Java - and thus the JVM gets
initialized...

https://lwn.net/Articles/727206/                                                                                                                                                                                                                                                        
https://lwn.net/Articles/727703/                                                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                                        
See also https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=865303 and "friends".                                                                                                                                                                                                        
Somewhere there is also the boot option to disable the security(!) fix                                                                                                                                                                                                                  
to make Java work again.  

Your fault for still using i386 then. (Don't get me wrong: the regression
should be fixed, nevertheless, sure.)

> Is there a possibility of using a different data type, or of also
> running mysql/mariadb? I have reasonable success with data access using
> mysql, the part I have major trouble with is report writing, which

Would work.

> stopped altogether for a couple of weeks recently. I had to resort to
> writing a php report generator for the specific one I needed quickly.

The Report Builder also is Java...

Regards,

Rene

[toc] | [prev] | [next] | [standalone]


#186677

FromJoe <joe@jretrading.com>
Date2017-09-11 18:10 +0200
Message-ID<uozrA-5Ep-15@gated-at.bofh.it>
In reply to#186675
On Mon, 11 Sep 2017 14:52:29 +0200
Rene Engelhard <rene@debian.org> wrote:


> >  I have reasonable success with data access
> > using mysql, the part I have major trouble with is report writing,
> > which  
> 
> Would work.
> 
> > stopped altogether for a couple of weeks recently. I had to resort
> > to writing a php report generator for the specific one I needed
> > quickly.  
> 
> The Report Builder also is Java...
> 
>

Yes, it's the only bit of Base I use that does need Java. It works
poorly at best, and it just stopped for a while. No bits missing, as
far as I could see, bearing in mind that I run sid, but no dice.

I fired up my wife's computer and used Access to get the job done
immediately, but I've been trying to leave Access for ten years or
more, so I had a go with fpdf with php, and can now produce my most
important reports (i.e. invoices) if Base goes walkabout again.

-- 
Joe

[toc] | [prev] | [next] | [standalone]


#186714

FromFlo <debianflo@gmx.at>
Date2017-09-12 18:40 +0200
Message-ID<uoWo9-3DJ-1@gated-at.bofh.it>
In reply to#186675

On 09/11/17 14:52, Rene Engelhard wrote:
> On Mon, Sep 11, 2017 at 09:21:00AM +0100, Joe wrote:
>> On Sun, 10 Sep 2017 23:00:49 +0200
>> Flo <debianflo@gmx.at> wrote:
>>
>>> Dear all,
>>>
>>> Libreoffice is working for me except for Base.
>>>
>>> This means when I want to create a (or use an existing) database
>>> libreoffice crashes immediately without giving any information.
>>>
>>> I open libreoffice and click to open a new database (HSQLDB Embedded).
>                                                          ^^^^^^^^^^^^^^^^^
>>> Then Finish and I am asked about the name of the database. I enter
>>> the name, click Save and then comes the crash. A database file is
>>> created, though.
>>>
>>> I am using Debian testing.
>>>
>>> I haven't found anything in the web. Can anyone help me?
>>>
>>
>> Sadly, no, Base is extremely flaky, and doesn't seem to have many
>> users. Chicken and egg.
> 
> And beides Base being flaky, if you run i386 you run into the still unfixed
> regression in the kernel breaking Java (well, stuff embedding the JVM) on
> i386. (not on amd64).
> 
> And given the internal db is hsqldb - so *is* Java - and thus the JVM gets
> initialized...
> 
> https://lwn.net/Articles/727206/
> https://lwn.net/Articles/727703/
>                                                                                                                                                                                                                                                                                          
> See also https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=865303 and "friends".
> Somewhere there is also the boot option to disable the security(!) fix
> to make Java work again.
> 

This was a good hint. I played around a lot but the only thing I need to 
do is to use an older kernel.

I read in one of the articles that this should be solved at 4.13 and I 
installed such a kernel from the experimental release but it didn't 
change anything.

So for right now I can live with that. Though I don't like to run a 
kernel with some known security issues. And I hope it will get solved in 
the, hopefully, near future.

The other option would be to patch the kernel and to compile it myself ...

> Your fault for still using i386 then. (Don't get me wrong: the regression
> should be fixed, nevertheless, sure.)
> 

It's my old laptop. Still working ... .

Thank you very much.

Best regards,
Flo.

[toc] | [prev] | [next] | [standalone]


#186899

FromCurt <curty@free.fr>
Date2017-09-17 12:00 +0200
Message-ID<uqEwN-6en-11@gated-at.bofh.it>
In reply to#186714
On 2017-09-12, Flo <debianflo@gmx.at> wrote:
>
> The other option would be to patch the kernel and to compile it myself ...
>
>> Your fault for still using i386 then. (Don't get me wrong: the regression
>> should be fixed, nevertheless, sure.)
>
> It's my old laptop. Still working ... .

Have you tried the 'stack_guard_gap=1' kernel parameter?

> Thank you very much.
>
> Best regards,
> Flo.
>
>


-- 
"Time flies like an arrow. Fruit flies like a banana." Groucho

[toc] | [prev] | [next] | [standalone]


#186678

FromCindy-Sue Causey <butterflybytes@gmail.com>
Date2017-09-11 19:30 +0200
Message-ID<uoAH2-6oD-21@gated-at.bofh.it>
In reply to#186667
On 9/10/17, Flo <debianflo@gmx.at> wrote:
> Dear all,
>
> Libreoffice is working for me except for Base.
>
> This means when I want to create a (or use an existing) database
> libreoffice crashes immediately without giving any information.
>
> I open libreoffice and click to open a new database (HSQLDB Embedded).
> Then Finish and I am asked about the name of the database. I enter the
> name, click Save and then comes the crash. A database file is created,
> though.
>
> I am using Debian testing.
>
> I haven't found anything in the web. Can anyone help me?


Try running "libreoffice --base" in a terminal window, and see if that
gets you viable error messages. I just tested it, and it did bring up
the Database Wizard.

It's just something I picked up along the way about how Libreoffice
opens each feature. "--calc" gets the k/t for having taught me that a
long time ago and most likely via a right click over an Applications
menu entry... or something similar.. a long time ago... :)

Cindy :)
-- 
Cindy-Sue Causey
Talking Rock, Pickens County, Georgia, USA

* runs with duct tape *

[toc] | [prev] | [next] | [standalone]


#186715

FromFlo <debianflo@gmx.at>
Date2017-09-12 18:40 +0200
Message-ID<uoWoa-3DJ-21@gated-at.bofh.it>
In reply to#186678

On 09/11/17 19:26, Cindy-Sue Causey wrote:
> On 9/10/17, Flo <debianflo@gmx.at> wrote:
>> Dear all,
>>
>> Libreoffice is working for me except for Base.
>>
>> This means when I want to create a (or use an existing) database
>> libreoffice crashes immediately without giving any information.
>>
>> I open libreoffice and click to open a new database (HSQLDB Embedded).
>> Then Finish and I am asked about the name of the database. I enter the
>> name, click Save and then comes the crash. A database file is created,
>> though.
>>
>> I am using Debian testing.
>>
>> I haven't found anything in the web. Can anyone help me?
> 
> 
> Try running "libreoffice --base" in a terminal window, and see if that
> gets you viable error messages. I just tested it, and it did bring up
> the Database Wizard.
> 

For me there was not difference. Libreoffice just silently dies.

Best regards,
Flo

[toc] | [prev] | [standalone]


Back to top | Article view | linux.debian.user


csiph-web