Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.12
-
None
-
Live Data Factory running on Windows 2008 R1 32bit
Description
Experienced a crash of our primary MariaDB DB this evening at 23:15 , please can you help?
from the MariaDB log file the crash details are:-
190729 23:15:10 [ERROR] mysqld got exception 0xc000000d ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.3.12-MariaDB-log
|
key_buffer_size=8388608
|
read_buffer_size=36864
|
max_used_connections=266
|
max_threads=65537
|
thread_count=270
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2381676 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x0
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
ntdll.dll!EtwNotificationUnregister()
|
mysqld.exe!timer_callback()[threadpool_win.cc:419]
|
ntdll.dll!RtlIsCriticalSectionLockedByThread()
|
ntdll.dll!RtlSizeHeap()
|
kernel32.dll!BaseThreadInitThunk()
|
ntdll.dll!RtlInitializeExceptionChain()
|
ntdll.dll!RtlInitializeExceptionChain()
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
2019-07-29 23:18:21 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
|
2019-07-29 23:18:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
|
2019-07-29 23:18:21 0 [Note] InnoDB: Uses event mutexes
|
2019-07-29 23:18:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
2019-07-29 23:18:21 0 [Note] InnoDB: Number of pools: 1
|
2019-07-29 23:18:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
|
2019-07-29 23:18:21 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M
|
2019-07-29 23:18:21 0 [Note] InnoDB: Completed initialization of buffer pool
|
2019-07-29 23:18:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=150962067982
|
2019-07-29 23:18:22 0 [Note] InnoDB: Transaction 294057132 was in the XA prepared state.
|
2019-07-29 23:18:22 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
|
2019-07-29 23:18:22 0 [Note] InnoDB: Trx id counter is 294057133
|
2019-07-29 23:18:22 0 [Note] InnoDB: Starting final batch to recover 18 pages from redo log.
|
2019-07-29 23:18:22 0 [Note] InnoDB: Last binlog file 'd:\MariaDB\master\logbin\Master-bin.000615', position 146245658
|
2019-07-29 23:18:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2019-07-29 23:18:26 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
|
2019-07-29 23:18:26 0 [Note] InnoDB: Rollback of non-prepared transactions completed
|
2019-07-29 23:18:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2019-07-29 23:18:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2019-07-29 23:18:26 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2019-07-29 23:18:26 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
|
2019-07-29 23:18:26 0 [Note] InnoDB: 10.3.12 started; log sequence number 150962117583; transaction id 294057135
|
2019-07-29 23:18:26 0 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool
|
2019-07-29 23:18:26 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2019-07-29 23:18:26 0 [Note] Recovering after a crash using d:/MariaDB/master/logbin/Master-bin
|
2019-07-29 23:18:35 0 [Note] InnoDB: Buffer pool(s) load completed at 190729 23:18:35
|
2019-07-29 23:18:44 0 [Note] Starting crash recovery...
|
2019-07-29 23:18:44 0 [Note] InnoDB: Starting recovery for XA transactions...
|
2019-07-29 23:18:44 0 [Note] InnoDB: Transaction 294057132 in prepared state after recovery
|
2019-07-29 23:18:44 0 [Note] InnoDB: Transaction contains changes to 1 rows
|
2019-07-29 23:18:44 0 [Note] InnoDB: 1 transactions in prepared state after recovery
|
2019-07-29 23:18:44 0 [Note] Found 1 prepared transaction(s) in InnoDB
|
2019-07-29 23:18:44 0 [Note] Crash recovery finished.
|
2019-07-29 23:18:44 0 [Note] Server socket created on IP: '::'.
|
2019-07-29 23:18:44 0 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode.
|
2019-07-29 23:18:44 0 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode.
|
2019-07-29 23:18:44 0 [Note] Reading of all Master_info entries succeded
|
2019-07-29 23:18:44 0 [Note] Added new Master_info '' to hash table
|
2019-07-29 23:18:44 0 [Note] D:\MariaDB\bin\mysqld.exe: ready for connections.
|
Version: '10.3.12-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution
|
2019-07-29 23:19:23 81 [Note] Start binlog_dump to slave_server(2), pos(Master-bin.000615, 146246161)
|
2019-07-29 23:19:52 90 [Warning] Access denied for user 'root'@'127.0.0.1' (using password: YES)
|
2019-07-29 23:24:11 0 [Note] D:\MariaDB\bin\mysqld.exe (initiated by: unknown): Normal shutdown
|
2019-07-29 23:24:11 0 [Note] Event Scheduler: Purging the queue. 0 events
|
2019-07-29 23:24:11 0 [Note] InnoDB: FTS optimize thread exiting.
|
2019-07-29 23:24:11 0 [Note] InnoDB: Starting shutdown...
|
2019-07-29 23:24:11 0 [Note] InnoDB: Dumping buffer pool(s) to D:\MariaDB\data\ib_buffer_pool
|
2019-07-29 23:24:11 0 [Note] InnoDB: Instance 0, restricted to 6144 pages due to innodb_buf_pool_dump_pct=25
|
2019-07-29 23:24:11 0 [Note] InnoDB: Buffer pool(s) dump completed at 190729 23:24:11
|
2019-07-29 23:24:12 0 [Note] InnoDB: Shutdown completed; log sequence number 150964259475; transaction id 294063316
|
2019-07-29 23:24:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2019-07-29 23:24:12 0 [Note] D:\MariaDB\bin\mysqld.exe: Shutdown complete
|
|
|
2019-07-29 23:24:16 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
|
2019-07-29 23:24:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
|
2019-07-29 23:24:16 0 [Note] InnoDB: Uses event mutexes
|
2019-07-29 23:24:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
2019-07-29 23:24:16 0 [Note] InnoDB: Number of pools: 1
|
2019-07-29 23:24:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
|
2019-07-29 23:24:16 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M
|
2019-07-29 23:24:16 0 [Note] InnoDB: Completed initialization of buffer pool
|
2019-07-29 23:24:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2019-07-29 23:24:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2019-07-29 23:24:16 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2019-07-29 23:24:16 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
|
2019-07-29 23:24:16 0 [Note] InnoDB: 10.3.12 started; log sequence number 150964259475; transaction id 294063318
|
2019-07-29 23:24:16 0 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool
|
2019-07-29 23:24:16 0 [Note] Plugin 'FEEDBACK' is disabled.
|
2019-07-29 23:24:16 0 [Note] Server socket created on IP: '::'.
|
2019-07-29 23:24:16 0 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode.
|
2019-07-29 23:24:16 0 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode.
|
2019-07-29 23:24:16 0 [Note] Reading of all Master_info entries succeded
|
2019-07-29 23:24:16 0 [Note] Added new Master_info '' to hash table
|
2019-07-29 23:24:16 0 [Note] D:\MariaDB\bin\mysqld.exe: ready for connections.
|
Version: '10.3.12-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution
|
2019-07-29 23:24:31 0 [Note] InnoDB: Buffer pool(s) load completed at 190729 23:24:31
|
2019-07-29 23:25:12 65 [Note] Start binlog_dump to slave_server(2), pos(Master-bin.000616, 1808629)
|
2019-07-29 23:37:53 251 [Warning] Access denied for user 'zzdomainadmin'@'127.0.0.1' (using password: NO)
|
at 23:15:11 the following appeared in the application event log on the server
Faulting application mysqld.exe, version 10.3.12.0, time stamp 0x5c2f7f3f, faulting module ntdll.dll, version 6.0.6003.20562, time stamp 0x5cfa798d, exception code 0xc000000d, fault offset 0x00087471, process id 0x124, application start time 0x01d545acd61aec10.
|
There appears to be no hardware issue (it is running on a Virtual Machine under vmware ESXi), and all other VMs and other processes are ok; no ballooning memory; it had plenty of memory available etc...
The DB does run in Binlog mode and has a standby DB
I have done a mysqlcheck --all-databases and all appears to be ok
Can you urgently help please?
Is this a known bug and is it fixed in a later version of MariaDB and if so which version please?
Sorry for all the questions, I am panicking a great deal.
Attachments
Issue Links
- relates to
-
-
- Open
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Labels | need_feedback |
Hi, it has not reoccurred;.
Sorry there was was no minidump produced from the crash.
I do not have the query that caused this as we do not log all the queries in our production environment as that would have a severe performance impact and we would not have enough storage to log every enquiry.
Any ideas on cause, and if this is fixed in a later release please?
Hi , just a thought; i have logbin enabled and have the logbin files on the day of the crash as follows (the crash was at 23:15:11 on 29/07/2019) :-
Logbin files from day of Crash
29/07/2019 13:10 214,745,634 Master-bin.000614
29/07/2019 23:15 146,246,161 Master-bin.000615
29/07/2019 23:24 1,808,652 Master-bin.000616
If these are of use; how do I upload such large files to this Jira please?
thank you for all your very valuable support and guidance.
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*/; |
| Labels | need_feedback |
| Fix Version/s | 10.3 [ 22126 ] | |
| Assignee | Oleksandr Byelkin [ sanja ] | |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Description |
Experienced a crash of our primary MariaDB DB this evening at 23:15 , please can you help?
from the MariaDB log file the crash details are:- 190729 23:15:10 [ERROR] mysqld got exception 0xc000000d ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.12-MariaDB-log key_buffer_size=8388608 read_buffer_size=36864 max_used_connections=266 max_threads=65537 thread_count=270 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2381676 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... ntdll.dll!EtwNotificationUnregister() mysqld.exe!timer_callback()[threadpool_win.cc:419] ntdll.dll!RtlIsCriticalSectionLockedByThread() ntdll.dll!RtlSizeHeap() kernel32.dll!BaseThreadInitThunk() ntdll.dll!RtlInitializeExceptionChain() ntdll.dll!RtlInitializeExceptionChain() The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2019-07-29 23:18:21 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2019-07-29 23:18:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2019-07-29 23:18:21 0 [Note] InnoDB: Uses event mutexes 2019-07-29 23:18:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-07-29 23:18:21 0 [Note] InnoDB: Number of pools: 1 2019-07-29 23:18:21 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-29 23:18:21 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M 2019-07-29 23:18:21 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-29 23:18:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=150962067982 2019-07-29 23:18:22 0 [Note] InnoDB: Transaction 294057132 was in the XA prepared state. 2019-07-29 23:18:22 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-07-29 23:18:22 0 [Note] InnoDB: Trx id counter is 294057133 2019-07-29 23:18:22 0 [Note] InnoDB: Starting final batch to recover 18 pages from redo log. 2019-07-29 23:18:22 0 [Note] InnoDB: Last binlog file 'd:\MariaDB\master\logbin\Master-bin.000615', position 146245658 2019-07-29 23:18:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-29 23:18:26 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-07-29 23:18:26 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-07-29 23:18:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-07-29 23:18:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-29 23:18:26 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-29 23:18:26 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2019-07-29 23:18:26 0 [Note] InnoDB: 10.3.12 started; log sequence number 150962117583; transaction id 294057135 2019-07-29 23:18:26 0 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool 2019-07-29 23:18:26 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-29 23:18:26 0 [Note] Recovering after a crash using d:/MariaDB/master/logbin/Master-bin 2019-07-29 23:18:35 0 [Note] InnoDB: Buffer pool(s) load completed at 190729 23:18:35 2019-07-29 23:18:44 0 [Note] Starting crash recovery... 2019-07-29 23:18:44 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-07-29 23:18:44 0 [Note] InnoDB: Transaction 294057132 in prepared state after recovery 2019-07-29 23:18:44 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-07-29 23:18:44 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-07-29 23:18:44 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-07-29 23:18:44 0 [Note] Crash recovery finished. 2019-07-29 23:18:44 0 [Note] Server socket created on IP: '::'. 2019-07-29 23:18:44 0 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode. 2019-07-29 23:18:44 0 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode. 2019-07-29 23:18:44 0 [Note] Reading of all Master_info entries succeded 2019-07-29 23:18:44 0 [Note] Added new Master_info '' to hash table 2019-07-29 23:18:44 0 [Note] D:\MariaDB\bin\mysqld.exe: ready for connections. Version: '10.3.12-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution 2019-07-29 23:19:23 81 [Note] Start binlog_dump to slave_server(2), pos(Master-bin.000615, 146246161) 2019-07-29 23:19:52 90 [Warning] Access denied for user 'root'@'127.0.0.1' (using password: YES) 2019-07-29 23:24:11 0 [Note] D:\MariaDB\bin\mysqld.exe (initiated by: unknown): Normal shutdown 2019-07-29 23:24:11 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-07-29 23:24:11 0 [Note] InnoDB: FTS optimize thread exiting. 2019-07-29 23:24:11 0 [Note] InnoDB: Starting shutdown... 2019-07-29 23:24:11 0 [Note] InnoDB: Dumping buffer pool(s) to D:\MariaDB\data\ib_buffer_pool 2019-07-29 23:24:11 0 [Note] InnoDB: Instance 0, restricted to 6144 pages due to innodb_buf_pool_dump_pct=25 2019-07-29 23:24:11 0 [Note] InnoDB: Buffer pool(s) dump completed at 190729 23:24:11 2019-07-29 23:24:12 0 [Note] InnoDB: Shutdown completed; log sequence number 150964259475; transaction id 294063316 2019-07-29 23:24:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-07-29 23:24:12 0 [Note] D:\MariaDB\bin\mysqld.exe: Shutdown complete 2019-07-29 23:24:16 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2019-07-29 23:24:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2019-07-29 23:24:16 0 [Note] InnoDB: Uses event mutexes 2019-07-29 23:24:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-07-29 23:24:16 0 [Note] InnoDB: Number of pools: 1 2019-07-29 23:24:16 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-29 23:24:16 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M 2019-07-29 23:24:16 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-29 23:24:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-29 23:24:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-29 23:24:16 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-29 23:24:16 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2019-07-29 23:24:16 0 [Note] InnoDB: 10.3.12 started; log sequence number 150964259475; transaction id 294063318 2019-07-29 23:24:16 0 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool 2019-07-29 23:24:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-29 23:24:16 0 [Note] Server socket created on IP: '::'. 2019-07-29 23:24:16 0 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode. 2019-07-29 23:24:16 0 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode. 2019-07-29 23:24:16 0 [Note] Reading of all Master_info entries succeded 2019-07-29 23:24:16 0 [Note] Added new Master_info '' to hash table 2019-07-29 23:24:16 0 [Note] D:\MariaDB\bin\mysqld.exe: ready for connections. Version: '10.3.12-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution 2019-07-29 23:24:31 0 [Note] InnoDB: Buffer pool(s) load completed at 190729 23:24:31 2019-07-29 23:25:12 65 [Note] Start binlog_dump to slave_server(2), pos(Master-bin.000616, 1808629) 2019-07-29 23:37:53 251 [Warning] Access denied for user 'zzdomainadmin'@'127.0.0.1' (using password: NO) at 23:15:11 the following appeared in the application event log on the server Faulting application mysqld.exe, version 10.3.12.0, time stamp 0x5c2f7f3f, faulting module ntdll.dll, version 6.0.6003.20562, time stamp 0x5cfa798d, exception code 0xc000000d, fault offset 0x00087471, process id 0x124, application start time 0x01d545acd61aec10. There appears to be no hardware issue (it is running on a Virtual Machine under vmware ESXi), and all other VMs and other processes are ok; no ballooning memory; it had plenty of memory available etc... The DB does run in Binlog mode and has a standby DB I have done a mysqlcheck --all-databases and all appears to be ok Can you urgently help please? Is this a known bug and is it fixed in a later version of MariaDB and if so which version please? Sorry for all the questions, I am panicking a great deal. |
Experienced a crash of our primary MariaDB DB this evening at 23:15 , please can you help?
from the MariaDB log file the crash details are:- {noformat} 190729 23:15:10 [ERROR] mysqld got exception 0xc000000d ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.3.12-MariaDB-log key_buffer_size=8388608 read_buffer_size=36864 max_used_connections=266 max_threads=65537 thread_count=270 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2381676 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... ntdll.dll!EtwNotificationUnregister() mysqld.exe!timer_callback()[threadpool_win.cc:419] ntdll.dll!RtlIsCriticalSectionLockedByThread() ntdll.dll!RtlSizeHeap() kernel32.dll!BaseThreadInitThunk() ntdll.dll!RtlInitializeExceptionChain() ntdll.dll!RtlInitializeExceptionChain() The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 2019-07-29 23:18:21 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2019-07-29 23:18:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2019-07-29 23:18:21 0 [Note] InnoDB: Uses event mutexes 2019-07-29 23:18:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-07-29 23:18:21 0 [Note] InnoDB: Number of pools: 1 2019-07-29 23:18:21 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-29 23:18:21 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M 2019-07-29 23:18:21 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-29 23:18:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=150962067982 2019-07-29 23:18:22 0 [Note] InnoDB: Transaction 294057132 was in the XA prepared state. 2019-07-29 23:18:22 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2019-07-29 23:18:22 0 [Note] InnoDB: Trx id counter is 294057133 2019-07-29 23:18:22 0 [Note] InnoDB: Starting final batch to recover 18 pages from redo log. 2019-07-29 23:18:22 0 [Note] InnoDB: Last binlog file 'd:\MariaDB\master\logbin\Master-bin.000615', position 146245658 2019-07-29 23:18:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-29 23:18:26 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2019-07-29 23:18:26 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2019-07-29 23:18:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-07-29 23:18:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-29 23:18:26 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-29 23:18:26 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2019-07-29 23:18:26 0 [Note] InnoDB: 10.3.12 started; log sequence number 150962117583; transaction id 294057135 2019-07-29 23:18:26 0 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool 2019-07-29 23:18:26 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-29 23:18:26 0 [Note] Recovering after a crash using d:/MariaDB/master/logbin/Master-bin 2019-07-29 23:18:35 0 [Note] InnoDB: Buffer pool(s) load completed at 190729 23:18:35 2019-07-29 23:18:44 0 [Note] Starting crash recovery... 2019-07-29 23:18:44 0 [Note] InnoDB: Starting recovery for XA transactions... 2019-07-29 23:18:44 0 [Note] InnoDB: Transaction 294057132 in prepared state after recovery 2019-07-29 23:18:44 0 [Note] InnoDB: Transaction contains changes to 1 rows 2019-07-29 23:18:44 0 [Note] InnoDB: 1 transactions in prepared state after recovery 2019-07-29 23:18:44 0 [Note] Found 1 prepared transaction(s) in InnoDB 2019-07-29 23:18:44 0 [Note] Crash recovery finished. 2019-07-29 23:18:44 0 [Note] Server socket created on IP: '::'. 2019-07-29 23:18:44 0 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode. 2019-07-29 23:18:44 0 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode. 2019-07-29 23:18:44 0 [Note] Reading of all Master_info entries succeded 2019-07-29 23:18:44 0 [Note] Added new Master_info '' to hash table 2019-07-29 23:18:44 0 [Note] D:\MariaDB\bin\mysqld.exe: ready for connections. Version: '10.3.12-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution 2019-07-29 23:19:23 81 [Note] Start binlog_dump to slave_server(2), pos(Master-bin.000615, 146246161) 2019-07-29 23:19:52 90 [Warning] Access denied for user 'root'@'127.0.0.1' (using password: YES) 2019-07-29 23:24:11 0 [Note] D:\MariaDB\bin\mysqld.exe (initiated by: unknown): Normal shutdown 2019-07-29 23:24:11 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-07-29 23:24:11 0 [Note] InnoDB: FTS optimize thread exiting. 2019-07-29 23:24:11 0 [Note] InnoDB: Starting shutdown... 2019-07-29 23:24:11 0 [Note] InnoDB: Dumping buffer pool(s) to D:\MariaDB\data\ib_buffer_pool 2019-07-29 23:24:11 0 [Note] InnoDB: Instance 0, restricted to 6144 pages due to innodb_buf_pool_dump_pct=25 2019-07-29 23:24:11 0 [Note] InnoDB: Buffer pool(s) dump completed at 190729 23:24:11 2019-07-29 23:24:12 0 [Note] InnoDB: Shutdown completed; log sequence number 150964259475; transaction id 294063316 2019-07-29 23:24:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-07-29 23:24:12 0 [Note] D:\MariaDB\bin\mysqld.exe: Shutdown complete 2019-07-29 23:24:16 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2019-07-29 23:24:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2019-07-29 23:24:16 0 [Note] InnoDB: Uses event mutexes 2019-07-29 23:24:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-07-29 23:24:16 0 [Note] InnoDB: Number of pools: 1 2019-07-29 23:24:16 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-07-29 23:24:16 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M 2019-07-29 23:24:16 0 [Note] InnoDB: Completed initialization of buffer pool 2019-07-29 23:24:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-07-29 23:24:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-07-29 23:24:16 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-07-29 23:24:16 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2019-07-29 23:24:16 0 [Note] InnoDB: 10.3.12 started; log sequence number 150964259475; transaction id 294063318 2019-07-29 23:24:16 0 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool 2019-07-29 23:24:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-07-29 23:24:16 0 [Note] Server socket created on IP: '::'. 2019-07-29 23:24:16 0 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode. 2019-07-29 23:24:16 0 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode. 2019-07-29 23:24:16 0 [Note] Reading of all Master_info entries succeded 2019-07-29 23:24:16 0 [Note] Added new Master_info '' to hash table 2019-07-29 23:24:16 0 [Note] D:\MariaDB\bin\mysqld.exe: ready for connections. Version: '10.3.12-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution 2019-07-29 23:24:31 0 [Note] InnoDB: Buffer pool(s) load completed at 190729 23:24:31 2019-07-29 23:25:12 65 [Note] Start binlog_dump to slave_server(2), pos(Master-bin.000616, 1808629) 2019-07-29 23:37:53 251 [Warning] Access denied for user 'zzdomainadmin'@'127.0.0.1' (using password: NO) {noformat} at 23:15:11 the following appeared in the application event log on the server {noformat} Faulting application mysqld.exe, version 10.3.12.0, time stamp 0x5c2f7f3f, faulting module ntdll.dll, version 6.0.6003.20562, time stamp 0x5cfa798d, exception code 0xc000000d, fault offset 0x00087471, process id 0x124, application start time 0x01d545acd61aec10. {noformat} There appears to be no hardware issue (it is running on a Virtual Machine under vmware ESXi), and all other VMs and other processes are ok; no ballooning memory; it had plenty of memory available etc... The DB does run in Binlog mode and has a standby DB I have done a mysqlcheck --all-databases and all appears to be ok Can you urgently help please? Is this a known bug and is it fixed in a later version of MariaDB and if so which version please? Sorry for all the questions, I am panicking a great deal. |
| Assignee | Oleksandr Byelkin [ sanja ] | Vladislav Vaintroub [ wlad ] |
I'm wondering if this would be possible for you to collect WER crash dumps, and send one if something like this happens again.
exception 0xc000000d is STATUS_INVALID_PARAMETER
timer_callback() that is in your stacktrace is called when idle timeout expires on connection, i.e usually every 8 hours for every connection
The function that crashes (i.e contains invalid parameters) seems to be SetThreadpoolTimer(timer, (PFILETIME)&c->timeout, 0, 1000); which is called when timeout is reset. I do not get yet, how there can be an invalid parameter.
| Labels | need_feedback |
Hmm, I think I know what it could be
The documentation https://docs.microsoft.com/en-us/windows/win32/api/threadpoolapiset/nf-threadpoolapiset-closethreadpooltimer for CloseThreadpoolTimer says.
In some cases, callback functions might run after CloseThreadpoolTimer has been called. To prevent this behavior:
|
1.Call the SetThreadpoolTimer function with the pftDueTime parameter set to NULL and the msPeriod and msWindowLength parameters set to 0.
|
2.Call the WaitForThreadpoolTimerCallbacks function.
|
3.Call CloseThreadpoolTimer.
|
I guess, we hit "some cases" mentioned here. As we're missing 1. , starting with 10.2
| Labels | need_feedback |
Hi Vladislav, many thanks for your investigation and update to the Jira.
Is there a likelyhood of a fix now that you think it could be fixed?
I will enable WER on server where the crash happened so I can gather a dump should it occur again.
| issue.field.resolutiondate | 2019-09-09 11:54:24.0 | 2019-09-09 11:54:24.248 |
| Fix Version/s | 10.2.28 [ 23910 ] | |
| Fix Version/s | 10.3.19 [ 23908 ] | |
| Fix Version/s | 10.4.9 [ 23906 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
We have had a further occurrence of this entire Crash in our production data factory environment this evening; i believe this is the same issue.
I know this is fixed in 10.3.19;
is there any chance of getting this fix early for Windows 32bit please?
as i don't have access to compile it myself, and what i am after is the fix in the usual win32bit zip file format please? as I don't think we can wait 5 weeks+ before release 10.3.19 is released given this 2nd occurrence of the crash.
many thanks for your help
This evenings crash details are:-
190911 21:48:34 [ERROR] mysqld got exception 0xc000000d ; |
This could be because you hit a bug. It is also possible that this binary |
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs |
|
|
We will try our best to scrape up some info that will hopefully help |
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail. |
|
|
Server version: 10.3.12-MariaDB-log |
key_buffer_size=8388608 |
read_buffer_size=36864 |
max_used_connections=341 |
max_threads=65537 |
thread_count=307 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2381676 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
|
|
Thread pointer: 0x0 |
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went |
terribly wrong...
|
ntdll.dll!EtwNotificationUnregister()
|
mysqld.exe!timer_callback()[threadpool_win.cc:419] |
ntdll.dll!RtlIsCriticalSectionLockedByThread()
|
ntdll.dll!RtlSizeHeap()
|
kernel32.dll!BaseThreadInitThunk()
|
ntdll.dll!RtlInitializeExceptionChain()
|
ntdll.dll!RtlInitializeExceptionChain()
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains |
information that should help you find out what is causing the crash.
|
2019-09-11 21:51:27 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB |
2019-09-11 21:51:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions |
2019-09-11 21:51:27 0 [Note] InnoDB: Uses event mutexes |
2019-09-11 21:51:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 |
2019-09-11 21:51:27 0 [Note] InnoDB: Number of pools: 1 |
2019-09-11 21:51:27 0 [Note] InnoDB: Using SSE2 crc32 instructions |
2019-09-11 21:51:27 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M |
2019-09-11 21:51:27 0 [Note] InnoDB: Completed initialization of buffer pool |
2019-09-11 21:51:27 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=171950051107 |
2019-09-11 21:51:27 0 [Note] InnoDB: Transaction 334783073 was in the XA prepared state. |
2019-09-11 21:51:27 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo |
2019-09-11 21:51:27 0 [Note] InnoDB: Trx id counter is 334783074 |
2019-09-11 21:51:27 0 [Note] InnoDB: Starting final batch to recover 13 pages from redo log. |
2019-09-11 21:51:28 0 [Note] InnoDB: Last binlog file 'd:\MariaDB\master\logbin\Master-bin.000704', position 537903 |
2019-09-11 21:51:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active. |
2019-09-11 21:51:32 0 [Note] InnoDB: Starting in background the rollback of recovered transactions |
2019-09-11 21:51:32 0 [Note] InnoDB: Rollback of non-prepared transactions completed |
2019-09-11 21:51:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" |
2019-09-11 21:51:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables |
2019-09-11 21:51:32 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... |
2019-09-11 21:51:32 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. |
2019-09-11 21:51:32 0 [Note] InnoDB: 10.3.12 started; log sequence number 171950074662; transaction id 334783076 |
2019-09-11 21:51:32 0 [Note] InnoDB: Loading buffer pool(s) from D:\MariaDB\data\ib_buffer_pool |
2019-09-11 21:51:32 0 [Note] Plugin 'FEEDBACK' is disabled. |
2019-09-11 21:51:32 0 [Note] Recovering after a crash using d:/MariaDB/master/logbin/Master-bin |
2019-09-11 21:51:32 0 [Note] Starting crash recovery... |
2019-09-11 21:51:32 0 [Note] InnoDB: Starting recovery for XA transactions... |
2019-09-11 21:51:32 0 [Note] InnoDB: Transaction 334783073 in prepared state after recovery |
2019-09-11 21:51:32 0 [Note] InnoDB: Transaction contains changes to 1 rows |
2019-09-11 21:51:32 0 [Note] InnoDB: 1 transactions in prepared state after recovery |
2019-09-11 21:51:32 0 [Note] Found 1 prepared transaction(s) in InnoDB |
2019-09-11 21:51:32 0 [Note] Crash recovery finished. |
2019-09-11 21:51:32 0 [Note] Server socket created on IP: '::'. |
2019-09-11 21:51:32 0 [Warning] 'user' entry 'root@jpdpt3' ignored in --skip-name-resolve mode. |
2019-09-11 21:51:32 0 [Warning] 'proxies_priv' entry '@% root@jpdpt3' ignored in --skip-name-resolve mode. |
2019-09-11 21:51:32 0 [Note] Reading of all Master_info entries succeded |
2019-09-11 21:51:32 0 [Note] Added new Master_info '' to hash table |
2019-09-11 21:51:32 0 [Note] D:\MariaDB\bin\mysqld.exe: ready for connections. |
Version: '10.3.12-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution |
2019-09-11 21:51:46 83 [Note] Start binlog_dump to slave_server(2), pos(Master-bin.000704, 538405) |
2019-09-11 21:51:47 0 [Note] InnoDB: Buffer pool(s) load completed at 190911 21:51:47 |
|
slaterss Can you explain "you do not have access to compile yourself", please?
You should be able to
git clone https://github.com/mariadb/server -b 10.3
All software that is needed to setup build environment listed in https://mariadb.com/kb/en/library/Building_MariaDB_on_Windows/ , is free as well.
Thank you for your prompt reply;
unfortunately we are not able to install Compiler related s/w in our organisation unless it is on the approved list and done by our Corporate IT department.
Perl strawberry or activestate is not allowed.
Sorry; i guess i could try and do the build at home on my home PC; but just wondering if there is a nightly build i can be given access to such as mariadb-10.3.19-win32.zip ?
Yes, there is a build , I copied it to https://1drv.ms/u/s!AqT4tBcElQz_j4xBXKT7E_T5Dhr5iA?e=F82nEU
Perl is only needed for running the test suite, the build itself does not depend on it. I guess a portable version of Strawberry Perl might work for you, if installs are prohibited.
That is very helpful; really appreciate all your help and understanding.
I can't seem to access the URL
https://1drv.ms/u/s!AqT4tBcElQz_j4xBXKT7E_T5Dhr5iA?e=F82nEU
it comes back with this site cannot be reached?
It is OneDrive link, shared with everyone.
Here is a google drive link, shared with everyone as well https://drive.google.com/file/d/1h_R2RHGUU_vNkO7jIYSSdC-4cNZ9SiIh/view?usp=sharing
Brlliant, that worked a treat; I will put it on our Development environment and do some testing.
Sincere many thanks.
| Link | This issue relates to MDEV-20970 [ MDEV-20970 ] |
Hi, I see you have released 10.3.19 last night (5th November 2019)
However I cannot see that this MDEV-20206 in the change log; or the related one of MDEV-20970??
can you confirm that MDEV-20206 is fixed in 10.3.19 please?
Many thanks
This commit https://github.com/mariadb/server/commit/2336e0b3944b73379f9d773b4e1b37cbc723bce4 is tagged mariadb-10.4.9 mariadb-10.3.19 mariadb-10.2.28
So yes, it is in 10.3.19
but I'd suggest to hold your upgrades, 10.3.19 the release might need to be re-issued , because of https://jira.mariadb.org/browse/MDEV-20987
Many thanks for all your help on this; all is working perfect and been stable.
| Workflow | MariaDB v3 [ 98587 ] | MariaDB v4 [ 156547 ] |
Is it a recurring problem? Can you locate the query which caused it? Do you have a minidump from the crash?