Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Random characters in Pen Log #35

Open
nevat opened this issue Nov 23, 2016 · 2 comments
Open

Random characters in Pen Log #35

nevat opened this issue Nov 23, 2016 · 2 comments

Comments

@nevat
Copy link

nevat commented Nov 23, 2016

We are using Pen to load balancing a MariaDB Cluster (Galera). Looking at log file (var/log/pen.log), I can see random characters just before some SQL orders (marked in bold):

_SELECT DISTINCT ID FROM rundetails WHERE
.INSERT INTO rundetails (ID, JOB_ID, START_TIME, RUN_DURATION, RUN_OUTCOME,
.DELETE FROM rundetails WHERE ID IN (1604677)
dSELECT DISTINCT ID FROM rundetails WHERE
.INSERT INTO rundetails (ID, JOB_ID, START_TIME, RUN_DURATION, RUN_OUTCOME,
.DELETE FROM rundetails WHERE ID IN (1604678)
_SELECT DISTINCT ID FROM rundetails WHERE
.INSERT INTO rundetails (ID, JOB_ID, START_TIME, RUN_DURATION, RUN_OUTCOME,
.DELETE FROM rundetails WHERE ID IN (1604679)

I don't know if this is a Pen Log problem or Galera sending _SELECT, dSELECT, etc. instead of .SELECT.

There are any report/bug about it ?

Thanks.

@UlricE
Copy link
Owner

UlricE commented Nov 25, 2016

What's the full command line (and config file, if any?)

@nevat
Copy link
Author

nevat commented Nov 25, 2016

/etc/pen.conf

LOGFILE=/var/log/pen.log
WEBFILE=/var/www/pen/webstats.html
MAX_CONNECTIONS=256
ROUNDROBIN=true

PORT=3306
BACKEND=3

SERVER1=172.xx.xx.xx:3306
SERVER2=172.xx.xx.xx:3306
SERVER3=172.xx.xx.xx:3306


An init.d script

. /etc/rc.d/init.d/functions
. /etc/pen.conf

LOCKFILE="/var/lock/subsys/pen"
PID=/var/run/pen.pid
PROG=/usr/bin/pen
PROGNAME=Pend

RETVAL=0
start() {
SERVER=grep "^SERVER" /etc/pen.conf | cut -d= -f2
[ $XFORWARDEDFOR = "true" ] && SERVER="-H $SERVER"
[ $ROUNDROBIN = "true" ] && SERVER="-r $SERVER"
[ $SSLCERTS ] && SERVER="-E $SSLCERTS $SERVER"

echo -n $"Starting $PROGNAME: "
daemon $PROG $PORT -w $WEBFILE -x $MAX_CONNECTIONS -p $PID -l $LOGFILE -S $BACKEND $SERVER
RETVAL=$?
echo
[ $RETVAL -eq 0 ] && touch $LOCKFILE
return $RETVAL

}
stop() {
echo -n $"Stopping $PROGNAME: "
killproc $PROG
RETVAL=$?
echo
[ $RETVAL -eq 0 ] && rm -f $PID $LOCKFILE
return $RETVAL
}
case "$1" in
start)
start
;;
stop)
stop
;;
status)
status -p "$PID" -l $PROG $PROGNAME
;;
restart)
stop
start
;;
*)
echo $"Usage: $0 {start|stop|status|restart}"
exit 1
esac
exit $?


Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants