Spanner: "after all" hook for "should drop a foreign key constraint delete cascade" failed

Question

Spanner: "after all" hook for "should drop a foreign key constraint delete cascade" failed

Closed this issue a year ago · 1 comments

flaky-bot commented a year ago

This test failed!

To configure my behavior, see the Flaky Bot documentation.

If I'm commenting on this issue too often, add the flakybot: quiet label and
I will stop commenting.

commit: f2a7ae9
buildURL: Build Status, Sponge
status: failed

Test output

9 FAILED_PRECONDITION: Backup projects/long-door-651/instances/test-instance-1690798726/backups/test-backup-1690798726-enc cannot be deleted at the moment because it is still in use by 1 databases for pending restore activity. Please try deleting the backup once the restore or post-restore optimize operations have completed on these databases. The databases using this backup are displayed in the UI in the Backups table `In use by` column, and returned by the GetBackup API.
Error: 9 FAILED_PRECONDITION: Backup projects/long-door-651/instances/test-instance-1690798726/backups/test-backup-1690798726-enc cannot be deleted at the moment because it is still in use by 1 databases for pending restore activity. Please try deleting the backup once the restore or post-restore optimize operations have completed on these databases. The databases using this backup are displayed in the UI in the Backups table `In use by` column, and returned by the GetBackup API.
    at callErrorFromStatus (/workspace/node_modules/@grpc/grpc-js/build/src/call.js:31:19)
        -> /workspace/node_modules/@grpc/grpc-js/src/call.ts:81:17
    at Object.onReceiveStatus (/workspace/node_modules/@grpc/grpc-js/build/src/client.js:192:76)
        -> /workspace/node_modules/@grpc/grpc-js/src/client.ts:356:55
    at /workspace/node_modules/@grpc/grpc-js/build/src/call-interface.js:78:35
        -> /workspace/node_modules/@grpc/grpc-js/src/call-interface.ts:149:27
    at Object.onReceiveStatus (/workspace/node_modules/grpc-gcp/build/src/index.js:73:29)
        -> /workspace/node_modules/grpc-gcp/src/index.ts:132:15
    at InterceptingListenerImpl.onReceiveStatus (/workspace/node_modules/@grpc/grpc-js/build/src/call-interface.js:73:23)
        -> /workspace/node_modules/@grpc/grpc-js/src/call-interface.ts:145:19
    at Object.onReceiveStatus (/workspace/node_modules/@grpc/grpc-js/build/src/client-interceptors.js:360:141)
        -> /workspace/node_modules/@grpc/grpc-js/src/client-interceptors.ts:454:34
    at Object.onReceiveStatus (/workspace/node_modules/@grpc/grpc-js/build/src/client-interceptors.js:323:181)
        -> /workspace/node_modules/@grpc/grpc-js/src/client-interceptors.ts:416:48
    at /workspace/node_modules/@grpc/grpc-js/build/src/resolving-call.js:94:78
        -> /workspace/node_modules/@grpc/grpc-js/src/resolving-call.ts:111:24
    at processTicksAndRejections (internal/process/task_queues.js:79:11)
for call at
    at ServiceClientImpl.makeUnaryRequest (/workspace/node_modules/@grpc/grpc-js/build/src/client.js:160:32)
        -> /workspace/node_modules/@grpc/grpc-js/src/client.ts:326:42
    at ServiceClientImpl. (/workspace/node_modules/@grpc/grpc-js/build/src/make-client.js:105:19)
        -> /workspace/node_modules/@grpc/grpc-js/src/make-client.ts:189:15
    at /workspace/build/src/v1/database_admin_client.js:302:29
        -> /workspace/src/v1/database_admin_client.ts:446:25
    at /workspace/node_modules/google-gax/build/src/normalCalls/timeout.js:44:16
        -> /workspace/node_modules/google-gax/src/normalCalls/timeout.ts:54:13
    at repeat (/workspace/node_modules/google-gax/build/src/normalCalls/retries.js:80:25)
        -> /workspace/node_modules/google-gax/src/normalCalls/retries.ts:104:19
    at /workspace/node_modules/google-gax/build/src/normalCalls/retries.js:118:13
        -> /workspace/node_modules/google-gax/src/normalCalls/retries.ts:144:7
    at OngoingCall.call (/workspace/node_modules/google-gax/build/src/call.js:67:27)
        -> /workspace/node_modules/google-gax/src/call.ts:81:23
    at NormalApiCaller.call (/workspace/node_modules/google-gax/build/src/normalCalls/normalApiCaller.js:34:19)
        -> /workspace/node_modules/google-gax/src/normalCalls/normalApiCaller.ts:43:15
    at /workspace/node_modules/google-gax/build/src/createApiCall.js:84:30
        -> /workspace/node_modules/google-gax/src/createApiCall.ts:118:26

Answer 1 · 2023-08-04T06:58:26.000Z

Looks like this issue is flaky. 😟

I'm going to leave this open and stop commenting.

A human should fix and close this.

commit: 6852d99
buildURL: Build Status, Sponge
status: failed

Test output

9 FAILED_PRECONDITION: Backup projects/long-door-651/instances/test-instance-1691128675/backups/test-backup-1691128675-enc cannot be deleted at the moment because it is still in use by 1 databases for pending restore activity. Please try deleting the backup once the restore or post-restore optimize operations have completed on these databases. The databases using this backup are displayed in the UI in the Backups table `In use by` column, and returned by the GetBackup API.
Error: 9 FAILED_PRECONDITION: Backup projects/long-door-651/instances/test-instance-1691128675/backups/test-backup-1691128675-enc cannot be deleted at the moment because it is still in use by 1 databases for pending restore activity. Please try deleting the backup once the restore or post-restore optimize operations have completed on these databases. The databases using this backup are displayed in the UI in the Backups table `In use by` column, and returned by the GetBackup API.
    at callErrorFromStatus (/workspace/node_modules/@grpc/grpc-js/build/src/call.js:31:19)
        -> /workspace/node_modules/@grpc/grpc-js/src/call.ts:81:17
    at Object.onReceiveStatus (/workspace/node_modules/@grpc/grpc-js/build/src/client.js:192:76)
        -> /workspace/node_modules/@grpc/grpc-js/src/client.ts:356:55
    at /workspace/node_modules/@grpc/grpc-js/build/src/call-interface.js:78:35
        -> /workspace/node_modules/@grpc/grpc-js/src/call-interface.ts:149:27
    at Object.onReceiveStatus (/workspace/node_modules/grpc-gcp/build/src/index.js:73:29)
        -> /workspace/node_modules/grpc-gcp/src/index.ts:132:15
    at InterceptingListenerImpl.onReceiveStatus (/workspace/node_modules/@grpc/grpc-js/build/src/call-interface.js:73:23)
        -> /workspace/node_modules/@grpc/grpc-js/src/call-interface.ts:145:19
    at Object.onReceiveStatus (/workspace/node_modules/@grpc/grpc-js/build/src/client-interceptors.js:360:141)
        -> /workspace/node_modules/@grpc/grpc-js/src/client-interceptors.ts:454:34
    at Object.onReceiveStatus (/workspace/node_modules/@grpc/grpc-js/build/src/client-interceptors.js:323:181)
        -> /workspace/node_modules/@grpc/grpc-js/src/client-interceptors.ts:416:48
    at /workspace/node_modules/@grpc/grpc-js/build/src/resolving-call.js:94:78
        -> /workspace/node_modules/@grpc/grpc-js/src/resolving-call.ts:111:24
    at processTicksAndRejections (internal/process/task_queues.js:79:11)
for call at
    at ServiceClientImpl.makeUnaryRequest (/workspace/node_modules/@grpc/grpc-js/build/src/client.js:160:32)
        -> /workspace/node_modules/@grpc/grpc-js/src/client.ts:326:42
    at ServiceClientImpl. (/workspace/node_modules/@grpc/grpc-js/build/src/make-client.js:105:19)
        -> /workspace/node_modules/@grpc/grpc-js/src/make-client.ts:189:15
    at /workspace/build/src/v1/database_admin_client.js:302:29
        -> /workspace/src/v1/database_admin_client.ts:446:25
    at /workspace/node_modules/google-gax/build/src/normalCalls/timeout.js:44:16
        -> /workspace/node_modules/google-gax/src/normalCalls/timeout.ts:54:13
    at repeat (/workspace/node_modules/google-gax/build/src/normalCalls/retries.js:80:25)
        -> /workspace/node_modules/google-gax/src/normalCalls/retries.ts:104:19
    at /workspace/node_modules/google-gax/build/src/normalCalls/retries.js:118:13
        -> /workspace/node_modules/google-gax/src/normalCalls/retries.ts:144:7
    at OngoingCall.call (/workspace/node_modules/google-gax/build/src/call.js:67:27)
        -> /workspace/node_modules/google-gax/src/call.ts:81:23
    at NormalApiCaller.call (/workspace/node_modules/google-gax/build/src/normalCalls/normalApiCaller.js:34:19)
        -> /workspace/node_modules/google-gax/src/normalCalls/normalApiCaller.ts:43:15
    at /workspace/node_modules/google-gax/build/src/createApiCall.js:84:30
        -> /workspace/node_modules/google-gax/src/createApiCall.ts:118:26