Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

20 May 2024

  1. Nominal.

Please report concerns!

KEY

Database Replication

Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.

Latest update of every table in MPC MariaDB and Postgres

2024-07-18 10:40: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.

MariaDB mpc_development:

Source file of data: statusDB.csv

Table Count Created_at Updated_at
close_approaches 223366 2019-05-23 19:22:13 2019-05-23 19:22:13
comet_names 4586 2017-03-15 16:46:33 2017-03-15 16:46:33
comet_orbit_uncertainties 1015 2019-06-04 12:15:27 2019-06-04 12:15:27
comet_orbits 9442 2024-07-18 02:10:08 2024-07-18 02:31:04
identifications 196738 2024-07-13 12:06:23 2024-07-13 12:06:23
isolated_tracklets 46383640 2024-07-18 10:38:38 2024-07-18 10:38:38
mpc_indices 396 2024-07-18 10:30:02 2024-07-18 10:30:02
numbered_identifications 1100831 2024-05-27 04:43:45 2024-05-27 04:43:45
numbered_mps 699991 2012-05-09 14:38:19 2024-07-15 15:03:00
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 439575697 2024-07-18 02:10:02 2024-07-18 02:10:02
orbit_uncertainties 785580 2019-06-04 12:15:23 2024-05-27 15:31:39
orbits 1400481 2020-06-20 01:17:13 2024-07-17 14:31:12
perturbed_orbits 175724170 2018-09-27 17:20:33 2018-09-27 17:20:33
radar_observations 1507 2023-06-23 18:31:24 2023-06-23 18:31:24
No change in Maria mpc_development database structure.

Postgres mpc_sbn:

Table Count Created_at Updated_at
neocp_els 26 2024-06-15 08:54:14.26468 2024-07-18 05:32:16.8785
neocp_events 231231 2024-07-18 05:32:20.393255 2024-07-18 05:32:20.393255
neocp_obs_archive 588103 2024-07-18 05:32:16.87635 2024-07-18 05:32:16.87635
neocp_obs 501 2024-07-18 05:32:16.871781 2024-07-18 05:32:16.871781
neocp_prev_des 60414 2024-07-18 02:13:46.088424 2024-07-18 02:13:46.088424
neocp_var 46017 2024-07-18 05:32:20.362674 2024-07-18 05:32:20.362674
current_identifications 1909458 2024-07-18 02:00:28.494945 2024-07-18 02:09:41.912036
numbered_identifications 700773 2024-05-24 16:34:18.36268 2024-05-24 16:34:18.36268
primary_objects 1432436 2024-07-18 02:00:28.268567 2024-07-18 02:00:28.268567
obs_sbn 450365114 2024-07-18 06:09:06.222554-04 2024-07-18 06:42:05.655344-04
obs_alterations_deletions 1288063 2024-07-18 00:40:27.641663 2024-07-18 00:40:27.641663
obs_alterations_redesignations 3775 2024-07-11 15:53:20.134917 2024-07-11 15:53:20.134917
obs_alterations_unassociations 309775 2024-07-18 09:59:06.270358 2024-07-18 09:59:06.270358
mpc_orbits 1380220 2024-06-13 20:56:12.726281 2024-07-18 10:45:10.279441
No change to Postgres mpc_sbn database structure

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

Replication status view MPC-master → [SBN] → MPC-replica:

Server Table Count Updated_at Queried_at
MPC_marsden obs_sbn 450364186 2024-07-18 09:59:08.586621 2024-07-18 10:00:02.268053
MPC_mpcweb5 obs_sbn 450364611 2024-07-18 10:12:11.800008 2024-07-18 10:14:05.012383
SBN_to_AWS obs_sbn 450364611 2024-07-18 10:12:11.800008 2024-07-18 10:15:31.869332
MPC_marsden current_identifications 1909458 2024-07-18 02:09:41.912036 2024-07-18 10:28:36.241304
MPC_mpcweb5 current_identifications 1909458 2024-07-18 02:09:41.912036 2024-07-18 10:28:37.323911
SBN_to_AWS current_identifications 1909458 2024-07-18 02:09:41.912036 2024-07-18 10:28:38.587209
MPC_marsden mpc_orbits 1380220 2024-07-18 10:12:10.785674 2024-07-18 10:28:38.860164
MPC_mpcweb5 mpc_orbits 1380220 2024-07-18 10:12:10.785674 2024-07-18 10:28:39.941858
SBN_to_AWS mpc_orbits 1380220 2024-07-18 10:12:10.785674 2024-07-18 10:28:41.168215
MPC_marsden numbered_identifications 700773 2024-05-24 16:34:18.36268 2024-07-18 10:28:41.42187
MPC_mpcweb5 numbered_identifications 700773 2024-05-24 16:34:18.36268 2024-07-18 10:28:41.653661
SBN_to_AWS numbered_identifications 700773 2024-05-24 16:34:18.36268 2024-07-18 10:28:41.947468
MPC_marsden neocp_els 26 2024-07-18 05:32:16.8785 2024-07-18 10:28:42.09538
MPC_mpcweb5 neocp_els 26 2024-07-18 05:32:16.8785 2024-07-18 10:28:42.178919
SBN_to_AWS neocp_els 26 2024-07-18 05:32:16.8785 2024-07-18 10:28:42.268202
MPC_marsden neocp_events 231231 2024-07-18 05:32:20.393255 2024-07-18 10:28:42.357613
MPC_mpcweb5 neocp_events 231231 2024-07-18 05:32:20.393255 2024-07-18 10:28:42.49832
SBN_to_AWS neocp_events 231231 2024-07-18 05:32:20.393255 2024-07-18 10:28:42.665018
MPC_marsden neocp_obs 501 2024-07-18 05:32:16.871781 2024-07-18 10:28:42.776592
MPC_mpcweb5 neocp_obs 501 2024-07-18 05:32:16.871781 2024-07-18 10:28:42.860409
SBN_to_AWS neocp_obs 501 2024-07-18 05:32:16.871781 2024-07-18 10:28:42.951839
MPC_marsden neocp_obs_archive 588103 2024-07-18 05:32:16.87635 2024-07-18 10:28:43.041414
MPC_mpcweb5 neocp_obs_archive 588103 2024-07-18 05:32:16.87635 2024-07-18 10:28:43.231842
SBN_to_AWS neocp_obs_archive 588103 2024-07-18 05:32:16.87635 2024-07-18 10:28:43.427583
MPC_marsden neocp_prev_des 60414 2024-07-18 02:13:46.088424 2024-07-18 10:28:43.561463
MPC_mpcweb5 neocp_prev_des 60414 2024-07-18 02:13:46.088424 2024-07-18 10:28:43.659232
SBN_to_AWS neocp_prev_des 60414 2024-07-18 02:13:46.088424 2024-07-18 10:28:43.790729
MPC_marsden neocp_var 46017 2024-07-18 05:32:20.362674 2024-07-18 10:28:43.890712
MPC_mpcweb5 neocp_var 46017 2024-07-18 05:32:20.362674 2024-07-18 10:28:44.000171
SBN_to_AWS neocp_var 48017 2024-07-18 05:32:20.362674 2024-07-18 10:28:44.146521
MPC_marsden primary_objects 1432436 2024-07-18 02:00:28.268567 2024-07-18 10:28:44.244562
MPC_mpcweb5 primary_objects 1432436 2024-07-18 02:00:28.268567 2024-07-18 10:28:44.68317
SBN_to_AWS primary_objects 1432436 2024-07-18 02:00:28.268567 2024-07-18 10:28:45.484941
MPC_marsden obs_alterations_corrections 2024-07-18 10:28:45.731047
MPC_mpcweb5 obs_alterations_corrections 2024-07-18 10:28:45.814367
SBN_to_AWS obs_alterations_corrections 2024-07-18 10:28:45.902123
MPC_marsden obs_alterations_deletions 1288063 2024-07-18 00:40:27.641663 2024-07-18 10:28:45.991457
MPC_mpcweb5 obs_alterations_deletions 1288063 2024-07-18 00:40:27.641663 2024-07-18 10:28:46.318497
SBN_to_AWS obs_alterations_deletions 1288063 2024-07-18 00:40:27.641663 2024-07-18 10:28:46.957091
MPC_marsden obs_alterations_redesignations 3775 2024-07-11 15:53:20.134917 2024-07-18 10:28:47.135949
MPC_mpcweb5 obs_alterations_redesignations 3775 2024-07-11 15:53:20.134917 2024-07-18 10:28:47.220737
SBN_to_AWS obs_alterations_redesignations 3775 2024-07-11 15:53:20.134917 2024-07-18 10:28:47.312124