11.0.3.3 instalation

[omaigad]

Hello,
im trying to install 11.0.3.3 version of Sybase on Ubuntu
8.04.
I set
kernel.shmmax = 268435456
export LD_POINTER_GUARD=1
When i was runing sybinstall.sh script didnt copied
rc.sybase file corectly, had to move it by hand. sybinit
went ok i set everything to default, but at the end of 9
steps when it tryes to start server

Execute the Sybase Server Configuration now? y

WARNING: '/opt/sybase/master.dat' is a regular file which
is not recommended for a Server
device.
Press <return> to continue.

'/opt/sybase/master.dat' is a regular file that already
exists. It will be overwritten.
Press <return> to continue.
Running task: create the master device.
Building the master device
.Done
Task succeeded: create the master device.
Running task: update the Sybase Server runserver file.
Task succeeded: update the Sybase Server runserver file.
Running task: boot the Sybase Server.
waiting for server 'testdb' to boot...

SERVER ERROR: Failed to boot server 'testdb'.
Press <return> to continue.

I get segmentation fault when trying to starting server

augis@augis-laptop:/opt/sybase/install$ sudo ./startserver
-f /opt/sybase/install/RUN_sybDB
augis@augis-laptop:/opt/sybase/install$ 00:2009/03/29
21:59:03.64 kernel Using config area from primary master
device.
00:2009/03/29 21:59:03.64 kernel Warning: Using default
file '/opt/sybase/sybDB.cfg' since a configuration file was
not specified. Specify a configuration file name in the
RUNSERVER file to avoid this message.
00:2009/03/29 21:59:03.65 kernel os_create_keyfile: Removed
old segment /opt/sybase/sybDB.krg
00:2009/03/29 21:59:03.65 kernel Using 1024 file
descriptors.
00:2009/03/29 21:59:03.65 kernel Internal run-time model
set for Linux
00:2009/03/29 21:59:03.65 kernel SQL Server/11.0.3.3
ESD#6/P-FREE/Linux Intel/Linux 2.2.14 i686/1/OPT/Fri Mar 17
15:45:30 CET 2000
00:2009/03/29 21:59:03.65 kernel (c) Copyright 1987, 2000.
00:2009/03/29 21:59:03.65 kernel Sybase, Inc. All rights
reserved.
00:2009/03/29 21:59:03.65 kernel
00:2009/03/29 21:59:03.65 kernel Unpublished rights
reserved under U.S. copyright laws.
00:2009/03/29 21:59:03.65 kernel This software contains
confidential and trade secret information of Sybase,
00:2009/03/29 21:59:03.65 kernel Inc. Use, duplication
or disclosure of the software and documentation by
00:2009/03/29 21:59:03.65 kernel the U.S. Government is
subject to restrictions set forth in a license
00:2009/03/29 21:59:03.65 kernel agreement between the
Government and Sybase, Inc. or other written
00:2009/03/29 21:59:03.65 kernel agreement specifying the
Government's rights to use the software and any
00:2009/03/29 21:59:03.65 kernel applicable FAR provisions,
for example, FAR 52.227-19.
00:2009/03/29 21:59:03.65 kernel
00:2009/03/29 21:59:03.65 kernel Sybase, Inc. 6475 Christie
Avenue, Emeryville, CA 94608, USA.
00:2009/03/29 21:59:03.65 kernel Using
'/opt/sybase/sybDB.cfg' for configuration information.
00:2009/03/29 21:59:03.65 kernel Logging SQL Server
messages in file '/opt/sybase/install/errorlog'
.
00:2009/03/29 21:59:03.65 kernel Network and device
connection limit is 1014.
00:2009/03/29 21:59:03.65 server Number of proc buffers
allocated: 495.
00:2009/03/29 21:59:03.67 server Number of blocks left for
proc headers: 543.
00:2009/03/29 21:59:03.67 server Memory allocated for the
default data cache cache: 3718 Kb
00:2009/03/29 21:59:03.67 server Size of the 2K memory
pool: 3718 Kb
00:2009/03/29 21:59:03.67 kernel Unable to load KAIO driver
kaioasync.so.
00:2009/03/29 21:59:03.67 kernel Async disk I/O is
permanent disabled.
00:2009/03/29 21:59:03.67 kernel kistartup: asynchronous
I/O not available: No such file or directory
00:2009/03/29 21:59:03.67 kernel Initializing virtual
device 0, '/opt/sybase/master.dat'
00:2009/03/29 21:59:03.67 kernel Virtual device 0 started
using standard unix i/o.
Segmentation fault

thanks in adavance for help.

[Jason L. Froebe [TeamSybase]]

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

Hi,

The problem is the glibc that is packaged with the new Linux
distributions. You'll either have to use an older distribution or use a
chroot environment.

To set up a chroot environment: http://tinyurl.com/5cq6lm

The chroot instructions *should* work for 11.9x or 11.0x.

jason
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAknP7QYACgkQ73tB17phUQAIzACg2p8/X0S27C+xacEOg9HK1xuz
etwAniKuvdBEN36iAQ3ssNcz2k7Z9bAo
=HqR8
-----END PGP SIGNATURE-----

[Chris N. Brown [Sybase, Inc.]]

The last Ubuntu distribution that I've known ASE Server 11.9.x to work on
without any sort of trouble was "Dapper Drake" (6.06). I haven't tried
11.0.3 in ages but it may work on that distribution as well. Nice thing
is it's an LTS support from Canonical so you could continue to receive
updates from them for a few more years.

If you want to use Hardy Heron (8.04 LTS) as Jason said you could either:
Create a chroot environment
Use a virtual machine (either vmware or virtualbox or xen on 8.04)

Good luck!

-Chris

On Sun, 29 Mar 2009 11:24:02 -0800, omaigad wrote:

[snip]

[omaigad]

Thanks for answer. Went for debian 4.0 works like a charm
:)
chroot is too complicated for me, not a linux guru.
But i got one question left is there any hardware
limitations to 11.0.3.3 version? how many procesors it can
use, or how much RAM.

thank you for your time.

[Chris N. Brown [Sybase, Inc.]]

I haven't used 11.0.3 in so long (and I don't have a copy handy right
now), but I will try and go from memory.

11.0.3 wasn't really supported per se from Sybase, it was released "free"
and without any support from Sybase whatsoever (think of it more as we
were testing the waters to see if there was interest in ASE on Linux at
the time, so we made 11.0.3 available for download with no support).
11.9.2 was the first release we had on Linux that was officially
supported if I remember correctly (then jumping to 12.5 after that).

Limits? Well, I seem to remember limits on dumpfile size (2GB each
stripe). You've already seen issues with glibc (that's why you are
running Debian Etch). Best to use raw partitions; DSYNC wasn't available
in that release (nor was direct IO). Memory wasn't limited artificially
by Sybase; but you may run into 32-bit limitations -- not sure there.
There wasn't a limit on engines either but at that time we didn't see 32-
engine Linux installs :).

Best bet is just to change what you want with sp_configure and see if
you're able to boot. If not, you can change the config file back and try
again.

Good luck!

-Chris

[Michael Peppler [Team Sybase]]

The limits are pretty much as Chris mentions.

2GB for dump file sizes.
32GB for data devices (same as for 12.5)
2.7GB addressable RAM (32bit limit under linux, IIRC).

There is an issue with getting more than 128MB of RAM accessed on some
more recent versions of linux which require patching the dataserver
binary. Please see the FAQ at http://www.peppler.org/FAQ/linux.html for
additional information.

Michael

On Wed, 01 Apr 2009 04:25:17 -0800, omaigad wrote:

[Peter Collard]

Chris N. Brown [Sybase, Inc.] wrote:

> Limits? Well, I seem to remember limits on dumpfile size (2GB each
> stripe). You've already seen issues with glibc (that's why you are
> running Debian Etch). Best to use raw partitions; DSYNC wasn't available
> in that release (nor was direct IO). Memory wasn't limited artificially
> by Sybase; but you may run into 32-bit limitations -- not sure there.
> There wasn't a limit on engines either but at that time we didn't see 32-
> engine Linux installs :).

Generically, 11.0.3 was certainly good for 16 cpus (giving 15.4 times the
thruput of a single engine on the benchmark run for Arthur Anderson UK),
but was rumoured to run into scaling problems much above that.

[omaigad]

Hello,
thank you for info, but i cant set data device bigger than 2gb. thats
11.0.3.3

On Apr 5, 7:37 pm, "Michael Peppler [Team Sybase]"

[Michael Peppler [Team Sybase]]

Thanks for the correction - I couldn't remember if that version already
handled long arguments to lseek(), etc.

Michael