[pgsql-jp: 36723] Re: process exited abnormally and possibly corrupted shared memory.が発生する

[fukuda]

福田です。

「SELECT * FROM テーブル名 WHERE id = ********」
という問合せで件のエラーになるようです
テーブル定義は

  Column  |      Type      | Modifiers
----------+----------------+-----------
 id       | character(64)  | not null
 data     | text           |
 no       | integer        |
 exists   | boolean        |
 sequence | integer        | default 0

ですが、select文の発行でサーバが再起動をすることが
ありうるのでしょうか？


On Saturday 18 February 2006 05:52, fukuda様 wrote:
> 
> 自己レスです。
> 
> 件のメッセージを出力する前にSIGSEGVで死んでいるという
> メッセージをみつけました。
> 
> Feb 18 05:41:40 **** postgres[28538]: [689-1] LOG:  server process (PID 23385) was terminated by signal 11
> Feb 18 05:41:40 **** postgres[28538]: [690-1] LOG:  terminating any other active server processes
> 
> 
> 
> 
> On Saturday 18 February 2006 04:51, fukuda様 wrote:
> > 
> > 福田と申します。
> > 
> > Linux: 2.4.18-bf2.4
> > Postgresql: 7.4.9
> > 
> > にて運用中のサービスにおいてDB接続ができたり
> > できなくなったりする状態になりました。
> > postgresql.logには以下のメッセージが出力されており、
> > プロセスの終了と生成を繰り返しているようなのです。
> > 
> > Feb 18 04:18:01 **** postgres[3023]: [152-3]  process exited abnormally and possibly corrupted shared memory.
> > Feb 18 04:18:01 **** postgres[3013]: [149-3]  process exited abnormally and possibly corrupted shared memory.
> > Feb 18 04:18:01 **** postgres[3004]: [149-3]  process exited abnormally and possibly corrupted shared memory.
> > Feb 18 04:18:01 **** postgres[3001]: [149-3]  process exited abnormally and possibly corrupted shared memory.
> > Feb 18 04:18:01 **** postgres[2994]: [152-3]  process exited abnormally and possibly corrupted shared memory.
> > Feb 18 04:18:01 **** postgres[2987]: [149-3]  process exited abnormally and possibly corrupted shared memory.
> > Feb 18 04:18:01 **** postgres[3113]: [152-4] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
> > Feb 18 04:18:01 **** postgres[3141]: [150-3]  process exited abnormally and possibly corrupted shared memory.
> > Feb 18 04:18:01 **** postgres[3106]: [149-4] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
> > Feb 18 04:18:01 **** postgres[3087]: [152-4] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
> > Feb 18 04:18:01 **** postgres[3080]: [149-4] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
> > (同じメッセージなので省略)
> > Feb 18 04:18:01 **** postgres[2987]: [149-4] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
> > Feb 18 04:18:01 **** postgres[3141]: [150-4] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
> > Feb 18 04:18:01 **** postgres[28538]: [151-1] LOG:  all server processes terminated; reinitializing
> > Feb 18 04:18:01 **** postgres[3142]: [152-1] LOG:  database system was interrupted at 2006-02-18 04:17:31 JST
> > Feb 18 04:18:01 **** postgres[3142]: [153-1] LOG:  checkpoint record is at B/231D70A0
> > Feb 18 04:18:01 **** postgres[3142]: [154-1] LOG:  redo record is at B/231D70A0; undo record is at 0/0; shutdown TRUE
> > Feb 18 04:18:01 **** postgres[3142]: [155-1] LOG:  next transaction ID: 151535051; next OID: 3385122
> > Feb 18 04:18:01 **** postgres[3142]: [156-1] LOG:  database system was not properly shut down; automatic recovery in progress
> > Feb 18 04:18:01 **** postgres[3142]: [157-1] LOG:  redo starts at B/231D70E0
> > Feb 18 04:18:01 **** postgres[3142]: [158-1] LOG:  record with zero length at B/23202448
> > Feb 18 04:18:01 **** postgres[3142]: [159-1] LOG:  redo done at B/23202424
> > Feb 18 04:18:02 **** postgres[3145]: [152-1] FATAL:  the database system is starting up
> > Feb 18 04:18:04 **** postgres[3142]: [160-1] LOG:  database system is ready
> > 
> > postgresqlを再起動しても効果なく、
> > googleなどで検索しても、有益な情報が見付けることができませんでした。
> > どなたか、この状況を改善する方法をご存じないでしょうか
> > よろしくお願いいたします。
> > 
> > 
> > 
> > 
> 

-- 
━━━━━━━━有限会社ねっと屋━━━━━━━━
　福田伸行   fukuda ＠ netya.com
　〒530-0051　大阪市北区太融寺町2-22 
　梅田八千代ビル2F A号室
　TEL:06-4709-7661　FAX:06-4709-7662
━━━━━━━━━━━━━━━━━━━━━━━━