Thanks for the analysis, Laurent.

We have a fairly good idea what the problem is and will probably fix
this tomorrow.

The problem appears to be an open cursor being used twice in your
situation. The fix we did first was ensuring an inner query isn't
happening using a cursor. The fix we'll do tomorrow is also converting
the outer query to use a result-set instead of a cursor.

This is likely the one that in both your and Tshepang's case is being
fired twice.

Afterward we might implement support for the same query being running
twice as a cursor. Right now we don't support this because we cache our
sqlite statements. Then we will revert our current quick-fixes and use
cursors for everything again. But that's for later.

Cheers,


On Wed, 2009-11-04 at 00:37 +0100, Laurent Aguerreche wrote:
> Hello,
> 
> 
> with an up-to-date tracker, I get:
> 
> (tracker-store:5449): Tracker-DEBUG: <--- [14252] D-Bus request for
> SPARQL Query, query:'SELECT ?file { ?file nfo:fileLastModified
> "2009-09-13T18:54:28Z" . FILTER (?file =
> <file:///local/laguerre/Administratif/blah>) }'
> (tracker-store:5449): Tracker-DEBUG: ---> [14252] Success, no error
> given
> (tracker-store:5449): Tracker-DEBUG: <--- [14253] D-Bus request for
> SPARQL Query, query:'SELECT ?file { ?file nfo:fileLastModified
> "2009-09-13T18:54:28Z" . FILTER (?file =
> <file:///local/laguerre/Administratif/blah/hop%20hop.pdf>) }'
> (tracker-store:5449): Tracker-DEBUG: ---> [14253] Success, no error
> given
> (tracker-store:5449): Tracker-DEBUG: <--- [14254] D-Bus request for
> SPARQL Query, query:'SELECT ?file { ?file nfo:fileLastModified
> "2009-09-13T18:54:28Z" . FILTER (?file =
> <file:///local/laguerre/Administratif/blah/hip%20hip.pdf>) }'
> (tracker-store:5449): Tracker-DEBUG: ---> [14254] Success, no error
> given
> (tracker-store:5449): Tracker-DEBUG: <--- [14255] D-Bus request for
> batch SPARQL Update, update:'DROP GRAPH <file:///local/laguerre/Desktop>
> INSERT {
> <file:///local/laguerre/Desktop> a nfo:FileDataObject ;
>        nfo:belongsToContainer <file:///local/laguerre> ;
>        nfo:fileName "Desktop" ;
>        nfo:fileSize 4096 ;
>        nfo:fileLastModified "2009-11-03T20:20:50Z" ;
>        nfo:fileLastAccessed "2009-11-03T20:22:43Z" .
> <file:///local/laguerre/Desktop> a nie:InformationElement , nfo:Folder ;
>        nie:isStoredAs <file:///local/laguerre/Desktop> ;
>        nie:mimeType "inode/directory" .
> <file:///local/laguerre/Desktop> a nfo:FileDataObject ;
>        nie:dataSource
> <urn:nepomuk:datasource:9291a450-1d49-11de-8c30-0800200c9a66> ;
>        tracker:available true .
> }
> '
> (tracker-store:5449): Tracker-DEBUG: Preparing query: 'SELECT
> "tracker:added" FROM "rdfs:Resource" WHERE ID = ?'
> **
> Tracker:ERROR:tracker-db-interface-sqlite.c:1231:tracker_db_statement_sqlite_reset:
>  assertion failed: (!priv->stmt_is_sunk)
> 
> Program received signal SIGABRT, Aborted.
> 0x0000003631e332f5 in raise () from /lib64/libc.so.6
> Missing separate debuginfos, use: debuginfo-install
> DeviceKit-power-010-0.3.20090810git.fc11.x86_64
> GConf2-2.26.2-1.fc11.x86_64 ORBit2-2.14.17-1.fc11.x86_64
> dbus-glib-0.80-2.fc11.x86_64 dbus-libs-1.2.12-2.fc11.x86_64
> e2fsprogs-libs-1.41.4-12.fc11.x86_64 gamin-0.1.10-4.fc11.x86_64
> glib2-2.20.5-1.fc11.x86_64 glibc-2.10.1-5.x86_64
> gtk2-2.16.6-2.fc11.x86_64 gvfs-1.2.3-12.fc11.x86_64
> hal-libs-0.5.12-29.20090226git.fc11.x86_64 libattr-2.4.43-3.fc11.x86_64
> libcap-2.16-4.fc11.1.x86_64 libpng-1.2.37-1.fc11.x86_64
> libselinux-2.0.80-1.fc11.x86_64 libusb-0.1.12-21.fc11.x86_64
> pango-1.24.5-1.fc11.x86_64 sqlite-3.6.17-1.fc11.x86_64
> zlib-1.2.3-22.fc11.x86_64
> (gdb) bt f
> #0  0x0000003631e332f5 in raise () from /lib64/libc.so.6
> No symbol table info available.
> #1  0x0000003631e34b20 in abort () from /lib64/libc.so.6
> No symbol table info available.
> #2  0x0000003bc065d0bf in g_assertion_message ()
> from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #3  0x0000003bc065d660 in g_assertion_message_expr ()
> from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #4  0x00007ffff7ddd21e in tracker_db_statement_sqlite_reset (stmt=<value
> optimized out>) at tracker-db-interface-sqlite.c:1231
>         __PRETTY_FUNCTION__ = "tracker_db_statement_sqlite_reset"
> #5  0x00007ffff7dddef2 in tracker_db_interface_sqlite_create_statement
> (db_interface=0x6298c0, query=0x9f8be0 "SELECT \"dc:source\" FROM
> \"rdfs:Resource_dc:source\" WHERE ID = ?") at
> tracker-db-interface-sqlite.c:506
>         stmt = <value optimized out>
> #6  0x00007ffff7ddb04a in tracker_db_interface_create_statement
> (interface=0x6298c0, query=<value optimized out>) at
> tracker-db-interface.c:291
>         stmt = <value optimized out>
>         args = {{gp_offset = 32, fp_offset = 48, overflow_arg_area =
> 0x7fffffffcd00, reg_save_area = 0x7fffffffcc30}}
>         __PRETTY_FUNCTION__ = "tracker_db_interface_create_statement"
> #7  0x00007ffff7db6dcc in get_property_values (property=<value optimized
> out>) at tracker-data-update.c:761
>         iface = 0x1549
>         stmt = <value optimized out>
>         result_set = <value optimized out>
>         table_name = 0xb837c0 "rdfs:Resource_dc:source"
>         field_name = 0x98a540 "dc:source"
>         multiple_values = <value optimized out>
>         old_values = 0xb34a40
> #8  0x00007ffff7db808c in delete_metadata_decomposed (property=0x995c90,
> value=0xa4cf98
> "urn:nepomuk:datasource:9291a450-1d49-11de-8c30-0800200c9a66",
> error=0x0) at tracker-data-update.c:982
>         multiple_values = <value optimized out>
>         fts = 0
>         table_name = 0xa4cfe0 "rdfs:Resource_dc:source"
>         field_name = 0x98a540 "dc:source"
>         super_properties = <value optimized out>
>         gvalue = {g_type = 0, data = {{v_int = 0, v_uint = 0, v_long =
> 0, v_ulong = 0, v_int64 = 0, v_uint64 = 0, v_float = 0, v_double = 0,
> v_pointer = 0x0}, {v_int = 0, v_uint = 0, v_long = 0, v_ulong = 0,
> v_int64 = 0, v_uint64 = 0, v_float = 0, v_double = 0, 
>               v_pointer = 0x0}}}
>         old_values = <value optimized out>
> #9  0x00007ffff7db8f61 in tracker_data_delete_statement
> (subject=0xbe5d10 "file:///local/laguerre/Desktop", predicate=0x98cbf0
> "http://purl.org/dc/elements/1.1/source";, object=0xa4cf98
> "urn:nepomuk:datasource:9291a450-1d49-11de-8c30-0800200c9a66",
> error=0x0)
>     at tracker-data-update.c:1157
>         class = <value optimized out>
>         field = 0x0
>         __PRETTY_FUNCTION__ = "tracker_data_delete_statement"
> #10 0x00007ffff7db958f in tracker_data_delete_resource_description
> (uri=0xbe5d10 "file:///local/laguerre/Desktop", error=<value optimized
> out>) at tracker-data-update.c:1798
>         iface = 0x6298c0
>         stmt = <value optimized out>
>         cursor = 0xae5b80
>         single_cursor = 0xb06f80
>         multi_cursor = 0xd25840
>         class = 0x639a80
>         sql = <value optimized out>
>         properties = <value optimized out>
>         property = 0x9ce620
>         class_uri = <value optimized out>
>         value = <value optimized out>
>         i = 13
>         first = <value optimized out>
> #11 0x00007ffff7dc275a in tracker_sparql_query_execute_drop_graph
> (self=<value optimized out>, error=0x7fffffffcf18) at
> tracker-sparql-query.c:2464
>         _inner_error_ = 0x0
>         is_var = 0
>         uri = 0xbe5d10 "file:///local/laguerre/Desktop"
>         __PRETTY_FUNCTION__ = "tracker_sparql_query_execute_drop_graph"
> #12 0x00007ffff7dd1733 in tracker_sparql_query_execute (self=0x9e3000,
> error=0x7fffffffcf98) at tracker-sparql-query.c:1157
>         result = <value optimized out>
>         _inner_error_ = 0x0
>         _tmp0_ = <value optimized out>
>         __PRETTY_FUNCTION__ = "tracker_sparql_query_execute"
> #13 0x00007ffff7db5df3 in tracker_data_update_sparql (update=<value
> optimized out>, error=0x7fffffffcf98) at tracker-data-update.c:1838
>         iface = 0x6298c0
>         sparql_query = 0x9e3000
>         __PRETTY_FUNCTION__ = "tracker_data_update_sparql"
> #14 0x000000000040bf47 in queue_idle_handler (user_data=<value optimized
> out>) at tracker-store.c:203
>         error = 0x0
>         private = 0x9b0af0
>         task = <value optimized out>
>         __PRETTY_FUNCTION__ = "queue_idle_handler"
> #15 0x0000003bc063790e in g_main_context_dispatch ()
> from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #16 0x0000003bc063b0e8 in ?? () from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #17 0x0000003bc063b535 in g_main_loop_run ()
> from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #18 0x000000000040927f in main (argc=1, argv=0x7fffffffd268) at
> tracker-main.c:430
>         context = <value optimized out>
>         error = 0x0
>         config = 0x629240
>         flags = TRACKER_DB_MANAGER_REMOVE_CACHE
>         is_first_time_index = 0
>         need_journal = 0
> (gdb) 
> 
> 
> 
> 
> 
> 
> I have to say that this crash does not always occur at the start-up of
> tracker-store but seems to happen most of the time when my Desktop is
> read! By the way, I have been able to index all my files a few minutes
> ago without a tracker-store crash. But it crashed again when I
> re-launched it...
> 
> I can crash tracker-store faster if I launch Evolution:
> 
> 
> 
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'SELECT
> "nco:emailAddress" FROM "nco:EmailAddress" WHERE ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "nco:ContactMedium" (ID) VALUES (?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "nco:EmailAddress" (ID) VALUES (?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'UPDATE
> "nco:EmailAddress" SET "nco:emailAddress" = ? WHERE ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "nco:Role_nco:hasEmailAddress" (ID, "nco:hasEmailAddress") VALUES
> (?, ?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "nco:Role_nco:hasContactMedium" (ID, "nco:hasContactMedium") VALUES
> (?, ?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'UPDATE
> "nie:InformationElement" SET "nie:isStoredAs" = ? WHERE ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "nmo:MailboxDataObject" (ID) VALUES (?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'UPDATE
> "nie:DataObject" SET "tracker:available" = ?, "nie:byteSize" = ? WHERE
> ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "nmo:Message_nmo:cc" (ID, "nmo:cc") VALUES (?, ?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "rdfs:Resource_nao:hasTag" (ID, "nao:hasTag") VALUES (?, ?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "nmo:Message" (ID) VALUES (?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'UPDATE
> "nmo:Message" SET "nmo:messageSubject" = ?, "nmo:receivedDate" = ?,
> "nmo:isRead" = ?, "nmo:from" = ? WHERE ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "nmo:Message_nmo:to" (ID, "nmo:to") VALUES (?, ?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'INSERT OR IGNORE
> INTO "nmo:Email" (ID) VALUES (?)'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'UPDATE
> "nmo:Email" SET "nmo:isDeleted" = ?, "nmo:isAnswered" = ?,
> "nmo:isFlagged" = ? WHERE ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'SELECT
> "rdfs:comment", "rdfs:label", strftime ("%Y-%m-%dT%H:%M:%SZ",
> "tracker:added", "unixepoch"), CAST ("tracker:modified" AS TEXT),
> "dc:title", "dc:creator", "dc:subject", "dc:description",
> "dc:publisher", "dc:contributor", "dc:type", "dc:format",
> "dc:identifier", "dc:language", "dc:coverage", "dc:rights",
> "nao:identifier" FROM "rdfs:Resource" WHERE ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'SELECT
> "tracker:added" FROM "rdfs:Resource" WHERE ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'SELECT
> "tracker:modified" FROM "rdfs:Resource" WHERE ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'SELECT strftime
> ("%Y-%m-%dT%H:%M:%SZ", "dc:date", "unixepoch") FROM
> "rdfs:Resource_dc:date" WHERE ID = ?'
> (tracker-store:5643): Tracker-DEBUG: Preparing query: 'SELECT
> "dc:source" FROM "rdfs:Resource_dc:source" WHERE ID = ?'
> **
> Tracker:ERROR:tracker-db-interface-sqlite.c:1231:tracker_db_statement_sqlite_reset:
>  assertion failed: (!priv->stmt_is_sunk)
> 
> Program received signal SIGABRT, Aborted.
> 0x0000003631e332f5 in raise () from /lib64/libc.so.6
> (gdb) bt f
> #0  0x0000003631e332f5 in raise () from /lib64/libc.so.6
> No symbol table info available.
> #1  0x0000003631e34b20 in abort () from /lib64/libc.so.6
> No symbol table info available.
> #2  0x0000003bc065d0bf in g_assertion_message ()
> from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #3  0x0000003bc065d660 in g_assertion_message_expr ()
> from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #4  0x00007ffff7ddd21e in tracker_db_statement_sqlite_reset (stmt=<value
> optimized out>) at tracker-db-interface-sqlite.c:1231
>         __PRETTY_FUNCTION__ = "tracker_db_statement_sqlite_reset"
> #5  0x00007ffff7dddef2 in tracker_db_interface_sqlite_create_statement
> (db_interface=0x6298c0, query=0xa71140 "SELECT \"dc:source\" FROM
> \"rdfs:Resource_dc:source\" WHERE ID = ?") at
> tracker-db-interface-sqlite.c:506
>         stmt = <value optimized out>
> #6  0x00007ffff7ddb04a in tracker_db_interface_create_statement
> (interface=0x6298c0, query=<value optimized out>) at
> tracker-db-interface.c:291
>         stmt = <value optimized out>
>         args = {{gp_offset = 32, fp_offset = 48, overflow_arg_area =
> 0x7fffffffc660, reg_save_area = 0x7fffffffc590}}
>         __PRETTY_FUNCTION__ = "tracker_db_interface_create_statement"
> #7  0x00007ffff7db6dcc in get_property_values (property=<value optimized
> out>) at tracker-data-update.c:761
>         iface = 0x160b
>         stmt = <value optimized out>
>         result_set = <value optimized out>
>         table_name = 0xa60590 "rdfs:Resource_dc:source"
>         field_name = 0x98a540 "dc:source"
>         multiple_values = <value optimized out>
>         old_values = 0xc3df20
> #8  0x00007ffff7db808c in delete_metadata_decomposed (property=0x995c90,
> value=0xa362e8
> "urn:nepomuk:datasource:1cb1eb90-1241-11de-8c30-0800200c9a66",
> error=0x0) at tracker-data-update.c:982
>         multiple_values = <value optimized out>
>         fts = 0
>         table_name = 0xa04570 "rdfs:Resource_dc:source"
>         field_name = 0x98a540 "dc:source"
>         super_properties = <value optimized out>
>         gvalue = {g_type = 0, data = {{v_int = 0, v_uint = 0, v_long =
> 0, v_ulong = 0, v_int64 = 0, v_uint64 = 0, v_float = 0, v_double = 0,
> v_pointer = 0x0}, {v_int = 0, v_uint = 0, v_long = 0, v_ulong = 0,
> v_int64 = 0, v_uint64 = 0, v_float = 0, v_double = 0, 
>               v_pointer = 0x0}}}
>         old_values = <value optimized out>
> #9  0x00007ffff7db8f61 in tracker_data_delete_statement
> (subject=0x9d9240 "email://1215617975.4227...@dohko/INBOX/17143",
> predicate=0x98cbf0 "http://purl.org/dc/elements/1.1/source";,
> object=0xa362e8
> "urn:nepomuk:datasource:1cb1eb90-1241-11de-8c30-0800200c9a66", 
>     error=0x0) at tracker-data-update.c:1157
>         class = <value optimized out>
>         field = 0x0
>         __PRETTY_FUNCTION__ = "tracker_data_delete_statement"
> #10 0x00007ffff7db958f in tracker_data_delete_resource_description
> (uri=0x9d9240 "email://1215617975.4227...@dohko/INBOX/17143",
> error=<value optimized out>) at tracker-data-update.c:1798
>         iface = 0x6298c0
>         stmt = <value optimized out>
>         cursor = 0xa57300
>         single_cursor = 0xbf71c0
>         multi_cursor = 0xbf7200
>         class = 0x639a80
>         sql = <value optimized out>
>         properties = <value optimized out>
>         property = 0x9ce620
>         class_uri = <value optimized out>
>         value = <value optimized out>
>         i = 13
>         first = <value optimized out>
> #11 0x00007ffff7dc275a in tracker_sparql_query_execute_drop_graph
> (self=<value optimized out>, error=0x7fffffffc878) at
> tracker-sparql-query.c:2464
>         _inner_error_ = 0x0
>         is_var = 0
>         uri = 0x9d9240 "email://1215617975.4227...@dohko/INBOX/17143"
>         __PRETTY_FUNCTION__ = "tracker_sparql_query_execute_drop_graph"
> #12 0x00007ffff7dd1733 in tracker_sparql_query_execute (self=0x9e3000,
> error=0x7fffffffc908) at tracker-sparql-query.c:1157
>         result = <value optimized out>
>         _inner_error_ = 0x0
>         _tmp0_ = <value optimized out>
>         __PRETTY_FUNCTION__ = "tracker_sparql_query_execute"
> #13 0x00007ffff7db5df3 in tracker_data_update_sparql (update=<value
> optimized out>, error=0x7fffffffc908) at tracker-data-update.c:1838
>         iface = 0x6298c0
>         sparql_query = 0x9e3000
>         __PRETTY_FUNCTION__ = "tracker_data_update_sparql"
> #14 0x000000000040bc91 in tracker_store_sparql_update (
>     sparql=0xc4bea0 "DROP GRAPH
> <email://1215617975.4227...@dohko/INBOX/17142>\nINSERT
> {\n<urn:nepomuk:datasource:1cb1eb90-1241-11de-8c30-0800200c9a66>
> rdf:type
> <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#Data";...,
> error=0x7fffffffc908)
>     at tracker-store.c:528
>         private = <value optimized out>
>         __PRETTY_FUNCTION__ = "tracker_store_sparql_update"
> #15 0x0000000000409c6c in tracker_resources_sparql_update (self=<value
> optimized out>, 
>     update=0xc4bea0 "DROP GRAPH
> <email://1215617975.4227...@dohko/INBOX/17142>\nINSERT
> {\n<urn:nepomuk:datasource:1cb1eb90-1241-11de-8c30-0800200c9a66>
> rdf:type
> <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#Data";...,
> context=0xbb1b60, 
>     error=<value optimized out>) at tracker-resources.c:237
>         actual_error = 0x0
>         request_id = 480
> #16 0x0000003bc3a0c55c in ?? () from /usr/lib64/libdbus-glib-1.so.2
> No symbol table info available.
> #17 0x0000003bc3a0ca15 in ?? () from /usr/lib64/libdbus-glib-1.so.2
> No symbol table info available.
> #18 0x0000003638e1c27e in ?? () from /lib64/libdbus-1.so.3
> No symbol table info available.
> #19 0x0000003638e104dc in dbus_connection_dispatch ()
> from /lib64/libdbus-1.so.3
> No symbol table info available.
> #20 0x0000003bc3a098d5 in ?? () from /usr/lib64/libdbus-glib-1.so.2
> No symbol table info available.
> #21 0x0000003bc063790e in g_main_context_dispatch ()
> from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #22 0x0000003bc063b0e8 in ?? () from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #23 0x0000003bc063b535 in g_main_loop_run ()
> from /lib64/libglib-2.0.so.0
> No symbol table info available.
> #24 0x000000000040927f in main (argc=1, argv=0x7fffffffd268) at
> tracker-main.c:430
>         context = <value optimized out>
>         error = 0x0
>         config = 0x629240
>         flags = TRACKER_DB_MANAGER_REMOVE_CACHE
>         is_first_time_index = 0
>         need_journal = 0
> (gdb) 
> 
> 
> 
> The crash seems to happen when the last (new?) mail has been read.
> 
> 
> Good luck...
> 
> 
> Laurent.
> 
> 
> 
> 
> 
> Le mardi 03 novembre 2009 à 15:33 +0200, Tshepang Lekhonkhobe a écrit :
> Tracker:ERROR:tracker-db-interface-sqlite.c:1231:tracker_db_statement_sqlite_reset:
> > assertion failed: (!priv->stmt_is_sunk)
> > 
> > Program received signal SIGABRT, Aborted.
> > 0xb7fe1424 in __kernel_vsyscall ()
> > (gdb) bt
> > #0  0xb7fe1424 in __kernel_vsyscall ()
> > #1  0xb7ab53d0 in *__GI_raise (sig=6) at
> > ../nptl/sysdeps/unix/sysv/linux/raise.c:64
> > #2  0xb7ab8a85 in *__GI_abort () at abort.c:88
> > #3  0xb7c86c2c in IA__g_assertion_message (domain=0xb7fd4f8b
> > "Tracker", file=0xb7fdaacd "tracker-db-interface-sqlite.c", line=1231,
> >     func=0xb7fdae40 "tracker_db_statement_sqlite_reset",
> > message=0x8414010 "assertion failed: (!priv->stmt_is_sunk)")
> >
> at 
> /build/buildd-glib2.0_2.22.2-2-i386-R8GTDn/glib2.0-2.22.2/glib/gtestutils.c:1302
> > #4  0xb7c8724d in IA__g_assertion_message_expr (domain=0xb7fd4f8b
> > "Tracker", file=0xb7fdaacd "tracker-db-interface-sqlite.c", line=1231,
> >     func=0xb7fdae40 "tracker_db_statement_sqlite_reset",
> > expr=0xb7fdab0b "!priv->stmt_is_sunk") at
> > /build/buildd-glib2.0_2.22.2-2-i386-R8GTDn/glib2.0-2.22.2/glib/gtestutils.c:1313
> > #5  0xb7fc555c in tracker_db_statement_sqlite_reset (stmt=<value
> > optimized out>) at tracker-db-interface-sqlite.c:1231
> > #6  0xb7fc55ad in tracker_db_interface_sqlite_create_statement
> > (db_interface=0x806f0f0, query=0x80662b8 "SELECT \"dc:source\" FROM
> > \"rdfs:Resource_dc:source\" WHERE ID = ?")
> >     at tracker-db-interface-sqlite.c:506
> > #7  0xb7fc204a in tracker_db_interface_create_statement
> > (interface=0x806f0f0, query=0xb7fd5abc "SELECT \"%s\" FROM \"%s\"
> > WHERE ID = ?") at tracker-db-interface.c:291
> > #8  0xb7f9a67a in get_property_values (property=0x83c9800) at
> > tracker-data-update.c:761
> > #9  0xb7f9bb0d in delete_metadata_decomposed (property=0x83c9800,
> > value=0x8066270
> > "urn:nepomuk:datasource:9291a450-1d49-11de-8c30-0800200c9a66",
> > error=0x0)
> >     at tracker-data-update.c:982
> > #10 0xb7f9ca7b in tracker_data_delete_statement (subject=0x806e2d0
> > "file:///home/wena/work/easyview/logs/mule.log", predicate=0x83c9788
> > "http://purl.org/dc/elements/1.1/source";,
> >     object=0x8066270
> > "urn:nepomuk:datasource:9291a450-1d49-11de-8c30-0800200c9a66",
> > error=0x0) at tracker-data-update.c:1157
> > #11 0xb7f9cfe5 in tracker_data_delete_resource_description
> > (uri=0x806e2d0 "file:///home/wena/work/easyview/logs/mule.log",
> > error=0xbffff25c) at tracker-data-update.c:1798
> > #12 0xb7fb6995 in tracker_sparql_query_execute_drop_graph
> > (self=0x83ff340, error=0xbffff2d8) at tracker-sparql-query.c:2464
> > #13 tracker_sparql_query_execute (self=0x83ff340, error=0xbffff2d8) at
> > tracker-sparql-query.c:1157
> > #14 0xb7f9951f in tracker_data_update_sparql (
> >     update=0x84040c8 "DROP GRAPH
> > <file:///home/wena/work/easyview/logs/mule.log> INSERT
> > {\n<file:///home/wena/work/easyview/logs/mule.log> a
> > nfo:FileDataObject ;\n\t nfo:belongsToContainer
> > <file:///home/wena/work/easyview/log"..., error=0xbffff2d8) at
> > tracker-data-update.c:1838
> > #15 0x080533eb in queue_idle_handler (user_data=0x83f5110) at
> > tracker-store.c:203
> > #16 0xb7c5e0b1 in g_idle_dispatch (source=0x8410f10, callback=0,
> > user_data=0x83f5110) at
> > /build/buildd-glib2.0_2.22.2-2-i386-R8GTDn/glib2.0-2.22.2/glib/gmain.c:4065
> > #17 0xb7c5fe98 in g_main_dispatch (context=0x80670b0) at
> > /build/buildd-glib2.0_2.22.2-2-i386-R8GTDn/glib2.0-2.22.2/glib/gmain.c:1960
> > #18 IA__g_main_context_dispatch (context=0x80670b0) at
> > /build/buildd-glib2.0_2.22.2-2-i386-R8GTDn/glib2.0-2.22.2/glib/gmain.c:2513
> > #19 0xb7c63623 in g_main_context_iterate (context=0x80670b0, block=1,
> > dispatch=1, self=0x805b850) at
> > /build/buildd-glib2.0_2.22.2-2-i386-R8GTDn/glib2.0-2.22.2/glib/gmain.c:2591
> > #20 0xb7c63aea in IA__g_main_loop_run (loop=0x8402238) at
> > /build/buildd-glib2.0_2.22.2-2-i386-R8GTDn/glib2.0-2.22.2/glib/gmain.c:2799
> > #21 0x080503f6 in main (argc=Cannot access memory at address 0x0
> > ) at tracker-main.c:430
> > 
> > 
> > On Tue, Nov 3, 2009 at 15:21, Philip Van Hoof<[email protected]> wrote:
> > > Can you give us a new backtrace?
> > >
> > > On Tue, 2009-11-03 at 14:01 +0200, Tshepang Lekhonkhobe wrote:
> > >> On Tue, Nov 3, 2009 at 13:03, Tshepang
> Lekhonkhobe<[email protected]> wrote:
> > >> > On Tue, Nov 3, 2009 at 12:50, Philip Van Hoof<[email protected]>
> wrote:
> > >> >> On Tue, 2009-11-03 at 11:48 +0100, Philip Van Hoof wrote:
> > >> >>> On Tue, 2009-11-03 at 12:46 +0200, Tshepang Lekhonkhobe wrote:
> > >> >>> > On Tue, Nov 3, 2009 at 12:04, Philip Van
> Hoof<[email protected]> wrote:
> > >> >>> > > We can't reproduce this problem. It would be useful if you
> guys could
> > >> >>> > > try to reproduce it after applying this patch:
> > >> >>> >
> > >> >>> > same crash; I'll do "tracker-control -r" and check again
> > >> >>>
> > >> >>> No, no need. Keep your situation if you can easily reproduce
> this way.
> > >> >>> We'll need it in a few moments to test against.
> > >> >
> > >> > silly me. I was too quick.
> > >> >
> > >> >> Can you try to reproduce against current master? We committed a
> fix for
> > >> >> this, but as we can't reproduce this ourselves you'll have to
> verify it.
> > >> >
> > >> > let's see if I can reproduce before I install the update; it's
> going
> > >> > to take a while; unless Laurent still got old DB around and
> checks
> > >> > this update
> > >>
> > >> I managed to reproduce even after a re-index, and even after
> > >> installing the update from master.
> > >>
> > >>
> > >
> > >
> > > --
> > > Philip Van Hoof, freelance software developer
> > > home: me at pvanhoof dot be
> > > gnome: pvanhoof at gnome dot org
> > > http://pvanhoof.be/blog
> > > http://codeminded.be
> > >
> > >
> 
> 


-- 
Philip Van Hoof, freelance software developer
home: me at pvanhoof dot be 
gnome: pvanhoof at gnome dot org 
http://pvanhoof.be/blog
http://codeminded.be

_______________________________________________
tracker-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/tracker-list

Reply via email to