Monday, July 6, 2015

sqlr-listener error:

ERROR:

sqlr-listener error:
        Unable to create a shared memory segment.  This is usally because an
        sqlr-listener is already running for the rovi instance.

        If it is not running, something may have crashed and left an old segment
        lying around.  Use the ipcs command to inspect existing shared memory
        segments and the ipcrm command to remove the shared memory segment with
        id -1.

        Error was: File exists


sqlr-connection error:
        The pid file /usr/local/var/sqlrelay/tmp/pids/sqlr-listener-rovi was not found.
        This usually means that the sqlr-listener
is not running.
        The sqlr-listener must be running for the sqlr-connection to start.


FIX:

Step 1: get shared memory info:
root@devtest:~# ipcs

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status
0x0101520c 385941504  ubuntu     640        679968     7
0x01015379 385974273  nobody     640        679968     3

------ Semaphore Arrays --------
key        semid      owner      perms      nsems
0x0101520c 9437184    ubuntu     600        13
0x01015379 9469953    nobody     600        13

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages

Step 2: remove shared memory
ipcrm -m 385941504
ipcrm -m 385974273

Step 3:
start sqlr:
sqlr-start -id abc
sqlr-start -id efg




No comments:

Post a Comment