unixODBC Pooling and unicode #35
Comments
|
On 04/02/2020 09:36, partyzan543 wrote:
Good afternoon!
Sorry for my poor English, but I have no one else to ask.
I use zabbix which accesses oracle through unixODBC.
If the request body contains unicode characters (select 'Кириллица'
from dual;)
and Pooling is enabled (CPTimeout = 120) then in response I get 'теÑ
Ñ ‚'
Otherwise, if #CPTimeout then in response I get a 'Кириллица'
If using isql, then in both cases I get a 'Кириллица'
Do you have any suggestions on how to fix this?
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#35?email_source=notifications&email_token=ABYK62NL2IYEQZRNJ2WXUJDRBEZINA5CNFSM4KPTRL6KYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4IK2XSBQ>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABYK62LCPRPGG225JHNQANDRBEZINANCNFSM4KPTRL6A>.
Hi,
Can I check which version of the driver manager you have?
…--
Nick
|
|
Used unixODBC 2.3.7 |
|
On 04/02/2020 10:16, partyzan543 wrote:
Used unixODBC 2.3.7
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#35?email_source=notifications&email_token=ABYK62PWG5G5GBE2L4X3ULLRBE6APA5CNFSM4KPTRL6KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKXCGSI#issuecomment-581837641>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABYK62I5OGTCGVZUJM2SPZDRBE6APANCNFSM4KPTRL6A>.
Would it be possible to see your DSN config and also a driver manager
trace of the query being done from zabbix?
…--
Nick
|
|
odbc.ini [Oracle12p] |
|
I also want to supplement the information. At the first application call (zabbix server) and CPTimeout = 300 enabled, the output is normal ('Кириллица'). But after the second call we get again 'Ñ‚ÐµÑ Ñ ‚ |
|
On 04/02/2020 10:31, partyzan543 wrote:
Thanks. I will try and reproduce this. I suspect it may be related to
the setup of iconv (I think the Oracle driver only exports the W
functions). A log of the calls being made would be helpful.
Can you also try the 2.3.8pre that's the current dev version. It maybe
that a change in that to iconv init will make a difference, if not you
will still need to use the current version to get any fix I find.
…--
Nick
odbc.ini
[ZBX]
Driver=Oracle12p
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
BindAsFLOAT=F
CloseCursor=F
DSN=XE2
DisableDPM=F
DisableMTS=T
EXECSchemaOpt=
EXECSyntax=T
Failover=T
FailoverDelay=10
FailoverRetryCount=10
FetchBufferSize=64000
ForceWCHAR=F
Lobs=T
Longs=T
MetadataIdDefault=F
QueryTimeout=T
ResultSets=T
ServerName=ZBXDBP.world
SQLGetData extensions=F
Translation DLL=
Translation Option=0
DisableRULEHint=T
UserID=user
PASSWORD=password
########################
odbcinst.ini
[ODBC]
Trace=Yes
Trace File=/tmp/sql.log
Pooling=Yes
[Oracle12p]
Description=Oracle ODBC driver for Oracle 12g 64bit
Driver=/usr/lib/oracle/12/lib/libsqora.so.12.1
CPTimeout = 300
DontDLClose = 1
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#35?email_source=notifications&email_token=ABYK62IAUNX6XDFQUSLC4F3RBE7ZBA5CNFSM4KPTRL6KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKXDUII#issuecomment-581843489>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABYK62N24QBSOZ4BPP6OCCDRBE7ZBANCNFSM4KPTRL6A>.
|
|
On 04/02/2020 10:40, partyzan543 wrote:
I also want to supplement the information. At the first application
call (zabbix server) and CPTimeout = 300 enabled, the output is normal
('Кириллица'). But after the second call we get again 'Ñ‚ÐµÑ Ñ ‚
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#35?email_source=notifications&email_token=ABYK62JO36RYTASNLJQIM6DRBFAY5A5CNFSM4KPTRL6KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKXEN2I#issuecomment-581846761>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABYK62LLGZNCYSXPBY4IGP3RBFAY5ANCNFSM4KPTRL6A>.
Ok, so I have just fixed a bug with iconv reuse and pooling. I can't say
for certain that its "your" problem, but it was "a" problem, and it may
well be related.
Give the current 2.3.8pre (git or tar on ftp site) a try.
…--
Nick
|
|
Thanks a lot! i will be try |
|
Good day! After the build 2.3.8pre, the zabbix-proxy proxy crashes. I tried changing the sources of 2.3.7 in accordance with the changes, but after the build, the proxy also crashes. Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ... |
|
On 05/02/2020 06:54, partyzan543 wrote:
Good day!
After the build 2.3.8pre, the zabbix-proxy proxy crashes.
Ok, again, can I see a driver manager trace of what lead up to that so I
can try and replicate the problem.
…--
Nick
|
|
[ODBC][20286][1580899002.774431][SQLFreeHandle.c][290] [ODBC][20286][1580899021.777775][SQLAllocHandle.c][513] [ODBC][20286][1580899062.787132][SQLAllocHandle.c][513] |
|
Crashes occurs when checking the third metric. |
|
On 05/02/2020 11:09, partyzan543 wrote:
Crashes occurs when checking the third metric.
(When opening a new connection, everything worked well in 2.3.7)
Prior to the commit, the second and further iterations gave unreadable
characters, and now the second iteration gives the Cyrillic alphabet
normally.
But when you try to use the connection a third time - crashes.
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#35?email_source=notifications&email_token=ABYK62NTUIZDWSQVBWHFPILRBKM5LA5CNFSM4KPTRL6KYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEK3BGJY#issuecomment-582357799>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ABYK62NAPBV3RZG4FDB4FH3RBKM5LANCNFSM4KPTRL6A>.
Ok, pushed a small (but hopefully important) change, can you try now.
…--
Nick
|
|
Thank you very much,Nick. All works! |
|
Now everything is ok with the Cyrillic characters, and proxy no crashes,but the memory leak on the proxy is ~ 2GB per hour. This is a lot. It seems that the value memory buffer is not cleared. On 2.3.7 and enabled pooling, there was no leak at all. |
|
I compiled 2.3.7 to reflect the changes in SQLConnect.c. Cyrillic characters work, proxy does not crashes, and memory does not leak. |
Good afternoon!
Sorry for my poor English, but I have no one else to ask.
I use zabbix which accesses oracle through unixODBC.
If the request body contains unicode characters (select 'Кириллица' from dual;)
and Pooling is enabled (CPTimeout = 120) then in response I get 'Ñ‚ÐµÑ Ñ ‚'
Otherwise, if #CPTimeout then in response I get a 'Кириллица'
If using isql, then in both cases I get a 'Кириллица'
Do you have any suggestions on how to fix this?
The text was updated successfully, but these errors were encountered: