How do I delete all of type plus associated types?

BenW · October 3, 2022, 9:45pm

If I have the following schema:

type ParentObject {
  id: ID!
  childObjects: [ChildObject!] @hasInverse(field: parent)
}

type ChildObject {
  id: ID!
  parent: ParentObject! @hasInverse(field: childObjects)
}

What would be the most efficient way to delete all ParentObjects with their associated .childObjects?

BenW · October 3, 2022, 9:49pm

Looks like the answer is to use this:

MichelDiz · October 3, 2022, 10:39pm

In DQL or GraphQL?

Your schema, is it a fixed parenting? e.g. ParentObject will never be a child of ChildObject.
ParentObject will always be the beginning of your modeling? It will have a nested infinite relation? or limited to two objects?

BenW · October 3, 2022, 10:51pm

Fixed parenting. I actually have a tree of objects:

A:
– B:
-----C
– B:
A:
– B:

query doesn’t need to be GraphQL, just need a way to delete the tree of objects.

EDIT: looks like I need to use an upsert like this: How to bulk delete nodes or cascade delete nodes? - #2 by MichelDiz

How to bulk delete nodes or cascade delete nodes?

upsert {
  query {
    V as var(func: type(Group)) @filter(eq(name, "MyGroup")){
      M as members
      P as posts
    }
  }

  mutation {
    delete {
      uid(V) * * .
      uid(M) * * .
      uid(P) * * .
    }
  }
}

EDIT: seemed to work:

MichelDiz · October 3, 2022, 11:20pm

These txn logs feels pretty ugly. We should fix this.
This happens because it’s shared, right?
Can you open an issue for this? please.

BenW · October 3, 2022, 11:22pm

This is using Ratel to perform an upsert on 21.03 standalone image running in local Docker.

You’re talking about the \u0000 stuff?

MichelDiz · October 3, 2022, 11:24pm

Yes. Do you have ACL? multitenancy I mean tho.

BenW · October 3, 2022, 11:29pm

I don’t think so, I’m just running the image with no flags in the Docker desktop app:

Warning: This standalone version is meant for quickstart purposes only.

         It is NOT RECOMMENDED for production environments.

2022/10/03 23:26:04 Listening on :8000...

[Sentry] 2022/10/03 23:26:05 Integration installed: ContextifyFrames

[Sentry] 2022/10/03 23:26:05 Integration installed: Environment

[Sentry] 2022/10/03 23:26:05 Integration installed: Modules

[Sentry] 2022/10/03 23:26:05 Integration installed: IgnoreErrors

[Sentry] 2022/10/03 23:26:05 Integration installed: ContextifyFrames

[Sentry] 2022/10/03 23:26:05 Integration installed: Environment

[Sentry] 2022/10/03 23:26:05 Integration installed: Modules

[Sentry] 2022/10/03 23:26:05 Integration installed: IgnoreErrors

[Sentry] 2022/10/03 23:26:07 Integration installed: ContextifyFrames

[Sentry] 2022/10/03 23:26:07 Integration installed: Environment

[Sentry] 2022/10/03 23:26:07 Integration installed: Modules

[Sentry] 2022/10/03 23:26:07 Integration installed: IgnoreErrors

[Sentry] 2022/10/03 23:26:07 Integration installed: ContextifyFrames

[Sentry] 2022/10/03 23:26:07 Integration installed: Environment

[Sentry] 2022/10/03 23:26:07 Integration installed: Modules

[Sentry] 2022/10/03 23:26:07 Integration installed: IgnoreErrors

I1003 23:26:07.319859      25 sentry_integration.go:48] This instance of Dgraph will send anonymous reports of panics back to Dgraph Labs via Sentry. No confidential information is sent. These reports help improve Dgraph. To opt-out, restart your instance with the --telemetry "sentry=false;" flag. For more info, see https://dgraph.io/docs/howto/#data-handling.

I1003 23:26:07.454793      35 sentry_integration.go:48] This instance of Dgraph will send anonymous reports of panics back to Dgraph Labs via Sentry. No confidential information is sent. These reports help improve Dgraph. To opt-out, restart your instance with the --telemetry "sentry=false;" flag. For more info, see https://dgraph.io/docs/howto/#data-handling.

I1003 23:26:07.691338      25 init.go:110] 


Dgraph version   : v21.03.0

Dgraph codename  : rocket

Dgraph SHA-256   : b4e4c77011e2938e9da197395dbce91d0c6ebb83d383b190f5b70201836a773f

Commit SHA-1     : a77bbe8ae

Commit timestamp : 2021-04-07 21:36:38 +0530

Branch           : HEAD

Go version       : go1.16.2

jemalloc enabled : true


For Dgraph official documentation, visit https://dgraph.io/docs.

For discussions about Dgraph     , visit http://discuss.dgraph.io.

For fully-managed Dgraph Cloud   , visit https://dgraph.io/cloud.


Licensed variously under the Apache Public License 2.0 and Dgraph Community License.

Copyright 2015-2021 Dgraph Labs, Inc.



I1003 23:26:07.693716      25 run.go:756] x.Config: {PortOffset:0 Limit:query-timeout=0ms; txn-abort-after=5m; max-retries=-1; max-pending-queries=10000; query-edge=1000000; mutations-nquad=1000000; disallow-drop=false; mutations=allow; normalize-node=10000 LimitMutationsNquad:1000000 LimitQueryEdge:1000000 BlockClusterWideDrop:false LimitNormalizeNode:10000 QueryTimeout:0s MaxRetries:-1 GraphQL:lambda-url=; introspection=true; debug=false; extensions=true; poll-interval=1s GraphQLDebug:false}

I1003 23:26:07.694469      25 run.go:757] x.WorkerConfig: {TmpDir:t ExportPath:export Trace:ratio=0.01; jaeger=; datadog= MyAddr: ZeroAddr:[localhost:5080] TLSClientConfig:<nil> TLSServerConfig:<nil> Raft:learner=false; snapshot-after-entries=10000; snapshot-after-duration=30m; pending-proposals=256; idx=; group= Badger:{Dir: ValueDir: SyncWrites:false NumVersionsToKeep:1 ReadOnly:false Logger:0xc00017ea00 Compression:1 InMemory:false MetricsEnabled:true NumGoroutines:8 MemTableSize:67108864 BaseTableSize:2097152 BaseLevelSize:10485760 LevelSizeMultiplier:10 TableSizeMultiplier:2 MaxLevels:7 VLogPercentile:0 ValueThreshold:1048576 NumMemtables:5 BlockSize:4096 BloomFalsePositive:0.01 BlockCacheSize:697932185 IndexCacheSize:375809638 NumLevelZeroTables:5 NumLevelZeroTablesStall:15 ValueLogFileSize:1073741823 ValueLogMaxEntries:1000000 NumCompactors:4 CompactL0OnClose:false LmaxCompaction:false ZSTDCompressionLevel:0 VerifyValueChecksum:false EncryptionKey:[] EncryptionKeyRotationDuration:240h0m0s BypassLockGuard:false ChecksumVerificationMode:0 DetectConflicts:true NamespaceOffset:-1 managedTxns:false maxBatchCount:0 maxBatchSize:0 maxValueThreshold:0} WhiteListedIPRanges:[{Lower:0.0.0.0 Upper:255.255.255.255}] StrictMutations:false AclEnabled:false HmacSecret:**** AbortOlderThan:5m0s ProposedGroupId:0 StartTime:2022-10-03 23:26:06.8472053 +0000 UTC m=+0.567541201 Ludicrous:enabled=false; concurrency=2000 LudicrousEnabled:false Security:whitelist=0.0.0.0/0; token= EncryptionKey:**** LogRequest:0 HardSync:false Audit:false}

I1003 23:26:07.697568      25 run.go:758] worker.Config: {PostingDir:p WALDir:w MutationsMode:0 AuthToken: HmacSecret:**** AccessJwtTtl:0s RefreshJwtTtl:0s CachePercentage:0,65,35 CacheMb:1024 Audit:<nil> ChangeDataConf:file=; kafka=; sasl_user=; sasl_password=; ca_cert=; client_cert=; client_key=;}

I1003 23:26:07.711255      25 log.go:295] Found file: 2 First Index: 30001

I1003 23:26:07.720718      25 storage.go:125] Init Raft Storage with snap: 30059, first: 30060, last: 36046

I1003 23:26:07.722568      25 server_state.go:141] Opening postings BadgerDB with options: {Dir:p ValueDir:p SyncWrites:false NumVersionsToKeep:2147483647 ReadOnly:false Logger:0x32c8038 Compression:1 InMemory:false MetricsEnabled:true NumGoroutines:8 MemTableSize:67108864 BaseTableSize:2097152 BaseLevelSize:10485760 LevelSizeMultiplier:10 TableSizeMultiplier:2 MaxLevels:7 VLogPercentile:0 ValueThreshold:1048576 NumMemtables:5 BlockSize:4096 BloomFalsePositive:0.01 BlockCacheSize:697932185 IndexCacheSize:375809638 NumLevelZeroTables:5 NumLevelZeroTablesStall:15 ValueLogFileSize:1073741823 ValueLogMaxEntries:1000000 NumCompactors:4 CompactL0OnClose:false LmaxCompaction:false ZSTDCompressionLevel:0 VerifyValueChecksum:false EncryptionKey:[] EncryptionKeyRotationDuration:240h0m0s BypassLockGuard:false ChecksumVerificationMode:0 DetectConflicts:false NamespaceOffset:1 managedTxns:false maxBatchCount:0 maxBatchSize:0 maxValueThreshold:0}

I1003 23:26:07.829086      25 log.go:34] All 3 tables opened in 9ms

I1003 23:26:07.833264      25 log.go:34] Discard stats nextEmptySlot: 0

I1003 23:26:07.833415      25 log.go:34] Set nextTxnTs to 820121

I1003 23:26:07.845650      25 log.go:34] Deleting empty file: p/000083.vlog

I1003 23:26:07.875747      25 groups.go:99] Current Raft Id: 0x8

I1003 23:26:07.875810      25 groups.go:115] Sending member request to Zero: id:8 addr:"localhost:7080" 

I1003 23:26:07.876128      25 run.go:568] Bringing up GraphQL HTTP API at 0.0.0.0:8080/graphql

I1003 23:26:07.876156      25 run.go:569] Bringing up GraphQL HTTP admin API at 0.0.0.0:8080/admin

I1003 23:26:07.876181      25 run.go:596] gRPC server started.  Listening on port 9080

I1003 23:26:07.876181      25 worker.go:111] Worker listening at address: [::]:7080

I1003 23:26:07.876203      25 run.go:597] HTTP server started.  Listening on port 8080

E1003 23:26:07.876265      25 groups.go:1177] Error during SubscribeForUpdates for prefix "\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x15dgraph.graphql.schema\x00": Unable to find any servers for group: 1. closer err: <nil>

I1003 23:26:07.880291      35 init.go:110] 


Dgraph version   : v21.03.0

Dgraph codename  : rocket

Dgraph SHA-256   : b4e4c77011e2938e9da197395dbce91d0c6ebb83d383b190f5b70201836a773f

Commit SHA-1     : a77bbe8ae

Commit timestamp : 2021-04-07 21:36:38 +0530

Branch           : HEAD

Go version       : go1.16.2

jemalloc enabled : true


For Dgraph official documentation, visit https://dgraph.io/docs.

For discussions about Dgraph     , visit http://discuss.dgraph.io.

For fully-managed Dgraph Cloud   , visit https://dgraph.io/cloud.


Licensed variously under the Apache Public License 2.0 and Dgraph Community License.

Copyright 2015-2021 Dgraph Labs, Inc.

I’ll DM full logs to you

MichelDiz · October 3, 2022, 11:32pm

The logs aren’t needed. What I need is to reproduce locally. And find out if other versions are the same.

Topic		Replies	Views
DQL JSON Delete All Dgraph kind:question , dql	7	1548	December 4, 2021
DQL to delete nodes + all child nodes with upsert Dgraph	2	751	April 18, 2021
How to delete objects based on nested objects' fields GraphQL kind:question	2	976	November 3, 2020
Deletion with upsert is not working Dgraph kind:question , dgraph	20	1306	April 27, 2023
How to delete with cascade? GraphQL kind:question , area:mutations	3	2692	November 7, 2020

How do I delete all of type plus associated types?

Related topics