Subject Re: [firebird-support] Server
Author Michael Ludwig
Michael Vilhelmsen schrieb am 07.06.2012 um 09:38 (-0000):

> WEBESCON Commit Trans 6/6/2012 2499515 1735.774
> WEBESCON Login 6/6/2012 859 0.59
> WEBESCON Logout 6/6/2012 858 0.595
> WEBESCON Start Trans 6/6/2012 2499516 1735.775
> WEBESCON Commit Trans 6/7/2012 657036 456.275
> WEBESCON Login 6/7/2012 232 0.161
> WEBESCON Logout 6/7/2012 231 0.160
> WEBESCON Start Trans 6/7/2012 657035 456.274
>
> These are the number of connect(Login), disconnect(Logout) and
> transactions.
> As you can see they are connecting/disconnection some 1700+ times each
> minute duing the entire day.

No - they're just using a lot of transactions. Login and logout match
your comparative data below. Autocommit mode would easily account for
the higher number of transactions.

> DWIUSER Commit Trans 6/6/2012 32384 22.48
> DWIUSER Start Trans 6/6/2012 18054 12.53
> DWIUSER Commit Trans 6/7/2012 8297 5.761
> DWIUSER Start Trans 6/7/2012 4347 3.018
> ESCONSERVICE Commit Trans 6/6/2012 607 0.421
> ESCONSERVICE Login 6/6/2012 286 0.198
> ESCONSERVICE Logout 6/6/2012 286 0.198
> ESCONSERVICE Start Trans 6/6/2012 607 0.421
> ESCONSERVICE Commit Trans 6/7/2012 171 0.118
> ESCONSERVICE Login 6/7/2012 79 0.054
> ESCONSERVICE Logout 6/7/2012 79 0.054
> ESCONSERVICE Start Trans 6/7/2012 171 0.118
>
>
> This morning (and some 10-12 times more the last 3-4 days) the server
> died with this:
>
> DBSRV03 (Server) Thu Jun 07 06:06:02 2012
> Database: ThreadData::start() failed:
> operating system directive _beginthreadex failed
> Not enough storage is available to process this command.
>
> Which I believe is "out of memory" problem.

It rather sounds like "disk full", but I believe you're correct:

http://technet.microsoft.com/en-us/library/cc978735.aspx

User Action:
Do one of the following, then retry the command: (1) reduce the number
of running programs; (2) remove unwanted files from the disk the
paging file is on and restart the system; (3) check the paging file
disk for an I/O error; or (4) install additional memory in your
system.

As for the causes, I don't have a clue.

Michael