Well, it is kind of incompatibility introduced by MariaDB. Have you ever seen SHOW PROCESSLIST returning NULL in TIME column? MariaDB does so.
MariaDB [(none)]> show processlist; +----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ | 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 | | 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 | | 19 | root | localhost | NULL | Sleep | 156 | | NULL | 0.000 | | 20 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 | +----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+ 7 rows in set (0.00 sec)
It is trivial to fix. But I wonder who would use these options having that MariaDB has support for backup locks?
Well, it is kind of incompatibility introduced by MariaDB. Have you ever seen SHOW PROCESSLIST returning NULL in TIME column? MariaDB does so.
MariaDB [(none)]> show processlist; ------- -----+- ------- ---+--- ---+--- ------+ ------+ ------- ------- ------- -----+- ------- ------- ---+--- ------- + ------- -----+- ------- ---+--- ---+--- ------+ ------+ ------- ------- ------- -----+- ------- ------- ---+--- ------- + ------- -----+- ------- ---+--- ---+--- ------+ ------+ ------- ------- ------- -----+- ------- ------- ---+--- ------- +
+----+-
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+-
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 19 | root | localhost | NULL | Sleep | 156 | | NULL | 0.000 |
| 20 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
+----+-
7 rows in set (0.00 sec)
It is trivial to fix. But I wonder who would use these options having that MariaDB has support for backup locks?