Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: [FireDAC][Stan]-700 Timeout expired (PostgreSQL)



Permlink Replies: 3 - Last Post: Sep 18, 2017 9:22 PM Last Post By: Dmitry Arefiev
Dmitry Vavilov

Posts: 29
Registered: 9/23/17
[FireDAC][Stan]-700 Timeout expired (PostgreSQL)
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 17, 2017 10:19 PM
Hello!
When set ResourceOptions.CmdExecTimeout: = 0, the query is canceled immediately with a message "[FireDAC] [Stan] -700 Timeout expired" (RAD Studio 10.2.1, PostgreSQL).
Lajos Juhasz

Posts: 801
Registered: 3/14/14
Re: [FireDAC][Stan]-700 Timeout expired (PostgreSQL)
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 17, 2017 10:56 PM   in response to: Dmitry Vavilov in response to: Dmitry Vavilov
Dmitry Vavilov wrote:

Hello!
When set ResourceOptions.CmdExecTimeout: = 0, the query is canceled
immediately with a message "[FireDAC] [Stan] -700 Timeout expired"
(RAD Studio 10.2.1, PostgreSQL).

Most probably as expected you're setting the timeout to 0ms that's not
enough to execute anything. According to :
http://docwiki.embarcadero.com/Libraries/Berlin/en/FireDAC.Stan.Option.TFDResourceOptions.CmdExecTimeout

Use the CmdExecTimeout property to control the DBMS action execution
timeout. The value < = 0 means no timeout. The default value is -1. The
time is expressed in milliseconds (0.001 sec).


If you would like to have no timeout you should leave the default -1
otherwise you should use a reasonable values like 5000.
Dmitry Vavilov

Posts: 29
Registered: 9/23/17
Re: [FireDAC][Stan]-700 Timeout expired (PostgreSQL)
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 18, 2017 4:06 AM   in response to: Lajos Juhasz in response to: Lajos Juhasz
Lajos Juhasz wrote:
Dmitry Vavilov wrote:

Hello!
When set ResourceOptions.CmdExecTimeout: = 0, the query is canceled
immediately with a message "[FireDAC] [Stan] -700 Timeout expired"
(RAD Studio 10.2.1, PostgreSQL).

Most probably as expected you're setting the timeout to 0ms that's not
enough to execute anything. According to :
http://docwiki.embarcadero.com/Libraries/Berlin/en/FireDAC.Stan.Option.TFDResourceOptions.CmdExecTimeout

Use the CmdExecTimeout property to control the DBMS action execution
timeout. The value < = 0 means no timeout. The default value is -1. The
time is expressed in milliseconds (0.001 sec).


If you would like to have no timeout you should leave the default -1
otherwise you should use a reasonable values like 5000.

There it is written less than or equal to 0. I have equal 0. The number of timesTimeout is of the Cardinal type. Less than 0 can not be put.
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: [FireDAC][Stan]-700 Timeout expired (PostgreSQL)
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 18, 2017 9:22 PM   in response to: Dmitry Vavilov in response to: Dmitry Vavilov
Really only $FFFFFFFF works as "no timeout".

--
With best regards,
Dmitry
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02