Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
backup problem -8020

backup problem -8020

2007-08-23       - By David P Possinger

 Back
I am trying to do a complete backup, the command I am using is:

dbmcli -u dbm,dbm -n localhost -d armmis medium_put Test_bkupF
/sapbackup/Test_bkupF FILE DATA 0 8 YES

dbmcli -u dbm,dbm -n localhost -d armmis -uUTL -c backup_start Test_bkupF

However I am receiving the following error:

OK
Returncode              -8020
Date                    20070823
Time                    00190353
Server                  test
Database                TEST
Kernel Version          QuickKnl  7.3.0    Build 048-100-066-583
Pages Transferred       131064
Pages Left              11997
Volumes
Medianame               Test_bkupF
Location                /sapbackup/Test_bkupF
Errortext               write: last block is smaller
Label                   DAT_00650
Is Consistent           false
First LOG Page          29
Last LOG Page
DB Stamp 1 Date         20070823
DB Stamp 1 Time         00175304
DB Stamp 2 Date
DB Stamp 2 Time
Page Count              143037
Devices Used            1
Database ID             test:TEST_20070823_162112
Max Used Data Page      256208

In the KNLDIAG is the following message:

2007-08-23 19:14:13    13     52024 SAVE     128000 pages ->
"pbackup/Test_bkupF"
2007-08-23 19:14:18    13     52024 SAVE     129000 pages ->
"pbackup/Test_bkupF"
2007-08-23 19:14:23    13     52024 SAVE     130000 pages ->
"pbackup/Test_bkupF"
2007-08-23 19:14:28    13     52024 SAVE     131000 pages ->
"pbackup/Test_bkupF"
en60_Write: write returned -1, No space left on device, fd 4, length 76
text 2007-08-23 19:14:28   141 ERR 11000 devio    write lgt 65024, wanted
65536
2007-08-23 19:14:28   141 ERR 11000 devio    write lgt 65024, wanted 65536

2007-08-23 19:14:28    13     11000 vasynclos '/sapbackup/Test_bkupF'
devno 16 T27
2007-08-23 19:14:28     8     12822 TASKING  Thread 141 joining
2007-08-23 19:14:28   141     11566 stop     DEVi stopped
2007-08-23 19:14:28    13     52024 SAVE     131056 pages ->
"pbackup/Test_bkupF"
2007-08-23 19:14:28    12     52012 SAVE     new tape required 4300

I'm using SAPDB 7.3 with AIX 4.3.

The directory /sapbackup has plenty of room.

Do I need to use backup_ignore or backup_replace? If so does anyone have
an example. I have not been able to get them to work.

Or is it something else that I'm overlooking?

Any help would be appreciated.

Thanks in advance,
David

-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ----
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use of
e-mail for such purpose.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ----