see Log

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

see Log

Postby makodim » Mon Sep 27, 2010 8:15 pm

hi, Whether you can look at a log "PokerTracker.log" in ticket 97692,
in which during process Rebuild Cache have many errors
"[000000CC][PostgresPreparedStatement (Error)] Unable to execute prepared query: prepared_statement_1; Reason: Fatal Error ()" and
"2010/09/28 02:00:21.453: [000000CC][PostgresPreparedStatement (Error)] Unable to execute prepared query: prepared_statement_1; Reason: Fatal Error (ERROR: could not read block 182026 of relation 1663/16403/16537: Invalid argument )"

Rebuild Cache update is 100 percent complete, but Whether it will be bad for the further normal work of database ? (may be me have damage SSD disk)

me use postgres 8.3.11 and PT3 - 3.07.4beta
makodim
 
Posts: 136
Joined: Tue Jun 03, 2008 11:46 am

Re: see Log

Postby WhiteRider » Tue Sep 28, 2010 3:10 am

Your ticket is in our system and I'm sure you'll get a response within the next few hours.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: see Log

Postby makodim » Tue Sep 28, 2010 6:08 am

this ticket me make for forum, (may be if want see full LOG only), may be kraada know answer?
makodim
 
Posts: 136
Joined: Tue Jun 03, 2008 11:46 am

Re: see Log

Postby kraada » Tue Sep 28, 2010 8:40 am

Did you delete or otherwise remove any files from the PostgreSQL/8.3/data/base/ directory?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: see Log

Postby makodim » Tue Sep 28, 2010 8:45 am

me format SSd disk, then instal PostgreSQL and use EnterpriseDB Tuning Wizard and then import and update FIRST database (There are suspicions that with a problem disk)
makodim
 
Posts: 136
Joined: Tue Jun 03, 2008 11:46 am

Re: see Log

Postby kraada » Tue Sep 28, 2010 9:03 am

A damaged disk could certainly cause problems like that.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: see Log

Postby makodim » Tue Sep 28, 2010 9:37 am

On what such errors can be displayed further? (Considering that Update Cache completed on 100% and in game all ok)
makodim
 
Posts: 136
Joined: Tue Jun 03, 2008 11:46 am

Re: see Log

Postby kraada » Tue Sep 28, 2010 11:01 am

I'd need to see more of the log to figure out what happened - there was some prepared statement that was not run because PostgreSQL could not read a specific file. The files are automatically numbered by PostgreSQL and vary by system so without knowing what statement failed and what data is unavailable I cannot say what damage may have resulted or what may or may not be correct in your database.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 38 guests

cron
highfalutin