Search Postgresql Archives

Re: Rollback of Query Cancellation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Jan 28, 2009 at 1:29 AM, Abdul Rahman <abr_ora@xxxxxxxxx> wrote:
> Welcome Jcasanov,
>
> Here is the output of the log files:
>
> 2009-01-27 09:24:18 FATAL:  the database system is starting up
> 2009-01-27 09:24:19 LOG:  database system was shut down at 2009-01-26
> 18:34:53
> 2009-01-27 09:24:19 LOG:  checkpoint record is at 0/1B9F92C8
> 2009-01-27 09:24:19 LOG:  redo record is at 0/1B9F92C8; undo record is at
> 0/0; shutdown TRUE
> 2009-01-27 09:24:19 LOG:  next transaction ID: 0/335372; next OID: 19380
> 2009-01-27 09:24:19 LOG:  next MultiXactId: 1; next MultiXactOffset: 0
> 2009-01-27 09:24:19 LOG:  database system is ready

all these messages are 'cause the database is starting up

> 2009-01-27 18:52:43 LOG:  received fast shutdown request
> 2009-01-27 18:52:44 LOG:  shutting down
> 2009-01-27 18:52:44 LOG:  database system is shut down
> 2009-01-27 18:52:44 LOG:  logger shutting down
>

the database was shutting down

> and
>
> 2009-01-28 09:42:14 FATAL:  the database system is starting up
> 2009-01-28 09:42:14 LOG:  database system was shut down at 2009-01-27
> 18:52:44
> 2009-01-28 09:42:14 LOG:  checkpoint record is at 0/1B9F9368
> 2009-01-28 09:42:14 LOG:  redo record is at 0/1B9F9368; undo record is at
> 0/0; shutdown TRUE
> 2009-01-28 09:42:14 LOG:  next transaction ID: 0/336490; next OID: 19380
> 2009-01-28 09:42:14 LOG:  next MultiXactId: 1; next MultiXactOffset: 0
> 2009-01-28 09:42:15 LOG:  database system is ready
> 2009-01-28 09:42:15 FATAL:  the database system is starting up
>

starting up again


none of these are saying the time for some records being deleted, read
my prior post about why is not possible that message (commit never
executed)


-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux