Opened 4 years ago

#1562 new defect

Dbwriter .SQLException: Subquery returns more than 1 row

Reported by: phil.okeeffe Owned by:
Priority: high Milestone:
Component: sge Version: 8.1.7
Severity: critical Keywords:
Cc:

Description

Getting SQLErrors and Exceptions in the dbwriter.log

All are complaining about
Caused by java.sql.SQLException: Subquery returns more than 1 row
in either the sge_host or sge_que tables.. Is this normal as we do not have this happening on our other sites.

e.g

com.sun.grid.reporting.dbwriter.ReportingException?: Error in SQL Statement: SELECT date_format(hv_time_start, '%Y-%m-%d %H:00:00') AS time_start, date_format(hv_time_start, '%Y-%m-%d %H:00:00') + INTERVAL 1 hour AS time_end, AVG(hv_dvalue) AS value FROM sge_host_values WHERE hv_variable = 'cpu' AND hv_parent = (SELECT h_id FROM sge_host WHERE h_hostname = 'xxxxxxx blah blah duplicate record xxxxx') AND hv_time_start <= {ts '2015-09-25 10:00:00.0'} AND hv_time_end > {ts '1969-12-31 21:00:00.0'} GROUP BY time_start

com.sun.grid.reporting.dbwriter.db.Database.createSQLError(Database.java:361)
com.sun.grid.reporting.dbwriter.db.Database.executeQuery(Database.java:570)
com.sun.grid.reporting.dbwriter.StoredRecordManager?.calculateDerivedValues(StoredRecordManager?.java:419)
com.sun.grid.reporting.dbwriter.StoredRecordManager?.calculateDerivedValues(StoredRecordManager?.java:366)
com.sun.grid.reporting.dbwriter.ReportingDBWriter.calculateDerivedValues(ReportingDBWriter.java:657)
com.sun.grid.reporting.dbwriter.ReportingDBWriter$DerivedValueThread?.run(ReportingDBWriter.java:850)

Caused by java.sql.SQLException: Subquery returns more than 1 row

com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

Change History (0)

Note: See TracTickets for help on using tickets.