Hi,
When add more than one Remote DataSet the tasks execute but never ends. The status of the task in the task table is always 1.
MariaDB [xibo]> select name, status from task where taskId = 6;
+-----------------------+--------+
| name | status |
+-----------------------+--------+
| Fetch Remote DataSets | 1 |
+-----------------------+--------+
It seems that one transaction is locked.
MariaDB [xibo]> SHOW FULL PROCESSLIST;
+------+------+------+---------+------+---------------------------------+----------------------------+----------+
| Id | User | db | Command | Time | State | Info | Progress |
+------+------+------+---------+------+---------------------------------+----------------------------+----------+
| 4000 | xibo | xibo | Sleep | 723 | | NULL | 0.000 |
| 4001 | xibo | xibo | Sleep | 723 | | NULL | 0.000 |
| 4002 | xibo | xibo | Sleep | 723 | | NULL | 0.000 |
| 4003 | xibo | xibo | Query | 723 | Waiting for table metadata lock | TRUNCATE TABLE `dataset_9` | 0.000 |
+------+------+------+---------+------+---------------------------------+----------------------------+----------+
If I kill the first and the second ones the task ends.
I’ve tried the next solution, that works, but I’m not sure about the fact of removing isolated call.
- Add the line $this->store->commitIfNecessary(); at file lib/XTR/RemoteDataSetFetchTask.php
- Change $this->getStore()->isolated by $this->getStore()->update at lib/Entity/DataSet.php.
Thanks,
Oriol.