8:18 p.m.
Native PG Connector does not pass back errors to client
-------------------------------------------------------
Key: TEIID-1732
URL: https://issues.jboss.org/browse/TEIID-1732
Project: Teiid
Issue Type: Bug
Affects Versions: 7.5
Environment: Red Hat Enterprise Linux Server release 5.7 (Tikanga)
JBoss EAP 5.1.1
java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Hi,
When we have people connecting to the native postgres emulation component of teiid (port
35432) using say, perl, or python, they can connect and query stuff fine, but if they give
it a bad query (for exammple, the statement "selectx * from table.name") we see
an error in the server side long saying the syntax is incorrect, but this error is never
passed back to the client. The client just sits there waiting for a response that never
comes.
Can we please have any and all errors returned back to the client correctly?
Thanks,
Graeme
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:30 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1732) Native PG Connector does not pass back errors to client
[
https://issues.jboss.org/browse/TEIID-1732?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1732:
---------------------------------------
Can you give a specific client and sequence of events? Trying a simple test over
jdbc/odbc (such as in TestODBCSocketTransport.testPreparedError) sends the error result
back just fine for a query error.
Native PG Connector does not pass back errors to client
-------------------------------------------------------
Key: TEIID-1732
URL: https://issues.jboss.org/browse/TEIID-1732
Project: Teiid
Issue Type: Bug
Affects Versions: 7.5
Environment: Red Hat Enterprise Linux Server release 5.7 (Tikanga)
JBoss EAP 5.1.1
java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Hi,
When we have people connecting to the native postgres emulation component of teiid (port
35432) using say, perl, or python, they can connect and query stuff fine, but if they give
it a bad query (for exammple, the statement "selectx * from table.name") we see
an error in the server side long saying the syntax is incorrect, but this error is never
passed back to the client. The client just sits there waiting for a response that never
comes.
Can we please have any and all errors returned back to the client correctly?
Thanks,
Graeme
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:55 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1732) Native PG Connector does not pass back errors to client
[
https://issues.jboss.org/browse/TEIID-1732?page=com.atlassian.jira.plugin...
]
Graeme Gillies commented on TEIID-1732:
---------------------------------------
Sure thing.
The following is the perl code I am running against a vdb we have
{code}
#!/usr/bin/env perl
use strict;
use warnings;
use DBI;
use DBD::Pg;
my $dbh =
DBI->connect("dbi:Pg:dbname=BneDS;host=teiid-devel.eng.bne.redhat.com;port=35432",
'teiid', 'teiid', {AutoCommit => 0})
|| die "Could not connect to database: $DBI::errstr";
my $query = <<QUERY;
select * from Bugzilla.bugs limit 2;
QUERY
print "$query";
my $sth = $dbh->prepare($query);
$sth->execute();
while ( my ( $bug_id, $login_name ) = $sth->fetchrow_array() ) {
print "$bug_id,\"$login_name\"\n";
}
$sth->finish();
$dbh->disconnect();
{code}
Note that this problem isn't present if using an ODBC connection. My understanding is,
as of teiid 7.5 port 35432 emulates a native postgres connection as well, so connecting to
it from other languages as per a normal postgres database is possible
Native PG Connector does not pass back errors to client
-------------------------------------------------------
Key: TEIID-1732
URL: https://issues.jboss.org/browse/TEIID-1732
Project: Teiid
Issue Type: Bug
Affects Versions: 7.5
Environment: Red Hat Enterprise Linux Server release 5.7 (Tikanga)
JBoss EAP 5.1.1
java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Hi,
When we have people connecting to the native postgres emulation component of teiid (port
35432) using say, perl, or python, they can connect and query stuff fine, but if they give
it a bad query (for exammple, the statement "selectx * from table.name") we see
an error in the server side long saying the syntax is incorrect, but this error is never
passed back to the client. The client just sits there waiting for a response that never
comes.
Can we please have any and all errors returned back to the client correctly?
Thanks,
Graeme
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:48 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1732) Native PG Connector does not pass back errors to client
[
https://issues.jboss.org/browse/TEIID-1732?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1732:
-------------------------------------
We tested for ODBC driver, but not for the libpq driver for the PG. So, DBI:ODBC will work
fine, but seems like there are still some lingering issues with libpq uses. Is there any
benefit using the DBI:Pg over DBI:ODBC?
Native PG Connector does not pass back errors to client
-------------------------------------------------------
Key: TEIID-1732
URL: https://issues.jboss.org/browse/TEIID-1732
Project: Teiid
Issue Type: Bug
Affects Versions: 7.5
Environment: Red Hat Enterprise Linux Server release 5.7 (Tikanga)
JBoss EAP 5.1.1
java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Hi,
When we have people connecting to the native postgres emulation component of teiid (port
35432) using say, perl, or python, they can connect and query stuff fine, but if they give
it a bad query (for exammple, the statement "selectx * from table.name") we see
an error in the server side long saying the syntax is incorrect, but this error is never
passed back to the client. The client just sits there waiting for a response that never
comes.
Can we please have any and all errors returned back to the client correctly?
Thanks,
Graeme
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:33 a.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1732) Native PG Connector does not pass back errors to client
[
https://issues.jboss.org/browse/TEIID-1732?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1732.
-----------------------------------
Fix Version/s: 7.4.1
7.6
Resolution: Done
The issue is with simple query error handling. It also matters that the sql started with
a malformed keyword. Perl Pg logic will issue an extended query if the sql starts with
"select", but a simple query for "selectx" and other non-recognized
sql. In the simple scenario we were not issuing a ready when an error was encountered.
Also added a minor fix that prevents errors from whitespace at the end of a single
delimited simple query.
Native PG Connector does not pass back errors to client
-------------------------------------------------------
Key: TEIID-1732
URL: https://issues.jboss.org/browse/TEIID-1732
Project: Teiid
Issue Type: Bug
Affects Versions: 7.5
Environment: Red Hat Enterprise Linux Server release 5.7 (Tikanga)
JBoss EAP 5.1.1
java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Fix For: 7.4.1, 7.6
Hi,
When we have people connecting to the native postgres emulation component of teiid (port
35432) using say, perl, or python, they can connect and query stuff fine, but if they give
it a bad query (for exammple, the statement "selectx * from table.name") we see
an error in the server side long saying the syntax is incorrect, but this error is never
passed back to the client. The client just sits there waiting for a response that never
comes.
Can we please have any and all errors returned back to the client correctly?
Thanks,
Graeme
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:24 p.m.
New subject: [JBoss JIRA] (TEIID-1732) Native PG Connector does not pass back errors to client
[
https://issues.jboss.org/browse/TEIID-1732?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1732.
---------------------------------
Native PG Connector does not pass back errors to client
-------------------------------------------------------
Key: TEIID-1732
URL: https://issues.jboss.org/browse/TEIID-1732
Project: Teiid
Issue Type: Bug
Affects Versions: 7.5
Environment: Red Hat Enterprise Linux Server release 5.7 (Tikanga)
JBoss EAP 5.1.1
java version "1.6.0_20"
OpenJDK Runtime Environment (IcedTea6 1.9.8) (rhel-1.22.1.9.8.el5_6-x86_64)
OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Fix For: 7.4.1, 7.6
Hi,
When we have people connecting to the native postgres emulation component of teiid (port
35432) using say, perl, or python, they can connect and query stuff fine, but if they give
it a bad query (for exammple, the statement "selectx * from table.name") we see
an error in the server side long saying the syntax is incorrect, but this error is never
passed back to the client. The client just sits there waiting for a response that never
comes.
Can we please have any and all errors returned back to the client correctly?
Thanks,
Graeme
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4789
days inactive
4881
days old
5 comments
4 participants
participants (4)
-
Graeme Gillies (JIRA) -
Ramesh Reddy (JIRA)
-
Steven Hawkins (Closed) (JIRA)
-
Steven Hawkins (JIRA)