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-22 02:10:01 (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 | 11217 | 2026-01-20 19:48:47 | 2026-01-20 20:01:02 |
| identifications | 211641 | 2026-01-14 12:15:20 | 2026-01-14 12:15:20 |
| isolated_tracklets | 49739615 | 2026-01-22 00:58:17 | 2026-01-22 00:58:17 |
| 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 | 2011-10-28 09:36:11 | 2026-01-12 14:34:38 |
| 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 | 502476227 | 2026-01-22 00:17:59 | 2026-01-22 00:17:59 |
| orbit_uncertainties | 787193 | 2019-06-03 12:14:45 | 2022-06-02 16:46:34 |
| orbits | 1508866 | 2026-01-22 00:18:03 | 2026-01-22 01:01:02 |
| radar_observations | 1507 | 2024-12-04 04:59:18 | 2024-12-04 04:59:18 |
| Table | Count | Created_at | Updated_at |
| neocp_els | 88 | 2026-01-20 11:04:11.151956 | 2026-01-22 02:05:36.102583 |
| neocp_events | 308856 | 2026-01-22 02:05:36.489346 | 2026-01-22 02:05:36.489346 |
| neocp_obs_archive | 774427 | 2026-01-22 02:05:36.060663 | 2026-01-22 02:05:36.060663 |
| neocp_obs | 1203 | 2026-01-22 02:05:36.018785 | 2026-01-22 02:05:36.018785 |
| neocp_prev_des | 70711 | 2026-01-22 00:17:13.904938 | 2026-01-22 00:17:13.904938 |
| neocp_var | 160959 | 2026-01-22 02:05:36.277235 | 2026-01-22 02:05:36.277235 |
| current_identifications | 2019401 | 2026-01-22 02:13:22.288891 | 2026-01-22 02:13:22.288891 |
| numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2025-10-20 21:02:31.305341 |
| primary_objects | 1535127 | 2026-01-22 02:13:22.196416 | 2026-01-22 02:13:22.196416 |
| obs_sbn | 524987963 | 2026-01-21 09:26:16.485998-05 | 2026-01-21 21:13:24.882367-05 |
| obs_alterations_deletions | 1467424 | 2026-01-21 23:34:16.746386 | 2026-01-21 23:34:16.746386 |
| obs_alterations_redesignations | 4515 | 2026-01-03 19:19:15.911342 | 2026-01-03 19:19:15.911342 |
| obs_alterations_unassociations | 534363 | 2026-01-21 18:10:08.045471 | 2026-01-21 18:10:08.045471 |
| mpc_orbits | 1491352 | 2026-01-22 02:13:05.749134 | 2026-01-22 02:13:12.309263 |
| minor_planet_names | 25992 | 2011-10-27 06:38:13 | 2026-01-16 00:37:34.652007 |
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 | 524987960 | 2026-01-22 01:59:03.210964 | 2026-01-22 02:00:02.634955 |
| MPC_mpcsbndb | obs_sbn | 524987963 | 2026-01-22 02:00:08.794499 | 2026-01-22 02:00:15.517623 |
| SBN_to_AWS | obs_sbn | 524987963 | 2026-01-22 02:00:27.482391 | 2026-01-22 02:00:38.468872 |
| MPC_primarydb | current_identifications | 2019389 | 2026-01-22 02:00:58.352306 | 2026-01-22 02:01:17.666406 |
| MPC_mpcsbndb | current_identifications | 2019389 | 2026-01-22 02:00:58.352306 | 2026-01-22 02:01:18.177703 |
| SBN_to_AWS | current_identifications | 2019389 | 2026-01-22 02:00:58.352306 | 2026-01-22 02:01:18.406631 |
| MPC_primarydb | comet_names | 4293 | 2026-01-20 19:57:26.179106 | 2026-01-22 02:01:18.643547 |
| MPC_mpcsbndb | comet_names | 4293 | 2026-01-20 19:57:26.179106 | 2026-01-22 02:01:18.755537 |
| SBN_to_AWS | comet_names | 4293 | 2026-01-20 19:57:26.179106 | 2026-01-22 02:01:18.84445 |
| MPC_primarydb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-01-22 02:01:18.935819 |
| MPC_mpcsbndb | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-01-22 02:01:19.086663 |
| SBN_to_AWS | minor_planet_names | 25992 | 2026-01-16 00:37:34.652007 | 2026-01-22 02:01:19.189291 |
| MPC_primarydb | mpc_orbits | 1491341 | 2026-01-22 02:01:17.08689 | 2026-01-22 02:01:19.287011 |
| MPC_mpcsbndb | mpc_orbits | 1491341 | 2026-01-22 02:01:17.08689 | 2026-01-22 02:01:21.149774 |
| SBN_to_AWS | mpc_orbits | 1491341 | 2026-01-22 02:01:17.08689 | 2026-01-22 02:01:21.559485 |
| MPC_primarydb | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2026-01-22 02:01:21.981381 |
| MPC_mpcsbndb | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2026-01-22 02:01:22.283815 |
| SBN_to_AWS | numbered_identifications | 875979 | 2025-10-20 21:02:31.305341 | 2026-01-22 02:01:22.424671 |
| MPC_primarydb | neocp_els | 88 | 2026-01-22 01:52:34.80447 | 2026-01-22 02:01:22.567376 |
| MPC_mpcsbndb | neocp_els | 88 | 2026-01-22 01:52:34.80447 | 2026-01-22 02:01:22.678292 |
| SBN_to_AWS | neocp_els | 88 | 2026-01-22 01:52:34.80447 | 2026-01-22 02:01:22.766385 |
| MPC_primarydb | neocp_events | 308855 | 2026-01-22 01:52:35.039662 | 2026-01-22 02:01:22.857954 |
| MPC_mpcsbndb | neocp_events | 308855 | 2026-01-22 01:52:35.039662 | 2026-01-22 02:01:23.044567 |
| SBN_to_AWS | neocp_events | 308855 | 2026-01-22 01:52:35.039662 | 2026-01-22 02:01:23.170626 |
| MPC_primarydb | neocp_obs | 1200 | 2026-01-22 01:52:34.721927 | 2026-01-22 02:01:23.283333 |
| MPC_mpcsbndb | neocp_obs | 1200 | 2026-01-22 01:52:34.721927 | 2026-01-22 02:01:23.391751 |
| SBN_to_AWS | neocp_obs | 1200 | 2026-01-22 01:52:34.721927 | 2026-01-22 02:01:23.480161 |
| MPC_primarydb | neocp_obs_archive | 774424 | 2026-01-22 01:52:34.763342 | 2026-01-22 02:01:23.571719 |
| MPC_mpcsbndb | neocp_obs_archive | 774424 | 2026-01-22 01:52:34.763342 | 2026-01-22 02:01:23.788971 |
| SBN_to_AWS | neocp_obs_archive | 774424 | 2026-01-22 01:52:34.763342 | 2026-01-22 02:01:23.934419 |
| MPC_primarydb | neocp_prev_des | 70711 | 2026-01-22 00:17:13.904938 | 2026-01-22 02:01:24.072565 |
| MPC_mpcsbndb | neocp_prev_des | 70711 | 2026-01-22 00:17:13.904938 | 2026-01-22 02:01:24.214312 |
| SBN_to_AWS | neocp_prev_des | 70711 | 2026-01-22 00:17:13.904938 | 2026-01-22 02:01:24.317648 |
| MPC_primarydb | neocp_var | 160959 | 2026-01-22 01:52:34.897987 | 2026-01-22 02:01:24.416797 |
| MPC_mpcsbndb | neocp_var | 160959 | 2026-01-22 01:52:34.897987 | 2026-01-22 02:01:24.600952 |
| SBN_to_AWS | neocp_var | 160959 | 2026-01-22 01:52:34.897987 | 2026-01-22 02:01:24.731374 |
| MPC_primarydb | obscodes | 2673 | 2026-01-21 20:21:18.54046 | 2026-01-22 02:01:24.835718 |
| MPC_mpcsbndb | obscodes | 2673 | 2026-01-21 20:21:18.54046 | 2026-01-22 02:01:24.960066 |
| SBN_to_AWS | obscodes | 2673 | 2026-01-21 20:21:18.54046 | 2026-01-22 02:01:25.048458 |
| MPC_primarydb | primary_objects | 1535115 | 2026-01-22 02:00:25.231259 | 2026-01-22 02:01:25.139405 |
| MPC_mpcsbndb | primary_objects | 1535115 | 2026-01-22 02:00:25.231259 | 2026-01-22 02:01:25.554994 |
| SBN_to_AWS | primary_objects | 1535115 | 2026-01-22 02:00:25.231259 | 2026-01-22 02:01:25.725931 |
| MPC_primarydb | obs_alterations_corrections | 0 | 2026-01-22 02:01:25.910563 | |
| MPC_mpcsbndb | obs_alterations_corrections | 0 | 2026-01-22 02:01:26.020625 | |
| SBN_to_AWS | obs_alterations_corrections | 0 | 2026-01-22 02:01:26.107638 | |
| MPC_primarydb | obs_alterations_deletions | 1467424 | 2026-01-21 23:34:16.746386 | 2026-01-22 02:01:26.198177 |
| MPC_mpcsbndb | obs_alterations_deletions | 1467424 | 2026-01-21 23:34:16.746386 | 2026-01-22 02:01:26.622029 |
| SBN_to_AWS | obs_alterations_deletions | 1467424 | 2026-01-21 23:34:16.746386 | 2026-01-22 02:01:26.759365 |