| 12 | | * mysql partitioning sucks (user-defined functions cannot be used for hash partitioning) |
| 13 | | * |
| 14 | | |
| | 11 | * mysql partitioning sucks (e.g. user-defined functions cannot be used for hash partitioning) |
| | 12 | * Bad files hunt in nebulous and/or on ippb02 (with Heather): |
| | 13 | - Ran slocate on ippb02.[0-2]/nebulous (got ~10.7M files) -> This version runs incredibly fast. Scanning all three ippb02 disks took 22 minutes (no attempt to optimize) |
| | 14 | - Checked their status in nebulous: |
| | 15 | - ok |
| | 16 | - uri not present in instance table for a given ins_id: ~5M files (Note: it seems that some files are temporary) |
| | 17 | For a lot of those files, the uri in nebulous is file:///data/ippb02.1/nebulous[...] while the file on disk is file:///data/ippb02.0/nebulous[...]. |
| | 18 | - uri not present in instance table and no ins_id but "similar" uris exist: 189k files |
| | 19 | {{{ |
| | 20 | Example of two similar uris: |
| | 21 | file:///data/ippb02.0/nebulous/00/00/1006632459.gpc1:ThreePi.nt:2011:01:23:o5584g0495o.285189:o5584g0495o.285189.ch.182968.XY34.mdl.fits |
| | 22 | file:///data/ipp025.0/nebulous/00/00/1230393764.gpc1:ThreePi.nt:2011:01:23:o5584g0495o.285189:o5584g0495o.285189.ch.182968.XY34.mdl.fits |
| | 23 | }}} |
| | 24 | - No entry in nebulous but there is a file on the disk: ~349k files (e.g: gpc1/ThreePi.nt/2010/12/30/o5560g0658o.269979/o5560g0658o.269979.ch.174390.XY03.ptn) |
| | 25 | Total: 5.7M "problems" |
| | 26 | See /tmp/nebulous_contents/problems. |