Checkpoint request failed on version 8.2.1.

Поиск
Список
Период
Сортировка
От Patrick Earl
Тема Checkpoint request failed on version 8.2.1.
Дата
Msg-id e0762e610701110921t32c22a1dld3dc652b3a0446d9@mail.gmail.com
обсуждение исходный текст
Ответы Re: Checkpoint request failed on version 8.2.1.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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"

В списке pgsql-general по дате отправления:

Предыдущее
От: "SunWuKung"
Дата:
Сообщение: crosstab - pivot - transpose
Следующее
От: Jiří Němec
Дата:
Сообщение: Remove duplicate rows