data return 0 rows in match

[wey-gu]

Please check the FAQ documentation before raising an issue

dot involved schema breaks appendVertecies (as row 0)

Describe the bug (required)

Your Environments (required)

• OS: Linux 5.15.0-1014 #17~20.04.1-Ubuntu SMP Thu Jun 23 20:01:51 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
• Compiler: g++ --version or clang++ --version
• CPU: lscpu
• Commit id ef6d6a0 3.1.0

How To Reproduce(required)

Steps to reproduce the behavior:
updated: minimal reproduce as follow

(root@nebula) [entity_resolution]> :play basketballplayer
Start loading dataset basketballplayer...

Load dataset succeeded!

Wed, 24 Aug 2022 10:18:40 UTC

(root@nebula) [basketballplayer]> match (v:player) return v limit 1
+------------------------------------------------------+
| v                                                    |
+------------------------------------------------------+
| ("player127" :player{age: 42, name: "Vince Carter"}) |
+------------------------------------------------------+
Got 1 rows (time spent 3548/4303 us)

Wed, 24 Aug 2022 10:18:55 UTC

(root@nebula) [basketballplayer]> CREATE TAG `foo.bar` ()
Execution succeeded (time spent 2401/3149 us)

Wed, 24 Aug 2022 10:19:02 UTC

(root@nebula) [basketballplayer]> match (v:player) return v limit 1
+---+
| v |
+---+
+---+
Empty set (time spent 3784/4309 us)

Wed, 24 Aug 2022 10:19:09 UTC

(root@nebula) [basketballplayer]> show hosts meta
+----------+------+----------+--------+--------------+---------+
| Host     | Port | Status   | Role   | Git Info Sha | Version |
+----------+------+----------+--------+--------------+---------+
| "metad1" | 9559 | "ONLINE" | "META" | "33fd35e"    | "3.1.0" |
| "metad0" | 9559 | "ONLINE" | "META" | "33fd35e"    | "3.1.0" |
| "metad2" | 9559 | "ONLINE" | "META" | "33fd35e"    | "3.1.0" |
+----------+------+----------+--------+--------------+---------+
Got 3 rows (time spent 892/1512 us)

Expected behavior

Data should be consistent to lookup/fetch for MATCH, but got 0 rows after AppendVertices
Additional context

[wey-gu]

reproduce, the long version, for kyle.cao

• deployment

# deploy nebulagraph with nebula-up (https://github.com/wey-gu/nebula-up/ ) all-in-one mode
curl -fsSL nebula-up.siwei.io/all-in-one.sh | bash

# you could use this instead, as it won't install everything
curl -fsSL nebula-up.siwei.io/all-in-one.sh | bash -s -- v3 dashboard

• load data

~/.nebula-up/console.sh

DDL ( I did the equivalent DDL write with studio for the first time)

CREATE SPACE entity_resolution (vid_type=FIXED_STRING(30));

CREATE TAG `user` (`name` string NOT NULL, `email` string NOT NULL, `phone_num` string NOT NULL, `birthday` date NOT NULL, `address` string NOT NULL)

CREATE TAG `address` ()
CREATE TAG `device` ()
CREATE TAG `email` ()
CREATE TAG `ip` ()
CREATE TAG `phone` ()

CREATE EDGE `used_device` (`time` datetime NOT NULL)
CREATE EDGE `logged_in_from` (`time` datetime NOT NULL)
CREATE EDGE `has_phone` ()
CREATE EDGE `has_address` ()
CREATE EDGE `has_email` ()

DML

INSERT VERTEX `user` (`email`, `name`, `birthday`, `address`, `phone_num`) VALUES
    "user_1":("[email protected]","Miranda Miller",date("1957-08-27"),"Brittany Forge Apt. 718 East Eric  WV 97881","+1-652-450-5443x00562"),
    "user_2":("[email protected]","Holly Pollard",date("1990-10-19"),"1 Amanda Freeway Lisaland  NJ 94933","600-192-2985x041"),
    "user_3":("[email protected]","Julia Hall",date("1927-08-24"),"Rodriguez Track East Connorfort  NC 63144","1248361783"),
    "user_4":("[email protected]","Franklin Barnett",date("2020-03-01"),"Richard Curve Kingstad  AZ 05660","(224)497-9312"),
    "user_5":("[email protected]","April Kelly",date("1967-12-01"),"Schmidt Key Lake Charles  AL 36174","410.138.1816x98702"),
    "user_6":("[email protected]","Steven Webb",date("1955-04-24"),"5 Joanna Key Suite 704 Frankshire  OK 03035","3666519376"),
    "user_7":("[email protected]","Jessica Torres",date("1958-09-03"),"1 Payne Circle Mitchellfort  LA 73053","535-357-3112x4903"),
    "user_8":("[email protected]","Brett Glenn",date("1992-09-03"),"Weber Unions Eddieland  MT 64619","660.391.3730"),
    "user_9":("[email protected]","Veronica Jordan",date("1947-06-08"),"2 Klein Mission New Annetteton  HI 05775","810-252-6218"),
    "user_10":("[email protected]","Steven Brooks",date("1954-06-14"),"1 Vanessa Stravenue Suite 184 Baileyville  NY 46381","+1-665-328-8103x3448"),
    "user_11":("[email protected]","Reginald Mccullough",date("1915-04-12"),"John Garden Port John  LA 54602","030.088.4523x94511"),
    "user_12":("[email protected]","Jennifer Foster",date("1988-04-30"),"11 Webb Groves Tiffanyside  MN 14566","(489)306-8558x98227"),
    "user_13":("[email protected]","Philip Garcia",date("1955-12-01"),"70 Robinson Locks Suite 113 East Veronica  ND 87845","490-088-7610x9437"),
    "user_14":("[email protected]","Ann Williams",date("1947-05-28"),"24 Mcknight Port Apt. 028 Sarahborough  MD 38195","868.057.4056x4814"),
    "user_15":("[email protected]","Jessica Stewart",date("1951-11-28"),"0337 Mason Corner Apt. 900 Toddmouth  FL 61464","(335)408-3835x883"),
    "user_16":("[email protected]","Sandra Dougherty",date("1908-06-03"),"7 Davis Station Apt. 691 Pittmanfort  HI 29746","+1-189-827-0744x27614"),
    "user_17":("[email protected]","Sharon Mccoy",date("1958-09-01"),"1 Southport Street Apt. 098 Westport  KY 85907","(814)898-9079x898"),
    "user_18":("[email protected]","Kathryn Miller",date("1958-09-01"),"1 Southport Street Apt. 098 Westport  KY 85907","(814)898-9079x898"),
    "user_19":("[email protected]","Bretty Glenn",date("1991-09-03"),"Weber Unions Eddieland  MT 64619","660-391-3730"),
    "user_20":("[email protected]","Julia H.",date("1927-08-24"),"Rodriguez Track East Connorfort NC 63144","1248361783"),
    "user_21":("[email protected]","Holly",date("0000-10-19"),"1 Amanda Freeway Lisaland  NJ 94933","(600)-192-2985"),
    "user_22":("[email protected]","Veronica Jordan",date("0000-06-08"),"HI 05775","(810)-252-6218"),
    "user_23":("[email protected]","Kelly April",date("2010-01-01"),"Schmidt Key Lake Charles AL 13617","410-138-1816");

INSERT VERTEX `email` () VALUES
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":(),
    "[email protected]":();

INSERT EDGE `has_email` () VALUES
    "user_1"->"[email protected]":(),
    "user_2"->"[email protected]":(),
    "user_3"->"[email protected]":(),
    "user_4"->"[email protected]":(),
    "user_5"->"[email protected]":(),
    "user_6"->"[email protected]":(),
    "user_7"->"[email protected]":(),
    "user_8"->"[email protected]":(),
    "user_9"->"[email protected]":(),
    "user_10"->"[email protected]":(),
    "user_11"->"[email protected]":(),
    "user_12"->"[email protected]":(),
    "user_13"->"[email protected]":(),
    "user_14"->"[email protected]":(),
    "user_15"->"[email protected]":(),
    "user_16"->"[email protected]":(),
    "user_17"->"[email protected]":(),
    "user_18"->"[email protected]":(),
    "user_19"->"[email protected]":(),
    "user_20"->"[email protected]":(),
    "user_21"->"[email protected]":(),
    "user_22"->"[email protected]":(),
    "user_23"->"[email protected]":();

• Then I made queries to see match got 0 rows, and tried created index and lookup to get data properly.

• Then I update the docker-compose yaml file manually to v3.2.0

cd ~/.nebula-up/nebula-docker-compose

# change v3.1.0 to v3.2.0 for core images

docker-compose up -d

• Things are not changed after upgraded to 3.2.0, same as retry of insert.

[wey-gu]

update:

• it's confirmed it's related the state of the cluster space itself, as I cannot reproduce after creating another cluster
• I cannot reproduce when creating a new space
• but i can reproduce when create a new space AS old space(cloning the schema)

[wey-gu]

the minimal direct cause was narrowed down to this dot involved line of ddl in v3.1.0, which is now dis-allowed in master/v3.2.0

CREATE TAG `foo.bar` ()

updated above reproduce procedure

[Sophie-Xie]

the minimal direct cause was narrowed down to this dot involved line of ddl in v3.1.0, which is now dis-allowed in master/v3.2.0

CREATE TAG `foo.bar` ()

updated above reproduce procedure

Can we close it？

[wey-gu]

the minimal direct cause was narrowed down to this dot involved line of ddl in v3.1.0, which is now dis-allowed in master/v3.2.0

CREATE TAG `foo.bar` ()

updated above reproduce procedure

Can we close it？

It's not fixed now, this will cause the issue in v3.1.0, but the fix should be cherry-picked to 3.1.0 to be more meaningful.