PDA

View Full Version : vacuum analyze problem



fille123
12-22-2009, 09:02 PM
evenin,

when I do Exactly what the manual says to do with the manual analyze i get this message... its longer so tell me if u need it all...

What can i do?

I tried to rebuild the handhistory in some "fix" option... but got some error message there...


Thank you




Nonremovable row versions range from 44 to 48 bytes long.
There were 0 unused item pointers.
Total free space (including removable row versions) is 7336 bytes.
0 pages are or will become empty, including 0 at the end of the table.
1 pages containing 7336 free bytes are potential move destinations.
CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: index "pokersites_pkey" now contains 16 row versions in 2 pages
DETAIL: 0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: "pokersites": moved 0 row versions, truncated 1 to 1 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.00 sec.INFO: analyzing "public.pokersites"INFO: "pokersites": scanned 1 of 1 pages, containing 16 live rows and 0 dead rows; 16 rows in sample, 16 estimated total rowsINFO: vacuuming "public.handhistories"
ERROR: invalid page header in block 38084 of relation "handhistories"

ERROR: invalid page header in block 38084 of relation "handhistories"

fozzy71
12-22-2009, 09:54 PM
evenin,

when I do Exactly what the manual says to do with the manual analyze i get this message... its longer so tell me if u need it all...

What can i do?

I tried to rebuild the handhistory in some "fix" option... but got some error message there...


Thank you




Nonremovable row versions range from 44 to 48 bytes long.
There were 0 unused item pointers.
Total free space (including removable row versions) is 7336 bytes.

How much free space is on your hard drives?

fille123
12-22-2009, 11:46 PM
1,9gb of 120gb

fille123
12-22-2009, 11:48 PM
now 22 gb free spaces, still dosnt work

fille123
12-23-2009, 12:03 AM
i read in some thread that maybe my database was corrupted so i thought of gettin a new one.... but then i'll need all the hands so i exported them but after ju 2min of exporting


"Error reading data: ERROR: XX001: invalid page header in block 38084 of realtion "handhistories"


what the heeelll is up with that?`:)



still could export the hands thought....

Patvs
12-23-2009, 10:03 AM
Just reimport the original handhistories from your archive folders.
Looks like your old database is corrupt.

fozzy71
12-23-2009, 12:20 PM
Just reimport the original handhistories from your archive folders.
Looks like your old database is corrupt.

THIS

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/showthread.php?t=20754


If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.

fille123
12-23-2009, 02:52 PM
the new database seems to work fine, what happens if i keep the old one? will hm run slower? or will it use more memory from my computer?

thanks

fozzy71
12-24-2009, 02:44 PM
No, it shouldn't. The inactive DB's don't affect the performance of the active DB very much at all, but there is no need to keep a corrupt DB on the PostgreSQL server if you can't access it. It is just wasting hard drive space.