-----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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
