[Bug 1631218] Re: seg faults in sqlite3 program

[Kevin O'Gorman]

here's the program it was running.

Here's the database schema
CREATE TABLE base64 (
        b64char CHAR NOT NULL PRIMARY KEY,
        b64val  INTEGER);
CREATE TABLE pos (
        pnum INTEGER PRIMARY KEY AUTOINCREMENT,
        ppos CHAR(64) NOT NULL,
        pcensus INTEGER NOT NULL,
        pscore INTEGER,
        pstate CHAR DEFAULT "N" NOT NULL,
        pmin INTEGER DEFAULT -99 NOT NULL,
        pmax INTEGER DEFAULT 99 NOT NULL,
        pmain CHAR(64));
CREATE UNIQUE INDEX pipos ON pos (ppos);
CREATE TABLE move (
        mfrom INTEGER NOT NULL,
        mto   INTEGER NOT NULL,
        mtype CHAR NOT NULL,
        mcell INTEGER NOT NULL,
        mvalue INTEGER,
        ma INTEGER DEFAULT -99,
        mb INTEGER DEFAULT 99,
        PRIMARY KEY (mfrom, mto, mcell));
CREATE UNIQUE INDEX mrev ON move (mto, mfrom, mcell);
CREATE TABLE expanded (
        census INTEGER NOT NULL,
        number INTEGER NOT NULL,
        pos CHAR(64),
        PRIMARY KEY (census, number));
CREATE INDEX exin ON expanded (number);
CREATE INDEX exis ON expanded (pos);


** Attachment added: "eround.py"
   https://bugs.launchpad.net/ubuntu/+source/python3.5/+bug/1631218/+attachment/4756383/+files/eround.py

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to python3.5 in Ubuntu.
https://bugs.launchpad.net/bugs/1631218

Title:
  seg faults in sqlite3 program

Status in python3.5 package in Ubuntu:
  New

Bug description:
  A small Python program that uses sqlite3 frequently gives me
  segmentation faults, but I'm not sure it's consistent.  Thus I'm a bit
  baffled about what to include, or how to help narrow down the problem.
  The inputs and the database are both quite large.  The core file is
  large enough at 12 MB, though I'll xz it for transport.

  However, I'll try to attach the core file and the program ( which is
  pretty simple ).  I'm hoping the core file gives you enough of a clue
  right off.

  ProblemType: Bug
  DistroRelease: Ubuntu 16.04
  Package: libpython3.5-stdlib 3.5.2-2~16.01
  ProcVersionSignature: Ubuntu 4.4.0-34.53-generic 4.4.15
  Uname: Linux 4.4.0-34-generic x86_64
  NonfreeKernelModules: wl
  ApportVersion: 2.20.1-0ubuntu2.1
  Architecture: amd64
  CurrentDesktop: XFCE
  Date: Thu Oct  6 17:40:55 2016
  InstallationDate: Installed on 2016-08-08 (59 days ago)
  InstallationMedia: Xubuntu 16.04.1 LTS "Xenial Xerus" - Release amd64 (20160719)
  SourcePackage: python3.5
  UpgradeStatus: No upgrade log present (probably fresh install)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/python3.5/+bug/1631218/+subscriptions