Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Executing DML & DDL combination via PostgresSQL ODBC to pgpool fails with 'WARNING: child process with pid: 24870 was terminated by segmentation fault' #33

Open
VenkatrjSAS opened this issue Sep 10, 2019 · 1 comment
Open

Executing DML & DDL combination via PostgresSQL ODBC to pgpool fails with 'WARNING: child process with pid: 24870 was terminated by segmentation fault' #33

VenkatrjSAS opened this issue Sep 10, 2019 · 1 comment

Comments

@VenkatrjSAS
Copy link

Executing DML & DDL combination via PostgresSQL ODBC to pgpool fails with 'WARNING: child process with pid: 24870 was terminated by segmentation fault'

By defult we config pgpool's load_balance_mode is off.

Looks like pgpool is doing load balance when it sees SELECT statement even though load_balance_mode is off.

==================================
Version:

  • pgpool-II version 4.0.6
  • postgres (PostgreSQL) 11.5
  • PostgresSQL psqlodbc-11.01.0000

==================================
pgpool erorr in the log file:

2019-09-10 10:22:09: pid 20205: LOG: fork a new child process with pid: 24870
2019-09-10 10:22:18: pid 24870: LOG: pool_send_and_wait: Error or notice message from backend: : DB node id: 0 backend pid: 24885 statement: "CREATE INDEX "USERS_AUTH_ID_INDEX" ON "ENTITIES" ( "AUTH_ID" )" message: "relation "USERS_AUTH_ID_INDEX" already exists"
2019-09-10 10:22:18: pid 20205: WARNING: child process with pid: 24870 was terminated by segmentation fault
2019-09-10 10:22:18: pid 20205: LOG: fork a new child process with pid: 24888
2019-09-10 10:22:18: pid 19153: WARNING: ssl read: EOF detected
2019-09-10 10:22:18: pid 19153: ERROR: unable to read data from frontend
2019-09-10 10:22:18: pid 19153: DETAIL: socket read failed with an error "Success"

==================================
pgpool.conf:

egrep -i 'load|white|black' pgpool.conf

Whitespace may be used. Comments are introduced with "#" anywhere on a line.

server for the changes to take effect, or use "pgpool reload". Some

                               # Weight for backend 0 (only in load balancing mode)
                               # load_balance_mode.

LOAD BALANCING MODE

load_balance_mode = on
# Activate load balancing mode
ignore_leading_white_space = on
# Ignore leading white spaces of each query
white_function_list = ''
black_function_list = 'currval,lastval,nextval,setval'
black_query_pattern_list = ''
# if on, ignore SQL comments when judging if load balance or
disable_load_balance_on_write = 'transaction'
# Load balance behavior when write query is issued
# subsequent read queries will not be load balanced
# will not be load balanced until the session ends.
# not be load balanced until the session ends.
# thus increases load of master.
# thus increases load of master.
white_memqcache_table_list = ''
black_memqcache_table_list = ''
load_balance_mode = off # Added through Consul-template

=========================================================================
DML & DDL Calls via PostgresSQL ODBC driver to pgpool summary:

In:        ConnectionHandle=0x7fffea45b960, WindowHandle=0, InConnectionString=`tracefile=/tmp/fun.croc;traceflags=319;CONOPTS=(SSLMode=require;pqopt={sslrootcert=/opt/<MaskedPath>/cacerts/trustedcerts.pem});DRIVER=POSTGRES;CATALOG=FB;DATABASE='DA_SYSCAT_default';;UID=dbmsowner;PWD=<Removed>;SERVER=cole-test2-onpremnnnnn.com;PORT=5431`, StringLength1=TKTS_NTS, OutConnectionString=0, BufferLength=0, StringLength2Ptr=0, DriverCompletion=TKTS_DRIVER_NOPROMPT=0
In:        StatementHandle=0x7fffea494640, Sql=`SET SESSION CLIENT_MIN_MESSAGES=WARNING;`, SqlL=40
In:        StatementHandle=0x7fffea494640, Sql=`CREATE SCHEMA  IF NOT EXISTS "FS_SYSCAT";`, SqlL=41
In:        StatementHandle=0x7fffea494640, Sql=`SET SCHEMA 'FS_SYSCAT';`, SqlL=23

In:        ConnectionHandle=0x7fffdfd9a8e0, WindowHandle=0, InConnectionString=`tracefile=/tmp/fun.croc;traceflags=319;CONOPTS=(SSLMode=require;pqopt={sslrootcert=/opt/<MaskedPath>/cacerts/trustedcerts.pem});DRIVER=POSTGRES;CATALOG=FB;DATABASE='DA_SYSCAT_default';;UID=dbmsowner;PWD=<Removed>;SERVER=cole-test2-onpremnnnnn.com;PORT=5431`, StringLength1=TKTS_NTS, OutConnectionString=0, BufferLength=0, StringLength2Ptr=0, DriverCompletion=TKTS_DRIVER_NOPROMPT=0
In:        StatementHandle=0x7fffdfd9e0e0, Sql=`SET SESSION CLIENT_MIN_MESSAGES=WARNING;`, SqlL=40
In:        StatementHandle=0x7fffdfd9e0e0, Sql=`SET SCHEMA 'FS_SYSCAT';`, SqlL=23
In:        StatementHandle=0x7fffdfd9e0e0, Sql=`select "VERSION" from "DATA_SERVICES" where "DS_ID"=1`, SqlL=53
In:        StatementHandle=0x7fffdfd9e0e0, Sql=`SELECT * FROM "DATA_SERVICES" WHERE 1=0`, SqlL=39
In:        StatementHandle=0x7fffdfd9e0e0, Sql=`CREATE INDEX "USERS_AUTH_ID_INDEX" ON "ENTITIES" ( "AUTH_ID" )`, SqlL=62
In:        StatementHandle=0x7fffdfd9e0e0, Sql=`CREATE INDEX "USERS_ENTITY_ID_INDEX" ON "ENTITIES" ( "ENTITY_ID" )`, SqlL=66

==================
ODBC log:

Processing input file /home/centos/t9.croc

TKTSAllocHandle:
In: HandleType = TKTS_HANDLE_ENV=1, InputHandle = TKTS Extension Handle=0x7f04341645c0, OutputHandlePtr = VALID
Return: TKTS_SUCCESS = 0
Out: *OutputHandlePtr = henv1=0x7f043417a0a0
TKTSAllocHandle:
In: HandleType = TKTS_HANDLE_DBC=2, InputHandle = henv1=0x7f043417a0a0, OutputHandlePtr = VALID
Return: TKTS_SUCCESS = 0
Out: *OutputHandlePtr = hdbc1=0x7f043417c940
TKTSDriverConnect:
In: ConnectionHandle = hdbc1=0x7f043417c940, WindowHandle = TKTS_NULL_HANDLE=0,
InConnectionstring = tracefile=/tmp/fun.croc;traceflags=319;CONOPTS=(SSLMode=require;pqopt={sslrootcert=/opt/<MaskedPath>/cacerts/trustedcerts.pem});DRIVER=POSTGRES;CATALOG=FB;DATABASE='DA_SYSCAT_default';;UID=dbmsowner;PWD=<Removed>;SERVER=cole-test2-onpremnnnnn.com;PORT=5431,
StringLength1 = TKTS_NTS=-3, OutConnectionString = NULL=0, BufferLength = 0, StringLength2Ptr = NULL=0, DriverCompletion = TKTS_DRIVER_NOPROMPT=0
Return: TKTS_SUCCESS_WITH_INFO = 0x80fff801
dbc: szSqlState = 01S02, *pfNativeError = -2130708291, *pcbErrorMsg = 25
MessageText = Current catalog set to FB
TKTSSetConnectAttr:
In: ConnectionHandle = hdbc1=0x7f043417c940, Attribute = TKTS_ATTR_AUTOCOMMIT=102, ValuePtr = TKTS_AUTOCOMMIT_ON=1, StringLength = TKTS_IS_UINTEGER=-5
Return: TKTS_SUCCESS = 0
TKTSAllocHandle:
In: HandleType = TKTS_HANDLE_STMT=3, InputHandle = hdbc1=0x7f043417c940, OutputHandlePtr = VALID
Return: TKTS_SUCCESS = 0
Out: *OutputHandlePtr = hstmt1=0x7f0425306c00

TKTSExecDirect:
In: StatementHandle = hstmt1=0x7f0425306c00, StatementText = SET SESSION CLIENT_MIN_MESSAGES=WARNING;, TextLength = 40
Return: TKTS_SUCCESS = 0

TKTSExecDirect:
In: StatementHandle = hstmt1=0x7f0425306c00, StatementText = CREATE SCHEMA IF NOT EXISTS "FS_SYSCAT";, TextLength = 41
Return: TKTS_SUCCESS = 0

TKTSExecDirect:
In: StatementHandle = hstmt1=0x7f0425306c00, StatementText = SET SCHEMA 'FS_SYSCAT';, TextLength = 23
Return: TKTS_SUCCESS = 0

TKTSFreeHandle:
In: HandleType = TKTS_HANDLE_STMT=3, Handle = hstmt1=0x7f0425306c00
Return: TKTS_SUCCESS = 0
TKTSAllocHandle:
In: HandleType = TKTS_HANDLE_DBC=2, InputHandle = henv1=0x7f043417a0a0, OutputHandlePtr = VALID
Return: TKTS_SUCCESS = 0
Out: *OutputHandlePtr = hdbc2=0x7f04253070e0
TKTSGetConnectAttr:
In: ConnectionHandle = hdbc2=0x7f04253070e0, Attribute = =20000, ValuePtr = VALID, BufferLength = TKTS_IS_POINTER=-4, StringLengthPtr = VALID
Return: TKTS_SUCCESS = 0
Out: *ValuePtr = 0, *StringLengthPtr = 8
TKTSDriverConnect:
In: ConnectionHandle = hdbc2=0x7f04253070e0, WindowHandle = TKTS_NULL_HANDLE=0,
InConnectionstring = tracefile=/tmp/fun.croc;traceflags=319;CONOPTS=(SSLMode=require;pqopt={sslrootcert=/opt/<MaskedPath>/cacerts/trustedcerts.pem});DRIVER=POSTGRES;CATALOG=FB;DATABASE='DA_SYSCAT_default';;UID=dbmsowner;PWD=<Removed>;SERVER=cole-test2-onpremnnnnn.com;PORT=5431,
StringLength1 = TKTS_NTS=-3, OutConnectionString = NULL=0, BufferLength = 0, StringLength2Ptr = NULL=0, DriverCompletion = TKTS_DRIVER_NOPROMPT=0
Return: TKTS_SUCCESS_WITH_INFO = 0x80fff801
dbc: szSqlState = 01S02, *pfNativeError = -2130708291, *pcbErrorMsg = 25
MessageText = Current catalog set to FB
TKTSSetConnectAttr:
In: ConnectionHandle = hdbc2=0x7f04253070e0, Attribute = TKTS_ATTR_AUTOCOMMIT=102, ValuePtr = TKTS_AUTOCOMMIT_ON=1, StringLength = TKTS_IS_UINTEGER=-5
Return: TKTS_SUCCESS = 0
TKTSAllocHandle:
In: HandleType = TKTS_HANDLE_STMT=3, InputHandle = hdbc2=0x7f04253070e0, OutputHandlePtr = VALID
Return: TKTS_SUCCESS = 0
Out: *OutputHandlePtr = hstmt2=0x7f0425311d00

TKTSExecDirect:
In: StatementHandle = hstmt2=0x7f0425311d00, StatementText = SET SESSION CLIENT_MIN_MESSAGES=WARNING;, TextLength = 40
Return: TKTS_SUCCESS = 0

TKTSExecDirect:
In: StatementHandle = hstmt2=0x7f0425311d00, StatementText = SET SCHEMA 'FS_SYSCAT';, TextLength = 23
Return: TKTS_SUCCESS = 0

TKTSFreeHandle:
In: HandleType = TKTS_HANDLE_STMT=3, Handle = hstmt2=0x7f0425311d00
Return: TKTS_SUCCESS = 0
TKTSAllocHandle:
In: HandleType = TKTS_HANDLE_STMT=3, InputHandle = hdbc1=0x7f043417c940, OutputHandlePtr = VALID
Return: TKTS_SUCCESS = 0
Out: *OutputHandlePtr = hstmt3=0x7f0425311d00
TKTSFreeStmt:
In: StatementHandle = hstmt3=0x7f0425311d00, Option = TKTS_CLOSE=0
Return: TKTS_SUCCESS = 0

TKTSExecDirect:
In: StatementHandle = hstmt3=0x7f0425311d00, StatementText = select "VERSION" from "DATA_SERVICES" where "DS_ID"=1, TextLength = 53
Return: TKTS_SUCCESS = 0

TKTSBindCol:
In: StatementHandle = hstmt3=0x7f0425311d00, ColumnNumber = 1, TargetType = TKTS_C_TKCHAR=3, TargetValuePtr = VALID, BufferLength = 1024, StrLen_or_IndPtr = VALID
Return: TKTS_SUCCESS = 0
TKTSFetch:
In: StatementHandle = hstmt3=0x7f0425311d00
Return: TKTS_SUCCESS = 0
TKTSFreeStmt:
In: StatementHandle = hstmt3=0x7f0425311d00, Option = TKTS_CLOSE=0
Return: TKTS_SUCCESS = 0
TKTSFreeHandle:
In: HandleType = TKTS_HANDLE_STMT=3, Handle = hstmt3=0x7f0425311d00
Return: TKTS_SUCCESS = 0
TKTSAllocHandle:
In: HandleType = TKTS_HANDLE_STMT=3, InputHandle = hdbc1=0x7f043417c940, OutputHandlePtr = VALID
Return: TKTS_SUCCESS = 0
Out: *OutputHandlePtr = hstmt4=0x7f041b49e6a0
TKTSPrepare:
In: StatementHandle = hstmt4=0x7f041b49e6a0, StatementText = SELECT * FROM "DATA_SERVICES" WHERE 1=0, TextLength = 39
Return: TKTS_SUCCESS = 0
TKTSFreeStmt:
In: StatementHandle = hstmt4=0x7f041b49e6a0, Option = TKTS_UNPREPARE=101
Return: TKTS_SUCCESS = 0

TKTSExecDirect:
In: StatementHandle = hstmt4=0x7f041b49e6a0, StatementText = CREATE INDEX "USERS_AUTH_ID_INDEX" ON "ENTITIES" ( "AUTH_ID" ), TextLength = 62
Return: TKTS_ERROR = 0x80fff802
stmt: szSqlState = 42P07, *pfNativeError = 1, *pcbErrorMsg = 92, *ColumnNumber = -2, *RowNumber = 0
MessageText = ERROR: ERROR: relation "USERS_AUTH_ID_INDEX" already exists; Error while executing the query

TKTSExecDirect:
In: StatementHandle = hstmt4=0x7f041b49e6a0, StatementText = CREATE INDEX "USERS_ENTITY_ID_INDEX" ON "ENTITIES" ( "ENTITY_ID" ), TextLength = 66
Return: TKTS_ERROR = 0x80fff802
stmt: szSqlState = 08S01, *pfNativeError = 35, *pcbErrorMsg = 174, *ColumnNumber = -2, *RowNumber = 0
MessageText = ERROR: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. ; The connection has been lost

TKTSFreeHandle:
In: HandleType = TKTS_HANDLE_STMT=3, Handle = hstmt4=0x7f041b49e6a0
Return: TKTS_SUCCESS = 0
TKTSEndTran:
In: HandleType = TKTS_HANDLE_DBC=2, Handle = hdbc1=0x7f043417c940, CompletionType = TKTS_ROLLBACK=1
Return: TKTS_SUCCESS = 0

Done!

==================================
Wrokaround:

Reason is when we pass a hint i.e. /NO LOAD BALANCE/ with SELECT statement pgpool dose not terminate child process with segmentation fault.
But without the hint it dose fail.

==================================
SELECT with Hint:

TKTSPrepare:
In: StatementHandle = hstmt4=0x7fd050948d00, StatementText = /*NO LOAD BALANCE*/ SELECT * FROM "DATA, TextLength = 39
@pgpool-tmp
Copy link
Collaborator

We do not accept issues on Github. Please visit https://pgpool.net/mediawiki/index.php/Bug_tracking_system to file a bug report.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@pgpool-tmp @VenkatrjSAS