July 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3578) server becomes unresponsive after running for a while

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3578?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3578: --------------------------------------- Looks like the Teiid related threads are hung up on the logging queue. Do you have a slow / full disk that could be causing issues? > server becomes unresponsive after running for a while > ----------------------------------------------------- > > Key: TEIID-3578 > URL: https://issues.jboss.org/browse/TEIID-3578 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Environment: RHEL 6, AWS VM, JBoss EAP (standalone) 6.3.2.GA > JBoss Data Virtualization 6.1.0.ER4 > Reporter: Jorge Herrera > Assignee: Steven Hawkins > Attachments: server.log, stackTrace_TEIID-3578, threaddump.txt > > > Server becomes unresponsive, it does ack new sessions, but nothing else, admin-console, and direct queries are completely unresponsive. If I reboot the server it works just fine. Disk space / RAM / CPU all seem just fine. > [root@BIJDVDev2 ~]# df > Filesystem 1K-blocks Used Available Use% Mounted on > /dev/xvde1 6062016 4601808 1397596 77% / > none 7619624 0 7619624 0% /dev/shm > [BIJDVDev2.dev.a1.vary.redhat.com] [11:38:48 AM] > [root@BIJDVDev2 ~]# top > top - 11:43:05 up 14 days, 13:31, 1 user, load average: 0.00, 0.00, 0.00 > Tasks: 151 total, 1 running, 150 sleeping, 0 stopped, 0 zombie > Cpu(s): 0.1%us, 0.1%sy, 0.0%ni, 99.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st > Mem: 15239248k total, 5387488k used, 9851760k free, 203540k buffers > Swap: 0k total, 0k used, 0k free, 2887904k cached -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3572) Infinispan-dsl-cache translator: Can't convert 'a' to char using convert function

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3572?page=com.atlassian.jira.plugin... ] Van Halbert closed TEIID-3572. ------------------------------ Resolution: Duplicate Issue This is a duplicate of TEIID-3571 > Infinispan-dsl-cache translator: Can't convert 'a' to char using convert function > --------------------------------------------------------------------------------- > > Key: TEIID-3572 > URL: https://issues.jboss.org/browse/TEIID-3572 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > Attachments: serverLog.txt > > > Sample query: > {code} > select intkey from smalla where charvalue = convert('a',char) > {code} > Log is in the attachment. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3572) Infinispan-dsl-cache translator: Can't convert 'a' to char using convert function

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3572?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3572: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1242952|https://bugzilla.redhat.com/show_bug.cgi?id=1242952] from NEW to CLOSED > Infinispan-dsl-cache translator: Can't convert 'a' to char using convert function > --------------------------------------------------------------------------------- > > Key: TEIID-3572 > URL: https://issues.jboss.org/browse/TEIID-3572 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > Attachments: serverLog.txt > > > Sample query: > {code} > select intkey from smalla where charvalue = convert('a',char) > {code} > Log is in the attachment. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3572) Infinispan-dsl-cache translator: Can't convert 'a' to char using convert function

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3572?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3572: ------------------------------------ Tested this with the latest changes and confirmed there is an issue. > Infinispan-dsl-cache translator: Can't convert 'a' to char using convert function > --------------------------------------------------------------------------------- > > Key: TEIID-3572 > URL: https://issues.jboss.org/browse/TEIID-3572 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > Attachments: serverLog.txt > > > Sample query: > {code} > select intkey from smalla where charvalue = convert('a',char) > {code} > Log is in the attachment. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3578) server becomes unresponsive after running for a while

by Jorge Herrera (JIRA)

[ https://issues.jboss.org/browse/TEIID-3578?page=com.atlassian.jira.plugin... ] Jorge Herrera updated TEIID-3578: --------------------------------- Attachment: threaddump.txt > server becomes unresponsive after running for a while > ----------------------------------------------------- > > Key: TEIID-3578 > URL: https://issues.jboss.org/browse/TEIID-3578 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Environment: RHEL 6, AWS VM, JBoss EAP (standalone) 6.3.2.GA > JBoss Data Virtualization 6.1.0.ER4 > Reporter: Jorge Herrera > Assignee: Steven Hawkins > Attachments: server.log, stackTrace_TEIID-3578, threaddump.txt > > > Server becomes unresponsive, it does ack new sessions, but nothing else, admin-console, and direct queries are completely unresponsive. If I reboot the server it works just fine. Disk space / RAM / CPU all seem just fine. > [root@BIJDVDev2 ~]# df > Filesystem 1K-blocks Used Available Use% Mounted on > /dev/xvde1 6062016 4601808 1397596 77% / > none 7619624 0 7619624 0% /dev/shm > [BIJDVDev2.dev.a1.vary.redhat.com] [11:38:48 AM] > [root@BIJDVDev2 ~]# top > top - 11:43:05 up 14 days, 13:31, 1 user, load average: 0.00, 0.00, 0.00 > Tasks: 151 total, 1 running, 150 sleeping, 0 stopped, 0 zombie > Cpu(s): 0.1%us, 0.1%sy, 0.0%ni, 99.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st > Mem: 15239248k total, 5387488k used, 9851760k free, 203540k buffers > Swap: 0k total, 0k used, 0k free, 2887904k cached -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3573) Infinispan-dsl-cache translator: Operator <> incorrectly handles NULL values

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3573?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3573: ------------------------------------ Reading how to handle this in hibernate, and its indicated to use the IsNull/IsNotNull checks to explicitly consider null handling. Is this something that should recommended? > Infinispan-dsl-cache translator: Operator <> incorrectly handles NULL values > ---------------------------------------------------------------------------- > > Key: TEIID-3573 > URL: https://issues.jboss.org/browse/TEIID-3573 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > > Operator '<>' returns true for NULL <> 1 > Example: > {code} > select intKey,intNum from smallA where intNum<>1 > {code} > It returns also rows which have NULL in column intNum > I believe that NULL <> 1 is not true in SQL. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3570) Infinispan-dsl-cache translator: Incorrect ordering of NULL values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3570?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3570: --------------------------------------- Then this can be marked as resolved from a Teiid perspective. Null ordering is not guaranteed unless the user specifies null first/last. A lesser issue would be to make sure infinispan is consistent with their ordering. > Infinispan-dsl-cache translator: Incorrect ordering of NULL values > ------------------------------------------------------------------ > > Key: TEIID-3570 > URL: https://issues.jboss.org/browse/TEIID-3570 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > Attachments: serverLog.txt > > > NULL values are sorted oddly when using order by clause. > Numeric NULL values seems to be considered as zero. > Date/TimeStamp/Time NULL values are at the beginning, but String NULL values are at the end when sorted. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3570) Infinispan-dsl-cache translator: Incorrect ordering of NULL values

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3570?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3570: ------------------------------------ Not overriding the defaults for null order or supportsOrderByNullOrdering, which are unknown and false, respectively. So unless we disable push down sorting, this will a possible outcome. I have sent JDG group an email asking if there an option that I'm not seeing, such that we can control NULL's first/last. > Infinispan-dsl-cache translator: Incorrect ordering of NULL values > ------------------------------------------------------------------ > > Key: TEIID-3570 > URL: https://issues.jboss.org/browse/TEIID-3570 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Van Halbert > Attachments: serverLog.txt > > > NULL values are sorted oddly when using order by clause. > Numeric NULL values seems to be considered as zero. > Date/TimeStamp/Time NULL values are at the beginning, but String NULL values are at the end when sorted. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3578) server becomes unresponsive after running for a while

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3578?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3578: --------------------------------------- The jstack exception is an entirely separate issue - https://bugzilla.redhat.com/show_bug.cgi?id=1095504 You should be able to get a thread dump with using kill -3 pid > server becomes unresponsive after running for a while > ----------------------------------------------------- > > Key: TEIID-3578 > URL: https://issues.jboss.org/browse/TEIID-3578 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Environment: RHEL 6, AWS VM, JBoss EAP (standalone) 6.3.2.GA > JBoss Data Virtualization 6.1.0.ER4 > Reporter: Jorge Herrera > Assignee: Steven Hawkins > Attachments: server.log, stackTrace_TEIID-3578 > > > Server becomes unresponsive, it does ack new sessions, but nothing else, admin-console, and direct queries are completely unresponsive. If I reboot the server it works just fine. Disk space / RAM / CPU all seem just fine. > [root@BIJDVDev2 ~]# df > Filesystem 1K-blocks Used Available Use% Mounted on > /dev/xvde1 6062016 4601808 1397596 77% / > none 7619624 0 7619624 0% /dev/shm > [BIJDVDev2.dev.a1.vary.redhat.com] [11:38:48 AM] > [root@BIJDVDev2 ~]# top > top - 11:43:05 up 14 days, 13:31, 1 user, load average: 0.00, 0.00, 0.00 > Tasks: 151 total, 1 running, 150 sleeping, 0 stopped, 0 zombie > Cpu(s): 0.1%us, 0.1%sy, 0.0%ni, 99.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st > Mem: 15239248k total, 5387488k used, 9851760k free, 203540k buffers > Swap: 0k total, 0k used, 0k free, 2887904k cached -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3578) server becomes unresponsive after running for a while

by Jorge Herrera (JIRA)

[ https://issues.jboss.org/browse/TEIID-3578?page=com.atlassian.jira.plugin... ] Jorge Herrera updated TEIID-3578: --------------------------------- Attachment: server.log stackTrace_TEIID-3578 > server becomes unresponsive after running for a while > ----------------------------------------------------- > > Key: TEIID-3578 > URL: https://issues.jboss.org/browse/TEIID-3578 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.1 > Environment: RHEL 6, AWS VM, JBoss EAP (standalone) 6.3.2.GA > JBoss Data Virtualization 6.1.0.ER4 > Reporter: Jorge Herrera > Assignee: Steven Hawkins > Attachments: server.log, stackTrace_TEIID-3578 > > > Server becomes unresponsive, it does ack new sessions, but nothing else, admin-console, and direct queries are completely unresponsive. If I reboot the server it works just fine. Disk space / RAM / CPU all seem just fine. > [root@BIJDVDev2 ~]# df > Filesystem 1K-blocks Used Available Use% Mounted on > /dev/xvde1 6062016 4601808 1397596 77% / > none 7619624 0 7619624 0% /dev/shm > [BIJDVDev2.dev.a1.vary.redhat.com] [11:38:48 AM] > [root@BIJDVDev2 ~]# top > top - 11:43:05 up 14 days, 13:31, 1 user, load average: 0.00, 0.00, 0.00 > Tasks: 151 total, 1 running, 150 sleeping, 0 stopped, 0 zombie > Cpu(s): 0.1%us, 0.1%sy, 0.0%ni, 99.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st > Mem: 15239248k total, 5387488k used, 9851760k free, 203540k buffers > Swap: 0k total, 0k used, 0k free, 2887904k cached -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 5 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2015