{"action":"created","issue":{"url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/42","labels_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/42/labels{/name}","comments_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/42/comments","events_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/42/events","html_url":"https://github.com/2ndQuadrant/bdr/issues/42","id":65678805,"number":42,"title":"BDR 0.9 -  server process terminated by signal 11: Segmentation fault (postgresql v 9.4.1 - Postgis  v 2.1.5) ","user":{"login":"amersid","id":10289219,"avatar_url":"https://avatars.githubusercontent.com/u/10289219?v=3","gravatar_id":"","url":"https://api.github.com/users/amersid","html_url":"https://github.com/amersid","followers_url":"https://api.github.com/users/amersid/followers","following_url":"https://api.github.com/users/amersid/following{/other_user}","gists_url":"https://api.github.com/users/amersid/gists{/gist_id}","starred_url":"https://api.github.com/users/amersid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amersid/subscriptions","organizations_url":"https://api.github.com/users/amersid/orgs","repos_url":"https://api.github.com/users/amersid/repos","events_url":"https://api.github.com/users/amersid/events{/privacy}","received_events_url":"https://api.github.com/users/amersid/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/2ndQuadrant/bdr/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-04-01T13:01:35Z","updated_at":"2015-04-13T09:15:20Z","closed_at":null,"body":"I am testing bdr 0.9 (3 Node cluster) to use in production with postgresql 9.4.1 . postgis 2.1.5. \r\n\r\nIts working fine wile doing DML with geometry data types with certain type  e.g LINESTRING etc but while using polygon or multipolygon doing DML(Insert), its giving certain type of errors and caused abnormal termination of  server process with Segmentation fault resulting DB in recovery state with error. This is the only case if using BDR. On server with different non BDR cluster, its running fine. \r\n \r\nReconnecting to DB is terminating with mentioned errors. \r\n\r\npostgres=# select * from pg_stat_activity;\r\nno connection to the server\r\nThe connection to the server was lost. Attempting reset: Succeeded.\r\npostgres=# \\q\r\n[postgres@hatest03 pg_log]$ psql postgres postgres\r\npsql: FATAL:  the database system is in recovery mode\r\n\r\n#-------------------------------------Log Entries for initial error attached. \r\n\r\n< 2015-04-01 13:28:25.547 BST >LOG:  starting logical decoding for slot \"bdr_16385_6132744382953710504_1_16385__\"\r\n< 2015-04-01 13:28:25.547 BST >DETAIL:  streaming transactions committing after 0/2821A20, reading WAL from 0/28219E8\r\n< 2015-04-01 13:28:25.547 BST >LOG:  logical decoding found consistent point at 0/28219E8\r\n< 2015-04-01 13:28:25.547 BST >DETAIL:  There are no running transactions.\r\n< 2015-04-01 13:28:25.581 BST >LOG:  server process (PID 27238) was terminated by signal 11: Segmentation fault\r\n< 2015-04-01 13:28:25.581 BST >LOG:  terminating any other active server processes\r\n< 2015-04-01 13:28:25.596 BST >WARNING:  terminating connection because of crash of another server process\r\n< 2015-04-01 13:28:25.596 BST >DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.\r\n< 2015-04-01 13:28:25.596 BST >HINT:  In a moment you should be able to reconnect to the database and repeat your command.\r\n< 2015-04-01 13:28:30.178 BST >LOG:  all server processes terminated; reinitializing\r\n< 2015-04-01 13:28:30.737 BST >LOG:  database system was interrupted; last known up at 2015-04-01 13:28:06 BST\r\n< 2015-04-01 13:28:30.738 BST >FATAL:  the database system is in recovery mode\r\n< 2015-04-01 13:28:30.739 BST >LOG:  starting up replication identifier with ckpt at 0/2821948\r\n< 2015-04-01 13:28:30.739 BST >LOG:  recovered replication state of node 1 to 0/20B6728\r\n< 2015-04-01 13:28:30.739 BST >LOG:  recovered replication state of node 2 to 0/2BA4CA8\r\n< 2015-04-01 13:28:30.739 BST >LOG:  database system was not properly shut down; automatic recovery in progress\r\n< 2015-04-01 13:28:30.748 BST >LOG:  redo starts at 0/2821948\r\n< 2015-04-01 13:28:30.750 BST >LOG:  record with zero length at 0/284F988\r\n< 2015-04-01 13:28:30.750 BST >LOG:  redo done at 0/284F948\r\n< 2015-04-01 13:28:30.750 BST >LOG:  last completed transaction was at log time 2015-04-01 13:28:20.440181+01\r\n< 2015-04-01 13:28:30.792 BST >LOG:  autovacuum launcher started\r\n< 2015-04-01 13:28:30.792 BST >LOG:  starting background worker process \"bdr (6132744382413076968,1,16385,)->bdr (6132744782835962054,1,\"\r\n< 2015-04-01 13:28:30.793 BST >LOG:  database system is ready to accept connections\r\n< 2015-04-01 13:28:30.793 BST >LOG:  starting background worker process \"bdr (6132744382413076968,1,16385,)->bdr (6132744382953710504,1,\"\r\n< 2015-04-01 13:28:30.793 BST >FATAL:  mismatch in worker state, got 0, expected 1\r\n< 2015-04-01 13:28:30.793 BST >LOG:  starting background worker process \"bdr db: test\"\r\n< 2015-04-01 13:28:30.793 BST >FATAL:  mismatch in worker state, got 0, expected 1\r\n< 2015-04-01 13:28:30.793 BST >LOG:  starting background worker process \"bdr supervisor\"\r\n2015-04-01 13:28:30.792 BST >LOG:  starting background worker process \"bdr (6132744382413076968,1,16385,)->bdr (6132744782835962054,1,\"\r\n< 2015-04-01 13:28:30.793 BST >LOG:  database system is ready to accept connections\r\n< 2015-04-01 13:28:30.793 BST >LOG:  starting background worker process \"bdr (6132744382413076968,1,16385,)->bdr (6132744382953710504,1,\"\r\n< 2015-04-01 13:28:30.793 BST >FATAL:  mismatch in worker state, got 0, expected 1\r\n< 2015-04-01 13:28:30.793 BST >LOG:  starting background worker process \"bdr db: test\"\r\n< 2015-04-01 13:28:30.793 BST >FATAL:  mismatch in worker state, got 0, expected 1\r\n< 2015-04-01 13:28:30.793 BST >LOG:  starting background worker process \"bdr supervisor\"\r\n< 2015-04-01 13:28:30.793 BST >FATAL:  mismatch in worker state, got 0, expected 2\r\n< 2015-04-01 13:28:30.794 BST >LOG:  worker process: bdr (6132744382413076968,1,16385,)->bdr (6132744782835962054,1, (PID 27250) exited with exit code 1\r\n< 2015-04-01 13:28:30.794 BST >LOG:  worker process: bdr (6132744382413076968,1,16385,)->bdr (6132744382953710504,1, (PID 27251) exited with exit code 1\r\n< 2015-04-01 13:28:30.794 BST >LOG:  worker process: bdr db: test (PID 27252) exited with exit code 1\r\n< 2015-04-01 13:28:30.799 BST >LOG:  worker process: bdr supervisor (PID 27253) exited with exit code 1\r\n< 2015-04-01 13:28:31.800 BST >LOG:  starting background worker process \"bdr supervisor\"\r\n< 2015-04-01 13:28:31.810 BST >LOG:  registering background worker \"bdr db: test\"\r\n< 2015-04-01 13:28:31.810 BST >LOG:  starting background worker process \"bdr db: test\"\r\n< 2015-04-01 13:28:31.831 BST >LOG:  Found bdr_connections entry for bdr (6132744382953710504,1,16385,) (origin specific: 0, unidirectional: 0, status: i)\r\n< 2015-04-01 13:28:31.831 BST >LOG:  Found bdr_connections entry for bdr (6132744782835962054,1,16385,) (origin specific: 0, unidirectional: 0, stat\r\n\r\n\r\nRegards, Amer\r\nDBA@ Airbus Defence and Space\r\n07544779701"},"comment":{"url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/comments/92284785","html_url":"https://github.com/2ndQuadrant/bdr/issues/42#issuecomment-92284785","issue_url":"https://api.github.com/repos/2ndQuadrant/bdr/issues/42","id":92284785,"user":{"login":"amersid","id":10289219,"avatar_url":"https://avatars.githubusercontent.com/u/10289219?v=3","gravatar_id":"","url":"https://api.github.com/users/amersid","html_url":"https://github.com/amersid","followers_url":"https://api.github.com/users/amersid/followers","following_url":"https://api.github.com/users/amersid/following{/other_user}","gists_url":"https://api.github.com/users/amersid/gists{/gist_id}","starred_url":"https://api.github.com/users/amersid/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amersid/subscriptions","organizations_url":"https://api.github.com/users/amersid/orgs","repos_url":"https://api.github.com/users/amersid/repos","events_url":"https://api.github.com/users/amersid/events{/privacy}","received_events_url":"https://api.github.com/users/amersid/received_events","type":"User","site_admin":false},"created_at":"2015-04-13T09:15:20Z","updated_at":"2015-04-13T09:15:20Z","body":"Hi Craig, \r\n\r\nPlease confirm if this issues is reproduced or additional information from our side. I can create some  data directory  tar file and upload if this option is available to upload some files. \r\n\r\nRegards, Amer "}}