{"action":"created","issue":{"url":"https://api.github.com/repos/pgroonga/pgroonga/issues/77","repository_url":"https://api.github.com/repos/pgroonga/pgroonga","labels_url":"https://api.github.com/repos/pgroonga/pgroonga/issues/77/labels{/name}","comments_url":"https://api.github.com/repos/pgroonga/pgroonga/issues/77/comments","events_url":"https://api.github.com/repos/pgroonga/pgroonga/issues/77/events","html_url":"https://github.com/pgroonga/pgroonga/issues/77","id":345100768,"node_id":"MDU6SXNzdWUzNDUxMDA3Njg=","number":77,"title":"PGroonga 2.1.0 crash","user":{"login":"aeg","id":85253,"node_id":"MDQ6VXNlcjg1MjUz","avatar_url":"https://avatars0.githubusercontent.com/u/85253?v=4","gravatar_id":"","url":"https://api.github.com/users/aeg","html_url":"https://github.com/aeg","followers_url":"https://api.github.com/users/aeg/followers","following_url":"https://api.github.com/users/aeg/following{/other_user}","gists_url":"https://api.github.com/users/aeg/gists{/gist_id}","starred_url":"https://api.github.com/users/aeg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aeg/subscriptions","organizations_url":"https://api.github.com/users/aeg/orgs","repos_url":"https://api.github.com/users/aeg/repos","events_url":"https://api.github.com/users/aeg/events{/privacy}","received_events_url":"https://api.github.com/users/aeg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":8,"created_at":"2018-07-27T06:01:01Z","updated_at":"2018-07-31T00:46:43Z","closed_at":null,"author_association":"NONE","body":"pgroonga のindex を設定しているテーブルを更新するWebアプリケーションに対して、jmeter で4並列で更新し続けていると、pgroonga がcrash した。負荷は各スレッド、一連の更新を10秒間隔で実施している。また、この後、PostgreSQL にupdate を2並列で実施し続けたところ、同様のエラーが発生した\r\n\r\npgloonga.log\r\n```\r\n2018-07-26 00:46:54.150500|C|15992: -- CRASHED!!! --\r\n2018-07-26 00:46:54.152042|C|15992: /usr/pgroonga_lib/libgroonga.so.0(+0x145b6e) [0x7f2849738b6e]\r\n2018-07-26 00:46:54.152053|C|15992: /lib64/libpthread.so.0(+0xf370) [0x7f291ea48370]\r\n2018-07-26 00:46:54.152056|C|15992: /usr/pgroonga_lib/libgroonga.so.0(grn_io_segment_alloc+0xb1) [0x7f28498aecf1]\r\n2018-07-26 00:46:54.152059|C|15992: /usr/pgroonga_lib/libgroonga.so.0(grn_hash_add+0x1831) [0x7f2849845de1]\r\n2018-07-26 00:46:54.152061|C|15992: /usr/pgroonga_lib/libgroonga.so.0(grn_table_add+0x702) [0x7f28497501d2]\r\n2018-07-26 00:46:54.152064|C|15992: /usr/pgsql-10/lib/pgroonga.so(+0x18e0a) [0x7f284a337e0a]\r\n2018-07-26 00:46:54.152066|C|15992: /usr/pgsql-10/lib/pgroonga.so(+0x19214) [0x7f284a338214]\r\n2018-07-26 00:46:54.152068|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE(ExecInsertIndexTuples+0x2dd) [0x5ef1ed]\r\n2018-07-26 00:46:54.152071|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE() [0x60c43a]\r\n2018-07-26 00:46:54.152073|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE() [0x60c6b5]\r\n2018-07-26 00:46:54.152075|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE(standard_ExecutorRun+0x132) [0x5eff22]\r\n2018-07-26 00:46:54.152077|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE() [0x71b30a]\r\n2018-07-26 00:46:54.152080|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE() [0x71b547]\r\n2018-07-26 00:46:54.152082|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE(PortalRun+0x185) [0x71c085]\r\n2018-07-26 00:46:54.152084|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE(PostgresMain+0x1654) [0x719ad4]\r\n2018-07-26 00:46:54.152086|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE() [0x47ae1c]\r\n2018-07-26 00:46:54.152089|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE(PostmasterMain+0xecf) [0x6b073f]\r\n2018-07-26 00:46:54.152091|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE(main+0x7bf) [0x47bc4f]\r\n2018-07-26 00:46:54.152093|C|15992: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f291c7a1b35]\r\n2018-07-26 00:46:54.152095|C|15992: postgres: testap testdb_test 127.0.0.1(59624) UPDATE() [0x47bcb6]\r\n```\r\n\r\npostgresql.log\r\n\r\n```\r\n2018-07-26 00:46:54 JST 7880 5b584791.1ec8-14 0 LOG:  00000: server process (PID 15992) was terminated by signal 6: Aborted\r\n2018-07-26 00:46:54 JST 7880 5b584791.1ec8-15 0 DETAIL:  Failed process was running: update inv\r\n             SET inv_status = $1,\r\n              modified_id = $2,\r\n              modified_at = $3,\r\n              version_no = version_no + 1\r\n            where inv_id = $4\r\n            and version_no = $5\r\n2018-07-26 00:46:54 JST 7880 5b584791.1ec8-16 0 LOCATION:  LogChildExit, postmaster.c:3627\r\n2018-07-26 00:46:54 JST 7880 5b584791.1ec8-17 0 LOG:  00000: terminating any other active server processes\r\n2018-07-26 00:46:54 JST 7880 5b584791.1ec8-18 0 LOCATION:  HandleChildCrash, postmaster.c:3347\r\n```\r\n\r\n上記のupdate はpgroongaのindexが設定されているフィールドではありません。\r\n\r\nバージョン：\r\n\r\npostgresql10-server-10.4-1PGDG.rhel7.x86_64\r\npgroonga 2.1.0 (24a49d9)\r\nPostgreSQL: 10\r\nOS: CentOS 7\r\n\r\n設定：\r\npgroonga.enable_wal = off (default)\r\n"},"comment":{"url":"https://api.github.com/repos/pgroonga/pgroonga/issues/comments/409057505","html_url":"https://github.com/pgroonga/pgroonga/issues/77#issuecomment-409057505","issue_url":"https://api.github.com/repos/pgroonga/pgroonga/issues/77","id":409057505,"node_id":"MDEyOklzc3VlQ29tbWVudDQwOTA1NzUwNQ==","user":{"login":"aeg","id":85253,"node_id":"MDQ6VXNlcjg1MjUz","avatar_url":"https://avatars0.githubusercontent.com/u/85253?v=4","gravatar_id":"","url":"https://api.github.com/users/aeg","html_url":"https://github.com/aeg","followers_url":"https://api.github.com/users/aeg/followers","following_url":"https://api.github.com/users/aeg/following{/other_user}","gists_url":"https://api.github.com/users/aeg/gists{/gist_id}","starred_url":"https://api.github.com/users/aeg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aeg/subscriptions","organizations_url":"https://api.github.com/users/aeg/orgs","repos_url":"https://api.github.com/users/aeg/repos","events_url":"https://api.github.com/users/aeg/events{/privacy}","received_events_url":"https://api.github.com/users/aeg/received_events","type":"User","site_admin":false},"created_at":"2018-07-31T00:46:43Z","updated_at":"2018-07-31T00:46:43Z","author_association":"NONE","body":"ありがとうございます。本issue について、update 10万回を2並行で実施して、再現をさせていたのですが、今回、その試行を2回実施しても、本事象が再現しませんでした。\r\nソースを更新していただいた結果、発生しなくなったと考えてよさそうでしょうか。"}}
{"actor":{"display_login":"aeg"}}