Error Logging with clusters
Error Logging with clusters
От:
Shankar K <shan0075@yahoo.com>
Дата:
Hi, I got a database cluster with multiple databases on it. all with similar tables/indexes etc. Now the question is, how to identify database x raised error y (which gets logged in server logfile). for e.g. below snip gets logged in server logfile, which clearly tells dummy_id is not a column of temp_table. however it doesn't say what database or schema. 2003-07-29 12:13:14 ERROR: No such attribute temp_table.dummy_id i have log_min_error_statement, server_min_messages to its defaults which is error and notice respectively. I tried log_statement=true, but that didn't help either. Is there any way i could get that info. thanks Shankar __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com