I get the following exception when trying to start Servoy or create a new server:
java.sql.SQLException:JZ006: Caught IOException:
java.net.ConnectionException: Connection refused
The server is on an OSX machine that has SQLAnywhere 9.0 installed as well. I am able to start the Servoy-shipped ASA engine from the console, but cannot start Servoy. Permissions for the repository are correct.
“Connection refused” , normally means the database is not running (not listning for connection requests)
When starting Servoy do you see Sybase process in the list of processes on your machine?
dbserv9 appears on the activity monitor after I start Servoy. I get the error message, exit Servoy, then the dbserv9 process is gone.
atm_miguel:
dbserv9 appears on the activity monitor after I start Servoy. I get the error message, exit Servoy, then the dbserv9 process is gone.
Same problem here like last time
The dbserv9 process appears just before the startup-spalsh but is gone a few seconds later.
BTW starting up after installation is no problem but the issue occurs after restart or the next startup
OSX.3.5
Java 1.4.2 (last upgrade)
Servoy_2.1.1_RC1
Are you receiving an error message in the sybase log (sybase_log.txt)? This can be found in ‘/Applications/Servoy/sybase_db/’ on OSX.
-Ian
ijohnson:
Are you receiving an error message in the sybase log (sybase_log.txt)? This can be found in ‘/Applications/Servoy/sybase_db/’ on OSX.-Ian
This is my sybase_log.text:
I. 10/20 23:05:15. Database server started at Wed Oct 20 2004 23:05
I. 10/20 23:05:15. Trying to start SharedMemory link …
I. 10/20 23:05:16. SharedMemory link started successfully
I. 10/20 23:05:16. Trying to start TCPIP link …
I. 10/20 23:05:16. Starting on port 2638
I. 10/20 23:05:16. TCPIP link started successfully
I. 10/20 23:05:16. Now accepting requests
I. 10/20 23:43:12. Connection terminated abnormally
I. 10/20 23:43:12. Connection terminated abnormally
I. 10/20 23:43:12. Connection terminated abnormally
I. 10/20 23:43:12. Connection terminated abnormally
I. 10/20 23:43:12. Connection terminated abnormally
I. 10/20 23:43:12. Connection terminated abnormally
E. 10/21 14:45:21. Database cannot be started – “/Applications/Servoy_2.1.1_RC1/database/crm.db” unable to open transaction log
E. 10/21 14:46:54. Database cannot be started – “/Applications/Servoy_2.1.1_RC1/database/log_data.db” unable to open transaction log
E. 10/21 14:49:02. Database cannot be started – “/Applications/Servoy_2.1.1_RC1/database/log_data.db” unable to open transaction log
E. 10/21 20:55:07. Database cannot be started – “/Applications/Servoy_2.1.1_RC1/database/log_data.db” unable to open transaction log
What means “unable to open transaction log” and how is it related to these problems???
Thanks…
It means the sybase engine is not able to open the corresponding transaction logs for those databases. The transaction logs keep track of changes to the database (in the ‘database_name.log’ files in servoy’s ‘database’ directory). This could be caused by a permissions error (with the .log files), or it could be due to a corrupt database or log file (more likely). Jan may have a better answer for you, and the following thread might help:
Good Luck.
Sorry guys,
But I can’t figure this out
Controlled and recoverd permissions with DiskUtillity, installed 2.1.1_F again, but after restart or startup still got the same problems…
I assume you did this but to be sure: Did you close your old Sybase connection(s) before installing the new servoy version.
I also assume you did a clean (new directory) install to see what happens then…
I really don’t understand why you didn’t succeed yet. I move all my stuff back and forward all the time without any issues…
Bert,
Try DELETING the .log files (in the “database” folder of your Servoy folder).
FIRST - EXIT Servy and STOP the sybase service.
Restart Servoy - should be fine.
Bob Cusick
OK, thanks.
I’ll let you know how things work out,
bcusick:
Bert,Try DELETING the .log files (in the “database” folder of your Servoy folder).
FIRST - EXIT Servy and STOP the sybase service.
Restart Servoy - should be fine.
Bob Cusick
Hi Bob,
Did delete the .log files as you suggested wich worked fine untill I did a restart the problem accured again
I was thinking (yep… sometimes ) maybe I got some priviledges all messed up so I made a new user as root and installed the latest version 2.1.2 Final but things started to go wrong again like I told before.
Can you suggest me what to next and tell me also what the log files are for also related to this problem.
Thanks for your time,
Bert.
Bert, I suggest you send me te following files:
after a power failure last nite, i’m having these same problems too.
i can’t get any work done, and have lots to do this
weekend. has anyone solved this?
thanks very much
rm.
Sybase can’t open the databases ?
Maybe they are left in an invalid state or something.
Anyway…try using Sybase Central and connect to the database file and try to validate it (under the Tools menu).
HTH
P.S. Merry Christmas
I tried using Sybase Central, although I’ve never used it
before, and don’t really know what it’s for. It seemed
unable to locate any servers.
I looked at the sybase_log.txt file, and found this:
E. 12/24 12:41:51. Cannot open transaction log file – Can’t use log file “crm.log” since it is shorter than expected
E. 12/24 12:43:29. Cannot open transaction log file – Can’t use log file “crm.log” since it is shorter than expected
E. 12/24 12:45:22. Cannot open transaction log file – Can’t use log file “crm.log” since it is shorter than expected
so I deleted the database & log files I had no use for:
user_data.db, example.db, log_data.db, & crm.db.
then, when trying to start servoy, I’d get this in the sybase_log.txt file:
E. 12/24 12:48:35. Could not open/read file: database/user_data.db
E. 12/24 12:48:35. Could not open/read file: database/example.db
E. 12/24 12:48:35. Could not open/read file: database/log_data.db
E. 12/24 12:48:35. Could not open/read file: database/crm.db
after this, I edited the sybase.config file, and removed the following
lines:
database/user_data.db
database/example.db
database/log_data.db
database/crm.db
after this, I was able to run again.
I’m very confused about what happened, and would like to know
more about this so I can be ready in case anything like this happens
again in the future.
thanks.
(happy holidays to as well, Roclasi!)
Did you try the recommendations listed earlier on this thread?
http://forum.servoy.com/viewtopic.php?t … action+log
I found that -f command works very well when you have set the paths (your path will be different of course than the one listed). I did find that I had to delete the log files on the non-repository db’s like crm, etc. I found that that I got this damage whenever my G5 crashed while I was running Servoy (and thus Sybase).
RobertMeyer:
Cannot open transaction log file – Can’t use log file “crm.log” since it is shorter than expected
I you have copied a log or a db file (and not both at same time) you can just delete the log if this msg is displayed. (only do this if the database is closed properly last time, if not the log can contain important information!)