View Issue Details

IDProjectCategoryView StatusLast Update
0006387VALENTINA SERVERClientpublic2014-08-05 11:34
ReporterHelge TjeltaAssigned ToIvan Smahin 
PriorityhighSeveritycrashReproducibilityalways
Status assignedResolutionopen 
PlatformINTELOSMac OSOS Version10.8
Product Version5.1 
Target VersionTODO_BUGSFixed in Version 
Summary0006387: Can not change Client Idletimeout, stays at 5 mins
DescriptionTrying to change the idletimeout, doing it from Valentina studio says "writing INI file". The ini file contains the changes. But the server still close after 5 min.

This is with a Realbasic client. This works before with v4.9. But this v5.0, 5.1 and 5.2 does not work.

It the only place to change this, in valentina studio pro and that ini file... or is it possible to change the idletimeout from somewhere else, ie. in my client(realbasic)
/Helge
TagsNo tags attached.

Activities

Ivan Smahin

Ivan Smahin

2013-05-16 09:48

manager   ~0006994

There is SQL command:

SET PROPERTY MAXIDLECLIENTTIMEOUT OF server TO 20;

http://www.valentina-db.com/docs/dokuwiki/v5/doku.php?id=valentina:vcomponents:vsql:reference:properties:server_props&s[]=set&s[]=property#maxidleclienttimeout
Helge Tjelta

Helge Tjelta

2013-05-16 12:56

reporter  

Skjermbilde 2013-05-16 kl. 14.47.19.png (69,746 bytes)
Helge Tjelta

Helge Tjelta

2013-05-16 13:02

reporter   ~0006996

Last edited: 2013-05-16 13:29

View 4 revisions

I tried this:
  Dim resultat as integer
  resultat = mDatabase.SqlExecute("GET PROPERTY MAXIDLECLIENTTIMEOUT OF server;")
  msgbox str(resultat)

In it returned 0, but the ini file contains 1100 ?

Tried : GET PROPERTY PORT OF server; and this also gets 0, so I'm not comunication in the right way ?


Now I send just this from realbasic:
msgbox str(mConnection.SqlExecute("GET PROPERTY PORT OF server;"))

but still only 0 as result...

Ivan Smahin

Ivan Smahin

2013-05-17 09:52

manager   ~0007000

Also note, that changing this setting affects connections which being made after that changes only (existed connections stil use "old" MAXIDLECLIENTTIMEOUT).
Ivan Smahin

Ivan Smahin

2013-05-17 09:54

manager   ~0007001

I guess it is actually SQL-NULL value. Do you have an "admin" privilege like default sa user?
Helge Tjelta

Helge Tjelta

2013-05-17 19:02

reporter   ~0007005

Yep, I do it in my login window. then I disconnect and connect again with chosen user. Both the login window (which gets all users), and my user that I log in with, are both adminusers.

So I have admin rights, and do a two times connection. but still I get kicked out.
/helge
Ivan Smahin

Ivan Smahin

2013-05-18 08:53

manager   ~0007006

Can not reproduce it. Sounds weird.
Ok, could you run your vServer with following settings - VERBOSELEVEL = 3, LOGTOFILE = 1.
Then, do the steps above to reproduce "early" disconnection after enlarging MAXIDLECLIENTTIMEOUT
and send vServer log to me?

Also you can try following:
- Run vServer
- Change MAXIDLECLIENTTIMEOUT via vStudio (you can try both - vStudio GUI and query from SQL Editor)
- Run any V4RB example (let it be VSQL/Table_CreateDrop). You will be connected to vServer immediately.
Do nothing with this app just waiting for timeout reached.
Ivan Smahin

Ivan Smahin

2013-05-18 08:56

manager   ~0007007

resultat = mDatabase.SqlExecute("GET PROPERTY MAXIDLECLIENTTIMEOUT OF server;")
  msgbox str(resultat)

It is wrong. That query produces cursor (yes - single field and single row - but not a bare value!)
So you should do SqlSelect( "GET PROPERTY MAXIDLECLIENTTIMEOUT OF server;") instead.

SqlExecute is able to return affected row-count only!
Helge Tjelta

Helge Tjelta

2013-05-19 22:42

reporter  

vserver_x64_20130514_190750.log (4,215 bytes)
Helge Tjelta

Helge Tjelta

2013-05-19 22:44

reporter   ~0007011

I got it using sqlselect.

I now do it first time login, with the set command.

In my actual loing is use the get command, it now reads a new time: 50000 but still after a while I get kicked out.
Ivan Smahin

Ivan Smahin

2013-05-20 07:05

manager   ~0007013

Ok, could you send me vServer log I mentioned above?

BTW, we can use any IM like skype, ICQ, ... for better responsiveness.
Some time ago you were asking something about localization - is it solved or not?
Helge Tjelta

Helge Tjelta

2013-05-20 10:50

reporter   ~0007015

Hi Ivan, I have attached a log file, isn't that the one you are asking for ?

Also, hte localization is solved I think, the only thing now is idletimeout and sorting with upper and lowercases, now it treats them differently, but I want it to treat upper and lower case as the same....

But the timeout is the most important.... my skype is helgetjelta
Helge Tjelta

Helge Tjelta

2013-05-20 10:52

reporter   ~0007016

Also, I noticed that everytime my app crashes (my client) the server starts at 0 again in the serverprefspane, why?
Ivan Smahin

Ivan Smahin

2013-05-20 12:22

manager   ~0007017

It seems you are running vServer with VERBOSELEVEL = 2 or even 1. I need VERBOSELEVEL = 3 to see detailed vServer activity.

BTW, "Client has been suddenly disconnected" does not mean that vServer disconnects client because of any timeout. It means vClient closes communication socket itself without any vServer notification (like vConnection.Close()).
Ivan Smahin

Ivan Smahin

2013-05-20 12:26

manager   ~0007018

> Also, I noticed that everytime my app crashes (my client) the server starts at 0 again in the serverprefspane, why?

Do you mean vServer connection count?
If so, vServer see that socket is closed by vClient and close such a "dead" connection.
Ruslan Zasukhin

Ruslan Zasukhin

2013-05-20 13:38

administrator   ~0007019

i.e. client app have crashed for example...
Ruslan Zasukhin

Ruslan Zasukhin

2013-05-20 13:38

administrator   ~0007020

> Also, I noticed that everytime my app crashes (my client) the server starts at 0 again in the serverprefspane, why?

* do you mean OS X prefs pane "Valentina Servers"
* or preferences of Valentina Studio ?
Ruslan Zasukhin

Ruslan Zasukhin

2013-05-20 13:40

administrator   ~0007021

above I see picture with error
  VException was not catched ...

But THIS IS WHY your app crashes actually.

You need add try catch at least on top level of app
or around Valentina calls.

you have some error, it throws as exception, you NOT catch it in your code => crash
Helge Tjelta

Helge Tjelta

2013-05-20 15:45

reporter   ~0007023

the preferencepane of the server, where it says "Running" normally, this starts at 0d00h00m.

also, yes I have not build the client with a lot of TRY. Ruslan, does every call for SQL need to be with a TRY and to build cathing errors ? I have not concentrated on that before.

Also, why does this happens, the client app sits still for some time, and it gets kicked out, and server reports Client has been suddenly disconnected...
Helge Tjelta

Helge Tjelta

2013-05-20 15:48

reporter   ~0007024

Also, does it help if I send you the sourcefile... ?

I'll point to the methods doing the connection... although it is written a lot of norwegian in it, it should be possible to take a look at it...

It is now made with Xojo b17.
Helge Tjelta

Helge Tjelta

2013-05-20 18:04

reporter   ~0007025

But, all this problems has happend while the program/client i Silent/idle... so why does this happens. It is silent for a given time, and I might wait for 100 minutes or more, and when I first do a sql is crashes.

But nothing is happening with the program during this time... it is silent.
Helge Tjelta

Helge Tjelta

2013-05-20 19:10

reporter   ~0007026

what does that error code mean anyway ?
Ruslan Zasukhin

Ruslan Zasukhin

2013-05-20 19:21

administrator   ~0007027

Sun May 19 2013 23:33:33.806365 (TID 4344778752): (UID 27) ERROR 0x82517: Database with name "UNKNOWN" must be opened or created before operation.
Sun May 19 2013 23:34:07.690530 (TID 4344778752): (UID 27) Client has been suddenly disconnected


------
sounds like app tries operate on a closed (not opened yet) db
Helge Tjelta

Helge Tjelta

2013-05-20 19:31

reporter   ~0007028

But the app has been up and running all the time, no disconnecting, just silent. No operation with the app.... ?

Isn't that odd?
Ivan Smahin

Ivan Smahin

2013-05-21 08:46

manager   ~0007030

BTW, it could be such a disconnections because of MAXTRANSFERTIMEOUT (timeout to pass/receive anything to/from vServer ). Please try to change it or off it completely ( MAXTRANSFERTIMEOUT = 0).

Also, it would be very helpful to see vServer log with VERBOSELEVEL = 3 (the log you attached is either VERBOSELEVEL = 2 or even 1)- please do all the stuff for getting disconnection and send that log to me.
Helge Tjelta

Helge Tjelta

2013-05-21 10:56

reporter  

vserver_x64_20130521_113748.log (68,633 bytes)
Helge Tjelta

Helge Tjelta

2013-05-21 10:57

reporter  

Warnings_20130521_113748.log (2,302 bytes)
Helge Tjelta

Helge Tjelta

2013-05-21 10:57

reporter  

vserver_x64_20130521_113516.log (12,881 bytes)
Helge Tjelta

Helge Tjelta

2013-05-21 10:57

reporter  

vserver_x64_20130520_122431.log (9,845 bytes)
Helge Tjelta

Helge Tjelta

2013-05-21 10:57

reporter  

vserver_x64_20130520_121040.log (46,340 bytes)
Helge Tjelta

Helge Tjelta

2013-06-07 20:49

reporter   ~0007060

I have now made a workaround, I do a timer with a call to the database for every 90 sec, now it is alive forever...

The logs was supplied 21/5..

Issue History

Date Modified Username Field Change
2013-05-15 20:20 Helge Tjelta New Issue
2013-05-16 09:40 Ivan Smahin Assigned To => Ivan Smahin
2013-05-16 09:40 Ivan Smahin Status new => assigned
2013-05-16 09:48 Ivan Smahin Note Added: 0006994
2013-05-16 12:56 Helge Tjelta File Added: Skjermbilde 2013-05-16 kl. 14.47.19.png
2013-05-16 13:02 Helge Tjelta Note Added: 0006996
2013-05-16 13:03 Helge Tjelta Note Edited: 0006996 View Revisions
2013-05-16 13:05 Helge Tjelta Note Edited: 0006996 View Revisions
2013-05-16 13:29 Helge Tjelta Note Edited: 0006996 View Revisions
2013-05-17 09:52 Ivan Smahin Note Added: 0007000
2013-05-17 09:54 Ivan Smahin Note Added: 0007001
2013-05-17 19:02 Helge Tjelta Note Added: 0007005
2013-05-18 08:53 Ivan Smahin Note Added: 0007006
2013-05-18 08:56 Ivan Smahin Note Added: 0007007
2013-05-19 22:42 Helge Tjelta File Added: vserver_x64_20130514_190750.log
2013-05-19 22:44 Helge Tjelta Note Added: 0007011
2013-05-20 07:05 Ivan Smahin Note Added: 0007013
2013-05-20 10:50 Helge Tjelta Note Added: 0007015
2013-05-20 10:52 Helge Tjelta Note Added: 0007016
2013-05-20 12:22 Ivan Smahin Note Added: 0007017
2013-05-20 12:26 Ivan Smahin Note Added: 0007018
2013-05-20 13:38 Ruslan Zasukhin Note Added: 0007019
2013-05-20 13:38 Ruslan Zasukhin Note Added: 0007020
2013-05-20 13:40 Ruslan Zasukhin Note Added: 0007021
2013-05-20 15:45 Helge Tjelta Note Added: 0007023
2013-05-20 15:48 Helge Tjelta Note Added: 0007024
2013-05-20 18:04 Helge Tjelta Note Added: 0007025
2013-05-20 19:10 Helge Tjelta Note Added: 0007026
2013-05-20 19:21 Ruslan Zasukhin Note Added: 0007027
2013-05-20 19:31 Helge Tjelta Note Added: 0007028
2013-05-21 08:46 Ivan Smahin Note Added: 0007030
2013-05-21 10:56 Helge Tjelta File Added: vserver_x64_20130521_113748.log
2013-05-21 10:57 Helge Tjelta File Added: Warnings_20130521_113748.log
2013-05-21 10:57 Helge Tjelta File Added: vserver_x64_20130521_113516.log
2013-05-21 10:57 Helge Tjelta File Added: vserver_x64_20130520_122431.log
2013-05-21 10:57 Helge Tjelta File Added: vserver_x64_20130520_121040.log
2013-06-07 20:49 Helge Tjelta Note Added: 0007060
2013-12-15 16:37 Ruslan Zasukhin Target Version => 6.0
2014-02-14 10:35 Ruslan Zasukhin Target Version 6.0 => 7.0
2014-02-14 10:36 Ruslan Zasukhin Target Version 7.0 => 5.5.4
2014-08-05 11:34 Ruslan Zasukhin Target Version 5.6 => TODO_BUGS