Make WordPress Core

Opened 4 weeks ago

Closed 4 weeks ago

#63570 closed defect (bug) (wontfix)

Adapt to MySQL tenant of OceanBase

Reported by: laochou's profile laochou Owned by:
Milestone: Priority: normal
Severity: normal Version: trunk
Component: Date/Time Keywords: has-patch
Focuses: Cc:

Description

Adapt to MySQL tenant of OceanBase(multiple table update/delete is not a good idea for the same table。)

Attachments (1)

error.png (180.4 KB) - added by laochou 4 weeks ago.
Adapt to MySQL tenant of OceanBase(multiple table update/delete is not a good idea for the same table。)

Download all attachments as: .zip

Change History (10)

@laochou
4 weeks ago

Adapt to MySQL tenant of OceanBase(multiple table update/delete is not a good idea for the same table。)

#1 @laochou
4 weeks ago

This error report occurs in delete_expired_transients

This ticket was mentioned in PR #8985 on WordPress/wordpress-develop by @laochou.


4 weeks ago
#2

  • Keywords has-patch added

Adapt to MySQL tenant of OceanBase(multiple table update/delete is not a good idea for the same table。)
This error report occurs in delete_expired_transients

Trac ticket: https://core.trac.wordpress.org/ticket/63570

https://github.com/user-attachments/assets/6ba0ca4e-4a63-4f59-b8f7-30b65507c0ae

This ticket was mentioned in PR #8986 on WordPress/wordpress-develop by @laochou.


4 weeks ago
#3

Adapt to MySQL tenant of OceanBase(multiple table update/delete is not a good idea for the same table。)
This error report occurs in delete_expired_transients

Trac ticket: https://core.trac.wordpress.org/ticket/63570
https://github.com/user-attachments/assets/9974d688-80ed-4ea4-af9e-9b53436dc3d8

This ticket was mentioned in PR #8987 on WordPress/wordpress-develop by @laochou.


4 weeks ago
#4

Adapt to MySQL tenant of OceanBase(multiple table update/delete is not a good idea for the same table。)
This error report occurs in delete_expired_transients

Trac ticket: https://core.trac.wordpress.org/ticket/63570
https://github.com/user-attachments/assets/41cec253-47c5-498e-a9d0-b2ff23549b25

@peterwilsoncc commented on PR #8987:


4 weeks ago
#5

@sc-source Please stop opening and closing identical pull requests. If you need to update your code you can do so without closing the pull requst.

@laochou commented on PR #8987:


4 weeks ago
#6

Props peterwilsoncc.

@laochou commented on PR #8987:


4 weeks ago
#7

Props peterwilsoncc.

@laochou commented on PR #8987:


4 weeks ago
#8

@sc-source Please stop opening and closing identical pull requests. If you need to update your code you can do so without closing the pull requst.

I'm very sorry for doing that.
Now, I have linked Accounts.

#9 @peterwilsoncc
4 weeks ago

  • Milestone Awaiting Review deleted
  • Resolution set to wontfix
  • Status changed from new to closed

@laochou OceanBase appears to be a commercial and, based on the version string, customized database service it's not appropriate to place specific code in to WordPress for this purpose.

The delete_expired_transients() function runs on an action of the same name. If users of this service need to modify how this function runs then a plugin can be created for the purpose. For more complex needs a custom database drop-in can be created.

If there are general benefits to this change then they can be considered for all WordPress installs.

Note: See TracTickets for help on using tickets.