Re: Segmentation fault in case Debian9+odbc+pgsql10.6

Поиск
Список
Период
Сортировка
От Inoue, Hiroshi
Тема Re: Segmentation fault in case Debian9+odbc+pgsql10.6
Дата
Msg-id df758cac-e992-9cf1-9e01-da3568de9287@dream.email.ne.jp
обсуждение исходный текст
Ответ на Segmentation fault in case Debian9+odbc+pgsql10.6  (Yuriy Nasida <ynasida@gmail.com>)
Ответы Re: Segmentation fault in case Debian9+odbc+pgsql10.6
Список pgsql-odbc
Дерево обсуждения
Hi Yuriy,

The crash seems to be caused by setting log_min_duration_statement = 0 or log_duration = on
in postgresql.conf. The bug was fixed in 9.06.0100. Please avoid the setting in postgresql.conf
or upgrade the driver.

regards,
Hiroshi Inoue

On 2018/11/27 1:01, Yuriy Nasida wrote:
Hi guys,

FYI - I noted that i have not problems with Deb9+pgsql9 and with Deb8+pgsql10
But! I get segmentation fault in case  Debian9+odbc+pgsql10.6

Did you get something like this ?

Please look at some info below.

My odbc.ini:

[pgsqldsn]
Driver = /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
Database=dbname
Servername=ip
Port=5432
Username=root
Password=superpasswd
Debug=0
CommLog=1
UsageCount=1
RowVersioning=No
ShowSystemTables=No
ShowOidColumn=No
FakeOidIndex=No
ConnSettings=

odbc version:
odbc-postgresql:amd64             1:09.05.0400-2

# isql -v pgsqldsn
DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
Segmentation fault

Pgsql logs:

DEBUG:  forked new backend, pid=36868 socket=11
DEBUG:  postmaster child[36868]: starting with (
DEBUG:   postgres
DEBUG:  )
DEBUG:  InitPostgres
DEBUG:  my backend ID is 5
DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0
DEBUG:  received password packet
DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0
STATEMENT:  SET DateStyle = 'ISO'
DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
STATEMENT:  SET DateStyle = 'ISO'
LOG:  duration: 0.271 ms  statement: SET DateStyle = 'ISO'
DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0
STATEMENT:  SET extra_float_digits = 2
DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
STATEMENT:  SET extra_float_digits = 2
LOG:  duration: 0.171 ms  statement: SET extra_float_digits = 2
DEBUG:  unexpected EOF on client connection
DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
DEBUG:  shmem_exit(0): 6 on_shmem_exit callbacks to make
DEBUG:  proc_exit(0): 3 callbacks to make
DEBUG:  exit(0)
DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
DEBUG:  proc_exit(-1): 0 callbacks to make
DEBUG:  reaping dead processes
DEBUG:  server process (PID 36868) exited with exit code 0


Any advice ?
Thanks.


AVG のロゴ

このメールは、AVG アンチウイルス ソフトウェアでウイルス チェックされています。
www.avg.com


В списке pgsql-odbc по дате отправления: