gnome-rdp: Error during the connection to database

Bug #174102 reported by Mirko Hufnagel
This bug report is a duplicate of:  Bug #149542: Gnome RDP database corruption. Edit Remove
12
Affects Status Importance Assigned to Milestone
gnome-rdp (Ubuntu)
Fix Released
Undecided
Unassigned

Bug Description

Binary package hint: gnome-rdp

Hello,

after the last update now I get this error message if I start gnome-rdp: "Error during the connection to database."

mhufnagel@mhufnagel-laptop:~$ gnome-rdp
Stacktrace:

  at (wrapper managed-to-native) Mono.Data.SqliteClient.Sqlite.sqlite_compile (intptr,intptr,intptr&,intptr&,intptr&) <0x00004>
  at (wrapper managed-to-native) Mono.Data.SqliteClient.Sqlite.sqlite_compile (intptr,intptr,intptr&,intptr&,intptr&) <0xffffffff>
  at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (intptr,intptr&,intptr&) <0x0009e>
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (System.Data.CommandBehavior,bool,int&) <0x000da>
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (System.Data.CommandBehavior) <0x0001d>
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader () <0x0000f>
  at Mono.Data.SqliteClient.SqliteCommand.System.Data.IDbCommand.ExecuteReader () <0x0000d>
  at GnomeRDP.Sqlite.Query (string) <0x00047>
  at GnomeRDP.Configuration.CheckDatabaseVersion () <0x0007c>
  at GnomeRDP.MainApp.InitializeComponent () <0x00140>
  at GnomeRDP.MainApp..ctor (string[]) <0x000d5>
  at GnomeRDP.MainApp.Main (string[]) <0x00019>
  at (wrapper runtime-invoke) System.Object.runtime_invoke_void_string[] (object,intptr,intptr,intptr) <0xffffffff>

Native stacktrace:

        /usr/bin/mono [0x8194ca6]
        /usr/bin/mono [0x81770ed]
        [0xffffe440]
        /usr/lib/libsqlite.so.0(sqlite_compile+0x35) [0xb4bd0c35]
        [0xb4c9a841]
        [0xb4c9a72f]
        [0xb4c998cb]
        [0xb4c995b6]
        [0xb4c99580]
        [0xb4c99556]
        [0xb4c993b0]
        [0xb4c8f27d]
        [0xb4da7269]
        [0xb7904f9e]
        [0xb7904862]
        [0xb79047d5]
        /usr/bin/mono [0x8176f50]
        /usr/bin/mono(mono_runtime_invoke+0x27) [0x80b0b2f]
        /usr/bin/mono(mono_runtime_exec_main+0x142) [0x80b5383]
        /usr/bin/mono(mono_runtime_run_main+0x27e) [0x80b5631]
        /usr/bin/mono(mono_jit_exec+0xbd) [0x805a4cb]
        /usr/bin/mono [0x805a5a8]
        /usr/bin/mono(mono_main+0x1683) [0x805bdc9]
        /usr/bin/mono [0x8059636]
        /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe0) [0xb7ca6050]
        /usr/bin/mono [0x80595b1]

Debug info from gdb:

(no debugging symbols found)
Using host libthread_db library "/lib/tls/i686/cmov/libthread_db.so.1".
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
[Thread debugging using libthread_db enabled]
[New Thread -1211570480 (LWP 8234)]
[New Thread -1220949104 (LWP 8236)]
[New Thread -1209095280 (LWP 8235)]
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
0xffffe410 in __kernel_vsyscall ()
  3 Thread -1209095280 (LWP 8235) 0xffffe410 in __kernel_vsyscall ()
  2 Thread -1220949104 (LWP 8236) 0xffffe410 in __kernel_vsyscall ()
  1 Thread -1211570480 (LWP 8234) 0xffffe410 in __kernel_vsyscall ()

Thread 3 (Thread -1209095280 (LWP 8235)):
#0 0xffffe410 in __kernel_vsyscall ()
#1 0xb7e0b9f6 in ?? () from /lib/tls/i686/cmov/libpthread.so.0
#2 0x0811bc9f in ?? ()
#3 0xb7eea3ac in ?? ()
#4 0x00000000 in ?? ()

Thread 2 (Thread -1220949104 (LWP 8236)):
#0 0xffffe410 in __kernel_vsyscall ()
#1 0xb7e08676 in pthread_cond_wait@@GLIBC_2.3.2 ()
   from /lib/tls/i686/cmov/libpthread.so.0
#2 0x08120dde in ?? ()
#3 0xb78761dc in ?? ()
#4 0xb78761c4 in ?? ()
#5 0xb7e06541 in pthread_mutex_lock () from /lib/tls/i686/cmov/libpthread.so.0
#6 0x081210eb in ?? ()
#7 0xb78761dc in ?? ()
#8 0xb78761c4 in ?? ()
#9 0x00000000 in ?? ()

Thread 1 (Thread -1211570480 (LWP 8234)):
#0 0xffffe410 in __kernel_vsyscall ()
#1 0xb7d22f69 in fork () from /lib/tls/i686/cmov/libc.so.6
#2 0xb7e0d874 in fork () from /lib/tls/i686/cmov/libpthread.so.0
#3 0xb7e7aab9 in ?? () from /usr/lib/libglib-2.0.so.0
#4 0x00000010 in ?? ()
#5 0x00000010 in ?? ()
#6 0x08599e40 in ?? ()
#7 0xb7dd7170 in ?? () from /lib/tls/i686/cmov/libc.so.6
#8 0x08583a48 in ?? ()
#9 0x00000000 in ?? ()
#0 0xffffe410 in __kernel_vsyscall ()

=================================================================
Got a SIGSEGV while executing native code. This usually indicates
a fatal error in the mono runtime or one of the native libraries
used by your application.
=================================================================

Aborted (core dumped)

Revision history for this message
lilbudda (cory-meisch-gmail) wrote :
Download full text (4.1 KiB)

Stacktrace:

  at (wrapper managed-to-native) Mono.Data.SqliteClient.Sqlite.sqlite_compile (intptr,intptr,intptr&,intptr&,intptr&) <0x00004>
  at (wrapper managed-to-native) Mono.Data.SqliteClient.Sqlite.sqlite_compile (intptr,intptr,intptr&,intptr&,intptr&) <0xffffffff>
  at Mono.Data.SqliteClient.SqliteCommand.GetNextStatement (intptr,intptr&,intptr&) <0x0007e>
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (System.Data.CommandBehavior,bool,int&) <0x000d2>
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (System.Data.CommandBehavior) <0x0001d>
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader () <0x0000f>
  at Mono.Data.SqliteClient.SqliteCommand.System.Data.IDbCommand.ExecuteReader () <0x0000d>
  at GnomeRDP.Sqlite.Query (string) <0x00045>
  at GnomeRDP.Configuration.CheckDatabaseVersion () <0x00075>
  at GnomeRDP.MainApp.InitializeComponent () <0x0013e>
  at GnomeRDP.MainApp..ctor (string[]) <0x000ce>
  at GnomeRDP.MainApp.Main (string[]) <0x00019>
  at (wrapper runtime-invoke) GnomeRDP.MainApp.runtime_invoke_void_string[] (object,intptr,intptr,intptr) <0xffffffff>

Native stacktrace:

 /usr/bin/mono [0x81aa596]
 /usr/bin/mono [0x808bd63]
 /usr/bin/mono [0x818d74a]
 [0xb7f5c440]
 /usr/lib/libsqlite.so.0(sqlite_compile+0x35) [0xb53bdb85]
 [0xb54613a7]
 [0xb54612bf]
 [0xb5460603]
 [0xb546051e]
 [0xb54604e8]
 [0xb54604c6]
 [0xb5460306]
 [0xb558015e]
 [0xb5578797]
 [0xb790a467]
 [0xb790a252]
 [0xb790a1c3]
 /usr/bin/mono [0x818d45e]
 /usr/bin/mono(mono_runtime_invoke+0x29) [0x80b3349]
 /usr/bin/mono(mono_runtime_exec_main+0x24b) [0x80b48f4]
 /usr/bin/mono(mono_runtime_run_main+0x2ec) [0x80b4370]
 /usr/bin/mono(mono_jit_exec+0xbd) [0x805b158]
 /usr/bin/mono [0x805b235]
 /usr/bin/mono(mono_main+0x1380) [0x805c738]
 /usr/bin/mono [0x805a306]
 /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe0) [0xb7d12450]
 /usr/bin/mono [0x805a281]

Debug info from gdb:

(no debugging symbols found)
Using host libthread_db library "/lib/tls/i686/cmov/libthread_db.so.1".
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
[Thread debugging using libthread_db enabled]
[New Thread 0xb7c7ca30 (LWP 7417)]
[New Thread 0xb7384b90 (LWP 7419)]
[New Thread 0xb73a8b90 (LWP 7418)]
(no debugging symbols found)

...

(no debugging symbols found)
0xb7f5c410 in __kernel_vsyscall ()
  3 Thread 0xb73a8b90 (LWP 7418) 0xb7f5c410 in __kernel_vsyscall ()
  2 Thread 0xb7384b90 (LWP 7419) 0xb7f5c410 in __kernel_vsyscall ()
  1 Thread 0xb7c7ca30 (LWP 7417) 0xb7f5c410 in __kernel_vsyscall ()

Thread 3 (Thread 0xb73a8b90 (LWP 7418)):
#0 0xb7f5c410 in __kernel_vsyscall ()
#1 0xb7e7d196 in nanosleep () from /lib/tls/i686/cmov/libpthread.so.0
#2 0x08131b65 in ?? ()
#3 0xb73a83ac in ?? ()
#4 0x00000000 in ?? ()

Thread 2 (Thread 0xb7384b90 (LWP 7419)):
#0 0xb7f5c410 in __kernel_vsyscall ()
#1 0xb7e79aa5 in pthread_cond_wait@@GLIBC_2.3.2 ()
   from /lib/tls/i686/cmov/libpthread.so.0
#2 0x08136f20 in ?? ()
#3 0xb78821dc in ?? ()
#4 0xb78821c4 in ?? ()
#5 0xb7384198 in ?? ()
#6 0x00001cfb in ?? ()
#7 0x08135de7 in ?? ()
#8 0x00000006 in ?? ()
#9 0xb73841c8 in ?? (...

Read more...

Revision history for this message
lilbudda (cory-meisch-gmail) wrote :

Can confirm in Hardy as of 1/22/2008

Changed in gnome-rdp:
status: New → Confirmed
Revision history for this message
Mirko Hufnagel (mirko-linuxart) wrote :

How can I install only the hardy package from gnome-rdp - I don't want update the system.

My gnome-rdp Version:
gnome-rdp --version
gnome-rdp 0.2.2
Copyright (c) 2005-2006 Balazs Varkonyi

Thanks

Revision history for this message
lilbudda (cory-meisch-gmail) wrote :
Revision history for this message
Suco (sucotronic) wrote :

Can somebody download the last release of the original project to test it?
http://sourceforge.net/projects/gnome-rdp

Revision history for this message
tomm3h (tom-ninjabadger) wrote :

Hi all,

I can confirm that I've had the same issue (I upgraded to Hardy RC1 from a fully-updated Gutsy) with gnome-rdp.

I've also tried the latest 0.2.2.3, but this made no difference - the .db file is still unreadable.

I can also confirm that mv'ing my ~/gnome-rdp.db file solves the issue. Except that now I have to repopulate it with all the details I didn't want to have to remember! :(

I've still got my .db, so if anyone has a better fix, I'm all ears.

Thanks

Revision history for this message
starbugx (torben-lanrockers) wrote :
Revision history for this message
woodgdo1 (douglas-woodgate-bpc) wrote :

I just posted this fix to https://bugs.launchpad.net/ubuntu/+source/gnome-rdp/+bug/149542
Could possibly be scripted by package maintainer? The hard part is to tell what version the existing DB is since it is in the home directory...

Another Fix that I just came up with and is a bit more elegant:
(Dump a SQL backup of the DB)
cp .gnome-rdp.db .gnome-rdp2.db
sqlite3 .gnome-rdp.db
sqlite> .output dbdump
sqlite> .dump
sqlite> .quit

(Verify that there is data in the dump file)
cat dbdump

(Restore DB to other version of sqlite)
sqlite new.db
sqlite> .read dbdump
(To verify that the data made it in there correctly)
.dump
.quit
cp new.db .gnome-rdp.db

Start up gnome-rdp
Enjoy!!

Changed in gnome-rdp:
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.