MariaDB problem after upgrading 10.1 to 10.3
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
Can anyone help me ? Thank you.
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.
-
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 0 -
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 :)) 0
Please sign in to leave a comment.
Comments
2 comments