FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » database or disk is full: HY000
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
database or disk is full: HY000 [message #165369] Thu, 09 June 2011 10:03 Go to next message
tux99   Switzerland
Messages: 44
Registered: September 2010
Karma: 0
Member
Since I updated the Centos server (5.6) with the latest patches (yum update) and then rebooted the server I'm getting the following error from fudforum (3.0.1) each time an email from a ML arrives to be inserted into the forum:
Jun  5 07:26:28 london1 logger: (/var/www/fud-mageia/include/theme/default/db.inc:202<br />
Jun  5 07:26:28 london1 logger: /var/www/fud-mageia/include/theme/default/isearch.inc:70<br />
Jun  5 07:26:28 london1 logger: /var/www/fud-mageia/include/theme/default/imsg_edt.inc:441<br />
Jun  5 07:26:28 london1 logger: /var/www/fud-mageia/scripts/maillist.php:558<br />
Jun  5 07:26:28 london1 logger: ) database or disk is full: HY000<br />
Jun  5 07:26:28 london1 logger: Query: INSERT INTO fud30_index (word_id, msg_id) SELECT id, 12840 FROM fud
30_search WHERE word IN('Ahmad','Samir','écrit','June','wrote','Anssi','Hannula','Currently','our','flash-p
layer-plugin','pkg','only','built','bit','the','adobe','build','still','horribly','out','date','However','
this','problematic','for','users','installing','cumbersome','nonfree32','media','not','added','and','addin
g','would','very','nice','list','already','way','too','cluttered','One','option','x86','package','that','a
ctually','contains','flash','player','note','description','with','dependency','nspluginwrapper','When','pr
oper','released','replaced','suggests','think','I''ve','never','seen','work','might','box','setup','though
','Usually','install','plugin','either','use','browser','konqueror','which','uses','KDE4','wrapper','watch
','content','you','should','done','add','much','confusion','Sorry','hit','Send','fast','Not','but','it''s'
,'hackish','skeleton','will','download','rpm','closed-source','binary','blob','have','just','instal
Jun  5 07:26:28 london1 logger: led','Mageia','Flash','quite','painless','from','Adobe','site','Cheers','M
arc')<br />
Jun  5 07:26:28 london1 logger: Server Version: 3.3.6<br />


Obviously the data is always different but the error is always the same.

The disk is defnitely not full:
# df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/xvda 15997904 992064 14355724 7% /

And I don't use a real database, only sqlite.

I didn't do any fudforum related changes.

Can someone please suggest what I need to do to fix this?

Many thanks in advance.

[Updated on: Thu, 09 June 2011 10:14]

Report message to a moderator

Re: database or disk is full: HY000 [message #165370 is a reply to message #165369] Thu, 09 June 2011 10:26 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
The DB is reporting that it is out of space. Please check your MySQL logs for details.

Best of luck!

Frank

Re: database or disk is full: HY000 [message #165371 is a reply to message #165370] Thu, 09 June 2011 10:32 Go to previous messageGo to next message
tux99   Switzerland
Messages: 44
Registered: September 2010
Karma: 0
Member
I use SQlite not Mysql, AFAIK there are no SQlite logs?
(other than the ones in /var/log/messages I have posted above)

[Updated on: Thu, 09 June 2011 10:36]

Report message to a moderator

Re: database or disk is full: HY000 [message #165373 is a reply to message #165371] Thu, 09 June 2011 10:41 Go to previous messageGo to next message
tux99   Switzerland
Messages: 44
Registered: September 2010
Karma: 0
Member
The sqlite db file used by fudforum is currently 50MB large, is there a size limit when using sqlite?

# ls -la forum.db.php
-rw-rw---- 1 apache apache 51643392 Jun 9 16:04 forum.db.php
Re: database or disk is full: HY000 [message #165375 is a reply to message #165373] Thu, 09 June 2011 15:54 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Please run the following statement from the SQL Manager and post the output here:
pragma integrity_check;

Re: database or disk is full: HY000 [message #165376 is a reply to message #165375] Thu, 09 June 2011 16:05 Go to previous messageGo to next message
tux99   Switzerland
Messages: 44
Registered: September 2010
Karma: 0
Member
Ok, here it is:
*** in database main *** On tree page 49195 cell 0: invalid page number 1715282537 On tree page 49195 cell 3: invalid page number 1715282537 Fragmented space is 308 byte reported as 0 on page 49195 On tree page 33333 cell 0: 2nd reference to page 48902 On tree page 33333 cell 1: Child page depth differs On tree page 57 cell 17: Child page depth differs On tree page 50340 cell 55: 2nd reference to page 34978 On tree page 50340 cell 55: Child page depth differs On tree page 50340 cell 56: Child page depth differs On tree page 50305 cell 72: 2nd reference to page 47474 On tree page 50305 cell 72: Child page depth differs On tree page 50305 cell 73: 2nd reference to page 47530 On tree page 50305 cell 74: Child page depth differs On tree page 50295 cell 2: 2nd reference to page 35351 On tree page 50295 cell 2: Child page depth differs On tree page 50295 cell 3: Child page depth differs On tree page 50295 cell 54: 2nd reference to page 38499 On tree page 50295 cell 54: Child page depth differs On tree page 50295 cell 55: Child page depth differs On tree page 50295 cell 59: 2nd reference to page 49195 On tree page 50295 cell 59: Child page depth differs On tree page 50295 cell 60: Child page depth differs On tree page 50371 cell 18: 2nd reference to page 47217 On tree page 50371 cell 18: Child page depth differs On tree page 50371 cell 19: Child page depth differs On tree page 50371 cell 56: 2nd reference to page 47256 On tree page 50371 cell 56: Child page depth differs On tree page 50371 cell 57: Child page depth differs On tree page 50371 cell 77: 2nd reference to page 43143 On tree page 50371 cell 77: Child page depth differs On tree page 50371 cell 78: Child page depth differs Page 35832 is never used Page 36296 is never used Page 36849 is never used Page 36878 is never used Page 37312 is never used Page 37495 is never used Page 37772 is never used Page 38135 is never used Page 38390 is never used Page 39008 is never used Page 39082 is never used Page 39177 is never used Page 39419 is never used Page 39607 is never used Page 39940 is never used Page 40015 is never used Page 40159 is never used Page 40306 is never used Page 40472 is never used Page 41562 is never used Page 41597 is never used Page 42652 is never used Page 43200 is never used Page 43205 is never used Page 43218 is never used Page 43248 is never used Page 43256 is never used Page 43471 is never used Page 43733 is never used Page 43763 is never used Page 43765 is never used Page 43776 is never used Page 43843 is never used Page 43905 is never used Page 43910 is never used Page 43995 is never used Page 44076 is never used Page 44145 is never used Page 44305 is never used Page 44618 is never used Page 44947 is never used Page 45100 is never used Page 45127 is never used Page 45136 is never used Page 45190 is never used Page 45224 is never used Page 45309 is never used Page 45435 is never used Page 45580 is never used Page 45622 is never used Page 45734 is never used Page 45736 is never used Page 45787 is never used Page 45887 is never used Page 46095 is never used Page 46193 is never used Page 46306 is never used Page 46318 is never used Page 46421 is never used Page 47090 is never used Page 47251 is never used Page 47269 is never used Page 47306 is never used Page 47327 is never used Page 47350 is never used Page 47391 is never used Page 47402 is never used Page 47418 is never used Page 47432 is never used Page 47487 is never used Page 47563 is never used Page 47588 is never used Page 47653 is never used Page 47668 is never used Page 47688 is never used Page 47711 is never used Page 47730 is never used Page 47755 is never used Page 47837 is never used Page 48000 is never used Page 48027 is never used Page 48047 is never used Page 48122 is never used Page 48165 is never used Page 48299 is never used Page 48345 is never used Page 48375 is never used Page 48428 is never used Page 48463 is never used Page 48539 is never used Page 48548 is never used Page 48574 is never used Page 48605 is never used Page 48652 is never used Page 48775 is never used
rowid 301454 missing from index fud30_ses_i_u
rowid 301454 missing from index fud30_ses_i_s
rowid 301454 missing from index fud30_ses_i_tu
rowid 301455 missing from index fud30_ses_i_u
rowid 301455 missing from index fud30_ses_i_s
rowid 301455 missing from index fud30_ses_i_tu
rowid 302595 missing from index fud30_ses_i_u
rowid 302595 missing from index fud30_ses_i_s
rowid 302595 missing from index fud30_ses_i_tu
rowid 302697 missing from index fud30_ses_i_u
rowid 302697 missing from index fud30_ses_i_s
rowid 302697 missing from index fud30_ses_i_tu
rowid 302884 missing from index fud30_ses_i_u
rowid 302884 missing from index fud30_ses_i_s
rowid 302884 missing from index fud30_ses_i_tu
rowid 255 missing from index fud30_ses_i_u
rowid 255 missing from index fud30_ses_i_s
rowid 255 missing from index fud30_ses_i_tu
rowid 181 missing from index fud30_ses_i_u
rowid 181 missing from index fud30_ses_i_s
rowid 181 missing from index fud30_ses_i_tu
rowid 216 missing from index fud30_ses_i_u
rowid 216 missing from index fud30_ses_i_s
rowid 216 missing from index fud30_ses_i_tu
rowid 255 missing from index fud30_ses_i_u
rowid 255 missing from index fud30_ses_i_s
rowid 255 missing from index fud30_ses_i_tu
rowid 303136 missing from index fud30_ses_i_u
rowid 303136 missing from index fud30_ses_i_s
rowid 303136 missing from index fud30_ses_i_tu
rowid 303359 missing from index fud30_ses_i_u
rowid 303359 missing from index fud30_ses_i_s
rowid 303359 missing from index fud30_ses_i_tu
wrong # of entries in index fud30_ses_i_u
wrong # of entries in index fud30_ses_i_s
wrong # of entries in index fud30_ses_i_tu
rowid 224 missing from index fud30_msg_i_ip
rowid 231 missing from index fud30_msg_i_ip
rowid 235 missing from index fud30_msg_i_ip
rowid 238 missing from index fud30_msg_i_ip
rowid 251 missing from index fud30_msg_i_ip
rowid 256 missing from index fud30_msg_i_ip
rowid 259 missing from index fud30_msg_i_ip
rowid 262 missing from index fud30_msg_i_ip
rowid 263 missing from index fud30_msg_i_ip
rowid 264 missing from index fud30_msg_i_ip
rowid 265 missing from index fud30_msg_i_ip
rowid 269 missing from index fud30_msg_i_ip
rowid 277 missing from index fud30_msg_i_ip
rowid 381 missing from index fud30_msg_i_ip
rowid 391 missing from index fud30_msg_i_ip
rowid 395 missing from index fud30_msg_i_ip
rowid 399 missing from index fud30_msg_i_ip
rowid 408 missing from index fud30_msg_i_ip
rowid 449 missing from index fud30_msg_i_ip
rowid 451 missing from index fud30_msg_i_ip
rowid 468 missing from index fud30_msg_i_ip
rowid 302595 missing from index fud30_msg_i_s
rowid 302595 missing from index fud30_msg_i_mmi
rowid 302595 missing from index fud30_msg_i_ip
rowid 302595 missing from index fud30_msg_i_pi
rowid 302595 missing from index fud30_msg_i_ac
rowid 302595 missing from index fud30_msg_i_a
rowid 302595 missing from index fud30_msg_i_pa
rowid 302595 missing from index fud30_msg_i_ps
rowid 302595 missing from index fud30_msg_i_ta
rowid 302596 missing from index fud30_msg_i_s
rowid 302596 missing from index fud30_msg_i_mmi
rowid 302596 missing from index fud30_msg_i_ip
rowid 302596 missing from index fud30_msg_i_pi
rowid 302596 missing from index fud30_msg_i_ac
rowid 302596 missing from index fud30_msg_i_a
rowid 302596 missing from index fud30_msg_i_pa
rowid 302596 missing from index fud30_msg_i_ps
rowid 302596 missing from index fud30_msg_i_ta
rowid 302597 missing from index fud30_msg_i_s
rowid 302597 missing from index fud30_msg_i_mmi
rowid 302597 missing from index fud30_msg_i_ip
rowid 302597 missing from index fud30_msg_i_pi
rowid 302597 missing from index fud30_msg_i_ac
rowid 302597 missing from index fud30_msg_i_a
rowid 302597 missing from index fud30_msg_i_pa
rowid 302597 missing from index fud30_msg_i_ps
rowid 302597 missing from index fud30_msg_i_ta
rowid 302598 missing from index fud30_msg_i_s
rowid 302598 missing from index fud30_msg_i_mmi
rowid 302598 missing from index fud30_msg_i_ip
rowid 302598 missing from index fud30_msg_i_pi
rowid 302598 missing from index fud30_msg_i_ac
rowid 302598 missing from index fud30_msg_i_a
rowid 302598 missing from index fud30_msg_i_pa
rowid 302598 missing from index fud30_msg_i_ps
rowid 302598 missing from index fud30_msg_i_ta
rowid 12893 missing from index fud30_msg_i_mmi
rowid 12910 missing from index fud30_msg_i_mmi
rowid 12912 missing from index fud30_msg_i_mmi
rowid 12918 missing from index fud30_msg_i_mmi
rowid 12919 missing from index fud30_msg_i_mmi
rowid 12920 missing from index fud30_msg_i_mmi
rowid 12921 missing from index fud30_msg_i_mmi
rowid 12937 missing from index fud30_msg_i_mmi
rowid 12944 missing from index fud30_msg_i_ip
rowid 12944 missing from index fud30_msg_i_pi
rowid 12944 missing from index fud30_msg_i_ac
rowid 12944 missing from index fud30_msg_i_a
rowid 12944 missing from index fud30_msg_i_pa
rowid 12944 missing from index fud30_msg_i_ps
rowid 12944 missing from index fud30_msg_i_ta
rowid 12945 missing from index fud30_msg_i_mmi
rowid 12945 missing from index fud30_msg_i_ip
rowid 12945 missing from index fud30_msg_i_pi
rowid 12945 missing from index fud30_msg_i_ac
rowid 12945 missing from index fud30_msg_i_a
rowid 12945 missing from index fud30_msg_i_pa
rowid 12945 missing from index fud30_msg_i_ps
rowid 12945 missing from index fud30_msg_i_ta
rowid 12946 missing from index fud30_msg_i_mmi
rowid 12946 missing from index fud30_msg_i_ip
rowid 12946 missing from index fud30_msg_i_pi
rowid 12946 missing from index fud30_msg_i_ac
rowid 12946 missing from index fud30_msg_i_a
rowid 12946 missing from index fud30_msg_i_pa
rowid 12946 missing from index fud30_msg_i_ps
rowid 12946 missing from index fud30_msg_i_ta
rowid 12947 missing from index fud30_msg_i_mmi
rowid 12947 missing from index fud30_msg_i_ip
rowid 12947 missing from index fud30_msg_i_pi
rowid 12947 missing from index fud30_msg_i_ac
rowid 12947 missing from index fud30_msg_i_a
rowid 12947 missing from index fud30_msg_i_pa
rowid 12947 missing from index fud30_msg_i_ps
rowid 12947 missing from index fud30_msg_i_ta
rowid 12948 missing from index fud30_msg_i_mmi
rowid 12948 missing from index fud30_msg_i_ip
rowid 12948 missing from index fud30_msg_i_pi
rowid 12948 missing from index fud30_msg_i_ac
rowid 12948 missing from index fud30_msg_i_a
rowid 12948 missing from index fud30_msg_i_pa
rowid 12948 missing from index fud30_msg_i_ps
rowid 12948 missing from index fud30_msg_i_ta
rowid 301451 missing from index fud30_msg_i_s
rowid 301451 missing from index fud30_msg_i_mmi
rowid 301451 missing from index fud30_msg_i_ip
rowid 301451 missing from index fud30_msg_i_pi
rowid 301451 missing from index fud30_msg_i_ac
rowid 301451 missing from index fud30_msg_i_a
rowid 301451 missing from index fud30_msg_i_pa
rowid 301451 missing from index fud30_msg_i_ps
rowid 301451 missing from index fud30_msg_i_ta
rowid 301452 missing from index fud30_msg_i_s
rowid 301452 missing from index fud30_msg_i_mmi
rowid 301452 missing from index fud30_msg_i_ip
rowid 301452 missing from index fud30_msg_i_pi
rowid 301452 missing from index fud30_msg_i_ac
rowid 301452 missing from index fud30_msg_i_a
rowid 301452 missing from index fud30_msg_i_pa
rowid 301452 missing from index fud30_msg_i_ps
rowid 301452 missing from index fud30_msg_i_ta
rowid 301453 missing from index fud30_msg_i_s
rowid 301453 missing from index fud30_msg_i_mmi
rowid 301453 missing from index fud30_msg_i_ip
rowid 301453 missing from index fud30_msg_i_pi
rowid 301453 missing from index fud30_msg_i_ac
rowid 301453 missing from index fud30_msg_i_a
rowid 301453 missing from index fud30_msg_i_pa
rowid 301453 missing from index fud30_msg_i_ps
rowid 301453 missing from index fud30_msg_i_ta
rowid 301454 missing from index fud30_msg_i_mmi
rowid 301454 missing from index fud30_msg_i_pi
rowid 301454 missing from index fud30_msg_i_ac
rowid 301454 missing from index fud30_msg_i_a
rowid 301454 missing from index fud30_msg_i_pa
rowid 301454 missing from index fud30_msg_i_ps
rowid 301454 missing from index fud30_msg_i_ta
rowid 301455 missing from index fud30_msg_i_pi
rowid 301455 missing from index fud30_msg_i_ac
rowid 301455 missing from index fud30_msg_i_a
rowid 301455 missing from index fud30_msg_i_pa
rowid 301455 missing from index fud30_msg_i_ps
rowid 301455 missing from index fud30_msg_i_ta
rowid 302591 missing from index fud30_msg_i_s
rowid 302591 missing from index fud30_msg_i_mmi
rowid 302591 missing from index fud30_msg_i_ip
rowid 302591 missing from index fud30_msg_i_pi
rowid 302591 missing from index fud30_msg_i_ac
rowid 302591 missing from index fud30_msg_i_a
rowid 302591 missing from index fud30_msg_i_pa
rowid 302591 missing from index fud30_msg_i_ps
rowid 302591 missing from index fud30_msg_i_ta
rowid 302592 missing from index fud30_msg_i_s
rowid 302592 missing from index fud30_msg_i_mmi
rowid 302592 missing from index fud30_msg_i_ip
rowid 302592 missing from index fud30_msg_i_pi
rowid 302592 missing from index fud30_msg_i_ac
rowid 302592 missing from index fud30_msg_i_a
rowid 302592 missing from index fud30_msg_i_pa
rowid 302592 missing from index fud30_msg_i_ps
rowid 302592 missing from index fud30_msg_i_ta
rowid 302593 missing from index fud30_msg_i_s
rowid 302593 missing from index fud30_msg_i_mmi
rowid 302593 missing from index fud30_msg_i_ip
rowid 302593 missing from index fud30_msg_i_pi
rowid 302593 missing from index fud30_msg_i_ac
rowid 302593 missing from index fud30_msg_i_a
rowid 302593 missing from index fud30_msg_i_pa
rowid 302593 missing from index fud30_msg_i_ps
rowid 302593 missing from index fud30_msg_i_ta
rowid 302594 missing from index fud30_msg_i_s
rowid 302594 missing from index fud30_msg_i_mmi
rowid 302594 missing from index fud30_msg_i_ip
rowid 302594 missing from index fud30_msg_i_pi
rowid 302594 missing from index fud30_msg_i_ac
rowid 302594 missing from index fud30_msg_i_a
rowid 302594 missing from index fud30_msg_i_pa
rowid 302594 missing from index fud30_msg_i_ps
rowid 302594 missing from index fud30_msg_i_ta
rowid 302595 missing from index fud30_msg_i_mmi
rowid 302595 missing from index fud30_msg_i_pi
rowid 302595 missing from index fud30_msg_i_ac
rowid 302595 missing from index fud30_msg_i_a
rowid 302595 missing from index fud30_msg_i_pa
rowid 302595 missing from index fud30_msg_i_ps
rowid 302595 missing from index fud30_msg_i_ta
rowid 302694 missing from index fud30_msg_i_s
rowid 302694 missing from index fud30_msg_i_mmi
rowid 302694 missing from index fud30_msg_i_ip
rowid 302694 missing from index fud30_msg_i_pi
rowid 302694 missing from index fud30_msg_i_ac
rowid 302694 missing from index fud30_msg_i_a
rowid 302694 missing from index fud30_msg_i_pa
rowid 302694 missing from index fud30_msg_i_ps
rowid 302694 missing from index fud30_msg_i_ta
rowid 302695 missing from index fud30_msg_i_s
rowid 302695 missing from index fud30_msg_i_mmi
rowid 302695 missing from index fud30_msg_i_ip
rowid 302695 missing from index fud30_msg_i_pi
rowid 302695 missing from index fud30_msg_i_ac
rowid 302695 missing from index fud30_msg_i_a
rowid 302695 missing from index fud30_msg_i_pa
rowid 302695 missing from index fud30_msg_i_ps
rowid 302695 missing from index fud30_msg_i_ta
rowid 302696 missing from index fud30_msg_i_s
rowid 302696 missing from index fud30_msg_i_mmi
rowid 302696 missing from index fud30_msg_i_ip
rowid 302696 missing from index fud30_msg_i_pi
rowid 302696 missing from index fud30_msg_i_ac
rowid 302696 missing from index fud30_msg_i_a
rowid 302696 missing from index fud30_msg_i_pa
rowid 302696 missing from index fud30_msg_i_ps
rowid 302696 missing from index fud30_msg_i_ta
rowid 302697 missing from index fud30_msg_i_pi
rowid 302697 missing from index fud30_msg_i_ac
rowid 302697 missing from index fud30_msg_i_a
rowid 302697 missing from index fud30_msg_i_pa
rowid 302697 missing from index fud30_msg_i_ps
rowid 302697 missing from index fud30_msg_i_ta
rowid 302880 missing from index fud30_msg_i_s
rowid 302880 missing from index fud30_msg_i_mmi
rowid 302880 missing from index fud30_msg_i_ip
rowid 302880 missing from index fud30_msg_i_pi
rowid 302880 missing from index fud30_msg_i_ac
rowid 302880 missing from index fud30_msg_i_a
rowid 302880 missing from index fud30_msg_i_pa
rowid 302880 missing from index fud30_msg_i_ps
rowid 302880 missing from index fud30_msg_i_ta
rowid 302881 missing from index fud30_msg_i_s
rowid 302881 missing from index fud30_msg_i_mmi
rowid 302881 missing from index fud30_msg_i_ip
rowid 302881 missing from index fud30_msg_i_pi
rowid 302881 missing from index fud30_msg_i_ac
rowid 302881 missing from index fud30_msg_i_a
rowid 302881 missing from index fud30_msg_i_pa
rowid 302881 missing from index fud30_msg_i_ps
rowid 302881 missing from index fud30_msg_i_ta
rowid 302882 missing from index fud30_msg_i_s
rowid 302882 missing from index fud30_msg_i_mmi
rowid 302882 missing from index fud30_msg_i_ip
rowid 302882 missing from index fud30_msg_i_pi
rowid 302882 missing from index fud30_msg_i_ac
rowid 302882 missing from index fud30_msg_i_a
rowid 302882 missing from index fud30_msg_i_pa
rowid 302882 missing from index fud30_msg_i_ps
rowid 302882 missing from index fud30_msg_i_ta
rowid 302883 missing from index fud30_msg_i_s
rowid 302883 missing from index fud30_msg_i_mmi
rowid 302883 missing from index fud30_msg_i_ip
rowid 302883 missing from index fud30_msg_i_pi
rowid 302883 missing from index fud30_msg_i_ac
rowid 302883 missing from index fud30_msg_i_a
rowid 302883 missing from index fud30_msg_i_pa
rowid 302883 missing from index fud30_msg_i_ps
rowid 302883 missing from index fud30_msg_i_ta
rowid 302884 missing from index fud30_msg_i_pi
rowid 302884 missing from index fud30_msg_i_ac
rowid 302884 missing from index fud30_msg_i_a
rowid 302884 missing from index fud30_msg_i_pa
rowid 302884 missing from index fud30_msg_i_ps
rowid 302884 missing from index fud30_msg_i_ta
rowid 303133 missing from index fud30_msg_i_s
rowid 303133 missing from index fud30_msg_i_mmi
rowid 303133 missing from index fud30_msg_i_ip
rowid 303133 missing from index fud30_msg_i_pi
rowid 303133 missing from index fud30_msg_i_ac
rowid 303133 missing from index fud30_msg_i_a
rowid 303133 missing from index fud30_msg_i_pa
rowid 303133 missing from index fud30_msg_i_ps
rowid 303133 missing from index fud30_msg_i_ta
rowid 303134 missing from index fud30_msg_i_s
rowid 303134 missing from index fud30_msg_i_mmi
rowid 303134 missing from index fud30_msg_i_ip
rowid 303134 missing from index fud30_msg_i_pi
rowid 303134 missing from index fud30_msg_i_ac
rowid 303134 missing from index fud30_msg_i_a
rowid 303134 missing from index fud30_msg_i_pa
rowid 303134 missing from index fud30_msg_i_ps
rowid 303134 missing from index fud30_msg_i_ta
rowid 303135 missing from index fud30_msg_i_s
rowid 303135 missing from index fud30_msg_i_mmi
rowid 303135 missing from index fud30_msg_i_ip
rowid 303135 missing from index fud30_msg_i_pi
rowid 303135 missing from index fud30_msg_i_ac
rowid 303135 missing from index fud30_msg_i_a
rowid 303135 missing from index fud30_msg_i_pa
rowid 303135 missing from index fud30_msg_i_ps
rowid 303135 missing from index fud30_msg_i_ta
rowid 303136 missing from index fud30_msg_i_mmi
rowid 303136 missing from index fud30_msg_i_pi
rowid 303136 missing from index fud30_msg_i_ac
rowid 303136 missing from index fud30_msg_i_a
rowid 303136 missing from index fud30_msg_i_pa
rowid 303136 missing from index fud30_msg_i_ps
rowid 303136 missing from index fud30_msg_i_ta
rowid 303278 missing from index fud30_msg_i_s
rowid 303278 missing from index fud30_msg_i_mmi
rowid 303278 missing from index fud30_msg_i_ip
rowid 303278 missing from index fud30_msg_i_pi
rowid 303278 missing from index fud30_msg_i_ac
rowid 303278 missing from index fud30_msg_i_a
rowid 303278 missing from index fud30_msg_i_pa
rowid 303278 missing from index fud30_msg_i_ps
rowid 303278 missing from index fud30_msg_i_ta
rowid 303279 missing from index fud30_msg_i_s
rowid 303279 missing from index fud30_msg_i_mmi
rowid 303279 missing from index fud30_msg_i_ip
rowid 303279 missing from index fud30_msg_i_pi
rowid 303279 missing from index fud30_msg_i_ac
rowid 303279 missing from index fud30_msg_i_a
rowid 303279 missing from index fud30_msg_i_pa
rowid 303279 missing from index fud30_msg_i_ps
rowid 303279 missing from index fud30_msg_i_ta
rowid 303280 missing from index fud30_msg_i_s
rowid 303280 missing from index fud30_msg_i_mmi
rowid 303280 missing from index fud30_msg_i_ip
rowid 303280 missing from index fud30_msg_i_pi
rowid 303280 missing from index fud30_msg_i_ac
rowid 303280 missing from index fud30_msg_i_a
rowid 303280 missing from index fud30_msg_i_pa
rowid 303280 missing from index fud30_msg_i_ps
rowid 303280 missing from index fud30_msg_i_ta
rowid 303281 missing from index fud30_msg_i_s
rowid 303281 missing from index fud30_msg_i_mmi
rowid 303281 missing from index fud30_msg_i_ip
rowid 303281 missing from index fud30_msg_i_pi
rowid 303281 missing from index fud30_msg_i_ac
rowid 303281 missing from index fud30_msg_i_a
rowid 303281 missing from index fud30_msg_i_pa
rowid 303281 missing from index fud30_msg_i_ps
rowid 303281 missing from index fud30_msg_i_ta
rowid 303356 missing from index fud30_msg_i_s
rowid 303356 missing from index fud30_msg_i_mmi
rowid 303356 missing from index fud30_msg_i_ip
rowid 303356 missing from index fud30_msg_i_pi
rowid 303356 missing from index fud30_msg_i_ac
rowid 303356 missing from index fud30_msg_i_a
rowid 303356 missing from index fud30_msg_i_pa
rowid 303356 missing from index fud30_msg_i_ps
rowid 303356 missing from index fud30_msg_i_ta
rowid 303357 missing from index fud30_msg_i_s
rowid 303357 missing from index fud30_msg_i_mmi
rowid 303357 missing from index fud30_msg_i_ip
rowid 303357 missing from index fud30_msg_i_pi
rowid 303357 missing from index fud30_msg_i_ac
rowid 303357 missing from index fud30_msg_i_a
rowid 303357 missing from index fud30_msg_i_pa
rowid 303357 missing from index fud30_msg_i_ps
rowid 303357 missing from index fud30_msg_i_ta
rowid 303358 missing from index fud30_msg_i_s
rowid 303358 missing from index fud30_msg_i_mmi
rowid 303358 missing from index fud30_msg_i_ip
rowid 303358 missing from index fud30_msg_i_pi
rowid 303358 missing from index fud30_msg_i_ac
rowid 303358 missing from index fud30_msg_i_a
rowid 303358 missing from index fud30_msg_i_pa
rowid 303358 missing from index fud30_msg_i_ps
rowid 303358 missing from index fud30_msg_i_ta
wrong # of entries in index fud30_msg_i_s
wrong # of entries in index fud30_msg_i_mmi
wrong # of entries in index fud30_msg_i_ip
wrong # of entries in index fud30_msg_i_pi
wrong # of entries in index fud30_msg_i_ac
wrong # of entries in index fud30_msg_i_a
wrong # of entries in index fud30_msg_i_pa
wrong # of entries in index fud30_msg_i_ps
wrong # of entries in index fud30_msg_i_ta
Re: database or disk is full: HY000 [message #165377 is a reply to message #165376] Thu, 09 June 2011 16:43 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Try to run "reindex;" and "vacuum;".

If it doesn't help, dump and reload the database. This link may help: http://random.kakaopor.hu/how-to-repair-an-sqlite-database
Re: database or disk is full: HY000 [message #165378 is a reply to message #165369] Thu, 09 June 2011 16:49 Go to previous messageGo to next message
tux99   Switzerland
Messages: 44
Registered: September 2010
Karma: 0
Member
reindex;

returns:
SQL Error
(/var/www/fud-mageia/include/theme/default/db.inc:102
/var/www/fud-mageia/include/theme/default/db.inc:109
/var/www/html/forum/adm/admsql.php:76
) indexed columns are not unique: 23000
Query: reindex
_POST: array ( 'S' => 'db22e8747e0400a51753ae2fa2929e2c', 'SQ' => 'c383a393aceca0431fe3b95bb100414b', 'sql' => 'reindex; ', )
Server Version: 3.3.6
[Referring Page] http://mageia.linuxtech.net/forum/adm/admsql.php?S=db22e8747e0400a51753ae2fa2929e2c&SQ=f7951aad3354858e078cba2dd77d47dc


vacuum;

returns:
SQL Error
(/var/www/fud-mageia/include/theme/default/db.inc:102
/var/www/fud-mageia/include/theme/default/db.inc:109
/var/www/html/forum/adm/admsql.php:76
) constraint failed: 23000
Query: vacuum;
_POST: array ( 'S' => 'db22e8747e0400a51753ae2fa2929e2c', 'SQ' => 'c383a393aceca0431fe3b95bb100414b', 'sql' => 'vacuum;', )
Server Version: 3.3.6
[Referring Page] http://mageia.linuxtech.net/forum/adm/admsql.php


I'm trying the dump and reload now.

[Updated on: Thu, 09 June 2011 16:50]

Report message to a moderator

Re: database or disk is full: HY000 [message #165379 is a reply to message #165378] Thu, 09 June 2011 16:56 Go to previous messageGo to next message
tux99   Switzerland
Messages: 44
Registered: September 2010
Karma: 0
Member
dump went fine but the restore gives the following output:

Restoring forum files...

Warning: fopen(/var/www/fud-mageia//messages/msg_70000) [function.fopen]: failed to open stream: Permission denied in /var/www/html/forum/adm/admimport.php on line 110
WARNING: couldn't create /var/www/fud-mageia//messages/msg_70000

Warning: fopen(/var/www/fud-mageia//messages/msg_90000) [function.fopen]: failed to open stream: Permission denied in /var/www/html/forum/adm/admimport.php on line 110
WARNING: couldn't create /var/www/fud-mageia//messages/msg_90000

Warning: fopen(/var/www/fud-mageia//scripts/maillist.php-new) [function.fopen]: failed to open stream: Permission denied in /var/www/html/forum/adm/admimport.php on line 110
WARNING: couldn't create /var/www/fud-mageia//scripts/maillist.php-new

Warning: fopen(/var/www/html/forum//adm/admuser.php-new) [function.fopen]: failed to open stream: Permission denied in /var/www/html/forum/adm/admimport.php on line 110
WARNING: couldn't create /var/www/html/forum//adm/admuser.php-new
Drop database tables...

Fatal error: Uncaught exception 'Exception' with message '(/var/www/fud-mageia/include/theme/default/db.inc:102<br /> /var/www/fud-mageia/include/theme/default/db.inc:109<br /> /var/www/html/forum/adm/admimport.php:143<br /> ) database disk image is malformed: HY000<br /> Query: DROP TABLE fud30_ses<br /> _POST: array ( 'S' =&gt; 'db22e8747e0400a51753ae2fa2929e2c', 'SQ' =&gt; 'c383a393aceca0431fe3b95bb100414b', 'path' =&gt; '/var/www/fud-mageia/tmp/FUDforum_09_06_2011_10_14.fud.gz', 'btn_submit' =&gt; 'Import Data', )<br /> Server Version: 3.3.6<br /> [Referring Page] http://mageia.linuxtech.net/forum/adm/admimport.php?S=db22e8747e0400a51753ae2fa2929e2c&amp;SQ=c383a393aceca0431fe3b95bb100414b<br /> ' in /var/www/fud-mageia/include/core.inc:197 Stack trace: #0 /var/www/fud-mageia/include/theme/default/db.inc(102): fud_sql_error_handler('DROP TABLE fud3...', 'HY000', 'database disk i...', '3.3.6') #1 /var/www/fud-mageia/include/theme/default/db.inc(109): uq('DROP TABLE fud3...', 1) #2 /var/www/html/forum/adm/admimport.php(143): q('DROP TABLE fud3...') #3 {main} thrown in /var/www/fud-mageia/include/core.inc on line 197
Re: database or disk is full: HY000 [message #165380 is a reply to message #165379] Thu, 09 June 2011 17:00 Go to previous messageGo to next message
tux99   Switzerland
Messages: 44
Registered: September 2010
Karma: 0
Member
I guess we can ignore those warnings, the -new files where backups I made (they are owned by root) and the msg_*000 probably too, they are from last november and also root owned.
Re: database or disk is full: HY000 [message #165392 is a reply to message #165380] Sat, 11 June 2011 05:34 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Where are we with this? Are you back on-line?
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Character limit in posts
Next Topic: install_safe.php
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 09:32:21 GMT 2024

Total time taken to generate the page: 0.02537 seconds