I'll change the service definition on my own, not sure if changing in the rpm is an acceptable default behavior for fedora, will leave that up to you. Here I don't really understand what to replace D_GENERAL with as all other options don't seem appropriate, maybe use D_PARSE. _func_, hostname, gai_strerror(error)) Īnd the D_GENERAL, whichever case is used, also causes xlog to set export_errno to 1. Xlog(D_GENERAL, "%s: failed to resolve %s: %s", However, this laborious severely limits the. Periodic CHECKPOINT's subsequently help to kick the xlog clean up into action. When this is running the pgxlog directory grows rapidly, and recovers very slowly. Occasionally I need to shift data on to a larger tablespace to prevent /var from filling up. Xlog(D_GENERAL, "%s: failed to resolve %s: (%d) %m", I'm running postgreSQL 9.6.0 on CentOS 7.2. This could probably be avoided by replacing L_ERROR with L_WARNING, however a couple of lines above the call to xlog, there's a call to host_addrinfo (in support/export/hostname.c), which does:Įrror = getaddrinfo(hostname, NULL, &hint, &ai) The L_ERROR causes xlog to set export_errno to 1, which is the value that exportfs returns. Next, disassemble and clean the fill valve and float cup. Once it breaks off, wash the valve with warm water and soap. ![]() ![]() If the exterior of the fill valve has mineral buildup on it, use vinegar and a toothbrush to clean off the sediment. Xlog(L_ERROR, "Failed to resolve %s", hname) Sediment can build up over time, and a good cleaning may fix the issue. In support/export/client.c, function client_lookup this sequence will do it once: That error exit code is set to 1 (twice!) when running exportfs, and the code finds an unresolvable host name. After I freed up space on the pgxlog partition and restarted, it took some time to replay all of the log (15-20 minutes) and everything recovered with no data corruption However, the theory about the data partition filling up first didn't happen in my case. ![]() To fix it, all it takes is to prefix all three exec targets in rvice unit definition that invoke /usr/sbin/exportfs with a - to make systemd ignore the error exit code (probably ignored by the sysV init script in pre-systemd times, but I don't have one around anymore to check.) user that the data directory filled up before pgxlog filled up. I finally had time to look at this, and I'm starting to believe that this started to happen with the switch to systemd.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |