[
https://issues.jboss.org/browse/TEIID-3578?page=com.atlassian.jira.plugin...
]
Steven Hawkins 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.
For demo's, it looks good because you can then use the Dashboard
to view the logs. But it may not be the best option in all use cases.
Yes, using the db logging option in general is not something that should be done in a
production scenario. Even having command logging turned on in production would be
specific to debugging an issue that is not reproducible in a staging environment or there
is some specific need for a post audit.
However it's hard to say what exactly is going on in this particular case other than
the teiid threads are blocking on the logging queue as confirmed above by Ramesh.
There's no indication as to why the db appender is waiting on the session bean or
service registry threads are waiting. These states have occurred for others:
https://developer.jboss.org/thread/173023
https://issues.jboss.org/secure/attachment/12389923/stuck-deploy-eap-jsta... /
https://issues.jboss.org/browse/JBIDE-19641
So we'd need to see what versions are affected and how Teiid or his environment is
contributing.
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)