Executing a stored procedure makes the network database server stop.

The procedure declares a FOR loop (cursor) where it iterates a proxy table. Running the procedure I get "communication error" as the network database service sometimes stops. However sometime I do get a successful run.

the proxy table is located in a remote server (oracle), so it seems to be an issue with the communication between sybase/oracle.

Transcript of console.log

I. 12/12 13:59:07.     TCPIP link started successfully
I. 12/12 13:59:07. Now accepting requests

-the procedure is called and no information on why it stopped

-Restart after crash

I. 12/12 13:59:47. SQL Anywhere Network Server Version 12.0.1.3817 I. 12/12 13:59:47.

I am able to do crash the db network service by running a sql towards the proxy table also.

SELECT * FROM PROXY_ORACLE_TABLE;

There's less than 50 rows (though there is a blob column).

alt text

Is there a db log which would give me more details to figure out what's causing this? Or does anyone have an idea of what the issue might be?

asked 12 Dec '12, 05:43

Kman's gravatar image

Kman
1114411
accept rate: 0%

edited 12 Dec '12, 08:31

Reimer%20Pods's gravatar image

Reimer Pods
4.2k334481

Use "Remote Data Access Debugging" aka setting the CIS_OPTION = 7 might help. In general, I agree with Thomas's suggestion to avoid (or more correctly: reduce the probability of) such situations.

(12 Dec '12, 06:22) Volker Barth

The exception must be found in the Sybase DB Server as this is the one which stops. The remote server is running fine

(12 Dec '12, 07:16) Kman
Replies hidden

Does the database server stop (e.g. by a crash), or is it only the connection that is dropped? Does the console log (dbsrv12 -o myLog.txt) show anything of interest?

I would doubt that a crashing (or hung up) database server would send a -85 error...

(12 Dec '12, 07:31) Volker Barth

The server stops (crash), yes. No the console log does not show anything about why or even that it did stop. I've added a transcript to the question

(12 Dec '12, 07:59) Kman

I've set cis_rowset_size = 1, which seems to make it more stable, though it's too early to say for sure

(12 Dec '12, 09:22) Kman
Replies hidden

Do you have a support contract? If so, we would be interested in investigating the remote server proxy crash. You can also auto-submit any outstanding collected dump files by using dbsupport -sa.

You might also want to try the latest 12.0.1 EBF if you haven't already done that.

(18 Dec '12, 15:11) Jeff Albion

FWIW, the above log excerpt shows 12.0.1.3817, which is the latest EBF, isn't it?

(18 Dec '12, 17:00) Volker Barth

Ah, yes - that is correct Volker, thanks. Sorry about that.

We should definitely attempt to capture more details about the crashing behaviour.

Which Oracle ODBC driver are you using? Are you using the "iAnywhere Solutions" version included with SQL Anywhere or are you using Oracle's ODBC driver?

(19 Dec '12, 09:44) Jeff Albion

...and setting the CIS_OPTION = 7 seems still worthwhile, methinks...

(19 Dec '12, 10:06) Volker Barth
showing 4 of 9 show all flat view

If the possibility exists that the server is down. I would copy the rows into a temp table and work on that set.

Even then it is possible that the server stops responding during the select.

Hope This Helps

permanent link

answered 12 Dec '12, 06:06

Thomas%20Duemesnil's gravatar image

Thomas Dueme...
2.5k233560
accept rate: 15%

It is the Sybase Network database server which stops while running this procedure. So a temporary table would not help. It fails while using the remote server proxy table. The remote server is running fine though.

(12 Dec '12, 07:09) Kman
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:

×104
×61
×46

question asked: 12 Dec '12, 05:43

question was seen: 895 times

last updated: 19 Dec '12, 10:06