FreeBSD ase 11.0.3.3 multiprocessor problem

[Augustukas]

Hello,

we are running FreeBSD 7.2.
on
CPU: Intel(R) Xeon(TM) CPU 3.20GHz (3200.14-MHz 686-class CPU)
Logical CPUs per core: 2

system works fine with sp_configure 'max online engines',1
but when i set sp_configure 'max online engines', 2
server starts fine.
/usr/local/etc/rc.d/sybase.sh status
sybase 48714 0.0 2.2 802016 44968 ?? Ss 12:19PM 0:02.45 /usr/
local/sybase-ase/bin/dataserver -d/usr/local/sybase-ase/data/
master.dat -ssyb -e/var/log/sybase/errorlog -i/usr/local/sybase-ase
sybase 48771 0.0 0.2 801972 5048 ?? S 12:19PM 0:01.78 /usr/
local/sybase-ase/bin/dataserver -ONLINE:
1,0,0xea570033,0x284e2000,0x309c6000,0x1159
sybase 48720 0.0 0.2 8140 5084 p0 I 12:19PM 0:00.02 /usr/
local/sybase-ase/bin/backupserver -Ssybb -e/var/log/sybase/backup.log -
I/usr/local/sybase-ase/interfaces -M/usr/local/sybase-ase/bin/
sybmultbuf -Lus_english -Jiso_1 -c/usr/local/sybase-ase/
backup_tape.cfg

top gives
48714 sybase 1 8 0 783M 44968K nanslp 1 0:03 0.00%
dataserver
48771 sybase 1 8 0 783M 5048K nanslp 1 0:02 0.00%
dataserver

when i try to login into server with central it stops responding.
error log shows
00:2009/04/23 12:19:40.51 server Database 'TTT' is now online.
00:2009/04/23 12:19:40.51 server SQL Server's default sort order is:
00:2009/04/23 12:19:40.51 server 'nocaselit_iso_1' (ID = 81)
00:2009/04/23 12:19:40.51 server on top of default character set:
00:2009/04/23 12:19:40.51 server 'iso_1' (ID = 1).
01:2009/04/23 12:19:40.52 kernel engine 1, os pid 48771 online
01:2009/04/23 12:20:14.53 kernel ninit: set process group 48771, No
such process

thank you for your time

[Rob V [Sybase]]

Does the same happen when you log in with 'isql' ?

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"Augustukas" <gri...@gmail.com> wrote in message
news:f055e49d-7098-4644...@y1g2000yqk.googlegroups.com...

[Augustukas]

On Apr 23, 1:40 pm, "Rob V [Sybase]"

<r...@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
> Does the same happen when you log in with 'isql' ?
>
> HTH,
>
> Rob V.
> -----------------------------------------------------------------
> Rob Verschoor
>
> Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
> and Replication Server 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online atwww.sypron.nl/shop):
> "Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference Guide"
>

> mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.MEhttp://www.sypron.nl

> Sypron B.V., Amersfoort, The Netherlands
> Chamber of Commerce 27138666
> -----------------------------------------------------------------
>

> "Augustukas" <grik...@gmail.com> wrote in message

isql -Usa -P -Ssyb
1> select @@version
2> go
No language handler installed.
Language cmd: select @@version

[Rob V [Sybase]]

This is the error message you get when connect to the Backup Server instead
of to ASE: the Backup Server is not suppsoed to be logged into, but
communicates with ASE through a different method.
I'm guessing your interfaces files contains something other than you
expect -- I'd recommend to check it out ($SYBASE/interfaces).

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"Augustukas" <gri...@gmail.com> wrote in message
news:b0e6bb61-b394-4581...@c36g2000yqn.googlegroups.com...

[Augustukas]

On Apr 23, 2:14 pm, "Rob V [Sybase]"

<r...@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
> This is the error message you get when connect to the Backup Server instead
> of to ASE: the Backup Server is not suppsoed to be logged into, but
> communicates with ASE through a different method.
> I'm guessing your interfaces files contains something other than you
> expect -- I'd recommend to check it out ($SYBASE/interfaces).
>
> HTH,
>
> Rob V.
> -----------------------------------------------------------------
> Rob Verschoor
>
> Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
> and Replication Server 15.0.1/12.5 // TeamSybase
>

yes in this case i was connecting to backup server my fault.
But when i through isql to correct server
it just hangs up and i cant do nothing unless i restart server

1> select @@version
2> go

^Ce/DB-LIBRARY error:
Unexpected EOF from SQL Server.

[Bret Halford [Sybase]]

>
> yes in this case i was connecting to backup server my fault.
> But when i through isql to correct server
> it just hangs up and i cant do nothing unless i restart server
>
> 1> select @@version
> 2> go
> ^Ce/DB-LIBRARY error:
> Unexpected EOF from SQL Server.

Is the timing of the "ninit" error mapping to the login attempt?
Anything else showing up in the errorlog (there is often a stacktrace
with an abrupt termination like that).

What is the exact server version (dataserver -v output)? I don't
recall that 11.0.x was ever certified on FreeBSD, but that was all
a long time ago.

-bret