-
Notifications
You must be signed in to change notification settings - Fork 649
Description
OS: Mac OSX 10.12.4
Node.js version: 6.9.3
npm version: 5.0.0
version: 0.4.4
After closing #2176 i run my data export in spanner. When a number of requests were in parallel the following error occurred several times.
noStatus - TypeError: requestStream.destroy is not a function
at StreamProxy.<anonymous> (/Users/Chipintoza/GSS Projects/accounts.gss.ge/node_modules/@google-cloud/spanner/src/transaction.js:375:19)
at emitOne (events.js:96:13)
at StreamProxy.emit (events.js:188:7)
at ClientReadableStream.<anonymous> (/Users/Chipintoza/GSS Projects/accounts.gss.ge/node_modules/google-gax/lib/streaming.js:130:17)
at emitOne (events.js:96:13)
at ClientReadableStream.emit (events.js:188:7)
at ClientReadableStream._emitStatusIfDone (/Users/Chipintoza/GSS Projects/accounts.gss.ge/node_modules/grpc/src/node/src/client.js:204:12)
at ClientReadableStream._receiveStatus (/Users/Chipintoza/GSS Projects/accounts.gss.ge/node_modules/grpc/src/node/src/client.js:180:8)
at /Users/Chipintoza/GSS Projects/accounts.gss.ge/node_modules/grpc/src/node/src/client.js:592:14
After certain quantity of data export, the following error kept occurring constantly:
- req.url - http://accounts.gss.local:9001/gss-api/environments/upsert
InternalServerError: err.code: 8 - err.message: Too many active sessions in database projects/spanner-gss-ge/instances/business-data/databases/system-development, limit is 30000. Increase the node count to allow more sessions.
- err.status: undefined
- err location: Environment.upsert\database.runTransaction((err, tx) => {...
- data:
{
"environmentId": "5e9d511f-e300-49d8-80ba-21c421f98b03",
"isActive": true,
"created": 1325376000000,
"timestamp": 1496655116694,
"modifierId": "system-id",
"modifierName": "system",
"name": "ka:ჩემი 'GSS გარემო' - paab@mail.ru|en:My 'GSS Environment' - paab@mail.ru|ru:Моя 'GSS Среда' - paab@mail.ru",
"databaseID": "39aa56bc-f926-4df2-afe9-619c1e527afe",
"isUnderControl": false,
"environmentSyncURL": "",
"linkedGSSContactID": null,
"linkedContactID": null,
"inputLanguages": "en ka ru",
"usersInputLanguages": "",
"registrationCountry": "",
"rsgeServiceUser": "",
"rsgeServiceUserPassword": "",
"mainCurrencySignification": null,
"accountingCurrencySignifications": "",
"domain": null,
"gssEducationIsActive": false
}- apiResponse:
I stop my process and during 20 minute from console i can not run any queries... there was same error:
Too many active sessions in database projects/spanner-gss-ge/instances/business-data/databases/system-development, limit is 30000. Increase the node count to allow more sessions.
When will close sessions? look at pictures
I was wait around 40 minute and then delete database.
https://cloud.google.com/spanner/docs/limits
Sessions per database per node 10,000
What does it mean?
how longer do i need to wait session closing?
Thank you

