MySQL Forums
Forum List  »  Newbie

Re: escaped character problem
Posted by: Wim Roffel
Date: October 07, 2018 02:05PM

There is not really much of configuration files.

My.cnf contains only references

mysqldump.cnf contains:
[mysqldump]
quick
quote-names
max_allowed_packet = 16M

mysqld.cnf contains:
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
bind-address = 127.0.0.1
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover-options = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M
innodb_file_per_table = 1

mysql.cnf contains only
[mysql]

mysqld_safe_syslog.cnf contains only
[mysqld_safe]
syslog

I had a two and a half year old Virtual installation (already PHP7 and Mysql instead of MariaDb). Until now I ran a project with a rather small database on it and everything seemed to work. Now - when I tried to import this larger database it gave the same problem as mentioned in my previous posts.

In this case I decided to see what happened when I applied double the quotes trick to the entries that gave problems. After the first few escapes I kept the same problems. But then I got a general error. And then - after even more double quotes - I got a 500 error. So I looked into the mysql error log and I found hundreds of entries like this:
[Sun Oct 07 18:40:46.234657 2018] [core:error] [pid 16752:tid 2856221504] [client 222.209.12.214:52567] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.

At the end I got the following three messages:
[Sun Oct 07 18:45:01.122183 2018] [fcgid:warn] [pid 16752:tid 2982112064] [client 222.209.12.214:56654] mod_fcgid: read data timeout in 40 seconds, referer: http://www.mysite.com/phpmyadmin/db_import.php?db=babil&token=7d006c0845ff766babde1753b77ec170
[Sun Oct 07 18:45:01.122743 2018] [core:error] [pid 16752:tid 2982112064] [client 222.209.12.214:56654] End of script output before headers: import.php, referer: http://www.mysite.com/phpmyadmin/db_import.php?db=babil&token=7d006c0845ff766babde1753b77ec170
[Sun Oct 07 18:45:01.356852 2018] [core:error] [pid 16752:tid 3024075584] [client 222.209.12.214:56880] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace., referer: http://www.mysite.com/phpmyadmin/import.php

Options: ReplyQuote


Subject
Written By
Posted
October 02, 2018 08:37AM
October 02, 2018 09:59AM
October 02, 2018 01:03PM
October 02, 2018 02:30PM
October 04, 2018 06:36AM
October 04, 2018 08:22AM
Re: escaped character problem
October 07, 2018 02:05PM
October 07, 2018 03:27PM
October 02, 2018 02:14PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.