Bug#1060056: mariadb-server: mariadb-hotcopy fails for performance_schema and sys

2024-01-17 Thread Otto Kekäläinen
Control: forwarded -1 https://github.com/MariaDB/server/pull/2995

This will be fixed in Debian next month when MariaDB 10.11.7 releases



Bug#1060056:

2024-01-16 Thread Daniel Black
merged - https://github.com/MariaDB/server/pull/2995



Bug#1060056: mariadb-server: mariadb-hotcopy fails for performance_schema and sys

2024-01-06 Thread Paul Szabo
> ... why use a simple tool, when a complex one is almost as good?

Time for mariadb-hotcopy: 0.13user  5.50system 0:06.08elapsed 92%CPU
Time for mariadb-backup:  0.92user 12.31system 0:28.54elapsed 46%CPU

It is common Linux practice to send info to STDOUT, error to STDERR.
mariadb-hotcopy gets this right, while mariadb-backup is extremely(!)
chatty on STDERR.

But then, these are not this bug...

Cheers, Paul
-- 
Paul Szabo   p...@maths.usyd.edu.au   www.maths.usyd.edu.au/u/psz
School of Mathematics and Statistics   University of SydneyAustralia



Bug#1060056: mariadb-server: mariadb-hotcopy fails for performance_schema and sys

2024-01-06 Thread Paul Szabo
You convinced me (I convinced myself?): I now use mariadb-backup instead,
as per the lines in my patch in MDEV-33187:

  Seems mariadb-hotcopy is deprecated
  so maybe we should be using mariabackup?

I guess this is progress: why use a simple tool, when a complex one is
almost as good?

Thanks, Paul
-- 
Paul Szabo   p...@maths.usyd.edu.au   www.maths.usyd.edu.au/u/psz
School of Mathematics and Statistics   University of SydneyAustralia

Join the Union and fight for a better University: www.nteu.au/join



Bug#1060056: mariadb-server: mariadb-hotcopy fails for performance_schema and sys

2024-01-05 Thread Paul Szabo
Dear Otto,

Thanks for your quick reply.

MDEV-33187 is "new".

MDEV-30259 is only year old, though the issue seems ten years old:
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=735014

Thanks, Paul
-- 
Paul Szabo   p...@maths.usyd.edu.au   www.maths.usyd.edu.au/u/psz
School of Mathematics and Statistics   University of SydneyAustralia



Bug#1060056: mariadb-server: mariadb-hotcopy fails for performance_schema and sys

2024-01-05 Thread Otto Kekäläinen
Hei Paul!

Thanks for taking the time to report these upstream along with patches!

I don't see the upstream MDEVs having a status 'fixed' nor any
confirmation/review about the patches yet. Let's wait a bit for a
feedback round.



Bug#1060056: mariadb-server: mariadb-hotcopy fails for performance_schema and sys

2024-01-05 Thread Paul Szabo
Package: mariadb-server
Version: 1:10.11.4-1~deb12u1
Severity: normal

mariadb-hotcopy produces errors. For details and patch please see
the upstream report
https://jira.mariadb.org/browse/MDEV-33187
(and probably also the older
https://jira.mariadb.org/browse/MDEV-30259
that really should have made it into bookworm).

Please include those patches in the next point release!

Thanks, Paul

Paul Szabo   p...@maths.usyd.edu.au   www.maths.usyd.edu.au/u/psz
School of Mathematics and Statistics   University of SydneyAustralia


-- System Information:
Debian Release: 12.4
  APT prefers stable-security
  APT policy: (500, 'stable-security'), (500, 'stable')
Architecture: i386 (x86_64)

Kernel: Linux 6.5+pk12.50 (SMP w/16 CPU threads; PREEMPT)
Kernel taint flags: TAINT_WARN
Locale: LANG=C.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-server depends on:
ii  adduser3.134
ii  debconf [debconf-2.0]  1.5.82
ii  galera-4   26.4.13-1
ii  gawk   1:5.2.1-2
ii  iproute2   6.1.0-3
ii  libc6  2.36-9+deb12u3
ii  libdbi-perl1.643-4
ii  libpam0g   1.5.2-6+deb12u1
ii  libssl33.0.11-1~deb12u2
ii  libstdc++6 12.2.0-14
ii  lsof   4.95.0-1
ii  mariadb-client 1:10.11.4-1~deb12u1
ii  mariadb-common 1:10.11.4-1~deb12u1
ii  mariadb-server-core1:10.11.4-1~deb12u1
ii  passwd 1:4.13+dfsg1-1+b1
ii  perl   5.36.0-7+deb12u1
ii  procps 2:4.0.2-3
ii  psmisc 23.6-1
ii  rsync  3.2.7-1
ii  socat  1.7.4.4-2
ii  zlib1g 1:1.2.13.dfsg-1

Versions of packages mariadb-server recommends:
ii  libhtml-template-perl   2.97-2
pn  mariadb-plugin-provider-bzip2   
pn  mariadb-plugin-provider-lz4 
pn  mariadb-plugin-provider-lzma
pn  mariadb-plugin-provider-lzo 
pn  mariadb-plugin-provider-snappy  
pn  pv  

Versions of packages mariadb-server suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20220412cvs-1
pn  mariadb-test   
pn  netcat-openbsd 

-- debconf information:
  mariadb-server/nis_warning:
  mariadb-server/old_data_directory_saved:
  mariadb-server/postrm_remove_databases: false