At a first look it most likely is my new
ora_ncs_buff_mtpl /ORA_DBD_NCS_BUFFER might be the source of the problem
byt default it is 1 which may be too small.
Can you set the ORA_DBD_NCS_BUFFER to 2 then 3 and 4 to see if it
cleans up the problem
My guess is that 1 is too small and I might have to make it 2 to cover
more bases.
cheers
John Scoles
Martin Evans wrote:
John Scoles wrote:
Thank Charles that is really good stuff
I have not investigated the
NLS_LANG=.WE8ISO8859P1, but the tests 30long.t and 31lob_extended.t
still fail badly if NLS_LANG=.AL32UTF8.
bug yet as my local test box is just US7ASCII.
BTW can you tell me what the '
NLS_CHARACTERSET and
NLS_NCHAR_CHARACTERSET
setting of your Oralcle DB you are testing on
I will have to do that later today or tonight as I have to install a
different version or Oracle to get that to fail (I hope)
If you can set $dbh->{dbd_verbose}=15 just before the test start to fail in
30long.t and 31lob_extended.t
and send me the results I will have something more to go on.
Look for another RC in the next day or two.
Cheers
Jardine wrote:
On 14/01/10 12:19, Charles Jardine wrote:
On 12/01/10 12:07, John Scoles wrote:
Ok third time is a Charm
The Third RC of the beer edition of DBD::Oracle 1.24 can be found at
http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.24-RC3.tar
This round has a few little patches from Martin Evans on it.
Please test and enjoy
My environment is Linux x86-64, Perl 5.10.1 (64 bit), DBI 1.609,
Oracle 10.2.0.4.2 (64 bit). Database charset UTF8, national
charset AL16UTF16
Three things:
[snip]
3. Here is a patch which removes the remaining warnings detected by
gcc in 64-bit mode.
[snip]
I realise that something has wrapped the very long lines in the patch,
so I am trying again, sending the patch as an attachment.
For me tests 40long.t and 30lob_extended.t also fail when $NLS_LANG is
AMERICAN_AMERICA.AL32UTF8. The values of NLS_CHARACTERSET and
NLS_NCHAR_CHARACTERSET in my database are:
AL32UTF8 and
UTF8
as the test output below shows.
The errors I get are:
prove -vb t/30long.t
t/30long.t ..
1..479
# ora_server_version: 11 1 0 6 0
# Database 11.1.0.6.0 CHAR set is AL32UTF8 (Unicode), NCHAR set is UTF8
(Unicode)
# Client 11.1.0.6 NLS_LANG is 'AMERICAN_AMERICA.AL32UTF8', NLS_NCHAR is
'<unset>'
#
#
=========================================================================
# Running long test for LONG (0) use_utf8_data=0
# create table dbd_ora__drop_me ( idx integer, lng LONG, dt date )
# long_data[0] length 10240
# long_data[1] length 81920
# long_data[2] length 71680
# --- insert some LONG data (ora_type 0)
ok 1 - prepare: insert into dbd_ora__drop_me values (?, ?, SYSDATE)
ok 2 - insert long data 40
ok 3 - insert long data 41
ok 4 - insert long data 42
ok 5 - insert long data undef 43
# --- fetch LONG data back again -- truncated - LongTruncOk == 1
# LongReadLen 20, LongTruncOk 1
ok 6 - prepare: select * from dbd_ora__drop_me order by idx
ok 7 - execute: select * from dbd_ora__drop_me order by idx
ok 8 - fetch_arrayref for select * from dbd_ora__drop_me order by idx
ok 9 - four rows
ok 10 - byte_string test of truncated to LongReadLen 20
ok 11 - nice_string test of truncated to LongReadLen 20
ok 12 - LONG UTF8 setting
ok 13 - byte_string test of truncated to LongReadLen 20
ok 14 - nice_string test of truncated to LongReadLen 20
ok 15 - LONG UTF8 setting
ok 16 - byte_string test of truncated to LongReadLen 20
ok 17 - nice_string test of truncated to LongReadLen 20
ok 18 - LONG UTF8 setting
ok 19 - last row undefined
ok 20 - prepare select * from dbd_ora__drop_me order by idx
# --- fetch LONG data back again -- truncated - LongTruncOk == 0
# LongReadLen 81910, LongTruncOk
ok 21 - execute select * from dbd_ora__drop_me order by idx
ok 22 - fetchrow_arrayref select * from dbd_ora__drop_me order by idx
ok 23 - length tmp->[1] 10240
ok 24 - truncation error not triggered (LongReadLen 81910, data 10240)
ok 25 - tmp==1406 || tmp==24345 tmp actually=24345
# --- fetch LONG data back again -- complete - LongTruncOk == 0
# LongReadLen 82920, LongTruncOk
ok 26 - prepare: select * from dbd_ora__drop_me order by idx
ok 27 - execute select * from dbd_ora__drop_me order by idx
ok 28 - fetchrow_arrayref select * from dbd_ora__drop_me order by idx
ok 29 - Strings are identical, Len 10240
ok 30 - fetchrow_arrayref select * from dbd_ora__drop_me order by idx
ok 31 - Strings are identical, Len 10240
ok 32 - fetchrow_arrayref select * from dbd_ora__drop_me order by idx
ok 33 - Strings are identical, Len 10240
ok 34 # skip blob_read tests for LONGs - not currently supported
<snipped - all the same>
ok 94 # skip ora_auto_lob tests for LONGs - not supported
#
#
=========================================================================
# Running long test for LONG RAW (24) use_utf8_data=0
ok 95 - prepare: insert into dbd_ora__drop_me values (?, ?, SYSDATE)
# create table dbd_ora__drop_me ( idx integer, lng LONG RAW, dt date )
# long_data[0] length 20480
# long_data[1] length 81920
# long_data[2] length 71680
# --- insert some LONG RAW data (ora_type 24)
ok 96 - insert long data 40
ok 97 - insert long data 41
ok 98 - insert long data 42
ok 99 - insert long data undef 43
# --- fetch LONG RAW data back again -- truncated - LongTruncOk == 1
# LongReadLen 20, LongTruncOk 1
ok 100 - prepare: select * from dbd_ora__drop_me order by idx
ok 101 - execute: select * from dbd_ora__drop_me order by idx
ok 102 - fetch_arrayref for select * from dbd_ora__drop_me order by idx
ok 103 - four rows
ok 104 - byte_string test of truncated to LongReadLen 40
ok 105 - nice_string test of truncated to LongReadLen 40
ok 106 - LONG RAW UTF8 setting
ok 107 - byte_string test of truncated to LongReadLen 40
ok 108 - nice_string test of truncated to LongReadLen 40
ok 109 - LONG RAW UTF8 setting
ok 110 - byte_string test of truncated to LongReadLen 40
ok 111 - nice_string test of truncated to LongReadLen 40
ok 112 - LONG RAW UTF8 setting
ok 113 - last row undefined
ok 114 - prepare select * from dbd_ora__drop_me order by idx
# --- fetch LONG RAW data back again -- truncated - LongTruncOk == 0
# LongReadLen 40955, LongTruncOk
ok 115 - execute select * from dbd_ora__drop_me order by idx
ok 116 - fetchrow_arrayref select * from dbd_ora__drop_me order by idx
ok 117 - length tmp->[1] 20480
ok 118 - truncation error not triggered (LongReadLen 40955, data 20480)
ok 119 - tmp==1406 || tmp==24345 tmp actually=24345
# --- fetch LONG RAW data back again -- complete - LongTruncOk == 0
# LongReadLen 82920, LongTruncOk
ok 120 - prepare: select * from dbd_ora__drop_me order by idx
ok 121 - execute select * from dbd_ora__drop_me order by idx
ok 122 - fetchrow_arrayref select * from dbd_ora__drop_me order by idx
ok 123 - Strings are identical, Len 20480
ok 124 - fetchrow_arrayref select * from dbd_ora__drop_me order by idx
ok 125 - Strings are identical, Len 81920
ok 126 - fetchrow_arrayref select * from dbd_ora__drop_me order by idx
ok 127 - Strings are identical, Len 71680
ok 128 # skip blob_read tests for LONGs - not currently supported
<snipped all the same>
ok 188 # skip ora_auto_lob tests for LONG RAWs - not supported
#
#
=========================================================================
# Running long test for NCLOB (112) use_utf8_data=1
# create table dbd_ora__drop_me ( idx integer, lng NCLOB, dt date )
# long_data[0] length 10240
ok 189 - prepare: insert into dbd_ora__drop_me values (?, ?, SYSDATE)
# long_data[1] length 81920
# long_data[2] length 71680
# --- insert some NCLOB data (ora_type 112)
ok 190 - insert long data 40
ok 191 - insert long data 41
ok 192 - insert long data 42
ok 193 - insert long data undef 43
# --- fetch NCLOB data back again -- truncated - LongTruncOk == 1
# LongReadLen 20, LongTruncOk 1
ok 194 - prepare: select * from dbd_ora__drop_me order by idx
ok 195 - execute: select * from dbd_ora__drop_me order by idx
DBD::Oracle has returned a NEED_DATA status when doing a LobRead!!
DBD::Oracle::db disconnect failed: ORA-03127: no new operations allowed
until the active operation ends (DBD ERROR: OCISessionEnd) at t/30long.t
line 68.
# Looks like you planned 479 tests but ran 195.
# Looks like your test exited with 255 just after 195.
Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 284/479 subtests
(less 122 skipped subtests: 73 okay)
Test Summary Report
-------------------
t/30long.t (Wstat: 65280 Tests: 195 Failed: 0)
Non-zero exit status: 255
Parse errors: Bad plan. You planned 479 tests but ran 195.
Files=1, Tests=195, 0 wallclock secs ( 0.04 usr 0.00 sys + 0.12 cusr
0.01 csys = 0.17 CPU)
Result: FAIL
It is similar with 31lob_extended.t but as it is a shorter test and it
is easier to segregate the failure I've concentrated on that. I
commented out the first section of bracketed tests in 31lob_extended.t
and left the remaining one which fails. The output is:
prove -vb t/31lob_extended.t
t/31lob_extended.t ..
1..31
ok 1 - created test table
# create table dbd_ora__drop_me ( idx integer, x clob, dt date )
ok 2 - created test data
ok 3 - created test procedure
ok 4 - ora_auto_lobs not fetching prepare call proc
ok 5 - ora_auto_lobs not fetching - bind out cursor
ok 6 - ora_auto_lobs not fetching - execute to get out cursor
DBD::Oracle has returned a NEED_DATA status when doing a LobRead!!
procedure p_DBD_Oracle_drop_me possibly not dropped- check -
DBD::Oracle::db do failed: ORA-03127: no new operations allowed until
the active operation ends (DBD ERROR: OCIStmtExecute) [for Statement
"drop procedure p_DBD_Oracle_drop_me"] at t/31lob_extended.t line 175.
table dbd_ora__drop_me possibly not dropped - check - DBD::Oracle::db do
failed: ORA-03127: no new operations allowed until the active operation
ends (DBD ERROR: OCIStmtExecute) [for Statement " drop table
dbd_ora__drop_me "] at t/nchar_test_lib.pl line 204.
# Looks like you planned 31 tests but ran 6.
# Looks like your test exited with 255 just after 6.
DBD::Oracle::db DESTROY failed: ORA-03127: no new operations allowed
until the active operation ends (DBD ERROR: OCIStmtExecute)
ORA-03127: no new operations allowed until the active operation ends
(DBD ERROR: OCISessionEnd) at t/31lob_extended.t line 91.
Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 25/31 subtests
Test Summary Report
-------------------
t/31lob_extended.t (Wstat: 65280 Tests: 6 Failed: 0)
Non-zero exit status: 255
Parse errors: Bad plan. You planned 31 tests but ran 6.
Files=1, Tests=6, 0 wallclock secs ( 0.02 usr 0.00 sys + 0.05 cusr
0.01 csys = 0.08 CPU)
Result: FAIL
With verbose turned on I get the attached output.
This is not actually causing me a problem right now as it only seems to
happen when ora_auto_lob is on (default) and we mostly disable it.
Please let me know if there is anything else I can provide or do to help
nail this one.
Martin
