Should I be able to crash 4D Server?

View: New views
8 Messages — Rating Filter:   Alert me  

Should I be able to crash 4D Server?

by psmith-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I had a pretty frustrating day. I was doing a demo of the performance  
of v11 versus 2004 for one of my biggest customers (yes, it is much  
faster). The customer is looking at possibly dramatically increasing  
the number of seats from 80 to 120, possibly later to 200 - or  
abandoning my solution. At the end of the demo, 4D Server v11 crashed.  
The crash happened when the only connected client quit. Actually, the  
client hung while attempting to quit.

I imagine there is something in my code, somewhere, which has been  
running fine on 2004 for several years, but which made v11 4D Server  
unstable. Then, on quitting, the server happened to crash - probably  
when doing some internal housekeeping related to closing the connection.

My question, which is kind of an offshoot of the "Multiple core"  
thread, is should we be _able_ to crash the server? I suspect the  
single, cooperative thread on 4D Server is its weakest link. I would  
hope that threads could terminate abnormally without crashing an  
entire server, but perhaps not that all-important cooperative thread.

I haven't worked with Oracle for a couple of decades. I've never  
worked with SQL Server or Sybase. Can a developer willfully execute  
code which would crash one of those servers? It would make me feel a  
little better if the answer was "yes". (;-<)



Paul Smith

TSE International
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Parent Message unknown Re: Should I be able to crash 4D Server?

by Richard Wright-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> Date: Wed, 11 Nov 2009 17:08:51 +0100
> From: psmith <psmith@...>
> To: 4D iNug Technical <4d_tech@...>
> Message-ID: <74AA5843-6BC2-4560-83A9-0C94E020FB0C@...>
>
> ...
>
> I haven't worked with Oracle for a couple of decades. I've never
> worked with SQL Server or Sybase. Can a developer willfully execute
> code which would crash one of those servers? It would make me feel a
> little better if the answer was "yes". (;-<)

I was able to crash Oracle. It was a few years ago and I can't for the  
life of me remember what it was but it was reproducible.


------------------------------------------------
Richard Wright
DataDomain
rwright@...
------------------------------------------------

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Re: Should I be able to crash 4D Server?

by John DeSoi :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On Nov 11, 2009, at 11:08 AM, psmith wrote:

> My question, which is kind of an offshoot of the "Multiple core"  
> thread, is should we be _able_ to crash the server? I suspect the  
> single, cooperative thread on 4D Server is its weakest link. I would  
> hope that threads could terminate abnormally without crashing an  
> entire server, but perhaps not that all-important cooperative thread.
>
> I haven't worked with Oracle for a couple of decades. I've never  
> worked with SQL Server or Sybase. Can a developer willfully execute  
> code which would crash one of those servers? It would make me feel a  
> little better if the answer was "yes". (;-<)

I can't speak for the above databases, but with PostgreSQL each  
connection runs in a separate process. It was designed this way to  
make it difficult or impossible for a client connection to crash the  
server process. And of course it allows the server to take advantage  
of any number of CPUs/cores.




John DeSoi, Ph.D.




**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Re: Should I be able to crash 4D Server?

by Alan Chan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

John,

You're bad:-)

Alan Chan

4D iNug Technical <4d_tech@...> writes:
>And of course it allows the server to take advantage  
>of any number of CPUs/cores.


**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Re: Should I be able to crash 4D Server?

by Peter Schumacher-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Might happen, depending on the code. v11 changed a lot of the old  
tricks. Can you reproduce it? ...and more interesting, which version  
of v11 did you use? The is a whole bunch of this breed... :)


Am 11.11.2009 um 09:08 schrieb psmith:

> I imagine there is something in my code, somewhere, which has been  
> running fine on 2004 for several years, but which made v11 4D Server  
> unstable. Then, on quitting, the server happened to crash - probably  
> when doing some internal housekeeping related to closing the  
> connection.

Greetings,
[4D-Consulting.com]eK, Wiesbaden (Germany)
Peter Schumacher
--------------------------------------------------------
Web: http://www.4D-Consulting.com/
FreeCall:  0800-434 636 7
Tel.:      +49-611-9406.850 - Fax: +49-611-9406.744
4D-Consulting.com eK - Scharnhorststr. 36 - 65195 Wiesbaden
Member of the German Developer Network  http://www.die4dwerkstatt.de









**********************************************************************
Get up to $600 to spend on Amazon.com
this holiday season - http://www.4d.com/serverpromo.html
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Re: Should I be able to crash 4D Server?

by psmith-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Peter,

It doesn't happen regularly. In fact, it seems random.

v11.4 hf7 on Windows 2003.

Paul Smith

TSE International

> Might happen, depending on the code. v11 changed a lot of the old  
> tricks. Can you reproduce it? ...and more interesting, which version  
> of v11 did you use? The is a whole bunch of this breed... :)

**********************************************************************
Get up to $600 to spend on Amazon.com
this holiday season - http://www.4d.com/serverpromo.html
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Re: Should I be able to crash 4D Server?

by t anthony breen :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

You may want to review your plug-ins.  We had a similar experience  
years ago when a fax plug-in was executing some code when the client  
quit that would result in the server crashing (and many data  
recoveries until we figured it out).


t anthony breen
Subito Systems
---------------------------------------------------------------------
I went to a bookstore and asked the saleswoman, "where's the self-
help section?"  She said if she told me, it would defeat the purpose...


On Nov 11, 2009, at 8:08 AM, psmith wrote:

> Hi,
>
> I had a pretty frustrating day. I was doing a demo of the  
> performance of v11 versus 2004 for one of my biggest customers  
> (yes, it is much faster). The customer is looking at possibly  
> dramatically increasing  the number of seats from 80 to 120,  
> possibly later to 200 - or abandoning my solution. At the end of  
> the demo, 4D Server v11 crashed. The crash happened when the only  
> connected client quit. Actually, the client hung while attempting  
> to quit.
>

**********************************************************************
Get up to $600 to spend on Amazon.com
this holiday season - http://www.4d.com/serverpromo.html
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

Re: Should I be able to crash 4D Server?

by psmith-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

Thanks for the suggestion.

We're just using 4D Write, 4D Internet commands and 4D Pack.

The server sometimes just seems to crash... even if none of the  
plugins have been used.

Often, the "client" will not quit correctly. This can cause the server  
to crash.



Paul Smith

TSE International

> You may want to review your plug-ins.  We had a similar experience  
> years ago when a fax plug-in was executing some code when the client  
> quit that would result in the server crashing (and many data  
> recoveries until we figured it out).
>
>
> t anthony breen
> Subito Systems

**********************************************************************
Get up to $600 to spend on Amazon.com
this holiday season - http://www.4d.com/serverpromo.html
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************