[MDEV-18101] Updating MariaDB Created: 2018-12-28  Updated: 2019-01-27  Resolved: 2019-01-27

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Update, Platform Windows
Affects Version/s: 10.3.10, 10.3.11, 10.3.12, 10.2
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: VH Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: crash, need_feedback
Environment:

Windows 10 Pro X64, desktop, SSD, Ivy chip


Attachments: PNG File image-2018-12-29-00-27-54-156.png     PNG File image-2018-12-29-00-29-36-126.png     PNG File image-2018-12-29-00-32-21-796.png    

 Description   

Updating MariaDB brakes (wrecks a havoc) of digiKam access to MYSQL. Full clean installarion of MariaDB needed yet DB is gone - happened many times this fall - lost DB few times :/ :/ :/


https://mariadb.com/kb/en/library/upgrading-mariadb-on-windows/#upgrade-wizard

No remedy other than start from 0 with DB!!

How? Why?
1. Wanted to update/reinstall MariaDB as I wanted to change MYSQL as a service to common process.
2. MYSQL as process (not service) seems to be much more stable:

  • it quits when DB usage stops
  • does not auto-start with SYS
  • mysql.exe as process starts and stops with DB apps (such as digiKam)
  • mysql.exe RAM consumption very LOW when process
  • mysql.exe RAM consumption very HIGH when service

Upgrade needs to work without loosing DB!



 Comments   
Comment by Elena Stepanova [ 2018-12-29 ]

I'm sorry that something doesn't work for you, and that it makes you very upset, but could you please describe the problem in a comprehensible and comprehensive manner? We can't do anything productive with "nothing works, everything fails!"

Things like a screenshot of an error saying that you have insufficient privileges gives us absolutely nothing, all we can tell you is "configure the privileges then".

Please specify what kind of installation you had (version, configuration), which version you were upgrading to, which exact steps you performed to upgrade, what was the immediate result of the upgrade, what you did next, what exactly you got as a result.

Please do it in a form of copy-pasting command lines and stdout/stderr (if you did it via the command line) and attaching server/system/upgrade logs rather than describing it in words in pictures.

Please also note that we don't have information about how exactly an arbitrary third-party application works with the database. You can of course wait till we get to installing it and/or inspecting the code to find out, but we have limited resources and it can take months until we get to it. You can considerably speed up the process if you perform the basic initial problem investigation on your side – enable the database server general log, see which queries come in, check how they correlate with the contents of your database, etc.

Generated at Thu Feb 08 08:41:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.