[ovirt-users] Postgresql failure (was: Ovirt Engine Issue)

[Eli Mesika]

----- Original Message -----
> From: "Yedidyah Bar David" <didi at redhat.com>
> To: "Melissa Mesler" <melissa at aasteel.com>, "Eli Mesika" <emesika at redhat.com>
> Cc: users at ovirt.org
> Sent: Monday, December 7, 2015 4:14:49 PM
> Subject: Postgresql failure (was: [ovirt-users] Ovirt Engine Issue)
> 
> On Mon, Dec 7, 2015 at 4:00 PM, Melissa Mesler <melissa at aasteel.com> wrote:
> > Here is what I retrieved from the postresql logs:
> >
> > LOG:  database system was interrupted; last known up at 2015-12-04 10:57:43
> > CST
> > LOG:  unexpected pageaddr 0/69564000 in log file 0, segment 107, offset
> > 5652480
> > LOG:  invalid primary checkpoint record
> > LOG:  unexpected pageaddr 0/6952A000 in log file 0, segment 107, offset
> > 5414912
> > LOG:  invalid secondary checkpoint record
> > PANIC:  could not locate a valid checkpoint record
> > LOG:  startup process (PID 1637) was terminated by signal 6: Aborted
> > LOG:  aborting startup due to startup process failure
> > LOG:  database system was interrupted; last known up at 2015-12-04 10:57:43
> > CST
> > LOG:  unexpected pageaddr 0/69564000 in log file 0, segment 107, offset
> > 5652480
> > LOG:  invalid primary checkpoint record
> > LOG:  unexpected pageaddr 0/6952A000 in log file 0, segment 107, offset
> > 5414912
> > LOG:  invalid secondary checkpoint record
> > PANIC:  could not locate a valid checkpoint record
> > LOG:  startup process (PID 2632) was terminated by signal 6: Aborted
> > LOG:  aborting startup due to startup process failure
> >
> > Also, when I did the sync on the ovirt vm it was powered off. I know not to
> > do live syncs as there could be issues. That's why I'm so confused that
> > there's a pr oblem.
> 
> No idea, adding Eli and changing subject.

Seems as database is corrupted 
This is a serious issue that someone with DBA knowledge should handle 
http://blog.endpoint.com/2014/11/when-postgres-will-not-start.html
Remember to do a physical copy of your database file to a different partition or server before you start 

Eli

> 
> Best,
> 
> >
> >
> >
> > On 12/7/15 1:03 AM, Yedidyah Bar David wrote:
> >
> > On Mon, Dec 7, 2015 at 12:09 AM, Melissa Mesler <melissa at aasteel.com>
> > wrote:
> >
> > Hopefully someone can give me a good idea of how to troubleshoot an ovirt
> > issue. I am running 3.5 on CentOS 6.7. Here is the issue I'm having. I have
> > Ovirt running as a virtual machine in KVM. I recently moved (with virtsync)
> > the vm to rebuild the host. Once the host was rebuilt I moved ovirt back.
> > Now ovirt-engine starts but is inaccessible. In the logs it says this:
> >
> > 2015-12-06 15:57:24,558 ERROR [org.ovirt.engine.core.bll.Backend] (MSC
> > service thread 1-2) Error in getting DB connection. The database is
> > inaccessible. Original exception is: DataAccessResourceFailureException:
> > Error retreiving database metadata; nested exception is
> > org.springframework.jdbc.support.MetaDataAccessException: Could not get
> > Connection for extracting meta data; nested exception is
> > org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
> > JDBC Connection; nested exception is java.sql.SQLException:
> > javax.resource.ResourceException: IJ000453: Unable to get managed
> > connection
> > for java:/ENGINEDataSource
> >
> > I did notice that I can't get postgresql to start.
> >
> > What happens when you try? Check/post also pg logs please, from
> > /var/lib/pgsql/data/pg_log/ .
> >
> > Everything worked
> > perfectly fine before. Any ideas?
> >
> > Was the copy done from a live machine? From a snapshot? Perhaps it wasn't
> > consistent? Need to check pg logs.
> >
> > Best,
> >
> >
> 
> 
> 
> --
> Didi
>