Menu

#4244 There's error message in postgresql log when use pgsqlsetup to setup xcat database

2.8.5
rejected
database
5
2014-08-12
2014-08-12
Degao Chu
No

After install xcat and postgresql, use command "source /etc/profile.d/xcat.sh;/opt/xcat/bin/pgsqlsetup -i -V 2>&1 >>/tmp/pcm-pgsqlsetup.log" to setup postgresql. There will be some error message in postgresql log. Seems no function impact. We don't know whether it's a bug. Please help investigate it.

[root@demoenv ~]# cat /var/lib/pgsql/data/pg_log/postgresql-Fri.log
LOG: database system was shut down at 2014-03-14 12:02:28 CST
LOG: database system is ready to accept connections
LOG: autovacuum launcher started

ERROR: syntax error at or near "q" at character 1
STATEMENT: q;
LOG: unexpected EOF on client connection
ERROR: syntax error at or near "q" at character 1
STATEMENT: q;
LOG: unexpected EOF on client connection
LOG: received fast shutdown request
LOG: aborting any active transactions
LOG: autovacuum launcher shutting down
FATAL: terminating connection due to administrator command
FATAL: terminating connection due to administrator command
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2014-03-14 12:04:54 CST
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
WARNING: there is no transaction in progress
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
[root@demoenv ~]#

Discussion

  • Lissa Valletta

    Lissa Valletta - 2014-08-12
    • assigned_to: Lissa Valletta
    • component: unknown --> database
     
  • Lissa Valletta

    Lissa Valletta - 2014-08-12

    This has nothing to do with xCAT. autovaccum is a function of postgresql and it may have some issue in your environment. Is this Redhat 7, what level of postgresql. Are you using the one shipped with the OS?? I would search for this error out of postgresql in the autovacuum area.
    What level of xCAT are you running.

     
  • Lissa Valletta

    Lissa Valletta - 2014-08-12
    • status: open --> rejected
     
MongoDB Logo MongoDB