-- Logs begin at Wed 2022-02-16 12:51:15 EST, end at Wed 2022-02-23 10:15:01 EST. -- Feb 21 12:10:44 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:44 355834 [Warning] Aborted connection 355834 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:46 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:46 355836 [Warning] Aborted connection 355836 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:47 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:47 355841 [Warning] Aborted connection 355841 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:47 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:47 355842 [Warning] Aborted connection 355842 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:48 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:48 355844 [Warning] Aborted connection 355844 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:51 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:51 355847 [Warning] Aborted connection 355847 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:52 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:52 355850 [Warning] Aborted connection 355850 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:52 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:52 355851 [Warning] Aborted connection 355851 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:53 355853 [Warning] Aborted connection 355853 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:55 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:55 355857 [Warning] Aborted connection 355857 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:56 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:56 355859 [Warning] Aborted connection 355859 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:56 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:56 355860 [Warning] Aborted connection 355860 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:57 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:57 355861 [Warning] Aborted connection 355861 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:58 355864 [Warning] Aborted connection 355864 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:10:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:10:59 355867 [Warning] Aborted connection 355867 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:02 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:02 355871 [Warning] Aborted connection 355871 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:03 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:03 355873 [Warning] Aborted connection 355873 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:03 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:03 355874 [Warning] Aborted connection 355874 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:03 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:03 355875 [Warning] Aborted connection 355875 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:04 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:04 355876 [Warning] Aborted connection 355876 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:05 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:05 355877 [Warning] Aborted connection 355877 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:06 355878 [Warning] Aborted connection 355878 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:06 355881 [Warning] Aborted connection 355881 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:08 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:08 355887 [Warning] Aborted connection 355887 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:12 355895 [Warning] Aborted connection 355895 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:13 355898 [Warning] Aborted connection 355898 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:13 355899 [Warning] Aborted connection 355899 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:15 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:15 355903 [Warning] Aborted connection 355903 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:15 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:15 355904 [Warning] Aborted connection 355904 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:16 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:16 355907 [Warning] Aborted connection 355907 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:16 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:16 355908 [Warning] Aborted connection 355908 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:17 355909 [Warning] Aborted connection 355909 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:18 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:18 355910 [Warning] Aborted connection 355910 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:20 355914 [Warning] Aborted connection 355914 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:22 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:22 355915 [Warning] Aborted connection 355915 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:24 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:24 355918 [Warning] Aborted connection 355918 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:28 355926 [Warning] Aborted connection 355926 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:28 355927 [Warning] Aborted connection 355927 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:28 355930 [Warning] Aborted connection 355930 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:30 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:30 355933 [Warning] Aborted connection 355933 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:30 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:30 355935 [Warning] Aborted connection 355935 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:31 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:31 355936 [Warning] Aborted connection 355936 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:31 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:31 355937 [Warning] Aborted connection 355937 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:31 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:31 355940 [Warning] Aborted connection 355940 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:31 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:31 355941 [Warning] Aborted connection 355941 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:32 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:32 355942 [Warning] Aborted connection 355942 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:33 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:33 355944 [Warning] Aborted connection 355944 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:35 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:35 355948 [Warning] Aborted connection 355948 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:36 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:36 355949 [Warning] Aborted connection 355949 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:37 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:37 355952 [Warning] Aborted connection 355952 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:37 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:37 355953 [Warning] Aborted connection 355953 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:39 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:39 355956 [Warning] Aborted connection 355956 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:39 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:39 355958 [Warning] Aborted connection 355958 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:43 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:43 355962 [Warning] Aborted connection 355962 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:43 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:43 355964 [Warning] Aborted connection 355964 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:47 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:47 355975 [Warning] Aborted connection 355975 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:48 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:48 355976 [Warning] Aborted connection 355976 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:50 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:50 355981 [Warning] Aborted connection 355981 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:50 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:50 355983 [Warning] Aborted connection 355983 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:50 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:50 355985 [Warning] Aborted connection 355985 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:52 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:52 355992 [Warning] Aborted connection 355992 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:53 355995 [Warning] Aborted connection 355995 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:53 355997 [Warning] Aborted connection 355997 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:53 355998 [Warning] Aborted connection 355998 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:54 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:54 355999 [Warning] Aborted connection 355999 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:56 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:56 356005 [Warning] Aborted connection 356005 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:11:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:11:59 356011 [Warning] Aborted connection 356011 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:00 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:00 356014 [Warning] Aborted connection 356014 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:00 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:00 356016 [Warning] Aborted connection 356016 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:02 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:02 356021 [Warning] Aborted connection 356021 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:06 356032 [Warning] Aborted connection 356032 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:07 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:07 356034 [Warning] Aborted connection 356034 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:07 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:07 356037 [Warning] Aborted connection 356037 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:08 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:08 356038 [Warning] Aborted connection 356038 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:08 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:08 356039 [Warning] Aborted connection 356039 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:11 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:11 356051 [Warning] Aborted connection 356051 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:12 356055 [Warning] Aborted connection 356055 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:12 356056 [Warning] Aborted connection 356056 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:13 356059 [Warning] Aborted connection 356059 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:15 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:15 356063 [Warning] Aborted connection 356063 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:15 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:15 356064 [Warning] Aborted connection 356064 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:16 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:16 356065 [Warning] Aborted connection 356065 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:18 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:18 356069 [Warning] Aborted connection 356069 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:20 356072 [Warning] Aborted connection 356072 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:21 356074 [Warning] Aborted connection 356074 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:23 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:23 356076 [Warning] Aborted connection 356076 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:27 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:27 356084 [Warning] Aborted connection 356084 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:28 356087 [Warning] Aborted connection 356087 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:28 356088 [Warning] Aborted connection 356088 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:29 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:29 356089 [Warning] Aborted connection 356089 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:29 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:29 356090 [Warning] Aborted connection 356090 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:29 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:29 356091 [Warning] Aborted connection 356091 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:30 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:30 356094 [Warning] Aborted connection 356094 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:30 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:30 356095 [Warning] Aborted connection 356095 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:31 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:31 356096 [Warning] Aborted connection 356096 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:32 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:32 356098 [Warning] Aborted connection 356098 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:32 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:32 356100 [Warning] Aborted connection 356100 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:32 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:32 356101 [Warning] Aborted connection 356101 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:32 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:32 356102 [Warning] Aborted connection 356102 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:35 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:35 356105 [Warning] Aborted connection 356105 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:36 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:36 356109 [Warning] Aborted connection 356109 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:37 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:37 356112 [Warning] Aborted connection 356112 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:37 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:37 356113 [Warning] Aborted connection 356113 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:39 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:39 356116 [Warning] Aborted connection 356116 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:39 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:39 356117 [Warning] Aborted connection 356117 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:40 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:40 356118 [Warning] Aborted connection 356118 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:42 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:42 356120 [Warning] Aborted connection 356120 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:43 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:43 356122 [Warning] Aborted connection 356122 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:44 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:44 356124 [Warning] Aborted connection 356124 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:45 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:45 356126 [Warning] Aborted connection 356126 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:45 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:45 356127 [Warning] Aborted connection 356127 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:47 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:47 356131 [Warning] Aborted connection 356131 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:52 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:52 356140 [Warning] Aborted connection 356140 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:55 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:55 356142 [Warning] Aborted connection 356142 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:56 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:56 356146 [Warning] Aborted connection 356146 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:12:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:12:59 356153 [Warning] Aborted connection 356153 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:01 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:01 356159 [Warning] Aborted connection 356159 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:02 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:02 356160 [Warning] Aborted connection 356160 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:05 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:05 356166 [Warning] Aborted connection 356166 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:06 353607 [Warning] Aborted connection 353607 to db: 'ctsiredcap' user: 'RedcapWeb' host: 'redcap-web02.dbmi.pitt.edu' (Got an error writing communication packets) Feb 21 12:13:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:06 356169 [Warning] Aborted connection 356169 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:08 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:08 356172 [Warning] Aborted connection 356172 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:10 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:10 356174 [Warning] Aborted connection 356174 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:11 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:11 356178 [Warning] Aborted connection 356178 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:12 356182 [Warning] Aborted connection 356182 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:12 356183 [Warning] Aborted connection 356183 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:15 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:15 356186 [Warning] Aborted connection 356186 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:15 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:15 356187 [Warning] Aborted connection 356187 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:16 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:16 356190 [Warning] Aborted connection 356190 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:16 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:16 356191 [Warning] Aborted connection 356191 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:17 356192 [Warning] Aborted connection 356192 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:17 356195 [Warning] Aborted connection 356195 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:18 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:18 356196 [Warning] Aborted connection 356196 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:18 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:18 356197 [Warning] Aborted connection 356197 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:19 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:19 356199 [Warning] Aborted connection 356199 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:20 356200 [Warning] Aborted connection 356200 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:20 356201 [Warning] Aborted connection 356201 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:20 353529 [Warning] Aborted connection 353529 to db: 'ctsiredcap' user: 'RedcapWeb' host: 'redcap-web02.dbmi.pitt.edu' (Got an error writing communication packets) Feb 21 12:13:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:21 356204 [Warning] Aborted connection 356204 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:23 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:23 356207 [Warning] Aborted connection 356207 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:23 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:23 356208 [Warning] Aborted connection 356208 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:27 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:27 356213 [Warning] Aborted connection 356213 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:29 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:29 356215 [Warning] Aborted connection 356215 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:30 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:30 356217 [Warning] Aborted connection 356217 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:30 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:30 356218 [Warning] Aborted connection 356218 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:30 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:30 356221 [Warning] Aborted connection 356221 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:31 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:31 356222 [Warning] Aborted connection 356222 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:31 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:31 356223 [Warning] Aborted connection 356223 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:32 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:32 356224 [Warning] Aborted connection 356224 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:32 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:32 356226 [Warning] Aborted connection 356226 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:33 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:33 356228 [Warning] Aborted connection 356228 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:36 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:36 356237 [Warning] Aborted connection 356237 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:37 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:37 356238 [Warning] Aborted connection 356238 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:38 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:38 356241 [Warning] Aborted connection 356241 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:41 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:41 356247 [Warning] Aborted connection 356247 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:43 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:43 356250 [Warning] Aborted connection 356250 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:45 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:45 356253 [Warning] Aborted connection 356253 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:46 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:46 356255 [Warning] Aborted connection 356255 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:46 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:46 356256 [Warning] Aborted connection 356256 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:47 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:47 356258 [Warning] Aborted connection 356258 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:47 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:47 356259 [Warning] Aborted connection 356259 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:47 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:47 356260 [Warning] Aborted connection 356260 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:50 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:50 356264 [Warning] Aborted connection 356264 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:50 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:50 356265 [Warning] Aborted connection 356265 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:50 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:50 356266 [Warning] Aborted connection 356266 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:51 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:51 356267 [Warning] Aborted connection 356267 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:52 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:52 356270 [Warning] Aborted connection 356270 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:52 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:52 356271 [Warning] Aborted connection 356271 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:52 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:52 356272 [Warning] Aborted connection 356272 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:52 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:52 356273 [Warning] Aborted connection 356273 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:54 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:54 356276 [Warning] Aborted connection 356276 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:57 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:57 356280 [Warning] Aborted connection 356280 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:57 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:57 356283 [Warning] Aborted connection 356283 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:13:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:13:59 356285 [Warning] Aborted connection 356285 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:00 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:00 356287 [Warning] Aborted connection 356287 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:00 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:00 356288 [Warning] Aborted connection 356288 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:00 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:00 356289 [Warning] Aborted connection 356289 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:02 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:02 356291 [Warning] Aborted connection 356291 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:02 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:02 356293 [Warning] Aborted connection 356293 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:02 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:02 356294 [Warning] Aborted connection 356294 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:03 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:03 356296 [Warning] Aborted connection 356296 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:05 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:05 356300 [Warning] Aborted connection 356300 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:06 356301 [Warning] Aborted connection 356301 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:07 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:07 356302 [Warning] Aborted connection 356302 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:08 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:08 356305 [Warning] Aborted connection 356305 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:10 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:10 356306 [Warning] Aborted connection 356306 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:12 356310 [Warning] Aborted connection 356310 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:12 356312 [Warning] Aborted connection 356312 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:14 356318 [Warning] Aborted connection 356318 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:15 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:15 356321 [Warning] Aborted connection 356321 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:15 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:15 356322 [Warning] Aborted connection 356322 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:15 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:15 356323 [Warning] Aborted connection 356323 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:17 356327 [Warning] Aborted connection 356327 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:17 356328 [Warning] Aborted connection 356328 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:25 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:25 356340 [Warning] Aborted connection 356340 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:48 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:48 356397 [Warning] Aborted connection 356397 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:49 356400 [Warning] Aborted connection 356400 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:49 356402 [Warning] Aborted connection 356402 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:50 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:50 356405 [Warning] Aborted connection 356405 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:51 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:51 356409 [Warning] Aborted connection 356409 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:51 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:51 356410 [Warning] Aborted connection 356410 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:53 356413 [Warning] Aborted connection 356413 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:14:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:14:59 356426 [Warning] Aborted connection 356426 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:15:09 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:15:09 356457 [Warning] Aborted connection 356457 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:15:32 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:15:32 356498 [Warning] Aborted connection 356498 to db: 'unconnected' user: 'unauthenticated' host: 'redcap-web02.dbmi.pitt.edu' (This connection closed normally without authentication) Feb 21 12:16:10 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:16:10 356356 [Warning] Aborted connection 356356 to db: 'ctsiredcap' user: 'RedcapWeb' host: 'redcap-web02.dbmi.pitt.edu' (Got an error writing communication packets) Feb 21 12:39:16 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:39:16 362814 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 362814, query: select record from redcap_record_list Feb 21 12:39:16 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 12:40:51 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:40:51 363257 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 363257, query: select record from redcap_record_list Feb 21 12:40:51 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 12:40:51 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:40:51 363259 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 363259, query: select record from redcap_record_list Feb 21 12:40:51 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 12:41:08 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:41:08 363340 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 363340, query: select record from redcap_record_list Feb 21 12:41:08 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 12:49:37 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:49:37 365278 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 365278, query: select record from redcap_record_list Feb 21 12:49:37 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 12:49:40 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:49:40 365304 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 365304, query: select record from redcap_record_list Feb 21 12:49:40 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 12:52:41 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:52:41 366099 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 366099, query: select record from redcap_record_list Feb 21 12:52:41 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 12:56:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:56:58 367280 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 367280, query: select record from redcap_record_list Feb 21 12:56:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 12:57:00 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 12:57:00 367283 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 367283, query: select record from redcap_record_list Feb 21 12:57:00 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 13:32:39 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 13:32:39 377043 [Warning] Access denied for user 'milnes'@'localhost' (using password: YES) Feb 21 13:32:48 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 13:32:48 377071 [Warning] Access denied for user 'milnes'@'localhost' (using password: YES) Feb 21 13:45:36 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 13:45:36 380665 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 380665, query: select record from redcap_record_list Feb 21 13:45:36 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 14:29:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 14:29:53 393574 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 393574, query: select distinct event_id, field_name, value, instance, record Feb 21 14:29:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: from redcap_data where project_id = 8486 and field_name in ('record_id', 'name', 'appt', 'clinic', 'phone_mobile', 'phone_home', 'email', 'participant_id', 'status_notes', 'age', 'eligibility_notes') Feb 21 14:29:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: and (value like '%a%') and event_id = 38098 Feb 21 14:29:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: order by abs(value), value Feb 21 16:15:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 16:15:53 417674 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 417674, query: select record from redcap_record_list Feb 21 16:15:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 16:31:34 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 16:31:34 420189 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 420189, query: select record from redcap_record_list Feb 21 16:31:34 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 17:03:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 17:03:13 424439 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 424439, query: select distinct event_id, field_name, value, instance, record Feb 21 17:03:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: from redcap_data where project_id = 9945 and field_name in ('record_id', 'initials', 'cc_date', 'el_notes', 'rl_practice', 'headset_num', 'polar_num', 'watch1_num', 'watch2_num', 'app_version', 'rl_start', 'ema_ra_assigned', 'fmri_date', 'ema_proj_end', 'ema_act_end', 'ema_flagged_notes', 'data_excl_who', 'termin_check_ra', 'date_of_the_interview', 'mini_a_pastep', 'mini_a_currep', 'mini_a4_time', 'mini_a6', 'mini_a_currep_score', 'mini_a_pastep_score', 'mini_b17a', 'mini_b17b', 'mini_b17c', 'mini_b18a', 'mini_b_suicidality_score', 'mini_c0a', 'mini_c_currep', 'mini_c_pastep', 'mini_c3_sum_c', 'mini_c3_time', 'mini_c3_sum_p', 'mini_c8', 'mini_d5', 'mini_g4', 'mini_i1a', 'mini_j1b', 'mini_j1', 'mini_j1_often', 'mini_j1_drug', 'mini_j1_class', 'mini_l1a_feet', 'mini_l1a_inches', 'mini_l1b', 'mini_l_thresholdw', 'mini_m4a', 'mini_m4b', 'mini_mb8a', 'mini_mb8b' Feb 21 17:22:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 17:22:20 426482 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 426482, query: select record from redcap_record_list Feb 21 17:22:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 21 17:33:23 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-21 17:33:23 427652 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 427652, query: select * from redcap_data_access_groups where project_id = 10532 order by trim(group_name) Feb 22 06:29:04 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-22 6:29:04 447183 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 447183, query: select record from redcap_record_list Feb 22 06:29:04 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 06:32:22 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-22 6:32:22 447395 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 447395, query: select record from redcap_record_list Feb 22 06:32:22 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 06:32:54 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-22 6:32:54 447434 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 447434, query: select record from redcap_record_list Feb 22 06:32:54 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 06:38:54 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-22 6:38:54 447776 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 447776, query: select record from redcap_record_list Feb 22 06:38:54 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 09:31:29 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 2022-02-22 9:31:29 468494 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 468494, query: select record from redcap_record_list Feb 22 09:31:29 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: 220222 9:53:13 [ERROR] mysqld got signal 11 ; Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: This could be because you hit a bug. It is also possible that this binary Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: or one of the libraries it was linked against is corrupt, improperly built, Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: or misconfigured. This error can also be caused by malfunctioning hardware. Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: We will try our best to scrape up some info that will hopefully help Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: diagnose the problem, but since we have already crashed, Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: something is definitely wrong and this may fail. Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: Server version: 10.5.13-MariaDB Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: key_buffer_size=134217728 Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: read_buffer_size=131072 Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: max_used_connections=173 Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: max_threads=302 Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: thread_count=14 Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: It is possible that mysqld could use up to Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 795892 K bytes of memory Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: Hope that's ok; if not, decrease some variables in the equation. Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: Thread pointer: 0x7fbafc0008d8 Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: Attempting backtrace. You can use the following information to find out Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: where mysqld died. If you see no messages after this, something went Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: terribly wrong... Feb 22 09:53:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: stack_bottom = 0x7fbb4d7f9c90 thread_stack 0x49000 Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(my_print_stacktrace)[0x55d161720d6e] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(handle_fatal_signal)[0x55d161123367] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: sigaction.c:0(__restore_rt)[0x7fbe193aa630] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(st_join_table::save_explain_data(Explain_table_access*, unsigned long long, bool, st_join_table*))[0x55d160f64c4f] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x55d160f6678b] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(JOIN::save_explain_data(Explain_query*, bool, bool, bool, bool))[0x55d160f668f0] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(JOIN::build_explain())[0x55d160f66b4c] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(JOIN::optimize())[0x55d160f7c0b1] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(mysql_select(THD*, TABLE_LIST*, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55d160f7c1c7] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55d160f7ce34] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: /usr/sbin/mariadbd(+0x63b749)[0x55d160ddb749] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(mysql_execute_command(THD*))[0x55d160f2087d] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d160f22d15] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d160f255e5] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(do_command(THD*))[0x55d160f26d7f] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(do_handle_one_connection(CONNECT*, bool))[0x55d161013662] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(handle_one_connection)[0x55d161013934] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x55d16137291d] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: pthread_create.c:0(start_thread)[0x7fbe193a2ea5] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: ??:0(__clone)[0x7fbe188bdb0d] Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: Trying to get some variables. Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: Some pointers may be invalid and cause the dump to abort. Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: Query (0x7fbafc010510): select distinct event_id, field_name, value, instance, record Feb 22 09:53:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[26602]: from redcap_data where project_id = 7827 and field_name in ('record_id', 'notes', 'email', 'date_consent', 'consent_person', 'recruit_md', 'date_start', 'date_45d', 'date_end', 'vis_id', 'fitbit_id', 'date_fitbit_mailed', 'fitbit_mail_track', 'date_fitbit_delivered', 'date_fitbit_data_start', 'return_fitbit_date', 'payment_comments', 'payment_date', 'vincent_number', 'date_payment_card_confirmed', 'date_payment_card_loaded', 'payment_amount', 'payment_partial_explain', 'return_phone_date', 'android_version', 'iphone_version', 'aware_android_version', 'aware_iphone_version', 'uuid', 'smartphone_storage_total', 'smartphone_storage_free', 'fitbit_email', 'fitbit_password', 'fitbit_firmware', 'fitbit_android_version', 'fitbit_iphone_version', 'uuid_end_date', 'uuid2', 'uuid2_start_date', 'fitbit2_email', 'flag_date', 'aware_lastsync', 'fitbit_lastsync', 'daily_lastsync', 'weekly_lastsync', 'flag_notes', 'flag_troubleshoot', 'com_notes', 'data_notes', 'opioid1_other_spec_45d', 'notes_45d', 'notes_90d', 'name', 'phone_number', 'number_type_other', 'phone_number_2', 'number_type_other_2', 'contact_when', 'address_street', 'address_city', 'address_state', 'address_zip', 'demo_datetime', 'dob', 'age', 'height_ft', 'height_inch', 'height', 'weight', 'bmi', 'race_other', 'race_multiple', 'living_other', 'employment_other', 'smoker_years', 'smoker_cigarettesdaily', 'wifi_note', 'own_comp_note', 'own_tablet_note', 'own_smartphone_model', 'own_smartphone_note', 'access_internet_note', 'social_media_note', 'own_tracker_note', 'notes_bl', 'cancer_type', 'cancer_dx_date', 'cancer_stage', 'comorbid_dx', 'chemo_start', 'emr_height_in', 'emr_weight_lb', 'date_death', 'chemo1_date', 'chemo1_cycle', 'chemo1_day', 'chemo1_med', 'chemo1_notes', 'chemo2_date', 'chemo2_cycle', 'chemo2_day', 'chemo2_med', 'chemo2_notes', 'chemo3_date', 'chemo3_cycle', 'chemo3_day', 'chemo3_med', 'chemo3_notes', 'chemo4_date', 'chemo4_cycle', 'chemo4_day', 'chemo4_med', 'chemo4_notes', 'chemo5_date', 'chemo5_cycle', 'chemo5_day', 'chemo5_med', 'chemo5_notes', 'chemo6_date', 'chemo6_cycle', 'chemo6_day', 'chemo6_med', 'chemo6_notes', 'chemo7_date', 'chemo7_cycle', 'chemo7_day', 'chemo7_med', 'chemo7_notes', 'chemo8_date', 'chemo8_cycle', 'chemo8_day', 'chemo8_med', 'chemo8_notes', 'chemo9_date', 'chemo9_cycle', 'chemo9_day', 'chemo9_med', 'chemo9_notes', 'chemo10_date', 'chemo10_cycle', 'chemo10_day', 'chemo10_med', 'chemo10_notes', 'chemo11_date', 'chemo11_cycle', 'chemo11_day', 'chemo11_med', 'chemo11_notes', 'chemo12_date', 'chemo12_cycle', 'chemo12_day', 'chemo12_med', 'chemo12_notes', 'chemo13_date', 'chemo13_cycle', 'chemo13_day', 'chemo13_med', 'chemo13_notes', 'chemo14_date', 'chemo14_cycle', 'chemo14_day', 'chemo14_med', 'chemo14_notes', 'chemo15_date', 'chemo15_cycle', 'chemo15_day', 'chemo15_med', 'chemo15_notes', 'chemo16_date', 'chemo16_cycle', 'chemo16_day', 'chemo16_med', 'chemo16_notes', 'chemo17_date', 'chemo17_cycle', 'chemo17_day', 'chemo17_med', 'chemo17_notes', 'chemo18_date', 'chemo18_cycle', 'chemo18_day', 'chemo18_med', 'chemo18_notes', 'chemo19_date', 'chemo19_cycle', 'chemo19_day', 'chemo19_med', 'chemo19_notes', 'chemo20_date', 'chemo20_cycle', 'chemo20_day', 'chemo20_med', 'chemo20_notes', 'chemo21_date', 'chemo21_cycle', 'chemo21_day', 'chemo21_med', 'chemo21_notes', 'chemo22_date', 'chemo22_cycle', 'chemo22_day', 'chemo22_med', 'chemo22_notes', 'chemo23_date', 'chemo23_cycle', 'chemo23_day', 'chemo23_med', 'chemo23_notes', 'chemo24_date', 'chemo24_cycle', 'chemo24_day', 'chemo24_med', 'chemo24_notes', 'chemo25_date', 'chemo25_cycle', 'chemo25_day', 'chemo25_med', 'chemo25_notes', 'chemo26_date', 'chemo26_cycle', 'chemo26_day', 'chemo26_med', 'chemo26_notes', 'chemo27_date', 'chemo27_cycle', 'chemo27_day', 'chemo27_med', 'chemo27_notes', 'chemo28_date', 'chemo28_cycle', 'chemo28_day', 'chemo28_med', 'chemo28_notes', 'chemo29_date', 'chemo29_cycle', 'chemo29_day', 'chemo29_med', 'chemo29_notes', 'chemo30_date', 'chemo30_cycle', 'chemo30_day', 'chemo30_med', 'chemo30_notes', 'chemo31_date', 'chemo31_cycle', 'chemo31_day', 'chemo31_med', 'chemo31_notes', 'chemo32_date', 'chemo32_cycle', 'chemo32_day', 'chemo32_med', 'chemo32_notes', 'chemo33_date', 'chemo33_cycle', 'chemo33_day', 'chemo33_med', 'chemo33_notes', 'chemo34_date', 'chemo34_cycle', 'chemo34_day', 'chemo34_med', 'chemo34_notes', 'chemo35_date', 'chemo35_cycle', 'chemo35_day', 'chemo35_med', 'chemo35_notes', 'chemo36_date', 'chemo36_cycle', 'chemo36_day', 'chemo36_med', 'chemo36_notes', 'chemo37_date', 'chemo37_cycle', 'chemo37_day', 'chemo37_med', 'chemo37_notes', 'chemo38_date', 'chemo38_cycle', 'chemo38_day', 'chemo38_med', 'chemo38_notes', 'chemo39_date', 'chemo39_cycle', 'chemo39_day', 'chemo39_med', 'chemo39_notes', 'chemo40_date', 'chemo40_cycle', 'chemo40_day', 'chemo40_med', 'chemo40_notes', 'chemo41_date', 'chemo41_cycle', 'chemo41_day', 'chemo41_med', 'chemo41_notes', 'chemo42_date', 'chemo42_cycle', 'chemo42_day', 'chemo42_med', 'chemo42_notes', 'chemo43_date', 'chemo43_cycle', 'chemo43_day', 'chemo43_med', 'chemo43_notes', 'chemo44_date', 'chemo44_cycle', 'chemo44_day', 'chemo44_med', 'chemo44_notes', 'chemo45_date', 'chemo45_cycle', 'chemo45_day', 'chemo45_med', 'chemo45_notes', 'hosp1_admit_date', 'hosp1_discharge_date', 'hosp1_reason', 'hosp1_notes', 'hosp2_admit_date', 'hosp2_discharge_date', 'hosp2_reason', 'hosp2_notes', 'hosp3_admit_date', 'hosp3_discharge_date', 'hosp3_reason', 'hosp3_notes', 'surgery', 'ed') Feb 22 09:53:15 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: mariadb.service: main process exited, code=killed, status=11/SEGV Feb 22 09:53:16 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Unit mariadb.service entered failed state. Feb 22 09:53:16 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: mariadb.service failed. Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: mariadb.service holdoff time over, scheduling restart. Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Stopped MariaDB 10.5.13 database server. Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Starting MariaDB 10.5.13 database server... Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:21 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.13-MariaDB) starting as process 7738 ... Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:21 0 [Note] InnoDB: Uses event mutexes Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:21 0 [Note] InnoDB: Number of pools: 1 Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:21 0 [Note] InnoDB: Using Linux native AIO Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:21 0 [Note] InnoDB: Initializing buffer pool, total size = 10737418240, chunk size = 134217728 Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:21 0 [Note] InnoDB: Completed initialization of buffer pool Feb 22 09:53:21 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=702043061602,702043061602 Feb 22 09:53:24 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:24 0 [Note] InnoDB: Starting final batch to recover 20193 pages from redo log. Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] InnoDB: 128 rollback segments are active. Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] InnoDB: 10.5.13 started; log sequence number 702344014273; transaction id 613856570 Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] Plugin 'FEEDBACK' is disabled. Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Warning] Failed to create a socket for IPv6 '::': errno: 97. Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] Server socket created on IP: '0.0.0.0'. Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] Reading of all Master_info entries succeeded Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] Added new Master_info '' to hash table Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:53:28 0 [Note] /usr/sbin/mariadbd: ready for connections. Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Version: '10.5.13-MariaDB' socket: '/data/mysql/mysql.sock' port: 3306 MariaDB Server Feb 22 09:53:28 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Started MariaDB 10.5.13 database server. Feb 22 09:55:10 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 9:55:10 0 [Note] InnoDB: Buffer pool(s) load completed at 220222 9:55:10 Feb 22 10:12:10 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 10:12:10 4379 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 4379, query: select record from redcap_record_list Feb 22 10:12:10 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 10:33:08 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 10:33:08 9652 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 9652, query: select record from redcap_record_list Feb 22 10:33:08 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 10:33:54 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 2022-02-22 10:33:54 9846 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 9846, query: select record from redcap_record_list Feb 22 10:33:54 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: 220222 10:43:58 [ERROR] mysqld got signal 11 ; Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: This could be because you hit a bug. It is also possible that this binary Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: or one of the libraries it was linked against is corrupt, improperly built, Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: or misconfigured. This error can also be caused by malfunctioning hardware. Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: We will try our best to scrape up some info that will hopefully help Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: diagnose the problem, but since we have already crashed, Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: something is definitely wrong and this may fail. Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Server version: 10.5.13-MariaDB Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: key_buffer_size=134217728 Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: read_buffer_size=131072 Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: max_used_connections=14 Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: max_threads=302 Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: thread_count=14 Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: It is possible that mysqld could use up to Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 795892 K bytes of memory Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Hope that's ok; if not, decrease some variables in the equation. Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Thread pointer: 0x7f5b040009b8 Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Attempting backtrace. You can use the following information to find out Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: where mysqld died. If you see no messages after this, something went Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: terribly wrong... Feb 22 10:43:58 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: stack_bottom = 0x7f5de4084c90 thread_stack 0x49000 Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(my_print_stacktrace)[0x563c8c8b1d6e] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(handle_fatal_signal)[0x563c8c2b4367] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: sigaction.c:0(__restore_rt)[0x7f5e033ad630] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(st_join_table::save_explain_data(Explain_table_access*, unsigned long long, bool, st_join_table*))[0x563c8c0f5c4f] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(JOIN::save_explain_data_intern(Explain_query*, bool, bool, bool, char const*))[0x563c8c0f778b] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(JOIN::save_explain_data(Explain_query*, bool, bool, bool, bool))[0x563c8c0f78f0] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(JOIN::build_explain())[0x563c8c0f7b4c] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(JOIN::optimize())[0x563c8c10d0b1] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(mysql_select(THD*, TABLE_LIST*, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x563c8c10d1c7] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(handle_select(THD*, LEX*, select_result*, unsigned long))[0x563c8c10de34] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: /usr/sbin/mariadbd(+0x63b749)[0x563c8bf6c749] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(mysql_execute_command(THD*))[0x563c8c0b187d] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x563c8c0b3d15] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x563c8c0b65e5] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(do_command(THD*))[0x563c8c0b7d7f] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(do_handle_one_connection(CONNECT*, bool))[0x563c8c1a4662] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(handle_one_connection)[0x563c8c1a4934] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(MyCTX_nopad::finish(unsigned char*, unsigned int*))[0x563c8c50391d] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: pthread_create.c:0(start_thread)[0x7f5e033a5ea5] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: ??:0(__clone)[0x7f5e028c0b0d] Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Trying to get some variables. Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Some pointers may be invalid and cause the dump to abort. Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Query (0x7f5b040305d0): select distinct event_id, field_name, value, instance, record Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: from redcap_data where project_id = 7827 and field_name in ('record_id', 'notes', 'email', 'date_consent', 'consent_person', 'recruit_md', 'date_start', 'date_45d', 'date_end', 'vis_id', 'fitbit_id', 'date_fitbit_mailed', 'fitbit_mail_track', 'date_fitbit_delivered', 'date_fitbit_data_start', 'return_fitbit_date', 'payment_comments', 'payment_date', 'vincent_number', 'date_payment_card_confirmed', 'date_payment_card_loaded', 'payment_amount', 'payment_partial_explain', 'return_phone_date', 'android_version', 'iphone_version', 'aware_android_version', 'aware_iphone_version', 'uuid', 'smartphone_storage_total', 'smartphone_storage_free', 'fitbit_email', 'fitbit_password', 'fitbit_firmware', 'fitbit_android_version', 'fitbit_iphone_version', 'uuid_end_date', 'uuid2', 'uuid2_start_date', 'fitbit2_email', 'flag_date', 'aware_lastsync', 'fitbit_lastsync', 'daily_lastsync', 'weekly_lastsync', 'flag_notes', 'flag_troubleshoot', 'com_notes', 'data_notes', 'opioid1_other_spec_45d', 'notes_45d', 'notes_90d', 'name', 'phone_number', 'number_type_other', 'phone_number_2', 'number_type_other_2', 'contact_when', 'address_street', 'address_city', 'address_state', 'address_zip', 'demo_datetime', 'dob', 'age', 'height_ft', 'height_inch', 'height', 'weight', 'bmi', 'race_other', 'race_multiple', 'living_other', 'employment_other', 'smoker_years', 'smoker_cigarettesdaily', 'wifi_note', 'own_comp_note', 'own_tablet_note', 'own_smartphone_model', 'own_smartphone_note', 'access_internet_note', 'social_media_note', 'own_tracker_note', 'notes_bl', 'cancer_type', 'cancer_dx_date', 'cancer_stage', 'comorbid_dx', 'chemo_start', 'emr_height_in', 'emr_weight_lb', 'date_death', 'chemo1_date', 'chemo1_cycle', 'chemo1_day', 'chemo1_med', 'chemo1_notes', 'chemo2_date', 'chemo2_cycle', 'chemo2_day', 'chemo2_med', 'chemo2_notes', 'chemo3_date', 'chemo3_cycle', 'chemo3_day', 'chemo3_med', 'chemo3_notes', 'chemo4_date', 'chemo4_cycle', 'chemo4_day', 'chemo4_med', 'chemo4_notes', 'chemo5_date', 'chemo5_cycle', 'chemo5_day', 'chemo5_med', 'chemo5_notes', 'chemo6_date', 'chemo6_cycle', 'chemo6_day', 'chemo6_med', 'chemo6_notes', 'chemo7_date', 'chemo7_cycle', 'chemo7_day', 'chemo7_med', 'chemo7_notes', 'chemo8_date', 'chemo8_cycle', 'chemo8_day', 'chemo8_med', 'chemo8_notes', 'chemo9_date', 'chemo9_cycle', 'chemo9_day', 'chemo9_med', 'chemo9_notes', 'chemo10_date', 'chemo10_cycle', 'chemo10_day', 'chemo10_med', 'chemo10_notes', 'chemo11_date', 'chemo11_cycle', 'chemo11_day', 'chemo11_med', 'chemo11_notes', 'chemo12_date', 'chemo12_cycle', 'chemo12_day', 'chemo12_med', 'chemo12_notes', 'chemo13_date', 'chemo13_cycle', 'chemo13_day', 'chemo13_med', 'chemo13_notes', 'chemo14_date', 'chemo14_cycle', 'chemo14_day', 'chemo14_med', 'chemo14_notes', 'chemo15_date', 'chemo15_cycle', 'chemo15_day', 'chemo15_med', 'chemo15_notes', 'chemo16_date', 'chemo16_cycle', 'chemo16_day', 'chemo16_med', 'chemo16_notes', 'chemo17_date', 'chemo17_cycle', 'chemo17_day', 'chemo17_med', 'chemo17_notes', 'chemo18_date', 'chemo18_cycle', 'chemo18_day', 'chemo18_med', 'chemo18_notes', 'chemo19_date', 'chemo19_cycle', 'chemo19_day', 'chemo19_med', 'chemo19_notes', 'chemo20_date', 'chemo20_cycle', 'chemo20_day', 'chemo20_med', 'chemo20_notes', 'chemo21_date', 'chemo21_cycle', 'chemo21_day', 'chemo21_med', 'chemo21_notes', 'chemo22_date', 'chemo22_cycle', 'chemo22_day', 'chemo22_med', 'chemo22_notes', 'chemo23_date', 'chemo23_cycle', 'chemo23_day', 'chemo23_med', 'chemo23_notes', 'chemo24_date', 'chemo24_cycle', 'chemo24_day', 'chemo24_med', 'chemo24_notes', 'chemo25_date', 'chemo25_cycle', 'chemo25_day', 'chemo25_med', 'chemo25_notes', 'chemo26_date', 'chemo26_cycle', 'chemo26_day', 'chemo26_med', 'chemo26_notes', 'chemo27_date', 'chemo27_cycle', 'chemo27_day', 'chemo27_med', 'chemo27_notes', 'chemo28_date', 'chemo28_cycle', 'chemo28_day', 'chemo28_med', 'chemo28_notes', 'chemo29_date', 'chemo29_cycle', 'chemo29_day', 'chemo29_med', 'chemo29_notes', 'chemo30_date', 'chemo30_cycle', 'chemo30_day', 'chemo30_med', 'chemo30_notes', 'chemo31_date', 'chemo31_cycle', 'chemo31_day', 'chemo31_med', 'chemo31_notes', 'chemo32_date', 'chemo32_cycle', 'chemo32_day', 'chemo32_med', 'chemo32_notes', 'chemo33_date', 'chemo33_cycle', 'chemo33_day', 'chemo33_med', 'chemo33_notes', 'chemo34_date', 'chemo34_cycle', 'chemo34_day', 'chemo34_med', 'chemo34_notes', 'chemo35_date', 'chemo35_cycle', 'chemo35_day', 'chemo35_med', 'chemo35_notes', 'chemo36_date', 'chemo36_cycle', 'chemo36_day', 'chemo36_med', 'chemo36_notes', 'chemo37_date', 'chemo37_cycle', 'chemo37_day', 'chemo37_med', 'chemo37_notes', 'chemo38_date', 'chemo38_cycle', 'chemo38_day', 'chemo38_med', 'chemo38_notes', 'chemo39_date', 'chemo39_cycle', 'chemo39_day', 'chemo39_med', 'chemo39_notes', 'chemo40_date', 'chemo40_cycle', 'chemo40_day', 'chemo40_med', 'chemo40_notes', 'chemo41_date', 'chemo41_cycle', 'chemo41_day', 'chemo41_med', 'chemo41_notes', 'chemo42_date', 'chemo42_cycle', 'chemo42_day', 'chemo42_med', 'chemo42_notes', 'chemo43_date', 'chemo43_cycle', 'chemo43_day', 'chemo43_med', 'chemo43_notes', 'chemo44_date', 'chemo44_cycle', 'chemo44_day', 'chemo44_med', 'chemo44_notes', 'chemo45_date', 'chemo45_cycle', 'chemo45_day', 'chemo45_med', 'chemo45_notes', 'hosp1_admit_date', 'hosp1_discharge_date', 'hosp1_reason', 'hosp1_notes', 'hosp2_admit_date', 'hosp2_discharge_date', 'hosp2_reason', 'hosp2_notes', 'hosp3_admit_date', 'hosp3_discharge_date', 'hosp3_reason', 'hosp3_notes', 'surgery', 'ed') Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: and (value like '%1%') and event_id = 36032 Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: order by abs(value), value Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Connection ID (thread ID): 12519 Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Status: KILL_CONNECTION Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains Feb 22 10:43:59 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[7738]: information that should help you find out what is causing the crash. Feb 22 10:44:00 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: mariadb.service: main process exited, code=killed, status=11/SEGV Feb 22 10:44:01 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Unit mariadb.service entered failed state. Feb 22 10:44:01 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: mariadb.service failed. Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: mariadb.service holdoff time over, scheduling restart. Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Stopped MariaDB 10.5.13 database server. Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Starting MariaDB 10.5.13 database server... Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:06 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.13-MariaDB) starting as process 10901 ... Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:06 0 [Note] InnoDB: Uses event mutexes Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:06 0 [Note] InnoDB: Number of pools: 1 Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:06 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:06 0 [Note] InnoDB: Using Linux native AIO Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:06 0 [Note] InnoDB: Initializing buffer pool, total size = 10737418240, chunk size = 134217728 Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:06 0 [Note] InnoDB: Completed initialization of buffer pool Feb 22 10:44:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=702043061602,702043061602 Feb 22 10:44:11 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:11 0 [Note] InnoDB: Starting final batch to recover 31089 pages from redo log. Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] InnoDB: 128 rollback segments are active. Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] InnoDB: 10.5.13 started; log sequence number 702515907596; transaction id 614111446 Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] Plugin 'FEEDBACK' is disabled. Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Warning] Failed to create a socket for IPv6 '::': errno: 97. Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] Server socket created on IP: '0.0.0.0'. Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] Reading of all Master_info entries succeeded Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] Added new Master_info '' to hash table Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:44:17 0 [Note] /usr/sbin/mariadbd: ready for connections. Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: Version: '10.5.13-MariaDB' socket: '/data/mysql/mysql.sock' port: 3306 MariaDB Server Feb 22 10:44:17 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Started MariaDB 10.5.13 database server. Feb 22 10:46:10 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 10:46:10 0 [Note] InnoDB: Buffer pool(s) load completed at 220222 10:46:10 Feb 22 12:16:11 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 12:16:11 26539 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 26539, query: select record from redcap_record_list Feb 22 12:16:11 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 12:58:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 12:58:06 39377 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 39377, query: select record from redcap_record_list Feb 22 12:58:06 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:27:49 48377 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 25; hex 73757a79686f6d656d616b6572626240676d61696c2e636f6d; asc suzyhomemakerbb@gmail.com;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 8026989f; asc & ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 8026989e; asc & ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 80004ff9; asc O ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000981d; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 395a423566644d4a5172; asc 9ZB5fdMJQr;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48377, OS thread handle 140161039963904, query id 2170354 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:27:49 48377 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 23; hex 73656a6f686e736f6e3037313340676d61696c2e636f6d; asc sejohnson0713@gmail.com;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 803a9885; asc : ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 803a9884; asc : ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000d4f9; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000c5ec; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 656d6678414347753868; asc emfxACGu8h;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48377, OS thread handle 140161039963904, query id 2170354 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:27:49 48377 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 18; hex 7269636864696c6c6579406d736e2e636f6d; asc richdilley@msn.com;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 803c7fb2; asc < ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 803c7fb1; asc < ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000d62d; asc -;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000c61d; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 6f506d53326535375036; asc oPmS2e57P6;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48377, OS thread handle 140161039963904, query id 2170354 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:27:49 48377 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 13; hex 6d706c3130407073752e656475; asc mpl10@psu.edu;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 80365a91; asc 6Z ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 80365a90; asc 6Z ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 800020f2; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000602b; asc `+;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 62547441484c6a473266; asc bTtAHLjG2f;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48377, OS thread handle 140161039963904, query id 2170354 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:27:49 48377 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 17; hex 4346495270726f6a40706974742e656475; asc CFIRproj@pitt.edu;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 8040b0a8; asc @ ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 8040b0a7; asc @ ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000c7a9; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000c64a; asc J;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 44764a6d706266567648; asc DvJmpbfVvH;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48377, OS thread handle 140161039963904, query id 2170354 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:27:49 48377 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 20; hex 63646b683134323940636f6d636173742e6e6574; asc cdkh1429@comcast.net;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 8041e754; asc A T;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 8041e753; asc A S;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000d8dd; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000c893; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 383366444d6a56377859; asc 83fDMjV7xY;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48377, OS thread handle 140161039963904, query id 2170354 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:27:49 48377 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 15; hex 4252554e4f39404a554e4f2e434f4d; asc BRUNO9@JUNO.COM;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 803ccd01; asc < ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 803ccd00; asc < ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000cb64; asc d;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000bd3f; asc ?;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 59696e4937456a555252; asc YinI7EjURR;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48377, OS thread handle 140161039963904, query id 2170354 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:27:49 48377 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 25; hex 627269616e2e6b656c6c657932343040676d61696c2e636f6d; asc brian.kelley240@gmail.com;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 8038fe14; asc 8 ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 8038fe13; asc 8 ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 800060cd; asc ` ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000a1c9; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 55775158336e43526b6f; asc UwQX3nCRko;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48377, OS thread handle 140161039963904, query id 2170354 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:27:49 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:28:20 48515 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 25; hex 73757a79686f6d656d616b6572626240676d61696c2e636f6d; asc suzyhomemakerbb@gmail.com;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 8026989f; asc & ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 8026989e; asc & ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 80004ff9; asc O ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000981d; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 395a423566644d4a5172; asc 9ZB5fdMJQr;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48515, OS thread handle 140161039349504, query id 2175439 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:28:20 48515 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 23; hex 73656a6f686e736f6e3037313340676d61696c2e636f6d; asc sejohnson0713@gmail.com;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 803a9885; asc : ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 803a9884; asc : ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000d4f9; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000c5ec; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 656d6678414347753868; asc emfxACGu8h;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48515, OS thread handle 140161039349504, query id 2175439 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:28:20 48515 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 18; hex 7269636864696c6c6579406d736e2e636f6d; asc richdilley@msn.com;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 803c7fb2; asc < ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 803c7fb1; asc < ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000d62d; asc -;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000c61d; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 6f506d53326535375036; asc oPmS2e57P6;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48515, OS thread handle 140161039349504, query id 2175439 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:28:20 48515 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 13; hex 6d706c3130407073752e656475; asc mpl10@psu.edu;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 80365a91; asc 6Z ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 80365a90; asc 6Z ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 800020f2; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000602b; asc `+;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 62547441484c6a473266; asc bTtAHLjG2f;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48515, OS thread handle 140161039349504, query id 2175439 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:28:20 48515 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 17; hex 4346495270726f6a40706974742e656475; asc CFIRproj@pitt.edu;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 8040b0a8; asc @ ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 8040b0a7; asc @ ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000c7a9; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000c64a; asc J;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 44764a6d706266567648; asc DvJmpbfVvH;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48515, OS thread handle 140161039349504, query id 2175439 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:28:20 48515 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 20; hex 63646b683134323940636f6d636173742e6e6574; asc cdkh1429@comcast.net;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 8041e754; asc A T;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 8041e753; asc A S;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000d8dd; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000c893; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 383366444d6a56377859; asc 83fDMjV7xY;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48515, OS thread handle 140161039349504, query id 2175439 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:28:20 48515 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 15; hex 4252554e4f39404a554e4f2e434f4d; asc BRUNO9@JUNO.COM;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 803ccd01; asc < ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 803ccd00; asc < ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 8000cb64; asc d;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000bd3f; asc ?;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 59696e4937456a555252; asc YinI7EjURR;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48515, OS thread handle 140161039349504, query id 2175439 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 13:28:20 48515 [ERROR] InnoDB: Clustered record for sec rec not found index `participant_email_phone` of table `ctsiredcap`.`redcap_surveys_participants` Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 25; hex 627269616e2e6b656c6c657932343040676d61696c2e636f6d; asc brian.kelley240@gmail.com;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 4; hex 8038fe14; asc 8 ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: clust index record PHYSICAL RECORD: n_fields 15; compact format; info bits 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0: len 4; hex 8038fe13; asc 8 ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 1: len 6; hex 000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2: len 7; hex 80000000000000; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 3: len 4; hex 800060cd; asc ` ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 4: len 4; hex 8000a1c9; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 5: len 10; hex 55775158336e43526b6f; asc UwQX3nCRko;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 6: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 7: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 8: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 9: len 0; hex ; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 10: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 11: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 12: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 13: SQL NULL; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 14: len 1; hex 80; asc ;; Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: TRANSACTION 421647627690192, ACTIVE 0 sec fetching rows Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: mysql tables in use 2, locked 0 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 0 lock struct(s), heap size 1128, 0 row lock(s) Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: MySQL thread id 48515, OS thread handle 140161039349504, query id 2175439 redcap-web02.dbmi.pitt.edu 136.142.228.62 RedcapWeb Sending data Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: select p.participant_id, r.response_id, r.first_submit_time, r.completion_time, Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: r.return_code, p.participant_identifier, p.participant_email Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: from redcap_surveys_participants p, redcap_surveys_response r where p.survey_id = 7633 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and p.event_id = 26058 and p.participant_id = r.participant_id Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.record = '10' and r.first_submit_time is not null Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: and r.instance = '1' order by p.participant_email desc limit 1 Feb 22 13:28:20 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ Feb 22 14:29:19 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Stopping MariaDB 10.5.13 database server... Feb 22 14:29:19 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:19 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown Feb 22 14:29:19 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:19 0 [Note] Event Scheduler: Purging the queue. 0 events Feb 22 14:29:19 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:19 0 [Note] InnoDB: FTS optimize thread exiting. Feb 22 14:29:19 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:19 0 [Note] InnoDB: Starting shutdown... Feb 22 14:29:19 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:19 0 [Note] InnoDB: Dumping buffer pool(s) to /data/mysql/ib_buffer_pool Feb 22 14:29:19 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:19 0 [Note] InnoDB: Restricted to 161300 pages due to innodb_buf_pool_dump_pct=25 Feb 22 14:29:19 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:19 0 [Note] InnoDB: Buffer pool(s) dump completed at 220222 14:29:19 Feb 22 14:29:22 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" Feb 22 14:29:22 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:22 0 [Note] InnoDB: Shutdown completed; log sequence number 703180459099; transaction id 614975443 Feb 22 14:29:22 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[10901]: 2022-02-22 14:29:22 0 [Note] /usr/sbin/mariadbd: Shutdown complete Feb 22 14:29:23 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Stopped MariaDB 10.5.13 database server. Feb 22 14:30:12 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Starting MariaDB 10.5.13 database server... Feb 22 14:30:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:12 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.13-MariaDB) starting as process 24645 ... Feb 22 14:30:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:12 0 [Note] InnoDB: Uses event mutexes Feb 22 14:30:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 Feb 22 14:30:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:12 0 [Note] InnoDB: Number of pools: 1 Feb 22 14:30:12 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:12 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] InnoDB: Using Linux native AIO Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] InnoDB: Initializing buffer pool, total size = 10737418240, chunk size = 134217728 Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] InnoDB: Completed initialization of buffer pool Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] InnoDB: 128 rollback segments are active. Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] InnoDB: 10.5.13 started; log sequence number 703180459099; transaction id 614975444 Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] Plugin 'FEEDBACK' is disabled. Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Warning] Failed to create a socket for IPv6 '::': errno: 97. Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] Server socket created on IP: '0.0.0.0'. Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] Reading of all Master_info entries succeeded Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] Added new Master_info '' to hash table Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:30:13 0 [Note] /usr/sbin/mariadbd: ready for connections. Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: Version: '10.5.13-MariaDB' socket: '/data/mysql/mysql.sock' port: 3306 MariaDB Server Feb 22 14:30:13 redcap-dbserver-prod-02.dbmi.pitt.edu systemd[1]: Started MariaDB 10.5.13 database server. Feb 22 14:31:36 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:31:36 0 [Note] InnoDB: Buffer pool(s) load completed at 220222 14:31:36 Feb 22 14:42:07 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:42:07 3894 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 3894, query: select record from redcap_record_list Feb 22 14:42:07 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 14:48:31 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 14:48:31 5778 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 5778, query: select record from redcap_record_list Feb 22 14:48:31 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 22 15:54:41 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 15:54:41 24078 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 24078, query: select distinct event_id, field_name, value, instance, record Feb 22 15:54:41 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: from redcap_data where project_id = 10532 and field_name = 'id' Feb 22 15:54:41 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: and record in ('2555-1', '2555-2', '2555-3', '2555-4', '2555-5', '2555-6', '2555-7', '2555-8', '2555-9', '2555-10', '2555-11', '2555-12', '2555-13', '2555-14', '2555-15', '2555-16', '2555-17', '2555-18', '2555-19', '2555-20', '2555-21', '2555-22', '2555-23', '2555-24', '2555-25', '2555-26', '2555-27', '2555-28', '2555-29', '2555-30', '2555-31', '2555-32', '2555-33', '2555-34', '2555-35', '2555-36', '2555-37', '2555-38', '2555-39', '2555-40', '2555-41', '2555-42', '2555-43', '2555-44', '2555-45', '2555-46', '2555-47', '2555-48', '2555-49', '2555-50', '2555-51', '2555-52', '2555-53', '2555-54', '2555-55', '2555-56', '2555-57', '2555-58', '2555-59', '2555-60', '2555-61', '2555-62', '2555-63', '2555-64', '2555-65', '2555-66', '2555-67', '2555-68', '2555-69', '2555-70', '2555-71', '2555-72', '255 Feb 22 16:41:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-22 16:41:14 34788 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 34788, query: select record from redcap_record_list Feb 22 16:41:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: where project_id = 10532 and dag_id in ('2533') and record in ('2533-2', '2533-4', '2533-5', '2533-7', '2533-12', '2533-16', '2533-17', '2533-21', '2533-24', '2533-25', '2533-28', '2533-32', '2533-34', '2533-36', '2533-38', '2533-39', '2533-44', '2533-45', '2533-49', '2533-52', '2533-58', '2533-63', '2533-64', '2533-70', '2533-77', '2533-78', '2533-81', '2533-83', '2533-85', '2533-87', '2533-88', '2533-90', '2533-95', '2533-99', '2533-101', '2533-104', '2533-105', '2533-106', '2533-109', '2533-111', '2533-114', '2533-116', '2533-117', '2533-118', '2533-125', '2533-126', '2533-128', '2533-129', '2533-131', '2533-136', '2533-138', '2533-141', '2533-143', '2533-146', '2533-152', '2533-173', '2533-184', '2533-186', '2533-187', '2533-188', '2533-189', '2533-190', '2533-191', '2533-193', '2533-194', '2533-196', '2533-201', '2533-203', '2533-207', '2533-209', '2533-213', '2533-214', Feb 23 07:41:10 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 7:41:10 2882 [Warning] Aborted connection 2882 to db: 'ctsiredcap' user: 'aja56' host: 'aja56-dt.dbmi.pitt.edu' (Got timeout reading communication packets) Feb 23 07:41:10 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 7:41:10 2883 [Warning] Aborted connection 2883 to db: 'ctsiredcap' user: 'aja56' host: 'aja56-dt.dbmi.pitt.edu' (Got timeout reading communication packets) Feb 23 08:27:22 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 8:27:22 70849 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 70849, query: select record from redcap_record_list Feb 23 08:27:22 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: where project_id = 9244 and dag_id in ('2124') order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 23 08:38:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 8:38:14 72101 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 72101, query: select distinct event_id, field_name, value, instance, record Feb 23 08:38:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: from redcap_data where project_id = 10532 and field_name = 'id' Feb 23 08:38:14 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: and record in ('2555-1', '2555-2', '2555-3', '2555-4', '2555-5', '2555-6', '2555-7', '2555-8', '2555-9', '2555-10', '2555-11', '2555-12', '2555-13', '2555-14', '2555-15', '2555-16', '2555-17', '2555-18', '2555-19', '2555-20', '2555-21', '2555-22', '2555-23', '2555-24', '2555-25', '2555-26', '2555-27', '2555-28', '2555-29', '2555-30', '2555-31', '2555-32', '2555-33', '2555-34', '2555-35', '2555-36', '2555-37', '2555-38', '2555-39', '2555-40', '2555-41', '2555-42', '2555-43', '2555-44', '2555-45', '2555-46', '2555-47', '2555-48', '2555-49', '2555-50', '2555-51', '2555-52', '2555-53', '2555-54', '2555-55', '2555-56', '2555-57', '2555-58', '2555-59', '2555-60', '2555-61', '2555-62', '2555-63', '2555-64', '2555-65', '2555-66', '2555-67', '2555-68', '2555-69', '2555-70', '2555-71', '2555-72', '255 Feb 23 09:57:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 9:57:13 88142 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 88142, query: select distinct event_id, field_name, value, instance, record Feb 23 09:57:13 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: from redcap_data where project_id = 6738 and field_name in ('id', 'first_name', 'last_name', 'other_no_hospital', 'date_seen', 'no_pamphlets', 'cprat_not_enrolled', 'cent_missed', 'cpce_notdone', 'moca_b_score', 'moca', 'assessment_notes', 'follow_up_notes', 'primaryname', 'address', 'email', 'phone_number', 'secondaryname', 'secondary_address', 'secondary_email', 'secondary_phone', 'deathdate', 'discharge_mrs', 'discharge_cpc', 'dischargedate', 'date_arrest', 'dateofassessment', 'other_no_assessment', 'other_concerns', 'discharge_worries', 'physical_concerns', 'ep_concerns', 'cognitive_concerns', 'spiritual_concerns', 'social_concerns', 'financial_concerns', 'extra_resources', 'added_notes', 'what_was_done', 'notes_2', 'notes_3', 'notes_4', 'call_date', 'why_missed_other', 'notes', 'attempt_1', 'attempt_1miss_other', 'attempt_2', 'attempt_2miss_other', 'att Feb 23 09:59:11 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 9:59:11 88587 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 88587, query: select distinct event_id, field_name, value, instance, record Feb 23 09:59:11 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: from redcap_data where project_id = 6738 and field_name in ('id', 'first_name', 'last_name', 'other_no_hospital', 'date_seen', 'no_pamphlets', 'cprat_not_enrolled', 'cent_missed', 'cpce_notdone', 'moca_b_score', 'moca', 'assessment_notes', 'follow_up_notes', 'primaryname', 'address', 'email', 'phone_number', 'secondaryname', 'secondary_address', 'secondary_email', 'secondary_phone', 'deathdate', 'discharge_mrs', 'discharge_cpc', 'dischargedate', 'date_arrest', 'dateofassessment', 'other_no_assessment', 'other_concerns', 'discharge_worries', 'physical_concerns', 'ep_concerns', 'cognitive_concerns', 'spiritual_concerns', 'social_concerns', 'financial_concerns', 'extra_resources', 'added_notes', 'what_was_done', 'notes_2', 'notes_3', 'notes_4', 'call_date', 'why_missed_other', 'notes', 'attempt_1', 'attempt_1miss_other', 'attempt_2', 'attempt_2miss_other', 'att Feb 23 10:01:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 10:01:53 89317 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 89317, query: select record from redcap_record_list Feb 23 10:01:53 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 23 10:01:57 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 10:01:57 89340 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 89340, query: select record from redcap_record_list Feb 23 10:01:57 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 23 10:01:57 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 10:01:57 89342 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 89342, query: select record from redcap_record_list Feb 23 10:01:57 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record Feb 23 10:01:57 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: 2022-02-23 10:01:57 89346 [Warning] Sort aborted, host: redcap-web02.dbmi.pitt.edu, user: RedcapWeb, thread: 89346, query: select record from redcap_record_list Feb 23 10:01:57 redcap-dbserver-prod-02.dbmi.pitt.edu mariadbd[24645]: where project_id = 10532 order by record regexp '^[A-Z]', abs(record), replace(replace(record,'_',''),'-','')*1, record