× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
umesh dutonde
dutondeumesh reported Oct 26, 2015  · tariqrahiman last modified Nov 7, 2015

Replica environment : Query takes 2 mins to execute and returns the "timeout waiting for a pooled item" error


Dev
Emil Goicovici
emil.goicovici
QA
Jenny Nishimura
JennyNishimura
Priority Major
Complexity Unknown
Component MongoSQL
Version 17.0

Aqua Data Studio 17.0.0-rc-22
Build #: 46570
Built on: 2015-Oct-22 03:35:55 PM     

MongoDB versions : 2.6.11 , 3.0.7
Steps to Reproduce:
1] Establish  2 node replica mongo connection.
2] Connect ADS to primary replica member 
3] Run below SQL script to insert data  
 
create database adsunittest collection tde
go
 
use adsunittest
go
 
INSERT INTO tde(_id, bindata, codedata, contribs, dob, flag, md5Data, mnky, mxky, stats, uuidData, views, weight)
  VALUES(OBJECTID('523e93882318904ad2312360'), OBJECTID('523e93882318904ad2312360'), 7.898090808988789E8, OBJECTID('523e93882318904ad2312360'), NULL, false, false, MINKEY(), MAXKEY(), 89089980912, NULL, '1340090880.7897', 7.898090808988789E8)
GO
 
INSERT INTO tde(_id, codedata, contribs, dob, flag, md5Data, mnky, mxky, stats, uuidData, views, weight, name.first, name.last)
  VALUES(OBJECTID('523e92862318904ad231235c'), NULL, NULL, NULL, true, MINKEY(), MINKEY(), MAXKEY(), MAXKEY(), UUID('d28a74da-87a6-1752-2476-c71108323bd5'), '1340090880.23', 7898.898, 'James', 'Pradhan')
GO
 
4] Run below command(which has intersect clause)
 
select stats from tde
intersect
select name.last from tde
go
 
5] Now execute below command
 
select count(*) from tde 
go 
 
6] This command takes 2 min. to execute   and displays error message .
 
>[Error] Script lines: 22-25 ------------------------
 Timeout waiting for a pooled item after 120000 MILLISECONDS
 If you want to execute MongoDB JavaScript commands, you can use the EVAL or EVAL_ARRAY command or launch a MongoJS Query Analyzer.
 To set the default syntax for MongoDB Query Analyzer, go to File > Options > Query Analyzer > MongoDB > Default Syntax. 
 
Note : 
1. Executed same query in ADS 17.0.0-rc-15, here it works properly 
2. Above scenario working fine on Stand alone environment. 
3. Intersect clause is the cause of the problem.
4. Issue observed for Union clause also.
5. I have attached mongoScripts.sql for reference  
3 attachments
  •  
  •  
  • No shares
  •  
All Comments (4) Change History
Sort 

Issue #13799
Closed
Fixed
Resolved Oct 26, 2015
 
 
Completion
No due date
Fixed Build ADS 17.0.0-rc-24, mongo-jdbc 1.4.7.6, 2.4.7.6
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017