The proposal to merge lp:~zeitgeist/zeitgeist/pragma-settings into lp:zeitgeist
has been updated.
Status: Needs review = Merged
--
https://code.launchpad.net/~zeitgeist/zeitgeist/pragma-settings/+merge/35833
Your team Zeitgeist Framework Team is subscribed to branch
Hello Zeitgeist Framework Team,
On 2010-09-19 08:54z (2 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.1 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
Hello Zeitgeist Framework Team,
On 2010-09-19 08:54z (2 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.3 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
Public bug reported:
If we add subj_uri_id and subj_origin_id columns to the event_view we
could make the prefix searches about 10% faster. Combined with the
upcoming optimization of the GLOB statement it will be possible to
reduce the avg. time for this kind of queries from ~0.20s to ~0.12s.
As
** Attachment added: test_new_event_view.py
https://bugs.edge.launchpad.net/bugs/642686/+attachment/1607450/+files/test_new_event_view.py
--
Add subj_uri_id and subj_origin_id columns to event_view
https://bugs.launchpad.net/bugs/642686
You received this bug notification because you are a
** Changed in: zeitgeist
Importance: Undecided = Wishlist
** Changed in: zeitgeist
Assignee: (unassigned) = Markus Korn (thekorn)
** Changed in: zeitgeist
Assignee: Markus Korn (thekorn) = (unassigned)
--
Add subj_uri_id and subj_origin_id columns to event_view
** Changed in: zeitgeist
Assignee: (unassigned) = Markus Korn (thekorn)
** Changed in: zeitgeist
Status: New = In Progress
--
Add subj_uri_id and subj_origin_id columns to event_view
https://bugs.launchpad.net/bugs/642686
You received this bug notification because you are a member
Markus Korn has proposed merging
lp:~thekorn/zeitgeist/fix-642686-eventview-add-origin-and-uri-id into
lp:zeitgeist.
Requested reviews:
Zeitgeist Framework Team (zeitgeist)
Related bugs:
#642686 Add subj_uri_id and subj_origin_id columns to event_view
Hello Zeitgeist Framework Team,
On 2010-09-19 11:09z (31 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.1 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
Hello Zeitgeist Framework Team,
On 2010-09-19 11:09z (31 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.3 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
** Branch linked: lp:zeitgeist
--
Add subj_uri_id and subj_origin_id columns to event_view
https://bugs.launchpad.net/bugs/642686
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status in Zeitgeist Framework:
Hello Zeitgeist Framework Team,
On 2010-09-19 11:48z (just requested), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.1 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
** Changed in: zeitgeist
Status: In Progress = Fix Committed
--
Add subj_uri_id and subj_origin_id columns to event_view
https://bugs.launchpad.net/bugs/642686
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist
Public bug reported:
The recently merged changes to use journal_mode=WAL and adding some
columns to event_view requires schema upgrades.
1) Setting WAL journalling *permanently* makes the DB unreadable with
sqlite 3.6 which is still widely deployed. Notably if I boot back into
Ubuntu Lucid Lynx
2010/9/19 Mikkel Kamstrup Erlandsen mikkel.kamst...@gmail.com:
2) Contrary to what is stated in the merge request for the event_view
changes the event_view VIEW is *not* regenerated on each startup.
Actually they do, create_db() is executed every time at startup and it
has a DROP VIEW.
--
Public bug reported:
As stateted by Mikkel in bug 642772 the event_view is broken for `old`
databases
Traceback:
DBusException: org.freedesktop.DBus.Python.sqlite3.OperationalError: Traceback
(most recent call last):
File /usr/lib/pymodules/python2.6/dbus/service.py, line 702, in _message_cb
Hi Mikkel,
I'm sorry, number two on your list is definitely my bad. I did not know that
this DROP VIEW [...] line has no effect, and I also did not test my changes
on an already existing database. My changes are indeed not working as I expect
them to work.
I'll work on fixing the issue in bug
Hmmm I can't really figure out a good fix for this:
1) We revert the WAL change :(
2) We create a translation script that copies the DB content 1-to-1 in a new
db file in case something below sqlite 3.7 is used
On Sun, Sep 19, 2010 at 3:48 PM, Markus Korn thek...@gmx.de wrote:
Hi Mikkel,
2010/9/19 Siegfried Gevatter rai...@ubuntu.com:
Actually they do, create_db() is executed every time at startup and it
has a DROP VIEW.
Err, scratch that.
--
WAL and event_view changes requires schema upgrade
https://bugs.launchpad.net/bugs/642772
You received this bug notification because you
Hello Zeitgeist Framework Team,
On 2010-09-19 14:26z (1 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.5 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
** Branch linked: lp:zeitgeist
--
Today's updates to lp:zeitgeist broke event_view
https://bugs.launchpad.net/bugs/642803
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status in Zeitgeist Framework: In
I found the following statement in http://www.sqlite.org/wal.html under
Backwards Compatibility
One can explicitly change out of WAL mode using a pragma such as this:
PRAGMA journal_mode=DELETE;
Deliberately changing out of WAL mode changes the database file format
version numbers back to 1 so
** Branch linked: lp:~zeitgeist/zeitgeist/fix-642772
--
WAL and event_view changes requires schema upgrade
https://bugs.launchpad.net/bugs/642772
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
Status in
** Changed in: zeitgeist
Status: In Progress = Fix Committed
--
Today's updates to lp:zeitgeist broke event_view
https://bugs.launchpad.net/bugs/642803
You received this bug notification because you are a member of Zeitgeist
Framework Team, which is subscribed to Zeitgeist Framework.
from what I understand people with who dual boot are confronted with this
issue right?
On Sun, Sep 19, 2010 at 4:22 PM, Launchpad Bug Tracker
642...@bugs.launchpad.net wrote:
** Branch linked: lp:~zeitgeist/zeitgeist/fix-642772
--
WAL and event_view changes requires schema upgrade
There are two possible solutions for this issue:
1.) check if we are operating on an empty database
2.) change our upgrade function in a way that if a upgrade script is not found
for X - Z it tries to run X - Y - Z
For 1.) there are two possible ways:
1.a.) check if file already exists before
+1 for 1.a)
___
Mailing list: https://launchpad.net/~zeitgeist
Post to : zeitgeist@lists.launchpad.net
Unsubscribe : https://launchpad.net/~zeitgeist
More help : https://help.launchpad.net/ListHelp
Hello Zeitgeist Framework Team,
On 2010-09-20 05:49z (2 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.1 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
Hello Zeitgeist Framework Team,
On 2010-09-20 05:49z (2 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.3 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
Hello Zeitgeist Framework Team,
On 2010-09-20 05:49z (2 minutes ago), you uploaded a translation
template for zeitgeist in Zeitgeist Framework 0.5 in Launchpad.
The template has now been imported successfully.
Thank you,
The Launchpad team
___
30 matches
Mail list logo
