[MDEV-3699] LP:681761 - OQGraph table contents are lost on restart Created: 2010-11-26  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Vsevolod Velichko (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug681761.xml    

 Description   

During the mysqld restart all OQGraph contents are lost. When I insert something into table, everything is OK and I can use all the OQGraph features, but only until mysqld restart. Then I have to re-insert all the data.
Tested on Debian Squeeze (5.2.3-MariaDB-mariadb90-log) and Ubuntu Maverick (5.2.3-MariaDB-mariadb87-log).

MariaDB [DBName]> select count from ReactionGraph \G

                                                      • 1. row ***************************
                                                        count: 0
                                                        1 row in set (0.00 sec)

MariaDB [DBName]> show create table ReactionGraph \G

                                                      • 1. row ***************************
                                                               Table: ReactionGraph
                                                        Create Table: CREATE TABLE `ReactionGraph` (
                                                          `latch` smallint(5) unsigned DEFAULT NULL,
                                                          `origid` bigint(20) unsigned DEFAULT NULL,
                                                          `destid` bigint(20) unsigned DEFAULT NULL,
                                                          `weight` double DEFAULT NULL,
                                                          `seq` bigint(20) unsigned DEFAULT NULL,
                                                          `linkid` bigint(20) unsigned DEFAULT NULL,
                                                          KEY `latch` (`latch`,`origid`,`destid`) USING HASH,
                                                          KEY `latch_2` (`latch`,`destid`,`origid`) USING HASH
                                                        ) ENGINE=OQGRAPH DEFAULT CHARSET=utf8
                                                        1 row in set (0.00 sec)

MariaDB [DBName]> insert into ReactionGraph (origid,destid,weight) (select ... ) \G
Query OK, 16545 rows affected (1.13 sec)
Records: 16545 Duplicates: 0 Warnings: 0

MariaDB [DBName]> exit
Bye
torkvemada@host ~ $ sudo service mysql restart
Stopping MariaDB database server: mysqld.
Starting MariaDB database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
torkvemada@host ~ $ mysql -uroot DBName
MariaDB [DBName]> select count from ReactionGraph \G

                                                      • 1. row ***************************
                                                        count: 0
                                                        1 row in set (0.00 sec)


 Comments   
Comment by Kristian Nielsen [ 2010-11-26 ]

Re: OQGraph table contents are lost on restart
Unfortunately, this is how OQGraph is designed. From http://openquery.com/graph/doc:

"The base Mk.II implementation acts similar to the MEMORY engine, it [...] has no persistence."

Comment by Rasmus Johansson (Inactive) [ 2010-11-26 ]

Launchpad bug id: 681761

Generated at Thu Feb 08 06:50:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.