Minor Planet Center Annex

@ SBN

DOWNTIME ANNOUNCEMENT

01 Feb 2023: There may be brief power/network outages on Wed 01 Feb 2023 between 6-8 EST (11:00-13:00 UTC) due to electrical work in the building.
Thank you for your patience.

 

Database Status: ORANGE

27 Jan 2023

  1. SBN server is up and running. mpc_sbn database is updated in real-time only 5 out of 10 tables. Help is on the way. Stay tuned.

Please report concerns!

KEY

Latest update of every table in MPC MariaDB and Postgres

2023-01-29 18:40:01 (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 12117 2014-02-10 15:54:22 2023-01-28 04:31:05
identifications 610270 2023-01-27 12:11:21 2023-01-27 12:11:21
isolated_tracklets 39652498 2023-01-29 16:06:08 2023-01-29 16:06:08
mpc_indices 396 2023-01-29 18:30:03 2023-01-29 18:30:03
numbered_identifications 1000224 2022-11-19 08:43:22 2022-11-19 08:43:22
numbered_mps 619999 2013-03-28 19:29:15 2022-12-02 20:26:41
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 364998535 2023-01-29 17:43:03 2023-01-29 17:43:03
orbit_uncertainties 787161 2019-06-03 12:14:44 2022-11-19 08:56:04
orbits 1264934 2023-01-29 17:43:07 2023-01-29 18:31:04
perturbed_orbits 175724170 2018-09-27 17:20:33 2018-09-27 17:20:33
radar_observations 1507 2019-05-30 03:12:41 2019-05-30 03:12:41
No change in Maria mpc_development database structure.

Postgres mpcbeta:

Table Count Created_at Updated_at
neocp_els 84 2022-12-24 11:48:22.992896 2023-01-29 17:31:32.99238
neocp_events 168878 2023-01-29 17:42:23.143472 2023-01-29 17:42:23.143472
neocp_obs_archive 444344 2023-01-29 17:31:32.988171 2023-01-29 17:31:32.988171
neocp_obs 1316 2023-01-29 17:31:32.98249 2023-01-29 17:31:32.98249
neocp_prev_des 52324 2023-01-29 17:42:23.123242 2023-01-29 17:42:23.123242
neocp_var 159901 2023-01-29 17:31:33.709755 2023-01-29 17:31:33.709755
current_identifications 1795298 2023-01-29 17:41:54.561626 2023-01-29 17:42:23.395078
numbered_identifications 620748 2022-11-18 15:30:54.523925 2022-11-18 15:30:54.523925
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 84 2022-12-24 11:48:22.992896 2023-01-29 17:31:32.99238
neocp_events 168878 2023-01-29 17:42:23.143472 2023-01-29 17:42:23.143472
neocp_obs_archive 444344 2023-01-29 17:31:32.988171 2023-01-29 17:31:32.988171
neocp_obs 1316 2023-01-29 17:31:32.98249 2023-01-29 17:31:32.98249
neocp_prev_des 52324 2023-01-29 17:42:23.123242 2023-01-29 17:42:23.123242
neocp_var 159901 2023-01-29 17:31:33.709755 2023-01-29 17:31:33.709755
current_identifications 1795298 2023-01-29 17:41:54.561626 2023-01-29 17:42:23.395078
numbered_identifications 620748 2022-11-18 15:30:54.523925 2022-11-18 15:30:54.523925
primary_objects 0 1970-01-01 00:00:00.0 1970-01-01 00:00:00.0
obs_sbn 374647004 2023-01-25 23:08:03.859468-05 2023-01-25 23:09:19.366977-05
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 375123820 2023-01-29 17:55:17.408861 2023-01-29 18:00:01.869895
MPC_mpcweb5 obs_sbn 375123855 2023-01-29 18:10:17.106387 2023-01-29 18:11:03.274448
SBN_to_AWS obs_sbn 2023-01-29 18:17:27.480481
MPC_marsden current_identifications 1795298 2023-01-29 17:42:23.395078 2023-01-29 18:17:27.560508
MPC_mpcweb5 current_identifications 1795298 2023-01-29 17:42:23.395078 2023-01-29 18:17:27.983797
SBN_to_AWS current_identifications 1795298 2023-01-29 17:42:23.395078 2023-01-29 18:17:28.122804
MPC_marsden numbered_identifications 620748 2022-11-18 15:30:54.523925 2023-01-29 18:17:28.341353
MPC_mpcweb5 numbered_identifications 620748 2022-11-18 15:30:54.523925 2023-01-29 18:17:28.551469
SBN_to_AWS numbered_identifications 620748 2022-11-18 15:30:54.523925 2023-01-29 18:17:28.650601
MPC_marsden neocp_els 83 2023-01-29 17:31:32.99238 2023-01-29 18:17:28.767876
MPC_mpcweb5 neocp_els 83 2023-01-29 17:31:32.99238 2023-01-29 18:17:28.841059
SBN_to_AWS neocp_els 83 2023-01-29 17:31:32.99238 2023-01-29 18:17:28.911139
MPC_marsden neocp_events 168878 2023-01-29 17:42:23.143472 2023-01-29 18:17:28.982508
MPC_mpcweb5 neocp_events 168878 2023-01-29 17:42:23.143472 2023-01-29 18:17:29.107064
SBN_to_AWS neocp_events 168878 2023-01-29 17:42:23.143472 2023-01-29 18:17:29.19763
MPC_marsden neocp_obs 1300 2023-01-29 17:31:32.98249 2023-01-29 18:17:29.288508
MPC_mpcweb5 neocp_obs 1300 2023-01-29 17:31:32.98249 2023-01-29 18:17:29.362747
SBN_to_AWS neocp_obs 1300 2023-01-29 17:31:32.98249 2023-01-29 18:17:29.433229
MPC_marsden neocp_obs_archive 444344 2023-01-29 17:31:32.988171 2023-01-29 18:17:29.504937
MPC_mpcweb5 neocp_obs_archive 444344 2023-01-29 17:31:32.988171 2023-01-29 18:17:29.686196
SBN_to_AWS neocp_obs_archive 444344 2023-01-29 17:31:32.988171 2023-01-29 18:17:29.786243
MPC_marsden neocp_prev_des 52324 2023-01-29 17:42:23.123242 2023-01-29 18:17:29.889503
MPC_mpcweb5 neocp_prev_des 52324 2023-01-29 17:42:23.123242 2023-01-29 18:17:29.980549
SBN_to_AWS neocp_prev_des 52324 2023-01-29 17:42:23.123242 2023-01-29 18:17:30.057872
MPC_marsden neocp_var 157995 2023-01-29 17:31:33.709755 2023-01-29 18:17:30.135928
MPC_mpcweb5 neocp_var 157995 2023-01-29 17:31:33.709755 2023-01-29 18:17:30.280498
SBN_to_AWS neocp_var 157995 2023-01-29 17:31:33.709755 2023-01-29 18:17:30.368786