error messages (autovaccum canceled and syntax errors) while loadinga DUMP
От | Matthias Apitz |
---|---|
Тема | error messages (autovaccum canceled and syntax errors) while loadinga DUMP |
Дата | |
Msg-id | 20200625111137.GA15798@sh4-5.1blu.de обсуждение исходный текст |
Ответы |
Re: error messages (autovaccum canceled and syntax errors) whileloading a DUMP
|
Список | pgsql-general |
Hello A PG dump file was produced on a 11.4. server the usual ways. When it is loaded with $ gzip -dc newanna_export.dmp | /usr/local/sisis-pap/pgsql/bin/psql -U sisis sisis it gives lots of error messages in the server log as: 2020-06-25 12:00:50.333 CEST [31295] ERROR: canceling autovacuum task 2020-06-25 12:00:50.333 CEST [31295] CONTEXT: automatic analyze of table "sisis.public.idm_targetlog" 2020-06-25 12:00:53.658 CEST [31295] ERROR: canceling autovacuum task 2020-06-25 12:00:53.658 CEST [31295] CONTEXT: automatic analyze of table "sisis.public.idm_targettab" 2020-06-25 12:00:55.375 CEST [31295] ERROR: canceling autovacuum task 2020-06-25 12:00:55.375 CEST [31295] CONTEXT: automatic analyze of table "sisis.public.idm_tasktab" and also syntax errors like: 2020-06-25 12:02:15.509 CEST [32719] ERROR: syntax error at or near "order" at character 652 2020-06-25 12:02:15.509 CEST [32719] STATEMENT: select id, brgroup, ins_time, upd_time, task_1, task_2, task_3, int_sel_1,int_sel_2, int_sel_3, int_sel_4, int_sel_5, str_sel_1, str_sel_2, str_sel_3, dat_sel_1, dat_sel_2, sel_seq_1, sel_seq_2,int_val_1, int_val_2, int_val_3, int_val_4, int_val_5, str_val_1, str_val_2, str_val_3, str_val_4, str_val_5, valtype_1,valtype_2, valtype_3, valtype_4, valtype_5, valtype_6, valtype_7, valmode_1, valmode_2, valmode_3, valmode_4, valmode_5,valmode_6, valmode_7, valname_1, valname_2, valname_3, valname_4, valname_5, valname_6, valname_7, valcont_1, valcont_2,valcont_3, valcont_4, valcont_5, valcont_6, valcont_7, sel_seq_3 from acq_vardata where id= order by sel_seq_3 2020-06-25 12:06:42.098 CEST [306] ERROR: syntax error at or near "q" at character 1 2020-06-25 12:06:42.098 CEST [306] STATEMENT: q select count(*) from ig_bigstrings ; What could be the reason for this? matthias -- Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub
В списке pgsql-general по дате отправления: