cancel
Showing results for 
Search instead for 
Did you mean: 

Database dump error

ps_vinay
Explorer
0 Kudos

Hello All, I'm getting the below error. Can anyone help on this. Backup Server: 4.124.2.1: Archive API error for device='compress::/net/134.163.248.45/sybase/sybbkup/CPDMDR/bkup/PDBA_WH-20151118093434-0.db::000': Vendor application name=Compress API, Library version=1, API routine=syb_open(), Message=syb_open: open() error=30, msg=Read-only file system Msg 8009, Level 16, State 1: Server 'CPDMDR', Line 1: Error encountered by Backup Server.  Please refer to Backup Server messages for details.

Accepted Solutions (0)

Answers (4)

Answers (4)

ps_vinay
Explorer
0 Kudos

Hello All.

Thank you very much for your inputs. Contacted the NFS team to re-mount the file system to read-write and everything went fine after that.

Thanks,

P S Vinay

former_member350489
Participant
0 Kudos

Is this by any chance a NetApp Filer with an NFS file system you're trying to write to ?

If so, we've encountered this problem a couple of times due to a "bug", that kicks in once in a while, making the filsystems "read only" !

It happened when we did "some operation" on the Filer and then the ESX lost contact...

Former Member
0 Kudos

It looks to be read only file system and may be NFS too.

Please check if you are able to write using the user which initiates the back up.

Please ensure that there are no spaces between compress and next set of commands in the scripts.

jayrijnbergen
Active Participant
0 Kudos

the messages says: error=30, msg=Read-only file system

If you would try to write to a directory where you don't have permission, the error message would show:

error=13, msg=Permission denied

For example, try dump model database to the root filesystem "/model.dmp"

(Assuming here that you don't run your Sybase server with root account)

Check the output from command: mount

Anyway, the touch command would be easiest way to test

jayrijnbergen
Active Participant
0 Kudos

Read the error message...

msg=Read-only file system

check with your system admin to remount the filesystem read/write

c_baker
Advisor
Advisor
0 Kudos

Also, do not use the streaming compression any more - 'compress::....'.  It has been deprecated.

Instead use the 'compress = <compression level>' syntax in your dump database command and investigate compression levels 100 and 101.  These levels utilize all cores during the dump to improve performance, whereas the older compression levels 1-9 only used a single core.

In addition, these dumps contain detail about the compression level used internally, so can be used to restore using the 'Archive Database Access' feature for object-level recovery when needed.

Chris

ps_vinay
Explorer
0 Kudos

Hi, Thanks the folder where the backup file is writing having the below permission. Please check. But whereas the system tables are also getting backup up to this folder and it not giving any error. Only for the backup it is giving error. Bot the script is invoked by sa /net/134.163.248.45/sybase/sybbkup/CPDMDR/bkup drwxr-xr-x  3 sybase  dba        24576 Nov 19 00:05 bkup