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

Notification

Icon
Error
Error: : The server method 'Synchronize' failed.
Options
Previous Topic Next Topic
ttba
#1 Posted : Wednesday, 28 January 2009 3:42:17 AM(UTC)
Rank: Newbie

Joined: 2/07/2008(UTC)
Posts: 2
I loaded the latest 2.2 and get the following error. I have the system set up to send emails which does work but in this case I get no other information. It just dies with this message on the screen.

---
Estimated time left: 5 hours 33 min 51 secs (9114 of 59847 objects synchronized)
Synch rate: 2.5 objects/sec
Status: Synchronization error
Current file: Austin\101MSDCF\DSC06207.JPG

Error: : The server method 'Synchronize' failed.

Stack trace:

---

I verified the timeout in the web.config as follows:

<location path="gs/services/Gallery.asmx">
<system.web>
<httpRuntime executionTimeout="86400"/>
</system.web>
</location>


I then tried synchronizing again with the following result:

---
Estimated time left: 10 hours 2 min 35 secs (53 of 59847 objects synchronized)
Synch rate: 1.7 objects/sec
Status: Synchronization error
Current file: Bike Run to Reno Street Vibrations Rene 2002\DSC02169.JPG

Error: System.Data.SQLite.SQLiteException: The database file is locked database is locked

Stack trace:

at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at System.Data.SQLite.SQLiteTransaction..ctor(SQLiteConnection connection, Boolean deferredLock) at System.Data.SQLite.SQLiteConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.SQLite.SQLiteConnection.BeginTransaction() at GalleryServerPro.Data.SQLite.SQLiteGalleryServerProProvider.BeginTransaction() in D:\Inetpub\rp\TIS.GSP.Data.SQLite\SQLiteGalleryServerProProvider.cs:line 953 at GalleryServerPro.Business.SynchronizationManager.Synchronize(String synchId, IAlbum album, String userName) in D:\Inetpub\rp\TIS.GSP.Business\SynchronizationManager.cs:line 156 at Gsp.Gallery.Synchronize(Int32 albumId, String synchId, Boolean isRecursive, Boolean overwriteThumb, Boolean overwriteOpt, Boolean regenerateMetadata) in D:\Inetpub\rp\Website\gs\services\Gallery.asmx.cs:line 252
---

And received the following email:

Error - The database file is locked database is locked

Error Information
Name Value
Type System.Data.SQLite.SQLiteException
Message The database file is locked
database is locked
Source System.Data.SQLite
TargetSite Boolean Step(System.Data.SQLite.SQLiteStatement)
StackTrace at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at System.Data.SQLite.SQLiteTransaction..ctor(SQLiteConnection connection, Boolean deferredLock)
at System.Data.SQLite.SQLiteConnection.BeginDbTransaction(IsolationLevel isolationLevel)
at System.Data.SQLite.SQLiteConnection.BeginTransaction()
at GalleryServerPro.Data.SQLite.SQLiteGalleryServerProProvider.BeginTransaction() in D:\Inetpub\rp\TIS.GSP.Data.SQLite\SQLiteGalleryServerProProvider.cs:line 953
at GalleryServerPro.Business.SynchronizationManager.Synchronize(String synchId, IAlbum album, String userName) in D:\Inetpub\rp\TIS.GSP.Business\SynchronizationManager.cs:line 156
at Gsp.Gallery.Synchronize(Int32 albumId, String synchId, Boolean isRecursive, Boolean overwriteThumb, Boolean overwriteOpt, Boolean regenerateMetadata) in D:\Inetpub\rp\Website\gs\services\Gallery.asmx.cs:line 247
Data


QueryString Collection
Name Value
N/A


Form Collection
Name Value
N/A


Cookies Collection
Name Value
.ASPXANONYMOUS fr3dGou2yQEkAAAAMWMyZDhiNTctNjAyYy00MjcyLTgyN2YtZWMwMTQxNDBhZmVi4IeIVGapmGNG39RoIi2mI--BjIM1
.ASPXAUTH 2222336B1D715D950811D78ECE72B3ACA5E2957BB8D65F79329EFF7E37C698EDCFB6E988FACE75E30D624CC5BA
193167384FE3D2F57C2809CAC120B7DF2B24D26D6D07079E2697448327C82FFB5DF415
.ASPXROLES AAEAAAD_____AQAAAAAAAAAMAgAAAE1TeXN0ZW0uV2ViLCBWZXJzaW9uPTIuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbC
wgUHVibGljS2V5VG9rZW49YjAzZjVmN2YxMWQ1MGEzYQUBAAAAIVN5c3RlbS5XZWIuU2VjdXJpdHkuUm9sZVByaW5jaX
BhbAcAAAAIX1ZlcnNpb24LX0V4cGlyZURhdGUKX0lzc3VlRGF0ZQ1fUHJvdmlkZXJOYW1lCV9Vc2VybmFtZRFfSXNSb2xlTGl
zdENhY2hlZAlfQWxsUm9sZXMAAAABAQABCA0NAQIAAAABAAAAVu0be4hPy0hWuTlKhE_LSAYDAAAAElNRTGl0ZVJvbGVQc
m92aWRlcgYEAAAACXJlbmVwZXJlegEGBQAAABRTeXN0ZW0gQWRtaW5pc3RyYXRvcgsuB8L7a-12SU-zwpJTvrT3aztUxQ2
ASP.NET_SessionId vs402j45eydshv45z1cxxde0


Session Variables
Name Value
N/A


Server Variables
Name Value
ALL_HTTP HTTP_CACHE_CONTROL:no-cache HTTP_CONNECTION:Keep-Alive HTTP_CONTENT_LENGTH:152 HTTP_CONTENT_TYPE:application/json; charset=utf-8 HTTP_ACCEPT:*/* HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:en-us HTTP_COOKIE:.ASPXANONYMOUS=fr3dGou2yQEkAAAAMWMyZDhiNTctNjAyYy00MjcyLTgyN2YtZWMwMTQxNDBhZmVi4I
eIVGapmGNG39RoIi2mI--BjIM1; .ASPXAUTH=2222336B1D715D950811D78ECE72B3ACA5E2957BB8D65F79329EFF7E37C698EDCFB6E988FACE75E30
D624CC5BA193167384FE3D2F57C2809CAC120B7DF2B24D26D6D07079E2697448327C82FFB5DF415; .ASPXROLES=AAEAAAD_____AQAAAAAAAAAMAgAAAE1TeXN0ZW0uV2ViLCBWZXJzaW9uPTIuMC4wLjAsIEN1bHR1cmU9
bmV1dHJhbCwgUHVibGljS2V5VG9rZW49YjAzZjVmN2YxMWQ1MGEzYQUBAAAAIVN5c3RlbS5XZWIuU2VjdXJpdHkuUm9sZ
VByaW5jaXBhbAcAAAAIX1ZlcnNpb24LX0V4cGlyZURhdGUKX0lzc3VlRGF0ZQ1fUHJvdmlkZXJOYW1lCV9Vc2VybmFtZRFfSXN
Sb2xlTGlzdENhY2hlZAlfQWxsUm9sZXMAAAABAQABCA0NAQIAAAABAAAAVu0be4hPy0hWuTlKhE_LSAYDAAAAElNRTGl0ZV
JvbGVQcm92aWRlcgYEAAAACXJlbmVwZXJlegEGBQAAABRTeXN0ZW0gQWRtaW5pc3RyYXRvcgsuB8L7a-12SU-zwpJTvrT3aztUxQ2 HTTP_HOST:xxx.xxx.com HTTP_REFERER:http://xxx.xxx.com/Default.aspx?g=task_synchronize&aid=1 HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; WOW64; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) HTTP_UA_CPU:x86
ALL_RAW Cache-Control: no-cache Connection: Keep-Alive Content-Length: 152 Content-Type: application/json; charset=utf-8 Accept: */* Accept-Encoding: gzip, deflate Accept-Language: en-us Cookie: .ASPXANONYMOUS=fr3dGou2yQEkAAAAMWMyZDhiNTctNjAyYy00MjcyLTgyN2YtZWMwMTQxNDBhZmVi4IeIVGapmGNG39
RoIi2mI--BjIM1; .ASPXAUTH=2222336B1D715D950811D78ECE72B3ACA5E2957BB8D65F79329EFF7E37C698EDCFB6E988FACE75E30D
624CC5BA193167384FE3D2F57C2809CAC120B7DF2B24D26D6D07079E2697448327C82FFB5DF415; .ASPXROLES=AAEAAAD_____AQAAAAAAAAAMAgAAAE1TeXN0ZW0uV2ViLCBWZXJzaW9uPTIuMC4wLjAsIEN1bHR1cmU9
bmV1dHJhbCwgUHVibGljS2V5VG9rZW49YjAzZjVmN2YxMWQ1MGEzYQUBAAAAIVN5c3RlbS5XZWIuU2VjdXJpdHkuUm9sZ
VByaW5jaXBhbAcAAAAIX1ZlcnNpb24LX0V4cGlyZURhdGUKX0lzc3VlRGF0ZQ1fUHJvdmlkZXJOYW1lCV9Vc2VybmFtZRFfSXN
Sb2xlTGlzdENhY2hlZAlfQWxsUm9sZXMAAAABAQABCA0NAQIAAAABAAAAVu0be4hPy0hWuTlKhE_LSAYDAAAAElNRTGl0ZVJ
vbGVQcm92aWRlcgYEAAAACXJlbmVwZXJlegEGBQAAABRTeXN0ZW0gQWRtaW5pc3RyYXRvcgsuB8L7a-12SU-zwpJTvrT3aztUxQ2 Host: xxx.xxx.com Referer: http://xxx.xxx.com/Defau...k_synchronize&aid=1 User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; WOW64; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) UA-CPU: x86
APPL_MD_PATH /LM/W3SVC/722638/Root
APPL_PHYSICAL_PATH D:\Inetpub\xxx.com\
AUTH_TYPE Forms
AUTH_USER xxx
AUTH_PASSWORD
LOGON_USER
REMOTE_USER xxx
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH 152
CONTENT_TYPE application/json; charset=utf-8
GATEWAY_INTERFACE CGI/1.1
HTTPS off
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID 722638
INSTANCE_META_PATH /LM/W3SVC/722638
LOCAL_ADDR 10.169.107.212
PATH_INFO /gs/services/Gallery.asmx/Synchronize
PATH_TRANSLATED D:\Inetpub\xxx.com\gs\services\Gallery.asmx
QUERY_STRING
REMOTE_ADDR 10.169.107.212
REMOTE_HOST 10.169.107.212
REMOTE_PORT 2222
REQUEST_METHOD POST
SCRIPT_NAME /gs/services/Gallery.asmx
SERVER_NAME xxx.xxx.com
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/6.0
URL /gs/services/Gallery.asmx
HTTP_CACHE_CONTROL no-cache
HTTP_CONNECTION Keep-Alive
HTTP_CONTENT_LENGTH 152
HTTP_CONTENT_TYPE application/json; charset=utf-8
HTTP_ACCEPT */*
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-us
HTTP_COOKIE .ASPXANONYMOUS=fr3dGou2yQEkAAAAMWMyZDhiNTctNjAyYy00MjcyLTgyN2YtZWMwMTQxNDBhZmVi4IeIVGapmGNG39
RoIi2mI--BjIM1; .ASPXAUTH=2222336B1D715D950811D78ECE72B3ACA5E2957BB8D65F79329EFF7E37C698EDCFB6E988FACE75E30D
624CC5BA193167384FE3D2F57C2809CAC120B7DF2B24D26D6D07079E2697448327C82FFB5DF415; .ASPXROLES=AAEAAAD_____AQAAAAAAAAAMAgAAAE1TeXN0ZW0uV2ViLCBWZXJzaW9uPTIuMC4wLjAsIEN1bHR1cmU9b
mV1dHJhbCwgUHVibGljS2V5VG9rZW49YjAzZjVmN2YxMWQ1MGEzYQUBAAAAIVN5c3RlbS5XZWIuU2VjdXJpdHkuUm9sZV
ByaW5jaXBhbAcAAAAIX1ZlcnNpb24LX0V4cGlyZURhdGUKX0lzc3VlRGF0ZQ1fUHJvdmlkZXJOYW1lCV9Vc2VybmFtZRFfSXNS
b2xlTGlzdENhY2hlZAlfQWxsUm9sZXMAAAABAQABCA0NAQIAAAABAAAAVu0be4hPy0hWuTlKhE_LSAYDAAAAElNRTGl0ZVJv
bGVQcm92aWRlcgYEAAAACXJlbmVwZXJlegEGBQAAABRTeXN0ZW0gQWRtaW5pc3RyYXRvcgsuB8L7a-12SU-zwpJTvrT3aztUxQ2
HTTP_HOST xxx.xxx.com
HTTP_REFERER http://xxx.xxx.com/Defau...k_synchronize&aid=1
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; WOW64; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
HTTP_UA_CPU x86

Back to top
 |  Edit by user
Roger Martin
#2 Posted : Wednesday, 28 January 2009 5:04:02 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,301
Location: Fort Atkinson, WI
The first error left the database file open, which caused the second error. You can release the file lock by restarting the application pool or just running iisreset at a command prompt. If you are using a hosting provider, hopefully they let you restart it through their web control panel, but if not, if you wait long enough (up to a day usually) the process will recycle on its own.

I have occasionally seen the first error "The server method 'Synchronize' failed" but haven't been able to get to the bottom of it. The fact that you don't get an error message means the failure is happening outside the error handling mechanism, which is pretty strange because I wrap everything I possibly can inside the error handler.

If you can provide additional clues it might help. Does it happen when the synch gets to a certain file? A certain time period into the synch? When the error occurs, use Windows Explorer to inspect the media objects directory - maybe the synch is still running in the background and only the progress UI failed. In this case, you should see thumbnail and optimized images continue to be created. Or you can use Task Manager to see if the w3wp.exe process is still using processor cycles.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
ttba
#3 Posted : Wednesday, 28 January 2009 11:51:31 AM(UTC)
Rank: Newbie

Joined: 2/07/2008(UTC)
Posts: 2
Thanks for the quick reply Roger. Apparently it kept running as I've received a couple more emails with errors since. I've been quite busy today so I haven't had a chance to even look at them. I am running it on my own server so I have flexibility. At any rate I'll take a closer look tomorrow and let you know.
Back to top
yan
#4 Posted : Friday, 5 March 2010 5:28:49 AM(UTC)
Rank: Member

Joined: 5/03/2010(UTC)
Posts: 11
Man
Location: Seattle
I'm also getting Sync failures, consistently but only when syncing a lot of objects. Short Syncs go fine.

Error: : The server method 'Synchronize' failed.

HTTP Status: 12152

Stack trace:

Anything I can do to help resolve it?
Back to top
yan
#5 Posted : Friday, 5 March 2010 3:31:21 PM(UTC)
Rank: Member

Joined: 5/03/2010(UTC)
Posts: 11
Man
Location: Seattle
in my case IIS keeps crunching and thumbnails and compressed files keep generating even after the error occurs
Back to top
yan
#6 Posted : Friday, 5 March 2010 3:49:51 PM(UTC)
Rank: Member

Joined: 5/03/2010(UTC)
Posts: 11
Man
Location: Seattle
Not sure if this is related, but this happens in 2 of my directories that contain the most objects. When CPU quiets down and I look in these albums through the UI, some objects don't have captions and the sort order is somewhat random. In small directories all the objects end up with the default captions and sorted.

I hope that helps...
Back to top
Roger Martin
#7 Posted : Monday, 8 March 2010 11:58:42 PM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,301
Location: Fort Atkinson, WI
When you start a synch, there are two pieces:

1. The server-side synchronization
2. The client-side progress notification

In your case an error seems to be occurring in the client-side piece, which is a little annoying but doesn't interfere with the actual synchronizing. I have seen reports of this every once in a while but haven't been able to trace it down. As best I can tell there isn't any javascript failing but something to do with the AJAX callbacks.

The sort order of new objects is the same as the order in which the OS gives the media files to GSP for processing.

It would be odd for a media object not to have a caption - there should always be one based on the metadata description or the file name.

Keep an eye on the error log, which tracks all errors that occur on the server. If you don't see an entry for the error, you can assume it is probably a client-side error.
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