[ome-users] Can't log into server (SOLVED)

[josh.moore at gmx.de]

Scott originally wrote about an error starting his server after a Mac
upgrade:

 > > > I have been running Omero 403 on osx for about 3 months quite
 > > > successfully.  However yesterday i could no longer log into
 > > > omero. ...  This started after i installed a security patch
 > > > from apple and restarted the server..

In his log files, there was this statement:

 > > > Caused by: org.postgresql.util.PSQLException: ERROR: index
 > > > "event_external_id_key" contains unexpected zero page at block
 > > > 10395

Via private emails, we found out that Scott was able to both query the
"event" table and to dump his database:

  psql omero
  select count(*) from event;
  \q
  pg_dump -F c omero > omero.db

However, *not* able to add an event:

   insert into event (id, permissions, time, experimenter,
   experimentergroup, session, type) values
   (ome_nextval('seq_event'),0,now(),0,0,0,0);

This is what kept his server from starting, and points towards
corruption in the database from the restart. See:

  http://archives.postgresql.org/pgsql-general/2009-03/msg01138.php

The solution:

   REINDEX INDEX event_external_id_key;


Hopefully that will be of use to someone somewhere.

Cheers,
~Josh