[Maria-developers] Updating OQGRAPH tables
![](https://secure.gravatar.com/avatar/a2be5e3cc035a1320b5870360a7338f7.jpg?s=120&d=mm&r=g)
Hi I have been struggling to get OQGRAPH working with MariaDB 10.0.7. The system has been hanging and crashing frequently. I will post as bugs if I can recreate them, but this question is simply, how can I update the data? On a new install of MariaDB 10.0.7 and OQGRAPH - I create the sample tables at https://mariadb.com/kb/en/oqgraph-examples/#creating-a-table-with-weight - I then update the oq2_backing table. The changes reflect on the oq2_backing table, not the oq2_graph table: UPDATE oq2_backing SET weight=4 WHERE origid=2 AND destid=6; SELECT * FROM oq2_backing; +--------+--------+--------+ | origid | destid | weight | +--------+--------+--------+ | 1 | 2 | 1 | | 2 | 3 | 1 | | 2 | 6 | 4 | | 3 | 4 | 3 | | 4 | 5 | 1 | | 5 | 6 | 2 | +--------+--------+--------+ SELECT * FROM oq2_graph; +-------+--------+--------+--------+------+--------+ | latch | origid | destid | weight | seq | linkid | +-------+--------+--------+--------+------+--------+ | NULL | 1 | 2 | 1 | NULL | NULL | | NULL | 2 | 3 | 1 | NULL | NULL | | NULL | 2 | 6 | 10 | NULL | NULL | | NULL | 3 | 4 | 3 | NULL | NULL | | NULL | 4 | 5 | 1 | NULL | NULL | | NULL | 5 | 6 | 2 | NULL | NULL | +-------+--------+--------+--------+------+--------+ How can I make changes that reflect on the table? thanks, ian
![](https://secure.gravatar.com/avatar/2d5441015d430e38ac620bc4a06298cb.jpg?s=120&d=mm&r=g)
Hello Ian I just tried to repeat what you found and I got the expected value for weight (weight=4) in my output. However I think it quite probable there is a bug that manifests under the right conditions, so I need you to provide some configuration information: * your system (32-bit, 64-bit, number of CPU cores, which operating system distribution, and kernel version) * either your compiler version, or did you install from a binary package, if so which version, where from? * contents of /etc/my.cnf or any other mysql config files TBH I am not sure what else to ask for, perhaps the output from SHOW GLOBAL VARIABLES so I can compare it to my own build, but that is quite a large volume of information, so feel free to pastebin it or something or create a bug against https://bugs.launchpad.net/oqgraph and attach it there thanks, Andrew
![](https://secure.gravatar.com/avatar/2d5441015d430e38ac620bc4a06298cb.jpg?s=120&d=mm&r=g)
Hi Ian, as an aside, the use of numeric latches is deprecated, we retained it to assist users migrating from OQGraph v2, because the intention is to implement additional graph algorithms over time. Great job with the examples in the wiki, its something I always wanted to see but never have the time to do! Regardless, your query should still have worked as you expected... thanks, --Andrew On 08/02/14 23:37, Andrew McDonnell wrote:
Hello Ian
I just tried to repeat what you found and I got the expected value for weight (weight=4) in my output.
However I think it quite probable there is a bug that manifests under the right conditions, so I need you to provide some configuration information:
* your system (32-bit, 64-bit, number of CPU cores, which operating system distribution, and kernel version)
* either your compiler version, or did you install from a binary package, if so which version, where from?
* contents of /etc/my.cnf or any other mysql config files
TBH I am not sure what else to ask for, perhaps the output from
SHOW GLOBAL VARIABLES
so I can compare it to my own build, but that is quite a large volume of information, so feel free to pastebin it or something or create a bug against https://bugs.launchpad.net/oqgraph and attach it there
thanks, Andrew
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
participants (2)
-
Andrew McDonnell
-
Ian Gilfillan