Hi,
From past two weeks, Odoo speed is reduced to one-third of the initial speed.
Also in D:\Odoo 10.0\PostgreSQL\data\pg_log :
Files of size 10MB and type text document are created.
For 22nd October altogether 663 pg_log files are created and it has consumed 6.47 GB space only for today.
For 13th Ocotber, 1264 files are created and it has consumed 12.3 GB space.
For 14th Ocotber, 133 files are created and it has consumed 1.29 GB space.
For 15th Ocotber, 1317 files are created and it has consumed 12.8 GB space.
On opening any of the log files it states :
2018-10-22 17:45:29 IST ERROR: column res_partner.cont_dob does not exist at character 838
2018-10-22 17:45:29 IST STATEMENT: SELECT "res_partner"."last_website_so_id" as "last_website_so_id","res_partner"."personl_email" as "personl_email","res_partner"."picking_warn" as "picking_warn","res_partner"."write_date" as "write_date","res_partner"."name" as "name","res_partner"."email_id_official" as "email_id_official","res_partner"."architect" as "architect","res_partner"."google_1" as "google_1","res_partner"."Level" as "Level","res_partner"."create_date" as "create_date","res_partner"."notify_email" as "notify_email","res_partner"."ver_status" as "ver_status","res_partner"."display_name" as "display_name","res_partner"."tin_no1" as "tin_no1","res_partner"."country_id" as "country_id","res_partner"."employee" as "employee","res_partner"."mobile2" as "mobile2","res_partner"."account_type" as "account_type","res_partner"."blacklisted" as "blacklisted","res_partner"."cont_dob" as "cont_dob","res_partner"."email1" as "email1","res_partner"."barcode" as "barcode","res_partner"."title" as "title","res_partner"."spouse" as "spouse","res_partner"."linkdien" as "linkdien","res_partner"."india_mart_1" as "india_mart_1","res_partner"."date" as "date","res_partner"."customer" as "customer","res_partner"."lang" as "lang","res_partner"."company_id" as "company_id","res_partner"."website" as "website","res_partner"."commercial_company_name" as "commercial_company_name","res_partner"."buying_role_partner" as "buying_role_partner","res_partner"."just_dial" as "just_dial","res_partner"."team_id" as "team_id","res_partner"."site_no" as "site_no","res_partner"."invoice_warn" as "invoice_warn","res_partner"."act_cont_id" as "act_cont_id","res_partner"."invoice_warn_msg" as "invoice_warn_msg","res_partner"."mobile1" as "mobile1","res_partner"."create_uid" as "create_uid","res_partner"."acct_email3" as "acct_email3","res_partner"."active" as "active","res_partner"."residence_address" as "residence_address","res_partner"."id" as "id","res_partner"."street2" as "street2","res_partner"."acct_land_three" as "acct_land_three","res_partner"."share_holder1" as "share_holder1","res_partner"."calendar_last_notif_ack" as "calendar_last_notif_ack","res_partner"."user_id" as "user_id","res_partner"."zone_1" as "zone_1","res_partner"."category_client" as "category_client","res_partner"."commercial_partner_id" as "commercial_partner_id","res_partner"."date_of_birth_partner" as "date_of_birth_partner","res_partner"."potential_client" as "potential_client","res_partner"."phone" as "phone","res_partner"."owner_no" as "owner_no","res_partner"."fax" as "fax","res_partner"."state_id" as "state_id","res_partner"."master" as "master","res_partner"."phone_three" as "phone_three","res_partner"."vat" as "vat","res_partner"."picking_warn_msg" as "picking_warn_msg","res_partner"."spec_ind" as "spec_ind","res_partner"."type" as "type","res_partner"."type_type" as "type_type","res_partner"."child2" as "child2","res_partner"."phone1" as "phone1","res_partner"."opt_out" as "opt_out","res_partner"."comment" as "comment","res_partner"."sale_warn_msg" as "sale_warn_msg","res_partner"."child1" as "child1","res_partner"."parent_id" as "parent_id","res_partner"."signup_token" as "signup_token","res_partner"."color" as "color","res_partner"."supplier" as "supplier","res_partner"."function" as "function","res_partner"."message_bounce" as "message_bounce","res_partner"."purchase_warn" as "purchase_warn","res_partner"."skype" as "skype","res_partner"."pan_no" as "pan_no","res_partner"."partner_share" as "partner_share","res_partner"."gst" as "gst","res_partner"."educational_qualification" as "educational_qualification","res_partner"."email2" as "email2","res_partner"."affinity_partner" as "affinity_partner","res_partner"."street" as "street","res_partner"."architects_nmbr" as "architects_nmbr","res_partner"."installer" as "installer","res_partner"."established" as "established","res_partner"."facebook_id" as "facebook_id","res_partner"."landmark" as "landmark","res_partner"."acct_mobile3" as "acct_mobile3","res_partner"."mobile" as "mobile","res_partner"."geo_location" as "geo_location","res_partner"."acct_mobile2" as "acct_mobile2","res_partner"."home_phone_num" as "home_phone_num","res_partner"."city" as "city","res_partner"."email" as "email","res_partner"."complete_details" as "complete_details","res_partner"."message_last_post" as "message_last_post","res_partner"."work_phone_exte" as "work_phone_exte","res_partner"."debit_limit" as "debit_limit","res_partner"."last_time_entries_checked" as "last_time_entries_checked","res_partner"."working_since" as "working_since","res_partner"."is_company" as "is_company","res_partner"."db_contact" as "db_contact","res_partner"."pmanager" as "pmanager","res_partner"."credit_limit" as "credit_limit","res_partner"."signup_expiration" as "signup_expiration","res_partner"."signup_type" as "signup_type","res_partner"."share_holder3" as "share_holder3","res_partner"."tz" as "tz","res_partner"."zip" as "zip","res_partner"."purchase_warn_msg" as "purchase_warn_msg","res_partner"."company_name" as "company_name","res_partner"."ref" as "ref","res_partner"."share_holder2" as "share_holder2","res_partner"."contact_source" as "contact_source","res_partner"."type_others" as "type_others","res_partner"."sale_warn" as "sale_warn","res_partner"."rating_rating" as "rating_rating","res_partner"."write_uid" as "write_uid" FROM "res_partner"
WHERE "res_partner".id IN (3) ORDER BY "res_partner"."display_name"
Can anyone help in figuring out the exact problem and how these log files are getting created in PostgreSQL pg_log folders ? Can I delete all these files and is it the reason of reduction in speed of Odoo ?
Regards
Sumit Sinha
