| Anonymous | Login | 2024-11-21 01:32 MST |
| Main | My View | View Issues | Change Log | Roadmap | Repositories |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
| 0013671 | ClearOS | app-network-report - Network Report | public | 2017-03-12 01:24 | 2017-03-23 08:01 | ||||
| Reporter | NickH | ||||||||
| Assigned To | bchambers | ||||||||
| Priority | normal | Severity | minor | Reproducibility | always | ||||
| Status | closed | Resolution | fixed | ||||||
| Platform | OS | OS Version | |||||||
| Product Version | 7.3.0 | ||||||||
| Target Version | 7.3.1 Updates | Fixed in Version | 7.3.1 Updates | ||||||
| Summary | 0013671: Network reports broken/empty | ||||||||
| Description | The Network Report has been broken apparently since 24/02. See https://www.clearos.com/clearfoundation/social/community/network-report-not-running-or-logging-since-februari-24-updates# [^] My Network Reports show "Nothing to report ..." for each interface. | ||||||||
| Tags | No tags attached. | ||||||||
| Attached Files | |||||||||
 Relationships |
 Notes |
|
|
(0005101) bchambers (administrator) 2017-03-13 08:55 |
Something dropping all the table options (auto_increment, default values etc.). It is not just on an upgrade. I fixed my tables last night by dropping the network table and re-adding using the schema. This morning, the options are gone again. Weird: MariaDB [reports]> explain network; +------------+---------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------------+------+-----+---------------------+-------+ | id | bigint(20) unsigned | NO | | 0 | | | iface | varchar(16) | NO | | NULL | | | rx_bytes | bigint(20) | YES | | NULL | | | rx_packets | bigint(20) | YES | | NULL | | | rx_errors | bigint(20) | YES | | NULL | | | rx_drop | bigint(20) | YES | | NULL | | | rx_rate | bigint(20) | YES | | NULL | | | tx_bytes | bigint(20) | YES | | NULL | | | tx_packets | bigint(20) | YES | | NULL | | | tx_errors | bigint(20) | YES | | NULL | | | tx_drop | bigint(20) | YES | | NULL | | | tx_rate | bigint(20) | YES | | NULL | | | timestamp | timestamp | NO | | 0000-00-00 00:00:00 | | +------------+---------------------+------+-----+---------------------+-------+ |
|
(0005111) bchambers (administrator) 2017-03-13 08:58 |
Tracked it down to this script that runs daily: /usr/sbin/purge-report-tables report Investigating... |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-03-12 01:24 | NickH | New Issue | |
| 2017-03-12 09:39 | user2 | Status | new => acknowledged |
| 2017-03-12 09:39 | user2 | Target Version | => 7.3.1 Updates |
| 2017-03-13 08:55 | bchambers | Note Added: 0005101 | |
| 2017-03-13 08:58 | bchambers | Note Added: 0005111 | |
| 2017-03-13 09:12 | bchambers | Assigned To | => bchambers |
| 2017-03-13 09:12 | bchambers | Status | acknowledged => assigned |
| 2017-03-13 09:47 | bchambers | Relationship added | related to 0013721 |
| 2017-03-13 09:52 | bchambers | Status | assigned => confirmed |
| 2017-03-13 09:52 | bchambers | Status | confirmed => resolved |
| 2017-03-13 09:52 | bchambers | Fixed in Version | => 7.3.1 Updates |
| 2017-03-13 09:52 | bchambers | Resolution | open => fixed |
| 2017-03-23 08:01 | user2 | Status | resolved => closed |
|
Issue History |