mysql source recovers after process restarts

I am doing a large import (~300GB – MyISAM) into a MySQL server version 5.6.48 within a FreeBSD jail, before starting I did:

SET GLOBAL bulk_insert_buffer_size = 1024 * 1024 * 1024;
SET GLOBAL net_buffer_length=1000000;
SET GLOBAL max_allowed_packet=1000000000;
SET foreign_key_checks = 0;

And then:

source file.sql

The dump started to load but after a while, the server memory RAM/SWAP got full and the mysqld process exited.

What I notice and surprised me is that when the MySQL server came up again, the source command continued to load the dump, kind of “resuming” the process.

From the docs, I haven’t found much documentation about the source command, only from the MySQL shell:

mysql> source
ERROR:
Usage: . <filename> | source <filename>

Therefore wondering what is keeping the state or track of the inserted data and how could I check/monitor the source progress, besides willing to understand if this “resume” option is the expected behavior and if it could be configured.

kvm virtualization – How do remove the default storage pool from a libvirt hypervisor, so that even after libvirtd restarts there is NO storage pool

I want to remove the default storage pool from my virt-manager AND NOT HAVE IT COME BACK BY ITSELF, EVER. I can destroy it and undefine it all I want, but when i restart libvirtd (for me thats “sudo systemctl restart libvirtd” in an arch linux terminal window), and restart virt-manager, the default storage pool is back, just like Frankenstein.

I don’t want a storage pool of any kind. I simply want to move from the dual-boot I have now (arch linux and windows) to running the two OS simultaneously. I intend to provision two physical disk partitions on the host to be disks on the guest, and I can do this via the xml that defines the domain.

Or am i required to have a storage pool no matter what?

4.4 kitkat – The phone restarts / restarts continuously

I have an old micromax phone that runs on Android kitkat. For some reason, I turned off / on the phone. But now, when I press the power button, it restarts continuously (without appearance of the home screen).

I even charged the battery fully and I even checked that the battery was loose or not, there is no problem regarding the battery.

Even I had done a factory data reset and cleared the cache partition (by simultaneously pressing the power button and the volume key, then selecting the option resetting the factory data and removing the cache partition option) But it doesn't work!

The phone restarts continuously! To stop it , I had to manually remove the battery and then reinstall it. But when i press the power button, the condition becomes the same, it restarts / restarts continuously.

Is there anyway that I can fix it myself? Please help

My moto g5 plus continuously restarts with the flashing blue screen of moto G

I have been using moto g5 plus for the past few years. lats night it worked well. and since morning, it has only restarted continuously with the blue motorcycle screen. What to do? even if i have to reset it to factory settings then how to recover data from phone.

mysql – MariaDB restarts frequently

MariaDB restarts frequently (several times a day).

This is what I get in the mariadb.log

200411 18:38:51 mysqld_safe Number of processes running now: 0
200411 18:38:51 mysqld_safe mysqld restarted
200411 18:38:53 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.HWm8QZ' --pid-file='/var/lib/mysql/db-recover.pid'
200411 18:38:54 (Note) /usr/sbin/mysqld (mysqld 10.0.33-MariaDB-wsrep) starting as process 16103 ...
200411 18:39:01 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1
200411 18:39:01 (Note) /usr/sbin/mysqld (mysqld 10.0.33-MariaDB-wsrep) starting as process 16162 ...
200411 18:39:01 (Note) InnoDB: Using mutexes to ref count buffer pool pages
200411 18:39:01 (Note) InnoDB: The InnoDB memory heap is disabled
200411 18:39:01 (Note) InnoDB: Mutexes and rw_locks use GCC atomic builtins
200411 18:39:01 (Note) InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
200411 18:39:01 (Note) InnoDB: Compressed tables use zlib 1.2.7
200411 18:39:01 (Note) InnoDB: Using Linux native AIO
200411 18:39:01 (Note) InnoDB: Using CPU crc32 instructions
200411 18:39:01 (Note) InnoDB: Initializing buffer pool, size = 4.4G
200411 18:39:02 (Note) InnoDB: Completed initialization of buffer pool
200411 18:39:02 (Note) InnoDB: Highest supported file format is Barracuda.
200411 18:39:02 (Note) InnoDB: 128 rollback segment(s) are active.
200411 18:39:02 (Note) InnoDB: Waiting for purge to start
200411 18:39:02 (Note) InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 523546041827
200411 18:39:02 (Note) Plugin 'FEEDBACK' is disabled.
200411 18:39:02 (Note) Server socket created on IP: '::'.
200411 18:39:02 (Warning) 'proxies_priv' entry '@% root@site-mariadb' ignored in --skip-name-resolve mode.
200411 18:39:02 (Note) WSREP: Read nil XID from storage engines, skipping position init
200411 18:39:02 (Note) WSREP: wsrep_load(): loading provider library 'none'
200411 18:39:02 (Note) /usr/sbin/mysqld: ready for connections.
Version: '10.0.33-MariaDB-wsrep'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server, wsrep_25.21.rc3fc46e

Any ideas on what could be going on?

magento 1.9 – Mysql server restarts again and again due to high memory usage

I have 4 vCPU and 6 GB of memory on my server and the Red Hat Linux distribution with magento 1 configured and working suddenly, it started to restart the mysql server again and again. I checked that the CPU usage of all 4 cores goes to 100% most of the time and the memory consumption slowly went down to 5.87 GB then the server killed the mysql server and again the memory has gone to 1.2 GB and the Mysql server restarts again and again the same thing happens. I checked the my.cnf file and found these settings

   #
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

[mysqld]
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_allowed_packet=1073741824
max_allowed_packet=1073741824
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
log-error=/var/lib/mysql/server1.nctest.net.err
performance-schema=0
default-storage-engine=MyISAM
innodb_file_per_table=1
open_files_limit=50000
innodb_buffer_pool_size=134217728

I haven't gotten what I'm missing here, i.e. letting my 100% memory consume through the mysqld process.

macbook pro – No backlight on new Mac Pro, computer restarts

I bought this brand new MacBook Pro (15 inch, 2018) from Apply in 2019. From the start, it had this problem. I have permanently connected it to an external monitor and the MacBook is permanently closed and still connected to power.

At seemingly random intervals, say – about 3 to 5 times a month, after being away from the computer for about half an hour (for example, lunch), I come back to find that the external monitor does not not wake up on the keyboard or mouse input. When I open the cover of the MacBook, I can see that it is on, because the Touch Bar is on and responds to touch. But the strange thing is – there is no screen backlight!

The touch bar displays the screen brightness icon, so I tap on it, then it gives me the cursor left-right, and moving it to the left and right does nothing. If I hold a torch on the screen, I can see that it is working normally and I can move the mouse and interact with the icons and menu options.

I have not been able to reproduce this on the Apple Store, and they are not interested in reading the error reports.

It just happened now, and while I was on my way to the Apple Store to show the staff, it rebooted and then presented this error to me, what it did done dozens of times before.

Anyone know how to decipher this problem report so that I can understand what is causing it?

**Your computer was restarted because of a problem**


panic(cpu 8 caller 0xffffff7f91b9dad5): userspace watchdog timeout: remoted connection watchdog expired, no updates from remoted monitoring thread in 64 seconds, 11628 checkins from thread since monitoring enabled 232604 seconds ago after loadservice: com.apple.logd, total successful checkins since load (232604 seconds ago): 23260, last successful checkin: 10 seconds ago
service: com.apple.WindowServer, total successful checkins since load (232574 seconds ago): 23256, last successful checkin: 10 seconds ago

Backtrace (CPU 8), Frame : Return Address
0xffffffa3d068b820 : 0xffffff801113bb2b 
0xffffffa3d068b870 : 0xffffff80112734d5 
0xffffffa3d068b8b0 : 0xffffff8011264f4e 
0xffffffa3d068b900 : 0xffffff80110e2a40 
0xffffffa3d068b920 : 0xffffff801113b217 
0xffffffa3d068ba20 : 0xffffff801113b5fb 
0xffffffa3d068ba70 : 0xffffff80118d2b25 
0xffffffa3d068bae0 : 0xffffff7f91b9dad5 
0xffffffa3d068baf0 : 0xffffff7f91b9d7e6 
0xffffffa3d068bb10 : 0xffffff801186739b 
0xffffffa3d068bb60 : 0xffffff8011870443 
0xffffffa3d068bca0 : 0xffffff8011222d12 
0xffffffa3d068bdb0 : 0xffffff80111419d8 
0xffffffa3d068be10 : 0xffffff8011118635 
0xffffffa3d068be70 : 0xffffff801112f0e5 
0xffffffa3d068bf00 : 0xffffff801124b575 
0xffffffa3d068bfa0 : 0xffffff80110e3226 
      Kernel Extensions in backtrace:
         com.apple.driver.watchdog(1.0)(053A5D15-51D4-3E61-978B-EB435FA4BD0A)@0xffffff7f91b9c000->0xffffff7f91ba4fff

BSD process name corresponding to current thread: watchdogd
Boot args: chunklist-security-epoch=0 -chunklist-no-rev2-dev

Mac OS version:
19D76

Kernel version:
Darwin Kernel Version 19.3.0: Thu Jan  9 20:58:23 PST 2020; root:xnu-6153.81.5~1/RELEASE_X86_64
Kernel UUID: A8DDE75C-CD97-3C37-B35D-1070CC50D2CE
Kernel slide:     0x0000000010e00000
Kernel text base: 0xffffff8011000000
__HIB  text base: 0xffffff8010f00000
System model name: MacBookPro15,1 (Mac-937A206F2EE63C01)
System shutdown begun: NO

System uptime in nanoseconds: 232618213105438
last loaded kext at 3509823775238: @filesystems.msdosfs 1.10 (addr 0xffffff7f968a8000, size 69632)
loaded kexts:
com.razer.common.razerhid   21.94
com.radiosilenceapp.nke.filter  2.2
@filesystems.msdosfs    1.10
@filesystems.smbfs  3.4.1
@filesystems.exfat  1.4
>AudioAUUC  1.70
@fileutil   20.036.15
@kext.AMDFramebuffer    3.0.5
@kext.AMDRadeonX4000    3.0.5
@kext.AMDRadeonServiceManager   3.0.5
>!AGraphicsDevicePolicy 4.7.2
@AGDCPluginDisplayMetrics   4.7.2
>!AHV   1
|IOUserEthernet 1.0.1
|IO!BSerialManager  7.0.3f5
>pmtelemetry    1
>AGPM   111.4.2
>!APlatformEnabler  2.7.0d0
>X86PlatformShim    1.0.0
>!AUpstreamUserClient   3.6.8
@Dont_Steal_Mac_OS_X    7.0.0
>AGDCBacklightControl   4.7.2
>!A!IKBLGraphics    14.0.4
>BridgeAudioCommunication   6.66
>ACPI_SMC_PlatformPlugin    1.0.0
>!ABacklight    180.1
@kext.AMD9500!C 3.0.5
>!AThunderboltIP    3.1.3
>!A!ISlowAdaptiveClocking   4.0.0
>!AAVEBridge    6.1
>!AMuxControl2  4.7.2
>!AMCCSControl  1.13
>!ABridgeAudio!C    6.66
>!AGFXHDA   100.1.424
>!ATopCaseHIDEventDriver    3430.1
>!AHIDALSService    1
>!A!IPCHPMC 2.0.1
>!A!ICFLGraphicsFramebuffer 14.0.4
>!AFIVRDriver   4.1.0
@filesystems.autofs 3.0
|SCSITaskUserClient 422.0.2
>usb.realtek8153patcher 5.0.0
>BCMWLANFirmware4355.Hashstore  1
>BCMWLANFirmware4364.Hashstore  1
>BCMWLANFirmware4377.Hashstore  1
>!AFileSystemDriver 3.0.1
@filesystems.hfs.kext   522.0.9
@BootCache  40
@!AFSCompression.!AFSCompressionTypeDataless    1.0.0d1
@!AFSCompression.!AFSCompressionTypeZlib    1.0.0
>!AVirtIO   1.0
>!ABCMWLANBusInterfacePCIe  1
@filesystems.apfs   1412.81.1
@private.KextAudit  1.0
>!ASmartBatteryManager  161.0.0
>!AACPIButtons  6.1
>!ASMBIOS   2.1
>!AACPIEC   6.1
>!AAPIC 1.7
$!AImage4   1
@nke.applicationfirewall    303
$TMSafetyNet    8
@!ASystemPolicy 2.0.0
|EndpointSecurity   1
>!UAudio    320.49
@kext.AMDRadeonX4100HWLibs  1.0
@kext.AMDRadeonX4000HWServices  3.0.5
|IOAVB!F    800.17
>!ASSE  1.0
@!AGPUWrangler  4.7.2
>IOPlatformPluginLegacy 1.0.0
>!ABacklightExpert  1.1.0
>!AHDA!C    283.15
|IOHDA!F    283.15
>usb.cdc.acm    5.0.0
>usb.serial 6.0.0
|IOSlowAdaptiveClocking!F   1.0.0
>X86PlatformPlugin  1.0.0
>!AGraphicsControl  4.7.2
>!ASMBus!C  1.0.18d1
@plugin.IOgPTPPlugin    810.1
|IOEthernetAVB!C    1.1.0
|IOUSBHIDDriver 900.4.2
>!AActuatorDriver   3430.1
|IONDRVSupport  569.4
>!AHS!BDriver   3430.1
>IO!BHIDDriver  7.0.3f5
>!AMultitouchDriver 3430.1
>!AInputDeviceSupport   3430.1
>IOPlatformPlugin!F 6.0.0d8
>!AHIDKeyboard  209
>!ASMBusPCI 1.0.14d1
|IO!BHost!CUARTTransport    7.0.3f5
|IO!BHost!CTransport    7.0.3f5
>!A!ILpssUARTv1 3.0.60
>!A!ILpssUARTCommon 3.0.60
>!AOnboardSerial    1.0
@kext.AMDSupport    3.0.5
@!AGraphicsDeviceControl    4.7.2
|IOAccelerator!F2   438.3.1
|IOGraphics!F   569.4
>!AThunderboltEDMSink   4.2.2
>!AThunderboltDPOutAdapter  6.2.5
@kext.triggers  1.0
>usb.IOUSBHostHIDDevice 1.2
>usb.cdc.ecm    5.0.0
>usb.cdc.ncm    5.0.0
>usb.!UHub  1.2
>usb.cdc    5.0.0
>usb.networking 5.0.0
>usb.!UHostCompositeDevice  1.2
|IOSurface  269.6
@filesystems.hfs.encodings.kext 1
|IOAudio!F  300.2
@vecLib.kext    1.2.0
>!ABCMWLANCore  1.0.0
>mDNSOffloadUserClient  1.0.1b8
>IOImageLoader  1.0.0
|IOSerial!F 11
|IO80211!FV2    1200.12.2b1
>corecapture    1.0.4
|IOSkywalk!F    1
>!AThunderboltPCIDownAdapter    2.5.4
>!AThunderboltDPInAdapter   6.2.5
>!AThunderboltDPAdapter!F   6.2.5
>!AHPM  3.4.4
>!A!ILpssI2C!C  3.0.60
>!A!ILpssDmac   3.0.60
>!A!ILpssI2C    3.0.60
>!AXsanScheme   3
>!AThunderboltNHI   5.8.6
|IOThunderbolt!F    7.6.0
>usb.!UHostPacketFilter 1.0
|IOUSB!F    900.4.2
>usb.!UVHCIBCE  1.2
>usb.!UVHCI 1.2
>usb.!UVHCICommonBCE    1.0
>usb.!UVHCICommon   1.0
>!AEffaceableNOR    1.0
|IOBufferCopy!C 1.1.0
|IOBufferCopyEngine!F   1
|IONVMe!F   2.1.0
>usb.!UXHCIPCI  1.2
>usb.!UXHCI 1.2
>!AEFINVRAM 2.1
>!AEFIRuntime   2.1
>!ASMCRTC   1.0
|IOSMBus!F  1.1
|IOHID!F    2.0.0
$quarantine 4
$sandbox    300.0
@kext.!AMatch   1.0.0d1
>!AKeyStore 2
>!UTDM  489.80.2
|IOSCSIBlockCommandsDevice  422.0.2
>!ACredentialManager    1.0
>KernelRelayHost    1
>!ASEPManager   1.0.1
>IOSlaveProcessor   1
>!AFDEKeyStore  28.30
>!AEffaceable!S 1.0
>!AMobileFileIntegrity  1.0.5
@kext.CoreTrust 1
|CoreAnalytics!F    1
|IOTimeSync!F   810.1
|IONetworking!F 3.4
>DiskImages 493.0.0
|IO!B!F 7.0.3f5
|IO!BPacketLogger   7.0.3f5
|IOUSBMass!SDriver  157.40.7
|IOSCSIArchitectureModel!F  422.0.2
|IO!S!F 2.1
|IOUSBHost!F    1.2
>usb.!UCommon   1.0
>!UHostMergeProperties  1.2
>!ABusPower!C   1.0
|IOReport!F 47
>!AACPIPlatform 6.1
>!ASMC  3.1.9
>watchdog   1
|IOPCI!F    2.9
|IOACPI!F   1.4
@kec.pthread    1
@kec.corecrypto 1.0
@kec.Libm   1

python – Program restarts by itself and does not end until 2 valid entries

Guys, I was doing Gustavo Guanabara exercises and I came across an intriguing situation: my code restarts and hers does not !!! This is Python World Lesson 22 exercise 112. I used a structure of 3 files according to the diagram below:

test /
…. courseInVideo /
…….. currency /
…………____ init____.py
……..____ init____.py
…….. dado.py

Here is the content of the currency / ____ init____.py:

def metade(num, boleano):
    if boleano:
        return moeda(num/2)
    return num/2

def dobro(num, boleano):
    if boleano:
        return moeda(num*2)
    return num*2

def aumentar(num, acrescimo, boleano):
    result = num + (num * acrescimo / 100)
    if boleano:
        return moeda(result)
    return result

def diminuir(num, reducao, boleano):
    result = num - (num*reducao/100)
    if boleano:
        return moeda(result)
    return result

def moeda(num):
    conversor = str(num).split('.')
    saida = "RS" + conversor(0) + ',' + conversor(1)
    return saida

def resumo(num, acrescimo, reducao):
    saida = 20*'-' + 'n' + 'RESUMO DO VALOR' + 'n' + 20*'-' + 'nPreço analisado: ' + moeda(num) + 'nDobro do preço: ' + dobro(num, True) + 'nMetade do preço: ' + metade(num, True) + 'n' + str(acrescimo) + '% de aumento: ' + aumentar(num, acrescimo, True) + 'n' + str(reducao) + '% de redução: ' + diminuir(num, reducao, True)
    print(saida)

Content of data.py:

def leiaDinheiro(entrada):
    valido = True
    while valido:
        num = input(entrada)
        if num.isalpha():
            print(f'ERRO: "{num}´" é um preço inválido!')
        else:
            valido = False
            return float(num)

And the EmVideo / ____ init____.py course:

from teste.cursoEmVideo import dado
from teste.cursoEmVideo import moeda

p = dado.leiaDinheiro('Digite o preço: R$')
moeda.resumo(p, 80, 35)

Can anyone see why the program restarts after reading valid data, in this case numeric data? Even, as I mentioned in the title, the program really ends, but only after two valid data reads (not necessarily consecutive).

sharepoint server – SP 2016: disabled sandbox code service restarts

In an effort to stop the spucworkerprocessproxy process, I stop the Sandboxed Code Service (because we don't use sandbox code) by running:

$serviceInstance =  Get-SPServiceInstance | ? { $_.TypeName -eq '
Microsoft Sharepoint Foundation Sandboxed Code Service';

Stop-SPServiceInstance -Identity $serviceInstance.Id -Confirm:$false;

After performing the above, the status of the Sandboxed Code Service became "Unprovisioning" and the spucworkerprocessproxy was arrested and the entire load on his database was gone. And there was a lot of joy.

However, the next morning, the service was operational again, with spucworkerprocessproxy. Sad paperclip.

How can we stop this thing, and keep it? Thank you.

samsung – Android restarts after startup

My odroid xu4 card is started with Android and gets the console, but then it tries to open the fstab file. But the file path does not work properly and it starts to restart.

shell @ odroidxu3: / $
[2.387631] fs_mgr: path of the fstab file
[2.387690] fs_mgr: unable to open file
[2.440814] sysrq: SysRq: R / O emergency reassembly
[2.442844] Emergency reassembly finished
[3.273570] restart: restart the system with the command & # 39; & # 39;

Please help me with the same.