Postgres Pro
Downloads
Home   >   mailing lists

Re: Rollback of Query Cancellation - Mailing list pgsql-general

From Abdul Rahman
Subject Re: Rollback of Query Cancellation
Date
Msg-id 566877.21653.qm@web65711.mail.ac4.yahoo.com
Whole thread Raw
In response to Re: Rollback of Query Cancellation  (Abdul Rahman <abr_ora@yahoo.com>)
Responses Re: Rollback of Query Cancellation  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-general
Tree view
Thanks Jaime,
Plz consider the actual log files to explore the issue in detail. Because I have pasted the log files of client machine, I am using (sorry).


2009-01-27 18:29:25 STATEMENT:  delete from ci_cin_type_v where req_id='0824100207'
    delete from ci_cust_type_v where req_id='0824100207'
    delete from ci_dependents_v where req_id='0824100207'
    delete from ci_employer_v where req_id='0824100207'
    delete from ci_cor_sig_v where req_id='0824100207'
    delete from ci_corporate_v where req_id='0824100207'
    delete from ci_individual_v where req_id='0824100207'
    delete from ci_cif_v where req_id='0824100207'
2009-01-27 18:29:41 ERROR:  relation "ci_cust_type_v" does not exist
2009-01-27 18:29:41 STATEMENT:  delete from ci_cust_type_v where req_id='0824100207'
2009-01-27 18:52:08 LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
2009-01-27 18:52:08 LOG:  unexpected EOF on client connection
2009-01-27 18:52:08 LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
2009-01-27 18:52:08 LOG:  unexpected EOF on client connection


Here, I am talking about the last query (Bold_Italic). Now my question is still stands. Kindly continue to up your valuable text.




From: Jaime Casanova <jcasanov@systemguards.com.ec>
To: Abdul Rahman <abr_ora@yahoo.com>
Cc: pgsql-general@postgresql.org
Sent: Wednesday, January 28, 2009 11:38:59 AM
Subject: Re: Rollback of Query Cancellation

On Wed, Jan 28, 2009 at 1:29 AM, Abdul Rahman <abr_ora@yahoo.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

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Rollback of Query Cancellation
Next
From: Abdul Rahman
Date:
Subject: Re: Rollback of Query Cancellation