Fehler in Datenbank

    • Trebuchet
      Trebuchet
      Bronze
      Dabei seit: 10.01.2007 Beiträge: 1.116
      habe gestern eine fehlermeldung im hm-report erhalten, nachdem (!) die session erfolgreich mit stats und import funktioniert hat.

      habe dann den hm beendet und die datenbank zuerst vakuumiert und danach noch reindexiert, bei beiden sind fehlermeldungen aufgetaucht:

      reindex:
      (
      NOTICE: table "pg_class" was reindexed
      NOTICE: table "sql_features" was reindexed
      NOTICE: table "sql_implementation_info" was reindexed
      NOTICE: table "pg_statistic" was reindexed
      NOTICE: table "sql_languages" was reindexed
      NOTICE: table "sql_packages" was reindexed
      NOTICE: table "sql_parts" was reindexed
      NOTICE: table "sql_sizing" was reindexed
      NOTICE: table "sql_sizing_profiles" was reindexed
      NOTICE: table "pg_ts_config" was reindexed
      NOTICE: table "pg_ts_config_map" was reindexed
      NOTICE: table "pg_ts_dict" was reindexed
      NOTICE: table "pg_ts_parser" was reindexed
      NOTICE: table "pg_ts_template" was reindexed
      NOTICE: table "pg_type" was reindexed
      NOTICE: table "pg_attribute" was reindexed
      NOTICE: table "pg_proc" was reindexed
      NOTICE: table "pg_autovacuum" was reindexed
      NOTICE: table "pg_attrdef" was reindexed
      NOTICE: table "pg_constraint" was reindexed
      NOTICE: table "pg_inherits" was reindexed
      )

      NOTICE: table "pg_index" was reindexed
      ERROR: could not access status of transaction 6619239
      DETAIL: Could not open file "pg_subtrans/0065": No such file or directory.

      ERROR: could not access status of transaction 6619239
      DETAIL: Could not open file "pg_subtrans/0065": No such file or directory.



      vacuumize:

      ERROR: could not read block 19 of relation 1663/418190/418424: Invalid argument

      ERROR: could not read block 19 of relation 1663/418190/418424: Invalid argument

      kann mir jemand erklären, wie ich das reparieren kann?

      gruss
  • 2 Antworten