You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@juddi.apache.org by Rick <op...@users.sourceforge.net> on 2004/05/13 07:00:32 UTC

Happyjuddi.jsp Infinite Loop

RedHat Linux 7.3
j2sdk 1.4.2_04
Tomcat 5.0.19
MySQL 4.0.18 w/MySQL Connector/J 3.0.11-stable

Happyjuddi.jsp goes into an infinite loop banging away at the DB.  From the 
mysql query log:

    Time                 Id Command    Argument
    040512 15:57:30       1 Connect     juddi@millhouse.hilton.com on juddi
                          1 Init DB     juddi
                          1 Query       SELECT 1
    040512 15:57:31       1 Query       select round('inf'), round('-inf'), 
round('nan')
                          1 Query       SHOW VARIABLES
                          1 Query       SET autocommit=1
                          1 Query       SET autocommit=1
                          1 Query       select count(*) from publisher
                          1 Quit
                          2 Connect     juddi@millhouse.hilton.com on juddi
                          2 Init DB     juddi
                          2 Query       SELECT 1
                          2 Query       select round('inf'), round('-inf'), 
round('nan')
                          2 Query       SHOW VARIABLES
                          2 Query       SET autocommit=1
                          2 Query       SET autocommit=1
                          2 Query       select count(*) from publisher
                          2 Quit
                          3 ...

The only way to stop it is shutdown tomcat.
Debugging statements show everything is fine up to JDBC getConnection().  
Nothing after. If I shutdown the DB and run happyjuddi.jsp, I get the 
expected connect and select error and the rest is fine.

I notice that with DB down 3 re-tries before fail.  Having trouble locating 
where retry is configured.

Any help is much appreciated.

Rick