Skip to Content.
Sympa Menu

freetds - Re: Seg Faults talking to MS SQL 6.5

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Francis Smit <francis AT oztel.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Seg Faults talking to MS SQL 6.5
  • Date: Tue, 07 Mar 2000 09:45:04 +1100


I Guessed that it wasn't happy to have queries that
didn't return data sets, so I made sure it did, and all
was well, I think I was doing stored proc's at the
time.

"Mark T. Johns" wrote:

> Thank You very much! That did the trick.
>
> BTW, that is one of the strangest work-arounds. How did you discover it?
>
> Thanks, again,
>
> -Mark
>
> Francis Smit wrote:
> >
> > Oh I get that too, I'm going to MSSQL 7.0,
> > same thing the work around is, to put a select
> > in the sql, any old one will do, just so it returns
> > a data set, one row or no rows are fine.
> > i.e..
> >
> > $sql = "insert or such like\n";
> > $sql .= "silly select I know will be quick\n";
> >
> > that should work fine, it does for me.
> >
> > Mark Johns wrote:
> >
> > > Here is the scoop:
> > >
> > > We are experiencing problems with PHP, Apache, freeTDS, RH6.1, and
> > > MSSQL 6.5(NT4). We are able to connect, make SELECT queries, etc.
> > > Everything works great. The problem happens when we execute an INSERT,
> > > or an UPDATE query. The database on the remote system is updated
> > > correctly. However, the script segfaults, and never returns. This
> > > happens when using normal connects or persistent. I have attached a
> > > small script which exhibits this behaviour, and the TDSDUMP output.
> > >
> > > Please let me know what other information you may need.
> > >
> > > =========== script =================
> > > <html>
> > > <body>
> > > <?
> > > # The following line contains the SQL server hostname, the username, and
> > > # the password for connecting to the database.
> > >
> > > $db2 = mssql_connect("cfs_back","daf","987654321")
> > > or die("Unable to connect to MS SQL server");
> > >
> > > # The next line says which database to use.
> > >
> > > mssql_select_db("dupcsm",$db2)
> > > or die("Unable to select database");
> > >
> > > $result = mssql_query("Update Customer set Address_Line3='jjjjjjj'
> > > where Customer_Id='80110'",$db2);
> > >
> > > ?>
> > > <p>test<p>
> > > </html>
> > > </body>
> > > ========== end script ===============
> > > ========== dump log =================
> > > Sending packet @ 2000-03-06 14:19:20
> > > 0000 02 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0020 00 00 00 00 00 00 00 64 61 66 00 00 00 00 00 00
> > > |.......daf......|
> > > 0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0040 00 00 00 00 00 03 39 38 37 36 35 34 33 32 31 00
> > > |......987654321.|
> > > 0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0060 00 00 00 00 09 33 37 38 37 36 00 00 00 00 00 00
> > > |.....37876......|
> > > 0070 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0080 00 00 00 05 03 01 06 0a 09 01 00 00 00 00 02 00
> > > |................|
> > > 0090 00 00 00 00 50 48 50 20 33 2e 30 00 00 00 00 00 |....PHP
> > > 3.0.....|
> > > 00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 00b0 00 00 07 63 66 73 5f 62 61 63 6b 00 00 00 00 00
> > > |...cfs_back.....|
> > > 00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 00d0 00 08 39 38 37 36 35 34 33 32 31 00 00 00 00 00
> > > |..987654321.....|
> > > 00e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 00f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 0190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 01a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 01b0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 01c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > > 01d0 00 09 04 02 00 00 44 42 2d 4c 69 62 72 61 72 79
> > > |......DB-Library|
> > > 01e0 0a 00 00 00 00 00 0d 11 00 00 00 00 00 00 00 00
> > > |................|
> > > 01f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |................|
> > >
> > > Sending packet @ 2000-03-06 14:19:20
> > > 0000 02 01 00 4c 00 00 00 00 00 00 00 00 00 00 00 00
> > > |...L............|
> > > 0010 00 00 00 00 00 00 00 00 00 00 00 00 00 69 73 6f
> > > |.............iso|
> > > 0020 5f 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> > > |_1..............|
> > > 0030 00 00 00 00 00 00 00 00 00 00 00 05 01 35 31 32
> > > |.............512|
> > > 0040 00 00 00 03 00 00 00 00 00 00 00 00 |............|
> > >
> > > 2000-03-06 14:19:20 inside tds_process_login_tokens()
> > > 2000-03-06 14:19:20 inside tds_process_default_tokens() marker is e3
> > > 2000-03-06 14:19:20 inside tds_process_default_tokens() marker is ab
> > > 2000-03-06 14:19:20 inside tds_process_default_tokens() marker is e3
> > > 2000-03-06 14:19:20 inside tds_process_default_tokens() marker is fd
> > > 2000-03-06 14:19:20 leaving tds_process_login_tokens() returning 1
> > > Sending packet @ 2000-03-06 14:19:20
> > > 0000 01 01 00 12 00 00 00 00 75 73 65 20 64 75 70 63 |........use
> > > dupc|
> > > 0010 73 6d |sm|
> > >
> > > 2000-03-06 14:19:20 processing result tokens. marker is e3
> > > 2000-03-06 14:19:20 inside tds_process_default_tokens() marker is e3
> > > 2000-03-06 14:19:20 processing result tokens. marker is ab
> > > 2000-03-06 14:19:20 processing result tokens. marker is fd
> > > Sending packet @ 2000-03-06 14:19:20
> > > 0000 01 01 00 4d 00 00 00 00 55 70 64 61 74 65 20 43 |...M....Update
> > > C|
> > > 0010 75 73 74 6f 6d 65 72 20 73 65 74 20 41 64 64 72 |ustomer set
> > > Addr|
> > > 0020 65 73 73 5f 4c 69 6e 65 33 3d 27 6a 6a 6a 6a 6a
> > > |ess_Line3='jjjjj|
> > > 0030 6a 6a 27 20 77 68 65 72 65 20 43 75 73 74 6f 6d |jj' where
> > > Custom|
> > > 0040 65 72 5f 49 64 3d 27 38 30 31 31 30 27 |er_Id='80110'|
> > >
> > > 2000-03-06 1
> > > ============== end log ======================
> > > (NOTE: The last line is precisely where the log stopped. it reads
> > > '2000-03-06 1')
> > >
> > > Thanks You so much, for you assistance.
> > >
> > > -Mark
> > >
> > > --
> > > Boycott Amazon.com:
> > > http://perl.oreilly.com/cgi-bin/amazon_patent.comments.pl
> > > --
> > > Mark T. Johns, Webmaster, RIMS - http://www.rims.com/
> > > email: xmtj AT rims.com - BBS: http://rimsweb.rims.com/ubb/
> > > voice: (630) 428-5389
> > >
> > > ---
> > > You are currently subscribed to freetds as: francis AT oztel.com
> > > To unsubscribe, forward this message to $subst('Email.Unsub')
> >
> > --
> >
> > Grisly . oo
> > `oO
> > Francis Smit
> >
> > Knowledge By Design/OzTel
> > Suite 201, 683 George st
> > Sydney 2000 NSW
> >
> > mailto:francis AT kbd.com.au
> >
> > Tel: +61 2 9212 1399
> > Fax: +61 2 9212 5727
> > ___________________________________
> > m$: How can we stuff you up today?
> >
> > ---
> > You are currently subscribed to freetds as: xmtj AT rims.com
> > To unsubscribe, forward this message to $subst('Email.Unsub')
>
> --
> Boycott Amazon.com:
> http://perl.oreilly.com/cgi-bin/amazon_patent.comments.pl
> --
> Mark T. Johns, Webmaster, RIMS - http://www.rims.com/
> email: xmtj AT rims.com - BBS: http://rimsweb.rims.com/ubb/
> voice: (630) 428-5389
>
> ---
> You are currently subscribed to freetds as: francis AT oztel.com
> To unsubscribe, forward this message to $subst('Email.Unsub')

--

Grisly . oo
`oO
Francis Smit


Knowledge By Design/OzTel
Suite 201, 683 George st
Sydney 2000 NSW

mailto:francis AT kbd.com.au

Tel: +61 2 9212 1399
Fax: +61 2 9212 5727
___________________________________
m$: How can we stuff you up today?






Archive powered by MHonArc 2.6.24.

Top of Page