Live loader process hand

Users Dgraph
,
1

Doing live loader and the process just hangs with the message “processing schema.gz”

Dgraph version : v1.0.9

Server logs

2021/01/23 12:00:41 draft.go:881: Skipping snapshot at index: 9451725. Insufficient discard entries: 6. MinPendingStartTs: 8228795
2021/01/23 12:00:41 draft.go:769: Found 524 old transactions. Acting to abort them.
2021/01/23 12:00:42 draft.go:746: TryAbort 524 txns with start ts. Error: <nil>
2021/01/23 12:03:43 draft.go:881: Skipping snapshot at index: 9451725. Insufficient discard entries: 6. MinPendingStartTs: 8228795
2021/01/23 12:03:43 draft.go:769: Found 692 old transactions. Acting to abort them.
2021/01/23 12:03:46 draft.go:746: TryAbort 692 txns with start ts. Error: <nil>
2021/01/23 12:06:42 draft.go:881: Skipping snapshot at index: 9451725. Insufficient discard entries: 6. MinPendingStartTs: 8228795
2021/01/23 12:06:42 draft.go:769: Found 724 old transactions. Acting to abort them.
2021/01/23 12:06:46 draft.go:746: TryAbort 724 txns with start ts. Error: <nil>
2021/01/23 12:09:41 draft.go:881: Skipping snapshot at index: 9451725. Insufficient discard entries: 6. MinPendingStartTs: 8228795
2021/01/23 12:09:41 draft.go:769: Found 724 old transactions. Acting to abort them.
2021/01/23 12:09:43 draft.go:746: TryAbort 724 txns with start ts. Error: <nil>
2021/01/23 12:12:44 draft.go:881: Skipping snapshot at index: 9451725. Insufficient discard entries: 6. MinPendingStartTs: 8228795
2021/01/23 12:12:44 draft.go:769: Found 724 old transactions. Acting to abort them.
2021/01/23 12:12:45 draft.go:746: TryAbort 724 txns with start ts. Error: <nil>
2021/01/23 12:15:42 draft.go:881: Skipping snapshot at index: 9451725. Insufficient discard entries: 6. MinPendingStartTs: 8228795
2021/01/23 12:15:42 draft.go:769: Found 720 old transactions. Acting to abort them.
2021/01/23 12:15:43 draft.go:746: TryAbort 720 txns with start ts. Error: <nil>
2021/01/23 12:18:43 draft.go:881: Skipping snapshot at index: 9451725. Insufficient discard entries: 6. MinPendingStartTs: 8228795
2021/01/23 12:18:43 draft.go:769: Found 722 old transactions. Acting to abort them.
2021/01/23 12:18:45 draft.go:746: TryAbort 722 txns with start ts. Error: <nil>
2021/01/23 12:21:42 draft.go:881: Skipping snapshot at index: 9451725. Insufficient discard entries: 6. MinPendingStartTs: 8228795
2021/01/23 12:21:42 draft.go:769: Found 720 old transactions. Acting to abort them.
2021/01/23 12:21:46 draft.go:746: TryAbort 720 txns with start ts. Error: <nil>

Is there any way to abort all the pending transactions?

Restarted the live load with the new cluster.
Server logs


2021/01/23 14:09:17 draft.go:746: TryAbort 250 txns with start ts. Error: <nil>
2021/01/23 14:09:22 draft.go:746: TryAbort 250 txns with start ts. Error: <nil>
2021/01/23 14:09:39 draft.go:746: TryAbort 256 txns with start ts. Error: <nil>
2021/01/23 14:09:52 draft.go:746: TryAbort 256 txns with start ts. Error: <nil>
2021/01/23 14:11:37 mutation.go:174: Done schema update predicate:"name" value_type:STRING directive:INDEX tokenizer:"fulltext"
2021/01/23 14:11:38 mutation.go:174: Done schema update predicate:"route" value_type:STRING directive:INDEX tokenizer:"hash" list:true
2021/01/23 14:11:40 mutation.go:582: tryAbortTransactions for 256 txns. Error: <nil>
2021/01/23 14:11:51 draft.go:746: TryAbort 54 txns with start ts. Error: <nil>
2021/01/23 14:11:52 mutation.go:582: tryAbortTransactions for 256 txns. Error: <nil>
2021/01/23 14:11:54 mutation.go:582: tryAbortTransactions for 250 txns. Error: <nil>
2021/01/23 14:11:54 mutation.go:582: tryAbortTransactions for 250 txns. Error: <nil>

The process is still running for almost 30 minutes

Server logs

2021/01/23 14:25:27 draft.go:881: Skipping snapshot at index: 911. Insufficient discard entries: 0. MinPendingStartTs: 877
2021/01/23 14:25:27 draft.go:769: Found 432 old transactions. Acting to abort them.
2021/01/23 14:25:28 draft.go:746: TryAbort 432 txns with start ts. Error: <nil>
2021/01/23 14:27:16 draft.go:881: Skipping snapshot at index: 911. Insufficient discard entries: 0. MinPendingStartTs: 877
2021/01/23 14:27:16 draft.go:769: Found 370 old transactions. Acting to abort them.
2021/01/23 14:27:17 draft.go:746: TryAbort 370 txns with start ts. Error: <nil>

2021/01/23 14:30:16 draft.go:881: Skipping snapshot at index: 911. Insufficient discard entries: 0. MinPendingStartTs: 877
2021/01/23 14:30:16 draft.go:769: Found 333 old transactions. Acting to abort them.
2021/01/23 14:30:17 draft.go:746: TryAbort 333 txns with start ts. Error: <nil>
2021/01/23 14:32:46 draft.go:746: TryAbort 69 txns with start ts. Error: <nil>
2

Hey @Arun_Kumar_AB, we don’t support such an old version. We recommend that you upgrade https://dgraph.io/docs/deploy/dgraph-administration/#upgrading-from-v122-to-v20030-for-enterprise-customers - cuz since 2018, Dgraph has changed a lot and fixed several bugs. Which could be the solution for your issue.