Issue Plesk Obsidian 18.0.61 Update 4 Causes DB Outage

[lightingman2003]

Server operating system version

Ubuntu 22.04.4 LTS

Plesk version and microupdate number

Plesk Obsidian 18.0.61 Update #4

Following the automatic update of Plesk 18.0.61 Update 4 (https://docs.plesk.com/release-notes/obsidian/change-log/?18061-mu4#plesk-18061-mu4) caused a DB Outage this morning at around 06:29 BST.

Was there anything in this update which would have caused this outage?

Included within the Update 4 change log was a fix for Maria DB Upgrade tool, but would this have impacted a currently running DB?

CC - @Alex Presland

 

[Kaspar@Plesk]

Was there anything in this update which would have caused this outage?

Any particular errors in the mariadb log and/or system logs?

Included within the Update 4 change log was a fix for Maria DB Upgrade tool, but would this have impacted a currently running DB?

The Update 4 should not affect running databases.

 

[Alex Presland]

MariaDB Log was turned off. I can only assume that this is default for the Plesk AWS template that we're using.

/var/log/plesk/install/plesk_18.0.61_installation.log completed at 06:28:36:

...[snip]...
STOP Bootstrapper 18.0.61 perform-deferred-actions AT Wed May 29 06:28:36 BST 2024
START update_history
Trying to start service mariadb... active
done
Trying to establish test connection... connected
done

**** [update_history] completed successfully.

STOP update_history

Syslog showed that "oom-kill" took it out!

May 29 06:29:00 hosting kernel: [1053914.855885] Out of memory: Killed process 1010 (mariadbd) total-vm:4902036kB, anon-rss:1727856kB, file-rss:16024kB, shmem-rss:0kB, UID:115 pgtables:5148kB oom_score_adj:0
May 29 06:29:00 hosting systemd[1]: mariadb.service: Failed with result 'oom-kill'.

...but there was LOADS of memory and swap available:



...so this is all a little confusing.

MariaDB version is currently 10.6.16, and we're currently looking into the right time to upgrade to 10.11 (which is now available).

Any ideas of what to investigate next would be appreciated...

 

[Alex Presland]

@Kaspar@Plesk Any thoughts on potential further investigation that @lightingman2003 and I can do on this please?

 

[Kaspar@Plesk]

I am not sure. Are there other unusual log entries prior to the Out of memory entry that (possibly) indicate other issues? Kernel panic?

Best advice I have is to meticulously go trough the logs and search online for any unusual log entry you find. Also don't hesitate to open a ticket with support to let our support experts have a look at it.

 

[felixja]

Hi there, not sure if related, but we are also having problems witg DBs after last update, in different machines. In our case, when entering for the first time into the "Databases" section inside a domain we get an error with this stack trace:

TypeError: Cannot read properties of undefined (reading 'display')
at Function.G [as getStyle] (https://xxxxx:8443/cp/javascript/externals/prototype.js?1716875267:1:39099)
at Function.getDimensions (https://xxxxx:8443/cp/javascript/externals/prototype.js?1716875267:1:55567)
at Function.getWidth (https://xxxxx:8443/cp/javascript/externals/prototype.js?1716875267:1:55434)
at https://xxxxx:8443/cp/javascript/main.js?1716875267:8:94009
at NodeList.forEach (<anonymous>)
at c._initToolbar (https://xxxxx:8443/cp/javascript/main.js?1716875267:8:93272)
at c._addEvents (https://xxxxx:8443/cp/javascript/main.js?1716875267:8:92984)
at c.render (https://xxxxx:8443/cp/javascript/main.js?1716875267:1:8478)
at c.render (https://xxxxx:8443/cp/javascript/main.js?1716875267:8:95520)
at c.render (https://xxxxx:8443/cp/javascript/views/smb/database/list.js?dc5bbf7aaa199a059d37:1:5311)
at render (https://xxxxx:8443/cp/javascript/main.js?1716875267:1:23117)
at https://xxxxx:8443/cp/javascript/views/smb/database/list.js?dc5bbf7aaa199a059d37:1:1297
at ro (https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:93078)
at wo (https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:100305)
at yo (https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:100161)
at xo (https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:99705)
at https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:111368
at _c (https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:111870)
at cc (https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:105682)
at Vs (https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:46632)
at rc (https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:102610)
at ti (https://xxxxx:8443/ui-library/plesk-ui-library.min.js?1716875267:35:68087)
at https://xxxxx:8443/cp/javascript/vendors.js?1716875267:25:5375
at https://xxxxx:8443/cp/javascript/vendors.js?1716875267:25:4478
at https://xxxxx:8443/cp/javascript/vendors.js?1716875267:25:5368
at https://xxxxx:8443/cp/javascript/vendors.js?1716875267:47:18305
at Array.forEach (<anonymous>)
at ee (https://xxxxx:8443/cp/javascript/vendors.js?1716875267:47:18293)
at te (https://xxxxx:8443/cp/javascript/vendors.js?1716875267:47:19548)
at re (https://xxxxx:8443/cp/javascript/vendors.js?1716875267:47:23655)
at async Object.t [as navigate] (https://xxxxx:8443/cp/javascript/vendors.js?1716875267:47:2976

After a couple of reloads, the page loads correctly, but when we try to enter to the phpmyadmin on any of the databases, it loads but shows the error "Token mismatch" with a bunch of errors in the js navigator console, and it's imposible to make any actions on the page.

At least, in the front isde, there not seems to be any problems as all the sites are opperative, but this way we can't manage the databases.

Thanks

 

[felixja]

Nevermind, seems more related to the host because is happening also in an older version server.