[MDEV-16046] All query hangs in processlist - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Incomplete
Affects Version/s: 10.0.27
Fix Version/s: N/A
Component/s: Storage Engine - InnoDB
Labels:
- need_feedback
Environment:
centos6.8 x86_64,

Description

Suddenly, all queries hang on mariadb, and can not execute normally.

Attachments contains stack, processlist, err log, innodb status.

From engine innodb status:

We got the following information:

Dictionary memory allocated 11142855

Buffer pool size        1441791

Buffer pool size, bytes 23622303744

Free buffers            0

Database pages          1302517

Old database pages      480825

Modified db pages       81780

Percent of dirty pages(LRU & free pages): 6.279

Max dirty pages percent: 75.000

Pending reads 102

Free buffers 0, is it normally?

And from the stack, many threads hang on select function.

Is this a bug?

Attachments

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

iostat.jpeg
2018-04-27 14:20
138 kB
louis hust
my3309.cnf
2018-04-27 14:13
2 kB
louis hust
processlist0.jpeg
2018-04-27 14:20
152 kB
louis hust
processlist1.jpeg
2018-04-27 14:20
181 kB
louis hust
processlist2.jpeg
2018-04-27 14:20
122 kB
louis hust
processlist3.jpeg
2018-04-27 14:20
181 kB
louis hust
SGRDB-mysql01.err
2018-04-27 14:13
187 kB
louis hust
show_engine_innodb.txt
2018-04-27 14:13
40 kB
louis hust
show_status.txt
2018-04-27 14:13
36 kB
louis hust
stack
2018-04-27 14:14
123 kB
louis hust

Activity

People

Assignee:: Unassigned

Reporter:: louis hust

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2018-04-27 14:21

Updated:: 2019-02-17 15:00

Resolved:: 2019-02-17 15:00

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.