postgresql – Best way to solve a lot of queries stuck because of no index

found this table has 800,000 rows and does not have any indexes

Is there any safer and more sufficient way to solve this problem?

Only really re-emptive work:

  • Proper design work up-front so there are no large tables with no indexes, or not common queries that are not well-supported by the existing indexes. This might be out of your hands if you don’t work directly with the development team for the application, but as a DBA you could monitor your databases for potentially worrying structures (i.e. a table with no keys/indexes, regular slow running queries if you log those, …). Recheck after application updates, in case a structure migration has failed silently and left indexes undefined that the developers have added.

  • Load testing on the application to make sure no such issues are likely (you often can’t rule them out entirely, but you can certainly minimise the risk). Again, this may be out of your hands.

but I think this approach is risky

A long index build, especially if done as an offline operation so could hold up all other access to the table, could be problematic, but when this happens adding the index is the only solution. Perhaps go for an online index build if possible – that will take longer but won’t completely block part of the application while it does the job.

Also, if you have a dev copy of the system, test the new indexing changes there before applying to production to avoid making a change that will take ages to apply and have little of the benefit you are needing.

keyboard – New macOS install stuck on loading screen, but works in safe mode

First a bit of history:

I had installed Bootcamp on my MacBook and to give it more space, I had deleted macOS recovery and system partitions from Easus Partition Manager on Windows. But because of this, I wasn’t able to install macOS back as Internet Recovery wasn’t able to download.

So I booted it in Target Disk mode and wiped the SSD clean from another MacBook. Internet recovery now downloaded fine, but now I got “Downloading installer information to the target volume failed” on trying to install the OS.

So now I did a Disk Utility “Restore” via target disk mode from the other MacBook, but on booting, I was getting APFS PreBoot volume not found error, I followed this guide to manually create that volume: and now that the SSD was fixed, I clean reinstalled macOS Catalina via Internet recovery.

But after installation, it seems to be stuck at the loading screen with the Apple logo and the loading bar at around 60%. However, it boots just fine in safe mode. Also while in safe mode, I noticed that it can’t properly recognize my in-built keyboard, even though all keys work just fine on trying. If I go to keyboard settings in safe mode, I see the following screen:

enter image description here

The “Change keyboard type…” shouldn’t ideally be there. I know because I tried booting another working MacBook to safe mode and I don’t see that button there.
On clicking on the button, I see:

enter image description here

BTW I got the above screen on the first safe mode boot as well.

Then I clicked Continue, and I try clicking on the button to the right of the left shift key, i.e., Z:

enter image description here

I am not sure if that’s the reason for it not booting up, but just putting it there.

I have already tried NVRAM reset, SMC reset, DFU firmware revive, installing Mojave, Big Sur. None helped.

I also tried unloading and even deleting the Apple HIDKeyboard, TopCase and MultitouchDriver kexts, thinking maybe the driver isn’t able to communicate with the built-in keyboard/touchbar/touchpad properly, but that didn’t help either. I am almost at the end of the list of all things to try. My MacBook is out of warranty. As such, I am asking here for more things to try out before sending it out to the service center.

Thanks a lot!

boot loop – Please help me do data recovery from a phone stuck in bootloop

I bought a Huawei Honor 5C Pro phone 2 years back and so far it had been working well. Two nights back, the phone shut down because of empty battery and I slept without putting it on charge.

The next morning, I started to charge it but the red light started blinking continuously for some time. Then, the honor logo was repeatedly flashing on and off without it reaching the lock screen.After every two or three times of flashing honor logo, it flashes emui with reboot,factory reset and clear partition cache options but it doesn’t stop for me to choose any option.

This bootloop happens continuously while it is charging and if I remove it from charging, it still bootloops and doesn’t shutdown no matter what. It bootloops until all battery is drained and then shuts down.

Only one time did it open while charge was 10% but after that, it shut down and hasn’t stopped bootlooping.

Unfortunately, the battery is not removable.

Also, the problem is, when I put it on charge, for some time a red light blinks and then without any input from user, the phone switches on, boots to Honor logo and after every 2-3 honor logo flashes, it flashes to emui (with reboot, factory reset and clear partition cache option) but the screen immediately blacks out before I can choose any option.

The morning it happened, after many tries, it did open once at 10% charge. But it again switched off and hasn’t stopped bootlooping since.

I don’t care if the phone doesn’t work. I just need the data stored on the ROM. If the phone can work, that’s great but the data is more important.

As long as the phone keeps charging, this boot loop keeps happening despite me trying to switch off the phone. When I remove it from charging, it still boot loops until battery is low.

Please help me get back control of the phone or atleast recover the data stored on the phone’s ROM.

Site stuck in maintenance mode after migration to D8

I migrated a D7 site to D8 as instructed. The content has come over but I can’t get the site out of maintenance mode because I have 2 “This block is broken or missing. You may be missing content or you might need to enable the original module.”
I have tried a couple of suggestions to fix this by adding Recreate Block Content and Fixed Block Content modules but the errors persist.

During the site migration, these modules could not be converted to D8. Is this the problem? I am fairly new to Drupal.


I’m 16, I’m stuck outside of Australia with an expired Australian passport and my mother is refusing to give me my valid one. What can I do?

My parents are divorced and still in a custody battle over my sister and I so we need signatures from both of them for me to get a passport. We got a passport earlier this year but because my dad isn’t in Australia they couldn’t give it to him so they gave it to my mum. Now she’s refusing to give me my passport. I’ve got recordings of her saying she won’t give it to me. Is there anything I can do to get my passport so I can come back home? I do have an Afghan passport but my Aussie passport and afghan passport are under different names. What can I do? Please help. I want to go home.

sharepoint server – SP 2013 Configuration Wizard stuck at step 9 / 10 with SPUpgradeException at SPIisWebSiteWssSequence

I am trying since multiple days installing SharePoint 2013 Foundation farm (no standalone development environment), but the Configuration Wizard stucks doggedly at step 9 of 10. Now I am at the end of my wisdom and my nerves.

Please help me with a solution for this issue. Thank you very much in advance.

  • Windows 2008 R2 Enterprise with IIS version 7.0 (is this IIS version correct?)
  • SQL Server Express 2008 R2 ADV (ADV = Advanced Services)
  • SharePoint 2013 Foundation with Service Pack 1 and really all possible updates
  • My virus protector is off
  • My firewall is off

The Error (in German)

Wizard error message at step 9 of 10

in brief:

Microsoft.SharePoint.Upgrade.SPUpgradeException: Action of
Microsoft.SharePoint.Upgrade.SPIisWebSiteWssSequence failed

The log file says:

Task upgrade has failed with an unknown exception Exception:
Microsoft.SharePoint.Upgrade.SPUpgradeException: Action of
Microsoft.SharePoint.Upgrade.SPIisWebSiteWssSequence failed. —>
System.NullReferenceException: Der Objektverweis wurde nicht auf eine
Objektinstanz festgelegt. bei
xmldocSiteMap, String strSrcFilePath, String strMergeFilePattern)
bei Microsoft.SharePoint.Administration.SPAspSiteMapFile.Copy(String
strSrcDir, String strSrcDirPrevious, String strSrcLeaf, String
strDestDir, Boolean bMergeMaps, Boolean bBackupExistingFile) bei
vrPath, OverwriteSetting overwrite) bei
Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() — Ende
der internen Ausnahmestapelüberwachung —

I tried:

  • Deleting cache files and editing cache.ini
  • Starting configuration wizard from command line:
  • stsadm -o execadmsvcjobs
  • PSConfig.exe -cmd upgrade -inplace b2b -force
  • Removing SharePoint and SQL Server and re-install them again

and much more from a hundred of Google findings

Please help me with a solution for this issue. Thank you very much in advance.

ios – iPhone is stuck in Recovery Mode with full storage

I was trying to update my iPhone X (GSM) from iOS 12.3.1 to iOS 14.0.1

The following steps was carried:

1- Downloading the latest firmware ipsw (size 4.61 GB) from
iPhone10,3,iPhone10,6_14.0.1_18A393_Restore.ipsw from

2- Downloading the latest iTunes on my Windows 10 PC

3- Connecting the iPhone by an original USB cable to my PC

4- Locating my iPhone
and pressing “Shift” button from my keyboard and pressing on the
Update from iTunes

5- Selected the ipsw which was previously

6- During in the middle of the update, an error came out
with a code # 14.

7- My iPhone got stuck permanently on the iTunes

8- Tried for several times to exit the Recovery Mode by
Pressing and quickly release the Volume Up button. Press and quickly
release the Volume Down button. Then, press and hold the Side
button. it just keep restarting and getting back into the Recovery

9- Downloaded couple of software’s “Tenorshare ReiBoot Pro”
and “3uTools” to force exit Recovery Mode, no good results.

The problem here is happening because I guess that I have tried to install the updates although there was no enough storage on my iPhone.

If there is anyway to delete large files in order to free space of my iPhone (while it is in Recovery Mode” it would be much appreciated.


If there is a way to update the iPhone to any iOS that has a small ipsw size would help on this issue, bare in mind downgrading or using OTA (Over the Air) firmwares to be directly installed on my iPhone by a PC.


Thinking outside the box:

If there is a way to connect the iPhone to any operating system i.e. Linux and have it connected there by entering the file explorer in order to delete some large files would help, need some experiments please.

ubuntu – watchdog: BUG: soft lockup – CPU#51 stuck

We have 2 similar machines x10qbi, 4 x cpu, 1TB RAM, Ubuntu 18 that are facing soft lockup and freeze.
Already disabled ACPI in BIOS, but it did not solve, ASP was off since initial setup.

These 2 machines faced issues with RAID5 and RAID10 via adaptec (8 disks x 3TB SAS 7200)

watchdog: BUG: soft lockup - CPU#51 stuck for 22s! (pacd:140354)
Modules linked in: macvlan cfg80211 ceph libceph fscache aufs overlay rdma_ucm(OE) ib_ucm(OE) ib_ipoib(OE) ib_umad(OE) esp6_offload esp6 esp4_offload esp4 xfrm_algo mlx5_fpga_
mdev vfio_iommu_type1 vfio mdev(OE) mlx4_en(OE) bonding xfs nls_iso8859_1 intel_rapl sb_edac x86_pkg_temp_thermal intel_powerclamp coretemp kvm_intel kvm irqbypass ipmi_ssif i
k(OE) intel_rapl_perf mei_me lpc_ich mei shpchp ioatdma ipmi_si mac_hid ipmi_devintf ipmi_msghandler acpi_pad sch_fq_codel nf_nat_pptp nf_nat_proto_gre nf_conntrack_pptp nf_co
dma_cm(OE) iw_cm(OE) ib_cm(OE) iscsi_tcp libiscsi_tcp libiscsi scsi_transport_iscsi knem(OE) ip_tables x_tables autofs4
 btrfs zstd_compress raid10 raid456 async_raid6_recov async_memcpy async_pq async_xor async_tx xor raid6_pq libcrc32c raid1 raid0 multipath linear mlx4_ib(OE) ib_uverbs(OE) ib
f_pclmul crc32_pclmul ghash_clmulni_intel ast hid_generic i2c_algo_bit pcbc ttm usbhid aesni_intel hid drm_kms_helper aes_x86_64 crypto_simd syscopyarea glue_helper ixgbe sysf
sys_fops ptp nvme_core devlink aacraid ahci pps_core drm mlx_compat(OE) libahci mdio wmi
CPU: 51 PID: 140354 Comm: pacd Tainted: G           OE    4.15.0-29-generic #31-Ubuntu
Hardware name: Supermicro PIO-848B-TRF4T-ST031/X10QBI, BIOS 3.2a 08/08/2019
RIP: 0010:_raw_spin_unlock_irqrestore+0x15/0x20
RSP: 0018:ffff8d09bf2c3d68 EFLAGS: 00000202 ORIG_RAX: ffffffffffffff11
RAX: 00000000ff5e4a5d RBX: ffff8d49ab049b68 RCX: ffff8d09bf2c3d98
RDX: ffff8d49ab049b70 RSI: 0000000000000202 RDI: 0000000000000202
RBP: ffff8d09bf2c3d68 R08: 000000000000000e R09: 0000000000000000
R10: ffff8d09bf2c3c70 R11: 0000000000000073 R12: 00000000ff5e4a5d
R13: 0000000000000202 R14: 0000000000000000 R15: 0000000000000000
FS:  00007ff6c3e9e700(0000) GS:ffff8d09bf2c0000(0000) knlGS:0000000000000000
CS:  0010 DS: 0000 ES: 0000 CR0: 0000000080050033
CR2: 00000000152b4038 CR3: 0000003dc5766001 CR4: 00000000003606e0
DR0: 0000000000000000 DR1: 0000000000000000 DR2: 0000000000000000
DR3: 0000000000000000 DR6: 00000000fffe0ff0 DR7: 0000000000000400
Call Trace:
 ? blk_mq_tag_update_depth+0x110/0x110
 ? ktime_get+0x43/0xa0
 ? lapic_next_deadline+0x26/0x30
RIP: 0010:_raw_spin_unlock_irqrestore+0x15/0x20
RSP: 0018:ffff9a6f5aa7fa68 EFLAGS: 00000202 ORIG_RAX: ffffffffffffff11
RAX: 0000000000000202 RBX: ffff9a6f5aa7fac0 RCX: ffff8c8805690000
RDX: 0000000000000000 RSI: 0000000000000202 RDI: 0000000000000202
RBP: ffff9a6f5aa7fa68 R08: 0000000000d00000 R09: ffff8d09bf663440
R10: 0000000000000000 R11: 0000000000000082 R12: ffff8d49ab049b68
R13: 0000000000000002 R14: 0000000000000060 R15: ffff8d49ab049b00
 ? wait_woken+0x80/0x80
 ? submit_bio+0x73/0x150
 ? xfs_setfilesize_trans_alloc.isra.13+0x3e/0x90 (xfs)
 xfs_submit_ioend+0x87/0x1c0 (xfs)
 xfs_vm_writepages+0xd1/0xf0 (xfs)
 ? iomap_write_begin.constprop.18+0x140/0x140
 ? iomap_file_buffered_write+0x6e/0xa0
 ? iomap_write_begin.constprop.18+0x140/0x140
 ? xfs_iunlock+0xf8/0x100 (xfs)
 ? __filemap_fdatawrite_range+0xc1/0x100
 xfs_file_fsync+0x5f/0x230 (xfs)
RIP: 0033:0x7ff729d273e7
RSP: 002b:00007ff6c3d9ec50 EFLAGS: 00000293 ORIG_RAX: 000000000000004b
RAX: ffffffffffffffda RBX: 0000000000000027 RCX: 00007ff729d273e7
RDX: 0000000000000000 RSI: 0000000000000000 RDI: 0000000000000027
RBP: 00007ff6c3d9ed30 R08: 0000000000000000 R09: 000000000000002c
R10: 00007ff6bc0008d0 R11: 0000000000000293 R12: 00007ff6c3d9ece0
R13: 00007ff6bc010965 R14: 00007ff6c3d9ed60 R15: 00007ff6bc00e3f0
Code: 47 76 ff ff ff 7f 89 d0 5d c3 90 90 90 90 90 90 90 90 90 90 90 90 0f 1f 44 00 00 55 48 89 e5 c6 07 00 0f 1f 40 00 48 89 f7 57 9d <0f> 1f 44 00 00 5d c3 0f 1f 40 00 0f 1f

rooting – TWRP is stuck at the boot screen when trying to flash twrp on Mi A2

I am trying to root my Mi A2 android phone. I am following this tutorial. When I try fastboot boot path/to/twrp/image the phone gets stuck on the boot screen. What am I doing wrong? Is it because a] I don’t have required drivers or because b] I have to disable force encryption? If a] I have to install new drivers what are they, where do I get them and how do I install them? If it is b] about disabling force enryption then how to do it?