[JBoss JIRA] (TEIID-2477) Standardize and correct jdbc database version comparisons
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-2477?page=com.atlassian.jira.plugin... ]
Johnathon Lee updated TEIID-2477:
---------------------------------
Fix Version/s: 7.7.10
> Standardize and correct jdbc database version comparisons
> ---------------------------------------------------------
>
> Key: TEIID-2477
> URL: https://issues.jboss.org/browse/TEIID-2477
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: JDBC Connector
> Affects Versions: 7.0
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4, 7.7.10
>
>
> The simple string comparison of versions is not correct across version numbers of differing digits (10 is not higher than 9). Generally the field needs standardized as well since for example we use the year designations for SQL Server but the driver reported version numbers will be the actual software versions.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 9 months
[JBoss JIRA] (TEIID-2477) Standardize and correct jdbc database version comparisons
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-2477?page=com.atlassian.jira.plugin... ]
Johnathon Lee closed TEIID-2477.
--------------------------------
Resolution: Done
> Standardize and correct jdbc database version comparisons
> ---------------------------------------------------------
>
> Key: TEIID-2477
> URL: https://issues.jboss.org/browse/TEIID-2477
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: JDBC Connector
> Affects Versions: 7.0
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 7.7.10, 8.4
>
>
> The simple string comparison of versions is not correct across version numbers of differing digits (10 is not higher than 9). Generally the field needs standardized as well since for example we use the year designations for SQL Server but the driver reported version numbers will be the actual software versions.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 9 months
[JBoss JIRA] (TEIID-2477) Standardize and correct jdbc database version comparisons
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-2477?page=com.atlassian.jira.plugin... ]
Johnathon Lee reopened TEIID-2477:
----------------------------------
re-open for fix version
> Standardize and correct jdbc database version comparisons
> ---------------------------------------------------------
>
> Key: TEIID-2477
> URL: https://issues.jboss.org/browse/TEIID-2477
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: JDBC Connector
> Affects Versions: 7.0
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4
>
>
> The simple string comparison of versions is not correct across version numbers of differing digits (10 is not higher than 9). Generally the field needs standardized as well since for example we use the year designations for SQL Server but the driver reported version numbers will be the actual software versions.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 9 months
[JBoss JIRA] (TEIID-2636) Stream corruption errors when doing big query
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-2636?page=com.atlassian.jira.plugin... ]
Johnathon Lee updated TEIID-2636:
---------------------------------
Fix Version/s: 7.7.10
> Stream corruption errors when doing big query
> ---------------------------------------------
>
> Key: TEIID-2636
> URL: https://issues.jboss.org/browse/TEIID-2636
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.4
> Environment: Teiid 8.5 Beta2 Running in JBoss EAP 6.1 on RHEL6
> Java 7 openjdk
> Reporter: Graeme Gillies
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.5, 7.7.10
>
> Attachments: server.log
>
>
> Hi,
> When performing the following big query against a virtual db we have setup in this environment, we get an error
> The query is
> {noformat}
> SELECT
> bugs.bug_id, classification.name, bugs.cf_internal_whiteboard,
> dev_cond_nak_grouped."value", partner_grouped."value",
> bugs.cf_last_closed, bugs.bug_severity, bugs.cf_qa_whiteboard,
> bugs.short_desc, qe_cond_nak_grouped."value", bugs.priority,
> bugs.version, bugs.cf_pm_score, bugs.bug_status, product.name,
> blocks_grouped.blocked, qa_contact.login_name, reporter.login_name,
> component.name, flag_grouped.flag_full, bugs.delta_ts,
> dependson_grouped.dependson, verified_grouped."value",
> bugs.creation_ts, bugs.cf_devel_whiteboard, keyword_grouped.name,
> target_release_grouped."value", bugs.target_milestone, assigned_to.login_name,
> bugs.resolution
> FROM Bugzilla_raw.bugs
> LEFT JOIN Bugzilla_raw.products ON products.id = bugs.product_id
> LEFT JOIN Bugzilla_raw.classifications classification ON classification.id = products.classification_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(dev_cond_nak."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_conditional_nak dev_cond_nak ON dev_cond_nak.bug_id = bugs.bug_id GROUP BY bugs.bug_id) dev_cond_nak_grouped ON bugs.bug_id = dev_cond_nak_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(partner."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_partner partner ON partner.bug_id = bugs.bug_id GROUP BY bugs.bug_id) partner_grouped ON bugs.bug_id = partner_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(qe_cond_nak."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_qe_conditional_nak qe_cond_nak ON qe_cond_nak.bug_id = bugs.bug_id GROUP BY bugs.bug_id) qe_cond_nak_grouped ON bugs.bug_id = qe_cond_nak_grouped.bug_id
> LEFT JOIN Bugzilla_raw.products product ON product.id = bugs.product_id LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(blocks.blocked)) AS blocked FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.dependencies blocks ON blocks.dependson = bugs.bug_id GROUP BY bugs.bug_id) blocks_grouped ON bugs.bug_id = blocks_grouped.bug_id
> LEFT JOIN Bugzilla_raw.profiles qa_contact ON qa_contact.userid = bugs.qa_contact LEFT JOIN Bugzilla_raw.profiles reporter ON reporter.userid = bugs.reporter LEFT JOIN Bugzilla_raw.components component ON component.id = bugs.component_id LEFT JOIN ( SELECT flags.bug_id, TEXTAGG(FOR(concat(ft.name, flags.status))) AS flag_full FROM Bugzilla_raw.flags
> LEFT JOIN Bugzilla_raw.flagtypes ft ON ft.id = flags.type_id GROUP BY flags.bug_id) flag_grouped ON bugs.bug_id = flag_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(dependson.dependson)) AS dependson FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.dependencies dependson ON dependson.blocked = bugs.bug_id GROUP BY bugs.bug_id) dependson_grouped ON bugs.bug_id = dependson_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(verified."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_verified verified ON verified.bug_id = bugs.bug_id GROUP BY bugs.bug_id) verified_grouped ON bugs.bug_id = verified_grouped.bug_id
> LEFT JOIN ( SELECT keywords.bug_id, TEXTAGG(FOR(kw.name)) AS name FROM Bugzilla_raw.keywords LEFT JOIN Bugzilla_raw.keyworddefs kw ON kw.id = keywords.keywordid GROUP BY keywords.bug_id) keyword_grouped ON bugs.bug_id = keyword_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(target_release."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bugs_release target_release ON target_release.bug_id = bugs.bug_id GROUP BY bugs.bug_id) target_release_grouped ON bugs.bug_id = target_release_grouped.bug_id
> LEFT JOIN Bugzilla_raw.profiles assigned_to ON assigned_to.userid = bugs.assigned_to
> WHERE bugs.bug_id > 990410 OR bugs.delta_ts > parseTimestamp('2013-07-31 06:57:31 +0000', 'yyyy-MM-dd HH:mm:ss z')
> LIMIT 0,1000000
> {noformat}
> The error the client sees is
> ERROR: TEIID30048 Error reading 24,668
> DETAIL: org.teiid.jdbc.TeiidSQLException: TEIID30048 Error reading 24,668
> This is using the Postgresql ODBC interface or the JDBC interface
> The errors in the log file are quite long so I will attach the whole log file.
> Regards,
> Graeme
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 9 months
[JBoss JIRA] (TEIID-2636) Stream corruption errors when doing big query
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-2636?page=com.atlassian.jira.plugin... ]
Johnathon Lee closed TEIID-2636.
--------------------------------
Resolution: Done
> Stream corruption errors when doing big query
> ---------------------------------------------
>
> Key: TEIID-2636
> URL: https://issues.jboss.org/browse/TEIID-2636
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.4
> Environment: Teiid 8.5 Beta2 Running in JBoss EAP 6.1 on RHEL6
> Java 7 openjdk
> Reporter: Graeme Gillies
> Assignee: Steven Hawkins
> Fix For: 7.7.10, 8.5, 8.4.1
>
> Attachments: server.log
>
>
> Hi,
> When performing the following big query against a virtual db we have setup in this environment, we get an error
> The query is
> {noformat}
> SELECT
> bugs.bug_id, classification.name, bugs.cf_internal_whiteboard,
> dev_cond_nak_grouped."value", partner_grouped."value",
> bugs.cf_last_closed, bugs.bug_severity, bugs.cf_qa_whiteboard,
> bugs.short_desc, qe_cond_nak_grouped."value", bugs.priority,
> bugs.version, bugs.cf_pm_score, bugs.bug_status, product.name,
> blocks_grouped.blocked, qa_contact.login_name, reporter.login_name,
> component.name, flag_grouped.flag_full, bugs.delta_ts,
> dependson_grouped.dependson, verified_grouped."value",
> bugs.creation_ts, bugs.cf_devel_whiteboard, keyword_grouped.name,
> target_release_grouped."value", bugs.target_milestone, assigned_to.login_name,
> bugs.resolution
> FROM Bugzilla_raw.bugs
> LEFT JOIN Bugzilla_raw.products ON products.id = bugs.product_id
> LEFT JOIN Bugzilla_raw.classifications classification ON classification.id = products.classification_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(dev_cond_nak."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_conditional_nak dev_cond_nak ON dev_cond_nak.bug_id = bugs.bug_id GROUP BY bugs.bug_id) dev_cond_nak_grouped ON bugs.bug_id = dev_cond_nak_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(partner."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_partner partner ON partner.bug_id = bugs.bug_id GROUP BY bugs.bug_id) partner_grouped ON bugs.bug_id = partner_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(qe_cond_nak."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_qe_conditional_nak qe_cond_nak ON qe_cond_nak.bug_id = bugs.bug_id GROUP BY bugs.bug_id) qe_cond_nak_grouped ON bugs.bug_id = qe_cond_nak_grouped.bug_id
> LEFT JOIN Bugzilla_raw.products product ON product.id = bugs.product_id LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(blocks.blocked)) AS blocked FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.dependencies blocks ON blocks.dependson = bugs.bug_id GROUP BY bugs.bug_id) blocks_grouped ON bugs.bug_id = blocks_grouped.bug_id
> LEFT JOIN Bugzilla_raw.profiles qa_contact ON qa_contact.userid = bugs.qa_contact LEFT JOIN Bugzilla_raw.profiles reporter ON reporter.userid = bugs.reporter LEFT JOIN Bugzilla_raw.components component ON component.id = bugs.component_id LEFT JOIN ( SELECT flags.bug_id, TEXTAGG(FOR(concat(ft.name, flags.status))) AS flag_full FROM Bugzilla_raw.flags
> LEFT JOIN Bugzilla_raw.flagtypes ft ON ft.id = flags.type_id GROUP BY flags.bug_id) flag_grouped ON bugs.bug_id = flag_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(dependson.dependson)) AS dependson FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.dependencies dependson ON dependson.blocked = bugs.bug_id GROUP BY bugs.bug_id) dependson_grouped ON bugs.bug_id = dependson_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(verified."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_verified verified ON verified.bug_id = bugs.bug_id GROUP BY bugs.bug_id) verified_grouped ON bugs.bug_id = verified_grouped.bug_id
> LEFT JOIN ( SELECT keywords.bug_id, TEXTAGG(FOR(kw.name)) AS name FROM Bugzilla_raw.keywords LEFT JOIN Bugzilla_raw.keyworddefs kw ON kw.id = keywords.keywordid GROUP BY keywords.bug_id) keyword_grouped ON bugs.bug_id = keyword_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(target_release."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bugs_release target_release ON target_release.bug_id = bugs.bug_id GROUP BY bugs.bug_id) target_release_grouped ON bugs.bug_id = target_release_grouped.bug_id
> LEFT JOIN Bugzilla_raw.profiles assigned_to ON assigned_to.userid = bugs.assigned_to
> WHERE bugs.bug_id > 990410 OR bugs.delta_ts > parseTimestamp('2013-07-31 06:57:31 +0000', 'yyyy-MM-dd HH:mm:ss z')
> LIMIT 0,1000000
> {noformat}
> The error the client sees is
> ERROR: TEIID30048 Error reading 24,668
> DETAIL: org.teiid.jdbc.TeiidSQLException: TEIID30048 Error reading 24,668
> This is using the Postgresql ODBC interface or the JDBC interface
> The errors in the log file are quite long so I will attach the whole log file.
> Regards,
> Graeme
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 9 months
[JBoss JIRA] (TEIID-2636) Stream corruption errors when doing big query
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-2636?page=com.atlassian.jira.plugin... ]
Johnathon Lee reopened TEIID-2636:
----------------------------------
re-open for fix version
> Stream corruption errors when doing big query
> ---------------------------------------------
>
> Key: TEIID-2636
> URL: https://issues.jboss.org/browse/TEIID-2636
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.4
> Environment: Teiid 8.5 Beta2 Running in JBoss EAP 6.1 on RHEL6
> Java 7 openjdk
> Reporter: Graeme Gillies
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.5
>
> Attachments: server.log
>
>
> Hi,
> When performing the following big query against a virtual db we have setup in this environment, we get an error
> The query is
> {noformat}
> SELECT
> bugs.bug_id, classification.name, bugs.cf_internal_whiteboard,
> dev_cond_nak_grouped."value", partner_grouped."value",
> bugs.cf_last_closed, bugs.bug_severity, bugs.cf_qa_whiteboard,
> bugs.short_desc, qe_cond_nak_grouped."value", bugs.priority,
> bugs.version, bugs.cf_pm_score, bugs.bug_status, product.name,
> blocks_grouped.blocked, qa_contact.login_name, reporter.login_name,
> component.name, flag_grouped.flag_full, bugs.delta_ts,
> dependson_grouped.dependson, verified_grouped."value",
> bugs.creation_ts, bugs.cf_devel_whiteboard, keyword_grouped.name,
> target_release_grouped."value", bugs.target_milestone, assigned_to.login_name,
> bugs.resolution
> FROM Bugzilla_raw.bugs
> LEFT JOIN Bugzilla_raw.products ON products.id = bugs.product_id
> LEFT JOIN Bugzilla_raw.classifications classification ON classification.id = products.classification_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(dev_cond_nak."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_conditional_nak dev_cond_nak ON dev_cond_nak.bug_id = bugs.bug_id GROUP BY bugs.bug_id) dev_cond_nak_grouped ON bugs.bug_id = dev_cond_nak_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(partner."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_partner partner ON partner.bug_id = bugs.bug_id GROUP BY bugs.bug_id) partner_grouped ON bugs.bug_id = partner_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(qe_cond_nak."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_qe_conditional_nak qe_cond_nak ON qe_cond_nak.bug_id = bugs.bug_id GROUP BY bugs.bug_id) qe_cond_nak_grouped ON bugs.bug_id = qe_cond_nak_grouped.bug_id
> LEFT JOIN Bugzilla_raw.products product ON product.id = bugs.product_id LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(blocks.blocked)) AS blocked FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.dependencies blocks ON blocks.dependson = bugs.bug_id GROUP BY bugs.bug_id) blocks_grouped ON bugs.bug_id = blocks_grouped.bug_id
> LEFT JOIN Bugzilla_raw.profiles qa_contact ON qa_contact.userid = bugs.qa_contact LEFT JOIN Bugzilla_raw.profiles reporter ON reporter.userid = bugs.reporter LEFT JOIN Bugzilla_raw.components component ON component.id = bugs.component_id LEFT JOIN ( SELECT flags.bug_id, TEXTAGG(FOR(concat(ft.name, flags.status))) AS flag_full FROM Bugzilla_raw.flags
> LEFT JOIN Bugzilla_raw.flagtypes ft ON ft.id = flags.type_id GROUP BY flags.bug_id) flag_grouped ON bugs.bug_id = flag_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(dependson.dependson)) AS dependson FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.dependencies dependson ON dependson.blocked = bugs.bug_id GROUP BY bugs.bug_id) dependson_grouped ON bugs.bug_id = dependson_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(verified."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_verified verified ON verified.bug_id = bugs.bug_id GROUP BY bugs.bug_id) verified_grouped ON bugs.bug_id = verified_grouped.bug_id
> LEFT JOIN ( SELECT keywords.bug_id, TEXTAGG(FOR(kw.name)) AS name FROM Bugzilla_raw.keywords LEFT JOIN Bugzilla_raw.keyworddefs kw ON kw.id = keywords.keywordid GROUP BY keywords.bug_id) keyword_grouped ON bugs.bug_id = keyword_grouped.bug_id
> LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(target_release."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bugs_release target_release ON target_release.bug_id = bugs.bug_id GROUP BY bugs.bug_id) target_release_grouped ON bugs.bug_id = target_release_grouped.bug_id
> LEFT JOIN Bugzilla_raw.profiles assigned_to ON assigned_to.userid = bugs.assigned_to
> WHERE bugs.bug_id > 990410 OR bugs.delta_ts > parseTimestamp('2013-07-31 06:57:31 +0000', 'yyyy-MM-dd HH:mm:ss z')
> LIMIT 0,1000000
> {noformat}
> The error the client sees is
> ERROR: TEIID30048 Error reading 24,668
> DETAIL: org.teiid.jdbc.TeiidSQLException: TEIID30048 Error reading 24,668
> This is using the Postgresql ODBC interface or the JDBC interface
> The errors in the log file are quite long so I will attach the whole log file.
> Regards,
> Graeme
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
11 years, 9 months