Comments (2)
Looks like the function is designed to look for if the alter command is currently processing. Such as we add a column to the messages table, this may take a while (longer than timeout), then a timeout occurs, the script then runs again and we reach here telling it to not execute the command a second time. So it checks the process list to see if it can find the command running. If it can, it doesn't try to send it again.
mysql> SHOW FULL PROCESSLIST;
Id | User | Host | db | Command | Time | State | Info |
---|---|---|---|---|---|---|---|
5 | event_scheduler | localhost | NULL | Daemon | 1614649 | Waiting on empty queue | NULL |
1599695 | jeremy | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST |
2 rows in set (0.00 sec)
Seems that Info can be null. Best solution is to exclude it or ensure that we filter it by checking for Command <> 'Daemon' and User <> 'event_scheduler'
from smf.
Thanks, helpful. Sounds like a fix is easy.
from smf.
Related Issues (20)
- [2.1]: Notication emails for reply not sent if user also subscribe for the board HOT 2
- [3.0]: MariaDB doesn't have "REGEXP_LIKE" HOT 1
- [3.0]: Upgrade doesn't work HOT 2
- [3.0/2.1]: Installing packages/themes does not parse line breaks for the XML tags. HOT 1
- [3.0]: Upgrade breaks after backup due to User::$me not being initialized
- [3.0]: New columns not being added to tables HOT 1
- [3.0]: Calling pg_version() with default connection is depracated as of PHP 8.1
- [3.0] Installer needs General language file? HOT 17
- [3.0]: Error while adding holidays
- [3.0]: Adding calendar event can cause max_execution_time to be exceeded HOT 3
- [3.0]: No option to delete events
- [3.0]: Undefined variable $is_os HOT 11
- [3.0]: Installer does not provide minimum database version upon failure due to unsupported version. HOT 2
- [3.0]: Config::getTempDir() is defaulting to sys_get_temp_dir HOT 38
- [2.1 & 3.0]: PHP Fatal error: Uncaught Error: Interface "MatthiasMullie\PathConverter\ConverterInterface" not found HOT 2
- [3.0]: Installer - Line #1604: Field 'exdates' doesn't have a default value HOT 2
- [3.0]: Cannot send PM - "You have an error in your SQL syntax;"
- [3.0]: "You have an error in your SQL syntax" trying to update profile HOT 1
- [2.1 & 3.0]: Merged topic link is broken HOT 1
- [3.0]: Suggestion - consistent encoding HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from smf.