Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread Keep getting Application Frozen on post
Tue, Feb 21 2006 7:14 AMPermanent Link

"Bern Rudisill"
Hello all,

   I seem to be having a weird problem. Basically I have a program that
checks a folder every 60 seconds for import text files, if there are
any then the program will start going through them and put them in the
table, then afterwards it runs a query which deletes records that are
past a timeout.

Most of the time this works great but sometimes when I issue the .post
to save the record to the table the program just hangs and after about
2 mins my mad except comes up and tells me the program is frozen. This
program may be running on multiple computers all going into the same
table and possible at the same time.

I am not using client/server yet. On the same computer there is another
program that reads from the import table and displays to the user what
is in this table.

Why would the application freeze on a .post? I would think if the table
was locked or something I would get a DBError not a complete freeze.


The project is small and I can attach it if need be.
Thanks
Bern

--
Tue, Feb 21 2006 12:57 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Bern,

<< Why would the application freeze on a .post? I would think if the table
was locked or something I would get a DBError not a complete freeze. >>

Other than a corrupted table, the only reason I can think of would be an
issue with the hard drive.

<< The project is small and I can attach it if need be. >>

Please do.  At the very least I can try it here on a couple of machines and
see what happens.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Feb 21 2006 2:23 PMPermanent Link

"Bern Rudisill"
Tim Young [Elevate Software] wrote:

> Bern,
>
> << Why would the application freeze on a .post? I would think if the
> table was locked or something I would get a DBError not a complete
> freeze. >>
>
> Other than a corrupted table, the only reason I can think of would be
> an issue with the hard drive.
>
> << The project is small and I can attach it if need be. >>
>
> Please do.  At the very least I can try it here on a couple of
> machines and see what happens.

Tim,

   I just emailed you the project, the subject is "Project request in
news group".

BTW I am have the problem at more then one location, so I think I can
rule out the hard drive problem. I have also checked the tables and
they are not corrupt.

Bern

--
Tue, Feb 21 2006 4:10 PMPermanent Link

"Bern Rudisill"
Bern Rudisill wrote:

> Tim Young [Elevate Software] wrote:
>
> > Bern,
> >
> > << Why would the application freeze on a .post? I would think if the
> > table was locked or something I would get a DBError not a complete
> > freeze. >>
> >
> > Other than a corrupted table, the only reason I can think of would
> > be an issue with the hard drive.
> >
> > << The project is small and I can attach it if need be. >>
> >
> > Please do.  At the very least I can try it here on a couple of
> > machines and see what happens.
>
> Tim,
>
>    I just emailed you the project, the subject is "Project request in
> news group".
>
> BTW I am have the problem at more then one location, so I think I can
> rule out the hard drive problem. I have also checked the tables and
> they are not corrupt.
>
> Bern

Also remember this will be running on multiple computers at the same
time.

--
Wed, Feb 22 2006 10:45 AMPermanent Link

"Bern Rudisill"
Bern Rudisill wrote:

> Bern Rudisill wrote:
>
> > Tim Young [Elevate Software] wrote:
> >
> > > Bern,
> > >
> > > << Why would the application freeze on a .post? I would think if
> > > the table was locked or something I would get a DBError not a
> > > complete freeze. >>
> > >
> > > Other than a corrupted table, the only reason I can think of would
> > > be an issue with the hard drive.
> > >
> > > << The project is small and I can attach it if need be. >>
> > >
> > > Please do.  At the very least I can try it here on a couple of
> > > machines and see what happens.
> >
> > Tim,
> >
> >    I just emailed you the project, the subject is "Project request in
> > news group".
> >
> > BTW I am have the problem at more then one location, so I think I
> > can rule out the hard drive problem. I have also checked the tables
> > and they are not corrupt.
> >
> > Bern
>
> Also remember this will be running on multiple computers at the same
> time.

Can you let me know if you received the project? I have quite a few
customers calling me for a status.

Bern

--
Wed, Feb 22 2006 6:28 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Bern,

<< Can you let me know if you received the project? I have quite a few
customers calling me for a status. >>

Yes, I received it okay.  I'm looking at it now.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Feb 23 2006 2:36 PMPermanent Link

"Bern Rudisill"
Tim Young [Elevate Software] wrote:

> Bern,
>
> << Can you let me know if you received the project? I have quite a
> few customers calling me for a status. >>
>
> Yes, I received it okay.  I'm looking at it now.

I sent the tables over last night, did you get them?

I am wonder if the problem may be that since the program may be running
on many computer at one time if while one is running the delete query
another one is trying to add new items to the database while another is
trying to run another delete query, while another is also trying to add
new items, etc etc etc. I wonder if it may be a locking issue..

Bern

--
Fri, Feb 24 2006 1:30 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Bern,

<< I sent the tables over last night, did you get them? >>

Yes, I did, but I called you because it doesn't appear as though I can run
anything without the import files also.  Frankly, I'm not sure what I'm
supposed to do because you didn't include specific instructions. Wink

<< I am wonder if the problem may be that since the program may be running
on many computer at one time if while one is running the delete query
another one is trying to add new items to the database while another is
trying to run another delete query, while another is also trying to add new
items, etc etc etc. I wonder if it may be a locking issue.. >>

Sure it could be.  Are you using transactions in any other applications,
etc. that are trying to update the same tables ?  SQL UPDATE and DELETE
statements also implicitly use transactions.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image