Checkpoint request failed on version 8.2.1.

From: "Patrick Earl" <patearl(at)patearl(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Checkpoint request failed on version 8.2.1.
Date: 2007-01-11 17:21:02
Message-ID: e0762e610701110921t32c22a1dld3dc652b3a0446d9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi all. I'm getting a checkpoint request failed message when I try to
execute a CREATE DATABASE command. Since it was a fresh install, I've
included the entire server log up to the point of the error. I
truncated the log output two lines after the error message.

Is there a way I can avoid this problem? Is this a bug? Thanks.

Patrick

2007-01-11 09:46:20 LOG: database system was shut down at 2007-01-11
09:46:16 Mountain Standard Time
2007-01-11 09:46:20 LOG: checkpoint record is at 0/487970
2007-01-11 09:46:20 LOG: redo record is at 0/487970; undo record is
at 0/0; shutdown TRUE
2007-01-11 09:46:20 LOG: next transaction ID: 0/595; next OID: 10820
2007-01-11 09:46:20 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2007-01-11 09:46:20 LOG: database system is ready
2007-01-11 09:47:51 LOG: received SIGHUP, reloading configuration files
2007-01-11 09:48:18 FATAL: no pg_hba.conf entry for host
"192.168.2.102", user "sa", database "postgres", SSL off
2007-01-11 09:55:39 LOG: could not receive data from client: No
connection could be made because the target machine actively refused
it.

2007-01-11 09:55:39 LOG: unexpected EOF on client connection
2007-01-11 09:55:59 NOTICE: CREATE TABLE will create implicit
sequence "Transactions_Transaction_ID_seq" for serial column
"Transactions.Transaction_ID"
2007-01-11 09:55:59 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create
implicit index "Transactions_pkey" for table "Transactions"
2007-01-11 09:56:05 NOTICE: CREATE TABLE will create implicit
sequence "Database_Updates_ID_seq" for serial column
"Database_Updates.ID"
2007-01-11 09:56:05 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create
implicit index "Database_Updates_pkey" for table "Database_Updates"
2007-01-11 09:56:06 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create
implicit index "Key_pkey" for table "Key"
2007-01-11 09:56:07 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create
implicit index "UnitTestTable1_pkey" for table "UnitTestTable1"
2007-01-11 09:56:07 NOTICE: trigger "Delete_Tracking_Trigger" for
table "UnitTestTable1" does not exist, skipping
2007-01-11 09:56:07 NOTICE: trigger "Update_Tracking_Trigger" for
table "UnitTestTable1" does not exist, skipping
2007-01-11 09:56:07 NOTICE: trigger "Insert_Tracking_Trigger" for
table "UnitTestTable1" does not exist, skipping
2007-01-11 09:56:10 NOTICE: drop cascades to sequence "_WEBDRIL"."IDSequence"
2007-01-11 09:56:10 NOTICE: drop cascades to table "_WEBDRIL"."Database_Id"
2007-01-11 09:56:10 NOTICE: drop cascades to table
"_WEBDRIL"."Database_Updates"
2007-01-11 09:56:10 NOTICE: drop cascades to default for table
"_WEBDRIL"."Database_Updates" column ID
2007-01-11 09:56:10 NOTICE: drop cascades to table "_WEBDRIL"."Transactions"
2007-01-11 09:56:10 NOTICE: drop cascades to default for table
"_WEBDRIL"."Transactions" column Transaction_ID
2007-01-11 09:56:10 NOTICE: drop cascades to function
"_WEBDRIL"."Get_Transaction_ID"()
2007-01-11 09:56:10 NOTICE: drop cascades to function
"_WEBDRIL"."Current_Transaction_ID"()
2007-01-11 09:56:10 NOTICE: drop cascades to function
"_WEBDRIL"."Get_User_ID"()
2007-01-11 09:56:11 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create
implicit index "UnitTestTable1_pkey" for table "UnitTestTable1"
2007-01-11 09:56:11 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create
implicit index "UnitTestTable2_pkey" for table "UnitTestTable2"
2007-01-11 09:56:17 ERROR: could not open relation 1663/16403/16426:
Permission denied
2007-01-11 09:56:17 ERROR: checkpoint request failed
2007-01-11 09:56:17 HINT: Consult recent messages in the server log
for details.
2007-01-11 09:56:17 STATEMENT: CREATE DATABASE "TestDatabase"
2007-01-11 09:56:18 NOTICE: drop cascades to table "TestSchema"."stable"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message NM 2007-01-11 17:49:07 storing SMALL large objects to postgres with C# (.NET ODBC layer)
Previous Message SunWuKung 2007-01-11 17:19:08 crosstab - pivot - transpose

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-01-11 17:21:34 Re: ideas for auto-processing patches
Previous Message Kim 2007-01-11 17:20:13 unusual performance for vac following 8.2 upgrade