October 2021 - openSUSE Users - openSUSE Mailing Lists

mysql upgrade failure
by Marc Chamberlin 31 Oct '21

31 Oct '21

Hello - I have ran into a problem that maybe someone else has hit and knows a solution for it. I recently upgraded my OpenSuSE 15.2 x64 version to OpenSuSE 15.3 x64 and installed all additional updates and patches that were suggested for 15.3. Most of the upgrade succeeded, all except Mariadb. Google has not been helpful either. My understanding of Mariadb is that after a new install of a new version it is suppose to automagically update and fix the databases from the older version, when the server is restarted, but I think this is failing. I found the upgrade log file for Mariadb and it appears to be reporting some kind of corruption has occurred. This is preventing the mariadb (mysql) server from even starting, so it is not possible to use queries to find and repair the database. - > bigbang:/var/tmp/mysql-protected.lBP2YQ # more log_upgrade_run.err > 2021-10-31 12:11:36 0 [Note] InnoDB: !!! innodb_force_recovery is set > to 1 !!! > 2021-10-31 12:11:36 0 [Note] InnoDB: Uses event mutexes > 2021-10-31 12:11:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 > 2021-10-31 12:11:36 0 [Note] InnoDB: Number of pools: 1 > 2021-10-31 12:11:36 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions > 2021-10-31 12:11:36 0 [Note] mysqld: O_TMPFILE is not supported on > /tmp (disabling future attempts) > 2021-10-31 12:11:36 0 [Note] InnoDB: Using Linux native AIO > 2021-10-31 12:11:36 0 [Note] InnoDB: Initializing buffer pool, total > size = 134217728, chunk size = 134217728 > 2021-10-31 12:11:36 0 [Note] InnoDB: Completed initialization of > buffer pool > 2021-10-31 12:11:36 0 [ERROR] InnoDB: corrupted TRX_NO 5f737461748dea16 > 2021-10-31 12:11:36 0 [Note] InnoDB: Retry with innodb_force_recovery=5 > 2021-10-31 12:11:36 0 [ERROR] InnoDB: Plugin initialization aborted > with error Data structure corruption > 2021-10-31 12:11:36 0 [Note] InnoDB: Starting shutdown... > 2021-10-31 12:11:36 0 [ERROR] Plugin 'InnoDB' init function returned > error. > 2021-10-31 12:11:36 0 [ERROR] Plugin 'InnoDB' registration as a > STORAGE ENGINE failed. > 2021-10-31 12:11:36 0 [Note] Plugin 'FEEDBACK' is disabled. > 2021-10-31 12:11:36 0 [ERROR] Unknown/unsupported storage engine: InnoDB > 2021-10-31 12:11:36 0 [ERROR] Aborting On a hunch, I decided to install the OpenSuSE OSS repository for 15.2 and this allowed me to drop back and install version 10.4.13-lp152.1.1 of the mariadb server, client, errormessages, and tools packages. (OpenSuSE 15.3 wants to install version 10.5.12-3.9.1 of these mariadb packages.) And lo and behold the previous 10.4.13-lp152.1.1 package works fine! So what gives? Any idea why the upgraded version of mariadb packages are failing to upgrade and support my databases? As I said I have tried Googling for an answer but no joy finding one. A lot of the proposed solutions, Google found, assume the mariadb server is up and running (hump!) so the example solutions given, use mysql queries and commands to fix corrupt databases and tables. I should also point out that AFAIK most, if not all of my database structures are using InnoDB and not the older MYISAM structures (although the mysql database itself appears to have both). I did make a mysql backup of all the databases but without the ability to start the mariadb server I don't know how to make use of this backup file to reconstruct all the databases and their tables etc. Thanks in advance for any and all advice on how to upgrade my mariadb server. Marc Chamberlin -- *"The Truth is out there" - Spooky* -- *_ _ . . . . . . _ _ . _ _ _ _ . . . . _ . . . . _ _ . _ _ _ . . . . _ _ . _ . . _ . _ _ _ _ . _ . _ . _ . _ . * Computers: the final frontier. These are the voyages of the user Marc. His mission: to explore strange new hardware. To seek out new software and new applications. To boldly go where no Marc has gone before! (/This email is digitally signed. My public key for sending encrypted email to me can be found at - https://keys.openpgp.org/search?q=marc@domesweetdome.us.com or just ask me for it and I will send it to you as an attachment. If you don't understand, no worries, just ignore it and/or ask me to explain it further./)

1 0

Qt software compile problem
by Gustav Degreef 31 Oct '21

31 Oct '21

Hello folks, I am trying to compile a Qt program which is not available in ANY opensuse repo, that I can find. It is called Hello Speech example and it is used to control QtSpeech. Hello Speak Example is used to control the rate, rhythm, voice etc from QtSpeech. I got the software comes from git. The instructions on compiling the package are to run "qmake--qt5" followed by "make". When I run qmake-qt5, I get the following message: "Project ERROR: Unknown module(s) in QT: texttospeech" there was no other output at all. I searched for this and found a post (Ubuntu forum) with a similar build problem and same error message. It seems to indicate where the problem lies (some edits by me): reply ..."You state that you are using Qt 5.9 but the error message shows include directories to qt4..." op ..." Issue was that build was taking qt4 libs instead of Qt5, Fixed by adding |qt5-default| package" I am running opensuse 15.3 new install (not updated from 15.2, etc.). I installed the base development and kernel develpment softwae patterns via yast. I also ran: zypper install libqt5-qtbase-devel Which installed a bunch of packages. Am I missing some Qt5 packages? Any help would be appreciated, thanks. Gustav

3 7

comparing installed package list from a specific repo between two systems
by Istvan Gabor 30 Oct '21

30 Oct '21

Hello: I have two openSUSE 15.1 installations and would like to compare their installed packages from a given repo, let's say from packman. I would like to use diff program to compare the lists of installed packages. I can produce an installed package list of the packman repo using: zypper pa -ir <packman> > list.txt The problem with this approach is that the column widths are different depending on the installed packages' names and therefore I cannot use diff to compare the lists. (All lines will be different.) Is there a way to configure zypper how to format its output? Or is there any option that makes the output usable for diff? Other solutions are also welcome. Thanks, Istvan

3 3

vpn
by Douglas McGarrett 30 Oct '21

30 Oct '21

Two of my credit cards were hacked last month, so I would like to install and use a vpn to purchase items on the 'net. I downloaded and printed out a paper called YaST VPN module. It says to install the latest stable version us zypper: sudo zypper install yast2-vpn. I did that, and after a page full of error messages, it says: The following NEW package is going to be installed: ` yast2-vpn 1 new package to install. Overall download size: 32.1 KiB. Already cached: 0 B. After the operation, additional 110.0 KiB will be used. Continue? [y/n/v/...? shows all options] (y): y Retrieving package yast2-vpn-4.3.0-1.98.noarch (1/1), 32.1 KiB (110.0 KiB unpacked) Retrieving: yast2-vpn-4.3.0-1.98.noarch.rpm ............................................................[done] Checking for file conflicts: ...........................................................................[done] (1/1) Installing: yast2-vpn-4.3.0-1.98.noarch ..........................................................[done] I then invoked /usr/sbin/yast2 vpn and got a "VPN Gateway and Client page which asked me to name the vpn, so I called it newvpn. The page recognizes Connection name: newvpn. At this point, I don't know how to g further. Will some kind soul please help? --doug

8 20

can't copy many files
by Douglas McGarrett 30 Oct '21

30 Oct '21

I am tearing what little hair I still have! I have ~38 GiB of photos in a directory on the main drive. I need to copy these to a flash drive. I have a 128 GiB flash drive. I can only copy about 4 or 5 photos to the flash drive. (I am trying to do this with Dolphin as a source and File Manager as the destination.) After it copies about 5 files, it will not copy any more. Directory shows 14 MiB on the disk. (I have previously cleared the flash with gParted and told it to be fat32-- I need the flash to be readable on a Windows machine.) It is now showing in gParted as sda *and* sdb, with different sizes used, but no where near the full size of 128 GiB. This is not the only flash drive I have seen this problem with, but it's the only one I have that *should* be big enough to hold all the photos. ( I need to send them to an insurance company.) Failure message is "Could not write to /run/media/root/9458-DC92/insurance_pix/9:1_balun.jpg." I can't even try this on another computer without downloading all the files from the camera again. ( I will if necessary, but I don't understand the failure mode.) --doug

5 11

/dev/mapper/
by Istvan Gabor 27 Oct '21

27 Oct '21

Hello: Still my new openSUSE Leap 15.3 installation. Doing a df -h my root partition (the only partition at the moment) is listed as /dev/mapper/WDC.....-part2. Is this the normal way in Leap 15.3 or I enabled some service which does this? How could I get back the old /dev/sdx way? Thanks, Istvan

3 4

Leap 15.3 yast software repositories priority order
by Istvan Gabor 26 Oct '21

26 Oct '21

Hello: This is a new openSUSE Leap 15.3 installation. The order the repos are listed in yast software repositories window is strange (incorrect). All repos with priority number 99 are separeted in a different group from any other repos which have different priority number. For example if I set ascending order I get something like this (I write only the numbers): 60 120 150 180 99 (Default) 99 (Default) 99 (Default) 99 (Default) That is, everything not 99 is listed before 99 independently from its value. How could I fix this, it's really annoying. Thanks, Istvan

3 4

Tiny Letters
by Mark Misulich 25 Oct '21

25 Oct '21

Hi, I have been configuring my Asus laptop after I installed opensuse. I found by research that there has been an issue in the past with the Intel video driver that my laptop uses in linux. But that driver was placed in the 5.8 kernel and the problem went away. Those fixes have now been added into the updated 5.3 kernels, which are used in Leap 15.3. The driver is working, but it doesn't seem to be configured correctly from the start, and anything displayed in any window was displayed too small. So the issue to me seemed to be that the driver configuration was incorrect, at least for my laptop display. I haven't found any information about how to generally configure the driver overall (Intel TigerLake-LP Iris Xe Graphics [TGL GT2]). What I have done is to increase font and icon size, and window zoom to get a readable screen in each browser. Yet what I haven't found is how to increase the size of the font in the URL windows in a browser. They appear very tiny, as the rest of a browser screen used to present before I adjusted the settings. The adjustments I have made in the browser settings haven't affected the url window in the browser. Would anyone have ideas as to how to increase font size in that specific location? Thanks Mark

4 4

[oS-en] Unending sync
by Carlos E. R. 25 Oct '21

25 Oct '21

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, This afternoon I told this desktop machine to hibernate. My script to hibernate is this: date --rfc-3339=seconds echo Syncing sync date --rfc-3339=seconds echo "synced. Now screensaver" xscreensaver-command -lock sleep 3 #sudo chvt 10 #sleep 1 sudo /usr/local/sbin/beep sleep 1 #systemctl hibernate sudo /usr/bin/systemctl hibernate sleep 3 sudo /usr/local/sbin/beep #date --rfc-3339=seconds echo Well, at 19 hours it was still going at it: Telcontar:~ # hibernate 2021-10-23 15:23:17+02:00 Syncing It had been attempting to sync the filesystem for 4 hours, unsuccessfully. I do a separate sync previous to hibernating, because otherwise the hibernate stalls for long time not giving a hint of what is going on. What is going on? Well, the problem seems to be syncing the metadata of partition sdc9 (reiserfs, rotating rust), which holds /var/spool/news/. It can be a few millions of small files. Not really a news server, just the leafnode proxy. I know it takes very long after it runs /etc/cron.daily/leafnode, which calls "/usr/sbin/texpire": logger -p cron.warning -t texpire "CER: running leafnode's texpire without ionice" test -x /usr/sbin/texpire && su - news -c "/usr/sbin/texpire" logger -p cron.warning -t texpire "CER: finished texpire" sync -f /var/spool/news/ logger -p cron.warning -t texpire "CER: and synced -f" That sync can take half an hour normally, but that was not the time it runs: <9.4> 2021-10-22T23:45:01.361524+02:00 Telcontar texpire - - - CER: running leafnode's texpire without ionice ... <9.4> 2021-10-23T00:35:19.929058+02:00 Telcontar texpire - - - CER: finished texpire <9.4> 2021-10-23T00:37:09.833697+02:00 Telcontar texpire - - - CER: and synced -f So it should have not interfered. So what? Another possibility is that there is a cronjob that every 4 minutes tries to fetch news. So what I have done is disabling that job, and after a while, sync finished. So now my hibernate script will also need to stop news fetching. But how is it possible that sync is unable to cope and sync in time the metadata of a hundred new tiny files at most? Is it some new problem with reiserfs? - -- Cheers Carlos E. R. (from 15.2 x86_64 at Telcontar) -----BEGIN PGP SIGNATURE----- iHoEARECADoWIQQZEb51mJKK1KpcU/W1MxgcbY1H1QUCYXRaDBwccm9iaW4ubGlz dGFzQHRlbGVmb25pY2EubmV0AAoJELUzGBxtjUfViwEAoJFRSLa1AEeBDYv3uGZU gqh6eRzEAJ95ciPt1S737jGuo14SB+HPmsTYzA== =ls1+ -----END PGP SIGNATURE-----

5 14

Live Net 15.3 Upgrade Pointers
by Lew Wolfgang 25 Oct '21

25 Oct '21

Hi Folks, I've got to perform a live upgrade from Leap 15.2 to 15.3 on a system for which I don't have physical access. I'm thinking that a live zypper upgrade via remote ssh will work using the instructions for a console upgrade, listed here: https://en.opensuse.org/SDB:System_upgrade Does anyone have experience doing this? Any pointers would be appreciated before I break something! Regards, Lew

1 0