[astro] [Fwd: Re: No GPU work]
Travis Desell
deselt at cs.rpi.edu
Tue Mar 20 13:44:47 EDT 2012
Hi Heidi,
This looks like mysql crashed, which caused the validator to crash. If mysql and the validator are restarted everything should be fine.
--Travis
On Mar 20, 2012, at 12:41 PM, Heidi Newberg wrote:
>
> Travis,
>
> Is this a bug in the server? Is it possible for you to fix this bug?
>
> Heidi
>
> -------- Original Message --------
> Subject: Re: [astro] No GPU work
> Date: Tue, 13 Mar 2012 11:32:26 -0400
> From: Matt Arsenault <arsenm2 at gmail.com>
> Reply-To: Astro Research <astro at cs.rpi.edu>
> To: Astro Research <astro at cs.rpi.edu>
> References: <20120313131308.7LWI5.296648.root at hrndva-web28-z01>
>
> 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
>
> _______________________________________________
> astro mailing list
> astro at cs.rpi.edu
> https://www.cs.rpi.edu/mailman/listinfo/astro
>
>
---------------------------------------------------------------------------
Travis Desell, Assistant Professor
University of North Dakota - Dept. of Computer Science
travis.desell at gmail.com - cell: 518-867-1054
Streibel Hall Room 220 - office: 777-701-3477
3950 Campus Road Stop 9015
Grand Forks, North Dakota 52802-9015
Homepage ( http://people.cs.und.edu/~tdesell/ )
MilkyWay at Home ( http://milkyway.cs.rpi.edu/ )
DNA at Home ( http://volunteer.cs.und.edu/dna )
Worldwide Computing Laboratory ( http://wcl.cs.rpi.edu/ )
----------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.cs.rpi.edu/mailman/archives/astro/attachments/20120320/1f6a8971/attachment-0001.html>
More information about the astro
mailing list