[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Manoj Iyer]

** Changed in: mysql-5.7 (Ubuntu)
   Status: Incomplete => Won't Fix

** Changed in: mysql-5.6 (Ubuntu)
   Status: Incomplete => Won't Fix

** Changed in: ubuntu-power-systems
   Status: Incomplete => Won't Fix

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Manoj Iyer]

** Changed in: ubuntu-power-systems
 Assignee: David Britton (davidpbritton) => Canonical Server Team 
(canonical-server)

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Andrew Cloke]

** Tags removed: triage-r
** Tags added: triage-a

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Daniel Black]

I haven't managed to reproduce however I see no reason why the bug would
of gone away from the code changes made since the mysql versions Daniel
Axtens used when https://bugs.mysql.com/bug.php?id=80436 was written.
I'm just going to keep trying.

I see [~racb] was trying to bundle this patch with bug #1706291 however
from a logical point of view this is an independent bug.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Manoj Iyer]

Daniel, any updates on this bug? I believe this is blocking bug #1706291

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Daniel Black]

apologies for the delay. still trying to get a test case. I'll continue
looking next week.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[David Britton]

Hello --

1) Where are you observing this failure?  16.04?

2) It would be a bit premature to commit anything into Ubuntu without
acknowledgement from upstream on this patch (against MariaDB) and if it
is an acceptable change in Mysql.  After that, we would want it
committed to the dev release, then an SRU could be requested against
Xenial (16.04).


** Changed in: ubuntu-power-systems
   Status: New => Incomplete

** Changed in: mysql-5.6 (Ubuntu)
   Status: New => Incomplete

** Changed in: mysql-5.7 (Ubuntu)
   Status: New => Incomplete

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Manoj Iyer]

** Tags removed: triage-a
** Tags added: triage-r

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Manoj Iyer]

** Tags removed: triage-g
** Tags added: triage-a

** Changed in: ubuntu-power-systems
 Assignee: Canonical Server Team (canonical-server) => David Britton 
(davidpbritton)

** Changed in: mysql-5.6 (Ubuntu)
 Assignee: (unassigned) => David Britton (davidpbritton)

** Changed in: mysql-5.7 (Ubuntu)
 Assignee: Ubuntu on IBM Power Systems Bug Triage (ubuntu-power-triage) => 
David Britton (davidpbritton)

** Changed in: mysql-5.6 (Ubuntu)
   Importance: Undecided => High

** Changed in: mysql-5.7 (Ubuntu)
   Importance: Undecided => High

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[bin tang]

bugproxy，您好，请问如何向您请教问题呀，谢谢！

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Daniel Black]

Previous "Clarification from upstream" is a different bug.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Manoj Iyer]

** Tags added: triage-g

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Frank Heimes]

Clarification from upstream:
https://github.com/mysql/mysql-server/pull/80#issuecomment-317872906

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Andreas Hasenack]

** Bug watch added: MySQL Bug System #80436
   http://bugs.mysql.com/bug.php?id=80436

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=80436
   Importance: Unknown
   Status: Unknown

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Andreas Hasenack]

** Bug watch added: MySQL Bug System #80436
   http://bugs.mysql.com/bug.php?id=80436

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=80436
   Importance: Unknown
   Status: Unknown

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.7 in Ubuntu.
Matching subscriptions: main
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1706281/+subscriptions

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Daniel Black]

** Also affects: mysql-5.6 (Ubuntu)
   Importance: Undecided
   Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu-power-systems/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Daniel Black]

** Package changed: dbf2mysql (Ubuntu) => mysql-5.7 (Ubuntu)

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu-power-systems/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[David Britton]

** Description changed:

- == Comment: #0 - Daniel Black  - 2017-07-24 18:53:29 ==
  ---Problem Description---
-  
- Contact Information = Daniel Black (daniel.bl...@au1.ibm.com), Daniel Axtens 
(Canonical) 
-  
+ 
+ per upstream bug https://bugs.mysql.com/bug.php?id=80436 MySQL-5.7 can
+ assert on ppc64/ppc64le (and probably ARM64) because load order between
+ "recursive" and "writer_thread" wasn't properly enforced.
+ 
+ Upstream bug report has a patch (originally from MariaDB) that corrects
+ the problem.
+ 
  ---uname output---
  Linux p87 4.4.0-62-generic #83-Ubuntu SMP Wed Jan 18 14:09:19 UTC 2017 
ppc64le ppc64le ppc64le GNU/Linux
-  
- Machine Type = Any P8 
-  
+ 
+ Machine Type = Any P8
+ 
  ---Steps to Reproduce---
  Install MySQL-5.6 or 5.7
  
  Perform lots of concurrent innodb operations on Power hardware.
  
- A per upstream bug https://bugs.mysql.com/bug.php?id=80436 MySQL-5.7 can
- assert on ppc64/ppc64le (and probably ARM64) because load order between
- "recursive" and "writer_thread" wasn't properly enforced.
  
- Upstream bug report has a patch (originally from MariaDB) that corrects
- the problem.
+ Contact Information = Daniel Black (daniel.bl...@au1.ibm.com), Daniel Axtens 
(Canonical)

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu-power-systems/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

[Bug 1706281] Re: MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc during high load on PPC64

[Andrew Cloke]

** Also affects: ubuntu-power-systems
   Importance: Undecided
   Status: New

** Changed in: ubuntu-power-systems
   Importance: Undecided => High

** Changed in: ubuntu-power-systems
 Assignee: (unassigned) => Canonical Server Team (canonical-server)

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1706281

Title:
  MySQL-5.6/5.7 innodb assertion !lock->recursive assert in sync0rw.cc
  during high load on PPC64

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu-power-systems/+bug/1706281/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs