Launchpad has imported 14 comments from the remote bug at
https://bugs.documentfoundation.org/show_bug.cgi?id=143317.
If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.
On 2021-07-12T14:47:42+00:00 Allan Kelly wrote:
Created attachment 173510
Test table use to recreate bug
When using Base (via direct connector) to scroll through a mysql table,
or clicking last row, or add new row, Base crashes and starts recovery
dialog.
Ubuntu: 5.8.0-59-generic #66~20.04.1-Ubuntu
Libreoffice: Version: 6.4.7.2 Build ID: 1:6.4.7-0ubuntu0.20.04.1
Connector: libreoffice-mysql-connector/focal-updates,now
1:6.4.7-0ubuntu0.20.04.1 amd64 [installed]
mysql: Ver 8.0.25-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
Using a small test table, scrolling seems is OK up around 150 rows
scrolling further crashes.
My work around at the moment is to use jdbc conector
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1972820/comments/0
On 2021-07-12T18:36:38+00:00 julien2412 wrote:
Could you give a try to LO 7.1.4 from LO ppa (see
https://launchpad.net/~libreoffice/+archive/ubuntu/ppa)?
Indeed 6.X branch is EOL and there won't be any new LO version on 7.0
branch after the released 7.0.6 version.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1972820/comments/1
On 2021-07-13T10:21:44+00:00 Allan Kelly wrote:
I have upgraded using the PPA
LO is now
Version: 7.1.4.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 12; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Ubuntu package version: 1:7.1.4~rc2-0ubuntu0.20.04.1~lo1
Calc: threaded
libreoffice-mysql-connector/focal,now 1:7.1.4~rc2-0ubuntu0.20.04.1~lo1
amd64 [installed]
Problem still occurs. Second page forward browsing the test table
results in Base crashing and recovery dialog starts.
It has also introduced authentication issues for my jdbc connection so I
will will have to revert to previous version as this is not a testing
system.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1972820/comments/2
On 2021-07-13T16:13:48+00:00 Iplaw67-h wrote:
The test SQL dump has a collation "utf8mb4_0900_ai_ci" which
unfortunately fails to get imported into my version 5 server.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1972820/comments/3
On 2021-07-13T16:26:38+00:00 Iplaw67-h wrote:
Copied and pasted the SQL manually and removed the collation statement
via the mysql CLI.
No crash for me when scrolling through result set in Table browse mode
with
Version: 7.1.4.2 / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
I scrolled from the first record to the last record with no crash.
This sounds like a bug that is specific to the Ubuntu version, whether
it is GTK3 or some other handling error causing a crash.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1972820/comments/4
On 2021-07-14T14:57:34+00:00 Nv4y-robert wrote:
Couldn't confirm the buggy behavior.
Tested with the attached table, also with a table with 8000 rows and 12
columns and a table with 3 rows and 15 columns. Scrolled though the
table to the end and back to the start. Couldn't reproduce a crash with
direct connection - here to MariaDB - and LO 7.2.0.1 VCL:kf5 on OpenSUSE
15.2 64bit rpm Linux.
Think it is a special bug of Ubuntu version of LO and direct connection.
Please try the packages from LO directly. You could install these
packages parallel as a user-defined installation. If you need help for
this: Send me a private mail.
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1972820/comments/5
On 2021-07-14T17:34:08+00:00 Allan Kelly wrote:
The problem is occurring on a system I have just migrated from Ubuntu
18.04 with mysql 5 which connected fine, to Ubuntu 20.04 with mysql 8.
Mysql 8 seems less supported in 20.04. odbc and jdbc drivers are no
longer in Ubuntu repositories and needed to be obtained from mysql
community. Have any of these attempts to reproduce issue been against a
mysql 8 server?
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1972820/comments/6
