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

[Van Halbert (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13090465#comment-13090465 ] 

Van Halbert commented on TEIID-3578:
------------------------------------

> Maybe we need to look at multiple logging levels for command logging. Using INFO level, just write out the 
Begin/End for the user query, but only write the "END" for source query.

We do distinguish a trace level which provides the query plan as well.
I'm not sure how much value there would be in just omitting the source start events. If you end up putting the source sql in the source end event then the data volume could be similar.

[van] I wasn't thinking of volume, but the number of actual log entries.  And by eliminating 1 for each source query, a 3 source query could go from 8 entries to 5 entries.  That's over 33% reduction in the number of log entries backing up.

> 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, server_startup.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 at 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 at 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)