Home > Could Not > Could Not Send Queryconnection Dead

Could Not Send Queryconnection Dead

TCP connection to server seems to be OK since INSERT INTO logfile ... and too slow...Essentially your query execution time is defined by:2016-04-01 20:30:07,589 TRACE [org.teiid.ODBC] (NIO3) invoking server method: executeQuery [BEGIN;declare "SQL_CUR0xb8babc80" scroll cursor with hold for SELECT * FROM ag WHERE id=7496;fetch Like Show 0 Likes(0) Actions 10. You can not post a blank message. have a peek at this web-site

Click Here to join Tek-Tips and talk with other members! I am using postgres 7.4.7 (stock with my unbuntu 5.04 distro), and the newest pgodbc drivers as of a couple weeks ago, with Access as the front end, no problems. Sorry, no I meant from the web console... could this cause worse performances, and could it be due to the way the client works?There is definitely a couple of odd things in the first trace.We see a "SELECT *"

How are they connected? If that's not the case, then more detail please. that is involved across the board.The other strange thing is that some users have started complaining about not being able to log in.The plot grows thicker by the minute, and speaking

On windows, thought, it seems less different (faster). Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Trojan. RE: ODBC connection problem :( WonderCow (Programmer) 7 Sep 05 11:24 I have taken a copy of the nightly backup and dumped it onto out stage environment (close to live hardware-wise)

I think this should be enough to determine what needs to be done. I will try to check this out as a possibility, but with there being some form of consistency of users who do/don't I'm not entirely sure this will be the cause. Re: help needed troubleshooting slow odbc usage Steven Hawkins Apr 1, 2016 6:59 PM (in response to Marco Ardito) > and the trace is attached: it's too much work for something https://www.postgresql.org/message-id/[email protected] also in this simple script.so I guess it's not unixodbc probably?next week I'll test again the same script above on a windows web server on my workstation so to use the

Please turn JavaScript back on and reload this page. Already a member? Error messages in unpredictable places2. Re: help needed troubleshooting slow odbc usage Steven Hawkins Mar 30, 2016 8:34 AM (in response to Marco Ardito) > Works, but it is not very practicalYou mean in Designer?

The Universe has been exported and we can create a webi doc from it. Re: help needed troubleshooting slow odbc usage Steven Hawkins Apr 6, 2016 3:22 PM (in response to Steven Hawkins) From what I can see the issue is that we are misreporting They are connected by ODBC.The client accesses server by call ODBC API.Connection and query timeout don't be set in the client. Registration on or use of this site constitutes acceptance of our Privacy Policy.

RE: ODBC connection problem :( WonderCow (Programmer) 7 Sep 05 05:02 I have set postgres loggin for the client machines, but I am now convinced that it isn't thwe code, since http://strobelfilms.com/could-not/could-not-send-reply.html Sometimes on the client appear: ODBC--call failed. Has anyone got this working successfully and can share how they got there. Like Show 0 Likes(0) Actions Go to original post Actions Remove from profile Feature on your profile More Like This Retrieving data ...

This tool uses JavaScript and much of it will not work correctly without it enabled. I have to say that postgres odbc documentation is not very good, imho, all online example talk just about using the windows gui panel, but this is quite different in linux Since client and server are on the same host, it's unlikely to be network connectivity. http://strobelfilms.com/could-not/error-could-not-initialize-display-hardware-dead-space-2.html Previous:From: Mark KirkwoodDate: 2009-04-01 08:11:45 Subject: Re: Raid 10 chunksize Privacy Policy | About PostgreSQL Copyright © 1996-2016 The PostgreSQL Global Development Group PostgreSQL › PostgreSQL - pgadmin support Search everywhere

Something must of cleared up I guess with the network. Have I left something out? I don't sure this problem is bug.The detail is following: Imake aclient program that communicate withprogreSQL by ODBC on Windows7.

But it's a different everything...

Restart the computer and try it again. i.e if you are using MySQL server then check that MySQL server is running or stopped. So it can be done ----JBR RE: ODBC connection problem :( WonderCow (Programmer) 7 Sep 05 04:41 Thanks for responding, but the problem is a little more odd than it looks:We Re: help needed troubleshooting slow odbc usage Marco Ardito Mar 31, 2016 3:49 AM (in response to Steven Hawkins) Steven Hawkins ha scritto: > Works, but it is not very practical

What configuration options do you have for that odbc client? anyway I have this all running on my computer something was just not working. I never use Designer, only xml VDBs... have a peek here What version of Teiid are you running on, and what is the source / mapped types for those columns?

Copyright © 2000-2015, Alpha Software Corporation | Database Software Products Support Forums My Account Get-It-Free » Sign In Create Account Board index ‹ Archives (Read Only) ‹ PokerTracker Holdem v2 ‹ They all have same activex versions, odbc, and there does not appear to be any correlation there.There are also different levels of use for each of these users - as a Even very simple queries need 4-5 seconds to get the response, while mysql odbc is blasing fast...selecting more fields from the vdb (or *) only makes thing worse... No odd/different software2.

Consult your database documentation for further information. 34 - 'Could not receive the response, communication down ??; Could not send Query(connection dead) SQL State is: 08S01' The server is running I'm This appears to hit a unexpected path in the driver which then causes the re-fetching of the column metadata.Your query has the columns:PGAPI_Columns: table='ag',field_name='id',type=20,name='long'PGAPI_Columns: table='ag',field_name='rag_soc',type=1043,name='string'PGAPI_Columns: table='ag',field_name='fg',type=1043,name='string'PGAPI_Columns: table='ag',field_name='pers_giuridica',type=16,name='boolean'...PGAPI_Columns: table='ag',field_name='note_amm',type=14939,name='lo'PGAPI_Columns: table='ag',field_name='note_form',type=14939,name='lo'PGAPI_Columns: table='ag',field_name='note_gen',type=14939,name='lo'PGAPI_Columns: table='ag',field_name='prossimo_consorziato',type=16,name='boolean'PGAPI_Columns: To start viewing messages, select the forum that you want to visit from the selection below. I don't sure this problem is bug.The detail is following: Imake aclient program that communicate withprogreSQL by ODBC on Windows7.

After that it was a good few complaining about more than one error, and now it's got to the point where there are heaploads of errors happening on average every 5-10 If you're rolling your own, get the newest postgres source (8.0.3 as of right now I believe). Kenney Join Date Jul 2005 Posts 140 Re: error on submit Thank you so much for your response. I am sure it is something else that I have not done.

Trojan. if it is client side, I am leaning more toward odbc problems, although I don't really think that it is. Topic locked 2 posts • Page 1 of 1 PT Error by tercet » Thu Jun 19, 2008 7:46 pm Everythign was working fine last night..When I come back today I You can not post a blank message.

They are connected by ODBC.The client accesses server by call ODBC API.Connection and query timeout don't be set in the client. Yes, each user uses their own terminal, but we havetried switchnig a user with and a user without problems. This is obviously pretty unnecessary. Would adding a org.teiid.PLANNER log session work?I already added to standalone-teiid.xml (I see this is reflected in the web console, also) but I never see any trace i the

I don't sure this problem is bug.The detail is following: Imake aclient program that communicate withprogreSQL by ODBC on Windows7. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action.