Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica.log file is not rotating 2

/home/dbadmin/DBbursa/v_DB_node0001_catalog/vertica.log
the log is not rotating because log rotate expects username owner to be root root

of file

/opt/vertica/config/logrotate/total/DB
and it is dbadmin verticadba 

Comments

  • Hi Shimon!

    Can you post your installation flags? You can extract it from /opt/vertica/config/admintools.conf
  • Welcome to Ubuntu 14.04 LTS (GNU/Linux 3.11.0-12-generic x86_64) ~# cat /opt/vertica/config/admintools.conf [Configuration] last_port = 5433 default_base = /home/dbadmin format = 3 install_opts = --hosts '123.123.123.123' '--failure-threshold=FAIL' -S default spreadlog = False controlsubnet = default controlmode = broadcast [Cluster] hosts = 123.123.123.123 [Nodes] node0001 = 123.123.123.123,/home/dbadmin,/home/dbadminv_mydb_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_mydb_node0002 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_mydb_node0003 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_frienddb_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_default_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_default_node0002 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_test_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_mydb_node0004 = 123.123.123.123,/home/dbadmin,/home/dbadmin v_myappdb_node0001 = 123.123.123.123,/home/dbadmin,/home/dbadmin [Database:frienddb] restartpolicy = ksafe port = 5433 path = /home/dbadmin/frienddb nodes = v_frienddb_node0001 [Database:myappdb] restartpolicy = ksafe port = 5433 path = /home/dbadmin/myappdb/v_myappdb_node0001_catalog nodes = v_myappdb_node0001
  • Hi!

    It do not match, to config.

    /home/dbadmin/DBbursa/v_DB_node0001_catalog/vertica.log

    means that name of database is DB, while you posted config for frienddb and myappdb

  • no i changed names if you can remove that DBbursa from all comments and thus comment
  • after changing the owner it works for me , i just report a bug to you
  • Hi!

    Thanks, but looks like you are an enterprise user (4 nodes ;)), so a best way its to open a ticket or send an e-mail to Vertica support.

    About your "bug":
    1. I did a lot of installations and no problems with log rotation. There are problems sometimes(while its not clear in docs) with user permissions when you defines a db super user and/or os user already exists. But you modified your output so I can't be sure that you didn't modified your install options too and so can say where is a problem.
    An example of permissions problem:
    https://community.vertica.com/vertica/topics/tz


    2. Ubuntu 14.04 isn't supported, so be careful, you actually have no support.
    https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/SupportedPlatforms/MCandServer.htm%3FTocP...

    PS
    I asked only install options - to verify a problem with permissions and I don't care about ips, and so on, only db super user, group, password, etc.

    Ubuntu 14.04 require threshold HALT :)
    [email protected]:~$ lsb_release -a
    No LSB modules are available.
    Distributor ID: Ubuntu
    Description: Ubuntu 14.04 LTS
    Release: 14.04
    Codename: trusty

    [email protected]:~$ grep install /opt/vertica/config/admintools.conf
    install_opts = --hosts '127.0.0.1' --dba-user daniel --dba-group daniel --data-dir /vertica --clean --license CE --accept-eula --failure-threshold HALT


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.