ruby-on-rails - Postgresql 导致 "no space on device"错误但磁盘/分区未满

Question

我在运行我的 Rails 网站时遇到以下错误，我认为这是导致网站崩溃的原因。我正在使用 Passenger，我的网站访问量很大。当我尝试将其重新联机时，Apache 生成了大量子节点，机器上的负载激增至大约 50，站点变得极其缓慢。我不缺磁盘。

PGError (FATAL:  could not access status of transaction 0
DETAIL:  could not write to file "pg_subtrans/009B" at offset 8192: No space left on device):
    /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:876:in `initialize'
    /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:876:in `connect'
    /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:876:in `connect'
    /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:276:in `initialize'
    /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:37:in `new'
    /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:37:in `postgresql_connection'
    /vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:292:in `send'
    /vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:292:in `connection='
    /vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:260:in `retrieve_connection'
    /vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'
    /vendor/rails/activerecord/lib/active_record/query_ca

Answer 1

“设备上没有剩余空间”错误不一定是由空间不足引起的。它也可能是由于文件系统的 inode 表已满引起的 - 换句话说，您的文件系统只能容纳这么多文件，而您已经达到了该限制。

如果您有大量小文件，就会发生这种情况。在这些情况下，通常会构建一个具有大 inode 表的新文件系统，以允许更多的小文件。