Comments (10)
Exact version: mycheckpoint rev 208, build 201011041330.
Original comment by [email protected]
on 31 Aug 2011 at 1:36
from mycheckpoint.
I filed this as a feature request, but the reason for writing the patch was a
processlist overloaded with mycheckpoints hanging on (local) monitored db not
being ready.
Original comment by [email protected]
on 31 Aug 2011 at 1:43
from mycheckpoint.
Thank you, good patch. Will incorporate.
Can you please first elaborate on implied bug, where mycheckpoint hangs on db
not being ready? In what sense "not being ready"?
I would file this as a separate bug, if possible.
Original comment by [email protected]
on 21 Sep 2011 at 8:23
- Changed state: Accepted
from mycheckpoint.
Will need to allow for multiple instances of mycheckpoint if directed at
different servers.
Can you offer such patch (i.e. locking on a different file other than the
executable)? Otherwise I'll find a solution, but will take me some time.
Original comment by [email protected]
on 21 Sep 2011 at 9:05
from mycheckpoint.
Locking on the script itself has as benefit that the lock is released on end of
(premature) execution.
When locking to an external file, the file needs to exist and one needs the
remove the lock-file when the program ends. If the program crashed in a
previous run, one needs to remove the old lock-file at start-up.
In my opinion, if running the program from a central server is the
default/preferred, the best solution would be to make run-once optional using a
command line var to turn it on.
But if the default/preferred is to run it from multiple servers to a central db
(thus logging system i/o etc.), it should be a command line var to switch
run-once off.
I will have a look into the code (latest rev.) later today, to see if it is
easy to detect if the script is checking a local or remote db and switch
run-once off auto if it is checking remote.
Original comment by [email protected]
on 21 Sep 2011 at 9:29
from mycheckpoint.
"When locking to an external file, the file needs to exist and one needs the
remove the lock-file when the program ends. If the program crashed in a
previous run, one needs to remove the old lock-file at start-up."
One could consider using a permanent file for each target host and just use the
lock attempt on that file. This would require some code to create a filename
with the name/ip of the target host, if the file doesn't exist.
Will look into that aswell...
Original comment by [email protected]
on 21 Sep 2011 at 9:33
from mycheckpoint.
To check whether the script is using remote or local monitoring, compare host
with monitored_host
Original comment by [email protected]
on 21 Sep 2011 at 9:34
from mycheckpoint.
[deleted comment]
from mycheckpoint.
Here's a patch comparing the ip-address of the monitored host with the
ip-address of the fqdn of the executing host. This seems te work correctly if
one is using ip, hostname or fqdn as the monitored_host parameter.
Will submit patch for seperate lock-file per monitored host shortly...
Original comment by [email protected]
on 21 Sep 2011 at 12:40
Attachments:
from mycheckpoint.
And here's a patch creating 1 lock file per monitored host (even if it's local,
keeps code cleaner).
It will create the lock files in /tmp:
-rw-r--r-- 1 root root 0 Sep 21 14:47 mycheckpoint.192.168.23.77.lck
Looking at both patches I'd prefer this one, because code-wise it is
cleaner/simpler.
(Still don't like external files/pipes/sockets as means of locking, but in this
case...)
Original comment by [email protected]
on 21 Sep 2011 at 1:08
Attachments:
from mycheckpoint.
Related Issues (20)
- AttributeError: 'array.array' object has no attribute 'replace' HOT 2
- custom_query.custom_query_id should be an auto increment HOT 1
- creating custom charts of multiple metrics
- Support disabling of OS graphs
- TypeError: expected a character buffer object HOT 1
- Will not work with MariaDB HOT 10
- Tbale isn't created HOT 32
- ONLY_FULL_GROUP_BY in sql_mode MySql option HOT 1
- Graph are not present in reports HOT 5
- Export parameter change tracking as html code
- sv_diff returns zero rows HOT 2
- no Charts HOT 2
- disable-bin-log produce SQL error on mariadb 5.5.28a HOT 3
- Illegal mix of collations (utf8_bin,NONE) and (binary,IGNORABLE) for operation 'case'" HOT 4
- initial run fails on PXC HOT 2
- MySQL v5.6.12 has global variable slave_last_heartbeat - which causes mycheckpoint to fail HOT 1
- MariaDB 5.5.31 - "Unknown column 'mysql' in 'field list'" HOT 2
- while deploying 231 on 5.5.33a-MariaDB-log, got this error message -- status_variables_aggregated_hour table exists (1146, "Table 'mycheckpoint.status_variables_aggregated_hour' doesn't exist") HOT 1
- (1054, "Unknown column 'mysql' in 'field list'")
- Doesn't work with MariaDB 10.0 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 mycheckpoint.