=====================================
2017-07-06 13:56:08 7f2e10fff700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 20 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 11974 srv_active, 0 srv_shutdown, 97103 srv_idle
srv_master_thread log flush and writes: 109063
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 80670
--Thread 139835788470016 has waited at row0purge.cc line 770 for 948.00 seconds
the semaphore:
S-lock on RW-latch at 0x7f2e3cb7b100 '&dict_operation_lock'
a writer (thread id 139835763291904) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0purge.cc line 770
Last time write locked in file
/home/buildbot/buildbot/build/mariadb-10.1.22/storage/xtradb/dict/dict0stats.cc
line 2465
Holder thread 0 file not yet reserved line 0
--Thread 139835796862720 has waited at srv0srv.cc line 2828 for 948.00 seconds
the semaphore:
X-lock on RW-latch at 0x7f2e3cb7b100 '&dict_operation_lock'
a writer (thread id 139835763291904) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0purge.cc line 770
Last time write locked in file
/home/buildbot/buildbot/build/mariadb-10.1.22/storage/xtradb/dict/dict0stats.cc
line 2465
Holder thread 0 file not yet reserved line 0
--Thread 139836543101696 has waited at dict0dict.cc line 1172 for 945.00
seconds the semaphore:
Mutex at 0x7f2e37c23b68 '&dict_sys->mutex', lock var 1
Last time reserved by thread 139835763291904 in file not yet reserved line 0,
waiters flag 1
--Thread 139836492897024 has waited at row0mysql.cc line 1777 for 796.00
seconds the semaphore:
S-lock on RW-latch at 0x7f2e3cb7b100 '&dict_operation_lock'
a writer (thread id 139835763291904) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0purge.cc line 770
Last time write locked in file
/home/buildbot/buildbot/build/mariadb-10.1.22/storage/xtradb/dict/dict0stats.cc
line 2465
Holder thread 0 file not yet reserved line 0
OS WAIT ARRAY INFO: signal count 73839
Mutex spin waits 72637, rounds 1934887, OS waits 58180
RW-shared spins 22134, rounds 660553, OS waits 21968
RW-excl spins 236, rounds 8984, OS waits 295
Spin rounds per wait: 26.64 mutex, 29.84 RW-shared, 38.07 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 73300
Purge done for trx's n:o < 73120 undo n:o < 0 state: running
History list length 5
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 73299, not started
MySQL thread id 478, OS thread handle 0x7f2e3852bb00, query id 570023
172.17.0.2 root Waiting for query cache lock
SELECT 1
---TRANSACTION 73116, not started flushing log
MySQL thread id 472, OS thread handle 0x7f2e3b75cb00, query id 566926
172.17.0.2 root init
commit
---TRANSACTION 73111, not started
mysql tables in use 1, locked 0
MySQL thread id 471, OS thread handle 0x7f2e3b7a6b00, query id 566947
172.17.0.2 root
SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM
FN_QZ_TRIGGERS WHERE SCHED_NAME = 'Scheduler_20170705_one' AND TRIGGER_STATE =
'WAITING' AND NEXT_FIRE_TIME <= 1499348453295 AND (MISFIRE_INSTR = -1 OR
(MISFIRE_INSTR != -1 AND NEXT_FIRE_TIME >= 1499348363295)) ORDER BY
NEXT_FIRE_TIME ASC, PRIORITY DESC
---TRANSACTION 11523, not started
MySQL thread id 1, OS thread handle 0x7f2e3c910b00, query id 0 Waiting for
requests
---TRANSACTION 73150, ACTIVE 796 sec updating or deleting
mysql tables in use 1, locked 1
4 lock struct(s), heap size 1184, 2 row lock(s)
MySQL thread id 475, OS thread handle 0x7f2e387c5b00, query id 567500
172.17.0.2 root updating
UPDATE FN_QZ_TRIGGERS SET JOB_NAME = 'LogJob', JOB_GROUP = 'AppGroup',
DESCRIPTION = null, NEXT_FIRE_TIME = 1499348572377, PREV_FIRE_TIME =
1499348400000, TRIGGER_STATE = 'WAITING', TRIGGER_TYPE = 'CRON', START_TIME =
1499239247000, END_TIME = 0, CALENDAR_NAME = null, MISFIRE_INSTR = 0, PRIORITY
= 0 WHERE SCHED_NAME = 'Scheduler_20170705_one' AND TRIGGER_NAME = 'LogTrigger'
AND TRIGGER_GROUP = 'AppGroup'
Trx read view will not see trx with id >= 73151, sees < 73151
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 1; buffer pool: 0
1328 OS file reads, 274888 OS file writes, 91574 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
0.20 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 197877795
Log flushed up to 197877122
Pages flushed up to 197877122
Last checkpoint at 197877122
Max checkpoint age 80826164
Checkpoint age target 78300347
Modified age 673
Checkpoint age 673
1 pending log writes, 0 pending chkp writes
39529 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 281149440; in additional pool allocated 0
Total memory allocated by read views 600
Internal hash tables (constant factor + variable factor)
Adaptive hash index 4479184 (4425832 + 53352)
Page hash 277432 (buffer pool 0 only)
Dictionary cache 1787720 (1107952 + 679768)
File system 1035560 (812272 + 223288)
Lock system 667560 (664936 + 2624)
Recovery system 0 (0 + 0)
Dictionary memory allocated 679768
Buffer pool size 16383
Buffer pool size, bytes 268419072
Free buffers 15477
Database pages 903
Old database pages 353
Modified db pages 7
Percent of dirty pages(LRU & free pages): 0.043
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 2, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 828, created 75, written 223042
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 903, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
1 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
1 out of 1000 descriptors used
---OLDEST VIEW---
Normal read view
Read view low limit trx n:o 73151
Read view up limit trx id 73151
Read view low limit trx id 73151
Read view individually stored trx ids:
-----------------
Main thread process no. 1, id 139835796862720, state: enforcing dict cache limit
Number of rows inserted 2512, updated 18590, deleted 2256, read 102587
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.20 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Error: semaphore wait has lasted > 600 seconds
InnoDB: We intentionally crash the server, because it appears to be hung.
2017-07-06 13:56:13 7f2e0f7fc700 InnoDB: Assertion failure in thread
139835805255424 in file srv0srv.cc line 2402
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
170706 13:56:13 [ERROR] mysqld got signal 6 ;
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.1.22-MariaDB-1~jessie
key_buffer_size=134217728
read_buffer_size=2097152
max_used_connections=19
max_threads=102
thread_count=4
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 759834 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...
stack_bottom = 0x0 thread_stack 0x48400
mysqld(my_print_stacktrace+0x2e)[0x7f2e3c2f63ee]
mysqld(handle_fatal_signal+0x2fd)[0x7f2e3be3041d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7f2e3b458890]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f2e39548067]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f2e39549448]
mysqld(+0x7eada6)[0x7f2e3c073da6]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8064)[0x7f2e3b451064]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f2e395fb62d]
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.
Fatal signal 11 while backtracing
Regards,
Ajay
"Confidentiality Warning: This message and any attachments are intended only
for the use of the intended recipient(s).
are confidential and may be privileged. If you are not the intended recipient.
you are hereby notified that any
review. re-transmission. conversion to hard copy. copying. circulation or other
use of this message and any attachments is
strictly prohibited. If you are not the intended recipient. please notify the
sender immediately by return email.
and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure
no viruses are present in this email.
The company cannot accept responsibility for any loss or damage arising from
the use of this email or attachment."
_______________________________________________
onap-discuss mailing list
[email protected]
https://lists.onap.org/mailman/listinfo/onap-discuss
