The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

I'm runnung SA16 (16.0.0.2043) under linux (Ubuntu/trusty64) and VirtualBox as a service using the commands:

$ sudo /opt/sqlanywhere16/bin64/dbsvc -as -t network -s automatic -w demosvc -n demo -xd -x "tcpip(serverport=2600)" -oe /home/vagrant/demo/demo_errors.txt /home/vagrant/demo/demo.db
$ sudo service SA_demosvc start
That works fine, and I can successfully connect to the database service from Sybase Central.

The problem is that, sometimes, when I shutdown the machine and restart it, the service does not start up. If I try to start it manually, I see:

$ sudo service SA_demosvc start
Starting SAL Anywhere "Network" service demosvc
* Communication error
and the error file (demo_errors.txt) contains:
A Database server with that name has already started
Communication error

I've tried stopping the service - says there isn't one.
I've tried deleting the re-creating the service - problem persists.

I have found an unsatisfactory work-around that involves deleting the service and recreating it with a different server name (e.g.,, -n demo2), but that screws up the connection parameters for every client that is trying to use the database.

Has anyone else seen this? Am I missing something?

asked 29 Jan '15, 14:27

Terry%20Wilkinson's gravatar image

Terry Wilkinson
496142036
accept rate: 50%

edited 29 Jan '15, 14:30

OOPS! that was the problem!!!!!!! Thanks Breck!! I'd up-vote you if this was an answer :-(

(29 Jan '15, 14:49) Terry Wilkinson

Do you have a SQL Anywhere server (service or foreground) running on another computer, using that server name? There can be only one :)

alt text

permanent link

answered 29 Jan '15, 14:35

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%

Thanks for the help Breck. I didn't immediately think of that constraint, and the error message, though completely accurate, didn't jog my memory.

(29 Jan '15, 22:34) Terry Wilkinson
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×186
×60
×33
×14

question asked: 29 Jan '15, 14:27

question was seen: 602 times

last updated: 29 Jan '15, 22:34