DOWNTIME ANNOUNCEMENTIntermittent network outages due to network upgrades by the university and department:
Thank you for your patience. |
Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.
2026-01-08 00:00:02 (GMT)
Status of all major tables from MariaDB (mpc_development) and Postgres database (mpc_sbn). It includes list of all major tables, number of records in each tables, the latest updated record in each table. A color code corresponds to records updated less than 1 day, from 1 to 3 days and older than 3 days. Updated every 5 min. GMT timestamp of update is at the top left of the page.
Source file of data: statusDB.csv
| Table | Count | Created_at | Updated_at |
| comet_names | 5214 | 2025-10-23 17:12:59 | 2025-10-23 17:12:59 |
| comet_orbits | 11212 | 2026-01-07 23:34:29 | 2026-01-07 23:34:29 |
| identifications | 211589 | 2026-01-07 12:23:48 | 2026-01-07 12:23:48 |
| isolated_tracklets | 49673163 | 2026-01-07 23:58:14 | 2026-01-07 23:58:14 |
| mp_discoverers | 1969147 | 2025-06-18 21:18:06 | 2025-06-18 21:18:06 |
| numbered_comet_identifications | 1292 | 2025-10-23 16:03:49 | 2025-10-23 16:03:49 |
| numbered_identifications | 1319125 | 2025-10-22 17:46:28 | 2025-10-22 17:46:28 |
| numbered_mps | 875150 | 2022-04-06 05:12:11 | 2025-12-16 17:23:23 |
| obs_request_observers | 52 | 2019-07-24 16:57:48 | 2019-07-24 16:57:48 |
| obs_request_users | 7 | 2015-12-04 00:25:22 | 2015-12-04 00:25:22 |
| observations | 502455184 | 2026-01-07 23:34:22 | 2026-01-07 23:34:22 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1505904 | 2026-01-07 19:30:03 | 2026-01-07 20:01:05 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 47 | 2026-01-07 02:03:23.374603 | 2026-01-08 00:02:12.080695 |
| neocp_events | 305388 | 2026-01-08 00:02:12.333793 | 2026-01-08 00:02:12.333793 |
| neocp_obs_archive | 766160 | 2026-01-08 00:02:12.039118 | 2026-01-08 00:02:12.039118 |
| neocp_obs | 559 | 2026-01-08 00:02:11.99841 | 2026-01-08 00:02:11.99841 |
| neocp_prev_des | 70289 | 2026-01-07 19:56:40.740814 | 2026-01-07 19:56:40.740814 |
| neocp_var | 93928 | 2026-01-08 00:02:12.174441 | 2026-01-08 00:02:12.174441 |
| current_identifications | 2016367 | 2026-01-08 00:02:03.569564 | 2026-01-08 00:02:41.57687 |
| numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-10-20 21:02:31.305341 |
| primary_objects | 1532113 | 2026-01-08 00:02:03.476039 | 2026-01-08 00:02:03.476039 |
| obs_sbn | 522064345 | 2025-10-28 02:21:04.69305-04 | 2026-01-07 19:02:06.313245-05 |
| obs_alterations_deletions | 1465342 | 2026-01-07 17:08:45.397109 | 2026-01-07 17:08:45.397109 |
| obs_alterations_redesignations | 4515 | 2026-01-03 19:19:15.911342 | 2026-01-03 19:19:15.911342 |
| obs_alterations_unassociations | 530905 | 2026-01-07 18:10:15.944127 | 2026-01-07 18:10:15.944127 |
| mpc_orbits | 1488184 | 2026-01-08 00:02:52.663921 | 2026-01-08 00:03:00.354934 |
| minor_planet_names | 25963 | 2018-05-31 01:04:42 | 2025-12-22 18:37:02.674927 |
YYYY-MM-DD - latest record is older than 3 days
YYYY-MM-DD - latest record is older than 1 day
YYYY-MM-DD - latest record is less than 1 day old
| Server | Table | Count | Updated_at | Queried_at |
| MPC_primarydb | obs_sbn | 522064345 | 2026-01-07 23:58:12.553105 | 2026-01-08 00:00:02.641179 |
| MPC_mpcsbndb | obs_sbn | 522064345 | 2026-01-07 23:58:12.553105 | 2026-01-08 00:00:14.41432 |
| SBN_to_AWS | obs_sbn | 522064345 | 2026-01-07 23:58:12.553105 | 2026-01-08 00:00:47.880499 |
| MPC_primarydb | current_identifications | 2016367 | 2026-01-08 00:02:03.569564 | 2026-01-08 00:02:06.242902 |
| MPC_mpcsbndb | current_identifications | 2016367 | 2026-01-08 00:02:03.569564 | 2026-01-08 00:02:06.764298 |
| SBN_to_AWS | current_identifications | 2016367 | 2026-01-08 00:02:03.569564 | 2026-01-08 00:02:07.026727 |
| MPC_primarydb | minor_planet_names | 25963 | 2025-12-22 18:37:02.674927 | 2026-01-08 00:02:07.273499 |
| MPC_mpcsbndb | minor_planet_names | 25963 | 2025-12-22 18:37:02.674927 | 2026-01-08 00:02:07.417577 |
| SBN_to_AWS | minor_planet_names | 25963 | 2025-12-22 18:37:02.674927 | 2026-01-08 00:02:07.513817 |
| MPC_primarydb | mpc_orbits | 1488183 | 2026-01-07 23:58:17.571245 | 2026-01-08 00:02:07.604954 |
| MPC_mpcsbndb | mpc_orbits | 1488183 | 2026-01-07 23:58:17.571245 | 2026-01-08 00:02:09.377282 |
| SBN_to_AWS | mpc_orbits | 1488183 | 2026-01-07 23:58:17.571245 | 2026-01-08 00:02:09.728494 |
| MPC_primarydb | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2026-01-08 00:02:10.125568 |
| MPC_mpcsbndb | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2026-01-08 00:02:10.419215 |
| SBN_to_AWS | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2026-01-08 00:02:10.548849 |
| MPC_primarydb | neocp_els | 47 | 2026-01-07 23:52:28.714555 | 2026-01-08 00:02:10.685448 |
| MPC_mpcsbndb | neocp_els | 47 | 2026-01-07 23:52:28.714555 | 2026-01-08 00:02:10.790194 |
| SBN_to_AWS | neocp_els | 47 | 2026-01-07 23:52:28.714555 | 2026-01-08 00:02:10.872225 |
| MPC_primarydb | neocp_events | 305387 | 2026-01-07 23:52:28.829217 | 2026-01-08 00:02:10.957379 |
| MPC_mpcsbndb | neocp_events | 305387 | 2026-01-07 23:52:28.829217 | 2026-01-08 00:02:11.133071 |
| SBN_to_AWS | neocp_events | 305387 | 2026-01-07 23:52:28.829217 | 2026-01-08 00:02:11.247895 |
| MPC_primarydb | neocp_obs | 556 | 2026-01-07 23:52:28.61001 | 2026-01-08 00:02:11.353552 |
| MPC_mpcsbndb | neocp_obs | 556 | 2026-01-07 23:52:28.61001 | 2026-01-08 00:02:11.456466 |
| SBN_to_AWS | neocp_obs | 556 | 2026-01-07 23:52:28.61001 | 2026-01-08 00:02:11.538528 |
| MPC_primarydb | neocp_obs_archive | 766157 | 2026-01-07 23:52:28.619538 | 2026-01-08 00:02:11.624009 |
| MPC_mpcsbndb | neocp_obs_archive | 766157 | 2026-01-07 23:52:28.619538 | 2026-01-08 00:02:11.828667 |
| SBN_to_AWS | neocp_obs_archive | 766157 | 2026-01-07 23:52:28.619538 | 2026-01-08 00:02:11.964483 |
| MPC_primarydb | neocp_prev_des | 70289 | 2026-01-07 19:56:40.740814 | 2026-01-08 00:02:12.095911 |
| MPC_mpcsbndb | neocp_prev_des | 70289 | 2026-01-07 19:56:40.740814 | 2026-01-08 00:02:12.235436 |
| SBN_to_AWS | neocp_prev_des | 70289 | 2026-01-07 19:56:40.740814 | 2026-01-08 00:02:12.332879 |
| MPC_primarydb | neocp_var | 93928 | 2026-01-08 00:02:12.174441 | 2026-01-08 00:02:12.425225 |
| MPC_mpcsbndb | neocp_var | 93928 | 2026-01-08 00:02:12.174441 | 2026-01-08 00:02:12.581264 |
| SBN_to_AWS | neocp_var | 93928 | 2026-01-07 23:52:28.667235 | 2026-01-08 00:02:12.697113 |
| MPC_primarydb | obscodes | 2667 | 2026-01-07 19:35:42.299558 | 2026-01-08 00:02:12.793507 |
| MPC_mpcsbndb | obscodes | 2667 | 2026-01-07 19:35:42.299558 | 2026-01-08 00:02:12.909414 |
| SBN_to_AWS | obscodes | 2667 | 2026-01-07 19:35:42.299558 | 2026-01-08 00:02:12.992515 |
| MPC_primarydb | primary_objects | 1532113 | 2026-01-08 00:02:03.476039 | 2026-01-08 00:02:13.080338 |
| MPC_mpcsbndb | primary_objects | 1532113 | 2026-01-08 00:02:03.476039 | 2026-01-08 00:02:13.475111 |
| SBN_to_AWS | primary_objects | 1532113 | 2026-01-08 00:02:03.476039 | 2026-01-08 00:02:13.63509 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-01-08 00:02:13.815074 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-01-08 00:02:13.918995 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-01-08 00:02:14.000444 | |
| MPC_primarydb | obs_alterations_deletions | 1465342 | 2026-01-07 17:08:45.397109 | 2026-01-08 00:02:14.084946 |
| MPC_mpcsbndb | obs_alterations_deletions | 1465342 | 2026-01-07 17:08:45.397109 | 2026-01-08 00:02:14.46125 |
| SBN_to_AWS | obs_alterations_deletions | 1465342 | 2026-01-07 17:08:45.397109 | 2026-01-08 00:02:14.597249 |
| MPC_primarydb | obs_alterations_redesignations | 4515 | 2026-01-03 19:19:15.911342 | 2026-01-08 00:02:14.743747 |
| MPC_mpcsbndb | obs_alterations_redesignations | 4515 | 2026-01-03 19:19:15.911342 | 2026-01-08 00:02:14.85056 |
| SBN_to_AWS | obs_alterations_redesignations | 4515 | 2026-01-03 19:19:15.911342 | 2026-01-08 00:02:14.93351 |