[Pharo-users] SQLite bridge crashed Pharo 5.

[Offray Vladimir Luna Cárdenas]

Hi all,






====================
totalOffshoresByCountry
    "I load the offshores data from a SQLite database or cvs file"
    | queryResults |
    self dataLocation exists
    ifFalse: [ self downloadData  ]
    ifTrue: [

        queryResults := database executeQuery:
            'SELECT country_name, COUNT(*) AS "total_offshores" FROM
                (SELECT country_name, Description_
                FROM nodesNW
                INNER JOIN node_countriesNW
                ON nodesNW.Unique_ID = node_countriesNW.NODEID1
                ORDER BY country_name)
            GROUP BY country_name'].
    ^ queryResults
====================



Any help with this is welcomed.

Cheers,

Offray

I'm working with visualizations a external dataset which contains 270k records. So the best strategy seems to bridge pharo with SQLite to keep requirements low while using Roassal to visualize aggregated information that is obtained from querying the database. That seemed working fine for a while, but just a few minutes ago my image started to crash and after a while it crashed beyond being useful (it doesn't start anymore). I have added the crash dump file, to see if anyone of you can help me making sense of it and trying to detect where is the failure. I imagine that there is something wrong about the way I'm making the query This is the suspect method: database := (SQLiteConnection fileNamed: dataLocation fullName ) open. I have restarted a new image, but I can not remember which package provides SQLiteConnection. I imagine is some migration of NBSQLite under UFFI, but I can not find it in the pharo catalog.

crash.dmp
Description: application/vnd.tcpdump.pcap