The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

ERROR 3408: File size on disk does not match catalolg

Does anyone know how to fix this problem? Historical=> SELECT * FROM quote; ERROR 3408: File size on disk does not match catalog for /var/vertica_data/chi2vertica01/Data/Historical/v_historical_node0001_data/987/45035996274330987/45035996274330987_0.fdb

Comments

  • Looks like a data corruption issue detected by a vertica check. If you can, drop the table. May need to run file validation on the entire database and troubleshoot why and how the file corruption occurred ? Unsupported block device, file system, OS ? Check /opt/vertica/bin/vertica --help -v perform thorough database and file validation -V perform thorough data validation, then stop These might help, but if this is a serious production system, may wan to get Vertica support involved to avoid loss of data.
  • Thank you, Colin. We are using NFS for the data location and CentOS 6.3. I was trying to run the file validation, but it was saying "Unable to load Catalog". I just dropped the table since it is not in production yet, and trying to re-generate the same issue. We now have multiple writers (5) inserting bunch of garbage data for test. I've stopped and run them multiple times, and it happened. Thank you again. BK
  • NFS may be your problem. If you can, use local file system.
  • It looks like the NFS is the problem as you said. Thank you very much, Colin.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.