Hot Topic (More than 10 Replies) Stability (Read 21185 times)
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Stability
Aug 1st, 2020 at 1:40pm
Print Post Print Post  
Running Sesame 2.5.3 server on Windows XP workstation (11 years).  Most workstations running Windows 7.   

If, in the morning, I open up 'server admin' on the servers, unload my Sesame application, then 'stop this server', then reload the server, usually Sesame on the network will run just fine all day (may one server 'unlock/restart' needed).

But, if I don't do the above (unload/reload at beginning of the day), Sesame clients are likely to randomly and often just disappear from the workstation screen in the middle of a task, and the Sesame client has to be restarted.  Maddening.

I'm sure it's some kind of an issue with my internal network (tcp pipes?) that's causing the client to lose its 'Sesame' communication link with the server.  But I can't figure it out.  I have removed the anti-virus program from the server, and have tested results with a workstation's anti-virus program disabled, but that did not improve reliability.

It's not disabling, but irritating, and it does present ongoing productivity obstacles when I'm working from home, trying to get stuff done on Sesame through the Internet ... thus my original question about 'Sesame life in the cloud'.

ps - Ace, I remember you posting some here a decade ago - am happy to see you still kicking!
  

Larry
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Stability
Reply #1 - Aug 3rd, 2020 at 12:58pm
Print Post Print Post  
One of the first things I would recommend is to upgrade to Sesame 2.6.4. There was a lot of network changes/fixes between 2.5.3 and the latest version.

It almost sounds like something is going to sleep and closing ports but again I would upgrade to eliminate chasing an old issue that has already been fixed.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #2 - Aug 3rd, 2020 at 2:32pm
Print Post Print Post  
Ray,

Yes, understood.  That 'feels' like excellent advice.  (Poking a bit of fun at myself - solutions that were 'no brainers' 10 years ago, somehow now, at 64yrs old, become problematic for this 'well on my way to becoming a no brainer' business owner and past programmer.  I'll mull over whether I have one more 'upgrade in me'.)   Wink Sad Huh

ps - Running Windows XP workstation as server; Running Windows 7 client workstations.  Do I have to be aware of any caveats or preps before upgrading from 2.5.3 to 2.6.4 ?
« Last Edit: Aug 3rd, 2020 at 3:53pm by lksseven »  

Larry
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #3 - Sep 13th, 2022 at 12:55pm
Print Post Print Post  
Hi Ray,

I'm Haley's Comet circling back ...  I still have not upgraded from ver 2.5.3 (I've been trying to hold out for retirement and save my brain bruise).  But retirement still a ways off and some days the instability of this Sesame issue is a hair puller.

Yesterday I loaded a local Sesame client on the Sesame server, and the local client just disappeared in the middle of a task, forcing me to reload the client. 

So, this suggests to me that all of my problem may not be a Windows network issue, but rather either a programming issue in my Sesame, or possibly a file corruption issue in my database?
  

Larry
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Stability
Reply #4 - Sep 13th, 2022 at 1:48pm
Print Post Print Post  
Are you running the local client using the server name or localhost?

Just curious but either way is still using the network. Now if you launch Sesame standalone and it has the same issue, yes it's not a network issue and could be a programming or data issue. Here again there have been a LOT of changes since 2.5.3 so I would upgrade. The upgrade is a simple process. Just shut down Sesame, Run the update on the Server and ALL clients, and then start it all back up.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #5 - Sep 18th, 2022 at 7:39pm
Print Post Print Post  
Thank you for your reply (and for still being here!).

I opened a local client that is located on the same computer that runs the Sesame server engine.

I will do as you suggest and upgrade.

ps - almost all of my heavy lifting programming with Sesame programming was 2009 - 2012.  I was able to automate so much of my daily tool set of tasks (sales, purchasing, inventory, shipping, invoicing) that I can still be competitive and profitable as a very small and very shorthanded business in 2022.   I could never have continued to be in business without Sesame.  So thank you.
  

Larry
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #6 - Sep 20th, 2022 at 3:21am
Print Post Print Post  
I upgraded to 2.6.4 today.  I'm still losing connections to the Sesame server engine.  Shutting down the sesame server engine and then bringing it back up is the only thing that improves the stability.   I think I need to run the sesame server engine on a different computer and see if that improves stability (maybe I've got a wiggy hardware issue ... I don't see how that could be, though - it's only a 13year old server running Win XP  Smiley)

I'll report what I find out.
  

Larry
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #7 - Sep 20th, 2022 at 4:31pm
Print Post Print Post  
Bingo.  The problems of instability (for 6-8 years) seems to have been an inadequate sized swap file on the WinXP server.  4096mb max physical memory, and the swap file was set at 2048mb.  Once I increased the swap file to max 4096mb, all errors and disconnects and read/write errors stopped.  Amazing.
IF I hadn't upgraded to 2.6.4, I would have never been able to view the granular details that showed just what the problem really was.  Once I could see all the disconnects happening behind the scenes, and then all the read/write errors happening to cause those disconnects (I guess due to not enough swap space allocated), it put 'hardware failure on my radar.  That got me looking at the workings of the server, and that let me come across the swap file and had me thinking "hold my beer and watch what happens when I increase swap file size to the max".
Fingers crossed, but so far so good!
I tried to post before and after pics, but pic pixel count too high.
  

Larry
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #8 - Oct 4th, 2022 at 4:35pm
Print Post Print Post  
All clear swimming with my Sesame Win7 64 desktop workstations.  But the 3 Lenovo Thinkpad laptop workstations will be disconnected by the Sesame server engine, and then have intermittent read/write errors.   Anyone else experience this?
  

Larry
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Stability
Reply #9 - Oct 4th, 2022 at 4:43pm
Print Post Print Post  
Are the Laptops wireless or on the wired network? If wireless, does the problem persist if they are placed on a wired network?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #10 - Oct 4th, 2022 at 4:54pm
Print Post Print Post  
the laptops are connected 'wired'.  Only one of them comes and goes with me, the other two are stationary and wired to the network just like the desktops.

on the Sesame Server screen, it will say "client disconnected 192.168.1.?? (the ip addresses of the laptops), but also it might say 'client disconnected 4PDF"  or "CF226"(part of an inventory part #) ... like the server engine is catching some ephemera transient and mistaking it for a client glitch and so disconnecting it.  when this happens, the disconnect client at the workstation can be accessed and reconnects to the Sesame server, but continues to generate redhighlighted read/file errors on the server engine window, and eventually client gets disconnected again
  

Larry
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Stability
Reply #11 - Oct 7th, 2022 at 4:18pm
Print Post Print Post  
All the Network power saving settings have been turned off and sleep and hibernate are disabled correct? Strange that it's just the laptops.

Data other than the IP address appearing usually happens after a disconnect(or when something other than Sesame is trying to connect) and then garbage gets sent as part of the connection command.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
jacker
Member
*
Offline



Posts: 42
Location: Milwaukee, WI
Joined: May 20th, 2008
Re: Stability
Reply #12 - Oct 26th, 2022 at 3:47pm
Print Post Print Post  
Interesting discussion. I've had similar issues for years, if not decades. 7:30AM every day I pour a cup of coffee, make sure no stragglers are still connected from the previous day, shut down the server, restart it, and unlock all the databases.

I'm running 2.6.4 on a small cloud virtual Windows Server 2008 and I'll typically get 10-13 users connected at once. Sometimes the server can run all day or even for a day or two without the clients timing out, but then other days I'll have to kick everyone off and reboot 3 or 4 times in a single day.

To this day I am not sure what causes it to lock up and timeout the client connections. I've just learned to live with it. Job security, right? The cloud server is pretty stripped down and there's not a ton of memory to work with, but maybe I shall try tweaking the paging file. Any suggestions on how to troubleshoot this would be most welcome.

Cheers.  Cheesy
  

Jack - I'm smokin' past the filter and it's burnin' my lips...
Back to top
YIM YIM  
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #13 - Oct 31st, 2022 at 7:54pm
Print Post Print Post  
All of the fulltime workstations (desk and laptops) have all sleep and hibernation settings disabled.  My home and office laptop. works great on a fresh hookup, but once I disconnect to go home, then plug back in the next day, the router assigns the same ipaddress to my laptop as the previous day, and Sesame engine won't let it read/write well, building up read/write errors until they hit '100' when client connection vaporizes.   

So, the real beef by Sesame engine seems to be the ipaddress (not necessarily the laptop itself) - once a given ipaddress has been disconnected from Sesame, Sesame doesn't want to let it 100% back on the database.   

Is there a way to get the laptop to ask for a different ipaddress from the day before?  Or is there a way to tell Sesame 2.6.4 engine to clear its disconnect drawer and allow disconnected ipaddresses back on again?
  

Larry
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Stability
Reply #14 - Nov 1st, 2022 at 2:20pm
Print Post Print Post  
lksseven wrote on Oct 31st, 2022 at 7:54pm:
So, the real beef by Sesame engine seems to be the ipaddress (not necessarily the laptop itself) - once a given ipaddress has been disconnected from Sesame, Sesame doesn't want to let it 100% back on the database. 

Is there a way to get the laptop to ask for a different ipaddress from the day before?  Or is there a way to tell Sesame 2.6.4 engine to clear its disconnect drawer and allow disconnected ipaddresses back on again?


You're not seeing what you think you are seeing, as it's likely the desktops also have the same IP's from the day before. If you start Sesame Client, Do something and close out, Sesame server has forgotten about that client(unless you left an XResultSet open but that'll only result in a locked record).

Try this, from a command promp on the laptopt: Run a "Ping -T Servername" where Servername is the name of your server. Just let it run. When you start seeing read/write errors in Sesame, see if the Pings are taking longer or failing.

-Ray

  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #15 - Nov 1st, 2022 at 9:53pm
Print Post Print Post  
Thanks Ray, I will try your suggestion.
  

Larry
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #16 - Nov 4th, 2022 at 6:29pm
Print Post Print Post  
Yes, the ping response slowed down, and :Sesame engine wouldn't let laptop client write data to the database (red stripe with read/write errors)

Here is a pic from my phone of the Sesame engine screen
https://photos.app.goo.gl/tFoQs5xEqaDFYBeq8
  

Larry
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Stability
Reply #17 - Nov 7th, 2022 at 6:18pm
Print Post Print Post  
lksseven wrote on Nov 4th, 2022 at 6:29pm:
Yes, the ping response slowed down, and :Sesame engine wouldn't let laptop client write data to the database (red stripe with read/write errors)


Those are Write/Ping errors to the Sesame client meaning that client is offline/unavailable/unresponsive/Ports were closed/or communications are so slow that they timed out.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #18 - Nov 10th, 2022 at 7:39pm
Print Post Print Post  
and so, my focus/investigation should be on the client, not the server?  Server is WinXP (2009)

Sequence is always:
-Fresh load of Sesame engine/server
- Load Sesame client from each workstation (mix of desktops and laptops)
- as long as this initial hookup is intact, all perfect.  But is Sesame session is closed for any reason (laptop moved, or desktop computer rebooted), then this existing 'load' of Sesame server engine will not let that disconnected client back on to write.  The only thing that seems to let that client back on is to reload the Sesame server engine for a fresh 'load'.

I will keep tinkering with it.
  

Larry
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Stability
Reply #19 - Nov 14th, 2022 at 6:37pm
Print Post Print Post  
lksseven wrote on Nov 10th, 2022 at 7:39pm:
and so, my focus/investigation should be on the client, not the server?  Server is WinXP (2009)


If it only affects certain client systems, I would be looking at the client systems.

Quote:
Sequence is always:
-Fresh load of Sesame engine/server
- Load Sesame client from each workstation (mix of desktops and laptops)
- as long as this initial hookup is intact, all perfect.  But is Sesame session is closed for any reason (laptop moved, or desktop computer rebooted), then this existing 'load' of Sesame server engine will not let that disconnected client back on to write.  The only thing that seems to let that client back on is to reload the Sesame server engine for a fresh 'load'.


When you say "Disconnected" do you mean the client is showing up in the Disconnected list of Sesame Server? I'm asking as Sesame clients closed normally do not show up there. It makes no difference to Sesame but could leave records locked.

As a test, here's a screenshot of the Server after a laptop client was disconnected from the network(turned off WIFI completely) so the Sesame Server disconnected it after 10 failed pings. Closed the Sesame Client, reconnected to Network(same IP) and then I restarted the Sesame client. At the time of the screenshot it had no issues in a little over 11 minutes. It's now been over 40 minutes and still no issues, failed Pings, or network errors.

-Ray
  

Slacker.png ( 24 KB | 30 Downloads )
Slacker.png

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #20 - Nov 15th, 2022 at 1:46pm
Print Post Print Post  
Case in point:  Sesame engine running for about a week, workstations connected and happy.  I took my personal laptop off the network (260-LKS, 192.168.1.36) and took it home.  While at home, I rebooted it.  Back at office Monday, connected the laptop to network, loaded Sesame client, pulled up a customer record and did a two letter edit and save, then took this picture of the Sesame server screen.  It managed to allow and save the "xx" edit, but also produced 6 read/write errors.
https://photos.app.goo.gl/9nDJKdcj7xVnDs9R6
  

Larry
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Stability
Reply #21 - Nov 15th, 2022 at 2:36pm
Print Post Print Post  
Looking at that picture, Your client has already been disconnected once and is failing pings again(which are on the 20,001 port, not the main 20,000 port). That Server also has something else trying to connect to it at 11:31 PM and 3:04 AM. Are you running an Internet Security program or other program that might be sniffing open ports on the Server?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #22 - Nov 25th, 2022 at 11:45pm
Print Post Print Post  
Internet security running and sniffing for open ports- it's possible. What probably isn't possible is me capable of holding up my end of an intellligent conversation about security software and ports.  All of my workstations are running Fsecure internet security software - not sure about the server. 
I'm a little bit past the days of being able to fake it till I understand it  Sad 

I suspect a lot of things might improve if I got the gumption to jump off this 13year old WinXP server with 4GB ram, and onto a younger platform.  But I'm 66 and coming in for a soft landing in the next coupla years, so not sure I want to climb that server conversion summit.
  

Larry
Back to top
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Stability
Reply #23 - Dec 10th, 2022 at 7:02pm
Print Post Print Post  
So, here's my workaround (I don't have a theory; this is just what appears to be working)...
- client computer logs on network and boots up sesame.
- work work work
- laptop is closed and taken home
- next day, laptop opened and logged on, and Sesame engine starts showing read write errors and then shortly thereafter kicks off the Sesame client, stating that 192.168.1.36 has been disconnected.  If I re load Sesame client (still with ip .36), Sesame engine starts showing read write errors (red strip) and again Sesame server engine kicks off the client.
------ 
But, if I go into laptop network adaptor and change the MAC address (spoof, in other words), then when the network adaptor reenables itself with the new MAC (just changed the last digit), it gets a new IP address from the router (192.168.1.38), and Sesame engine welcomes the new load of Sesame client with open arms.

If I repeat the laptop shutdown , reopen and reconnect, keeping the MAC so that the ip .38 stays the same, Sesame engine doesn't like it, read write (red strip) errors, and soon a kickoff of the client , stating not only line client 192.168.1.36 has been disconnected, but adding a second line that client 192.168.1.38 has also been disconnected.

If I change MAC address to '..c3', then get new ip of .39, and Sesame engine loves it.  IF I disconnect Sesame client, a repeat of the above, resulting with 3 disconnected lines .36, .38, .39 . 
But if I go back and change MAC back to original '..c1', router reassigns ip .36, and Sesame engine so far in an hour loves it - no red strip, no client kicked off. 

Does the Sesame server have a cache that gets rotated out, so third time's a charm and the original offending 'ip.36' gets dropped out of the cache, making Sesame engine then think a subsequent request from 'ip.36' is virginal ?

In any case, having to take 40 seconds to change MAC address upon opening laptop each day is far better than having to take 15 minutes shutdown/reload server sesame engine and reloading clients
  

Larry
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Stability
Reply #24 - Dec 12th, 2022 at 6:53pm
Print Post Print Post  
lksseven wrote on Dec 10th, 2022 at 7:02pm:
So, here's my workaround (I don't have a theory; this is just what appears to be working)...
- client computer logs on network and boots up sesame.
- work work work
- laptop is closed and taken home


Are you missing a step in there of "Close Sesame"?

Quote:
Does the Sesame server have a cache that gets rotated out, so third time's a charm and the original offending 'ip.36' gets dropped out of the cache, making Sesame engine then think a subsequent request from 'ip.36' is virginal ?


No. Again there is no Cache like that or anything in Sesame that would be causing this behavior.

Out of curiosity: You're using DHCP, What happens if you use Static IP address?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged