Re: Rollback of Query Cancellation

On Wed, Jan 28, 2009 at 1:29 AM, Abdul Rahman <abr_ora(at)yahoo(dot)com> 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