Debian Bug report logs - #431044
Apache child exits on sql server functions

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Andrea Cerisara <andreacerisara@gmail.com>

To: submit@bugs.debian.org

Subject: Apache child exits on sql server functions

Date: Fri, 29 Jun 2007 09:43:27 +0200

Package: php5-sybase
Version: 5.2.0-8+etch1

When a php script reaches the first sql server function, the
process that handles the connection exits, and Apache reports:

apache2: iconv.c:357: tds_iconv_open: Assertion `ret == 0' failed.
[Thu Jun 28 13:54:48 2007] [notice] child pid 18191 exit signal Aborted (6)

From phpinfo() LANG is set to C, and the default charset is ISO-8859-1.
From locale command LANG is set to it_IT@euro.

I' m using Debian GNU/Linux 4.0, kernel 2.4.27-2-686,
php5-5.2.0-8+etch1 and libc6 2.3.6.ds1-13.

Message #10 received at 431044@bugs.debian.org (full text, mbox, reply):

From: Steve Langasek <vorlon@debian.org>

To: Andrea Cerisara <andreacerisara@gmail.com>, 431044@bugs.debian.org

Subject: Re: [php-maint] Bug#431044: Apache child exits on sql server functions

Date: Sun, 1 Jul 2007 19:24:42 -0700

Hi Andrea,

On Fri, Jun 29, 2007 at 09:43:27AM +0200, Andrea Cerisara wrote:
> When a php script reaches the first sql server function, the
> process that handles the connection exits, and Apache reports:

> apache2: iconv.c:357: tds_iconv_open: Assertion `ret == 0' failed.
> [Thu Jun 28 13:54:48 2007] [notice] child pid 18191 exit signal Aborted (6)

>  From phpinfo() LANG is set to C, and the default charset is ISO-8859-1.
>  From locale command LANG is set to it_IT@euro.

> I' m using Debian GNU/Linux 4.0, kernel 2.4.27-2-686,
> php5-5.2.0-8+etch1 and libc6 2.3.6.ds1-13.

I haven't been able to reproduce this problem in a test environment.  Can
you provide a test script that shows the error?

It's possible that the problem is also specific to tables containing
non-ASCII data.  You mentioned that the problem was not reproducible for you
when using sqsh; could you also provide a sample result set for a query that
succeeds with sqsh and fails with php5-sybase?

Cheers,
-- 
Steve Langasek                   Give me a lever long enough and a Free OS
Debian Developer                   to set it on, and I can move the world.
vorlon@debian.org                                   http://www.debian.org/

Message #15 received at 431044@bugs.debian.org (full text, mbox, reply):

From: Walter Doekes <walter@wjd.nu>

To: 431044@bugs.debian.org

Subject: Re: [php-maint] Bug#431044: Apache child exits on sql server functions

Date: Sat, 29 Sep 2007 12:09:32 +0200

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi debian folk.

> It's possible that the problem is also specific to tables containing
> non-ASCII data.  You mentioned that the problem was not reproducible
> for you when using sqsh; could you also provide a sample result set
> for a query that succeeds with sqsh and fails with php5-sybase?

I don't think it's the same bug, but it's really close.
Please take a look at this one:
http://bugs.php.net/bug.php?id=33693
If also concerns sybase-ct and iconv.


See this sample script connecting to a MS SQL server:

<?php
putenv('TDSVER=7.0');
$db = sybase_connect($server, $username, $password);
sybase_select_db('MODULES', $db);
sybase_query("DROP TABLE test_tbl");
sybase_query("CREATE TABLE test_tbl
  (a INT, b NVARCHAR(255), c UNIQUEIDENTIFIER)");
sybase_query("INSERT INTO test_tbl VALUES
  (1, N'Hello World', NEWID())");
if (($q1 = sybase_query("SELECT a, b FROM test_tbl")))
        print_r(sybase_fetch_row($q1));
if (($q2 = sybase_query("SELECT a, b, c FROM test_tbl")))
        print_r(sybase_fetch_row($q2));
?>


This outputs:

Array
(
    [0] => 1
    [1] => Hello World
)
error_handler: Data-conversion resulted in overflow.
Segmentation fault


If you replace the TDSVER=7.0 with TDSVER=4.2 you get:

Array
(
    [0] => 1
    [1] => Hello World
)
Array
(
    [0] => 1
    [1] => Hello World
    [2] => 244ebbc892d6f24694ab8a08836fa86d
)


Obviously it would be better if this is fixed upstream. But this bug has
existed since 2005 and for me personally I only need it fixed in Debian
and Ubuntu ;-)

Regards,
Walter Doekes


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG/iRcHeLk+LNJZ18RAnUpAKC9VUo8SPsVd+S0S08dSzGg2O9SZgCgp5Yr
tTYtwWKyCMYzzHjUYk4tP9M=
=skrN
-----END PGP SIGNATURE-----

Message #20 received at 431044@bugs.debian.org (full text, mbox, reply):

From: Steve Langasek <vorlon@debian.org>

To: Walter Doekes <walter@wjd.nu>, 431044@bugs.debian.org

Subject: Re: [php-maint] Bug#431044: Bug#431044: Apache child exits on sql server functions

Date: Mon, 1 Oct 2007 02:10:09 -0700

Hi Walter,

On Sat, Sep 29, 2007 at 12:09:32PM +0200, Walter Doekes wrote:

> Hi debian folk.

> > It's possible that the problem is also specific to tables containing
> > non-ASCII data.  You mentioned that the problem was not reproducible
> > for you when using sqsh; could you also provide a sample result set
> > for a query that succeeds with sqsh and fails with php5-sybase?

> I don't think it's the same bug, but it's really close.
> Please take a look at this one:
> http://bugs.php.net/bug.php?id=33693
> If also concerns sybase-ct and iconv.

> See this sample script connecting to a MS SQL server:

> <?php
> putenv('TDSVER=7.0');
> $db = sybase_connect($server, $username, $password);
> sybase_select_db('MODULES', $db);
> sybase_query("DROP TABLE test_tbl");
> sybase_query("CREATE TABLE test_tbl
>   (a INT, b NVARCHAR(255), c UNIQUEIDENTIFIER)");
> sybase_query("INSERT INTO test_tbl VALUES
>   (1, N'Hello World', NEWID())");
> if (($q1 = sybase_query("SELECT a, b FROM test_tbl")))
>         print_r(sybase_fetch_row($q1));
> if (($q2 = sybase_query("SELECT a, b, c FROM test_tbl")))
>         print_r(sybase_fetch_row($q2));
> ?>

> This outputs:

> Array
> (
>     [0] => 1
>     [1] => Hello World
> )
> error_handler: Data-conversion resulted in overflow.
> Segmentation fault

Is this problem reproducible for you with the php5-sybase package in
unstable, which is now based on the mssql extension rather than the
sybase-ct extension?  I wasn't able to reproduce it here.

-- 
Steve Langasek                   Give me a lever long enough and a Free OS
Debian Developer                   to set it on, and I can move the world.
vorlon@debian.org                                   http://www.debian.org/

Message #25 received at 431044@bugs.debian.org (full text, mbox, reply):

From: Walter Doekes <walter@wjd.nu>

To: Steve Langasek <vorlon@debian.org>, 431044@bugs.debian.org

Subject: Re: Bug#431044: [php-maint] Bug#431044: Bug#431044: Apache child exits on sql server functions

Date: Thu, 04 Oct 2007 10:08:37 +0200

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Steve

Steve Langasek wrote:
> Walter Doekes wrote:
>> <?php
>> putenv('TDSVER=7.0');
>> $db = sybase_connect($server, $username, $password);
>> sybase_select_db('MODULES', $db);
>> sybase_query("DROP TABLE test_tbl");
>> sybase_query("CREATE TABLE test_tbl
>>   (a INT, b NVARCHAR(255), c UNIQUEIDENTIFIER)");
>> sybase_query("INSERT INTO test_tbl VALUES
>>   (1, N'Hello World', NEWID())");
>> if (($q1 = sybase_query("SELECT a, b FROM test_tbl")))
>>         print_r(sybase_fetch_row($q1));
>> if (($q2 = sybase_query("SELECT a, b, c FROM test_tbl")))
>>         print_r(sybase_fetch_row($q2));
>> ?>
> 
>> This outputs:
> 
>> Array
>> (
>>     [0] => 1
>>     [1] => Hello World
>> )
>> error_handler: Data-conversion resulted in overflow.
>> Segmentation fault
> 
> Is this problem reproducible for you with the php5-sybase package in
> unstable, which is now based on the mssql extension rather than the
> sybase-ct extension?  I wasn't able to reproduce it here.

I don't think I would be able to reproduce it with a package based on
the mssql extension. As the author of the original bug report to php.net
pointed out, he could fix it by adding explicit support for the
CS_UNIQUE_TYPE to php_sybase_ct.c. So unless that support has been
"forgotten" in the mssql extension as well, you won't be seeing that bug.

But because unstable will take a while to become stable, I wouldn't mind
if the tiny fix would be applied to the current stable. If that's not
possible, I guess I'll have to wait for a backport :)

Regards,
Walter Doekes

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHBJ+FHeLk+LNJZ18RAtRbAJ4sDtjtignAIJ7/pkcvcNEjavq0awCfcN15
LI6Z7pat8gchXCErxCOOAaM=
=bV9n
-----END PGP SIGNATURE-----

Message #30 received at 431044-done@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: 431044-done@bugs.debian.org

Subject: #431044: Apache child exits on sql server functions

Date: Fri, 8 Jan 2010 17:06:34 +0100

Version: 5.2.6.dfsg.1-1+lenny4


No longer applies to current stable (lenny) since we have switched
sybase module to mssql.

-- 
Ondřej Surý <ondrej@sury.org>
http://blog.rfc1925.org/

Send a report that this bug log contains spam.