Sybase: Backup Server — “No virtual mapping for logical page”

I noticed today, trying to dump a database kept stalling. And after ~5 minutes of no data being dumped I check the backup logs. To my surprise I saw the following output in the logs, which seemed to be repeating almost infinitely:

…edited…

Mar 29 17:14:49 2007: Backup Server: 3.29.2.1: No virtual mapping for logical page 10694867.
Mar 29 17:14:49 2007: Backup Server: 3.29.2.1: No virtual mapping for logical page 10694868.
Mar 29 17:14:49 2007: Backup Server: 3.29.2.1: No virtual mapping for logical page 10694869.
Mar 29 17:14:49 2007: Backup Server: 3.29.2.1: No virtual mapping for logical page 10694870.
Mar 29 17:14:49 2007: Backup Server: 3.29.2.1: No virtual mapping for logical page 10694871.
…edited…

The size of this log file was also increasing at an alarming rate!

bash-2.05$ du -skh SYBASE_SERVER_BS.log
20M SYBASE_SERVER_BS.log
bash-2.05$ du -skh SYBASE_SERVER_BS.log
194M SYBASE_SERVER_BS.log
bash-2.05$ du -skh SYBASE_SERVER_BS.log
208M SYBASE_SERVER_BS.log
bash-2.05$ du -skh SYBASE_SERVER_BS.log
217M SYBASE_SERVER_BS.log
bash-2.05$ du -skh SYBASE_SERVER_BS.log
224M SYBASE_SERVER_BS.log
bash-2.05$ du -skh SYBASE_SERVER_BS.log
228M SYBASE_SERVER_BS.log
That should never happen!

The available free space on the partition of the sybase_server was almost full!

Filesystem size used avail capacity Mounted on
/dev/mXX/dsk/d32 7.9G 7.4G 369M 96% /opt

Noticing the filesystem was filling up I zero’ed the log file:

bash-2.05$ cat > /dev/null > SYBASE_SERVER_BS.log

Still the process repeated. I was left with no choice, but to kill — forcefully kill, the backup server. I tried to be nice with plain ol’ ‘kill’, but the backup server did not want to play nice — it would not die. I had no choice but to use ‘kill -9’.

bash-2.05$ tail -f SYBASE_SERVER_BS.log

showed nothing and this was a good sign; there were no more writes to the log file. Restarting the backup server proved very helpful and I was able to resume the dump of a database. I was only able to restart the backup server after killing the leftover sybmultbuf processe(s). My initial attempt to start the backup server failed!

bash-2.05$ nohup sh RUN_SYBASE_SERVER_BS &
[1] 29044
bash-2.05$ Sending output to nohup.out

[1]+ Done nohup sh RUN_SYBASE_SERVER_BS
bash-2.05$ tail -f nohup.out

Logging Backup Server messages in file ‘/opt/sybase_home/ase12.5/ASE-12_5/install/SYBASE_SERVER_BS.log’
Open Server Error: 16240.10.0: Net-Library routine sybnet_listen() failed in srv__start_net
Network error: status = 23 – Net-Lib protocol driver call to register a listener failed
.
Open Server Server Fatal Error: 16029.20.0: Failed to start any network listeners
.
No server log file open; Using stderr for log.
Mar 29 17:30:23 2007: Backup Server: 1.29.2.1: Unable to start the Backup Server. See Backup Server error log for additional information.

It was the above error message that gave me the inclination to look for sybmultbuf.

bash-2.05$ ps -ef | grep buf
sybadmin 29051 28250 0 17:30:42 pts/1 0:00 grep buf
sybadmin 27794 1 0 17:02:50 ? 0:00 /opt/sybase_server/ase12.5/ASE-12_5/bin/sybmultbuf 22 7 10 /opt/sybase_server/a
sybadmin 27795 27794 0 17:02:51 ? 0:01 /opt/sybase_server/ase12.5/ASE-12_5/bin/sybmultbuf 22 7 10 /opt/sybase_server/a

Just killing the first pid, 27794, did the trick. There was no need to use the ‘-9’ option this time, while issuing the kill to sybmultbuf 🙂

bash-2.05$ kill 27794
bash-2.05$ ps -ef | grep buf
sybadmin 29053 28250 0 17:30:52 pts/1 0:00 grep buf

After this I was able to start the backup server and continue on with my dump of a database.

bash-2.05$ nohup sh RUN_SYBASE_SERVER_back &
[1] 29055
bash-2.05$ Sending output to nohup.out

bash-2.05$ tail -f nohup.out
This software contains confidential and trade secret information of Sybase,
…edited…

That’s all folks!

Advertisements
This entry was posted in Sybase. Bookmark the permalink.

8 Responses to Sybase: Backup Server — “No virtual mapping for logical page”

  1. Madanu says:

    There is a tool similar to “tail -f” command. You can use it to monitor the Sybase log files. It shows file size too.

    MakeLogic tail is a GUI based freeware tool available from

    http://www.makelogic.com/tail/TailHome.htm

    Hope some of you may find this free tool helpful.

    Thanks,
    Madanu,
    http://www.makelogic.com

  2. Ohi Akhibi says:

    I am not sure if its OK to post this here. Pls correct me if I am wrong.

    This errors occurred when loading production database.

    Jul 25 11:47:20 2007: Backup Server: 3.29.2.1: No virtual mapping for logical page 1113678771.
    Jul 25 11:47:20 2007: Open Server Error: 16113.10.0: Invalid object id found in srv_putmsgq()..

    Jul 25 11:47:20 2007: Backup Server: 3.14.2.4: Logical page 1113678771 is not in the given database map.

    Jul 25 11:48:23 2007: Backup Server: 6.32.2.3:/dev/rmt/1mn: volume not valid or not requested

    Could you help with a solution or a pointer/link

  3. swinful says:

    Hi Akhibi. Request for — or, try to load another dump file. The dump you are loading is probably corrupt and Sybase does not like it. You may have to restart your backup server before re-loading. If the problem persist, I would suggest you open a case with Sybase.

    Good Luck!
    -swinful

  4. Naveen says:

    Hi, thanks for the information. I was very much thankful to you. Very good stuff.

  5. Vishnu says:

    Hi Thanks …I am able to trouble shoot my problem very easily by reading this info.

  6. Seema Dave says:

    Good posting and thanks for same. I have solved my problem. It is very useful.

  7. DBA says:

    Thank You Very Much! Helpful Post

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s