I gave a website built in umbraco to a client and it is hosted on my server.
The website used to crash after 10 or 12 months, so it was not a big issue but it has now started to crash every 2 or 3 days.
Whenever the website crashes, i have to create a new folder in IIS and point the domain to this new folder and it starts working again.
By crash i mean the website goes in some sort of loop when the url is hit. The website doesn't give any error, it just keeps on loading and on server side, w3wp.exe error keep on populating.
The error I am receiving on crash is regarding sqlceqp40.dll. To find out what was going wrong, i replaced this file in x86 and amd64 to experiment, and the corrupted website was working again. So, next time instead of creating new folder, i can replace the file. This would be an experiment again.
Please help on how I can stop the website from crashing and has this issue been faced by any other used.
P.S. Version of Umbraco is 7.2 and I have just the frontend website, no backend code of Umbraco is available or modified.
I don't know the answer but I do believe that SQL CE isn't generally considered appropriate for production purposes. Can you move to SQL Server proper?
Also there are can be some problems connected to size of database, after 2 years db can be bigger than 2 years ago, another way to solve this problem - clean up database, look at these two awesome packages please:
I have already converted the database to MSSQL. It wasn't a tough job as it seemed.
The speed has improved and it has resolved another issue too which was that my media folder/items were not being displayed due to which i couldn't move any media item to a folder.
Just putting the website under observation for 2 weeks now to see if it crashes again with this MSSQL.
Umbraco website issue!
I gave a website built in umbraco to a client and it is hosted on my server.
The website used to crash after 10 or 12 months, so it was not a big issue but it has now started to crash every 2 or 3 days.
Whenever the website crashes, i have to create a new folder in IIS and point the domain to this new folder and it starts working again.
By crash i mean the website goes in some sort of loop when the url is hit. The website doesn't give any error, it just keeps on loading and on server side, w3wp.exe error keep on populating.
The error I am receiving on crash is regarding sqlceqp40.dll. To find out what was going wrong, i replaced this file in x86 and amd64 to experiment, and the corrupted website was working again. So, next time instead of creating new folder, i can replace the file. This would be an experiment again.
Please help on how I can stop the website from crashing and has this issue been faced by any other used.
P.S. Version of Umbraco is 7.2 and I have just the frontend website, no backend code of Umbraco is available or modified.
I don't know the answer but I do believe that SQL CE isn't generally considered appropriate for production purposes. Can you move to SQL Server proper?
Absolutely agree with David, if you use SQL CE for production - migrate it to MSSQL database.
Thanks,
Alex
Thank you for your response.
The website has been live for 2 years now, i am not sure why it has started to occur more frequently now.
Also, how can I convert the current database to SQL, any tutorials on that?
Also there are can be some problems connected to size of database, after 2 years db can be bigger than 2 years ago, another way to solve this problem - clean up database, look at these two awesome packages please:
https://our.umbraco.org/projects/website-utilities/unversion/
https://our.umbraco.org/projects/backoffice-extensions/falm-housekeeping/
Few possible ways to migrate db:
"Export SQL Server Compact" Umbraco package https://our.umbraco.org/projects/backoffice-extensions/export-sql-server-compact
http://endzonesoftware.com/import-sql-server-compact-edition-files-sdf-sql-server/
https://forum.sambapos.com/t/how-to-migrate-from-sql-compact-edition-sdf-file-to-sql-server-2012-express/752
Hope it will help you.
Thanks,
Alex
I have checked for the data size and it's a touch under 80MB which doesn't seem too much to handle.
However, I will still convert to MSSQL, as I don't seem to have many options right now.
Many thanks :)
Faraz, 80MB isn't too much, but it's not a small database. So remove unused rows will be a good idea.
I have already converted the database to MSSQL. It wasn't a tough job as it seemed.
The speed has improved and it has resolved another issue too which was that my media folder/items were not being displayed due to which i couldn't move any media item to a folder.
Just putting the website under observation for 2 weeks now to see if it crashes again with this MSSQL.
Good job, Faraz, get back to us with feedback.
Thanks,
Alex
Sure thing.
I will write my feedback here in this thread, so if anyone has this issue in future they would know what to do ;)
Switching the database to the MSSQL has resolved the issue :)
is working on a reply...