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@xxxxxxxxxxxxxxxxxxx>
To: Abdul Rahman <abr_ora@xxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
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@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
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@xxxxxxxxxxxxxxxxxxx>
To: Abdul Rahman <abr_ora@xxxxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
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@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
