Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Upgrade from 2.4.8 SQLLite to 2.6 SQL CE Failing
Options
Previous Topic Next Topic
Petercloet
#1 Posted : Wednesday, 2 November 2011 10:19:10 AM(UTC)
Rank: Advanced Member

Joined: 10/12/2007(UTC)
Posts: 34
Location: Belgium
Hi Roger,

I tried to upgrade my copy of GalleryServerPro from 2.4.8 to 2.6 going from SQLLite to SQL CE.
First of all, I updated to .Net4 and made sure my Gallery was running with that version. That part of the upgrade went fine.

I then proceeded to the actual upgrade - making a copy of my galleryserverpro folder first.

First, I copied all the files in the GalleryServerPro_V2_6_0_Upgrade.zip package into my existing GalleryServerPro folder - telling the OS to copy/replace all files and folders.
Next, I went to my Gallery through the browser and it brought up the upgrade wizard.
After getting the green light all the way, I pressed "Next" to initiate the SQLLite -> SQL CE Database conversion. Then nothing much happens... and after 2 minutes or so I get an error that the connection timed out.
When I look on the IIS Server, I see that the SQL CE database file hasn't grown in size.
During the upgrade process - i.e. after I press the next button - I see the IIS Worker Service (w3wp)appear in the Task Manager. When the browser reports the connection timed out, this service also disappears from the Task Manager.

Any ideas on what is going on here?

I'm running IIS 7.5 on Windows 2008R2.
The R2 is running on a Virtual Machine within a host 2008R2 system. It has 1024Gb of memory allocated.
The browser I'm using is Firefox 7.0.1.

Please let me know if you require more input and/or log files.

Thanks for helping me out on this one.

Regards,

Peter
Back to top
WWW
Roger Martin
#2 Posted : Wednesday, 2 November 2011 10:40:55 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
It's pretty hard to tell given what you've said. Can you send me your .sqlite file? The upgrade process actually updates the .sqlite DB before trying to import the data, so please send me both versions: the original before the upgrade, and the one that was involved in the upgrade.

Send them to roger*at*techinfosystems*dot*com.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
Petercloet
#3 Posted : Wednesday, 2 November 2011 11:32:16 AM(UTC)
Rank: Advanced Member

Joined: 10/12/2007(UTC)
Posts: 34
Location: Belgium
Roger Martin;7913 wrote:
It's pretty hard to tell given what you've said. Can you send me your .sqlite file? The upgrade process actually updates the .sqlite DB before trying to import the data, so please send me both versions: the original before the upgrade, and the one that was involved in the upgrade.


Hi Roger, thanks for the quick response.
The files are on their way.

I tried to start the update from Internet Explorer 9 this time around but I get the same error.
When I monitor the progress of the upgrade on the server, I can see the IIS Worker Process in action and then after a while I also see a WERFault thread kicking in.
Then after a couple of minutes, the server reports that the IIS Worker Process has stopped working and Windows is collecting more information about the problem.
At the same time I get the error on the server, the connection in the browser times out.

Then, when I try to start my Gallery from the browser, it seems to default to a standard Media Gallery with default settings. This seems normal to me as the upgrade didn't succeed and therefore my own data isn't available in the SQL CE database that comes with 2.6.

Hope you can figure out what's going on... really appreciate your help here.

Regards,

Peter
Back to top
WWW
Roger Martin
#4 Posted : Monday, 7 November 2011 1:25:40 PM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
After studying Peter's sqlite file, I found two issues preventing the upgrade:

1. The contents of the Comment field in three records in aspnet_Users. The data was boring-looking plain text, and I do not know why it wouldn't convert, but SQL CE was very clear it didn't like the data. Since the data was not needed, I simply cleared the column in the source database.

2. Three duplicate profile records in gs_UserGalleryProfile. They were caused by a bug that I had fixed in 2.4.7, but it unfortunately left behind extra records. The extra records were ones where the username differed by case (e.g Admin vs admin). SQL CE enforces data integrity much better than SQLite and correctly prevented this kind of data from coming in. I deleted the duplicate records in the source.

Both of these issues might affect additional 2.4 => 2.5+ conversions, so if you think you might be affected, look for these two possibilities.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET