Re: [Sqlrelay-discussion] SIGSEGV when trying to create temporary table

[Devananda <kar...@ya...>]

David Muse wrote:
> Ever figure out anything out on this?

Push the responsibility onto the application :)

Not a real solution, but a quick one, and afaiac, it's not 
objectionable. Applications, and their programmers, shouldn't rely on a 
framework or connection method to clean up after them (though it is nice 
when they do).

I made a stub for checkForTempTable function in mysqlconnection.C 
(simply "return;"), and told the application developers here that they 
/must/ clean up their own temp tables. Since I sign off on all their SQL 
statements, I'll be able to ensure that they do.

Regards,
Devananda



> 
> Dave
> dav...@fi...
> 
> On Fri, 2006-07-07 at 13:14 -0700, Devananda wrote:
>> When sending CREATE TEMPORARY TABLE... either from PHP, or through 
>> sqlrhsh, the sqlr-connection segfaults. I ran the connection process in 
>> gdb, and received the following info:
>>
>> Program received signal SIGSEGV, Segmentation fault.
>> [Switching to Thread 2596304 (LWP 4296)]
>> 0x0093fa39 in sqlrcursor_svr::checkForTempTable ()
>>    from /usr/local/firstworks/lib/libsqlrconnection_debug-0.37.so.1
>>
>> The version of sql relay in which this happened is a slightly old 0.37, 
>> connecting to both MySQL 4.1.18 and 5.0.22 (the segfault happens with 
>> both connections). I will attempt to verify that this affects the latest 
>> sqlrelay (pulled from CVS) as soon as I can hammer out a library issue 
>> (probably early next week).
>>
>>
>> Regards,
>> Devananda vdv
>>
>> Using Tomcat but need to do more? Need to support web services, security?
>> Get stuff done quickly with pre-integrated technology to make your job easier
>> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
> 
>