[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=53473

--- Comment #18 from QA Administrators  ---
Dear Lionel Elie Mamane,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=53473

Xisco Faulí  changed:

   What|Removed |Added

   Priority|highest |medium
 CC||xiscofa...@libreoffice.org

--- Comment #17 from Xisco Faulí  ---
Lowering importance: Highest + Inherit from OOo doesn't make much sense at this
point anymore...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=53473

--- Comment #16 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.4.1 or 5.3.6  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170901

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=53473

--- Comment #15 from Christian Lohmaier  ---
The content of attachment 125560 has been deleted for the following reason:

spam

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=53473

--- Comment #14 from Mediot Listo  ---
Created attachment 125560
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125560=edit
scr

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=53473

tommy27  changed:

   What|Removed |Added

 Blocks|75025   |

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=53473

Robinson Tryon (qubit)  changed:

   What|Removed |Added

 CC||qu...@runcibility.com
Version|unspecified |4.2.4.2 release

--- Comment #13 from Robinson Tryon (qubit)  ---
(In reply to Lionel Elie Mamane from comment #8)
> (In reply to comment #7)
> > please retest against current 4.2.4.2 release.
> > if issue is still there, please move it to mab4.2 list since 4.1.x is EOL
> 
> As developer, I'm fairly sure the issue is still there.

All bugs with priority=highest should have a Version set. I'll add 4.2.4.2, but
it sounds like this bug goes back much further.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=53473

Lionel Elie Mamane  changed:

   What|Removed |Added

Version|4.2.4.2 release |Inherited From OOo

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

--- Comment #12 from Alex Thurgood ipla...@yahoo.co.uk ---
Adding self to CC if not already on

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

--- Comment #10 from tommy27 ba...@quipo.it ---
please retest with 4.3.x or 4.4.x branches
if issue is still there please move it to the mab4.3 list since 4.2.x is EOL

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

Lionel Elie Mamane lio...@mamane.lu changed:

   What|Removed |Added

 Blocks|65675   |75025

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

--- Comment #11 from Lionel Elie Mamane lio...@mamane.lu ---
(In reply to tommy27 from comment #10)
 please retest with 4.3.x or 4.4.x branches
 if issue is still there please move it to the mab4.3 list since 4.2.x is EOL

As developer, I'm fairly sure the issue is still there.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

   Priority|medium  |highest

--- Comment #9 from Björn Michaelsen bjoern.michael...@canonical.com ---
MABs should be priority highest.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

--- Comment #7 from tommy27 ba...@quipo.it ---
please retest against current 4.2.4.2 release.
if issue is still there, please move it to mab4.2 list since 4.1.x is EOL

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

Lionel Elie Mamane lio...@mamane.lu changed:

   What|Removed |Added

 Blocks|60270   |65675

--- Comment #8 from Lionel Elie Mamane lio...@mamane.lu ---
(In reply to comment #7)
 please retest against current 4.2.4.2 release.
 if issue is still there, please move it to mab4.2 list since 4.1.x is EOL

As developer, I'm fairly sure the issue is still there.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

Michael Meeks michael.me...@collabora.com changed:

   What|Removed |Added

 Blocks|52170   |60270

--- Comment #6 from Michael Meeks michael.me...@collabora.com ---
migrate to new mab

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

tommy27 ba...@quipo.it changed:

   What|Removed |Added

 CC||ba...@quipo.it

--- Comment #5 from tommy27 ba...@quipo.it ---
hi there. is this bug still present in recent 4.0.5 or 4.1.1 releases?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

--- Comment #4 from Fred Toussi fr...@users.sourceforge.net ---
I have spent some more time on the pattern of checkpoints. Also read the
original OOo bug report.

The purpose of the CHECKPOINT is valid for the current implementation of the
internal zip stream in order to save all data as soon as a chenge is made.
However, it should be possible to improve it and avoid excessive checkpoints
when no data has changed.

Also note that at the time of the bug report version 1.8.0.1 was used, which
has advanced to version 1.8.0.10. This probably has different sync and related
characteristics.

It seems at the moment two tricks are used in tandem as a consequence of the
OOo bug report.

When a table is opened directly by double clicking, SET WRITE_DELAY 0 and SET
WRITE_DELAY 60 are executed, even when no change is made to the data.

It also seems any read causes the checkpoint. It seems if a checkpoint does not
happen, the stream that reads from the .zip is not reset after a read and will
throw an exception.

It should be possible to fix the issue without too many alterations.

1. Ensure the read stream is reset after reads. For this, check the code and
see what is done with readonly databases and use the same method for all
databases.
2. Set the WRITE_DELAY=0 as a permanent setting
3. Whenever a FileDescriptor.sync() is issued on the write stream used for the
.log file, check if the stream length has gone up by a lot more than the length
of a COMMIT string and perform the checkpoint only in this case. A change
contains at least DELETE FROM tablename WHERE x=n (at least 20 characters).
The WIRTE_DELAY=0 ensures the sync is called only at a commit and not at other
times.

As mentioned on bug 5 you can use a custom version 2.2.9 or 2.3.0 jar with
logging enabled in order to see which commands are sent to the database.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

Jochen d...@jochenschiffers.de changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||d...@jochenschiffers.de,
   ||LibreOffice@bielefeldundbus
   ||s.de,
   ||rob...@familiegrosskopf.de
 Ever Confirmed|0   |1

--- Comment #3 from Jochen d...@jochenschiffers.de 2012-08-30 07:05:04 UTC ---
Changed status to NEW

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

Jochen d...@jochenschiffers.de changed:

   What|Removed |Added

   See Also||https://bugs.freedesktop.or
   ||g/show_bug.cgi?id=51338

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

Lionel Elie Mamane lio...@mamane.lu changed:

   What|Removed |Added

 Blocks||52170

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

--- Comment #2 from Fred Toussi fr...@users.sourceforge.net 2012-08-14 
23:16:54 UTC ---
Re hsqldb.applog: yes, this turns on the event log. In version 1.8.0, you can
include this in the .properties file of a database embedded in .odb if you want
to try it.

Re the need for flush() and CHECKPOINT in the OO 3.4 code, (I am referring here
to the logical files which are zipped by OO):

Among the database files, the .log file is implemented as an OutputStream.
HSQLDB writes to this stream, and at regular timed intervals calls the
FileDescriptor#sync() method.

An instance of FileAccess is provided by OO. The FileDescriptor is provided by
this instance.

It is not necessary to write the changes to the zip at each commit. It can be
delayed until the FileDescriptor#sync() is called. The delay can be a few 
seconds.

Note HSQLDB 1.8.0 and 2.x write the changes and commits to the .log file
somewhat differently, which may explain the frequent flush() and CHECKPOINT I
observed in my tests.

It would be worth comparing the code to the CWS, as this was written against
versions 2.0 and 2.1.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 53473] Embedded HSQLDB calls flush (CHECKPOINT) too often

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=53473

--- Comment #1 from Lionel Elie Mamane lio...@mamane.lu 2012-08-14 03:46:17 
UTC ---
Fred, when you wrote:

 [2] A less advanced form of EVENT LOG is supported by HSQLDB 1.8.0 and set via
 a URL property (no SQL statement is available).

you were referring to hsqldb.applog, right?

Note to self  other LibreOffice developers: see
http://www.hsqldb.org/doc/1.8/guide/ch04.html

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs