Best unofficial Apache Server developers community

List archives

Rebalance stuck?

Improved version of PHP MogileFS client
(10 lines)

MogileFS::Network and mindevcount=0
(44 lines)

Sep 8, 2010

Martijn Lina

Hi,

I have a problem with enable_rebalance. It seems that after a while it
stopped
working. Now i read in Store.pm about List::Util::shuffle() not being
really
random, is this still true?

I've also setup a test environment to analyse the rebalance problems and
after
three days i'm still not very sure why it also seems to get stuck with only
14
files. The current device usage situation is as follows:

Checking devices...
  host device         size(G)    used(G)    free(G)   use%   ob state  
I/O%
  ---- ------------ ---------- ---------- ---------- ------ ----------
-----
  [ 1] dev1             0.176      0.055      0.121  31.01%  writeable  
0.0
  [ 1] dev2             0.176      0.074      0.102  42.16%  writeable  
0.0
  [ 2] dev4             0.176      0.128      0.048  72.51%  writeable  
0.0
  [ 3] dev3             0.176      0.123      0.053  70.03%  writeable  
0.0
  ---- ------------ ---------- ---------- ---------- ------
             total:     0.703      0.379      0.324  53.93%

where the devices are spread along the three hosts like this:

virtualmedia1 [1]: alive
                   used(G) free(G) total(G)
  dev1: alive      0.054   0.122   0.176  
  dev2: alive      0.073   0.103   0.176  

virtualmedia2 [2]: alive
                   used(G) free(G) total(G)
  dev4: alive      0.127   0.049   0.176  

virtualmedia3 [3]: alive
                   used(G) free(G) total(G)
  dev3: alive      0.123   0.053   0.176  


I've set enable_rebalance=1 and never gets reset. For all rebalance attemps
it says:

Rebalance for DevFID[d=3;f=36]
(http://192.168.210.1:7500/dev3/0/000/000/0000000036.fid) failed: no
suitable destination devices available

and it seems it tries to itterate over all fids endlessly.

Could someone possibly shed some light on this? In our production
environment
we have a new server on which each device is full for only 9% while the
other
two are filled around 80% and rebalance doesn't work there either. We
really
need this because we pay bandwith per server (if we consume too much) so we
really need to get this balanced.


thanks in advance,

Martijn

Tags:

analyseenvironmenttestsetup

Messages in this thread

Rebalance stuck?

Re: Rebalance stuck?
(7 lines) Sep 8, 2010 11:20

Re: Rebalance stuck?
(45 lines) Sep 9, 2010 03:01

Re: Rebalance stuck?
(80 lines) Sep 9, 2010 03:31

Re: Rebalance stuck?
(115 lines) Sep 9, 2010 04:30

Re: Rebalance stuck?
(131 lines) Sep 9, 2010 09:59

Re: Rebalance stuck?
(156 lines) Sep 9, 2010 10:34

Re: Rebalance stuck?
(174 lines) Sep 9, 2010 17:52

mid
Similar news articles

Similar Threads

Re: Does anyone actively use rebalance?
Re: source socket, rebalance issues
source socket, rebalance issues
stuck confused an need help please
Hudson stuck?
db.repairDatabase() seems stuck
Help : Jackrabbit/Lucene get stuck
DO NOT REPLY New: Borrowers Getting Stuck
nodetool move looks stuck
Help! Cassandra Data Loader threads are getting stuck
Apache getting stuck with all workers in a BUSY_READ state
Updated: (AMQ-2614) After failover some messages are stuck in the new broker
REGEX - Long running thread - stuck at RE.java
Created: (MAPREDUCE-1950) Jetty Acceptor can stuck TaskTracker forever

Re: Does anyone actively use rebalance?

Rebalance has been immensely useful to us. When adding new storage
nodes, we are able to mitigate the damage from HD failures, are able
to add nodes more sparingly, and just generally balances out load
across storage nodes.

( 12 storage nodes, 6 drives each if it helps )

On Wed, Jul 14, 2010 at 3:12 AM, dormando <dorm### @rydia.net>
wrote:
 Hey,

 Are there any of you out there who active use the existing
"rebalance"
 feature and have measureable benefits from it? Please confirm that
you
 aren't just running it because it felt like a good idea, and that you
 actually get results from it?

 I have a larger plan for rewriting rebalance by wiring it over the
new
 drain code, but I can also just get the new drain code out very
quickly
 which will fix many problems for many people.

 However in the process I might disable/destroy the existing rebalance
 code, and it'll stay that way until we can finish writing the
rebalance
 stuff on top of it.

 If there're enough complainers I'll try to not break the old code, or
just
 wait until I can replace all of it at once...

 Thanks,
 -Dormando

Re: source socket, rebalance issues

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 8/23/10 12:24 PM, dormando wrote:
> It looks like the maxconns default is 10K and I don't set it
explicitly.
>  I assume that is connections that would show up in netstat?  I'm
seeing
> less than 1K active connections there.
>
> I'm even seeing this occasionally:
>
> ro### @a0100:/etc/mogilefs# mogadm check
> Checking trackers...
>   127.0.0.1:7001 ... REQUEST FAILURE (is the tracker up?)
> Unable to retrieve host information from tracker(s).
>

 Is it hovering around 1k as in suspiciously close to 1k? or well
below 1k?
 There's a chance that it would have failed to increase the maxconns
if not
 started from root or from a user with adjusted maxconns.

Actually, I just changed my methodology slightly to weed out the
TIME_WAITS and other stuff and now run:

netstat -anp | grep mogstored | wc -l

and now see only 300-400 sockets open and still see timeouts when I !watch

 when you run mogadm check, is it failing immediately or does it feel
like
 a timeout?

When it fails, which is probably only 5% of the time, it seems to do so
pretty quickly, which could be in about 2s.  When I normally do a
"mogadm check" there's a bit of a pause before it returns "ok" and when
it fails the pause length is about the same amount of time.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iD8DBQFMcwP6+Idx1gGGQ1YRAmnjAJ4qL+0yWP/gPcxP+rJPI4rlRCWIbACfQuLr
TfXVy4kxju3kvaatxo/cXrU=
=ohD5
-----END PGP SIGNATURE-----

source socket, rebalance issues

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I'm running mogilefs 2.30 with 14 hosts with 4 devices each. When I
!watch on one of my trackers, I see lots (several to many a minute) of
messages like these:

:: [replicate(9979)] Unable to create source socket to 10.2.128.90:7500
for /dev90128/0/670/784/0670784277.fid
:: [replicate(9979)] Failed copying fid 670784277 from devid 90128 to
devid 96208 (error type: src_error)
:: [replicate(9979)] copy_error: error copying fid 670784277 from devid
90128 during replication
:: [replicate(9977)] Unable to create source socket to 10.2.131.210:7500
for /dev210321/0/670/783/0670783216.fid
:: [replicate(9977)] Failed copying fid 670783216 from devid 210321 to
devid 96208 (error type: src_error)

I ran a fsck a while ago(now long completed, according to status) and
occasionally see lines like this:

:: [fsck(9970)] node 10.2.128.90 seems to be down in get_file_size
:: [fsck(9970)] Connectivity problem reaching device 90228 on host
10.2.128.90

very rarely do I actually see real monitor timeouts.

mogadm check shows the cluster is fairly bored with not much IO on the
hosts. The DB machine isn't overloaded, either. I'm using the zonelocal
and network plugins.

I'm also noticing that I have a significant number of files way over
replicated.  My replication policy has a max of 4 for any class,
however, out of my 212Mn files in mogilefs, about 2.5Mn have 10 or more
copies.  Many millions more are replicated 6 times or more.

I added some new nodes and ran a rebalanace.  After only a couple of
percents it would stop.  So, I start it again but it stops after a
couple more percents, repeat.

Any thoughts appreciated.

here's some more info:

!stats
uptime 8367694
pending_queries 0
processing_queries 0
bored_queryworkers 10
queries 2648773
work_queue_for_delete 70
work_queue_for_fsck 150
work_queue_for_replicate 10

!jobs
delete count 1
delete desired 1
delete pids 21633
fsck count 1
fsck desired 1
fsck pids 9970
job_master count 1
job_master desired 1
job_master pids 9971
monitor count 1
monitor desired 1
monitor pids 9986
queryworker count 10
queryworker desired 10
queryworker pids 533 1976 2957 12534 22680 24926 27103 27710 28132 29976
reaper count 1
reaper desired 1
reaper pids 22503
replicate count 5
replicate desired 5
replicate pids 9965 10016 14167 14317 31029


mogilefsd.conf:
db_dsn = DBI:mysql:blah:blah
local_network = 10.0.128.0/22

db_user = ...
db_pass = ...
listen = 0.0.0.0:7001
conf_port = 7001
listener_jobs = 10
delete_jobs = 1
replicate_jobs = 5
mog_root = /var/lib/mogdata
reaper_jobs = 1
plugins = ZoneLocal

mogstored.conf:
httplisten=0.0.0.0:7500
mgmtlisten=0.0.0.0:7501
docroot=/var/lib/mogdata

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iD8DBQFMbYNa+Idx1gGGQ1YRAgyEAJ9Rxjbo9ajioA3cb8iRJWJLpG19egCfXzxA
ot3kTHy2+5k5ZRmxpvWD1tw=
=e/jJ
-----END PGP SIGNATURE-----

stuck confused an need help please

I am trying to tweak my web application at thejarbar.org to be bug free.
Currrntly here is an issue whn clicking the "tutorials button as you can
view in your browser.  I am getting some kind of exceptions as ell listed
in the following stack trace and don't know how to osolve after days of
trying. I have been getting mysql SELECT privilege denied exception even
though user has all access to database.

the code behind the tutorial is as follows:

    package org.bar.jar.backing;

import org.bar.jar.model.UsercommentsEntity;
import org.bar.jar.util.HibernateUtil;
import org.hibernate.Session;

import java.util.List;

/**
 * Created by IntelliJ IDEA.
 * User: owner
 * Date: 15-May-2010
 * Time: 16:20:17
 * To change this template use File | Settings | File Templates.
 */
public class tutorialIndexBacking {
    private List<UsercommentsEntity> allUnflaggedComments;

    public List<UsercommentsEntity> getAllUnflaggedComments() {
        Session session =
HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        List<UsercommentsEntity> allUnflaggedComments =
(List<UsercommentsEntity>) session.createQuery("select uce from 
UsercommentsEntity  as uce where   uce.pageId = 'tutorialIndex' order by
uce.datemade desc").list();
        session.getTransaction().commit();
        return allUnflaggedComments;

As a first timer I would likw to know how a typical hibernate webapp is
moved from development to production please have  a look at the page if you
have the time

here is a log of all errors related to clicking that link

INFO main org.apache.catalina.startup.Catalina - Initialization processed
in 
344 ms
INFO main org.apache.catalina.core.StandardService - Starting service 
Catalina
INFO main org.apache.catalina.core.StandardEngine - Starting Servlet
Engine: 
Apache Tomcat/6.0.20
ERROR main org.apache.catalina.core.ContainerBase.[Catalina] - Exception 
opening database connection
java.sql.SQLException: Access denied for user ' yucca123_tom'@'localhost' 
(using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:703)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:775)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1037)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at 
org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)
INFO main org.apache.catalina.core.StandardContext - The listener 
"com.sun.faces.config.ConfigureListener" is already configured for this 
context. The duplicate definition has been ignored.
INFO main org.apache.catalina.core.StandardContext - The listener 
"com.sun.faces.config.ConfigureListener" is already configured for this 
context. The duplicate definition has been ignored.
INFO main org.apache.catalina.startup.Catalina - Server startup in 2326 ms
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: 
create table jarbartest.user_roles (user_name varchar not null, role_name 
varchar not null, primary key (user_name, role_name))
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - You have an 
error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near 'not null, role_name
varchar 
not null, primary key (user_name, role_name))' at line 1
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: 
create table jarbartest.usercomments (commentID int unsigned not null, 
commentMade varchar not null, dateMade datetime not null, flagged bit not 
null, page_id varchar not null, made_by varchar(20) not null, primary key 
(commentID))
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - You have an 
error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near 'not null, dateMade
datetime 
not null, flagged bit not null, page_id varchar not ' at line 1
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: 
create table jarbartest.users (user_name varchar not null, first_name 
varchar not null, last_name varchar not null, user_email varchar not null,

ip_address varchar not null, user_pass varchar not null, primary key 
(user_name))
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - You have an 
error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near 'not null, first_name 
varchar not null, last_name varchar not null, user_email va' at line 1
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: 
alter table jarbartest.usercomments add index FKAA77CEBF792FED2F
(made_by), 
add constraint FKAA77CEBF792FED2F foreign key (made_by) references 
jarbartest.users (user_name)
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - ALTER
command 
denied to user 'yucca123_hiber'@'localhost' for table 'usercomments'
ERROR TP-Processor2 org.hibernate.util.JDBCExceptionReporter - SELECT 
command denied to user 'yucca123_hiber'@'localhost' for table
'usercomments'
ERROR TP-Processor2 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[Faces

Servlet] - Servlet.service() for servlet Faces Servlet threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command 
denied to user 'yucca123_hiber'@'localhost' for table 'usercomments'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at 
org.bar.jar.backing.tutorialIndexBacking.getAllUnflaggedComments(tutorialIndexBacking.java:22)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
at 
com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
at org.apache.el.parser.AstValue.getValue(AstValue.java:118)
at
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at 
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
at javax.faces.component.UIData.getValue(UIData.java:614)
at javax.faces.component.UIData.getDataModel(UIData.java:1145)
at javax.faces.component.UIData.setRowIndex(UIData.java:451)
at 
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:77)
at 
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:813)
at javax.faces.component.UIData.encodeBegin(UIData.java:983)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:928)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
at 
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
at 
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
at 
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor2 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[jsp]
 
- Servlet.service() for servlet jsp threw exception
java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor2 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org] - 
Exception Processing ErrorPage[exceptionType=java.lang.Throwable, 
location=/oops.jsp]
org.apache.jasper.JasperException: java.lang.RuntimeException: Cannot find

FacesContext
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:418)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
... 22 more
ERROR TP-Processor2 org.hibernate.util.JDBCExceptionReporter - 
Communications link failure

The last packet successfully received from the server was 1,201,712 
milliseconds ago.  The last packet sent successfully to the server was 1 
milliseconds ago.
ERROR TP-Processor2 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[Faces

Servlet] - Servlet.service() for servlet Faces Servlet threw exception
java.io.EOFException: Can not read response from server. Expected to read
4 
bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2953)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2942)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3485)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at 
org.bar.jar.backing.tutorialIndexBacking.getAllUnflaggedComments(tutorialIndexBacking.java:22)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
at 
com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
at org.apache.el.parser.AstValue.getValue(AstValue.java:118)
at
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at 
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
at javax.faces.component.UIData.getValue(UIData.java:614)
at javax.faces.component.UIData.getDataModel(UIData.java:1145)
at javax.faces.component.UIData.setRowIndex(UIData.java:451)
at 
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:77)
at 
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:813)
at javax.faces.component.UIData.encodeBegin(UIData.java:983)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:928)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
at 
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
at 
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
at 
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor2 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[jsp]
 
- Servlet.service() for servlet jsp threw exception
java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor2 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org] - 
Exception Processing ErrorPage[exceptionType=java.lang.Throwable, 
location=/oops.jsp]
org.apache.jasper.JasperException: java.lang.RuntimeException: Cannot find

FacesContext
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:418)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
... 22 more
INFO main org.apache.catalina.core.StandardService - Stopping service 
Catalina
INFO main org.apache.catalina.startup.Catalina - Initialization processed
in 
330 ms
INFO main org.apache.catalina.core.StandardService - Starting service 
Catalina
INFO main org.apache.catalina.core.StandardEngine - Starting Servlet
Engine: 
Apache Tomcat/6.0.20
ERROR main org.apache.catalina.core.ContainerBase.[Catalina] - Exception 
opening database connection
java.sql.SQLException: Access denied for user ' yucca123_tom'@'localhost' 
(using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
at 
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:703)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:775)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1037)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at 
org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)
INFO main org.apache.catalina.core.StandardContext - The listener 
"com.sun.faces.config.ConfigureListener" is already configured for this 
context. The duplicate definition has been ignored.
INFO main org.apache.catalina.core.StandardContext - The listener 
"com.sun.faces.config.ConfigureListener" is already configured for this 
context. The duplicate definition has been ignored.
INFO main org.apache.catalina.startup.Catalina - Server startup in 1690 ms
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: 
create table jarbartest.user_roles (user_name varchar not null, role_name 
varchar not null, primary key (user_name, role_name))
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - You have an 
error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near 'not null, role_name
varchar 
not null, primary key (user_name, role_name))' at line 1
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: 
create table jarbartest.usercomments (commentID int unsigned not null, 
commentMade varchar not null, dateMade datetime not null, flagged bit not 
null, page_id varchar not null, made_by varchar(20) not null, primary key 
(commentID))
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - You have an 
error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near 'not null, dateMade
datetime 
not null, flagged bit not null, page_id varchar not ' at line 1
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: 
create table jarbartest.users (user_name varchar not null, first_name 
varchar not null, last_name varchar not null, user_email varchar not null,

ip_address varchar not null, user_pass varchar not null, primary key 
(user_name))
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - You have an 
error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near 'not null, first_name 
varchar not null, last_name varchar not null, user_email va' at line 1
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate -
Unsuccessful: 
alter table jarbartest.usercomments add index FKAA77CEBF792FED2F
(made_by), 
add constraint FKAA77CEBF792FED2F foreign key (made_by) references 
jarbartest.users (user_name)
ERROR TP-Processor2 org.hibernate.tool.hbm2ddl.SchemaUpdate - ALTER
command 
denied to user 'yucca123_hiber'@'localhost' for table 'usercomments'
ERROR TP-Processor2 org.hibernate.util.JDBCExceptionReporter - SELECT 
command denied to user 'yucca123_hiber'@'localhost' for table
'usercomments'
ERROR TP-Processor2 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[Faces

Servlet] - Servlet.service() for servlet Faces Servlet threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command 
denied to user 'yucca123_hiber'@'localhost' for table 'usercomments'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at 
org.bar.jar.backing.tutorialIndexBacking.getAllUnflaggedComments(tutorialIndexBacking.java:22)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
at 
com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
at org.apache.el.parser.AstValue.getValue(AstValue.java:118)
at
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at 
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
at javax.faces.component.UIData.getValue(UIData.java:614)
at javax.faces.component.UIData.getDataModel(UIData.java:1145)
at javax.faces.component.UIData.setRowIndex(UIData.java:451)
at 
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:77)
at 
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:813)
at javax.faces.component.UIData.encodeBegin(UIData.java:983)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:928)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
at 
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
at 
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
at 
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor2 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[jsp]
 
- Servlet.service() for servlet jsp threw exception
java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor2 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org] - 
Exception Processing ErrorPage[exceptionType=java.lang.Throwable, 
location=/oops.jsp]
org.apache.jasper.JasperException: java.lang.RuntimeException: Cannot find

FacesContext
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:418)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
... 22 more
ERROR TP-Processor3 org.hibernate.util.JDBCExceptionReporter - SELECT 
command denied to user 'yucca123_hiber'@'localhost' for table
'usercomments'
ERROR TP-Processor3 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[Faces

Servlet] - Servlet.service() for servlet Faces Servlet threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command 
denied to user 'yucca123_hiber'@'localhost' for table 'usercomments'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at 
org.bar.jar.backing.tutorialIndexBacking.getAllUnflaggedComments(tutorialIndexBacking.java:22)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
at 
com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
at org.apache.el.parser.AstValue.getValue(AstValue.java:118)
at
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at 
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
at javax.faces.component.UIData.getValue(UIData.java:614)
at javax.faces.component.UIData.getDataModel(UIData.java:1145)
at javax.faces.component.UIData.setRowIndex(UIData.java:451)
at 
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:77)
at 
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:813)
at javax.faces.component.UIData.encodeBegin(UIData.java:983)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:928)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
at 
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
at 
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
at 
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor3 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[jsp]
 
- Servlet.service() for servlet jsp threw exception
java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor3 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org] - 
Exception Processing ErrorPage[exceptionType=java.lang.Throwable, 
location=/oops.jsp]
org.apache.jasper.JasperException: java.lang.RuntimeException: Cannot find

FacesContext
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:418)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
... 22 more
ERROR TP-Processor4 org.hibernate.util.JDBCExceptionReporter - SELECT 
command denied to user 'yucca123_hiber'@'localhost' for table
'usercomments'
ERROR TP-Processor4 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[Faces

Servlet] - Servlet.service() for servlet Faces Servlet threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command 
denied to user 'yucca123_hiber'@'localhost' for table 'usercomments'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at 
org.bar.jar.backing.tutorialIndexBacking.getAllUnflaggedComments(tutorialIndexBacking.java:22)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
at 
com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:72)
at org.apache.el.parser.AstValue.getValue(AstValue.java:118)
at
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
at 
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
at javax.faces.component.UIData.getValue(UIData.java:614)
at javax.faces.component.UIData.getDataModel(UIData.java:1145)
at javax.faces.component.UIData.setRowIndex(UIData.java:451)
at 
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:77)
at 
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:813)
at javax.faces.component.UIData.encodeBegin(UIData.java:983)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:928)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
at 
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:266)
at 
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:197)
at 
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor4 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org].[/].[jsp]
 
- Servlet.service() for servlet jsp threw exception
java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
ERROR TP-Processor4 
org.apache.catalina.core.ContainerBase.[Catalina].[thejarbar.org] - 
Exception Processing ErrorPage[exceptionType=java.lang.Throwable, 
location=/oops.jsp]
org.apache.jasper.JasperException: java.lang.RuntimeException: Cannot find

FacesContext
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:418)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at 
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:416)
at 
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:271)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: Cannot find FacesContext
at 
javax.faces.webapp.UIComponentClassicTagBase.getFacesContext(UIComponentClassicTagBase.java:1855)
at 
javax.faces.webapp.UIComponentClassicTagBase.setJspId(UIComponentClassicTagBase.java:1672)
at org.apache.jsp.oops_jsp._jspx_meth_f_005fview_005f0(oops_jsp.java:93)
at org.apache.jsp.oops_jsp._jspService(oops_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
...

Hi guys

it looks like the Hudson build for patches is stuck since July 21st. Is it
intended?

http://hudson.zones.apache.org/hudson...R_PatchQueue.html
http://hudson.zones.apache.org/hudson...id.sp2.yahoo.net/

db.repairDatabase() seems stuck

Hi Guys,
This is my first post here, so i'll start by saying how impressed i am
with mongo so far!!

I'm in the pricess of moving a lot of my data from MySQL to mongo, I
have a db that has 3 very big collections, between 300M to 700M.
After adding a lot of the data, i realized that one of the fields i
added is not needed, so i decided to remove it:
db.mydb.update({}, {$unset : { 'myfield' : 1}}, false, true)
it took a while but it ended successfully. Since i wanted my data
files to be optimized i called  db.repairDatabase() which seemed to be
running for almost a day now.
In the beginning it seemed running, doing reallocation of files, but
now it doesn't do anything (at least not in the logs) but the CPU is
still high, so i guess it's doing something.
This is the end of the log messages:
 Tue Aug 24 18:10:44 [conn22] getmore content_cache.object cid:
8864487685831179766 getMore: {}  bytes:1049655 nreturned:869 135ms
Tue Aug 24 18:10:44 [conn22] getmore content_cache.object cid:
8864487685831179766 getMore: {}  bytes:1049189 nreturned:758 131ms
Tue Aug 24 18:10:45 [conn22] getmore content_cache.object cid:
8864487685831179766 getMore: {}  bytes:1049582 nreturned:1383 130ms
Tue Aug 24 18:10:46 [conn22] getmore content_cache.object cid:
8864487685831179766 getMore: {}  bytes:1065098 nreturned:869 119ms
Tue Aug 24 18:10:46 [conn22] getmore content_cache.object cid:
8864487685831179766 getMore: {}  bytes:567202 nreturned:1342 247ms
Tue Aug 24 18:10:47 [conn22] building new index on { _id: 1 } for
content_cache.object
Tue Aug 24 18:10:47 [conn22] Buildindex content_cache.object idxNo:0
{ name: "_id_", ns: "content_cache.object", key: { _id: 1 } }
Tue Aug 24 22:12:35 [conn22]     external sort used : 397 files  in
14508 secs
Tue Aug 24 22:16:23 allocating new datafile /var/lib/mongodb/
$tmp_repairDatabase_0/content_cache.110, filling with zeroes...
Tue Aug 24 22:16:47 done allocating datafile /var/lib/mongodb/
$tmp_repairDatabase_0/content_cache.110, size: 2047MB,  took 24.016
secs
Tue Aug 24 23:10:11 allocating new datafile /var/lib/mongodb/
$tmp_repairDatabase_0/content_cache.111, filling with zeroes...
Tue Aug 24 23:10:34 done allocating datafile /var/lib/mongodb/
$tmp_repairDatabase_0/content_cache.111, size: 2047MB,  took 23.563
secs



and that's it for the past few hours.
any help???

Help : Jackrabbit/Lucene get stuck

Hi,
We're using Jackrabbit 1.6.2 as an internal CMS in an application we
developped.
It runs in JBOSS 4.2.3 on jre 1.5.0_15 with XA transactions and Oracle10g

We have about 15 users adding / deleting files in the repository.
30 others just do read only CMS access and other stuff.

Things work fine except that sometimes, suddenly everything gets stuck and
all we have left is those kind of errors :
[org.apache.jackrabbit.core.query.lucene.NodeIteratorImpl] : Exception
retrieving Node with UUID : XXXXXXX-XXX-etc:
javax.jcr.ItemNotFoundException: XXXXXXX-XXX-etc

All our JCR connections are now dead. If we restart JBOSS, things get back
to normal, until the next crash.

We can't figure out what's happening. We suspect transaction or deadlock
problem but don't know where to look at.

Any help is more than welcome.
I did not add workspace.xml or repository.xml file or whatever as I don't
what is really relevant to troubleshoot but I am of course ready to do
so...


Regards,

Laurent

DO NOT REPLY New: Borrowers Getting Stuck

https://issues.apache.org/bugzilla/show_bug.cgi?id=49584

           Summary: Borrowers Getting Stuck
           Product: Tomcat 7
           Version: unspecified
          Platform: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Modules: jdbc-pool
        AssignedTo: d### @tomcat.apache.org
        ReportedBy: murp### @ben.name


The borrow connection logic seems to assume that connections will always
transition between active to idle. However, if connections move from
active to
released then a borrower can get stuck in idle.poll even though there is
room
in the pool for another connection to be created.

There is also an issue with connection create failing causing the pool
size to
be incremented but not decremented. In the borrowConnection method the
pool
size is incremented. However, if an exception occurs in the
createConnection
method releaseConnection can be called with a null argument and the pool
size
is not decremented.

nodetool move looks stuck

I ran nodetool move on one of the nodes and it seems stuck for a few hours
now.

I've been able to run it successfully in the past, but this time it looks
stuck.

Streams shows as if there's work in progress, but the same files have been
at the same position for a few hours.
I've also checked the compaction manager through jmx and it's not
compacting
anything.

Anything I can do to continue the move operation? Is this a bug?
thanks


$ nodetool -h 192.168.254.58 -p 9004 streams
Mode: Normal
 Nothing streaming to /192.168.252.124
Streaming to: /192.168.254.57
  
/outbrain/cassandra/data/outbrain_kvdb/stream/KvImpressions-170-Filter.db
0/45587965
   /outbrain/cassandra/data/outbrain_kvdb/stream/KvImpressions-170-Data.db
0/18369406636
   /outbrain/cassandra/data/outbrain_kvdb/stream/KvRatings-142-Index.db
0/6163411
   /outbrain/cassandra/data/outbrain_kvdb/stream/KvRatings-142-Filter.db
0/85645
   /outbrain/cassandra/data/outbrain_kvdb/stream/KvRatings-142-Data.db
0/37985032
   /outbrain/cassandra/data/outbrain_kvdb/stream/KvAds-108-Index.db
0/77307418
   /outbrain/cassandra/data/outbrain_kvdb/stream/KvAds-108-Filter.db
0/1436005
   /outbrain/cassandra/data/outbrain_kvdb/stream/KvAds-108-Data.db
0/704736670
   /outbrain/cassandra/data/Keyspace1/stream/Standard1-40-Index.db
0/230280
   /outbrain/cassandra/data/Keyspace1/stream/Standard1-40-Filter.db
0/20605
   /outbrain/cassandra/data/Keyspace1/stream/Standard1-40-Data.db
0/202808000
   /outbrain/cassandra/data/Keyspace1/stream/Standard1-41-Index.db 0/23912
   /outbrain/cassandra/data/Keyspace1/stream/Standard1-41-Filter.db
0/20605
   /outbrain/cassandra/data/Keyspace1/stream/Standard1-41-Data.db
0/21434973
   /outbrain/cassandra/data/Keyspace1/stream/Standard1-42-Index.db
0/965028
   /outbrain/cassandra/data/Keyspace1/stream/Standard1-42-Filter.db
0/20605
   /outbrain/cassandra/data/Keyspace1/stream/Standard1-42-Data.db
0/865380205
Not receiving any streams.

$ nodetool -h 192.168.254.57 -p 9004 streams
Mode: Normal
 Nothing streaming to /192.168.254.58
Streaming from: /192.168.254.58
   outbrain_kvdb:
/outbrain/cassandra/data/outbrain_kvdb/KvImpressions-tmp-1081-Data.db
0/18369406636
   outbrain_kvdb:
/outbrain/cassandra/data/outbrain_kvdb/KvRatings-tmp-167-Index.db
0/6163411
   outbrain_kvdb:
/outbrain/cassandra/data/outbrain_kvdb/KvRatings-tmp-167-Filter.db 0/85645
   outbrain_kvdb:
/outbrain/cassandra/data/outbrain_kvdb/KvRatings-tmp-167-Data.db
0/37985032
   outbrain_kvdb:
/outbrain/cassandra/data/outbrain_kvdb/KvAds-tmp-123-Index.db 0/77307418
   outbrain_kvdb:
/outbrain/cassandra/data/outbrain_kvdb/KvAds-tmp-123-Filter.db 0/1436005
   outbrain_kvdb:
/outbrain/cassandra/data/outbrain_kvdb/KvAds-tmp-123-Data.db 0/704736670
   Keyspace1: /outbrain/cassandra/data/Keyspace1/Standard1-tmp-21-Index.db
0/230280
   Keyspace1:
/outbrain/cassandra/data/Keyspace1/Standard1-tmp-21-Filter.db
0/20605
   Keyspace1: /outbrain/cassandra/data/Keyspace1/Standard1-tmp-21-Data.db
0/202808000
   Keyspace1: /outbrain/cassandra/data/Keyspace1/Standard1-tmp-22-Index.db
0/23912
   Keyspace1:
/outbrain/cassandra/data/Keyspace1/Standard1-tmp-22-Filter.db
0/20605
   Keyspace1: /outbrain/cassandra/data/Keyspace1/Standard1-tmp-22-Data.db
0/21434973
   Keyspace1: /outbrain/cassandra/data/Keyspace1/Standard1-tmp-23-Index.db
0/965028
   Keyspace1:
/outbrain/cassandra/data/Keyspace1/Standard1-tmp-23-Filter.db
0/20605
   Keyspace1: /outbrain/cassandra/data/Keyspace1/Standard1-tmp-23-Data.db
0/865380205

Help! Cassandra Data Loader threads are getting stuck

Hi All,

I have to load huge quantity of data into Cassandra (~10Billion rows).

I'm trying to load the Data from files using multithreading.

The idea is each thread will read the TAB delimited file and process chunk
of records.

For example Thread1 reads line 1-1000 lines
Thread 2 reads line 1001-2000 and insert into Cassandra.
Thread 3 reads line 2001-3000 and insert into Cassandra.

Thread 10 reads line 9001-10000 and insert into Cassandra.
Thread 1  reads line 10001-11000 and insert into Cassandra.
Thread 2 reads line 11001-12000 and insert into Cassandra.

and so on...

I'm testing with a small file size with 200000 records.

But somehow the process gets stuck and doesn't proceed any further after
processing say 16,000 records.

I've attached my working file.

Any help will be very much appreciated.

Regards

raich

Apache getting stuck with all workers in a BUSY_READ state

Hi, I've been having problems with apache becoming unresponsive, and
was wondering if anyone had any suggestions on what the problem might
be. Basically, periodically, apache will get into a state where all
the workers are stuck reading:

Server Version: Apache
Server Built: Oct 21 2009 10:54:43
Current Time: Tuesday, 15-Jun-2010 07:57:30 PDT
Restart Time: Tuesday, 15-Jun-2010 06:37:33 PDT
Parent Server Generation: 0
Server uptime:  1 hour 19 minutes 57 seconds
Total accesses: 985801 - Total Traffic: 8.1 GB
CPU Usage: u644.89 s203.76 cu3994.75 cs0 - 101% CPU load
206 requests/sec - 1.7 MB/second - 8.6 kB/request
1593 requests currently being processed, 15 idle workers
RRRRRRRRRRRRRCRRRRKRRRRRRRRRRRRRRRRRRRKRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRCRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRCRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRKRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRKRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRCRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RKRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRCRRRRRRRRRRRRRRRRRRRRRRKRRRRRRRRRRRKRKRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRKRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRKRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRKRRRRRRRRRRRRRRRRRRRRRRRRRRRRRKRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRWRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRRWRRRRKKCRRKRKRRRRKRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRC
RRKKRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRRRRRRRKRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
RRRRRRRRCKRRRRCCRRKRRRRRRRRRRRRRRRKRRRCRRRRRRRRRRRRRCCRRRCRRCRRR
RRRRRRRKKRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRWRRRRRKRRRKRRRRRRRRRRRRRW
KKRRRRRRRKRRRRWRKRRRRRRRRRRRRRRRWRRRRRRRRRRRR___RRR__RR___R_____
WRR__RRRSS......................................................
................................................................
................................................................
................................................................
................................................................
................................................................
................................................................

This is prior to complete failure - sometimes whatever's blocking gets
unblocked before it hits max clients, sometimes it doesn't. I'm
running apache 2.0.59 built with openssl 0.9.8n on AIX 6.1 with
prefork, and this is virtually all SSL traffic (pretty much everything
other than the scoreboard). A restart basically "fixes" the problem,
from the perspective that all the workers get killed and after the
initial thrashing of starting up new workers.

From my understanding of the READ state above, everything above is
stuck in one of two broad categories:

 - A client made the TCP connection to the server, and is somewhere
between the tcp handshake and the end of the HTTP Request info. This
suggests it could be a network issue (something's hanging the
connections), or an openssl issue (the TLS/SSL negotiation is
slow/hanging), or...?
 - The request has been completed, but we're proxying to somewhere
else and waiting for a response from the proxy. This potentially
applies in this case, because we do have apache setup to proxy some
URLs to another server.

There's nothing in the access or error logs jumping out to correlate
with this problem either - There are MaxClient issues once it hits
that, of course, but nothing related to the BUSY_READ state.

 When having the problem, I've correlated the scoreboard with the
ps/lsof/netstat output, and the second case seems unlikely because I'm
not seeing any open connections to the server that apache is proxy'ing
to. It feels like there's some shared resource that all the apache
workers are trying to access, but I can't figure out what it might be.
Any suggestions on a solution, or how I might get more info out of
apache as to what it's doing while everyone's in the read state? Are
there other broad categories I'm missing as to why the workers might
be in the read state? Any further info I could provide to help anyone?
My next steps are to dive into the apache source further and see what
possible resources it could be blocking on, but I'm hoping someone
smarter than me already knows. :)

Updated: (AMQ-2614) After failover some messages are stuck in the new broker

     [
https://issues.apache.org/activemq/br...nels:all-tabpanel
]

Hadrian Zbarcea updated AMQ-2614:

REGEX - Long running thread - stuck at RE.java

Hi,

 

We are facing high CPU usage in our application hosted on Tomcat. After
getting thread dumps, I see the following information. Seems like the
RE.java is getting processed continuously and due to this few threads in
Tomcat are stuck forever. This pushes the CPU usage above 90% and making
the application very unstable. 

 

Please advice.

 

Below is the info from thread dump:

 

TP-Processor5396" daemon prio=10 tid=0x022cff28 nid=0x1f91b runnable
[0x4dcfb000..0x4dcffc70]

            at org.apache.regexp.RE.matchNodes(RE.java:860)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchNodes(RE.java:1376)

            at org.apache.regexp.RE.matchAt(RE.java:1448)

            at org.apache.regexp.RE.match(RE.java:1498)

            at org.apache.regexp.RE.match(RE.java:1468)

            at org.apache.regexp.RE.match(RE.java:1561)

            at
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

            at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:290)

            at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)

            at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:233)

            at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:175)

            at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:128)

            at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:102)

            at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:109)

            at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:2
86)

            at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

            at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)

            at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)

            at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:
697)

            at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.
java:889)

            at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:690)

            at java.lang.Thread.run(Thread.java:595)

 

 

Here is the regex related code in our application :

 

        try{

          RE r = new
RE("^[\\w\\-]+(\\.)?[\\w\\-]+@[\\w\\-\\.]+(\\.([a-z]){2,4})$");

          RE r1 = new RE("^\\w{5,65}$");

          match = r.match(userID);

          if(!match)

            match = r1.match(userID);

 

        }catch(Exception ex){

            throw new BusinessException(ex);

        }

 

Any thoughts???? 
 
Do you really need to print this email? Help preserve our environment!
Devez-vous vraiment imprimer ce courriel? Pensons a l'environnement!

Created: (MAPREDUCE-1950) Jetty Acceptor can stuck TaskTracker forever

Jetty Acceptor can stuck TaskTracker forever