tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: JDBCRealm.getRoles causes NullPointerException
Date Wed, 03 Sep 2008 16:39:57 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Lloyd,

DIGLLOYD INC wrote:
> MySQL 5.0.51b + mysql-connector-java-5.1.6-bin.jar

Have you tried downgrading to a 5.0 version? It might be worth it to see
if there is some weird problem with their new driver.

> The only clue I see in catalina.out is the stack trace below (10 of them
> or so), about 9 hours *prior* to my detecting the authentication
> failure.  However, my access logs show that users logged in successfully
> *after* that series of failures.

That indicates to me that you are using multiple connections to the
database, and perhaps one of them gets damaged but the others are okay.
Do you see any other JDBC-related exceptions on your logs, or any faults
detected on the MySQL-server-side?

Are you using a DataSourceRealm? If so, are you sharing that DataSource
with your actual application, or do you have a separate one for
authentication?

Any other problems /not/ related to authentication?

Do you have a validationQuery set for your JDBC/JNDI <Resource>? If so,
what is it? Also, do you have the debugging options for leaked
connections turned on?

> I'm not sure where or how to debug this further.  It seems that Tomcat
> is making a bad call to next() which causes the NPE, but that's unclear;
> perhaps it's ResultSetImpl with a problem.  It's also unclear why
> there's a burst of such problems, then no further ones in the log, then
> the hours-later complete failure.

I suspect that your connection pool is slowly failing, one connection at
a time. When you run out of useful connections, your app is dead.

> Aug 31, 2008 5:30:48 PM org.apache.catalina.connector.CoyoteAdapter service
> SEVERE: An exception or error occurred in the container during the
> request processing
> java.lang.NullPointerException
>     at
> com.mysql.jdbc.ResultSetImpl.setRowPositionValidity(ResultSetImpl.java:826)
>     at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7046)
>     at org.apache.catalina.realm.JDBCRealm.getRoles(JDBCRealm.java:632)

I would check with MySQL as well. I've found that my reported bugs never
get fixed, but sometimes Tonci will at least get back to you ;)

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

iEYEARECAAYFAki+vd0ACgkQ9CaO5/Lv0PCa8QCeMoMC4hYDVZnK2TM+If/sJ7wC
YTYAnjHrmxXSu2rLdE5i2YDirOtAh3tb
=+9Cz
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message