New Ranks & Badges For The Community!
Notice something different? The ranks and associated badges have gone "Star Fleet". See what they all mean HERE
Highlighted
Absent Member.. Absent Member..
Absent Member..
1141 views

sybase stops suddenly

Sybase pmdb stops suddenly

 

 

can't start it the first try:
see end of: SybaseService.log

 

I. 06/26 13:44:00. Recovery complete
I. 06/26 13:44:00. Database "pmdb" (pmdb.db) started at Fri Jun 26 2015 13:44
I. 06/26 13:44:00. ... recovery 100% complete
I. 06/26 13:44:00. IQ Server shr.
I. 06/26 13:44:00. Database server started at Fri Jun 26 2015 13:44
I. 06/26 13:44:00. Trying to start SharedMemory link ...
E. 06/26 13:44:00. Shared Memory function startLocalRequestManager failed
I. 06/26 13:44:00. SharedMemory communication link not started
E. 06/26 13:44:00. Cannot allocate local port.
I. 06/26 13:44:00. Database server shutdown due to startup error
I. 06/26 13:44:00. Starting checkpoint of "pmdb" (pmdb.db) at Fri Jun 26 2015 13:44
I. 06/26 13:44:01. Finished checkpoint of "pmdb" (pmdb.db) at Fri Jun 26 2015 13:44
I. 06/26 13:44:01. Database server stopped at Fri Jun 26 2015 13:44
DBSPAWN ERROR: -85
Communication error
Using licenses from: /opt/HP/BSM/Sybase/SYSAM-2_0/licenses/SYBASE.lic
Checked out support-graced license for 4 IQ_CORE (2013.11240/permanent/05A6 8C85 8424 E91B).
Checked in license for 4 IQ_CORE (2013.11240/permanent/05A6 8C85 8424 E91B).
Checked in license for 4 IQ_CORE (2013.11240/permanent/05A6 8C85 8424 E91B).

Shared Memory function startLocalRequestManager failed Cannot allocate local port.
Server failed to start

 

 

after second try it starts, but after while it dies again

 

 

$PMDB_HOME/config/pmdbConfig.cfg already contains "-iqgovern 50" parameter

 

can't find any error

 

any help is welcome

 

thx

R

 

 

 

lsof -i | grep 21424 | grep LISTEN

 

 

 

Labels (1)
Tags (1)
0 Likes
3 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hi Radkokeves,

 

Please check the below points:

 

  1. Verify the database name is unique. there is a possibility that the database fails to start if the Server Name Is Not Unique on Your Network.
  2. If multiple servers on your system have the same name, messages appear in the server log file (*.srvlog or the name specified in the -o startup option) when you attempt to start the server using start_iq.
    DBSPAWN ERROR:  -85
    Communication error
    If you see these errors in the server log file and the server does not start, try to start the server using the iqsrv16 command. The iqsrv16 command returns a more specific error message:
    A database server with that name has already started

    Once you have verified that the problem is a duplicate server name on your network, start the server with a name that is different from the names of servers that are already running.

 

 

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

for some unexpected and unexplained reason Sybase bundled with SHR logs into /var/log/messages...

 

who knew ?

 

in my case Sybase kept dying it was due to unsufficient RAM/SWAP sizing

0 Likes
Highlighted
Fleet Admiral
Fleet Admiral

If there is plenty of memory available on server try increasing Sybase main cache (iqmc) and temporary cache (iqtc). This might help.

 

Close the thread if your issue is resolved to make the thread meaningful and complete. Do show gratitude to people who helped you by assigning points.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.