lwatch and lstat java exceptions

[Ryan Haasken]

Hello,

I have built the lmt-gui-3.0.0-1 rpm and installed on a system which already has lmt working.  I have already set up the MySQL database as described in the wiki instructions.  I verified that it was working by listing the tables in lmtsh.

After installing the rpm I built, I get the following error when I try to start lwatch:

# lwatch
[Prefs.prefsLoad:116] prefs file does NOT exist...
[MDSPanel.<init>:171] Exception detected while loading current MDS Ids for rind1
null
java.lang.Throwable
    at java.lang.Thread.dumpStack(Thread.java:417)
    at gov.llnl.lustre.lwatch.MDSPanel.<init>(MDSPanel.java:175)
    at gov.llnl.lustre.lwatch.FileSystemPanel.makeFSPanel(FileSystemPanel.java:229)
    at gov.llnl.lustre.lwatch.LWatch.createLWatchContainer(LWatch.java:626)
    at gov.llnl.lustre.lwatch.LWatch.<init>(LWatch.java:215)
    at gov.llnl.lustre.lwatch.LWatch.main(LWatch.java:789)
[OSTPanel.loadVariableInfoArray:407] VariableInfo load exception : null
Exception caught : null
java.lang.NullPointerException
    at gov.llnl.lustre.lwatch.OSTPanel.loadVariableInfoArray(OSTPanel.java:414)
    at gov.llnl.lustre.lwatch.OSTPanel.<init>(OSTPanel.java:211)
    at gov.llnl.lustre.lwatch.FileSystemPanel.makeFSPanel(FileSystemPanel.java:235)
    at gov.llnl.lustre.lwatch.LWatch.createLWatchContainer(LWatch.java:626)
    at gov.llnl.lustre.lwatch.LWatch.<init>(LWatch.java:215)
    at gov.llnl.lustre.lwatch.LWatch.main(LWatch.java:789)

And I get the following error when I try to start lstat:

# lstat
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.lang.reflect.InvocationTargetException

STACKTRACE:

java.net.SocketException: java.lang.reflect.InvocationTargetException
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:198)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
    at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
    at java.sql.DriverManager.getConnection(DriverManager.java:322)
    at java.sql.DriverManager.getConnection(DriverManager.java:358)
    at gov.llnl.lustre.database.Database.connect(Database.java:1548)
    at gov.llnl.lustre.lstat.Lstat$Device.<init>(Lstat.java:151)
    at gov.llnl.lustre.lstat.Lstat.processArgs(Lstat.java:525)
    at gov.llnl.lustre.lstat.Lstat.main(Lstat.java:209)


** END NESTED EXCEPTION **



Last packet sent to the server was 58 ms ago.

I think this looks like a database connection error or a query failing.  After doing some googling, I came across this similar issue http://code.google.com/p/lmt/issues/detail?id=44, but my lwatchclient user does have the host specified.

mysql> select user,host from user where user like 'lwatch%';
+--------------+-----------+
| user         | host      |
+--------------+-----------+
| lwatchadmin  | localhost |
| lwatchclient | localhost |
+--------------+-----------+
2 rows in set (0.00 sec)

Does anybody have any idea why lwatch and lstat are failing?  Thanks!

-Ryan Haasken

[Andrew Uselton]

Wild guess, but you might check your firewall rules and make sure the client MySQL server are allowed to talk to each other on the appropriate ports.

-A

--
You received this message because you are subscribed to the Google Groups "lmt-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lmt-discuss...@googlegroups.com.
To post to this group, send email to lmt-d...@googlegroups.com.
Visit this group at http://groups.google.com/group/lmt-discuss.
For more options, visit https://groups.google.com/groups/opt_out.

[Ryan Haasken]

I have installed the lmt-gui package on the management node where lmt-server is installed.  I am able to see live data with ltop, and I can see data that gets added to the LMT MySQL database using lmtsh.  Doesn't this mean the lmtsh client is able to talk to the MySQL server?  Does the Java code connect in a different way?

Also, when the client and and server are running on the same node, wouldn't they communicate with a socket and thus not be affected by firewall settings?

-Ryan

[Ryan Haasken]

Andrew,

That was a good guess.  We are using shorewall, and I needed to add a line to /etc/shorewall/rules that allowed communication on port 3306.  Now it's working.

Thanks,

Ryan