Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.2.37, 10.3.28, 10.4.18, 10.5.9
-
None
Description
I spent many many days and weeks with very very specific and random problem.
CREATE TABLE IF NOT EXISTS `datas` |
(
|
`id` varchar(32) NOT NULL, |
`access` int(10) unsigned DEFAULT NULL, |
`data` text NULL, |
PRIMARY KEY (`session_id`) |
) ROW_FORMAT = DYNAMIC |
ENGINE = InnoDB
|
DEFAULT CHARSET = utf8mb4 |
COLLATE = utf8mb4_unicode_ci; |
Put data like this:
INSERT INTO `datas` VALUES ('18041vivf9us088dluinh6ip02', 1619455120, 'd/lQRoGhOEIQn+bFpfZkfg==:Tzu6URdU5qSRh3ih4cfU6w=='); |
Then create PHP PDO connection and simple query like into test.php:
SELECT * FROM datas WHERE id="18041vivf9us088dluinh6ip02"; |
Create cron like this:
"* * * * * php74 /path_to_script/test.php" |
I believe that after some time you will see that php fetchAll() or fetch() will return empty result.
After I replaced DB to MySQL 5.7 than result will ALWAYS return requested row.
I think that some combination broken MariaDB stability, because my VPS server has enough memory, enough cpu capacity, enough disk space. Other services working well, no other problem and soo on. PHP is from Remi repository for example 7.4 version. MariaDB repo is original mariadb. I tested with all, but my main test was on 10.5.9 version. Tested on CentOS Linux release 7.9.2009 (Core). Core Linux 3.10.0-1160.21.1.el7.x86_64 (SMP).