[Linux] Problems with SQL
#1
I copied some data recursively from a external ntfs disk on an ext4 partition. (On terminal)
In some folders there were thumbs.db files. I wanted do delete them (On XBMC GUI) and as I deleted the third or fourth file suddenly the terminal (log in) appeard. XBMC crashed. (sorry for my bad english)

The Problem is, when I move down in XBMC Main Menu twice, XBMC crashes everytime...Shocked

Crashlog:
Code:
############## XBMC CRASH LOG ###############

################ SYSTEM INFO ################
Date: So 9. Mai 13:59:01 CEST 2010
XBMC Options:
Arch: x86_64
Kernel: Linux 2.6.31-20-generic #58-Ubuntu SMP Fri Mar 12 04:38:19 UTC 2010
Release:
    Distributor ID:    Ubuntu
    Description:    Ubuntu 9.10
    Release:    9.10
    Codename:    karmic
############## END SYSTEM INFO ##############

############### STACK TRACE #################
=====>  Core file: /home/****/core
        =========================================
############# END STACK TRACE ###############

################# LOG FILE ##################
....

initialize done
12:25:25 T:140509822175296 M:789893120  NOTICE: Running the application...
12:25:25 T:140509822175296 M:789893120  NOTICE: ES: Starting event server
12:25:25 T:140509822175296 M:789893120  NOTICE: DS: Starting dbus server
12:25:25 T:140509441943824 M:789893120  NOTICE: ES: Starting UDP Event server on 127.0.0.1:9777
12:25:25 T:140509441943824 M:789372928  NOTICE: UDP: Listening on port 9777
12:25:25 T:140509822175296 M:789999616   ERROR:  DS: Failed to connect to the D-Bus session daemon: /bin/dbus-launch terminated abnormally without any error message
12:25:25 T:140509822175296 M:789999616  NOTICE: starting zeroconf publishing
12:25:26 T:140509822175296 M:789688320   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
12:25:26 T:140509822175296 M:788955136   ERROR: exception in CApplication::Process()
12:25:26 T:140509410474256 M:784494592   ERROR: CFileCurl::CReadState::Open, didn't get any data from stream.
12:25:26 T:140509410474256 M:784494592   ERROR: WEATHER: Weather download failed!
12:25:26 T:140509563107600 M:785231872   ERROR: CFileCurl::CReadState::Open, didn't get any data from stream.
12:25:26 T:140509563107600 M:785231872   ERROR: CFileCurl::CReadState::Open, didn't get any data from stream.
12:25:26 T:140509563107600 M:785231872   ERROR: CFileCurl::CReadState::Open, didn't get any data from stream.
12:25:26 T:140509822175296 M:784080896   ERROR: XLCDproc::Initialize - Unable to connect to host. Retry in 4 seconds.
12:25:30 T:140509822175296 M:777318400   ERROR: XLCDproc::Initialize - Unable to connect to host. Retry in 8 seconds.
12:25:38 T:140509822175296 M:777342976   ERROR: XLCDproc::Initialize - Unable to connect to host. Retry in 16 seconds.
12:25:55 T:140509822175296 M:777363456   ERROR: XLCDproc::Initialize - Unable to connect to host. Retry in 32 seconds.
12:26:27 T:140509822175296 M:774918144   ERROR: XLCDproc::Initialize - Unable to connect to host. Retry in 64 seconds.
12:27:31 T:140509822175296 M:774934528   ERROR: XLCDproc::Initialize - Unable to connect to host. Giving up.
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: SQLite: SQL error or missing database
                                            Query: SELECT * FROM sqlite_master WHERE type = 'table' AND name = 'version'
13:59:01 T:140509822175296 M:759848960   ERROR: exception in CApplication::Render()
13:59:01 T:140509822175296 M:759848960   ERROR: CApplication::Render(), too many exceptions
13:59:01 T:140509822175296 M:780603392   ERROR: (pthread_mutex_destroy(&m_mutex)): [XCriticalSection.cpp:84] 16
13:59:01 T:140509822175296 M:780500992 WARNING: Cleanup: Having to cleanup texture pointer-nofocus.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture pointer-focus.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture pointer-focus-drag.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture pointer-focus-click.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture OSDProgressBack.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture OSDProgressMid.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture seekslider.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture osd_slider_nib.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture button-focus.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture button-nofocus.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture home-power.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture home-favourites.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture home-playmedia-FO.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture home-playmedia.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture HomeBladeSub_Part1.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture HomeBladeSub_Part2.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture HomeBlade_bottom.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture HomeHasSub.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture HomeBlade_middle.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture HomeBlade_top.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture XBMC_Logo.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture diffuse_mirror.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture HomeButtonsBack.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture Rss_Back.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture Rss_Back_Overlay.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture header.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture HomeBlade.png
13:59:01 T:140509822175296 M:780398592 WARNING: Cleanup: Having to cleanup texture special://temp/weather/128x128/28.png


############### END LOG FILE ################

############ END XBMC CRASH LOG #############
Reply
#2
I just installed xbmc again... same problem
Reply
#3
A debug log may show more. You may need to enable it via advancedsettings.xml, though there is possibly a commandline switch as well.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#4
looks like a wipe of the userdata might be a good thing to do.
If you have problems please read this before posting

Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.

Image

"Well Im gonna download the code and look at it a bit but I'm certainly not a really good C/C++ programer but I'd help as much as I can, I mostly write in C#."
Reply
#5
I deleted the MyMusic7.db in .xbmc folder... erverything works now
Reply

Logout Mark Read Team Forum Stats Members Help
[Linux] Problems with SQL0