Ratel (play.dgraph.io) won't drop data

I’m seeing a bunch of test data on play.dgraph.io – and it won’t let me drop it:

Where does that movie data live?

I’m also seeing play.dgraph.io is running v20.11.0-11-gb36b4862 – why is that not the latest / how can I upgrade it?

Thanks!

Are you sure that is not point to the Play’s sample cluster?

This looks like this Get 401 when visit schema route in ratel in Dgraph Clound

Also, 401 means Unauthorized.

When I go to the Cluster tab, it’s blank: CleanShot 2021-10-11 at 01.04.09@2x · CleanShot Cloud

Hey Jamila.

You are pointing Ratel to https://play.dgraph.io/ which is the Play dataset sample. You should point it to your cluster. Not Dgraph’s one. The Play cluster is locked for any change or mutations.

Click in the Ratel’s logo(where you can see a green ball). And change the “Dgraph server URL” to your Cluster address or IP.

Cheers.

I’m running this command locally:

docker run --rm -it -p “8080:8080” -p “9080:9080” -p “8000:8000” -v ~/dgraph:/dgraph “dgraph/standalone:v21.03.1”

What would I enter as the server URL in this case?

Remove this port, there’s no Ratel in that image.

Your localhost or the IP of the VM used to run Docker. With the port.

But pay attention that Google have new rules about CORS. You can’t run an HTTPS site to access a Non-HTTPS service. So, you have to use Firefox or something.

Sorry I’m not following – the getting started page shows these instructions:

And running that command without the “-p 8000:8000” part doesn’t seem to change anything – both return this in the terminal:

Warning: This standalone version is meant for quickstart purposes only.
         It is NOT RECOMMENDED for production environments.
/run.sh: line 16: dgraph-ratel: command not found
[Sentry] 2021/10/11 05:51:09 Integration installed: ContextifyFrames
[Sentry] 2021/10/11 05:51:09 Integration installed: Environment
[Sentry] 2021/10/11 05:51:09 Integration installed: Modules
[Sentry] 2021/10/11 05:51:09 Integration installed: IgnoreErrors
[Sentry] 2021/10/11 05:51:09 Integration installed: ContextifyFrames
[Sentry] 2021/10/11 05:51:09 Integration installed: Environment
[Sentry] 2021/10/11 05:51:09 Integration installed: Modules
[Sentry] 2021/10/11 05:51:09 Integration installed: IgnoreErrors
[Sentry] 2021/10/11 05:51:09 Integration installed: ContextifyFrames
[Sentry] 2021/10/11 05:51:09 Integration installed: Environment
[Sentry] 2021/10/11 05:51:09 Integration installed: Modules
[Sentry] 2021/10/11 05:51:09 Integration installed: IgnoreErrors
[Sentry] 2021/10/11 05:51:09 Integration installed: ContextifyFrames
[Sentry] 2021/10/11 05:51:09 Integration installed: Environment
[Sentry] 2021/10/11 05:51:09 Integration installed: Modules
[Sentry] 2021/10/11 05:51:09 Integration installed: IgnoreErrors
I1011 05:51:09.800182      30 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.
I1011 05:51:09.835522      38 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.
I1011 05:51:09.952012      30 init.go:110]

Dgraph version   : v21.03.2
Dgraph codename  : rocket-2
Dgraph SHA-256   : 00a53ef6d874e376d5a53740341be9b822ef1721a4980e6e2fcb60986b3abfbf
Commit SHA-1     : b17395d33
Commit timestamp : 2021-08-26 01:11:38 -0700
Branch           : HEAD
Go version       : go1.16.2
jemalloc enabled : true

For Dgraph official documentation, visit https://dgraph.io/docs.
For discussions about Dgraph     , visit https://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.


I1011 05:51:09.952112      30 run.go:752] x.Config: {PortOffset:0 Limit:mutations-nquad=1000000; disallow-drop=false; query-timeout=0ms; txn-abort-after=5m; max-pending-queries=10000; mutations=allow; normalize-node=10000; max-retries=-1; query-edge=1000000 LimitMutationsNquad:1000000 LimitQueryEdge:1000000 BlockClusterWideDrop:false LimitNormalizeNode:10000 QueryTimeout:0s MaxRetries:-1 GraphQL:introspection=true; debug=false; extensions=true; poll-interval=1s; lambda-url= GraphQLDebug:false}
I1011 05:51:09.952172      30 run.go:753] x.WorkerConfig: {TmpDir:t ExportPath:export Trace:datadog=; ratio=0.01; jaeger= 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:0xc000071450 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:2021-10-11 05:51:09.472920141 +0000 UTC m=+0.181884612 Ludicrous:enabled=false; concurrency=2000 LudicrousEnabled:false Security:whitelist=0.0.0.0/0; token= EncryptionKey:**** LogRequest:0 HardSync:false Audit:false}
I1011 05:51:09.952281      30 run.go:754] 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=; sasl-mechanism=PLAIN;}
I1011 05:51:09.961802      30 log.go:295] Found file: 1 First Index: 1
I1011 05:51:09.966713      30 storage.go:125] Init Raft Storage with snap: 80, first: 81, last: 10035
I1011 05:51:09.967614      30 server_state.go:140] Opening postings BadgerDB with options: {Dir:p ValueDir:p SyncWrites:false NumVersionsToKeep:2147483647 ReadOnly:false Logger:0x342b618 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}
I1011 05:51:09.997284      30 log.go:34] All 3 tables opened in 5ms
I1011 05:51:09.999475      30 log.go:34] Discard stats nextEmptySlot: 0
I1011 05:51:09.999651      30 log.go:34] Set nextTxnTs to 60011
I1011 05:51:10.003054      30 log.go:34] Deleting empty file: p/000009.vlog
I1011 05:51:10.015134      30 groups.go:100] Current Raft Id: 0x7
I1011 05:51:10.015171      30 groups.go:116] Sending member request to Zero: id:7 addr:"localhost:7080"
I1011 05:51:10.015778      30 worker.go:114] Worker listening at address: [::]:7080
I1011 05:51:10.016719      30 run.go:565] Bringing up GraphQL HTTP API at 0.0.0.0:8080/graphql
I1011 05:51:10.016748      30 run.go:566] Bringing up GraphQL HTTP admin API at 0.0.0.0:8080/admin
I1011 05:51:10.016766      30 run.go:593] gRPC server started.  Listening on port 9080
I1011 05:51:10.016770      30 run.go:594] HTTP server started.  Listening on port 8080
E1011 05:51:10.016768      30 groups.go:1181] 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>
I1011 05:51:10.017506      38 init.go:110]

Dgraph version   : v21.03.2
Dgraph codename  : rocket-2
Dgraph SHA-256   : 00a53ef6d874e376d5a53740341be9b822ef1721a4980e6e2fcb60986b3abfbf
Commit SHA-1     : b17395d33
Commit timestamp : 2021-08-26 01:11:38 -0700
Branch           : HEAD
Go version       : go1.16.2
jemalloc enabled : true

For Dgraph official documentation, visit https://dgraph.io/docs.
For discussions about Dgraph     , visit https://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.


I1011 05:51:10.018255      38 run.go:254] Setting Config to: {raft:0xc000552040 telemetry:0xc0003863d0 limit:0xc000552048 bindall:true portOffset:0 numReplicas:1 peer: w:zw rebalanceInterval:480000000000 tlsClientConfig:<nil> audit:<nil> limiterConfig:0xc000144080}
I1011 05:51:10.018384      38 run.go:144] Setting up grpc listener at: 0.0.0.0:5080
I1011 05:51:10.019425      38 run.go:144] Setting up http listener at: 0.0.0.0:6080
I1011 05:51:10.026862      38 log.go:295] Found file: 1 First Index: 1
I1011 05:51:10.030197      38 storage.go:125] Init Raft Storage with snap: 65, first: 66, last: 103
I1011 05:51:10.030602      38 node.go:152] Setting raft.Config to: &{ID:1 peers:[] learners:[] ElectionTick:20 HeartbeatTick:1 Storage:0xc0002da200 Applied:65 MaxSizePerMsg:262144 MaxCommittedSizePerReady:67108864 MaxUncommittedEntriesSize:0 MaxInflightMsgs:256 CheckQuorum:false PreVote:true ReadOnlyOption:0 Logger:0x342b618 DisableProposalForwarding:false}
I1011 05:51:10.031854      38 node.go:310] Found Snapshot.Metadata: {ConfState:{Nodes:[1] Learners:[] XXX_unrecognized:[]} Index:65 Term:8 XXX_unrecognized:[]}
I1011 05:51:10.031971      38 node.go:321] Found hardstate: {Term:17 Vote:1 Commit:103 XXX_unrecognized:[]}
I1011 05:51:10.032102      38 node.go:326] Group 0 found 103 entries
I1011 05:51:10.032132      38 raft.go:605] Restarting node for dgraphzero
I1011 05:51:10.032138      38 node.go:189] Setting conf state to nodes:1
I1011 05:51:10.032761      38 pool.go:164] CONN: Connecting to localhost:7080
I1011 05:51:10.032805      38 log.go:34] 1 became follower at term 17
I1011 05:51:10.032850      38 log.go:34] newRaft 1 [peers: [1], term: 17, commit: 103, applied: 65, lastindex: 103, lastterm: 17]
I1011 05:51:10.033619      38 run.go:388] Running Dgraph Zero...
I1011 05:51:10.118923      30 pool.go:164] CONN: Connecting to localhost:5080
I1011 05:51:10.123081      38 zero.go:445] Got connection request: cluster_info_only:true
I1011 05:51:10.123491      38 log.go:34] 1 no leader at term 17; dropping index reading msg
E1011 05:51:11.019880      30 groups.go:1181] 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>
E1011 05:51:11.041937      38 pool.go:311] CONN: Unable to connect with localhost:7080 : rpc error: code = Unknown desc = No node has been set up yet
E1011 05:51:12.020979      30 groups.go:1181] 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>
E1011 05:51:12.046596      38 pool.go:311] CONN: Unable to connect with localhost:7080 : rpc error: code = Unknown desc = No node has been set up yet
W1011 05:51:12.124421      38 node.go:708] [0x1] Read index context timed out
I1011 05:51:12.124681      38 log.go:34] 1 no leader at term 17; dropping index reading msg
E1011 05:51:13.021982      30 groups.go:1181] 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>
E1011 05:51:13.049548      38 pool.go:311] CONN: Unable to connect with localhost:7080 : rpc error: code = Unknown desc = No node has been set up yet
I1011 05:51:13.633547      38 log.go:34] 1 is starting a new election at term 17
I1011 05:51:13.633671      38 log.go:34] 1 became pre-candidate at term 17
I1011 05:51:13.633686      38 log.go:34] 1 received MsgPreVoteResp from 1 at term 17
I1011 05:51:13.633782      38 log.go:34] 1 became candidate at term 18
I1011 05:51:13.633806      38 log.go:34] 1 received MsgVoteResp from 1 at term 18
I1011 05:51:13.634133      38 log.go:34] 1 became leader at term 18
I1011 05:51:13.634173      38 log.go:34] raft.node: 1 elected leader 1 at term 18
I1011 05:51:13.634383      38 raft.go:911] I've become the leader, updating leases.
I1011 05:51:13.634447      38 assign.go:47] Updated UID: 40001. Txn Ts: 160001. NsID: 1.
E1011 05:51:14.023424      30 groups.go:1181] 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>
E1011 05:51:14.055055      38 pool.go:311] CONN: Unable to connect with localhost:7080 : rpc error: code = Unknown desc = No node has been set up yet
W1011 05:51:14.125618      38 node.go:708] [0x1] Read index context timed out
I1011 05:51:14.125897      38 zero.go:470] Connected: cluster_info_only:true
I1011 05:51:14.127906      38 zero.go:445] Got connection request: id:7 addr:"localhost:7080"
I1011 05:51:14.128166      38 zero.go:592] Connected: id:7 addr:"localhost:7080"
I1011 05:51:14.128650      30 groups.go:135] Connected to group zero. Assigned group: 0
I1011 05:51:14.128673      30 groups.go:137] Raft Id after connection to Zero: 0x7
I1011 05:51:14.128813      30 draft.go:270] Node ID: 0x7 with GroupID: 1
I1011 05:51:14.128826      30 draft.go:279] RaftContext: id:7 group:1 addr:"localhost:7080"
I1011 05:51:14.128927      30 node.go:152] Setting raft.Config to: &{ID:7 peers:[] learners:[] ElectionTick:20 HeartbeatTick:1 Storage:0xc0005fe500 Applied:80 MaxSizePerMsg:262144 MaxCommittedSizePerReady:67108864 MaxUncommittedEntriesSize:0 MaxInflightMsgs:256 CheckQuorum:false PreVote:true ReadOnlyOption:0 Logger:0x342b618 DisableProposalForwarding:false}
I1011 05:51:14.129608      30 node.go:310] Found Snapshot.Metadata: {ConfState:{Nodes:[7] Learners:[] XXX_unrecognized:[]} Index:80 Term:3 XXX_unrecognized:[]}
I1011 05:51:14.129674      30 node.go:321] Found hardstate: {Term:17 Vote:7 Commit:10035 XXX_unrecognized:[]}
I1011 05:51:14.145519      30 node.go:326] Group 1 found 10035 entries
I1011 05:51:14.145577      30 draft.go:1826] Restarting node for group: 1
I1011 05:51:14.145586      30 node.go:189] Setting conf state to nodes:7
I1011 05:51:14.145902      30 log.go:34] 7 became follower at term 17
I1011 05:51:14.145956      30 log.go:34] newRaft 7 [peers: [7], term: 17, commit: 10035, applied: 80, lastindex: 10035, lastterm: 17]
I1011 05:51:14.146016      30 draft.go:211] Operation started with id: opRollup
I1011 05:51:14.146426      30 draft.go:1208] Found Raft progress: 10035
I1011 05:51:14.146582      30 groups.go:820] Got address of a Zero leader: localhost:5080
I1011 05:51:14.147152      30 groups.go:834] Starting a new membership stream receive from localhost:5080.
I1011 05:51:14.148096      30 groups.go:851] Received first state update from Zero: counter:103 groups:<key:1 value:<members:<key:7 value:<id:7 group_id:1 addr:"localhost:7080" leader:true last_update:1633931163 > > tablets:<key:"\000\000\000\000\000\000\000\000Member.confirmed_at" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000Member.confirmed_at" > > tablets:<key:"\000\000\000\000\000\000\000\000Member.email" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000Member.email" > > tablets:<key:"\000\000\000\000\000\000\000\000Member.hashed_password" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000Member.hashed_password" > > tablets:<key:"\000\000\000\000\000\000\000\000Member.inserted_at" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000Member.inserted_at" > > tablets:<key:"\000\000\000\000\000\000\000\000Member.updated_at" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000Member.updated_at" > > tablets:<key:"\000\000\000\000\000\000\000\000Members.confirmed_at" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000Members.confirmed_at" > > tablets:<key:"\000\000\000\000\000\000\000\000Members.email" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000Members.email" > > tablets:<key:"\000\000\000\000\000\000\000\000Members.hashed_password" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000Members.hashed_password" > > tablets:<key:"\000\000\000\000\000\000\000\000dgraph.drop.op" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000dgraph.drop.op" > > tablets:<key:"\000\000\000\000\000\000\000\000dgraph.graphql.p_query" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000dgraph.graphql.p_query" > > tablets:<key:"\000\000\000\000\000\000\000\000dgraph.graphql.schema" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000dgraph.graphql.schema" > > tablets:<key:"\000\000\000\000\000\000\000\000dgraph.graphql.xid" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000dgraph.graphql.xid" > > tablets:<key:"\000\000\000\000\000\000\000\000dgraph.type" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000dgraph.type" > > tablets:<key:"\000\000\000\000\000\000\000\000people.name" value:<group_id:1 predicate:"\000\000\000\000\000\000\000\000people.name" > > snapshot_ts:10062 checksum:16974270649665006799 > > zeros:<key:1 value:<id:1 addr:"localhost:5080" leader:true > > maxUID:40000 maxTxnTs:160000 maxRaftId:7 cid:"268c4e2e-f63d-46c4-b2f4-7522a30c40cf" license:<maxNodes:18446744073709551615 expiryTs:1630468938 >
E1011 05:51:15.017091      30 admin.go:862] namespace: 0. Error reading GraphQL schema: Please retry again, server is not ready to accept requests.
I1011 05:51:15.024171      30 pool.go:164] CONN: Connecting to localhost:7080
I1011 05:51:15.057526      38 pool.go:327] CONN: Re-established connection with localhost:7080.
I1011 05:51:15.147534      30 groups.go:166] Server is ready
I1011 05:51:15.147585      30 access_ee.go:418] InitializeAcl closed
I1011 05:51:17.647114      30 log.go:34] 7 is starting a new election at term 17
I1011 05:51:17.647294      30 log.go:34] 7 became pre-candidate at term 17
I1011 05:51:17.647311      30 log.go:34] 7 received MsgPreVoteResp from 7 at term 17
I1011 05:51:17.647383      30 log.go:34] 7 became candidate at term 18
I1011 05:51:17.647393      30 log.go:34] 7 received MsgVoteResp from 7 at term 18
I1011 05:51:17.647414      30 log.go:34] 7 became leader at term 18
I1011 05:51:17.647428      30 log.go:34] raft.node: 7 elected leader 7 at term 18
I1011 05:51:18.146480      30 groups.go:906] Leader idx=0x7 of group=1 is connecting to Zero for txn updates
I1011 05:51:18.146506      30 groups.go:918] Got Zero leader: localhost:5080
I1011 05:51:18.149446      30 access_ee.go:353] RefreshAcls closed
I1011 05:51:20.020999      30 admin.go:873] namespace: 0. No GraphQL schema in Dgraph; serving empty GraphQL API

After trying them all, this worked as the server URL: http://localhost:8080