DCS-ODBC-Getting 'Invalid server handle' after bound hstmt is used for a while.

Bug #1252809 reported by Aruna Sadashiva
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
In Progress
Medium
RuoYu Zuo

Bug Description

Using ODBC 64 bit Linux driver.
'Invalid server handle' is returned and insert fails when using SQLBindParameter/Prepare/Execute. The SQLExecute is done in a loop. It works for a while, but fails within 10 minutes. Changed the program to reconnect every 5 mins, but still seeing this error. It works on SQ.

Have attached simple test program to recreate this. To run on SQ remove the SQLExecDirect calls to set CQDs, those are specific to Traf.

Revision history for this message
Aruna Sadashiva (aruna-sadashiva) wrote :
summary: - Getting 'Invalid server handle' after bound hstmt is used for a while.
+ DCS-ODBC-Getting 'Invalid server handle' after bound hstmt is used for a
+ while.
description: updated
Changed in trafodion:
milestone: none → r0.6
tags: added: client-odbc-linux
Revision history for this message
Aruna Sadashiva (aruna-sadashiva) wrote :

Reducing the Importance to Medium, as probability of someone running into this issue is very low.

Changed in trafodion:
importance: High → Medium
Changed in trafodion:
assignee: nobody → RuoYu Zuo (ruo-yu-zuo)
status: New → In Progress
information type: Proprietary → Public
Jian Jin (jian-jin)
Changed in trafodion:
milestone: r0.6 → r0.9
Changed in trafodion:
milestone: r0.9 → r1.1
Changed in trafodion:
milestone: r1.1 → r2.0
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Bug attachments

Remote bug watches

Bug watches keep track of this bug in other bug trackers.