[SAC] GDAL trac reports "DatabaseError: database is full"

When attempting to login to GDAL trac, I get:

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 387, in
dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 237, in
dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/trac/web/auth.py", line 100, in
process_request
    self._do_login(req)
  File "/usr/lib/python2.3/site-packages/trac/web/auth.py", line 139, in
_do_login
    "VALUES (%s, %s, %s, %s)", (cookie, remote_user,
  File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 50, in
execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 237, in
execute
    self.con._begin()
  File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 503, in
_begin
    self.db.execute("BEGIN")
DatabaseError: database is full

Regards,
--
Christopher Schmidt
MetaCarta

I cleared up a little space, in my home folder, not too much. But was enough to get mysql restarted and Drupal back up. Thanks for pinging about this problem Chris. The trouble brings us back to this old issue:
http://trac.osgeo.org/osgeo/ticket/126

On the 6th, /var/lib/mysql *.bin files started stacking up again, often twice per hour at 1GB+. Not sure what changed.

Tyler

On 8-Dec-07, at 6:52 PM, Christopher Schmidt wrote:

When attempting to login to GDAL trac, I get:

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 387, in
dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 237, in
dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/trac/web/auth.py", line 100, in
process_request
    self._do_login(req)
  File "/usr/lib/python2.3/site-packages/trac/web/auth.py", line 139, in
_do_login
    "VALUES (%s, %s, %s, %s)", (cookie, remote_user,
  File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 50, in
execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 237, in
execute
    self.con._begin()
  File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 503, in
_begin
    self.db.execute("BEGIN")
DatabaseError: database is full

Regards,
--
Christopher Schmidt
MetaCarta
_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

Tyler Mitchell
Executive Director
Open Source Geospatial Foundation
tmitchell@osgeo.org
P: +1-250-277-1621
M: +1-250-303-1831

On 09.12.2007 07:28, Tyler Mitchell (OSGeo) wrote:

I cleared up a little space, in my home folder, not too much. But was
enough to get mysql restarted and Drupal back up. Thanks for pinging
about this problem Chris. The trouble brings us back to this old issue:
http://trac.osgeo.org/osgeo/ticket/126

On the 6th, /var/lib/mysql *.bin files started stacking up again, often
twice per hour at 1GB+. Not sure what changed.

What changed is that we have 4 new databases for Drupal. IOW
odgeo_drupal osgeo_fdo osgeo_mapguide and osgeo_mapbender should be
duped and mothballed, and then deleted from mysql. The new databases are
called drupal_osgeo, drupal_fdo, drupal_mapguide and drupal_mapbender.

Also I changed the drupal cron job to run on all four sites once per
hour (it might create some additional stuff like search indexes etc, but
should not be such a biggie)

--Wolf

Tyler

On 8-Dec-07, at 6:52 PM, Christopher Schmidt wrote:

When attempting to login to GDAL trac, I get:

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 387, in
dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 237, in
dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/trac/web/auth.py", line 100, in
process_request
    self._do_login(req)
  File "/usr/lib/python2.3/site-packages/trac/web/auth.py", line 139, in
_do_login
    "VALUES (%s, %s, %s, %s)", (cookie, remote_user,
  File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 50, in
execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 237, in
execute
    self.con._begin()
  File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 503, in
_begin
    self.db.execute("BEGIN")
DatabaseError: database is full

Regards,
--
Christopher Schmidt
MetaCarta
_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

Tyler Mitchell
Executive Director
Open Source Geospatial Foundation
tmitchell@osgeo.org
P: +1-250-277-1621
M: +1-250-303-1831

_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac

--

<:3 )---- Wolf Bergenheim ----( 8:>