This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

How do I keep the graph table and data table in sync?

So I added some rows to the data table before I created the graph table that then showed up just fine. I then added some more rows to the data table and did a select * on the graph table and the new rows weren't there. I did a shortest route query and they showed up. A subsequent select * query to the graph table and they were there. What triggered them to appear? I then added a few more and no matter what I do they won't show up. The last one that won't show up was a two way link ( insert into oq_backing (origid,destid) values (9,10),(10,9) ). That's not a problem is it?

And lastly, is there any good documentation/literature around for how oqgraph works and how to use it?

Thanks, Preston

Answer

This seems to be a bug in OQGraph. See MDEV-5744.

As a workaround, you can disable query cache until this bug is fixed.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.