View Issue Details

IDProjectCategoryView StatusLast Update
0007048Anastasisbackendpublic2022-09-26 20:50
ReporterFlorian Dold Assigned ToFlorian Dold  
PriorityhighSeveritycrashReproducibilityhave not tried
Status closedResolutionfixed 
Target Version0.3.0Fixed in Version0.3.0 
Summary0007048: backend frequently crashes during backups
DescriptionJust repeatedly doing backups (~ 5-10 times) triggers this for me.
Additional InformationCore was generated by `anastasis-httpd -L INFO -c test_reducer_42Zirto.conf'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 0x00007f6401923a44 in GNUNET_PQ_exec_statements (db=0x0, es=0x7fff27117340) at pq_exec.c:87
87 result = PQexec (db->conn,
(gdb) bt
#0 0x00007f6401923a44 in GNUNET_PQ_exec_statements (db=0x0, es=0x7fff27117340) at pq_exec.c:87
#1 0x00007f6400084f9b in begin_transaction (cls=0x556b76c46b00, name=0x7f640008d8a2 "update lifetime")
    at plugin_anastasis_postgres.c:653
#2 0x00007f6400086d56 in postgres_update_lifetime (cls=0x556b76c46b00, account_pub=0x7fff27117750,
    payment_identifier=0x556b76c0b6b8, eol=...) at plugin_anastasis_postgres.c:1254
#3 0x0000556b74ddba5e in AH_handler_policy_post (connection=0x556b76cc2360, hc=0x556b76c6c7e0,
    account_pub=0x7fff27117750, recovery_data=0x0, recovery_data_size=0x7fff271177a0)
    at anastasis-httpd_policy_upload.c:947
#4 0x0000556b74dd617d in url_handler (cls=0x0, connection=0x556b76cc2360,
    url=0x556b76c92ec5 "/policy/040X0KZ79FNXVQ81HYWCZW429CAXAEESKBT824VZ096YJE3DX65G", method=0x556b76c92ec0 "POST",
    version=0x556b76c92f02 "HTTP/1.1", upload_data=0x0, upload_data_size=0x7fff271177a0, con_cls=0x556b76cc23b8)
    at anastasis-httpd.c:386
#5 0x00007f64011909b1 in ?? () from /usr/lib/
#6 0x00007f6401192600 in ?? () from /usr/lib/
#7 0x00007f6401194aa0 in ?? () from /usr/lib/
#8 0x00007f6401198ea2 in ?? () from /usr/lib/
#9 0x00007f640119a7d1 in ?? () from /usr/lib/
#10 0x00007f640119b234 in MHD_run () from /usr/lib/
#11 0x0000556b74dd5c8b in run_daemon (cls=0x0) at anastasis-httpd.c:197
#12 0x00007f6401701781 in GNUNET_SCHEDULER_do_work (sh=0x556b76c09380) at scheduler.c:2144
#13 0x00007f64017026a7 in select_loop (sh=0x556b76c09380, context=0x7fff27117c30) at scheduler.c:2441
#14 0x00007f64016fc72a in GNUNET_SCHEDULER_run (task=0x7f64016f4ce0 <program_main>, task_cls=0x7fff27117d30)
    at scheduler.c:738
#15 0x00007f64016f5e26 in GNUNET_PROGRAM_run2 (argc=5, argv=0x7fff27118268,
    binaryName=0x556b74de85cc "anastasis-httpd", binaryHelp=0x556b74de85b3 "Anastasis HTTP interface",
    options=0x7fff27117f70, task=0x556b74dd6a68 <run>, task_cls=0x0, run_without_scheduler=0) at program.c:345
#16 0x00007f64016f5f85 in GNUNET_PROGRAM_run (argc=5, argv=0x7fff27118268,
    binaryName=0x556b74de85cc "anastasis-httpd", binaryHelp=0x556b74de85b3 "Anastasis HTTP interface",
--Type <RET> for more, q to quit, c to continue without paging--
    options=0x7fff27117f70, task=0x556b74dd6a68 <run>, task_cls=0x0) at program.c:372
#17 0x0000556b74dd76ee in main (argc=5, argv=0x7fff27118268) at anastasis-httpd.c:993
TagsNo tags attached.


Florian Dold

2021-10-20 00:16

manager   ~0018444

Relevant logs:

2021-10-20T00:04:40.422194+0200 pq-397239(2ABJNXAV92PSGFP939FF9MN3NM) ERROR Database connection to 'postgres:///anastasischeck4' failed: FATAL: sorry, too many clients already
2021-10-20T00:04:40.422225+0200 anastasis-httpd-397239(2ABJNXAV92PSGFP939FF9MN3NM) ERROR Assertion failed at plugin_anastasis_postgres.c:649.

Florian Dold

2021-11-03 19:15

manager   ~0018455

Fixed by making sure that stasis doesn't create an new DB connection (without even cleaning up!) for each query made.

Also, DB errors should now be properly propagated instead of leading to SIGSEGV.

Issue History

Date Modified Username Field Change
2021-10-20 00:05 Florian Dold New Issue
2021-10-20 00:06 Florian Dold Assigned To => Christian Grothoff
2021-10-20 00:06 Florian Dold Priority normal => high
2021-10-20 00:06 Florian Dold Severity minor => crash
2021-10-20 00:06 Florian Dold Status new => assigned
2021-10-20 00:06 Florian Dold Description Updated
2021-10-20 00:16 Florian Dold Note Added: 0018444
2021-11-03 19:13 Florian Dold Assigned To Christian Grothoff => Florian Dold
2021-11-03 19:15 Florian Dold Status assigned => resolved
2021-11-03 19:15 Florian Dold Resolution open => fixed
2021-11-03 19:15 Florian Dold Note Added: 0018455
2022-09-26 20:49 Christian Grothoff Fixed in Version => 0.3.0
2022-09-26 20:49 Christian Grothoff Target Version => 0.3.0
2022-09-26 20:50 Christian Grothoff Status resolved => closed