Skip to content

Instantly share code, notes, and snippets.

@michelp
Last active January 12, 2019 18:16
Show Gist options
  • Select an option

  • Save michelp/0839d946bcfc5d752211ecd3e413c4ca to your computer and use it in GitHub Desktop.

Select an option

Save michelp/0839d946bcfc5d752211ecd3e413c4ca to your computer and use it in GitHub Desktop.
psql (11.1 (Debian 11.1-1.pgdg90+1))
Type "help" for help.
postgres=# \i test.sql
CREATE EXTENSION
CREATE EXTENSION
CREATE TABLE
INSERT 0 10
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
BEGIN
plan
------
1..1
(1 row)
lives_ok
-----------------
ok 1 - lives_ok
(1 row)
finish
--------
(0 rows)
psql:test.sql:22: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
psql:test.sql:22: connection to server was lost
michel@chrx:~/dev/pggraphblas$ docker exec -it pggraphblas-test-db /bin/bash bt
Reading symbols from /usr/lib/postgresql/11/bin/postgres...Reading symbols from /usr/lib/debug/.build-id/13/a8d9bf7adf2f48fb5def95ae81483190842721.debug...done.
done.
[New LWP 237]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
brCore was generated by `postgres:'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 0x0000000000000010 in ?? ()
(gdb) bt
#0 0x0000000000000010 in ?? ()
#1 0x000055a12aff332e in MemoryContextCallResetCallbacks (context=<optimized out>) at ./build/../src/backend/utils/mmgr/mcxt.c:314
#2 MemoryContextDelete (context=0x55a12d47ee00) at ./build/../src/backend/utils/mmgr/mcxt.c:229
#3 0x000055a12aff32ed in MemoryContextDeleteChildren (context=0x55a12c14b370) at ./build/../src/backend/utils/mmgr/mcxt.c:265
#4 0x000055a12aff3318 in MemoryContextDelete (context=0x55a12c14b370) at ./build/../src/backend/utils/mmgr/mcxt.c:221
#5 0x000055a12ac39464 in AtCleanup_Memory () at ./build/../src/backend/access/transam/xact.c:1766
#6 0x000055a12ac394fa in CleanupTransaction () at ./build/../src/backend/access/transam/xact.c:2682
#7 0x000055a12ac3d7da in CommitTransactionCommand () at ./build/../src/backend/access/transam/xact.c:2861
#8 0x000055a12aead4e5 in finish_xact_command () at ./build/../src/backend/tcop/postgres.c:2523
#9 0x000055a12aeaf173 in exec_simple_query (query_string=0x55a12c09b1c0 "rollback;") at ./build/../src/backend/tcop/postgres.c:1170
#10 0x000055a12aeb0f03 in PostgresMain (argc=<optimized out>, argv=argv@entry=0x55a12c0c5ab8, dbname=<optimized out>, username=<optimized out>)
at ./build/../src/backend/tcop/postgres.c:4182
#11 0x000055a12abbde00 in BackendRun (port=0x55a12c0bb8b0) at ./build/../src/backend/postmaster/postmaster.c:4361
#12 BackendStartup (port=0x55a12c0bb8b0) at ./build/../src/backend/postmaster/postmaster.c:4033
#13 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1706
#14 0x000055a12ae3bf43 in PostmasterMain (argc=1, argv=0x55a12c079560) at ./build/../src/backend/postmaster/postmaster.c:1379
#15 0x000055a12abbf2f4 in main (argc=1, argv=0x55a12c079560) at ./build/../src/backend/main/main.c:228
(gdb)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment