[ovirt-users] Postgresql failure

[Melissa Mesler]

I might end up just rebuilding my ovirt which isn't a huge deal as my 
set up is pretty simple.

I do have a question as to why this would happen. Can anyone give me 
guidance there? I would understand if I forcefully shut down the system 
but I didn't. I always shut my systems down clean so the database 
portion should've shutdown that way also. Just trying to understand more 
of why possibly this would happen so that I could avoid this in the future.

---
Melissa Mesler

On 12/7/15 8:14 AM, Yedidyah Bar David wrote:
> 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.
>
> 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,
>>
>>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20151207/58015462/attachment-0001.html>