You are not logged in.

#1 2013-10-19 18:59:50

graysky
Wiki Maintainer
From: :wq
Registered: 2008-12-01
Posts: 10,595
Website

[xbmc] - library is missing records [solved by downgrading sqlite]

Recently, about 1/2 of my library is literally empty in the GUI, but the underlying files are on the filesystem and are accessible to the user running xbmc.

Example:
/media/shows is the library root.

The following are present:
/media/shows/foo/s1/foo.s01e01.mkv
/media/shows/foo/s1/foo.s01e02.mkv
/media/shows/foo/s1/foo.s01e03.mkv
...
/media/shows/foo/s1/foo.s01e10.mkv

/media/shows/foo/s2/foo.s02e01.mkv
/media/shows/foo/s2/foo.s02e02.mkv
/media/shows/foo/s2/foo.s02e03.mkv
...
/media/shows/foo/s2/foo.s02e10.mkv
When I browse to TV Shows>foo in the GUI, all I see is ".." when in the past I would see all the content sorted by season.  I tried removing ~/.xbmc and totally rebuilding it.  The scraper found the shows and I watched it pull down the meta data, but again, when I enter the library, I see nothing under the show name.

The permissions on /media/shows are all 755 for dirs and 644 for files.  The user running xbmc owns the dirs/files.

Anyone else experiencing this?  XBMCv12.2-5 and an up-to-date system.

Attached is a debug log.  What I did:
1) Loaded xbmc
2) Navigated to Shows>foo (which was empty)
3) Exited xbmc

14:55:00 T:140085346596800  NOTICE: -----------------------------------------------------------------------
14:55:00 T:140085346596800 WARNING: Unable to determine Linux distribution
14:55:00 T:140085346596800  NOTICE: Starting XBMC (12.2 Git:Unknown), Platform: Linux (Unknown, 3.11.5-1-ARCH x86_64). Built on Jul 26 2013
14:55:00 T:140085346596800  NOTICE: special://xbmc/ is mapped to: /usr/share/xbmc
14:55:00 T:140085346596800  NOTICE: special://xbmcbin/ is mapped to: /usr/lib/xbmc
14:55:00 T:140085346596800  NOTICE: special://masterprofile/ is mapped to: /home/facade/.xbmc/userdata
14:55:00 T:140085346596800  NOTICE: special://home/ is mapped to: /home/facade/.xbmc
14:55:00 T:140085346596800  NOTICE: special://temp/ is mapped to: /home/facade/.xbmc/temp
14:55:00 T:140085346596800  NOTICE: The executable running is: /usr/lib/xbmc/xbmc.bin
14:55:00 T:140085346596800  NOTICE: Local hostname: mars
14:55:00 T:140085346596800  NOTICE: Log File is located: /home/facade/.xbmc/temp/xbmc.log
14:55:00 T:140085346596800  NOTICE: -----------------------------------------------------------------------
14:55:00 T:140085346596800  NOTICE: load settings...
14:55:00 T:140085346596800  NOTICE: special://profile/ is mapped to: special://masterprofile/
14:55:00 T:140085346596800  NOTICE: loading special://masterprofile/guisettings.xml
14:55:00 T:140085346596800  NOTICE: Getting hardware information now...
14:55:00 T:140085346596800  NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.
14:55:00 T:140085346596800  NOTICE: Loaded playercorefactory configuration
14:55:00 T:140085346596800  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.
14:55:00 T:140085346596800  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.
14:55:00 T:140085346596800  NOTICE: No settings file to load (special://xbmc/system/advancedsettings.xml)
14:55:00 T:140085346596800  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
14:55:00 T:140085346596800  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <loglevel>0</loglevel>
                                              <gui>
                                                <algorithmdirtyregions>1</algorithmdirtyregions>
                                                <nofliptimeout>1000</nofliptimeout>
                                              </gui>
                                            </advancedsettings>
14:55:00 T:140085346596800  NOTICE: Log level changed to 0
14:55:00 T:140085346596800  NOTICE: Getting hardware information now...
14:55:00 T:140085346596800  NOTICE: Default DVD Player: dvdplayer
14:55:00 T:140085346596800  NOTICE: Default Video Player: dvdplayer
14:55:00 T:140085346596800  NOTICE: Default Audio Player: paplayer
14:55:00 T:140085346596800  NOTICE: Disabled debug logging due to GUI setting. Level 0.
14:55:00 T:140085346596800  NOTICE: Log level changed to 0
14:55:00 T:140085346596800  NOTICE: Loading media sources from special://masterprofile/sources.xml
14:55:00 T:140085346596800  NOTICE: Running database version Addons15
14:55:01 T:140085346596800   ERROR: Unable to load libcec.so.2, reason: libcec.so.2: cannot open shared object file: No such file or directory
14:55:01 T:140085346596800   ERROR: Initialise - failed to initialise bus cec
14:55:01 T:140084887963392  NOTICE: Thread XBMC Peripherals start, auto delete: false
14:55:01 T:140085346596800  NOTICE: Setup SDL
14:55:01 T:140085346596800  NOTICE: Checking resolution 16
14:55:01 T:140085346596800  NOTICE: Using visual 0x21
14:55:01 T:140085346596800  NOTICE: GL_VENDOR = Intel Open Source Technology Center
14:55:01 T:140085346596800  NOTICE: GL_RENDERER = Mesa DRI Intel(R) G45/G43
14:55:01 T:140085346596800  NOTICE: GL_VERSION = 2.1 Mesa 9.2.2
14:55:01 T:140085346596800  NOTICE: GL_SHADING_LANGUAGE_VERSION = 1.20
14:55:01 T:140085346596800  NOTICE: GL_EXTENSIONS = GL_ARB_multisample GL_EXT_abgr GL_EXT_bgra GL_EXT_blend_color GL_EXT_blend_minmax GL_EXT_blend_subtract GL_EXT_copy_texture GL_EXT_polygon_offset GL_EXT_subtexture GL_EXT_texture_object GL_EXT_vertex_array GL_EXT_compiled_vertex_array GL_EXT_texture GL_EXT_texture3D GL_IBM_rasterpos_clip GL_ARB_point_parameters GL_EXT_draw_range_elements GL_EXT_packed_pixels GL_EXT_point_parameters GL_EXT_rescale_normal GL_EXT_separate_specular_color GL_EXT_texture_edge_clamp GL_SGIS_generate_mipmap GL_SGIS_texture_border_clamp GL_SGIS_texture_edge_clamp GL_SGIS_texture_lod GL_ARB_framebuffer_sRGB GL_ARB_multitexture GL_EXT_framebuffer_sRGB GL_IBM_multimode_draw_arrays GL_IBM_texture_mirrored_repeat GL_3DFX_texture_compression_FXT1 GL_ARB_texture_cube_map GL_ARB_texture_env_add GL_ARB_transpose_matrix GL_EXT_blend_func_separate GL_EXT_fog_coord GL_EXT_multi_draw_arrays GL_EXT_secondary_color GL_EXT_texture_env_add GL_EXT_texture_filter_anisotropic GL_EXT_texture_lod_bias GL_INGR_blend_func_separate GL_NV_blend_square GL_NV_light_max_exponent GL_NV_texgen_reflection GL_NV_texture_env_combine4 GL_S3_s3tc GL_SUN_multi_draw_arrays GL_ARB_texture_border_clamp GL_ARB_texture_compression GL_EXT_framebuffer_object GL_EXT_texture_env_combine GL_EXT_texture_env_dot3 GL_MESA_window_pos GL_NV_packed_depth_stencil GL_NV_texture_rectangle GL_ARB_depth_texture GL_ARB_occlusion_query GL_ARB_shadow GL_ARB_texture_env_combine GL_ARB_texture_env_crossbar GL_ARB_texture_env_dot3 GL_ARB_texture_mirrored_repeat GL_ARB_window_pos GL_ATI_envmap_bumpmap GL_EXT_stencil_two_side GL_EXT_texture_cube_map GL_NV_depth_clamp GL_APPLE_packed_pixels GL_APPLE_vertex_array_object GL_ARB_draw_buffers GL_ARB_fragment_program GL_ARB_fragment_shader GL_ARB_shader_objects GL_ARB_vertex_program GL_ARB_vertex_shader GL_ATI_draw_buffers GL_ATI_texture_env_combine3 GL_ATI_texture_float GL_EXT_shadow_funcs GL_EXT_stencil_wrap GL_MESA_pack_invert GL_MESA_ycbcr_texture GL_NV_primitive_restart GL_ARB_depth_clamp GL_ARB_fragment_program_shadow GL_ARB_half_float_pixel GL_ARB_occlusion_query2 GL_ARB_point_sprite GL_ARB_shading_language_100 GL_ARB_sync GL_ARB_texture_non_power_of_two GL_ARB_vertex_buffer_object GL_ATI_blend_equation_separate GL_EXT_blend_equation_separate GL_OES_read_format GL_ARB_color_buffer_float GL_ARB_pixel_buffer_object GL_ARB_texture_compression_rgtc GL_ARB_texture_float GL_ARB_texture_rectangle GL_EXT_packed_float GL_EXT_pixel_buffer_object GL_EXT_texture_compression_dxt1 GL_EXT_texture_compression_rgtc GL_EXT_texture_rectangle GL_EXT_texture_sRGB GL_EXT_texture_shared_exponent GL_ARB_framebuffer_object GL_EXT_framebuffer_blit GL_EXT_packed_depth_stencil GL_APPLE_object_purgeable GL_ARB_vertex_array_object GL_ATI_separate_stencil GL_EXT_draw_buffers2 GL_EXT_draw_instanced GL_EXT_gpu_program_parameters GL_EXT_texture_array GL_EXT_texture_integer GL_EXT_texture_sRGB_decode GL_OES_EGL_image GL_MESA_texture_array GL_ARB_copy_buffer GL_ARB_depth_buffer_float GL_ARB_draw_instanced GL_ARB_half_float_vertex GL_ARB_instanced_arrays GL_ARB_map_buffer_range GL_ARB_texture_rg GL_ARB_texture_swizzle GL_ARB_vertex_array_bgra GL_EXT_separate_shader_objects GL_EXT_texture_swizzle GL_EXT_vertex_array_bgra GL_NV_conditional_render GL_ARB_ES2_compatibility GL_ARB_debug_output GL_ARB_draw_elements_base_vertex GL_ARB_explicit_attrib_location GL_ARB_fragment_coord_conventions GL_ARB_provoking_vertex GL_ARB_sampler_objects GL_ARB_seamless_cube_map GL_ARB_shader_texture_lod GL_ARB_texture_rgb10_a2ui GL_ARB_vertex_type_2_10_10_10_rev GL_EXT_provoking_vertex GL_EXT_texture_snorm GL_MESA_texture_signed_rgba GL_ARB_get_program_binary GL_ARB_robustness GL_ARB_shader_bit_encoding GL_ANGLE_texture_compression_dxt3 GL_ANGLE_texture_compression_dxt5 GL_ARB_internalformat_query GL_ARB_texture_storage GL_ARB_invalidate_subdata
14:55:01 T:140085346596800   ERROR: GLX: Same window as before, refreshing context
14:55:01 T:140085346596800   ERROR: Remote Translator: Can't find button skip
14:55:01 T:140085346596800   ERROR: Keymapping error: no such action 'skipminus' defined
14:55:01 T:140085346596800   ERROR: Remote Translator: Can't find button skip
14:55:01 T:140085346596800   ERROR: Keymapping error: no such action 'skipminus' defined
14:55:01 T:140085346596800  NOTICE: Running database version Addons15
14:55:01 T:140085346596800  NOTICE: Running database version ViewModes4
14:55:01 T:140085346596800  NOTICE: Running database version Textures13
14:55:01 T:140085346596800  NOTICE: Running database version MyMusic32
14:55:01 T:140085346596800  NOTICE: Running database version MyVideos75
14:55:01 T:140085346596800  NOTICE: Running database version TV22
14:55:01 T:140085346596800  NOTICE: Running database version Epg7
14:55:01 T:140085346596800  NOTICE: start dvd mediatype detection
14:55:01 T:140085346596800  NOTICE: initializing playlistplayer
14:55:01 T:140085346596800  NOTICE: DONE initializing playlistplayer
14:55:01 T:140084890326784  NOTICE: Thread CDetectDVDMedia start, auto delete: false
14:55:01 T:140084745492224  NOTICE: Thread XBPyThread start, auto delete: false
14:55:01 T:140085346596800  NOTICE: UpdateLibraries - Starting video library startup scan
14:55:01 T:140084745492224  NOTICE: -->Python Interpreter Initialized<--
14:55:01 T:140085346596800  NOTICE: initialize done
14:55:01 T:140084737099520  NOTICE: Thread CVideoInfoScanner start, auto delete: false
14:55:01 T:140084586215168  NOTICE: Thread XBPyThread start, auto delete: false
14:55:01 T:140085346596800  NOTICE: Enabled Joystick: Microsoft Microsoft® Nano Transceiver v2.0
14:55:01 T:140085346596800  NOTICE: Details: Total Axis: 37 Total Hats: 0 Total Buttons: 57
14:55:01 T:140085346596800  NOTICE: Running the application...
14:55:01 T:140085346596800  NOTICE: Webserver: Starting...
14:55:01 T:140085346596800  NOTICE: WebServer: Started the webserver
14:55:01 T:140084531324672  NOTICE: Thread Jobworker start, auto delete: true
14:55:01 T:140085346596800  NOTICE: starting zeroconf publishing
14:55:01 T:140084401641216  NOTICE: Thread AirPlayServer start, auto delete: false
14:55:01 T:140084410033920  NOTICE: Thread Jobworker start, auto delete: true
14:55:02 T:140084737099520  NOTICE: VideoInfoScanner: Starting scan ..
14:55:02 T:140084108060416  NOTICE: Thread Jobworker start, auto delete: true
14:55:02 T:140084116453120  NOTICE: Thread AirTunesServer start, auto delete: false
14:55:02 T:140084586215168  NOTICE: -->Python Interpreter Initialized<--
14:55:02 T:140084586215168  NOTICE:  StorageServer Module loaded RUN
14:55:02 T:140084586215168  NOTICE: StorageClient-2.5.2 Starting server
14:55:02 T:140084586215168  NOTICE: StorageServer-2.5.2 Storage Server starting /home/facade/.xbmc/temp/commoncache.db
14:55:02 T:140084737099520  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
14:55:04 T:140084737099520  NOTICE: Thread Background Loader start, auto delete: false
14:55:18 T:140085346596800  NOTICE: Previous line repeats 2 times.
14:55:18 T:140085346596800  NOTICE: Storing total System Uptime
14:55:18 T:140085346596800  NOTICE: Saving settings
14:55:18 T:140085346596800  NOTICE: stop all
14:55:18 T:140085346596800  NOTICE: ES: Stopping event server
14:55:18 T:140085346596800  NOTICE: stopping zeroconf publishing
14:55:18 T:140085346596800  NOTICE: Webserver: Stopping...
14:55:18 T:140085346596800  NOTICE: WebServer: Stopped the webserver
14:55:18 T:140085346596800  NOTICE: Webserver: Stopped...
14:55:19 T:140085346596800  NOTICE: stop dvd detect media
14:55:19 T:140085346596800  NOTICE: stop sap announcement listener
14:55:19 T:140085346596800  NOTICE: clean cached files!
14:55:19 T:140085346596800  NOTICE: unload skin
14:55:19 T:140084586215168  NOTICE: StorageServer-2.5.2 Closed down
14:55:19 T:140085346596800  NOTICE: stop python
14:55:19 T:140085346596800  NOTICE: stopped
14:55:19 T:140085346596800  NOTICE: destroy
14:55:19 T:140085346596800  NOTICE: closing down remote control service
14:55:19 T:140085346596800  NOTICE: unload sections
14:55:19 T:140085346596800  NOTICE: destroy
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10013 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10014 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10015 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10016 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10017 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10018 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10019 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10021 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10107 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10115 from the window manager when it didn't exist
14:55:19 T:140085346596800 WARNING: Attempted to remove window 10104 from the window manager when it didn't exist
14:55:19 T:140085346596800  NOTICE: closing down remote control service
14:55:19 T:140085346596800  NOTICE: unload sections
14:55:19 T:140085346596800  NOTICE: application stopped...

Last edited by graysky (2013-10-19 19:46:56)


CPU-optimized Linux-ck packages @ Repo-ck  • AUR packagesZsh and other configs

Offline

#2 2013-10-19 19:25:26

firecat53
Member
From: Lake Stevens, WA, USA
Registered: 2007-05-14
Posts: 1,542
Website

Re: [xbmc] - library is missing records [solved by downgrading sqlite]

Another thread mentioned the recent sqlite upgrade caused problems but I don't remember if it was the same or different issue.

Offline

#3 2013-10-19 19:37:49

graysky
Wiki Maintainer
From: :wq
Registered: 2008-12-01
Posts: 10,595
Website

Re: [xbmc] - library is missing records [solved by downgrading sqlite]

firecat53 wrote:

Another thread mentioned the recent sqlite upgrade caused problems but I don't remember if it was the same or different issue.

Bullseye.  Downgrading 3.8.1-1 -> 3.8.0.2-1 solved this for me.  I will open a flyspray.  Thanks!

EDIT: https://bugs.archlinux.org/task/37417 and https://bugs.archlinux.org/task/37418
EDIT2: http://trac.xbmc.org/ticket/14646

Last edited by graysky (2013-10-19 20:03:55)


CPU-optimized Linux-ck packages @ Repo-ck  • AUR packagesZsh and other configs

Offline

#4 2013-10-21 09:06:05

gotjazz
Member
Registered: 2013-06-06
Posts: 11

Re: [xbmc] - library is missing records [solved by downgrading sqlite]

had the same problem - seems to only happen with series of which you have episodes of more than one season - after setting flatten tv series to always I can see all episodes again. ALbeit not separated by seasons.

Offline

#5 2013-10-26 00:05:55

bleomycin
Member
Registered: 2012-10-23
Posts: 20

Re: [xbmc] - library is missing records [solved by downgrading sqlite]

Wow, glad I stumbled on this thread. This has been driving me nuts, I re-installed xbmc multiple times and re-scanned my library as well without luck. Hopefully this gets fixed soon, or maybe i'll switch to mysql finally.

Offline

#6 2013-10-26 21:09:29

johnpiers
Member
From: Somerset West, Cape Town
Registered: 2012-07-22
Posts: 35

Re: [xbmc] - library is missing records [solved by downgrading sqlite]

Thanks graysky, just to confirm, downgrading sqlite from 3.8.1-1 -> 3.8.0.2-1 did the trick for me as well! Just wondering how an error like this goes unnoticed before the repository is upgraded/updated? Not trolling, a genuine question, did this effect everyone who is using XBMC? Or not? Again, just wondering! Thanks.

Last edited by johnpiers (2013-10-26 21:15:06)

Offline

#7 2013-10-26 21:29:25

graysky
Wiki Maintainer
From: :wq
Registered: 2008-12-01
Posts: 10,595
Website

Re: [xbmc] - library is missing records [solved by downgrading sqlite]

@john - 


CPU-optimized Linux-ck packages @ Repo-ck  • AUR packagesZsh and other configs

Offline

#8 2013-10-26 21:53:56

Scimmia
Fellow
Registered: 2012-09-01
Posts: 11,461

Re: [xbmc] - library is missing records [solved by downgrading sqlite]

johnpiers wrote:

Thanks graysky, just to confirm, downgrading sqlite from 3.8.1-1 -> 3.8.0.2-1 did the trick for me as well! Just wondering how an error like this goes unnoticed before the repository is upgraded/updated?.

It goes unnoticed because of a couple of things:
1. The person doing the packing isn't running XBMC. They can't be expected to test every program that uses sqlite.
2. It seems this didn't go to [testing] at all. This usually happens when the update is necessary for security reasons, but doesn't allow the people running [testing] to find these kind of bugs before they hit the main repo. Looking through the SVN log, this never seems to go to [testing], so that's on the maintainer.

Offline

#9 2013-10-29 19:05:09

graysky
Wiki Maintainer
From: :wq
Registered: 2008-12-01
Posts: 10,595
Website

Re: [xbmc] - library is missing records [solved by downgrading sqlite]

Andreas has just packaged up 3.8.1-2 in [testing] which seems to correct this behavior for me.  Anyone else?


CPU-optimized Linux-ck packages @ Repo-ck  • AUR packagesZsh and other configs

Offline

#10 2013-10-30 09:21:25

tiprya
Member
Registered: 2012-10-14
Posts: 7

Re: [xbmc] - library is missing records [solved by downgrading sqlite]

3.8.1-2 that is now in [extra] works for me.

Thanks for all of the information in this thread.

Offline

Board footer

Powered by FluxBB