MariaDB problem after upgrading 10.1 to 10.3

Bidi

Well-Known Member
Oct 3, 2012
81
1
8
Romania, Transilvania
cPanel Access Level
DataCenter Provider
Hello guys,

I upgrade MariaDB 10.1 to 10.3 and since i made this update i get " Error establishing a database connection " on some websites but lots of them.

on the tail -f /var/lib/mysql/....hostname.err i dont have any errors at all, only this ones

2019-09-11 9:35:19 3051 [Warning] Access denied for user 'root'@'45.55.*****' (using password: YES) lots of them

and i founded this on the error log but i dont understand why because i dont have the account on the server, i had it long time ago

Code:
2019-09-11  9:23:27 0 [Warning] InnoDB: Ignoring tablespace for `szonero_phpb917`.`phpbbgn_warnings` because it could not be opened.

2019-09-11  9:23:27 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.

2019-09-11  9:23:27 0 [ERROR] InnoDB: The error means the system cannot find the path specified.

2019-09-11  9:23:27 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.

2019-09-11  9:23:27 0 [ERROR] InnoDB: Cannot open datafile for read-only: './szonero_phpb917/phpbbgn_words.ibd' OS error: 71

2019-09-11  9:23:27 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.

2019-09-11  9:23:27 0 [ERROR] InnoDB: The error means the system cannot find the path specified.

2019-09-11  9:23:27 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.

2019-09-11  9:23:27 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``szonero_phpb917`.`phpbbgn_words``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.

Can anyone help me ?
Thank you.
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
7,090
559
263
Houston
cPanel Access Level
DataCenter Provider
Hello,

I'd suggest opening a ticket for this, if the tablespace issues began as a result of the upgrade.

If you had tablespace issues prior to upgrading to MariaDB you might want to look at the resource here: Tutorial - InnoDB Corruption Repair Guide
 

Bidi

Well-Known Member
Oct 3, 2012
81
1
8
Romania, Transilvania
cPanel Access Level
DataCenter Provider
I got another vps with cPanel running maria 10.1 the scripts and any ipb works fine, made fresh instalation to test, i upgrade mariadb to 10.3 got the same problem like in the dedicated server so is not because of the innodb coruption, dose anyone else got this problem and founded a fix or sompting ?!

Till now i founded this having the same problem like me.

"world rows in MariaDB 10.2 is reserved, so cant be used. It should be changed to 'rows' or anything
Find the following file admin\applications\core\modules_admin\mycp\dashboard.php


Change line 377 to

$online = $this->DB->buildAndFetch( array( 'select' => 'count(*) as fixme', 'from' => 'sessions', 'where' => "running_time > {$time}" ) );$online = $this->DB->buildAndFetch( array( 'select' => 'count(*) as fixme', 'from' => 'sessions', 'where' => "running_time > {$time}" ) );


Change line 379 to


$stats['active_users'] = $online['fixme'];$stats['active_users'] = $online['fixme'];

Of course you don't have to use the word "fixme". You can use any word so long as you don't use "rows"!. Thanks!
"

Reserved Words > ROWS


--

But the big think is how the hell i make this changes to 50+ websites :))
 
Last edited: