Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

18 Sep 2023

  1. SBN server is up and running. Replication of SBN MariaDB copy is fixed and available for usage. Both Postgres databases (mpcbeta and mpc_sbn) are available for subscription.

Please report concerns!

KEY

Database Replication

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

Latest update of every table in MPC MariaDB and Postgres

2023-09-25 06:00:02 (GMT)

Status of all major tables from MariaDB (mpc_development) and two parallel Postgres databases (mpcbeta and 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 9083 2023-09-21 21:32:38 2023-09-21 21:32:38
identifications 613066 2023-09-12 12:17:45 2023-09-12 12:17:45
isolated_tracklets 40795805 2023-09-25 05:58:19 2023-09-25 05:58:19
mpc_indices 396 2023-09-25 06:00:03 2023-09-25 06:00:03
numbered_identifications 1005134 2023-07-19 20:18:28 2023-07-19 20:18:28
numbered_mps 623827 2011-10-27 01:30:19 2023-08-14 21:24:27
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 397012657 2023-09-25 02:17:14 2023-09-25 04:11:35
orbit_uncertainties 787153 2019-06-03 12:14:53 2023-04-21 05:47:13
orbits 1313568 2023-09-25 02:17:26 2023-09-25 02:31:04
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 mpcbeta:

Table Count Created_at Updated_at
neocp_els 107 2023-09-24 09:08:53.602276 2023-09-25 06:01:39.618246
neocp_events 196759 2023-09-25 06:01:41.920021 2023-09-25 06:01:41.920021
neocp_obs_archive 508660 2023-09-25 06:01:39.616828 2023-09-25 06:01:39.616828
neocp_obs 1006 2023-09-25 06:01:39.612968 2023-09-25 06:01:39.612968
neocp_prev_des 55817 2023-09-25 05:37:03.605046 2023-09-25 05:37:03.605046
neocp_var 205401 2023-09-25 06:01:41.898048 2023-09-25 06:01:41.898048
current_identifications 1837594 2023-09-25 05:36:37.59433 2023-09-25 05:36:37.59433
numbered_identifications 624590 2020-07-30 16:51:34.796062 2023-08-28 16:21:41.295108
primary_objects 1211321 2021-09-28 18:55:58.729643 2021-09-28 18:55:58.729643
No change to Postgres mpcbeta database structure

Postgres mpc_sbn:

Table Count Created_at Updated_at
neocp_els 107 2023-09-24 09:08:53.602276 2023-09-25 06:01:39.618246
neocp_events 196759 2023-09-25 06:01:41.920021 2023-09-25 06:01:41.920021
neocp_obs_archive 508660 2023-09-25 06:01:39.616828 2023-09-25 06:01:39.616828
neocp_obs 1006 2023-09-25 06:01:39.612968 2023-09-25 06:01:39.612968
neocp_prev_des 55817 2023-09-25 05:37:03.605046 2023-09-25 05:37:03.605046
neocp_var 205401 2023-09-25 06:01:41.898048 2023-09-25 06:01:41.898048
current_identifications 1837594 2023-09-25 05:36:37.59433 2023-09-25 05:36:37.59433
numbered_identifications 624590 2020-07-30 16:51:34.796062 2023-08-28 16:21:41.295108
primary_objects 1365941 2023-09-25 05:36:37.56658 2023-09-25 05:36:37.56658
obs_sbn 408647124 2023-09-25 01:56:03.828367-04 2023-09-25 02:00:38.393905-04
obs_alterations_deletions 908635 2023-09-25 02:20:57.768853 2023-09-25 02:20:57.768853
obs_alterations_redesignations 2707 2023-08-28 22:22:13.362713 2023-08-28 22:22:13.362713
obs_alterations_unassociations 37608 2023-09-25 02:43:49.954093 2023-09-25 02:43:49.954093
mpc_orbits 1303856 2021-02-04 01:10:21.383471 2023-09-25 06:05:24.957169
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 408647025 2023-09-25 04:50:33.032399 2023-09-25 05:00:02.69682
MPC_mpcweb5 obs_sbn 408647040 2023-09-25 05:08:12.892515 2023-09-25 05:10:42.13983
SBN_to_AWS obs_sbn 408647042 2023-09-25 05:15:21.616532 2023-09-25 05:17:51.228645
MPC_marsden current_identifications 1837593 2023-09-25 04:23:21.340915 2023-09-25 05:24:52.771284
MPC_mpcweb5 current_identifications 1837593 2023-09-25 04:23:21.340915 2023-09-25 05:24:53.228839
SBN_to_AWS current_identifications 1837593 2023-09-25 04:23:21.340915 2023-09-25 05:24:53.366089
MPC_marsden mpc_orbits 1303855 2023-09-25 05:15:21.002376 2023-09-25 05:24:53.758092
MPC_mpcweb5 mpc_orbits 1303855 2023-09-25 05:15:21.002376 2023-09-25 05:24:55.589106
SBN_to_AWS mpc_orbits 1303855 2023-09-25 05:15:21.002376 2023-09-25 05:24:55.704049
MPC_marsden numbered_identifications 624590 2023-08-28 16:21:41.295108 2023-09-25 05:24:55.935498
MPC_mpcweb5 numbered_identifications 624590 2023-08-28 16:21:41.295108 2023-09-25 05:24:56.144414
SBN_to_AWS numbered_identifications 624590 2023-08-28 16:21:41.295108 2023-09-25 05:24:56.242737
MPC_marsden neocp_els 106 2023-09-25 05:09:41.629564 2023-09-25 05:24:56.3952
MPC_mpcweb5 neocp_els 106 2023-09-25 05:09:41.629564 2023-09-25 05:24:56.467088
SBN_to_AWS neocp_els 106 2023-09-25 05:09:41.629564 2023-09-25 05:24:56.535531
MPC_marsden neocp_events 196752 2023-09-25 05:09:44.112162 2023-09-25 05:24:56.609622
MPC_mpcweb5 neocp_events 196752 2023-09-25 05:09:44.112162 2023-09-25 05:24:56.735266
SBN_to_AWS neocp_events 196752 2023-09-25 05:09:44.112162 2023-09-25 05:24:56.820077
MPC_marsden neocp_obs 1002 2023-09-25 05:09:41.62343 2023-09-25 05:24:56.927395
MPC_mpcweb5 neocp_obs 1002 2023-09-25 05:09:41.62343 2023-09-25 05:24:56.999164
SBN_to_AWS neocp_obs 1002 2023-09-25 05:09:41.62343 2023-09-25 05:24:57.067942
MPC_marsden neocp_obs_archive 508640 2023-09-25 05:09:41.627135 2023-09-25 05:24:57.145121
MPC_mpcweb5 neocp_obs_archive 508640 2023-09-25 05:09:41.627135 2023-09-25 05:24:57.318282
SBN_to_AWS neocp_obs_archive 508640 2023-09-25 05:09:41.627135 2023-09-25 05:24:57.405033
MPC_marsden neocp_prev_des 55816 2023-09-25 05:05:48.888617 2023-09-25 05:24:57.55915
MPC_mpcweb5 neocp_prev_des 55816 2023-09-25 05:05:48.888617 2023-09-25 05:24:57.648671
SBN_to_AWS neocp_prev_des 55816 2023-09-25 05:05:48.888617 2023-09-25 05:24:57.724876
MPC_marsden neocp_var 203410 2023-09-25 05:09:44.089516 2023-09-25 05:24:57.811246
MPC_mpcweb5 neocp_var 203410 2023-09-25 05:09:44.089516 2023-09-25 05:24:57.962816
SBN_to_AWS neocp_var 203410 2023-09-25 05:09:44.089516 2023-09-25 05:24:58.05121
MPC_marsden primary_objects 1365940 2023-09-25 04:22:40.065105 2023-09-25 05:24:58.194622
MPC_mpcweb5 primary_objects 1365940 2023-09-25 04:22:40.065105 2023-09-25 05:24:58.60167
SBN_to_AWS primary_objects 1365940 2023-09-25 04:22:40.065105 2023-09-25 05:24:58.733189
MPC_marsden obs_alterations_corrections 2023-09-25 05:24:58.987942
MPC_mpcweb5 obs_alterations_corrections 2023-09-25 05:24:59.058797
SBN_to_AWS obs_alterations_corrections 2023-09-25 05:24:59.127079
MPC_marsden obs_alterations_deletions 908635 2023-09-25 02:20:57.768853 2023-09-25 05:24:59.198797
MPC_mpcweb5 obs_alterations_deletions 908635 2023-09-25 02:20:57.768853 2023-09-25 05:24:59.744136
SBN_to_AWS obs_alterations_deletions 908635 2023-09-25 02:20:57.768853 2023-09-25 05:24:59.849307
MPC_marsden obs_alterations_redesignations 2707 2023-08-28 22:22:13.362713 2023-09-25 05:25:00.034976
MPC_mpcweb5 obs_alterations_redesignations 2707 2023-08-28 22:22:13.362713 2023-09-25 05:25:00.10831
SBN_to_AWS obs_alterations_redesignations 2707 2023-08-28 22:22:13.362713 2023-09-25 05:25:00.177133