X
Tap here to go to the mobile version of the site.

Support Forum

Sync fails sync Bookmarks on one PC only.

Posted

I've recently noticed lots of error-sync logs in the %APPDATA%\Mozilla\Firefox\Profiles\<My Profile>\weave\logs folder. My sync is set up to handle Bookmarks and History only.

I have 4 devices, 2 PCs - both Firefox 56.0.2 32-bit and 2 Android devices (latest Firefox, not sure of version). All 4 were previously set to sync together, Bookmarks/History.

One of the PCs (Windows 7 x64) - has the logs, but I've read numerous articles online on how to fix Sync myself or correct a corrupted places.sqlite database as that's what the error log seems to be suggesting is wrong.

Running check integrity against places.sqlite gives me this:

> Task: checkIntegrity - Unable to check database integrity > Task: checkCoherence - The task queue was cleared by an error in another task. > Task: expire - The task queue was cleared by an error in another task. > Task: vacuum - The task queue was cleared by an error in another task. > Task: stats - The task queue was cleared by an error in another task. > Task: _refreshUI - The task queue was cleared by an error in another task.

I have tried to repeat the process in safe mode and with a clear (new) profile - the issue persists. I have deleted places.sqlite (after making a backup) to see if sync suddenly starts working - but the bookmark related issue simply returns.

I have signed out on all devices, changed my sync password and logged in on just the PCs (for now until the problem is resolved). I have deleted all bookmarks on the 'problem' PC, then re-imported them from Internet Explorer on the other PC, then reactivated sync - this seems to initially work but once the 'problem' PC has the bookmarks, it tries to sync them and the errors return.

The error in question appears to be this:

1527797240532 Sync.Engine.Bookmarks WARN Error while backing up bookmarks, but continuing with sync: Error: Error(s) encountered during statement execution: database disk image is malformed (resource://gre/modules/Sqlite.jsm:823:25) JS Stack trace: handleCompletion@Sqlite.jsm:823:25 1527797240534 Sync.BrowserIDManager DEBUG _ensureValidToken already has one 1527797240543 Sync.Engine.Bookmarks DEBUG Successfully wrote previousFailed.

I can supply the entire file if required or put it on pastebin.

The only real issue I'm having is that I simply want my history/bookmarks (but nothing else) shared between all my devices that use Firefox, be it quantum or 56.0.2.

I have not tried Firefox Quantum (as numerous add-ons I use are unsupported and I didn't want to simply switch without a road back). I did try Firefox 52.0.8 ESR but the first thing it did was delete my places.sqlite so I wasn't able to reproduce the problem I'm having as I don't want to lose my history data (bookmarks are stored primarily in IE for convenience and simply imported when I need them as I use 'PlainOldFavorites' extension).

This looks like a bug with firefox sync or a corrupt file, but since I've cleared places.sqlite and let FF recreate it, I'm at a loss. If you need any further information to help solve this, I'm happy to provide as much as possible.

Thanks for any suggestions you can offer :)

I've recently noticed lots of error-sync logs in the %APPDATA%\Mozilla\Firefox\Profiles\<My Profile>\weave\logs folder. My sync is set up to handle Bookmarks and History only. I have 4 devices, 2 PCs - both Firefox 56.0.2 32-bit and 2 Android devices (latest Firefox, not sure of version). All 4 were previously set to sync together, Bookmarks/History. One of the PCs (Windows 7 x64) - has the logs, but I've read numerous articles online on how to fix Sync myself or correct a corrupted places.sqlite database as that's what the error log seems to be suggesting is wrong. Running check integrity against places.sqlite gives me this: > Task: checkIntegrity - Unable to check database integrity > Task: checkCoherence - The task queue was cleared by an error in another task. > Task: expire - The task queue was cleared by an error in another task. > Task: vacuum - The task queue was cleared by an error in another task. > Task: stats - The task queue was cleared by an error in another task. > Task: _refreshUI - The task queue was cleared by an error in another task. I have tried to repeat the process in safe mode and with a clear (new) profile - the issue persists. I have deleted places.sqlite (after making a backup) to see if sync suddenly starts working - but the bookmark related issue simply returns. I have signed out on all devices, changed my sync password and logged in on just the PCs (for now until the problem is resolved). I have deleted all bookmarks on the 'problem' PC, then re-imported them from Internet Explorer on the other PC, then reactivated sync - this seems to initially work but once the 'problem' PC has the bookmarks, it tries to sync them and the errors return. The error in question appears to be this: 1527797240532 Sync.Engine.Bookmarks WARN Error while backing up bookmarks, but continuing with sync: Error: Error(s) encountered during statement execution: database disk image is malformed (resource://gre/modules/Sqlite.jsm:823:25) JS Stack trace: handleCompletion@Sqlite.jsm:823:25 1527797240534 Sync.BrowserIDManager DEBUG _ensureValidToken already has one 1527797240543 Sync.Engine.Bookmarks DEBUG Successfully wrote previousFailed. I can supply the entire file if required or put it on pastebin. The only real issue I'm having is that I simply want my history/bookmarks (but nothing else) shared between all my devices that use Firefox, be it quantum or 56.0.2. I have not tried Firefox Quantum (as numerous add-ons I use are unsupported and I didn't want to simply switch without a road back). I did try Firefox 52.0.8 ESR but the first thing it did was delete my places.sqlite so I wasn't able to reproduce the problem I'm having as I don't want to lose my history data (bookmarks are stored primarily in IE for convenience and simply imported when I need them as I use 'PlainOldFavorites' extension). This looks like a bug with firefox sync or a corrupt file, but since I've cleared places.sqlite and let FF recreate it, I'm at a loss. If you need any further information to help solve this, I'm happy to provide as much as possible. Thanks for any suggestions you can offer :)

Chosen solution

UPDATE:

I've found the cause of my problem is a corrupted favicons.sqlite. I discovered this after copying a known good profile and grafting parts of the corrupted profile onto it - small chunks at a time.

Deleting the favicons.sqlite or renaming it or using any other version seems to correct the issue and things are syncing and behaving as they should.

Thank you all for your help and I hope someone else finds this useful.

Read this answer in context 0

Additional System Details

Installed Plug-ins

  • Shockwave Flash 29.0 r0

Application

  • Firefox 56.0.2
  • User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:56.0) Gecko/20100101 Firefox/56.0
  • Support URL: https://support.mozilla.org/1/firefox/56.0.2/WINNT/en-GB/

Extensions

  • Add-on Compatibility Reporter 2.2.4 (compatibility@addons.mozilla.org)
  • Cisco WebEx Extension 1.0.15 (ciscowebexstart1@cisco.com)
  • Classic Theme Restorer 1.7.4 (ClassicThemeRestorer@ArisT2Noia4dev)
  • Cookies Manager+ 1.14.3 ({bb6bc1bb-f824-4702-90cd-35e2fb24f25d})
  • Download Manager (S3) 4.13 (s3download@statusbar)
  • DownThemAll! 3.0.8 ({DDC359D1-844A-42a7-9AA1-88A850A938A8})
  • Flagfox 5.2.3 ({1018e4d6-728f-4b20-ad56-37578a4de76b})
  • Forecastfox (fix version) 4.16 (forecastfox@s3_fix_version)
  • FoxyProxy Basic 3.6.5 (foxyproxy-basic@eric.h.jung)
  • Hoxx VPN Proxy 2.3.0 (@hoxx-vpn)
  • IBM Security Rapport 2.1.24 (rapportext@trusteer.com)
  • LastPass: Free Password Manager 4.10.1.0 (support@lastpass.com)
  • New Tab Homepage 0.5.3 ({66E978CD-981F-47DF-AC42-E3CF417C1467})
  • PlainOldFavorites 1.4.1-signed.1-signed ({7E7165E2-0767-448c-852F-5FA8714F2C37})
  • Private Tab 0.2.3pre (privateTab@infocatcher)
  • Session Manager 0.8.1.13 ({1280606b-2510-4fe0-97ef-9b5a22eafe30})
  • uBlock Origin 1.16.6 (uBlock0@raymondhill.net)
  • Video DownloadHelper 6.3.3 ({b9db16a4-6edc-47ec-a1f4-b86292ed211d})
  • Fire IE 0.4.6.2 (fireie@fireie.org) (Inactive)
  • Groove Shredder 1.14.10.1-signed.1-signed (grooveshredder@code.argee.org) (Inactive)
  • PC Sync 2 Synchronisation Extension 1.0.0.732 (bkmrksync@nokia.com) (Inactive)
  • Tweak Network 1.8.1-signed.1-signed ({DAD0F81A-CF67-4eed-98D6-26F6E47274CA}) (Inactive)

Javascript

  • incrementalGCEnabled: True

Graphics

  • adapterDescription: NVIDIA GeForce GTX 970
  • adapterDescription2:
  • adapterDeviceID: 0x13c2
  • adapterDeviceID2:
  • adapterDrivers: nvd3dumx,nvwgf2umx,nvwgf2umx nvd3dum,nvwgf2um,nvwgf2um
  • adapterDrivers2:
  • adapterRAM: 4096
  • adapterRAM2:
  • adapterSubsysID: 31601462
  • adapterSubsysID2:
  • adapterVendorID: 0x10de
  • adapterVendorID2:
  • clearTypeParameters: Gamma: 2.2 Pixel Structure: RGB ClearType Level: 100 Enhanced Contrast: 50
  • crashGuards: []
  • direct2DEnabled: True
  • directWriteEnabled: True
  • directWriteVersion: 6.2.9200.22164
  • driverDate: 10-27-2017
  • driverDate2:
  • driverVersion: 23.21.13.8813
  • driverVersion2:
  • featureLog: {u'fallbacks': [], u'features': [{u'status': u'available', u'description': u'Compositing', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'HW_COMPOSITING'}, {u'status': u'available', u'description': u'Direct3D11 Compositing', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'D3D11_COMPOSITING'}, {u'status': u'available', u'description': u'Direct2D', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'DIRECT2D'}, {u'status': u'available', u'description': u'Direct3D11 hardware ANGLE', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'D3D11_HW_ANGLE'}, {u'status': u'available', u'description': u'GPU Process', u'log': [{u'status': u'available', u'type': u'default'}], u'name': u'GPU_PROCESS'}, {u'status': u'unavailable', u'description': u'WebRender', u'log': [{u'status': u'opt-in', u'message': u'WebRender is an opt-in feature', u'type': u'default'}, {u'status': u'unavailable', u'message': u"Build doesn't include WebRender", u'type': u'runtime'}], u'name': u'WEBRENDER'}, {u'status': u'disabled', u'description': u'Advanced Layers', u'log': [{u'status': u'disabled', u'message': u'Disabled by default', u'type': u'default'}], u'name': u'ADVANCED_LAYERS'}]}
  • info: {u'AzureContentBackend (UI Process)': u'skia', u'AzureCanvasBackend (UI Process)': u'skia', u'ApzWheelInput': 1, u'ApzDragInput': 1, u'AzureFallbackCanvasBackend (UI Process)': u'cairo', u'AzureCanvasAccelerated': 0, u'AzureCanvasBackend': u'Direct2D 1.1', u'AzureContentBackend': u'Direct2D 1.1'}
  • isGPU2Active: False
  • numAcceleratedWindows: 1
  • numTotalWindows: 1
  • webgl1DriverExtensions: GL_ANGLE_depth_texture GL_ANGLE_framebuffer_blit GL_ANGLE_framebuffer_multisample GL_ANGLE_instanced_arrays GL_ANGLE_lossy_etc_decode GL_ANGLE_pack_reverse_row_order GL_ANGLE_request_extension GL_ANGLE_robust_client_memory GL_ANGLE_texture_compression_dxt3 GL_ANGLE_texture_compression_dxt5 GL_ANGLE_texture_usage GL_ANGLE_translated_shader_source GL_CHROMIUM_bind_generates_resource GL_CHROMIUM_bind_uniform_location GL_CHROMIUM_copy_compressed_texture GL_CHROMIUM_copy_texture GL_CHROMIUM_sync_query GL_EXT_blend_minmax GL_EXT_color_buffer_half_float GL_EXT_debug_marker GL_EXT_discard_framebuffer GL_EXT_disjoint_timer_query GL_EXT_draw_buffers GL_EXT_frag_depth GL_EXT_map_buffer_range GL_EXT_occlusion_query_boolean GL_EXT_read_format_bgra GL_EXT_robustness GL_EXT_sRGB GL_EXT_shader_texture_lod GL_EXT_texture_compression_dxt1 GL_EXT_texture_filter_anisotropic GL_EXT_texture_format_BGRA8888 GL_EXT_texture_rg GL_EXT_texture_storage GL_EXT_unpack_subimage GL_KHR_debug GL_NV_EGL_stream_consumer_external GL_NV_fence GL_NV_pack_subimage GL_NV_pixel_buffer_object GL_OES_EGL_image GL_OES_EGL_image_external GL_OES_compressed_ETC1_RGB8_texture GL_OES_depth32 GL_OES_element_index_uint GL_OES_get_program_binary GL_OES_mapbuffer GL_OES_packed_depth_stencil GL_OES_rgb8_rgba8 GL_OES_standard_derivatives GL_OES_texture_float GL_OES_texture_float_linear GL_OES_texture_half_float GL_OES_texture_half_float_linear GL_OES_texture_npot GL_OES_vertex_array_object
  • webgl1Extensions: ANGLE_instanced_arrays EXT_blend_minmax EXT_color_buffer_half_float EXT_frag_depth EXT_shader_texture_lod EXT_texture_filter_anisotropic EXT_disjoint_timer_query MOZ_debug OES_element_index_uint OES_standard_derivatives OES_texture_float OES_texture_float_linear OES_texture_half_float OES_texture_half_float_linear OES_vertex_array_object WEBGL_color_buffer_float WEBGL_compressed_texture_s3tc WEBGL_debug_renderer_info WEBGL_debug_shaders WEBGL_depth_texture WEBGL_draw_buffers WEBGL_lose_context MOZ_WEBGL_lose_context MOZ_WEBGL_compressed_texture_s3tc MOZ_WEBGL_depth_texture
  • webgl1Renderer: Google Inc. -- ANGLE (NVIDIA GeForce GTX 970 Direct3D11 vs_5_0 ps_5_0)
  • webgl1Version: OpenGL ES 2.0 (ANGLE 2.1.0.dec065540d5f)
  • webgl1WSIInfo: EGL_VENDOR: Google Inc. (adapter LUID: 0000000000034aae) EGL_VERSION: 1.4 (ANGLE 2.1.0.dec065540d5f) EGL_EXTENSIONS: EGL_EXT_create_context_robustness EGL_ANGLE_d3d_share_handle_client_buffer EGL_ANGLE_d3d_texture_client_buffer EGL_ANGLE_surface_d3d_texture_2d_share_handle EGL_ANGLE_query_surface_pointer EGL_ANGLE_window_fixed_size EGL_ANGLE_keyed_mutex EGL_ANGLE_surface_orientation EGL_NV_post_sub_buffer EGL_KHR_create_context EGL_EXT_device_query EGL_KHR_image EGL_KHR_image_base EGL_KHR_gl_texture_2D_image EGL_KHR_gl_texture_cubemap_image EGL_KHR_gl_renderbuffer_image EGL_KHR_get_all_proc_addresses EGL_KHR_stream EGL_KHR_stream_consumer_gltexture EGL_NV_stream_consumer_gltexture_yuv EGL_ANGLE_flexible_surface_compatibility EGL_ANGLE_create_context_webgl_compatibility EGL_CHROMIUM_create_context_bind_generates_resource EGL_EXTENSIONS(nullptr): EGL_EXT_client_extensions EGL_EXT_platform_base EGL_EXT_platform_device EGL_ANGLE_platform_angle EGL_ANGLE_platform_angle_d3d EGL_ANGLE_device_creation EGL_ANGLE_device_creation_d3d11 EGL_ANGLE_experimental_present_path EGL_KHR_client_get_all_proc_addresses
  • webgl2DriverExtensions: GL_ANGLE_depth_texture GL_ANGLE_framebuffer_blit GL_ANGLE_framebuffer_multisample GL_ANGLE_instanced_arrays GL_ANGLE_lossy_etc_decode GL_ANGLE_pack_reverse_row_order GL_ANGLE_request_extension GL_ANGLE_robust_client_memory GL_ANGLE_texture_compression_dxt3 GL_ANGLE_texture_compression_dxt5 GL_ANGLE_texture_usage GL_ANGLE_translated_shader_source GL_CHROMIUM_bind_generates_resource GL_CHROMIUM_bind_uniform_location GL_CHROMIUM_copy_compressed_texture GL_CHROMIUM_copy_texture GL_CHROMIUM_sync_query GL_EXT_blend_minmax GL_EXT_color_buffer_float GL_EXT_color_buffer_half_float GL_EXT_debug_marker GL_EXT_discard_framebuffer GL_EXT_disjoint_timer_query GL_EXT_draw_buffers GL_EXT_frag_depth GL_EXT_map_buffer_range GL_EXT_occlusion_query_boolean GL_EXT_read_format_bgra GL_EXT_robustness GL_EXT_sRGB GL_EXT_shader_texture_lod GL_EXT_texture_compression_dxt1 GL_EXT_texture_filter_anisotropic GL_EXT_texture_format_BGRA8888 GL_EXT_texture_norm16 GL_EXT_texture_rg GL_EXT_texture_storage GL_EXT_unpack_subimage GL_KHR_debug GL_NV_EGL_stream_consumer_external GL_NV_fence GL_NV_pack_subimage GL_NV_pixel_buffer_object GL_OES_EGL_image GL_OES_EGL_image_external GL_OES_EGL_image_external_essl3 GL_OES_compressed_ETC1_RGB8_texture GL_OES_depth32 GL_OES_element_index_uint GL_OES_get_program_binary GL_OES_mapbuffer GL_OES_packed_depth_stencil GL_OES_rgb8_rgba8 GL_OES_standard_derivatives GL_OES_texture_float GL_OES_texture_float_linear GL_OES_texture_half_float GL_OES_texture_half_float_linear GL_OES_texture_npot GL_OES_vertex_array_object
  • webgl2Extensions: EXT_color_buffer_float EXT_texture_filter_anisotropic EXT_disjoint_timer_query MOZ_debug OES_texture_float_linear WEBGL_compressed_texture_s3tc WEBGL_debug_renderer_info WEBGL_debug_shaders WEBGL_lose_context MOZ_WEBGL_lose_context MOZ_WEBGL_compressed_texture_s3tc
  • webgl2Renderer: Google Inc. -- ANGLE (NVIDIA GeForce GTX 970 Direct3D11 vs_5_0 ps_5_0)
  • webgl2Version: OpenGL ES 3.0 (ANGLE 2.1.0.dec065540d5f)
  • webgl2WSIInfo: EGL_VENDOR: Google Inc. (adapter LUID: 0000000000034aae) EGL_VERSION: 1.4 (ANGLE 2.1.0.dec065540d5f) EGL_EXTENSIONS: EGL_EXT_create_context_robustness EGL_ANGLE_d3d_share_handle_client_buffer EGL_ANGLE_d3d_texture_client_buffer EGL_ANGLE_surface_d3d_texture_2d_share_handle EGL_ANGLE_query_surface_pointer EGL_ANGLE_window_fixed_size EGL_ANGLE_keyed_mutex EGL_ANGLE_surface_orientation EGL_NV_post_sub_buffer EGL_KHR_create_context EGL_EXT_device_query EGL_KHR_image EGL_KHR_image_base EGL_KHR_gl_texture_2D_image EGL_KHR_gl_texture_cubemap_image EGL_KHR_gl_renderbuffer_image EGL_KHR_get_all_proc_addresses EGL_KHR_stream EGL_KHR_stream_consumer_gltexture EGL_NV_stream_consumer_gltexture_yuv EGL_ANGLE_flexible_surface_compatibility EGL_ANGLE_create_context_webgl_compatibility EGL_CHROMIUM_create_context_bind_generates_resource EGL_EXTENSIONS(nullptr): EGL_EXT_client_extensions EGL_EXT_platform_base EGL_EXT_platform_device EGL_ANGLE_platform_angle EGL_ANGLE_platform_angle_d3d EGL_ANGLE_device_creation EGL_ANGLE_device_creation_d3d11 EGL_ANGLE_experimental_present_path EGL_KHR_client_get_all_proc_addresses
  • windowLayerManagerRemote: True
  • windowLayerManagerType: Direct3D 11
  • windowUsingAdvancedLayers: False

Modified Preferences

Misc

  • User JS: Yes
  • Accessibility: No
Shadow110 1072 solutions 14836 answers

Hi, you can check your add-ons here : https://alternativeto.net/ for alternatives for 57+

Please open this URL : https://support.mozilla.org/en-US/kb/forum-response-firefox-sync-verification-email-faq At the bottom of the page you will find information to create a bugzilla account please do so and follow instructions. Thank You.

Please let us know if this solved your issue or if need further assistance.

Hi, you can check your add-ons here : https://alternativeto.net/ for alternatives for 57+ Please open this URL : https://support.mozilla.org/en-US/kb/forum-response-firefox-sync-verification-email-faq At the bottom of the page you will find information to create a bugzilla account please do so and follow instructions. Thank You. Please let us know if this solved your issue or if need further assistance.
FredMcD
  • Top 10 Contributor
4190 solutions 58502 answers

I called for more help.


Sync We need to look at the sync logs. Type about:sync-log<enter> in the address bar.

Open the last file created and Copy its contents Now Paste it into this forum.


arkane78 said

Running check integrity against places.sqlite gives me this:

> Task: checkIntegrity
- Unable to check database integrity

One possible reason is the file is being used by another program.

Start your Computer in safe mode with network support. Then start Firefox. Run the test. Is the problem still there?

http://encyclopedia2.thefreedictionary.com/Linux+Safe+Mode Starting Any Computer In Safe Mode; Free Online Encyclopedia

I called for more help. -------------- Sync We need to look at the sync logs. Type ''' about:sync-log'''<enter> in the address bar. Open the last file created and '''Copy''' its contents Now '''Paste''' it into this forum. ---------------- ''arkane78 [[#question-1220047|said]]'' <blockquote> Running check integrity against places.sqlite gives me this:<br><br> > Task: checkIntegrity<br> - Unable to check database integrity </blockquote> One possible reason is the file is being used by another program. Start your '''Computer''' in safe mode with network support. Then start Firefox. Run the test. Is the problem still there? http://encyclopedia2.thefreedictionary.com/Linux+Safe+Mode Starting Any Computer In Safe Mode; Free Online Encyclopedia

Question owner

Pkshadow said

Hi, you can check your add-ons here : https://alternativeto.net/ for alternatives for 57+ Please open this URL : https://support.mozilla.org/en-US/kb/forum-response-firefox-sync-verification-email-faq At the bottom of the page you will find information to create a bugzilla account please do so and follow instructions. Thank You. Please let us know if this solved your issue or if need further assistance.

Hi Pkshadow,

Why do I need to create a bugzilla account?

I'm happy to create one but the page you direct you to suggests that if my e-mail address is inaccessible - I should create a bugzilla account, but my e-mail addresses aren't inaccessible.

FredMcD said

I called for more help.

Sync We need to look at the sync logs. Type about:sync-log<enter> in the address bar.

Open the last file created and Copy its contents Now Paste it into this forum.


arkane78 said

Running check integrity against places.sqlite gives me this:

> Task: checkIntegrity
- Unable to check database integrity

One possible reason is the file is being used by another program.

Start your Computer in safe mode with network support. Then start Firefox. Run the test. Is the problem still there?

http://encyclopedia2.thefreedictionary.com/Linux+Safe+Mode Starting Any Computer In Safe Mode; Free Online Encyclopedia

Hi FredMcD,

Here's the latest sync log content:

https://pastebin.com/hGKxniWs

I haven't tried safe-mode with networking yet, I'll be sure to do that later today when I get home from work.

''Pkshadow [[#answer-1117659|said]]'' <blockquote> Hi, you can check your add-ons here : https://alternativeto.net/ for alternatives for 57+ Please open this URL : https://support.mozilla.org/en-US/kb/forum-response-firefox-sync-verification-email-faq At the bottom of the page you will find information to create a bugzilla account please do so and follow instructions. Thank You. Please let us know if this solved your issue or if need further assistance. </blockquote> Hi Pkshadow, Why do I need to create a bugzilla account? I'm happy to create one but the page you direct you to suggests that if my e-mail address is inaccessible - I should create a bugzilla account, but my e-mail addresses aren't inaccessible. ''FredMcD [[#answer-1117749|said]]'' <blockquote> I called for more help. -------------- Sync We need to look at the sync logs. Type ''' about:sync-log'''<enter> in the address bar. Open the last file created and '''Copy''' its contents Now '''Paste''' it into this forum. ---------------- ''arkane78 [[#question-1220047|said]]'' <blockquote> Running check integrity against places.sqlite gives me this:<br><br> > Task: checkIntegrity<br> - Unable to check database integrity </blockquote> One possible reason is the file is being used by another program. Start your '''Computer''' in safe mode with network support. Then start Firefox. Run the test. Is the problem still there? http://encyclopedia2.thefreedictionary.com/Linux+Safe+Mode Starting Any Computer In Safe Mode; Free Online Encyclopedia </blockquote> Hi FredMcD, Here's the latest sync log content: https://pastebin.com/hGKxniWs I haven't tried safe-mode with networking yet, I'll be sure to do that later today when I get home from work.
Shadow110 1072 solutions 14836 answers

HI, only blockquote was is actually needed please : https://www.w3schools.com/tags/tag_blockquote.asp

Yes I do know what the page says. Please make the bugzilla account click then put your error messages in that there is also the other link and it will get a Supervisor to look at it as Support has no access to the servers and what ever else needs to be done to get your account working and syncing. properly.

You can post here as long as you would like but unfortunately we can not act on any of it. Thank You.

HI, only blockquote was is actually needed please : https://www.w3schools.com/tags/tag_blockquote.asp Yes I do know what the page says. Please make the bugzilla account click then put your error messages in that there is also the other link and it will get a Supervisor to look at it as Support has no access to the servers and what ever else needs to be done to get your account working and syncing. properly. You can post here as long as you would like but unfortunately we can not act on any of it. Thank You.
cor-el
  • Top 10 Contributor
  • Moderator
17345 solutions 156782 answers

There is a problem with the places.sqlite database.

1527833092926   Sync.Engine.Bookmarks   WARN    Error while building GUID map, skipping all other incoming items: Error: Error(s) encountered during statement execution: database disk image is malformed (resource://gre/modules/Sqlite.jsm:823:25) JS Stack trace: handleCompletion@Sqlite.jsm:823:25
1527833092926   Sync.Engine.Bookmarks   WARN    Reconciliation failed: aborting incoming processing.
1527833093215   Sync.Engine.Bookmarks   DEBUG   Records that failed to apply: menu
1527833093481   BookmarkSyncUtils   DEBUG   pushChanges: Processed change records: {"skipped":6276,"updated":0,"tombstones":0}
1527833093482   Sync.Status DEBUG   Status for engine bookmarks: error.engine.reason.unknown_fail
1527833093482   Sync.Status DEBUG   Status.service: success.status_ok => error.sync.failed_partial
1527833093482   Sync.ErrorHandler   DEBUG   bookmarks failed: Error: Error(s) encountered during statement execution: database disk image is malformed (resource://gre/modules/Sqlite.jsm:823:25) JS Stack trace: handleCompletion@Sqlite.jsm:823:25
1527833093482   Sync.Telemetry  TRACE   observed weave:engine:sync:error bookmarks

If "Verify Integrity" on the "Help -> Troubleshooting Information" (about:support) page cannot repair places.sqlite then remove all places.sqlite files in the Firefox profile folder. Firefox will rebuild places.sqlite and restore the bookmarks from a recent JSON backup in the bookmarkbackups folder.

You can use the button on the "Help -> Troubleshooting Information" (about:support) page to go to the current Firefox profile folder or use the about:profiles page.

There is a problem with the places.sqlite database. <pre><nowiki>1527833092926 Sync.Engine.Bookmarks WARN Error while building GUID map, skipping all other incoming items: Error: Error(s) encountered during statement execution: database disk image is malformed (resource://gre/modules/Sqlite.jsm:823:25) JS Stack trace: handleCompletion@Sqlite.jsm:823:25 1527833092926 Sync.Engine.Bookmarks WARN Reconciliation failed: aborting incoming processing. 1527833093215 Sync.Engine.Bookmarks DEBUG Records that failed to apply: menu 1527833093481 BookmarkSyncUtils DEBUG pushChanges: Processed change records: {"skipped":6276,"updated":0,"tombstones":0} 1527833093482 Sync.Status DEBUG Status for engine bookmarks: error.engine.reason.unknown_fail 1527833093482 Sync.Status DEBUG Status.service: success.status_ok => error.sync.failed_partial 1527833093482 Sync.ErrorHandler DEBUG bookmarks failed: Error: Error(s) encountered during statement execution: database disk image is malformed (resource://gre/modules/Sqlite.jsm:823:25) JS Stack trace: handleCompletion@Sqlite.jsm:823:25 1527833093482 Sync.Telemetry TRACE observed weave:engine:sync:error bookmarks</nowiki></pre> ---- If "Verify Integrity" on the "Help -> Troubleshooting Information" (about:support) page cannot repair places.sqlite then remove all places.sqlite files in the Firefox profile folder. Firefox will rebuild places.sqlite and restore the bookmarks from a recent JSON backup in the bookmarkbackups folder. *keep a backup copy of places.sqlite in case a new places.sqlite database has to be created *http://kb.mozillazine.org/Unable_to_process_the_backup_file_-_Firefox You can use the button on the "Help -> Troubleshooting Information" (about:support) page to go to the current Firefox profile folder or use the <b>about:profiles</b> page. *Help -> Troubleshooting Information -> Profile Directory:<br>Windows: Show Folder; Linux: Open Directory; Mac: Show in Finder *http://kb.mozillazine.org/Profile_folder_-_Firefox

Question owner

Hi cor-el,

Thanks for your help - the Verify Integrity command does indeed fail when I try it - so I've deleted all places.sqlite files that I can find in the profile and will monitor the situation.

Hi cor-el, Thanks for your help - the Verify Integrity command does indeed fail when I try it - so I've deleted all places.sqlite files that I can find in the profile and will monitor the situation.

Question owner

UPDATE:

It seems even with a new places.sqlite database, verify integrity still fails but I've yet to see if sync fails or not. I'm going to hazard a guess and say it probably will and that it's something to do with the profile itself, rather than places.sqlite - but I can't think of what that could be.

Will update with more information as I find it.

UPDATE: It seems even with a new places.sqlite database, verify integrity still fails but I've yet to see if sync fails or not. I'm going to hazard a guess and say it probably will and that it's something to do with the profile itself, rather than places.sqlite - but I can't think of what that could be. Will update with more information as I find it.
FredMcD
  • Top 10 Contributor
4190 solutions 58502 answers
Use these links to create a new profile. Use this new profile '''as is. ''' Is the problem still there? http://kb.mozillazine.org/Profile_folder_-_Firefox#Navigating_to_the_profile_folder https://support.mozilla.org/en-US/kb/profile-manager-create-and-remove-firefox-profiles https://support.mozilla.org/en-US/kb/how-run-firefox-when-profile-missing-inaccessible https://support.mozilla.org/en-US/kb/back-and-restore-information-firefox-profiles Type '''about:profiles'''<enter> in the address bar.

Question owner

UPDATE:

I have run sync successfully on a copied version of the other PC profile, using the places.sqlite from my original PC profile.

I have confirmed that sync works as expected (albeit after a little trial and error). This leads me to conclude that my main profile is corrupted, yet I don't know exactly how or why.

I can continue to update this thread with any new findings or I can simply mark it as solved as the issue looks to be a corrupted profile.

UPDATE: I have run sync successfully on a copied version of the other PC profile, using the places.sqlite from my original PC profile. I have confirmed that sync works as expected (albeit after a little trial and error). This leads me to conclude that my main profile is corrupted, yet I don't know exactly how or why. I can continue to update this thread with any new findings or I can simply mark it as solved as the issue looks to be a corrupted profile.

Chosen Solution

UPDATE:

I've found the cause of my problem is a corrupted favicons.sqlite. I discovered this after copying a known good profile and grafting parts of the corrupted profile onto it - small chunks at a time.

Deleting the favicons.sqlite or renaming it or using any other version seems to correct the issue and things are syncing and behaving as they should.

Thank you all for your help and I hope someone else finds this useful.

UPDATE: I've found the cause of my problem is a corrupted favicons.sqlite. I discovered this after copying a known good profile and grafting parts of the corrupted profile onto it - small chunks at a time. Deleting the favicons.sqlite or renaming it or using any other version seems to correct the issue and things are syncing and behaving as they should. Thank you all for your help and I hope someone else finds this useful.
FredMcD
  • Top 10 Contributor
4190 solutions 58502 answers

That was very good work. Well done. Please flag your last post as Solved Problem so others will know.

That was very good work. Well done. Please flag your last post as '''Solved Problem''' so others will know.