Edit report at https://bugs.php.net/bug.php?id=79721&edit=1
ID: 79721
Comment by: cbimax at gmail dot com
Reported by: cbimax at gmail dot com
Summary: Insert queries that take more than a day are dropped
Status: Open
Type: Bug
Package: MySQLi related
Operating System: Linux Gentoo
PHP Version: 7.2.31
Block user comment: N
Private report: N
New Comment:
I believe didn't understand your question.
If it is useful we have been working under php-5.6 with mysqli interface.
Previous Comments:
------------------------------------------------------------------------
[2020-06-21 18:14:49] bugreports2 at gmail dot com
mysqlnd - and your previous build?
------------------------------------------------------------------------
[2020-06-21 18:12:57] cbimax at gmail dot com
$ php -m
[PHP Modules]
bz2
Core
ctype
curl
date
dba
dom
fileinfo
filter
gettext
gmp
hash
iconv
json
libxml
mbstring
mysqli
mysqlnd
openssl
pcre
PDO
pdo_mysql
Phar
posix
readline
Reflection
session
SimpleXML
soap
sockets
SPL
standard
tokenizer
xapian
xdebug
xml
Zend OPcache
zlib
[Zend Modules]
Xdebug
Zend OPcache
------------------------------------------------------------------------
[2020-06-21 18:08:54] bugreports2 at gmail dot com
> But we only update PHP from 5.6 to 7.2; we don't touch the Kernel nor MariaDB
and your stineedge old build used mysqlnd or libmysql and what is your current using?
------------------------------------------------------------------------
[2020-06-21 18:06:15] cbimax at gmail dot com
> what evidecne do you have that it's even php related?
None. But we only update PHP from 5.6 to 7.2; we don't touch the Kernel nor MariaDB.
In case it is useful:
$ cat /etc/sysctl.conf
# /etc/sysctl.conf
#
# For more information on how this file works, please see
# the manpages sysctl(8) and sysctl.conf(5).
#
# In order for this file to work properly, you must first
# enable 'Sysctl support' in the kernel.
#
# Look in /proc/sys/ for all the things you can setup.
#
# Disables packet forwarding
net.ipv4.ip_forward = 0
# Disables IP dynaddr
#net.ipv4.ip_dynaddr = 0
# Disable ECN
#net.ipv4.tcp_ecn = 0
# Enables source route verification
#net.ipv4.conf.default.rp_filter = 1
# Enable reverse path
#net.ipv4.conf.all.rp_filter = 1
# Enable SYN cookies (yum!)
# http://cr.yp.to/syncookies.html
#net.ipv4.tcp_syncookies = 1
# Enable people in the specified (min, max) group range to send ICMP_ECHO
# messages (i.e. ping) and receive ICMP_ECHOREPLY responses. This allows
# you to run non-suid and non-caps ping, but it also means anyone with
# a gid in this range can send those packets (not just via ping).
#net.ipv4.ping_group_range = 100 100
# Disable source route
#net.ipv4.conf.all.accept_source_route = 0
#net.ipv4.conf.default.accept_source_route = 0
# Disable redirects
#net.ipv4.conf.all.accept_redirects = 0
#net.ipv4.conf.default.accept_redirects = 0
# Disable secure redirects
#net.ipv4.conf.all.secure_redirects = 0
#net.ipv4.conf.default.secure_redirects = 0
# Ignore ICMP broadcasts
#net.ipv4.icmp_echo_ignore_broadcasts = 1
# Disables the magic-sysrq key
#kernel.sysrq = 0
# When the kernel panics, automatically reboot in 3 seconds
#kernel.panic = 3
# Allow for more PIDs (cool factor!); may break some programs
#kernel.pid_max = 999999
# You should compile nfsd into the kernel or add it
# to modules.autoload for this to work properly
# TCP Port for lock manager
#fs.nfs.nlm_tcpport = 0
# UDP Port for lock manager
#fs.nfs.nlm_udpport = 0
------------------------------------------------------------------------
[2020-06-21 17:56:50] bugreports2 at gmail dot com
what evidecne do you have that it's even php related?
in my setups netfilter conntrack woud kill it long before
net.netfilter.nf_conntrack_tcp_timeout_established = 7200
when a single query takes longer than a day fix the root cause
hard_timeout => 2 => 2
Read timeout => 60
default_socket_timeout => 10 => 10
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=79721
--
Edit this bug report at https://bugs.php.net/bug.php?id=79721&edit=1