Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 8 of 8 total |
Keep getting Application Frozen on post |
Tue, Feb 21 2006 7:14 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 PM | Permanent 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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. << 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 |
This web page was last updated on Thursday, May 23, 2024 at 07:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |