[astro] No GPU work

[Matt Arsenault]

On Mar 13, 2012, at 9:13 AM, <pboulay at rochester.rr.com> <pboulay at rochester.rr.com> wrote:

> 9:12am...what's up?
> _______________________________________________
> astro mailing list
> astro at cs.rpi.edu
> https://www.cs.rpi.edu/mailman/listinfo/astro

It looks like nobody ever set up monthly/weekly table analyze and optimize but that isn't the problem. Also what is the backup situation?

I had to kill -9 the java processes as what usually happens when I restart it when things are broken.

I restarted it but the separation assimilator had the log:

SQLException: Communications link failure

The last packet successfully received from the server was 26,299 milliseconds ago.  The last packet sent successfully to the server was 16,298 milliseconds ago.
SQLState: 08S01
VendorError: 0
Validated 0 workunits, 0.8689118851243636% valid, 0.019620998758377244% invalid, 0.11146711611725915% inconclusive.
AssimlatePass Exception: 
SQLException: No operations allowed after connection closed.Connection was implicitly closed by the driver.
SQLState: 08003
VendorError: 0
Assimilated 0 workunits.
ERROR updating database: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed by the driver.
QUERY: UPDATE app_version SET pfc_n = 2.846710000000000e+05,  pfc_avg = 1.822893822436349e+01,  expavg_credit = 8.380063678601527e+05,  expavg_time = 1.331028503414000e+09  WHERE  id = 410  AND pfc_n = 284671.000000 AND abs(expavg_credit - 8.380063678601527e+05) < 1e-4  AND abs(pfc_scale - 6.040223057416700e-01) < 1e-6 
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed by the driver.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1160)
        at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1147)
        at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2486)
        at com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2468)
        at jboinc.database.ApplicationVersion.commitCreditPolicy(ApplicationVersion.java:73)
        at jboinc.daemons.CreditPolicy.writeModifiedApplicationVersions(CreditPolicy.java:464)
        at jboinc.daemons.ValidatorNew.run(ValidatorNew.java:132)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 26,299 milliseconds ago.  The last packet sent successfully to the server was 16,298 milliseconds ago.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3052)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2938)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3481)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1464)
        at jboinc.daemons.ValidatorNew.getValidationWorkunits(ValidatorNew.java:553)
        at jboinc.daemons.ValidatorNew.run(ValidatorNew.java:121)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2497)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2949)
        ... 9 more
[validator] error commiting modified application versions.

ValidatorNew caught a shutdown hook -- probably SIGHUP from bin/stop