On 21 July 2014 11:43, Stephan Beal <sgb...@googlemail.com> wrote:
> On Mon, Jul 21, 2014 at 11:39 AM, Michai Ramakers <m.ramak...@gmail.com>
> wrote:
>>
>> datetime(checkin_mtime(4258,rid),'unixepoch') FROM vfile WHERE
>> (pathname='scratch.txt' ) OR (pathname>'sc
>> f: SQL error: callback requested query abort
>
> Hmmm... the SQL is truncated in the error message. Can you please try again
> with the --sqltrace flag and paste the traced SQL here?
sure:
---
bash-4.3$ f ls --age --sqltrace scratch.txt
-- sqlite3_open: [/home/michai/proj/068/.fslckout]
PRAGMA foreign_keys=OFF;
SELECT sql FROM main.sqlite_master WHERE name=='vfile';
-- sqlite3_open: [/home/michai/.fossil]
PRAGMA foreign_keys=OFF;
SELECT value FROM vvar WHERE name='repository';
ATTACH DATABASE '/fossils/068.fossil' AS repository;
SELECT value FROM config WHERE name='allow-symlinks';
SELECT value FROM global_config WHERE name='allow-symlinks';
SELECT 1 FROM config WHERE name='aux-schema' AND value<>'2011-04-25 19:50';
SELECT value FROM vvar WHERE name='checkout';
SELECT value FROM config WHERE name='case-sensitive';
SELECT value FROM global_config WHERE name='case-sensitive';
SELECT value FROM config WHERE name='mtime-changes';
SELECT value FROM global_config WHERE name='mtime-changes';
BEGIN;
SELECT id, '/home/michai/proj/068/' || pathname, vfile.mrid,
deleted, chnged, uuid, size, mtime FROM vfile LEFT JOIN blob ON
vfile.mrid=blob.rid WHERE vid=4258 ;
COMMIT;
SELECT value FROM config WHERE name='timeline-utc';
SELECT value FROM global_config WHERE name='timeline-utc';
SELECT pathname, deleted, rid, chnged, coalesce(origname!=pathname,0),
datetime(checkin_mtime(4258,rid),'unixepoch') FROM vfile WHERE
(pathname='scratch.txt' ) OR (pathname>'scratch.txt/' AND
pathname<'scratch.txt0' ) ORDER BY pathname;
-- DROP TABLE IF EXISTS temp.ok;
-- CREATE TEMP TABLE ok(x INTEGER PRIMARY KEY);
-- WITH RECURSIVE ancestor(rid, mtime) AS ( SELECT 4258, mtime
FROM event WHERE objid=4258 UNION SELECT plink.pid,
event.mtime FROM ancestor, plink, event WHERE
plink.cid=ancestor.rid AND event.objid=plink.pid AND
plink.isPrim ORDER BY mtime DESC LIMIT 100000000 )INSERT INTO ok
SELECT rid FROM ancestor;
-- SELECT (max(event.mtime)-2440587.5)*86400 FROM mlink, event WHERE
mlink.mid=event.objid AND +mlink.mid IN ok AND mlink.fid=:fid;
SQLITE_ABORT: statement aborts at 15: [SELECT pathname, deleted, rid,
chnged, coalesce(origname!=pathname,0),
datetime(checkin_mtime(4258,rid),'unixepoch') FROM vfile WHERE
(pathname='scratch.txt' ) OR (pathname>'sc
f: SQL error: callback requested query abort
If you have recently updated your fossil executable, you might
need to run "fossil all rebuild" to bring the repository
schemas up to date.
-- LOOKASIDE_USED 11 180
-- LOOKASIDE_HIT 815
-- LOOKASIDE_MISS_SIZE 206
-- LOOKASIDE_MISS_FULL 0
-- CACHE_USED 2060136
-- SCHEMA_USED 20336
-- STMT_USED 0
-- MEMORY_USED 2253816 2309592
-- MALLOC_SIZE 64000
-- MALLOC_COUNT 2425 2488
-- PCACHE_OVFLOW 2086640 2119984
-- prepared statements 21
bash-4.3$ exit
---
For my info, is the '--sqltrace' flag documented somewhere..?
Michai
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
