On Tue, 15 Jun 2010 08:22:47 +0200 Arnt Gulbrandsen <[email protected]> wrote:
> On 06/15/2010 08:11 AM, Mike Pontillo wrote: >> Sorry to resurrect such an old post, but I was trying to figure out >> what happened with this bug. > > It was a true bug and I fixed it; the fix I chose was rather large, so > please wait for 3.1.4 (a few weeks). I am also having problems creating views: $ aox show build Archiveopteryx version 3.1.4, http://archiveopteryx.org/3.1.4 Built on Mar 12 2013 14:10:54 Jamsettings: CONFIGDIR = /usr/local/archiveopteryx PIDFILEDIR = /usr/local/archiveopteryx/lib/pidfiles BINDIR = /usr/local/archiveopteryx/bin SBINDIR = /usr/local/archiveopteryx/sbin MANDIR = /usr/local/archiveopteryx/man LIBDIR = /usr/local/archiveopteryx/lib INITDIR = /usr/local/archiveopteryx/lib AOXUSER = aox AOXGROUP = aox VERSION = 3.1.4 $ aox show cf log-level log-level = debug $ aox show cf logfile logfile = "/var/tmp/aox.log" $ aox list mailboxes /users/vv /users / /users/vv/Trash /users/vv/ulug /users/vv/INBOX $ aox -v -v -v -v add view /views/recent /users/vv/INBOX vv younger 30 aox: Using configuration file /usr/local/archiveopteryx/archiveopteryx.conf aox: Using configuration file /usr/local/archiveopteryx/aoxsuper.conf aox: Connecting to PostgreSQL server at 127.0.0.1:5432 (backend 1, fd 3, user aoxsuper) aox: Listening for database signal mailboxes_updated aox: Starting event loop aox: Connected: Database client 127.0.0.1:49464 connected to server 127.0.0.1:5432, on fd 3 (1 connections) aox: PostgreSQL server: SET IntervalStyle="postgres" aox: Postgres backend 1 has pid 15882 aox: Sent parse/execute for "listen "mailboxes_updated"" on backend 1 aox: Sent parse/execute for "select m.id, m.name, m.deleted, m.owner, m.uidnext, m.nextmodseq, m.uidvalidity, v.nextmodseq as viewnms, v.selector, v.view, v.source from mailboxes m left join views v on (m.id=v.view) " on backend 1 aox: Dequeueing query "listen "mailboxes_updated"" on backend 1 aox: Dequeueing query "select m.id, m.name, m.deleted, m.owner, m.uidnext, m.nextmodseq, m.uidvalidity, v.nextmodseq as viewnms, v.selector, v.view, v.source from mailboxes m left join views v on (m.id=v.view) " on backend 1 (with 8 rows) aox: Sent parse/execute for "select u.id, u.login, u.secret, u.ldapdn, a.name, a.localpart, a.domain, u.quota, al.mailbox as inbox, n.name as parentspace from users u join namespaces n on (u.parentspace=n.id) left join aliases al on (u.alias=al.id) left join addresses a on (al.address=a.id) where lower(u.login)=lower($1)" ($1='vv') on backend 1 aox: Dequeueing query "select u.id, u.login, u.secret, u.ldapdn, a.name, a.localpart, a.domain, u.quota, al.mailbox as inbox, n.name as parentspace from users u join namespaces n on (u.parentspace=n.id) left join aliases al on (u.alias=al.id) left join addresses a on (al.address=a.id) where lower(u.login)=lower($1)" ($1='vv') on backend 1 (with 1 rows) aox: Using database connection 1 aox: Sent parse/execute for "begin" on backend 1 aox: Dequeueing query "begin" on backend 1 aox: Sent parse/execute for "insert into mailboxes (name,owner,uidnext,uidvalidity,deleted) values ($1,$2,1,1,'f')" ($1='/views/recent',$2='1') on backend 1 aox: Sent parse/execute for "notify mailboxes_updated" on backend 1 aox: Sent parse/execute for "insert into views (view, selector, source, nextmodseq) values ((select id from mailboxes where name=$1),$2, ((select id from mailboxes where name=$3), 1::bigint)" ($1='/views/recent',$2='(messagesmaller 30)',$3='/users/vv/INBOX') on backend 1 aox: Sent parse/execute for "commit" on backend 1 aox: Dequeueing query "insert into mailboxes (name,owner,uidnext,uidvalidity,deleted) values ($1,$2,1,1,'f')" ($1='/views/recent',$2='1') on backend 1 (with 1 rows) aox: Dequeueing query "notify mailboxes_updated" on backend 1 aox: Couldn't create view I find no clues about the cause of the error in the log file. Is there a difference between 'create view' and 'add view'? What am i doing wrong? - Vegard V -
