Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dump database error

8 posts in Backup and Recovery Last posting was on 2009-02-12 08:27:52.0Z
heroxulei Posted on 2009-02-10 08:17:56.0Z
From: heroxulei@hotmail.com
Newsgroups: sybase.public.ase.backup+recovery
Subject: dump database error
Date: Tue, 10 Feb 2009 00:17:56 -0800 (PST)
Organization: http://groups.google.com
Lines: 25
Message-ID: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com>
NNTP-Posting-Host: 192.250.34.161
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1234253876 20139 127.0.0.1 (10 Feb 2009 08:17:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Feb 2009 08:17:56 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: 33g2000yqm.googlegroups.com; posting-host=192.250.34.161; posting-account=CZamOQoAAAAUHTdhCDOUmRkybCZwE5Ph
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!33g2000yqm.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3913
Article PK: 48002

Hi,

1> select @@version
2> go


---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/12.5.3/EBF 12331 ESD#1/P/Sun_svr4/OS 5.8/
ase1253/190
0/64-bit/FBO/Tue Jan 25 08:52:58
2005

When run a dump database, I got following error in the log:
Feb 10 02:28:30 2009: A25: SYBMULTBUF ERROR: In basis_get_membufs,
failed to create shared memory segment for I/O buffers. shmget call
failed with system erro
r=Invalid argument
Feb 10 02:28:30 2009: Backup Server: 4.139.2.82: [23] The 'shmget'
call failed for device 'compress::5::/xxx::20' with error number 22
(Invalid argument). Refer to your operating system documentation for
further details. Look for 'Feb 10 02:28:30 2009: A20:
SYBMULTBUF ERROR: ' in the backup server errorlog for additional
information from SYBMULTBUF.

Any advice?


Cory Sane [TeamSybase] Posted on 2009-02-10 13:15:33.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.backup+recovery
References: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com>
In-Reply-To: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com>
Subject: Re: dump database error
Lines: 35
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49917df5$1@forums-1-dub>
Date: 10 Feb 2009 05:15:33 -0800
X-Trace: forums-1-dub 1234271733 10.22.241.152 (10 Feb 2009 05:15:33 -0800)
X-Original-Trace: 10 Feb 2009 05:15:33 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3914
Article PK: 48003

It looks like your device has an extra argument of ::20... What is that?

The device should be "compress::1::/filenamehere"

--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

<heroxulei@hotmail.com> wrote in message news:0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com...
> Hi,
>
> 1> select @@version
> 2> go
>
>
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> Adaptive Server Enterprise/12.5.3/EBF 12331 ESD#1/P/Sun_svr4/OS 5.8/
> ase1253/190
> 0/64-bit/FBO/Tue Jan 25 08:52:58
> 2005
>
> When run a dump database, I got following error in the log:
> Feb 10 02:28:30 2009: A25: SYBMULTBUF ERROR: In basis_get_membufs,
> failed to create shared memory segment for I/O buffers. shmget call
> failed with system erro
> r=Invalid argument
> Feb 10 02:28:30 2009: Backup Server: 4.139.2.82: [23] The 'shmget'
> call failed for device 'compress::5::/xxx::20' with error number 22
> (Invalid argument). Refer to your operating system documentation for
> further details. Look for 'Feb 10 02:28:30 2009: A20:
> SYBMULTBUF ERROR: ' in the backup server errorlog for additional
> information from SYBMULTBUF.
>
> Any advice?


"Mark A. Parsons" <iron_horse Posted on 2009-02-10 14:39:26.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: dump database error
References: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com>
In-Reply-To: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4991919e$1@forums-1-dub>
Date: 10 Feb 2009 06:39:26 -0800
X-Trace: forums-1-dub 1234276766 10.22.241.152 (10 Feb 2009 06:39:26 -0800)
X-Original-Trace: 10 Feb 2009 06:39:26 -0800, vip152.sybase.com
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3915
Article PK: 48005

Can you post the entire text of your 'dump database' command.

heroxulei@hotmail.com wrote:
> Hi,
>
> 1> select @@version
> 2> go
>
>
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> Adaptive Server Enterprise/12.5.3/EBF 12331 ESD#1/P/Sun_svr4/OS 5.8/
> ase1253/190
> 0/64-bit/FBO/Tue Jan 25 08:52:58
> 2005
>
> When run a dump database, I got following error in the log:
> Feb 10 02:28:30 2009: A25: SYBMULTBUF ERROR: In basis_get_membufs,
> failed to create shared memory segment for I/O buffers. shmget call
> failed with system erro
> r=Invalid argument
> Feb 10 02:28:30 2009: Backup Server: 4.139.2.82: [23] The 'shmget'
> call failed for device 'compress::5::/xxx::20' with error number 22
> (Invalid argument). Refer to your operating system documentation for
> further details. Look for 'Feb 10 02:28:30 2009: A20:
> SYBMULTBUF ERROR: ' in the backup server errorlog for additional
> information from SYBMULTBUF.
>
> Any advice?


heroxulei Posted on 2009-02-11 02:39:07.0Z
From: heroxulei@hotmail.com
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: dump database error
Date: Tue, 10 Feb 2009 18:39:07 -0800 (PST)
Organization: http://groups.google.com
Lines: 44
Message-ID: <12b7b26e-1c9f-4767-ac6a-3271ee3d0158@v38g2000yqb.googlegroups.com>
References: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com> <4991919e$1@forums-1-dub>
NNTP-Posting-Host: 192.250.34.161
Mime-Version: 1.0
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1234319947 5397 127.0.0.1 (11 Feb 2009 02:39:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 11 Feb 2009 02:39:07 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v38g2000yqb.googlegroups.com; posting-host=192.250.34.161; posting-account=CZamOQoAAAAUHTdhCDOUmRkybCZwE5Ph
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!news.glorb.com!news2.glorb.com!postnews.google.com!v38g2000yqb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3916
Article PK: 48004

On 2月10日, 下午10时39分, "Mark A. Parsons"

<iron_horse@no_spamola.compuserve.com> wrote:
> Can you post the entire text of your 'dump database' command.
>
>
>
> heroxu...@hotmail.com wrote:
> > Hi,
>
> > 1> select @@version
> > 2> go
>
> > ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> > Adaptive Server Enterprise/12.5.3/EBF 12331 ESD#1/P/Sun_svr4/OS 5.8/
> > ase1253/190
> > 0/64-bit/FBO/Tue Jan 25 08:52:58
> > 2005
>
> > When run a dump database, I got following error in the log:
> > Feb 10 02:28:30 2009: A25: SYBMULTBUF ERROR: In basis_get_membufs,
> > failed to create shared memory segment for I/O buffers. shmget call
> > failed with system erro
> > r=Invalid argument
> > Feb 10 02:28:30 2009: Backup Server: 4.139.2.82: [23] The 'shmget'
> > call failed for device 'compress::5::/xxx::20' with error number 22
> > (Invalid argument). Refer to your operating system documentation for
> > further details. Look for 'Feb 10 02:28:30 2009: A20:
> > SYBMULTBUF ERROR: ' in the backup server errorlog for additional
> > information from SYBMULTBUF.
>
> > Any advice?- 隐藏被引用文字 -
>
> - 显示引用的文字 -

Hi all,

Thanks for your attention.
We have identified the reason. It is caused by insufficient memory.
There is no problem with the script since we used the same script for
a long time and they all succeed.


heroxulei Posted on 2009-02-11 09:11:58.0Z
From: heroxulei@hotmail.com
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: dump database error
Date: Wed, 11 Feb 2009 01:11:58 -0800 (PST)
Organization: http://groups.google.com
Lines: 139
Message-ID: <4215c9af-237d-4246-a8ab-25c142b104d0@d32g2000yqe.googlegroups.com>
References: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com> <4991919e$1@forums-1-dub> <12b7b26e-1c9f-4767-ac6a-3271ee3d0158@v38g2000yqb.googlegroups.com>
NNTP-Posting-Host: 192.250.34.161
Mime-Version: 1.0
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1234343518 19469 127.0.0.1 (11 Feb 2009 09:11:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 11 Feb 2009 09:11:58 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: d32g2000yqe.googlegroups.com; posting-host=192.250.34.161; posting-account=CZamOQoAAAAUHTdhCDOUmRkybCZwE5Ph
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!news.glorb.com!news2.glorb.com!postnews.google.com!d32g2000yqe.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3917
Article PK: 48006


On 2月11日, 上午10时39分, heroxu...@hotmail.com wrote:
> On 2月10日, 下午10时39分, "Mark A. Parsons"
>
>
>
>
>
> <iron_horse@no_spamola.compuserve.com> wrote:
> > Can you post the entire text of your 'dump database' command.
>
> > heroxu...@hotmail.com wrote:
> > > Hi,
>
> > > 1> select @@version
> > > 2> go
>
> > > ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> > > Adaptive Server Enterprise/12.5.3/EBF 12331 ESD#1/P/Sun_svr4/OS 5.8/
> > > ase1253/190
> > > 0/64-bit/FBO/Tue Jan 25 08:52:58
> > > 2005
>
> > > When run a dump database, I got following error in the log:
> > > Feb 10 02:28:30 2009: A25: SYBMULTBUF ERROR: In basis_get_membufs,
> > > failed to create shared memory segment for I/O buffers. shmget call
> > > failed with system erro
> > > r=Invalid argument
> > > Feb 10 02:28:30 2009: Backup Server: 4.139.2.82: [23] The 'shmget'
> > > call failed for device 'compress::5::/xxx::20' with error number 22
> > > (Invalid argument). Refer to your operating system documentation for
> > > further details. Look for 'Feb 10 02:28:30 2009: A20:
> > > SYBMULTBUF ERROR: ' in the backup server errorlog for additional
> > > information from SYBMULTBUF.
>
> > > Any advice?- 隐藏被引用文字 -
>
> > - 显示引用的文字 -
>
> Hi all,
>
> Thanks for your attention.
> We have identified the reason. It is caused by insufficient memory.
> There is no problem with the script since we used the same script for
> a long time and they all succeed.- 隐藏被引用文字 -
>
> - 显示引用的文字 -

Hi,

The issue is not solved. I made a mistake. Below is what I found so
far. Looks like someone changed command. Please help.
svdw2e01 85: cat stripe7346
use master
GO
dump database re to
"compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.1_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.2_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.3_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.4_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.5_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.6_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.7_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.8_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.9_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.10_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.11_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.12_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.13_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.14_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.15_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.16_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.17_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.18_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.19_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.20_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.21_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.22_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.23_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.24_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.25_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.26_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.27_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.28_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.29_of_30"
stripe on "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.30_of_30"
go

svdw2e01 95: isql -Udba0lxx -SS29PMM3 -i stripe7346
Password:

Backup Server: 4.132.1.1: Attempting to open byte stream device:
'compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.1_of_30::00'

Backup Server: 4.132.1.1: Attempting to open byte stream device:
'compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.2_of_30::01'
....
Backup Server: 4.139.2.82: [23] The 'shmget' call failed for device
'compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
20090211033430.28_of_30::27' with error number 22 (Invalid argument).
Refer to your operating system documentation for further details. Look
for 'Feb 11 03:39:32 2009: A27: SYBMULTBUF ERROR: ' in the backup
server errorlog for additional information from SYBMULTBUF.


Jason L. Froebe [TeamSybase] Posted on 2009-02-11 13:53:38.0Z
From: "Jason L. Froebe [TeamSybase]" <jason@froebe.net>
Organization: TeamSybase
User-Agent: Thunderbird 2.0.0.19 (X11/20090105)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: dump database error
References: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com> <4991919e$1@forums-1-dub> <12b7b26e-1c9f-4767-ac6a-3271ee3d0158@v38g2000yqb.googlegroups.com> <4215c9af-237d-4246-a8ab-25c142b104d0@d32g2000yqe.googlegroups.com>
In-Reply-To: <4215c9af-237d-4246-a8ab-25c142b104d0@d32g2000yqe.googlegroups.com>
X-Enigmail-Version: 0.95.7
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4992d862@forums-1-dub>
Date: 11 Feb 2009 05:53:38 -0800
X-Trace: forums-1-dub 1234360418 10.22.241.152 (11 Feb 2009 05:53:38 -0800)
X-Original-Trace: 11 Feb 2009 05:53:38 -0800, vip152.sybase.com
Lines: 42
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3918
Article PK: 48007

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

heroxulei@hotmail.com wrote:
> Hi,
>
> The issue is not solved. I made a mistake. Below is what I found so
> far. Looks like someone changed command. Please help.
> svdw2e01 85: cat stripe7346
> use master
> GO
> dump database re to
> "compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
> 20090211033430.1_of_30"
....
> Backup Server: 4.139.2.82: [23] The 'shmget' call failed for device
> 'compress::5::/dpmm05/pmm/s29pmm3dbdmp/db_S29PMM3.re.
> 20090211033430.28_of_30::27' with error number 22 (Invalid argument).
> Refer to your operating system documentation for further details. Look
> for 'Feb 11 03:39:32 2009: A27: SYBMULTBUF ERROR: ' in the backup
> server errorlog for additional information from SYBMULTBUF.

Hi,

it still sounds like a resource issue to me. How much memory is on the
box? What is shmmax set to? Also make sure you have space available in
/tmp.

- --
Jason L. Froebe
TeamSybase
http://www.froebe.net/blog
http://www.froebe-fibers.com
http://www.isug.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkmS2GEACgkQ73tB17phUQCjbACglPDx5j/kR9EfVuFsnU4X7PLW
hlEAoLkQ2B1XW/2RY+botDiDcGCVQm1X
=Hl84
-----END PGP SIGNATURE-----


Derek Asirvadem Posted on 2009-02-11 16:58:47.0Z
From: Derek Asirvadem <derek.asirvadem@gmail.com>
Organization: Software Gems Pty Ltd
Newsgroups: sybase.public.ase.backup+recovery
Message-ID: <499303c6@forums-1-dub>
References: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com> <4991919e$1@forums-1-dub> <12b7b26e-1c9f-4767-ac6a-3271ee3d0158@v38g2000yqb.googlegroups.com> <4215c9af-237d-4246-a8ab-25c142b104d0@d32g2000yqe.googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: dump database error
User-Agent: Unison/1.8.1
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 11 Feb 2009 08:58:47 -0800
X-Trace: forums-1-dub 1234371527 10.22.241.152 (11 Feb 2009 08:58:47 -0800)
X-Original-Trace: 11 Feb 2009 08:58:47 -0800, vip152.sybase.com
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3919
Article PK: 48008


> On 2009-02-11 20:11:58 +1100, heroxulei@hotmail.com said:
>
> The 'shmget' call failed for device

That means one, and only one, thing to me: a call to "get shared
memory" failed. You either have the memory for BS set too high (reduce
it a little), or you have actually run out of memory (and you need to
get some more or reduce all the memory hogs a little). Someone has
changed the memory allocation of programs that grab memory on the box,
and failed to inform you.
--
Cheers
Derek
Senior Sybase DBA / Information Architect
Copyright © 2008 Software Gems Pty Ltd
--
With the financial meltdown, consolidating many databases into one ASE
server and managing mixed load is a demand. Ask people who have been
doing it for years.


heroxulei Posted on 2009-02-12 08:27:52.0Z
From: heroxulei@hotmail.com
Newsgroups: sybase.public.ase.backup+recovery
Subject: Re: dump database error
Date: Thu, 12 Feb 2009 00:27:52 -0800 (PST)
Organization: http://groups.google.com
Lines: 26
Message-ID: <2d963d09-58a5-42f2-85fb-dcbf72ad4c4a@x38g2000yqj.googlegroups.com>
References: <0367c86c-7ef3-4774-973a-7e5495919702@33g2000yqm.googlegroups.com> <4991919e$1@forums-1-dub> <12b7b26e-1c9f-4767-ac6a-3271ee3d0158@v38g2000yqb.googlegroups.com> <4215c9af-237d-4246-a8ab-25c142b104d0@d32g2000yqe.googlegroups.com> <499303c6@forums-1-dub>
NNTP-Posting-Host: 192.250.34.161
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1234427273 32343 127.0.0.1 (12 Feb 2009 08:27:53 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 12 Feb 2009 08:27:53 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: x38g2000yqj.googlegroups.com; posting-host=192.250.34.161; posting-account=CZamOQoAAAAUHTdhCDOUmRkybCZwE5Ph
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!x38g2000yqj.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3920
Article PK: 48009


On 2月12日, 上午12时58分, Derek Asirvadem <derek.asirva...@gmail.com> wrote:
> > On 2009-02-11 20:11:58 +1100, heroxu...@hotmail.com said:
>
> > The 'shmget' call failed for device
>
> That means one, and only one, thing to me: a call to "get shared
> memory" failed.  You either have the memory for BS set too high (reduce
> it a little), or you have actually run out of memory (and you need to
> get some more or reduce all the memory hogs a little).  Someone has
> changed the memory allocation of programs that grab memory on the box,
> and failed to inform you.
> --
> Cheers
> Derek
> Senior Sybase DBA / Information Architect
> Copyright © 2008 Software Gems Pty Ltd
> --
> With the financial meltdown, consolidating many databases into one ASE
> server and managing mixed load is a demand.  Ask people who have been
> doing it for years.

Thanks all. The issue is caused by memory insufficiency.
We addressed the issue by adding more memory to the server.