Ask Your Question

Libre Base Errors [closed]

asked 2014-11-17 15:41:35 +0200

alan-gmail gravatar image

updated 2020-08-16 01:38:05 +0200

Alex Kemp gravatar image

Hi Libre Office Version: Build ID: 420m0(Build:2) English Base


I am new to Linux and therefore Libre Base

I should be grateful if you could give me an answer to my question before I waste any more time..

I have been using Base to provide a database for my paintings via a simple form. I recorded 200 records and then added the facility to include a photograph .jpg file and this is when the gremlins started to appear.

It constantly issues error messages when adding data and causes me to endlessly loose work as it has failed to write to the table from a form for no obvious reason I can see, sometimes I can add a new data or several set/records on the form OK and then it will fail with the error message as follows where the Table1 is my Table

S1000 General error java.lang.NullPointerException in statement [update "Table1" SET "Photo"=? Where ID=?}

Is is a know issue that it is unstable ? In addition I set auto save and backup yet fail to find them anywhere.

Any help will be very appreciated and I am ok to provide my database for analysis if required by genuine helper

cheers alan

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-16 01:39:58.701904

2 Answers

Sort by » oldest newest most voted

answered 2015-02-21 18:07:39 +0200

Alex Thurgood gravatar image

Yes, it is a known issue that when the embedded database becomes large, e.g. when storing images as binary stream data, then it can become unstable and lead to data loss.

Autosave doesn't work properly, it currently produces 0 byte files.

edit flag offensive delete link more

answered 2015-02-22 23:52:34 +0200

nettings gravatar image

After suffering from severe data loss myself, I was told that the default embedded database is pretty much unusable (people from the dev community might want to comment on whether that is true, and if so, why users are still lured into using it). The recommended approach seems to be to use a so-called "split database". There is a nice explanation/howto and ready-to-use script at .

edit flag offensive delete link more


MySQL / MariaDB is a good backend too.

doug gravatar imagedoug ( 2015-02-23 03:04:50 +0200 )edit

@doug: Any drop-in replacement fork of MySQL is better than regular MySQL. We're using Percona Server (the only problem of Percona Server is it's Linux-only), but will migrate to MariaDB in near future.<newline>Funny, I've never had issues with LO's integrated db system, as little as I've used it.

rautamiekka gravatar imagerautamiekka ( 2015-02-23 03:08:17 +0200 )edit

@rautamiekka: MySQL still has the best documentation and JDBC connector, mix and match with MariaDB core. Occasionally wish I went with PostgreSQL instead. Need higher degree of reliability and interoperatibility than LO integrated HSQLDB, although the more I know about the native LO solution, the more ok it sounds.

doug gravatar imagedoug ( 2015-02-24 02:27:38 +0200 )edit

Question Tools

1 follower


Asked: 2014-11-17 15:41:35 +0200

Seen: 1,319 times

Last updated: Feb 22 '15