Bug 523791
| Summary: | smolt database fields too small for filesystem information | ||
|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Eric Sandeen <esandeen> |
| Component: | smolt | Assignee: | Mike McGrath <mmcgrath> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Fedora Extras Quality Assurance <extras-qa> |
| Severity: | medium | Docs Contact: | |
| Priority: | low | ||
| Version: | rawhide | CC: | jeff, mmcgrath |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2009-09-16 17:16:50 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Ok, I think this is fixed upstream. It didn't require downtime like I thought it might. Only took about 30-40 seconds per column to update. |
filesystem information for large fs's is getting truncated when it's inserted into the db: bsize frsize blocks bfree bavail file ffree favail sent: 4096 4096 5846347456 5846346248 5846346248 4677104128 4677104125 4677104125 rcvd: 4096 4096 2147483647 2147483647 2147483647 2147483647 2147483647 2147483647 this is due to the int(11) types for most of the fields: +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | id | bigint(20) | NO | PRI | NULL | auto_increment | | host_id | int(11) | YES | MUL | NULL | | | mnt_pnt | varchar(64) | YES | | NULL | | | fs_type | varchar(16) | YES | | NULL | | | f_favail | int(11) | YES | | NULL | | | f_bsize | int(11) | YES | | NULL | | | f_frsize | int(11) | YES | | NULL | | | f_blocks | int(11) | YES | | NULL | | | f_bfree | int(11) | YES | | NULL | | | f_bavail | int(11) | YES | | NULL | | | f_files | int(11) | YES | | NULL | | | f_ffree | int(11) | YES | | NULL | | | f_fssize | bigint(24) | YES | | NULL | | +----------+-------------+------+-----+---------+----------------+ All but f_bsize and f_frsize should likely be increased to bigint(24) to accomodate larger filesystems. Thanks, -Eric