View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000005 | Timekoin Server | Performance Issue | public | 2012-06-21 02:51 | 2012-06-22 16:32 |
| Reporter | KnightMB | Assigned To | KnightMB | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Platform | PC | OS | Windows | OS Version | XP, Vista, or 7 |
| Product Version | 1.1 | ||||
| Target Version | 1.2 | Fixed in Version | 1.2 | ||
| Summary | 0000005: The part of Timekoin that checks to make sure the database is active has a memory leak | ||||
| Description | The main.php script of Timekoin does a routine check to make sure the database is active and if inactive, tries to re-establish a connection. After so many failures, it gives up and exits to avoid any further issues until the user attempts a restart of Timekoin. This check appears to cause a memory leak in Windows where if you check the task manager, you'll notice a php.exe process eating up more ram as time goes forward. | ||||
| Steps To Reproduce | Setup Timekoin on Windows (any version) and just let Timekoin run for a few days. Check the task manager from time to time. | ||||
| Tags | No tags attached. | ||||
|
|
Currently testing a suggested fix of simply using a "failed" query as a sign of database failure and then attempt to reconnect database. After 5 failures (spaced about 10 seconds apart on each retry), the program will exit to avoid further complications. As a side note, the mysql_ping being used to check for "active" database actually causes a 5 second delay in Windows (not seen on Linux or Mac). So future versions will simply just not use the command anymore as even the PHP.net website recommends against using this anymore. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-06-21 02:51 | KnightMB | New Issue | |
| 2012-06-21 02:51 | KnightMB | Status | new => assigned |
| 2012-06-21 02:51 | KnightMB | Assigned To | => KnightMB |
| 2012-06-21 02:53 | KnightMB | Status | assigned => acknowledged |
| 2012-06-21 02:57 | KnightMB | Note Added: 0000007 | |
| 2012-06-22 16:32 | KnightMB | Status | acknowledged => resolved |
| 2012-06-22 16:32 | KnightMB | Fixed in Version | 2.41 => 1.2 |
| 2012-06-22 16:32 | KnightMB | Resolution | open => fixed |
