Bug #31046 for Apache-DBI: LongReadLen and DBD::Sybase

Wed Nov 28 20:01:52 2007 adam.prime [...] utoronto.ca - Ticket created

Subject:

LongReadLen and DBD::Sybase

I'm not entirely sure that this should actually be a bug report for Apache::DBI, but it's Apache::DBI code that's getting referenced in the error, so i'm putting it here. When using Apache::DBI with DBD::Sybase 1.08 and freetds 0.64, i get this line repeatedly in the error log. Setting of CS_OPT_TEXTSIZE failed. at /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm line 277. This happens whenever Apache::DBI attempts to reset LongReadLen to it's initial state. In order to not get the log spam i've just added a next if $key eq 'LongReadLen' into the code, but that's obviously not a good fix either (but fixes my log spam problem, and hasn't seemed to cause anything else too horrible. Everything still works alright, but the log spam isn't exactly desirable.

Thu May 15 23:46:27 2008 pgollucci [...] p6m7g8.com - Taken

Thu May 15 23:47:02 2008 pgollucci [...] p6m7g8.com - Correspondence added

Can you give me some more context here ? (aka code, and actual message from log) ?

Thu May 15 23:47:04 2008 The RT System itself - Status changed from 'new' to 'open'

Fri May 16 10:47:13 2008 adam.prime [...] utoronto.ca - Correspondence added

From:

adam.prime [...] utoronto.ca

On Thu May 15 23:47:02 2008, PGOLLUCCI wrote: Show quoted text

> Can you give me some more context here ? (aka code, and actual message > from log) ? >

Setting of CS_OPT_TEXTSIZE failed. at /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm line 277. is the actual error message from the log. As for code, i haven't gone to any length to narrow down what exactly was causing it. It'll be tuesday before i'm back in the office and have access to a machine to attempt narrow down the code to figure out what exactly was causing this. I was literally getting it on every query. It's quite possible that there is a 'set textsize' buried in our generic connect code, so it could possibly be related to that.

Wed May 21 11:04:17 2008 adam.prime [...] utoronto.ca - Correspondence added

From:

adam.prime [...] utoronto.ca

On Thu May 15 23:47:02 2008, PGOLLUCCI wrote: Show quoted text

> Can you give me some more context here ? (aka code, and actual message > from log) ? >

i just had a bit of a deeper look into this and it is indeed occurring when running $dbh->do("set textsize 512000"); using a DBD::Sybase handle. The error message is Setting of CS_OPT_TEXTSIZE failed. at /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm line 277. It looks to me as though this is something weird with DBD::Sybase and MS SQL though, since the code around 277 is just attempting to set all the DBI attributes back to their original values.

Sat Feb 06 20:02:41 2010 PHRED [...] cpan.org - Correspondence added

Have you run into this issue recently Adam?

Sat Feb 06 20:25:32 2010 adam.prime [...] utoronto.ca - Correspondence added

On Sat Feb 06 20:02:41 2010, PHRED wrote: Show quoted text

> Have you run into this issue recently Adam?

I no longer have to work with MS SQL Server, so i personally haven't run into into it lately. I'd be surprised if it was no longer an issue though.