Prizm crashes

I’m running Prizm 3.10.r4 (Patch 1) on a Redhat server 2 Gb of RAM.
The Prizm process crashes about 2 to 3 times per week and the server has to be rebooted in order to get Prizm back up.
When the server is running, it is running without any problems… until it crashes…

Please see error log below “tech info”

Here is some tech info:


Features: Full (EMS, BAM)
Java Version: 1.5.0_11
Platform: i386
Operating System: Linux
OS Version: 2.6.9-67.EL
Server Time: 10/3/08 9:06 AM
Up Time: 000:00:06:47
Maximum Memory: 508M
Total Memory: 127M
Free Memory: 75M
Total Threads: 127
Server IP: xxx.xxx.xxx.xxx
DatabaseManager
Average Connection Wait Time = 0
Average Query Execution Time = 0
Connection Hold Time = 300000
Connection Timeout Count = 0
Connection Wait Time = 30000
DB Connections Opened = 2
Database Profile = mysql.xml
IP Address = 127.0.0.1
JDBC Driver = MySql
JDBC Jar File = mysql-connector-java-3.0.16-ga-bin.jar
Max. Connections = 50
Port = 3306
Schema Name = prizm
TaskScheduler
No. of scheduled Tasks = 26
NodeManager
Event Queue Size = 0, 0, 0, 0, 0, 0, 0
No. of registered Listeners = 7
Processing Time =
update (blocking): 5
update (non-blocking): 757
refresh (non-blocking): 3856
SNMPLib
Trap Port = 162
ElementConfigManager
Current Job =
Current Job ID = 0
Num Change Jobs Queued = 0
Num Config/Update Jobs Queued = 0
BAMManager
Radius Enabled = false

--------------------------- ERROR MESSAGE ------------------------

10/03/08 06:40:00 INFO SYSTEM Build Version: 3.10.r4( 02.18.2008 14:34:11 )
10/03/08 06:40:00 INFO SYSTEM Java Version: 1.5.0_11
10/03/08 06:40:00 INFO SYSTEM Platform: i386
10/03/08 06:40:00 INFO SYSTEM Operating System: Linux
10/03/08 06:40:00 INFO SYSTEM OS Version: 2.6.9-67.EL
10/03/08 06:40:00 WARN SYSTEM SQLException in getElementsByFilterjava.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused
** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused
STACKTRACE:
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:124)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:225)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1783)
at com.mysql.jdbc.Connection.<init>(Connection.java:450)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mot.canopy.prizm.services.database.Database$ConnCreator.run(Database.java:209)

** END NESTED EXCEPTION

10/03/08 06:40:00 WARN SYSTEM SQLException in getElementsByFilterjava.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused
BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused
STACKTRACE:
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:124)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:225)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1783)
at com.mysql.jdbc.Connection.<init>(Connection.java:450)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mot.canopy.prizm.services.database.Database$ConnCreator.run(Database.java:209)

** END NESTED EXCEPTION **



Does anybody know what is going on here?

Thanks
JB

just get used to it, thats the only advice i can offer you on prizm