RCDB Not Updating?

  • rcdb on gluondb1 and hallddb share the same last run:
    +--------+---------------------+---------------------+
    | number | started | finished |
    +--------+---------------------+---------------------+
    | 31528 | 2017-06-01 14:47:32 | 2017-06-01 14:48:13 |
    | 31526 | 2017-06-01 14:08:47 | 2017-06-01 14:09:53 |
    | 31525 | 2017-06-01 13:53:00 | 2017-06-01 13:54:12 |
    | 31524 | 2017-06-01 12:46:19 | 2017-06-01 12:47:37 |
    | 31523 | 2017-06-01 11:10:00 | 2017-06-01 11:11:05 |
  • Update of RCDB may be turned off for now.
  • User rcdb needs a password on gluondb1 but not on hallddb.

 

Advertisements

Structure of typical job info table in jproj

MariaDB [farming]> describe dc_03_reconJob;
+-----------------+---------------+------+-----+-------------------+-----------------------------+
| Field           | Type          | Null | Key | Default           | Extra                       |
+-----------------+---------------+------+-----+-------------------+-----------------------------+
| id              | int(11)       | NO   | PRI | NULL              | auto_increment              |
| run             | int(11)       | YES  |     | NULL              |                             |
| file            | int(11)       | YES  |     | NULL              |                             |
| jobId           | int(11)       | YES  |     | NULL              |                             |
| timeChange      | timestamp     | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| username        | varchar(64)   | YES  |     | NULL              |                             |
| project         | varchar(64)   | YES  |     | NULL              |                             |
| name            | varchar(64)   | YES  |     | NULL              |                             |
| queue           | varchar(64)   | YES  |     | NULL              |                             |
| hostname        | varchar(64)   | YES  |     | NULL              |                             |
| nodeTags        | varchar(64)   | YES  |     | NULL              |                             |
| coresRequested  | int(11)       | YES  |     | NULL              |                             |
| memoryRequested | int(11)       | YES  |     | NULL              |                             |
| status          | varchar(64)   | YES  |     | NULL              |                             |
| exitCode        | int(11)       | YES  |     | NULL              |                             |
| result          | varchar(64)   | YES  |     | NULL              |                             |
| timeSubmitted   | datetime      | YES  |     | NULL              |                             |
| timeDependency  | datetime      | YES  |     | NULL              |                             |
| timePending     | datetime      | YES  |     | NULL              |                             |
| timeStagingIn   | datetime      | YES  |     | NULL              |                             |
| timeActive      | datetime      | YES  |     | NULL              |                             |
| timeStagingOut  | datetime      | YES  |     | NULL              |                             |
| timeComplete    | datetime      | YES  |     | NULL              |                             |
| walltime        | varchar(8)    | YES  |     | NULL              |                             |
| cput            | varchar(8)    | YES  |     | NULL              |                             |
| mem             | varchar(64)   | YES  |     | NULL              |                             |
| vmem            | varchar(64)   | YES  |     | NULL              |                             |
| script          | varchar(1024) | YES  |     | NULL              |                             |
| files           | varchar(1024) | YES  |     | NULL              |                             |
| error           | varchar(1024) | YES  |     | NULL              |                             |
+-----------------+---------------+------+-----+-------------------+-----------------------------+
30 rows in set (0.00 sec)