Skip Menu |
 

This queue is for tickets about the Apache-DBI CPAN distribution.

Report information
The Basics
Id: 31046
Status: open
Priority: 0/
Queue: Apache-DBI

People
Owner: pgollucci [...] p6m7g8.com
Requestors: adam.prime [...] utoronto.ca
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: (no value)
Fixed in: (no value)



Subject: LongReadLen and DBD::Sybase
Download (untitled) / with headers
text/plain 767b
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.
Can you give me some more context here ? (aka code, and actual message from log) ?
From: adam.prime [...] utoronto.ca
Download (untitled) / with headers
text/plain 686b
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.
From: adam.prime [...] utoronto.ca
Download (untitled) / with headers
text/plain 595b
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.
Have you run into this issue recently Adam?
Download (untitled) / with headers
text/plain 237b
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.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.