dump database error

Discussion:

dump database error

(too old to reply)

h***@hotmail.com

2009-02-10 08:17:56 UTC

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?

unknown

2009-02-10 13:15:33 UTC

Permalink

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

Post by h***@hotmail.com
Hi,
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
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
SYBMULTBUF ERROR: ' in the backup server errorlog for additional
information from SYBMULTBUF.
Any advice?

Mark A. Parsons

2009-02-10 14:39:26 UTC

Permalink

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

h***@hotmail.com

2009-02-11 02:39:07 UTC

Permalink

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

Post by Mark A. Parsons
Can you post the entire text of your 'dump database' command.

Hi,
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
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
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.

h***@hotmail.com

2009-02-11 09:11:58 UTC

Permalink

Post by h***@hotmail.com
On 2月10日, 下午10时39分, "Mark A. Parsons"

Post by Mark A. Parsons
Can you post the entire text of your 'dump database' command.

Hi,
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
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
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]

2009-02-11 13:53:38 UTC

Permalink

Post by h***@hotmail.com
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"

....

Post by h***@hotmail.com
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

Derek Asirvadem

2009-02-11 16:58:47 UTC

Permalink

Post by h***@hotmail.com
The 'shmget' call failed for device

--
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.

h***@hotmail.com

2009-02-12 08:27:52 UTC

Permalink

Post by Derek Asirvadem

Post by h***@hotmail.com
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.