Delete a target platfor cause a database exception

[Miniwark]

How to reproduce :

• Go into a recipe
• Try to delete the platform

Same error occur when i try to directly delete a recipe

While doing a POST operation on /admin/bitten/configs/toremove, Trac issued an internal error.

Request parameters:

{'__EDITOR__1': u'textarea',
 '__FORM_TOKEN': u'6c73e1f11a53d2a4e5253f35',
 'cat_id': u'bitten',
 'description': u'',
 'label': u'toremove',
 'max_rev': u'',
 'min_rev': u'',
 'name': u'toremove',
 'panel_id': u'configs',
 'path': u'/',
 'path_info': u'toremove',
 'recipe': u'',
 'remove': u'Delete selected platforms',
 'sel': u'4'}

User Agent was: Mozilla/5.0 (X11; U; Linux x86_64; fr; rv:1.9.0.11) Gecko/2009060200 SUSE/3.0.11-0.1.1 Firefox/3.0.11

System Information

Trac	0.11.5rc1
Python	2.5 (r25:51908, Nov 27 2006, 19:28:51) [GCC 4.1.2 20061115 (prerelease) (SUSE Linux)]
setuptools	0.6c9
SQLite	3.3.8
pysqlite	2.3.2
Genshi	0.5.1
mod_python	3.2.10
Pygments	0.6
Bitten	0.6dev-r649
Subversion	1.4.0 (r21228)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib64/python2.5/site-packages/Trac-0.11.5rc1-py2.5.egg/trac/web/main.py", line 444, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib64/python2.5/site-packages/Trac-0.11.5rc1-py2.5.egg/trac/web/main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib64/python2.5/site-packages/Trac-0.11.5rc1-py2.5.egg/trac/admin/web_ui.py", line 114, in process_request
    path_info)
  File "/usr/local/lib64/python2.5/site-packages/Bitten-0.6dev_r649-py2.5.egg/bitten/admin.py", line 159, in render_admin_panel
    self._remove_platforms(req)
  File "/usr/local/lib64/python2.5/site-packages/Bitten-0.6dev_r649-py2.5.egg/bitten/admin.py", line 322, in _remove_platforms
    platform.delete(db=db)
  File "/usr/local/lib64/python2.5/site-packages/Bitten-0.6dev_r649-py2.5.egg/bitten/model.py", line 223, in delete
    build.delete()
  File "/usr/local/lib64/python2.5/site-packages/Bitten-0.6dev_r649-py2.5.egg/bitten/model.py", line 405, in delete
    db.commit()
OperationalError: SQL logic error or missing database

[osimons]

I can't replicate this. I can delete platforms and recipes without issues.

Looking at ​trac:ticket:6348, I feel there is some underlying issue here not directly related to Bitten itself.. Could you please:

• Look for duplicaes in the relevant db table
• Make sure you are running the SQLite database off a local filesystem, and not via a share
• Try updating SQLite and PySqlite bindings to a recent version

Please report back.

[Miniwark]

Hi !

I actualy i cannot reproduce this issue, because i have manualy remove all bitten records in the database to avoid it. Since then i did not have this problem anymore.

Some facts :

• The database is in the filesystem and is not a shared one
• I think than maybe this error was probably related to a duplicate database entry. At one time i have created two target platforms for a recipe and one was deleted.

[osimons]

As we don't seem to be able to reproduce it or otherwise know more about the 'how' & 'why' of the problem, I'm closing as worksforme. Please reopen if issue appears again.