DatabaseError at /account/login/

[nogi]

Arrrrghhhh, things seem to be getting worse for me. Another day, another error. I can't get into the web gui anymore. I noticed that on the console I was getting python error relating to /data: filesystem full which is odd is my RAIDZ vol has >1TB free. As I couldn't get into the GUI I rebooted the server via CLI and tried again. This is what greets me now:

Code:

DatabaseError at /account/login/
database or disk is full
Request Method:	POST
Request URL:	http://192.168.1.201/account/login/
Django Version:	1.3.1
Exception Type:	DatabaseError
Exception Value:	
database or disk is full
Exception Location:	/usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py in execute, line 234
Python Executable:	/usr/local/bin/python
Python Version:	2.7.2
Python Path:	
['/usr/local/www/freenasUI',
 '/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg',
 '/usr/local/lib/python2.7/site-packages/South-0.7.3-py2.7.egg',
 '/usr/local/lib/python2.7/site-packages/pyasn1-0.0.13b-py2.7.egg',
 '/usr/local/lib/python2.7/site-packages/pyasn1_modules-0.0.1a-py2.7.egg',
 '/usr/local/lib/python2.7/site-packages/flup-1.0.2-py2.7.egg',
 '/usr/local/lib/python2.7/site-packages/python_ldap-2.4.1-py2.7-freebsd-8.2-STABLE-amd64.egg',
 '/usr/local/lib/python27.zip',
 '/usr/local/lib/python2.7',
 '/usr/local/lib/python2.7/plat-freebsd8',
 '/usr/local/lib/python2.7/lib-tk',
 '/usr/local/lib/python2.7/lib-old',
 '/usr/local/lib/python2.7/lib-dynload',
 '/usr/local/lib/python2.7/site-packages',
 '/usr/local/www',
 '/usr/local/www',
 '/usr/local/www/freenasUI']
Server time:	Wed, 2 Nov 2011 17:21:30 +1000

 

[ProtoSD]

/data is on your flash drive. Can you get to the command line at the console? If you can, copy /data/freenas-v1.db to your raidz, then look in /data and see if you can figure out which files have grown or multiplied. You'll probably have to reflash if you can't clean that out, but if you have to reflash you can copy the database back to /data and reboot and it should restore your settings. If you can identify the files that are filling up /data you should be able to figure out the cause.

 

[nogi]

I'm guessing those 3 last ones shouldn't be there?

Code:

[nogi@KANDOR] /data# ll
total 20247
drwxr-xr-x   5 www   www            512 Nov  2 17:34 ./
drwxr-xr-x  20 root  wheel          512 Oct 14 06:47 ../
drwxrwxr-x   2 root  operator       512 Oct 14 06:48 .snap/
-rw-r--r--   1 www   www         158720 Nov  1 18:35 factory-v1.db
-rw-r--r--   1 www   www         175104 Nov  1 23:30 freenas-v1.db
-rw-r--r--   1 root  www         175104 Nov  1 18:39 freenas-v1.db.bak
-rw-r--r--   1 root  www         869557 Nov  2 17:00 rrd_dir.tar.bz2
drwxr-xr-x   2 root  www            512 Nov  1 18:35 ssh/
drwxr-xr-x   2 root  www            512 Nov  2 17:09 zfs/
-rw-------   1 root  www       13254656 Nov  1 18:35 ~$%#~000
-rw-------   1 root  www        6033912 Nov  1 18:35 ~$%#~001
-rw-------   1 root  www           4344 Nov  1 18:35 ~$%#~002
[nogi@KANDOR] /data# 

 

[ProtoSD]

yeah, get rid of those and the rrd_dir.tar.bz2

 

[jgreco]

Hey look, FreeNAS is swearing at you

 

[nogi]

Not as much as I am to it. My 2nd box is starting to do some funny things too now.

Code:

Nov  2 20:13:32 Krypton afpd[24085]: transmit: Request to dbd daemon (db_dir /mnt/KDATA) timed out.
Nov  2 20:13:32 Krypton afpd[24085]: Reopen volume /mnt/KDATA using in memory temporary CNID DB.
Nov  2 20:14:46 Krypton ntpd[2597]: sendto(2402:d800:0:1::11) (fd=22): No route to host

 

[gcooper]

Not as much as I am to it. My 2nd box is starting to do some funny things too now.

Code:

Nov  2 20:13:32 Krypton afpd[24085]: transmit: Request to dbd daemon (db_dir /mnt/KDATA) timed out.
Nov  2 20:13:32 Krypton afpd[24085]: Reopen volume /mnt/KDATA using in memory temporary CNID DB.
Nov  2 20:14:46 Krypton ntpd[2597]: sendto(2402:d800:0:1::11) (fd=22): No route to host

The CNID DB error is a permissions issue with afpd trying to access/create the Apple Double (foo -> ._foo) files it uses to store extended attributes on remote hosts.

- Is your FreeNAS device setup to talk on IPv6?
- Is afpd listening on IPv6?

I've identified some IPv4 based assumptions in the code that need to be fixed, but IPv6 is assumed to work (FWIW)...

 

[nogi]

- Is your FreeNAS device setup to talk on IPv6?
- Is afpd listening on IPv6?

It was but I have since turned it off as I don't use IPv6 at home. Will monitor the error.