PostgreSQL server terminated by signal 11 - Mailing list pgsql-sql

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA" style="font-size:
10.0pt;font-family:Arial">My PostgreSQL server running on a Linux machine is terminated by signal 11 whenever I try to
createsome indexes on a table, which contains quite a lot of data.  However I succeeded in creating some other indexes
withouthaving the PostgreSQL server terminated:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-CA"style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Courier" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Courier">agora=> CREATE INDEX IDX_GSLOG_EVENTTIME</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">agora->   ON GSLOG_EVENT (EVENT_DATE_CREATED);</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">CREATE INDEX</span></font><p class="MsoNormal"><font face="Courier" size="2"><span
lang="EN-CA"style="font-size: 
10.0pt;font-family:Courier">Time: 152908.797 ms</span></font><p class="MsoNormal"><font face="Courier" size="2"><span
lang="EN-CA"style="font-size: 
10.0pt;font-family:Courier">agora=> explain analyze select max(event_date_created) from gslog_event;</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">                                                                              QUERY
PLAN                                                   </span></font><p class="MsoNormal"><font face="Courier"
size="2"><spanlang="EN-CA" style="font-size: 

10.0pt;font-family:Courier">----------------------------------------------------------------------------------------------------------------------------------------------------------------------</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier"> Result  (cost=3.80..3.81 rows=1 width=0) (actual time=0.218..0.221 rows=1
loops=1)</span></font><pclass="MsoNormal"><font face="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">   InitPlan</span></font><p class="MsoNormal"><font face="Courier" size="2"><span
lang="EN-CA"style="font-size: 
10.0pt;font-family:Courier">     ->  Limit  (cost=0.00..3.80 rows=1 width=8) (actual time=0.197..0.200 rows=1
loops=1)</span></font><pclass="MsoNormal"><font face="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">           ->  Index Scan Backward using idx_gslog_eventtime on gslog_event 
(cost=0.00..39338251.59rows=10348246 width=8) (actual time=0.188..0.188 rows=1 loops=1)</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">                 Filter: (event_date_created IS NOT NULL)</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier"> Total runtime: 0.324 ms</span></font><p class="MsoNormal"><font face="Courier"
size="2"><spanlang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">(6 rows)</span></font><p class="MsoNormal"><font face="Courier" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Courier"> </span></font><p class="MsoNormal"><font face="Courier" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Courier">Time: 41.085 ms</span></font><p class="MsoNormal"><font face="Courier" size="2"><span
lang="EN-CA"style="font-size: 
10.0pt;font-family:Courier">agora=> CREATE INDEX IDX_GSLOG_EVENT_SPREAD_PROTOCOL_NAME</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">agora->   ON GSLOG_EVENT (EVENT_DATE_CREATED)</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">agora->   WHERE EVENT_NAME::text <> 'player-login'::text</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">agora->     AND PLAYER_USERNAME IS NOT NULL</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">agora->     AND GAME_CLIENT_VERSION IS NULL;</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">server closed the connection unexpectedly</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">        This probably means the server terminated abnormally</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">        before or while processing the request.</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">The connection to the server was lost. </span></font><font face="Courier" size="2"><span
style="font-size:10.0pt;font-family:Courier">Attemptingreset: Failed.</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial">The PostgreSQL log file doesn’t give more information about what went wrong, except that the
serverprocess has been terminated:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Courier" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Courier">LOG:  server process (PID 22270) was terminated by signal 11</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  terminating any other active server processes</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  all server processes terminated; reinitializing</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">FATAL:  the database system is starting up</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  database system was interrupted at 2006-07-27 15:29:27 GMT</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  checkpoint record is at 249/179D44A8</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  redo record is at 249/179D44A8; undo record is at 0/0; shutdown FALSE</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  next transaction ID: 543712876; next OID: 344858</span></font><p
class="MsoNormal"><fontface="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  next MultiXactId: 2; next MultiXactOffset: 3</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  database system was not properly shut down; automatic recovery in
progress</span></font><pclass="MsoNormal"><font face="Courier" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  redo starts at 249/179D44EC</span></font><p class="MsoNormal"><font face="Courier"
size="2"><spanlang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  record with zero length at 249/179E4888</span></font><p class="MsoNormal"><font
face="Courier"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  redo done at 249/179E2DFC</span></font><p class="MsoNormal"><font face="Courier"
size="2"><spanlang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  database system is ready</span></font><p class="MsoNormal"><font face="Courier"
size="2"><spanlang="EN-CA" style="font-size: 
10.0pt;font-family:Courier">LOG:  transaction ID wrap limit is 2147484146, limited by database
"postgres"</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial">I checked the memory installed on the machine, running memtest86 during more than one day; no
errorfound.  I checked bad blocks on every hard drive installed in this machine, using e2fsck -c /dev/hdxx; no bad
blockfound.  </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial">I’ve already dropped the table, inserted data, and tried to create all the indexes.  The
serversystematically crashed when creating some specific indexes.  The only idea I have for the moment would be to
setupanother machine with the same database environment.  Other idea(s)?</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial">Thanks</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-CA"
style="font-size:
10.0pt;font-family:Arial">--</span></font><span lang="EN-CA"></span><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-CA" style="font-size: 
10.0pt;font-family:Arial">Daniel CAUNE</span></font><span lang="EN-CA"></span><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-CA" style="font-size: 
10.0pt;font-family:Arial">Ubisoft Online Technology</span></font><span lang="EN-CA"></span><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-CA" style="font-size: 
10.0pt;font-family:Arial">(514) 490 2040 ext. 3613</span></font><span lang="EN-CA"></span><p class="MsoNormal"><font
face="TimesNew Roman" size="3"><span lang="EN-CA" style="font-size:12.0pt"> </span></font></div>