|
Taking Master-bin.000615 the last set of entries in this file are:-
The crash occured at 23:15:10, which I have highlighted below; these are standard statements where transaction perf stats information is written to the Partitioned Table (partitioned in 31 partitions) - RJIS_JQI_PERF ; there is a pre-insert trigger on the table that populates the Partition Number column with the day number of the month of the date.
|
master-bin.000615 last set of entries
|
# at 146198196
|
#190729 23:14:44 server id 1 end_log_pos 146198820 CRC32 0x25bf8941 Query thread_id=84 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438484/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (88,'2019-07-29 23:14:35','2019-07-29 23:14:35','RIBSFBT2','JQI','FNT02290',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146198820
|
#190729 23:14:44 server id 1 end_log_pos 146198851 CRC32 0xd4464fef Xid = 1765468
|
COMMIT/*!*/;
|
# at 146198851
|
#190729 23:14:44 server id 1 end_log_pos 146198893 CRC32 0xba10ad8f GTID 0-1-151127503 trans
|
/*!100001 SET @@session.gtid_seq_no=151127503*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146198893
|
#190729 23:14:44 server id 1 end_log_pos 146199324 CRC32 0x72566df6 Query thread_id=82 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438484/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02290','','2019-07-29 23:14:35','2019-07-29 23:14:35',3251,32,16,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6004)
|
/*!*/;
|
# at 146199324
|
#190729 23:14:44 server id 1 end_log_pos 146199355 CRC32 0xbf4e11e5 Xid = 1765472
|
COMMIT/*!*/;
|
# at 146199355
|
#190729 23:15:09 server id 1 end_log_pos 146199397 CRC32 0x20b24b71 GTID 0-1-151127504 trans
|
/*!100001 SET @@session.gtid_seq_no=151127504*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146199397
|
#190729 23:15:09 server id 1 end_log_pos 146200019 CRC32 0x71515f74 Query thread_id=17 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438509/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:08','2019-07-29 23:15:08','RIBSFBT3','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146200019
|
#190729 23:15:09 server id 1 end_log_pos 146200050 CRC32 0xe9db2971 Xid = 1765516
|
COMMIT/*!*/;
|
# at 146200050
|
#190729 23:15:09 server id 1 end_log_pos 146200092 CRC32 0xc5e7c1a3 GTID 0-1-151127505 trans
|
/*!100001 SET @@session.gtid_seq_no=151127505*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146200092
|
#190729 23:15:09 server id 1 end_log_pos 146200522 CRC32 0xe6683074 Query thread_id=18 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438509/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:08','2019-07-29 23:15:08',3250,16,0,0,0,'RIBSFBT3','B','145.227.178.246',0,null,6003)
|
/*!*/;
|
# at 146200522
|
#190729 23:15:09 server id 1 end_log_pos 146200553 CRC32 0x8b19bfdf Xid = 1765520
|
COMMIT/*!*/;
|
{color:#DE350B}# at 146200553
|
#190729 23:15:10 server id 1 end_log_pos 146200595 CRC32 0xab32469c GTID 0-1-151127506 trans
|
/*!100001 SET @@session.gtid_seq_no=151127506*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146200595
|
#190729 23:15:10 server id 1 end_log_pos 146201217 CRC32 0x96faaf66 Query thread_id=20 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438510/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:08','2019-07-29 23:15:08','RIBSFBT3','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146201217
|
#190729 23:15:10 server id 1 end_log_pos 146201248 CRC32 0xc666b21b Xid = 1765544
|
COMMIT/*!*/;
|
# at 146201248
|
#190729 23:15:10 server id 1 end_log_pos 146201290 CRC32 0x627b8456 GTID 0-1-151127507 trans
|
/*!100001 SET @@session.gtid_seq_no=151127507*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146201290
|
#190729 23:15:10 server id 1 end_log_pos 146201720 CRC32 0x781cba62 Query thread_id=19 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438510/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:08','2019-07-29 23:15:08',3250,15,0,0,0,'RIBSFBT3','B','145.227.178.246',0,null,6004)
|
/*!*/;
|
# at 146201720
|
#190729 23:15:10 server id 1 end_log_pos 146201751 CRC32 0x2cd28d48 Xid = 1765548
|
COMMIT/*!*/;{color}
|
# at 146201751
|
#190729 23:15:11 server id 1 end_log_pos 146201793 CRC32 0x0c16854b GTID 0-1-151127508 trans
|
/*!100001 SET @@session.gtid_seq_no=151127508*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146201793
|
#190729 23:15:11 server id 1 end_log_pos 146202415 CRC32 0x5c3ce7b5 Query thread_id=21 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438511/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:08','2019-07-29 23:15:08','RIBSFBT3','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146202415
|
#190729 23:15:11 server id 1 end_log_pos 146202446 CRC32 0x5ae40b66 Xid = 1765556
|
COMMIT/*!*/;
|
# at 146202446
|
#190729 23:15:11 server id 1 end_log_pos 146202488 CRC32 0x4f79f783 GTID 0-1-151127509 trans
|
/*!100001 SET @@session.gtid_seq_no=151127509*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146202488
|
#190729 23:15:11 server id 1 end_log_pos 146202919 CRC32 0x3a98e593 Query thread_id=22 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438511/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:08','2019-07-29 23:15:08',3250,16,16,0,0,'RIBSFBT3','B','145.227.178.246',0,null,6005)
|
/*!*/;
|
# at 146202919
|
#190729 23:15:11 server id 1 end_log_pos 146202950 CRC32 0xc38de180 Xid = 1765560
|
COMMIT/*!*/;
|
# at 146202950
|
#190729 23:15:12 server id 1 end_log_pos 146202992 CRC32 0x3722f9e3 GTID 0-1-151127510 trans
|
/*!100001 SET @@session.gtid_seq_no=151127510*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146202992
|
#190729 23:15:12 server id 1 end_log_pos 146203615 CRC32 0xd04e764c Query thread_id=24 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438512/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:08','2019-07-29 23:15:08','RIBSFBT3','JQI','FNT02414',32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146203615
|
#190729 23:15:12 server id 1 end_log_pos 146203646 CRC32 0x7244d408 Xid = 1765564
|
COMMIT/*!*/;
|
# at 146203646
|
#190729 23:15:12 server id 1 end_log_pos 146203688 CRC32 0xc7d2ade3 GTID 0-1-151127511 trans
|
/*!100001 SET @@session.gtid_seq_no=151127511*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146203688
|
#190729 23:15:12 server id 1 end_log_pos 146204119 CRC32 0x064635bb Query thread_id=25 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438512/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:08','2019-07-29 23:15:08',3250,16,16,0,0,'RIBSFBT3','B','145.227.178.246',0,null,6006)
|
/*!*/;
|
# at 146204119
|
#190729 23:15:12 server id 1 end_log_pos 146204150 CRC32 0x1a07913c Xid = 1765568
|
COMMIT/*!*/;
|
# at 146204150
|
#190729 23:15:12 server id 1 end_log_pos 146204192 CRC32 0x717d6495 GTID 0-1-151127512 trans
|
/*!100001 SET @@session.gtid_seq_no=151127512*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146204192
|
#190729 23:15:12 server id 1 end_log_pos 146204814 CRC32 0x9c848122 Query thread_id=52 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438512/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:09','2019-07-29 23:15:09','RIBSFBT2','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146204814
|
#190729 23:15:12 server id 1 end_log_pos 146204845 CRC32 0xb1520fc8 Xid = 1765572
|
COMMIT/*!*/;
|
# at 146204845
|
#190729 23:15:12 server id 1 end_log_pos 146204887 CRC32 0xf4c1b573 GTID 0-1-151127513 trans
|
/*!100001 SET @@session.gtid_seq_no=151127513*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146204887
|
#190729 23:15:12 server id 1 end_log_pos 146205316 CRC32 0x1d6490bb Query thread_id=53 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438512/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:09','2019-07-29 23:15:09',3250,0,0,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6005)
|
/*!*/;
|
# at 146205316
|
#190729 23:15:12 server id 1 end_log_pos 146205347 CRC32 0x4d3afa4c Xid = 1765576
|
COMMIT/*!*/;
|
# at 146205347
|
#190729 23:15:18 server id 1 end_log_pos 146205389 CRC32 0xf1066d9f GTID 0-1-151127514 trans
|
/*!100001 SET @@session.gtid_seq_no=151127514*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146205389
|
#190729 23:15:18 server id 1 end_log_pos 146206011 CRC32 0x31caeb05 Query thread_id=54 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:07','2019-07-29 23:15:07','RIBSFBT1','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146206011
|
#190729 23:15:18 server id 1 end_log_pos 146206042 CRC32 0x37e1331f Xid = 1765592
|
COMMIT/*!*/;
|
# at 146206042
|
#190729 23:15:18 server id 1 end_log_pos 146206084 CRC32 0x255142f0 GTID 0-1-151127515 trans
|
/*!100001 SET @@session.gtid_seq_no=151127515*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146206084
|
#190729 23:15:18 server id 1 end_log_pos 146206706 CRC32 0x8b65ecb0 Query thread_id=92 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:06','2019-07-29 23:15:06','RIBSFBT2','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146206706
|
#190729 23:15:18 server id 1 end_log_pos 146206737 CRC32 0x0c243020 Xid = 1765598
|
COMMIT/*!*/;
|
# at 146206737
|
#190729 23:15:18 server id 1 end_log_pos 146206781 CRC32 0xd3e57d2b GTID 0-1-151127516 cid=1765595 trans
|
/*!100001 SET @@session.gtid_seq_no=151127516*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146206781
|
#190729 23:15:18 server id 1 end_log_pos 146207403 CRC32 0xa3b318b3 Query thread_id=56 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:07','2019-07-29 23:15:07','RIBSFBT1','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146207403
|
#190729 23:15:18 server id 1 end_log_pos 146207434 CRC32 0xcfd8949d Xid = 1765595
|
COMMIT/*!*/;
|
# at 146207434
|
#190729 23:15:18 server id 1 end_log_pos 146207478 CRC32 0x14f6b5ed GTID 0-1-151127517 cid=1765595 trans
|
/*!100001 SET @@session.gtid_seq_no=151127517*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146207478
|
#190729 23:15:18 server id 1 end_log_pos 146208100 CRC32 0xd8948ad4 Query thread_id=100 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:09','2019-07-29 23:15:09','RIBSFBT2','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146208100
|
#190729 23:15:18 server id 1 end_log_pos 146208131 CRC32 0x1f619d09 Xid = 1765593
|
COMMIT/*!*/;
|
# at 146208131
|
#190729 23:15:18 server id 1 end_log_pos 146208173 CRC32 0x8f13c1ac GTID 0-1-151127518 trans
|
/*!100001 SET @@session.gtid_seq_no=151127518*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146208173
|
#190729 23:15:18 server id 1 end_log_pos 146208797 CRC32 0x52abfce1 Query thread_id=54 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:12','2019-07-29 23:15:12','RIBSFBT1','JQI','FNT02414',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146208797
|
#190729 23:15:18 server id 1 end_log_pos 146208828 CRC32 0x3271ad62 Xid = 1765603
|
COMMIT/*!*/;
|
# at 146208828
|
#190729 23:15:18 server id 1 end_log_pos 146208870 CRC32 0x6d3e099c GTID 0-1-151127519 trans
|
/*!100001 SET @@session.gtid_seq_no=151127519*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146208870
|
#190729 23:15:18 server id 1 end_log_pos 146209494 CRC32 0x7bd9a7da Query thread_id=92 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:10','2019-07-29 23:15:10','RIBSFBT2','JQI','FNT02414',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146209494
|
#190729 23:15:18 server id 1 end_log_pos 146209525 CRC32 0xf8def6fd Xid = 1765605
|
COMMIT/*!*/;
|
# at 146209525
|
#190729 23:15:18 server id 1 end_log_pos 146209567 CRC32 0x99ed8a96 GTID 0-1-151127520 trans
|
/*!100001 SET @@session.gtid_seq_no=151127520*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146209567
|
#190729 23:15:18 server id 1 end_log_pos 146210191 CRC32 0xfdcbec2b Query thread_id=100 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:14','2019-07-29 23:15:14','RIBSFBT2','JQI','FNT02414',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146210191
|
#190729 23:15:18 server id 1 end_log_pos 146210222 CRC32 0xafbb07a8 Xid = 1765607
|
COMMIT/*!*/;
|
# at 146210222
|
#190729 23:15:18 server id 1 end_log_pos 146210264 CRC32 0x26650e7c GTID 0-1-151127521 trans
|
/*!100001 SET @@session.gtid_seq_no=151127521*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146210264
|
#190729 23:15:18 server id 1 end_log_pos 146210888 CRC32 0x6ffe0301 Query thread_id=56 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:12','2019-07-29 23:15:12','RIBSFBT1','JQI','FNT02414',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146210888
|
#190729 23:15:18 server id 1 end_log_pos 146210919 CRC32 0x10ba874b Xid = 1765609
|
COMMIT/*!*/;
|
# at 146210919
|
#190729 23:15:18 server id 1 end_log_pos 146210963 CRC32 0xd5b3453a GTID 0-1-151127522 cid=1765613 trans
|
/*!100001 SET @@session.gtid_seq_no=151127522*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146210963
|
#190729 23:15:18 server id 1 end_log_pos 146211585 CRC32 0x2e056883 Query thread_id=92 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:15','2019-07-29 23:15:15','RIBSFBT2','JQI','FCHOXP02',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146211585
|
#190729 23:15:18 server id 1 end_log_pos 146211616 CRC32 0x0d4eb84e Xid = 1765613
|
COMMIT/*!*/;
|
# at 146211616
|
#190729 23:15:18 server id 1 end_log_pos 146211660 CRC32 0xca88eb7b GTID 0-1-151127523 cid=1765613 trans
|
/*!100001 SET @@session.gtid_seq_no=151127523*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146211660
|
#190729 23:15:18 server id 1 end_log_pos 146212283 CRC32 0xfc0c3a0c Query thread_id=54 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:15','2019-07-29 23:15:15','RIBSFBT1','JQI','FCHOXP02',30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146212283
|
#190729 23:15:18 server id 1 end_log_pos 146212314 CRC32 0xd0efe828 Xid = 1765611
|
COMMIT/*!*/;
|
# at 146212314
|
#190729 23:15:18 server id 1 end_log_pos 146212356 CRC32 0x7af12674 GTID 0-1-151127524 trans
|
/*!100001 SET @@session.gtid_seq_no=151127524*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146212356
|
#190729 23:15:18 server id 1 end_log_pos 146212980 CRC32 0x26d66f36 Query thread_id=100 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:17','2019-07-29 23:15:17','RIBSFBT2','JQI','FCHOXP02',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146212980
|
#190729 23:15:18 server id 1 end_log_pos 146213011 CRC32 0xfc668e1d Xid = 1765615
|
COMMIT/*!*/;
|
# at 146213011
|
#190729 23:15:18 server id 1 end_log_pos 146213053 CRC32 0x03b0937a GTID 0-1-151127525 trans
|
/*!100001 SET @@session.gtid_seq_no=151127525*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146213053
|
#190729 23:15:18 server id 1 end_log_pos 146213675 CRC32 0x2faa2e71 Query thread_id=56 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:15','2019-07-29 23:15:15','RIBSFBT1','JQI','FCHOXP02',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146213675
|
#190729 23:15:18 server id 1 end_log_pos 146213706 CRC32 0x22b31af5 Xid = 1765617
|
COMMIT/*!*/;
|
# at 146213706
|
#190729 23:15:18 server id 1 end_log_pos 146213748 CRC32 0x677f1508 GTID 0-1-151127526 trans
|
/*!100001 SET @@session.gtid_seq_no=151127526*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146213748
|
#190729 23:15:18 server id 1 end_log_pos 146214371 CRC32 0x2b1129e7 Query thread_id=54 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (61,'2019-07-29 23:15:17','2019-07-29 23:15:17','RIBSFBT1','JQI','ZZMON01',15,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146214371
|
#190729 23:15:18 server id 1 end_log_pos 146214402 CRC32 0x0f59475c Xid = 1765619
|
COMMIT/*!*/;
|
# at 146214402
|
#190729 23:15:18 server id 1 end_log_pos 146214444 CRC32 0x978f4108 GTID 0-1-151127527 trans
|
/*!100001 SET @@session.gtid_seq_no=151127527*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146214444
|
#190729 23:15:18 server id 1 end_log_pos 146215066 CRC32 0x5662a354 Query thread_id=56 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (61,'2019-07-29 23:15:18','2019-07-29 23:15:18','RIBSFBT1','JQI','ZZMON01',16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146215066
|
#190729 23:15:18 server id 1 end_log_pos 146215097 CRC32 0xe04a740a Xid = 1765621
|
COMMIT/*!*/;
|
# at 146215097
|
#190729 23:15:18 server id 1 end_log_pos 146215139 CRC32 0x3d170340 GTID 0-1-151127528 trans
|
/*!100001 SET @@session.gtid_seq_no=151127528*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146215139
|
#190729 23:15:18 server id 1 end_log_pos 146215570 CRC32 0x376f6140 Query thread_id=93 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:06','2019-07-29 23:15:06',3250,16,16,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6001)
|
/*!*/;
|
# at 146215570
|
#190729 23:15:18 server id 1 end_log_pos 146215601 CRC32 0xa6c5cd45 Xid = 1765627
|
COMMIT/*!*/;
|
# at 146215601
|
#190729 23:15:18 server id 1 end_log_pos 146215643 CRC32 0xf7fcb512 GTID 0-1-151127529 trans
|
/*!100001 SET @@session.gtid_seq_no=151127529*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146215643
|
#190729 23:15:18 server id 1 end_log_pos 146216270 CRC32 0x0261e650 Query thread_id=54 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (4009,'2019-07-29 23:15:17','2019-07-29 23:15:18','RIBSFBT1','JQI','ZZMON01',78,78,0,0,0,0,0,47,0,0,31,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146216270
|
#190729 23:15:18 server id 1 end_log_pos 146216301 CRC32 0x171e7932 Xid = 1765625
|
COMMIT/*!*/;
|
# at 146216301
|
#190729 23:15:18 server id 1 end_log_pos 146216343 CRC32 0x09294679 GTID 0-1-151127530 trans
|
/*!100001 SET @@session.gtid_seq_no=151127530*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146216343
|
#190729 23:15:18 server id 1 end_log_pos 146216970 CRC32 0x4d2585d9 Query thread_id=56 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (4009,'2019-07-29 23:15:18','2019-07-29 23:15:18','RIBSFBT1','JQI','ZZMON01',63,63,0,0,0,0,0,31,0,0,32,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146216970
|
#190729 23:15:18 server id 1 end_log_pos 146217001 CRC32 0xce486821 Xid = 1765631
|
COMMIT/*!*/;
|
# at 146217001
|
#190729 23:15:18 server id 1 end_log_pos 146217043 CRC32 0x095fe156 GTID 0-1-151127531 trans
|
/*!100001 SET @@session.gtid_seq_no=151127531*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146217043
|
#190729 23:15:18 server id 1 end_log_pos 146217474 CRC32 0x95df1818 Query thread_id=93 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:10','2019-07-29 23:15:10',3250,16,16,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6001)
|
/*!*/;
|
# at 146217474
|
#190729 23:15:18 server id 1 end_log_pos 146217505 CRC32 0x93fec9ed Xid = 1765635
|
COMMIT/*!*/;
|
# at 146217505
|
#190729 23:15:18 server id 1 end_log_pos 146217547 CRC32 0xee4612cb GTID 0-1-151127532 trans
|
/*!100001 SET @@session.gtid_seq_no=151127532*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146217547
|
#190729 23:15:18 server id 1 end_log_pos 146217976 CRC32 0x75257dbc Query thread_id=101 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:09','2019-07-29 23:15:09',3250,0,0,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6006)
|
/*!*/;
|
# at 146217976
|
#190729 23:15:18 server id 1 end_log_pos 146218007 CRC32 0x222a1e4f Xid = 1765633
|
COMMIT/*!*/;
|
# at 146218007
|
#190729 23:15:18 server id 1 end_log_pos 146218049 CRC32 0x35f47529 GTID 0-1-151127533 trans
|
/*!100001 SET @@session.gtid_seq_no=151127533*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146218049
|
#190729 23:15:18 server id 1 end_log_pos 146218480 CRC32 0x64075dd4 Query thread_id=93 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FCHOXP02','','2019-07-29 23:15:15','2019-07-29 23:15:15',3250,16,16,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6001)
|
/*!*/;
|
# at 146218480
|
#190729 23:15:18 server id 1 end_log_pos 146218511 CRC32 0x93d787a4 Xid = 1765637
|
COMMIT/*!*/;
|
# at 146218511
|
#190729 23:15:18 server id 1 end_log_pos 146218553 CRC32 0x30865e73 GTID 0-1-151127534 trans
|
/*!100001 SET @@session.gtid_seq_no=151127534*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146218553
|
#190729 23:15:18 server id 1 end_log_pos 146218984 CRC32 0xe3d35cd3 Query thread_id=101 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:14','2019-07-29 23:15:14',3250,16,16,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6006)
|
/*!*/;
|
# at 146218984
|
#190729 23:15:18 server id 1 end_log_pos 146219015 CRC32 0x1f347f70 Xid = 1765639
|
COMMIT/*!*/;
|
# at 146219015
|
#190729 23:15:18 server id 1 end_log_pos 146219057 CRC32 0x28e2a235 GTID 0-1-151127535 trans
|
/*!100001 SET @@session.gtid_seq_no=151127535*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146219057
|
#190729 23:15:18 server id 1 end_log_pos 146219679 CRC32 0x4ed91f6c Query thread_id=84 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:10','2019-07-29 23:15:10','RIBSFBT2','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146219679
|
#190729 23:15:18 server id 1 end_log_pos 146219710 CRC32 0xd6f9b9e1 Xid = 1765600
|
COMMIT/*!*/;
|
# at 146219710
|
#190729 23:15:18 server id 1 end_log_pos 146219752 CRC32 0x66944d63 GTID 0-1-151127536 trans
|
/*!100001 SET @@session.gtid_seq_no=151127536*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146219752
|
#190729 23:15:18 server id 1 end_log_pos 146220374 CRC32 0x80ce59c6 Query thread_id=88 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:06','2019-07-29 23:15:06','RIBSFBT2','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146220374
|
#190729 23:15:18 server id 1 end_log_pos 146220405 CRC32 0xead29cd9 Xid = 1765601
|
COMMIT/*!*/;
|
# at 146220405
|
#190729 23:15:18 server id 1 end_log_pos 146220449 CRC32 0x41b08c1c GTID 0-1-151127537 cid=1765602 trans
|
/*!100001 SET @@session.gtid_seq_no=151127537*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146220449
|
#190729 23:15:18 server id 1 end_log_pos 146221071 CRC32 0x10e873fe Query thread_id=86 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:05','2019-07-29 23:15:05','RIBSFBT2','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146221071
|
#190729 23:15:18 server id 1 end_log_pos 146221102 CRC32 0x4b420b34 Xid = 1765602
|
COMMIT/*!*/;
|
# at 146221102
|
#190729 23:15:18 server id 1 end_log_pos 146221146 CRC32 0x0d10eec2 GTID 0-1-151127538 cid=1765602 trans
|
/*!100001 SET @@session.gtid_seq_no=151127538*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146221146
|
#190729 23:15:18 server id 1 end_log_pos 146221576 CRC32 0x535e93db Query thread_id=57 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:07','2019-07-29 23:15:07',3250,15,0,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6002)
|
/*!*/;
|
# at 146221576
|
#190729 23:15:18 server id 1 end_log_pos 146221607 CRC32 0x9e7159bc Xid = 1765648
|
COMMIT/*!*/;
|
# at 146221607
|
#190729 23:15:18 server id 1 end_log_pos 146221651 CRC32 0x2b8eebf8 GTID 0-1-151127539 cid=1765602 trans
|
/*!100001 SET @@session.gtid_seq_no=151127539*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146221651
|
#190729 23:15:18 server id 1 end_log_pos 146222082 CRC32 0xfc33d527 Query thread_id=101 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FCHOXP02','','2019-07-29 23:15:17','2019-07-29 23:15:17',3250,63,47,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6006)
|
/*!*/;
|
# at 146222082
|
#190729 23:15:18 server id 1 end_log_pos 146222113 CRC32 0x421cc32d Xid = 1765652
|
COMMIT/*!*/;
|
# at 146222113
|
#190729 23:15:18 server id 1 end_log_pos 146222157 CRC32 0x5d189009 GTID 0-1-151127540 cid=1765602 trans
|
/*!100001 SET @@session.gtid_seq_no=151127540*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146222157
|
#190729 23:15:18 server id 1 end_log_pos 146222588 CRC32 0x930ff800 Query thread_id=55 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:07','2019-07-29 23:15:07',3250,15,15,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6001)
|
/*!*/;
|
# at 146222588
|
#190729 23:15:18 server id 1 end_log_pos 146222619 CRC32 0x9dcee1ce Xid = 1765650
|
COMMIT/*!*/;
|
# at 146222619
|
#190729 23:15:18 server id 1 end_log_pos 146222661 CRC32 0x8c2c5415 GTID 0-1-151127541 trans
|
/*!100001 SET @@session.gtid_seq_no=151127541*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146222661
|
#190729 23:15:18 server id 1 end_log_pos 146223285 CRC32 0x77efb1e7 Query thread_id=84 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:14','2019-07-29 23:15:14','RIBSFBT2','JQI','FNT02414',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146223285
|
#190729 23:15:18 server id 1 end_log_pos 146223316 CRC32 0xc33be9bb Xid = 1765654
|
COMMIT/*!*/;
|
# at 146223316
|
#190729 23:15:18 server id 1 end_log_pos 146223358 CRC32 0x6ed4be8a GTID 0-1-151127542 trans
|
/*!100001 SET @@session.gtid_seq_no=151127542*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146223358
|
#190729 23:15:18 server id 1 end_log_pos 146223982 CRC32 0x0d1f2f4d Query thread_id=88 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:10','2019-07-29 23:15:10','RIBSFBT2','JQI','FNT02414',30,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146223982
|
#190729 23:15:18 server id 1 end_log_pos 146224013 CRC32 0xe226a39a Xid = 1765656
|
COMMIT/*!*/;
|
# at 146224013
|
#190729 23:15:18 server id 1 end_log_pos 146224055 CRC32 0xd3850fba GTID 0-1-151127543 trans
|
/*!100001 SET @@session.gtid_seq_no=151127543*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146224055
|
#190729 23:15:18 server id 1 end_log_pos 146224486 CRC32 0xc254ae9c Query thread_id=57 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:12','2019-07-29 23:15:12',3250,16,16,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6002)
|
/*!*/;
|
# at 146224486
|
#190729 23:15:18 server id 1 end_log_pos 146224517 CRC32 0x33bf650c Xid = 1765658
|
COMMIT/*!*/;
|
# at 146224517
|
#190729 23:15:18 server id 1 end_log_pos 146224561 CRC32 0x49edf20c GTID 0-1-151127544 cid=1765659 trans
|
/*!100001 SET @@session.gtid_seq_no=151127544*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146224561
|
#190729 23:15:18 server id 1 end_log_pos 146224992 CRC32 0x82e67886 Query thread_id=55 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:12','2019-07-29 23:15:12',3250,16,16,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6001)
|
/*!*/;
|
# at 146224992
|
#190729 23:15:18 server id 1 end_log_pos 146225023 CRC32 0x246256e5 Xid = 1765659
|
COMMIT/*!*/;
|
# at 146225023
|
#190729 23:15:18 server id 1 end_log_pos 146225067 CRC32 0x829371a0 GTID 0-1-151127545 cid=1765659 trans
|
/*!100001 SET @@session.gtid_seq_no=151127545*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146225067
|
#190729 23:15:18 server id 1 end_log_pos 146225691 CRC32 0x2bdff1cd Query thread_id=86 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:10','2019-07-29 23:15:10','RIBSFBT2','JQI','FNT02414',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146225691
|
#190729 23:15:18 server id 1 end_log_pos 146225722 CRC32 0xeeb4a163 Xid = 1765662
|
COMMIT/*!*/;
|
# at 146225722
|
#190729 23:15:18 server id 1 end_log_pos 146225764 CRC32 0xcc7bfd6b GTID 0-1-151127546 trans
|
/*!100001 SET @@session.gtid_seq_no=151127546*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146225764
|
#190729 23:15:18 server id 1 end_log_pos 146226388 CRC32 0xd4e9505a Query thread_id=88 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:15','2019-07-29 23:15:15','RIBSFBT2','JQI','FNT02414',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146226388
|
#190729 23:15:18 server id 1 end_log_pos 146226419 CRC32 0xb28ad8a2 Xid = 1765664
|
COMMIT/*!*/;
|
# at 146226419
|
#190729 23:15:18 server id 1 end_log_pos 146226461 CRC32 0xf015bbb6 GTID 0-1-151127547 trans
|
/*!100001 SET @@session.gtid_seq_no=151127547*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146226461
|
#190729 23:15:18 server id 1 end_log_pos 146226892 CRC32 0x2e95893d Query thread_id=57 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FCHOXP02','','2019-07-29 23:15:15','2019-07-29 23:15:15',3250,16,16,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6002)
|
/*!*/;
|
# at 146226892
|
#190729 23:15:18 server id 1 end_log_pos 146226923 CRC32 0xc51848ce Xid = 1765666
|
COMMIT/*!*/;
|
# at 146226923
|
#190729 23:15:18 server id 1 end_log_pos 146226965 CRC32 0x4f1b6f45 GTID 0-1-151127548 trans
|
/*!100001 SET @@session.gtid_seq_no=151127548*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146226965
|
#190729 23:15:18 server id 1 end_log_pos 146227396 CRC32 0xd21c4e34 Query thread_id=55 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FCHOXP02','','2019-07-29 23:15:15','2019-07-29 23:15:15',3250,15,15,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6001)
|
/*!*/;
|
# at 146227396
|
#190729 23:15:18 server id 1 end_log_pos 146227427 CRC32 0x703c2f4b Xid = 1765668
|
COMMIT/*!*/;
|
# at 146227427
|
#190729 23:15:18 server id 1 end_log_pos 146227469 CRC32 0x29b44ed8 GTID 0-1-151127549 trans
|
/*!100001 SET @@session.gtid_seq_no=151127549*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146227469
|
#190729 23:15:18 server id 1 end_log_pos 146228092 CRC32 0x7707cfbf Query thread_id=86 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:14','2019-07-29 23:15:14','RIBSFBT2','JQI','FCHOXP02',32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146228092
|
#190729 23:15:18 server id 1 end_log_pos 146228123 CRC32 0xd86aee68 Xid = 1765669
|
COMMIT/*!*/;
|
# at 146228123
|
#190729 23:15:18 server id 1 end_log_pos 146228165 CRC32 0x69d53d83 GTID 0-1-151127550 trans
|
/*!100001 SET @@session.gtid_seq_no=151127550*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146228165
|
#190729 23:15:18 server id 1 end_log_pos 146228594 CRC32 0x48dd5214 Query thread_id=57 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2019-07-29 23:15:18','2019-07-29 23:15:18',3203,31,16,0,0,'RIBSFBT1','','145.227.178.249',0,null,6002)
|
/*!*/;
|
# at 146228594
|
#190729 23:15:18 server id 1 end_log_pos 146228625 CRC32 0x31bdfeff Xid = 1765672
|
COMMIT/*!*/;
|
# at 146228625
|
#190729 23:15:18 server id 1 end_log_pos 146228667 CRC32 0x1acee2d1 GTID 0-1-151127551 trans
|
/*!100001 SET @@session.gtid_seq_no=151127551*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146228667
|
#190729 23:15:18 server id 1 end_log_pos 146229096 CRC32 0x41b5e3c0 Query thread_id=55 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2019-07-29 23:15:17','2019-07-29 23:15:17',3203,15,15,0,0,'RIBSFBT1','','145.227.178.249',0,null,6001)
|
/*!*/;
|
# at 146229096
|
#190729 23:15:18 server id 1 end_log_pos 146229127 CRC32 0x4bdb3294 Xid = 1765676
|
COMMIT/*!*/;
|
# at 146229127
|
#190729 23:15:18 server id 1 end_log_pos 146229169 CRC32 0x345ea9fe GTID 0-1-151127552 trans
|
/*!100001 SET @@session.gtid_seq_no=151127552*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146229169
|
#190729 23:15:18 server id 1 end_log_pos 146229600 CRC32 0xd90839fe Query thread_id=82 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:10','2019-07-29 23:15:10',3250,16,16,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6004)
|
/*!*/;
|
# at 146229600
|
#190729 23:15:18 server id 1 end_log_pos 146229631 CRC32 0xa95d7bc8 Xid = 1765678
|
COMMIT/*!*/;
|
# at 146229631
|
#190729 23:15:18 server id 1 end_log_pos 146229673 CRC32 0xf590f391 GTID 0-1-151127553 trans
|
/*!100001 SET @@session.gtid_seq_no=151127553*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146229673
|
#190729 23:15:18 server id 1 end_log_pos 146230103 CRC32 0xd603bfed Query thread_id=57 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2019-07-29 23:15:18','2019-07-29 23:15:18',3237,63,63,0,31,'RIBSFBT1','','145.227.178.249',0,null,6002)
|
/*!*/;
|
# at 146230103
|
#190729 23:15:18 server id 1 end_log_pos 146230134 CRC32 0x0e6612da Xid = 1765680
|
COMMIT/*!*/;
|
# at 146230134
|
#190729 23:15:18 server id 1 end_log_pos 146230176 CRC32 0x067dba8e GTID 0-1-151127554 trans
|
/*!100001 SET @@session.gtid_seq_no=151127554*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146230176
|
#190729 23:15:18 server id 1 end_log_pos 146230606 CRC32 0xfbcc91bb Query thread_id=55 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2019-07-29 23:15:17','2019-07-29 23:15:18',3237,78,78,0,47,'RIBSFBT1','','145.227.178.249',0,null,6001)
|
/*!*/;
|
# at 146230606
|
#190729 23:15:18 server id 1 end_log_pos 146230637 CRC32 0xc52ccdfb Xid = 1765682
|
COMMIT/*!*/;
|
# at 146230637
|
#190729 23:15:18 server id 1 end_log_pos 146230679 CRC32 0x47cbfd9c GTID 0-1-151127555 trans
|
/*!100001 SET @@session.gtid_seq_no=151127555*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146230679
|
#190729 23:15:18 server id 1 end_log_pos 146231108 CRC32 0x4b025580 Query thread_id=89 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:06','2019-07-29 23:15:06',3250,0,0,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6002)
|
/*!*/;
|
# at 146231108
|
#190729 23:15:18 server id 1 end_log_pos 146231139 CRC32 0xff2b31f8 Xid = 1765688
|
COMMIT/*!*/;
|
# at 146231139
|
#190729 23:15:18 server id 1 end_log_pos 146231181 CRC32 0x30b4285c GTID 0-1-151127556 trans
|
/*!100001 SET @@session.gtid_seq_no=151127556*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146231181
|
#190729 23:15:18 server id 1 end_log_pos 146231612 CRC32 0x494191e7 Query thread_id=82 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:14','2019-07-29 23:15:14',3250,16,16,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6004)
|
/*!*/;
|
# at 146231612
|
#190729 23:15:18 server id 1 end_log_pos 146231643 CRC32 0x3ccfd322 Xid = 1765686
|
COMMIT/*!*/;
|
# at 146231643
|
#190729 23:15:18 server id 1 end_log_pos 146231685 CRC32 0xd6062a60 GTID 0-1-151127557 trans
|
/*!100001 SET @@session.gtid_seq_no=151127557*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146231685
|
#190729 23:15:18 server id 1 end_log_pos 146232116 CRC32 0xd0df3d24 Query thread_id=89 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:10','2019-07-29 23:15:10',3250,15,15,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6002)
|
/*!*/;
|
# at 146232116
|
#190729 23:15:18 server id 1 end_log_pos 146232147 CRC32 0xfe0a6497 Xid = 1765692
|
COMMIT/*!*/;
|
# at 146232147
|
#190729 23:15:18 server id 1 end_log_pos 146232189 CRC32 0x7e5e3089 GTID 0-1-151127558 trans
|
/*!100001 SET @@session.gtid_seq_no=151127558*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146232189
|
#190729 23:15:18 server id 1 end_log_pos 146232618 CRC32 0x5a5767f6 Query thread_id=87 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:05','2019-07-29 23:15:05',3250,0,0,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6003)
|
/*!*/;
|
# at 146232618
|
#190729 23:15:18 server id 1 end_log_pos 146232649 CRC32 0xa84f5ac0 Xid = 1765694
|
COMMIT/*!*/;
|
# at 146232649
|
#190729 23:15:18 server id 1 end_log_pos 146232691 CRC32 0x5e511d90 GTID 0-1-151127559 trans
|
/*!100001 SET @@session.gtid_seq_no=151127559*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146232691
|
#190729 23:15:18 server id 1 end_log_pos 146233122 CRC32 0x1daa5dc7 Query thread_id=89 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:15','2019-07-29 23:15:15',3250,16,16,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6002)
|
/*!*/;
|
# at 146233122
|
#190729 23:15:18 server id 1 end_log_pos 146233153 CRC32 0x4290721f Xid = 1765696
|
COMMIT/*!*/;
|
# at 146233153
|
#190729 23:15:18 server id 1 end_log_pos 146233195 CRC32 0xb0e9f388 GTID 0-1-151127560 trans
|
/*!100001 SET @@session.gtid_seq_no=151127560*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146233195
|
#190729 23:15:18 server id 1 end_log_pos 146233626 CRC32 0xd5305cd4 Query thread_id=87 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:10','2019-07-29 23:15:10',3250,16,16,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6003)
|
/*!*/;
|
# at 146233626
|
#190729 23:15:18 server id 1 end_log_pos 146233657 CRC32 0x2365d4a1 Xid = 1765698
|
COMMIT/*!*/;
|
# at 146233657
|
#190729 23:15:18 server id 1 end_log_pos 146233699 CRC32 0x29308e89 GTID 0-1-151127561 trans
|
/*!100001 SET @@session.gtid_seq_no=151127561*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146233699
|
#190729 23:15:18 server id 1 end_log_pos 146234130 CRC32 0x854095d4 Query thread_id=87 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FCHOXP02','','2019-07-29 23:15:14','2019-07-29 23:15:14',3250,63,63,0,0,'RIBSFBT2','B','145.227.178.246',0,null,6003)
|
/*!*/;
|
# at 146234130
|
#190729 23:15:18 server id 1 end_log_pos 146234161 CRC32 0xb60f765b Xid = 1765700
|
COMMIT/*!*/;
|
# at 146234161
|
#190729 23:15:18 server id 1 end_log_pos 146234203 CRC32 0x976f3e2a GTID 0-1-151127562 trans
|
/*!100001 SET @@session.gtid_seq_no=151127562*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146234203
|
#190729 23:15:18 server id 1 end_log_pos 146234825 CRC32 0xf71efe67 Query thread_id=58 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:07','2019-07-29 23:15:07','RIBSFBT1','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146234825
|
#190729 23:15:18 server id 1 end_log_pos 146234856 CRC32 0x4b6b67f6 Xid = 1765704
|
COMMIT/*!*/;
|
# at 146234856
|
#190729 23:15:18 server id 1 end_log_pos 146234898 CRC32 0x9a03dd4a GTID 0-1-151127563 trans
|
/*!100001 SET @@session.gtid_seq_no=151127563*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146234898
|
#190729 23:15:18 server id 1 end_log_pos 146235522 CRC32 0x49d9b886 Query thread_id=58 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:12','2019-07-29 23:15:12','RIBSFBT1','JQI','FNT02414',30,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146235522
|
#190729 23:15:18 server id 1 end_log_pos 146235553 CRC32 0xa6f4e56b Xid = 1765706
|
COMMIT/*!*/;
|
# at 146235553
|
#190729 23:15:18 server id 1 end_log_pos 146235595 CRC32 0xf4203735 GTID 0-1-151127564 trans
|
/*!100001 SET @@session.gtid_seq_no=151127564*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146235595
|
#190729 23:15:18 server id 1 end_log_pos 146236217 CRC32 0x3d02885e Query thread_id=58 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:15','2019-07-29 23:15:15','RIBSFBT1','JQI','FCHOXP02',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146236217
|
#190729 23:15:18 server id 1 end_log_pos 146236248 CRC32 0x1a1b23c5 Xid = 1765708
|
COMMIT/*!*/;
|
# at 146236248
|
#190729 23:15:18 server id 1 end_log_pos 146236290 CRC32 0x49718605 GTID 0-1-151127565 trans
|
/*!100001 SET @@session.gtid_seq_no=151127565*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146236290
|
#190729 23:15:18 server id 1 end_log_pos 146236913 CRC32 0xce191db8 Query thread_id=58 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (61,'2019-07-29 23:15:18','2019-07-29 23:15:18','RIBSFBT1','JQI','ZZMON01',15,0,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146236913
|
#190729 23:15:18 server id 1 end_log_pos 146236944 CRC32 0x37f17e6c Xid = 1765710
|
COMMIT/*!*/;
|
# at 146236944
|
#190729 23:15:18 server id 1 end_log_pos 146236986 CRC32 0x6b1c3062 GTID 0-1-151127566 trans
|
/*!100001 SET @@session.gtid_seq_no=151127566*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146236986
|
#190729 23:15:18 server id 1 end_log_pos 146237613 CRC32 0x16e3455d Query thread_id=58 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (4009,'2019-07-29 23:15:18','2019-07-29 23:15:18','RIBSFBT1','JQI','ZZMON01',62,62,0,0,0,0,0,32,0,0,30,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146237613
|
#190729 23:15:18 server id 1 end_log_pos 146237644 CRC32 0x2aabe497 Xid = 1765712
|
COMMIT/*!*/;
|
# at 146237644
|
#190729 23:15:18 server id 1 end_log_pos 146237686 CRC32 0x1f7fadd2 GTID 0-1-151127567 trans
|
/*!100001 SET @@session.gtid_seq_no=151127567*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146237686
|
#190729 23:15:18 server id 1 end_log_pos 146238117 CRC32 0x22ff6f1a Query thread_id=59 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:07','2019-07-29 23:15:07',3250,15,15,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6003)
|
/*!*/;
|
# at 146238117
|
#190729 23:15:18 server id 1 end_log_pos 146238148 CRC32 0xfde44110 Xid = 1765716
|
COMMIT/*!*/;
|
# at 146238148
|
#190729 23:15:18 server id 1 end_log_pos 146238190 CRC32 0xe28578c0 GTID 0-1-151127568 trans
|
/*!100001 SET @@session.gtid_seq_no=151127568*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146238190
|
#190729 23:15:18 server id 1 end_log_pos 146238621 CRC32 0x411882fe Query thread_id=59 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:12','2019-07-29 23:15:12',3250,15,15,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6003)
|
/*!*/;
|
# at 146238621
|
#190729 23:15:18 server id 1 end_log_pos 146238652 CRC32 0xc61234c3 Xid = 1765718
|
COMMIT/*!*/;
|
# at 146238652
|
#190729 23:15:18 server id 1 end_log_pos 146238694 CRC32 0xa951397f GTID 0-1-151127569 trans
|
/*!100001 SET @@session.gtid_seq_no=151127569*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146238694
|
#190729 23:15:18 server id 1 end_log_pos 146239125 CRC32 0x8827be14 Query thread_id=59 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FCHOXP02','','2019-07-29 23:15:15','2019-07-29 23:15:15',3250,31,31,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6003)
|
/*!*/;
|
# at 146239125
|
#190729 23:15:18 server id 1 end_log_pos 146239156 CRC32 0x809d8d8c Xid = 1765720
|
COMMIT/*!*/;
|
# at 146239156
|
#190729 23:15:18 server id 1 end_log_pos 146239198 CRC32 0x170e89dc GTID 0-1-151127570 trans
|
/*!100001 SET @@session.gtid_seq_no=151127570*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146239198
|
#190729 23:15:18 server id 1 end_log_pos 146239627 CRC32 0xf2ec44aa Query thread_id=59 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2019-07-29 23:15:18','2019-07-29 23:15:18',3203,15,15,0,0,'RIBSFBT1','','145.227.178.249',0,null,6003)
|
/*!*/;
|
# at 146239627
|
#190729 23:15:18 server id 1 end_log_pos 146239658 CRC32 0x21704977 Xid = 1765722
|
COMMIT/*!*/;
|
# at 146239658
|
#190729 23:15:18 server id 1 end_log_pos 146239700 CRC32 0x61daadbd GTID 0-1-151127571 trans
|
/*!100001 SET @@session.gtid_seq_no=151127571*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146239700
|
#190729 23:15:18 server id 1 end_log_pos 146240130 CRC32 0x17fcc1a3 Query thread_id=59 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438518/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2019-07-29 23:15:18','2019-07-29 23:15:18',3237,78,62,0,32,'RIBSFBT1','','145.227.178.249',0,null,6003)
|
/*!*/;
|
# at 146240130
|
#190729 23:15:18 server id 1 end_log_pos 146240161 CRC32 0xc87bce56 Xid = 1765724
|
COMMIT/*!*/;
|
# at 146240161
|
#190729 23:15:19 server id 1 end_log_pos 146240203 CRC32 0xc51b5f6a GTID 0-1-151127572 trans
|
/*!100001 SET @@session.gtid_seq_no=151127572*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146240203
|
#190729 23:15:19 server id 1 end_log_pos 146240825 CRC32 0x00928346 Query thread_id=60 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:07','2019-07-29 23:15:07','RIBSFBT1','JQI','FNT02414',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146240825
|
#190729 23:15:19 server id 1 end_log_pos 146240856 CRC32 0xceac369a Xid = 1765728
|
COMMIT/*!*/;
|
# at 146240856
|
#190729 23:15:19 server id 1 end_log_pos 146240898 CRC32 0x114c7005 GTID 0-1-151127573 trans
|
/*!100001 SET @@session.gtid_seq_no=151127573*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146240898
|
#190729 23:15:19 server id 1 end_log_pos 146241521 CRC32 0xb8c1d7af Query thread_id=60 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:11','2019-07-29 23:15:11','RIBSFBT1','JQI','FNT02414',30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146241521
|
#190729 23:15:19 server id 1 end_log_pos 146241552 CRC32 0xb945b85e Xid = 1765730
|
COMMIT/*!*/;
|
# at 146241552
|
#190729 23:15:19 server id 1 end_log_pos 146241594 CRC32 0xe12cfadc GTID 0-1-151127574 trans
|
/*!100001 SET @@session.gtid_seq_no=151127574*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146241594
|
#190729 23:15:19 server id 1 end_log_pos 146242218 CRC32 0xfc4bf987 Query thread_id=60 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (87,'2019-07-29 23:15:15','2019-07-29 23:15:15','RIBSFBT1','JQI','FCHOXP02',32,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146242218
|
#190729 23:15:19 server id 1 end_log_pos 146242249 CRC32 0x1558dfad Xid = 1765732
|
COMMIT/*!*/;
|
# at 146242249
|
#190729 23:15:19 server id 1 end_log_pos 146242291 CRC32 0x70721f78 GTID 0-1-151127575 trans
|
/*!100001 SET @@session.gtid_seq_no=151127575*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146242291
|
#190729 23:15:19 server id 1 end_log_pos 146242914 CRC32 0x9ffb54f3 Query thread_id=60 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (61,'2019-07-29 23:15:18','2019-07-29 23:15:18','RIBSFBT1','JQI','ZZMON01',16,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146242914
|
#190729 23:15:19 server id 1 end_log_pos 146242945 CRC32 0x58ee374f Xid = 1765734
|
COMMIT/*!*/;
|
# at 146242945
|
#190729 23:15:19 server id 1 end_log_pos 146242987 CRC32 0xcdc491e1 GTID 0-1-151127576 trans
|
/*!100001 SET @@session.gtid_seq_no=151127576*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146242987
|
#190729 23:15:19 server id 1 end_log_pos 146243614 CRC32 0x34e1d5e3 Query thread_id=60 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_SERVER_ENQ_PERF (QUERY_TYPE, QUERY_START, QUERY_END, SERVER_NODE_NAME, CLIENT_NODE_NAME, USER_ID, TOTAL_IJQ_TIME, ACCOMODATION_TIME, ENRG_TIME, TIMETABLE_TIME, SUPPLEMENTS_TIME, RESTRICTIONS_TIME, FARES_TIME, EXTERNAL_TIME, BULLETINS_TIME, EASEMENTS_TIME, ACCOMMODATION_TIME_INTERNAL, NRS_TIMEOUT, HTTP_STATUS, NRS_RES, JETT_CALLS, NUM_JOURNEYS, NRS_CALLS, TRANSLATED_USER_ID) VALUES (4009,'2019-07-29 23:15:18','2019-07-29 23:15:18','RIBSFBT1','JQI','ZZMON01',78,78,0,0,0,0,0,47,0,0,31,0,0,0,0,0,0,null)
|
/*!*/;
|
# at 146243614
|
#190729 23:15:19 server id 1 end_log_pos 146243645 CRC32 0x128626eb Xid = 1765736
|
COMMIT/*!*/;
|
# at 146243645
|
#190729 23:15:19 server id 1 end_log_pos 146243687 CRC32 0x0b612be1 GTID 0-1-151127577 trans
|
/*!100001 SET @@session.gtid_seq_no=151127577*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146243687
|
#190729 23:15:19 server id 1 end_log_pos 146244117 CRC32 0xc204973e Query thread_id=61 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:07','2019-07-29 23:15:07',3250,16,0,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6004)
|
/*!*/;
|
# at 146244117
|
#190729 23:15:19 server id 1 end_log_pos 146244148 CRC32 0x58c6621a Xid = 1765740
|
COMMIT/*!*/;
|
# at 146244148
|
#190729 23:15:19 server id 1 end_log_pos 146244190 CRC32 0x10b50b4c GTID 0-1-151127578 trans
|
/*!100001 SET @@session.gtid_seq_no=151127578*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146244190
|
#190729 23:15:19 server id 1 end_log_pos 146244621 CRC32 0x1984a5c4 Query thread_id=61 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FNT02414','','2019-07-29 23:15:11','2019-07-29 23:15:11',3250,15,15,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6004)
|
/*!*/;
|
# at 146244621
|
#190729 23:15:19 server id 1 end_log_pos 146244652 CRC32 0xefed98e0 Xid = 1765742
|
COMMIT/*!*/;
|
# at 146244652
|
#190729 23:15:19 server id 1 end_log_pos 146244694 CRC32 0x5b614af3 GTID 0-1-151127579 trans
|
/*!100001 SET @@session.gtid_seq_no=151127579*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146244694
|
#190729 23:15:19 server id 1 end_log_pos 146245125 CRC32 0x3dec43c9 Query thread_id=61 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('FCHOXP02','','2019-07-29 23:15:15','2019-07-29 23:15:15',3250,31,31,0,0,'RIBSFBT1','B','145.227.178.246',0,null,6004)
|
/*!*/;
|
# at 146245125
|
#190729 23:15:19 server id 1 end_log_pos 146245156 CRC32 0xd5d91084 Xid = 1765744
|
COMMIT/*!*/;
|
# at 146245156
|
#190729 23:15:19 server id 1 end_log_pos 146245198 CRC32 0xbc78b96e GTID 0-1-151127580 trans
|
/*!100001 SET @@session.gtid_seq_no=151127580*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146245198
|
#190729 23:15:19 server id 1 end_log_pos 146245627 CRC32 0xab0008d0 Query thread_id=61 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2019-07-29 23:15:18','2019-07-29 23:15:18',3203,16,16,0,0,'RIBSFBT1','','145.227.178.249',0,null,6004)
|
/*!*/;
|
# at 146245627
|
#190729 23:15:19 server id 1 end_log_pos 146245658 CRC32 0x0d570a7d Xid = 1765746
|
COMMIT/*!*/;
|
# at 146245658
|
#190729 23:15:19 server id 1 end_log_pos 146245700 CRC32 0xb5c7e232 GTID 0-1-151127581 trans
|
/*!100001 SET @@session.gtid_seq_no=151127581*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 146245700
|
#190729 23:15:19 server id 1 end_log_pos 146246130 CRC32 0x373701b1 Query thread_id=61 exec_time=0 error_code=0
|
SET TIMESTAMP=1564438519/*!*/;
|
/* */ INSERT INTO RJIS_JQI_PERF (USER_ID, MACHINE_ID, INPUT_TIME, OUTPUT_TIME, TYPE_1, TOTAL_RESPONSE_TIME, IJQ_TIME, CTR_TIME, EXTERNAL_TIME, SERVER_NODE_NAME, QUERY_DETAILS, IP_ADDRESS, NRS_TIMEOUT, TRANSLATED_USER_ID, PORT) VALUES ('ZZMON01','','2019-07-29 23:15:18','2019-07-29 23:15:18',3237,78,78,0,47,'RIBSFBT1','','145.227.178.249',0,null,6004)
|
/*!*/;
|
# at 146246130
|
#190729 23:15:19 server id 1 end_log_pos 146246161 CRC32 0xe45c8d5c Xid = 1765748
|
COMMIT/*!*/;
|
DELIMITER ;
|
# End of log file
|
ROLLBACK /* added by mysqlbinlog */;
|
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
|
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
|
|