Mysql/MariaDB, quirky restart after failure

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Mysql/MariaDB, quirky restart after failure

Postby entwisi » 21. January 2019 17:07

hi

Have a quirky problem, occasionally after a server reboot(mandated monthly restart of the VM ) or once when we had a full disk issue the mysqld process starts but on port+1 i.e. 3307 instead of 3306. I've checked using netstat and lsof and nothing else appears to be holding 3306 so why is it falling back one port? I can't see anything in config that would suggest why this would happen?

I've got round for now that after restart I have a script that pulls the port # from the process and then updates my sites php config automatically but its a fudge and I'd rather work out why.

Thanks in advance!
entwisi
 
Posts: 4
Joined: 21. January 2019 16:43
XAMPP version: 7.3
Operating System: Linux

Re: Mysql/MariaDB, quirky restart after failure

Postby Altrea » 21. January 2019 19:38

There is no automatical falling back port.
Either the port is changed in the configs or it does not take effect.
So the most likely scenario is that someone changed the mariadb config to port 3307 at runtime but that does not take effect because mariadb was not restarted after that.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 9768
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Mysql/MariaDB, quirky restart after failure

Postby entwisi » 21. January 2019 21:03

We checked my.cnf and it still said 3306. I even searched all files under the install for the text 3307 without joy.

As I said, really quirky, even a stop start of the DB wouldn't fix it it needs a full server reboot at which point it flips back to 3306.
entwisi
 
Posts: 4
Joined: 21. January 2019 16:43
XAMPP version: 7.3
Operating System: Linux

Re: Mysql/MariaDB, quirky restart after failure

Postby Altrea » 21. January 2019 21:15

As I said, Mariadb does not roll dice for choosing listening ports.
There is no failover functionality. If the configured port is blocked Mariadb will simply not start.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 9768
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Mysql/MariaDB, quirky restart after failure

Postby entwisi » 21. January 2019 22:37

I can only what I see, I guess I should file a bug report next time it happens,

Any suggested debug settings beyond trying to start with trace?
entwisi
 
Posts: 4
Joined: 21. January 2019 16:43
XAMPP version: 7.3
Operating System: Linux


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 12 guests