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.

Since upgrade from SQL Anywhere 9 to 16 (build 2283) we have problems with the database server that does not response anymore. All clients that are connected are freezing. A new connection in ISQL freezes after a click on the "Connect" button.

With request log we saw that the problem is in the command xp_startmail(). I created a small test sp that sends a email using the startmail, but the behavior is not always the same. Sometimes the db server freezes sometimes not.

asked 20 Sep '16, 04:31

SamuelCosta's gravatar image

SamuelCosta
113
accept rate: 0%

closed 20 Sep '16, 08:37

Graeme%20Perrow's gravatar image

Graeme Perrow
8.4k369107

Could you show a snippet of your code to connect via MAPI and to send the mail, say, to show whether you check the return code for xp_startmail and the like?

Note that v16 has introduced the new xp_get_mail_error_text system procedure and xp_get_mail_error_code system procedure that could be of help here - in case you get a return code before the engine freezes...

Does the behaviour depend on the user/privileges trying to mail and/or the kind of recipient (part of your mail domain or not)?

(20 Sep '16, 05:56) Volker Barth

sorry i'm so bored about this issue, that i did not think clearly... actually i'm using xp_startsmtp(); xp_sendmail(); xp_stopsmtp();

i will direct for the xp_startsmtp question.

(20 Sep '16, 06:42) SamuelCosta

The question has been closed for the following reason "The question was asked in error" by Graeme Perrow 20 Sep '16, 08:37

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:

×187

question asked: 20 Sep '16, 04:31

question was seen: 96 times

last updated: 20 Sep '16, 08:37