Mariadb syntax error in existing triggers after 12.10 point release update

2025-04-23 Thread Virgo Pärna
After installing 12.10 point release existing databases started to give syntax errors on existing triggers, when using FOR VAR IN NEW.FIELD1..NEW.FIELD2 DO loop. It works, when there are spaces around ".." - like: FOR VAR IN NEW.FIELD1 .. NEW.FIELD2 DO It also still works with

Mariadb syntax error in existing triggers after 12.10 point release update

2025-03-24 Thread Virgo Pärna
After installing 12.10 point release existing databases started to give syntax errors on existing triggers, when using FOR VAR IN NEW.FIELD1..NEW.FIELD2 DO loop. It works, when there are spaces around ".." - like: FOR VAR IN NEW.FIELD1 .. NEW.FIELD2 DO It also still works with

Re: yt-dlp search syntax?

2025-03-15 Thread Darac Marjal
On 12/03/2025 22:02, David Wright wrote: I typed caught a lite sneeze into google and got four hits; the top one was weWtRqoSUOI (official video), wL71FOgp1a4 (2016 remaster), BVef_GdeBs8 (looks like a disc), and SIsXdEw1hIU (Live 1998). Clicking on Videos at the top of the page gives me tho

Re: yt-dlp search syntax?

2025-03-13 Thread Greg
On 2025-03-13, mick.crane wrote: >>> > I meant "the following is of minor relevance.." > There wasn't a specific post this observation could reply to, it > happened to be yours. > Probably I should have removed the quoting. I see. Sorry for the misunderstanding. > mick > >

Re: yt-dlp search syntax?

2025-03-13 Thread mick.crane
On 2025-03-13 14:44, Greg wrote: On 2025-03-13, mick.crane wrote: On 2025-03-13 14:22, Greg wrote: On 2025-03-12, David Wright wrote: That's the way I normally look for videos, and ytsearch was also news to me. Is ytsearch limited to finding youtube videos, or more wideranging? One of the b

Re: yt-dlp search syntax?

2025-03-13 Thread Greg
On 2025-03-13, mick.crane wrote: > On 2025-03-13 14:22, Greg wrote: >> On 2025-03-12, David Wright wrote: >>> >>> That's the way I normally look for videos, and ytsearch was also >>> news to me. Is ytsearch limited to finding youtube videos, or more >>> wideranging? One of the benefits of yt-dlp

Re: yt-dlp search syntax?

2025-03-13 Thread Greg
t;ytsearch5:soundcloud:ambient music" Somewhere yesterday, I saw another syntax: yt-dlp "scsearch5:ambient music" would search soundcloud. I haven't tested any of this.

Re: yt-dlp search syntax?

2025-03-12 Thread David Wright
On Wed 12 Mar 2025 at 11:11:21 (-0400), Greg Wooledge wrote: > On Wed, Mar 12, 2025 at 14:33:11 -, Greg wrote: > > My robot says: > > > > One result: > > > > yt-dlp "ytsearch:QUERY" > > > > But for the life of me, after searching for twenty minutes, I can't > > determine whether this is co

Re: yt-dlp search syntax?

2025-03-12 Thread Huihang Yan
a, is a command line option, >Where I am stuck is getting a very specific search done. >Can anyone share the syntax? >Thanks, >Karen > > Hi Karen, I saw in the manpage of yt-dlp(1) that there is a '-x', '--extract-video' option: > Convert video files to audio

Re: yt-dlp search syntax?

2025-03-12 Thread Karen Lewellen
y specific search done. Can anyone share the syntax? Thanks, Karen My robot says: One result: yt-dlp "ytsearch:QUERY" But for the life of me, after searching for twenty minutes, I can't determine whether this is correct or not. Mutiple results: yt-dlp "ytsearchN:QUERY&qu

Re: yt-dlp search syntax?

2025-03-12 Thread Greg
On 2025-03-12, Greg Wooledge wrote: > > I don't think this is a thing I'll be doing much of. I would prefer > to do my search in the Youtube web site, pick which video I want, and > then download that one, rather than having some program pick one for > me. > Right for you and me. But the OP is v

Re: yt-dlp search syntax?

2025-03-12 Thread Greg Wooledge
On Wed, Mar 12, 2025 at 14:33:11 -, Greg wrote: > My robot says: > > One result: > > yt-dlp "ytsearch:QUERY" > > But for the life of me, after searching for twenty minutes, I can't > determine whether this is correct or not. hobbit:~$ wget https://github.com/yt-dlp/yt-dlp/releases/latest

Re: yt-dlp search syntax?

2025-03-12 Thread Greg
o produce audio files, like .mp3 and .m4a. She wants to *search*, though. That's the syntax we're looking for. > Best wishes, > Huihang > >

Re: yt-dlp search syntax?

2025-03-12 Thread Greg
, > Where I am stuck is getting a very specific search done. > Can anyone share the syntax? > Thanks, > Karen > > My robot says: One result: yt-dlp "ytsearch:QUERY" But for the life of me, after searching for twenty minutes, I can't determine whether this is corr

yt-dlp search syntax?

2025-03-11 Thread Karen Lewellen
: But cannot fully follow how to specify my search requirements. there are a zillion options for this tool, I am pleased for example to learn that converting items to mp3, or say m4a, is a command line option, Where I am stuck is getting a very specific search done. Can anyone share the syntax

Re: Syntax error in type_traits

2025-01-16 Thread Jesper Dybdal
On 2025-01-16 13:07, Greg Wooledge wrote: On Thu, Jan 16, 2025 at 12:38:29 +0100, Jesper Dybdal wrote: There is a syntax error (an erroneous ">" character) in     /usr/include/c++/12/type_traits in Bookworm.   So compiling any program that includes the header fails: e

Re: Syntax error in type_traits

2025-01-16 Thread Greg Wooledge
On Thu, Jan 16, 2025 at 12:38:29 +0100, Jesper Dybdal wrote: > There is a syntax error (an erroneous ">" character) in >     /usr/include/c++/12/type_traits > in Bookworm.   So compiling any program that includes the header > fails: > > echo "#include " &

Re: Syntax error in type_traits

2025-01-16 Thread Andy Smith
Hi Jesper, On Thu, Jan 16, 2025 at 12:38:29PM +0100, Jesper Dybdal wrote: > There is a syntax error (an erroneous ">" character) in >     /usr/include/c++/12/type_traits > in Bookworm. I do not experience this on my Debian 12. > > In file included from /usr/include/

Syntax error in type_traits

2025-01-16 Thread Jesper Dybdal
There is a syntax error (an erroneous ">" character) in     /usr/include/c++/12/type_traits in Bookworm.   So compiling any program that includes the header fails: echo "#include " >error.cpp g++ -c error.cpp Results in: In file included from /usr/include/c+

Re: find and it uncommon syntax - grrrrrrrrr

2024-02-10 Thread gene heskett
On 2/10/24 16:07, Greg Wooledge wrote: On Sat, Feb 10, 2024 at 02:58:24PM -0600, Nicholas Geovanis wrote: On Sat, Feb 10, 2024, 2:46 PM gene heskett wrote: Greetings; I have misplaced file someplace in /home/gene. its name is bpim5*shelf.scad Assuming that you are searching in the current

Re: find and it uncommon syntax - grrrrrrrrr

2024-02-10 Thread Andy Smith
Hello, On Sat, Feb 10, 2024 at 06:03:39PM -0500, gene heskett wrote: > On 2/10/24 15:55, Greg Wooledge wrote: > > find . -iname 'bpim5*shelf.scad' > > Thank you Greg, it worked and 4 more copies are under construction now, but > why is this not in the man page? Mind boggling. Why can Gene not lo

Re: find and it uncommon syntax - grrrrrrrrr

2024-02-10 Thread Andy Smith
Hello, On Sat, Feb 10, 2024 at 03:46:09PM -0500, gene heskett wrote: > I have misplaced file someplace in /home/gene. > its name is bpim5*shelf.scad > As usual it outputs 100,000 filenames, none of which is the one I am looking > for. How in heck do you shut this thing up so it only spits out > /t

Re: find and it uncommon syntax - grrrrrrrrr

2024-02-10 Thread gene heskett
On 2/10/24 15:55, Greg Wooledge wrote: find . -iname 'bpim5*shelf.scad' Thank you Greg, it worked and 4 more copies are under construction now, but why is this not in the man page? Mind boggling. Cheers, Gene Heskett, CET. -- "There are four boxes to be used in defense of liberty: soap, bal

Re: find and it uncommon syntax - grrrrrrrrr

2024-02-10 Thread Greg Wooledge
On Sat, Feb 10, 2024 at 02:58:24PM -0600, Nicholas Geovanis wrote: > On Sat, Feb 10, 2024, 2:46 PM gene heskett wrote: > > > Greetings; > > > > I have misplaced file someplace in /home/gene. > > its name is bpim5*shelf.scad > > > > Assuming that you are searching in the current working directory

Re: find and it uncommon syntax - grrrrrrrrr

2024-02-10 Thread Nicholas Geovanis
On Sat, Feb 10, 2024, 2:46 PM gene heskett wrote: > Greetings; > > I have misplaced file someplace in /home/gene. > its name is bpim5*shelf.scad > Assuming that you are searching in the current working directory: find bpim* -print | grep 'shelf.scad' As usual it outputs 100,000 filenames, non

Re: find and it uncommon syntax - grrrrrrrrr

2024-02-10 Thread Greg Wooledge
On Sat, Feb 10, 2024 at 03:46:09PM -0500, gene heskett wrote: > I have misplaced file someplace in /home/gene. > its name is bpim5*shelf.scad > As usual it outputs 100,000 filenames, none of which is the one I am looking cd find . -iname 'bpim5*shelf.scad'

find and it uncommon syntax - grrrrrrrrr

2024-02-10 Thread gene heskett
Greetings; I have misplaced file someplace in /home/gene. its name is bpim5*shelf.scad As usual it outputs 100,000 filenames, none of which is the one I am looking for. How in heck do you shut this thing up so it only spits out /the/path/to/the/file its looking for it it even found it? And wh

Re: smartctl cannot access my storage, need syntax help

2024-01-28 Thread David Wright
On Thu 25 Jan 2024 at 12:24:21 (-0500), Roy J. Tellason, Sr. wrote: > On Thursday 25 January 2024 09:03:36 am Anssi Saari wrote: > > On Tue 23 Jan 2024 at 06:32:54 (-0500), gene heskett wrote: > > > On 1/23/24 06:12, Gremlin wrote: > > > > On 1/23/24 06:04, gene heskett wrote: > > > > > On 1/23/24

Re: smartctl cannot access my storage, need syntax help

2024-01-26 Thread Anssi Saari
"Roy J. Tellason, Sr." writes: > On Thursday 25 January 2024 09:03:36 am Anssi Saari wrote: >> Western Digital at least claims to have solved the leaking >> problem with helium and since they've been making those drives for over >> a decade, I think it's solved. > > Your source for this? The int

Re: smartctl cannot access my storage, need syntax help

2024-01-25 Thread Roy J. Tellason, Sr.
On Thursday 25 January 2024 09:03:36 am Anssi Saari wrote: > Western Digital at least claims to have solved the leaking > problem with helium and since they've been making those drives for over > a decade, I think it's solved. Your source for this? -- Member of the toughest, meanest, deadliest,

Re: smartctl cannot access my storage, need syntax help

2024-01-25 Thread Anssi Saari
gene heskett writes: > I carefully note, the use of Helium and its problems is very carefully > ignored. I suppose helium is not required for SMR drives and could be used in CMR drives too... Western Digital at least claims to have solved the leaking problem with helium and since they've been ma

Re: Powered USB hub [was: Re: smartctl cannot access my storage, need syntax help]

2024-01-25 Thread Anssi Saari
Max Nikulin writes: > Purchasing a powered USB hub, I made a mistake. I have not checked > compatibility with hubctl in advance. > https://github.com/mvp/uhubctl/ Wow, that's very cool. I wonder if there's anything similar for USB switches? I have one that's software controllable but it's not gr

Re: smartctl cannot access my storage, need syntax help

2024-01-24 Thread Karl Vogel
On Tue, Jan 23, 2024 at 06:05:29AM -0500, gene heskett wrote: > On 1/23/24 00:30, Karl Vogel wrote: > >>> On 1/22/24 11:31, gene heskett wrote: > > > > G> How does an 8T backup server sound for another $200 in hdwe? Very > > G> enticing and I do have the sheckel's. > > > > https://www.amazon.com/d

Re: smartctl cannot access my storage, need syntax help

2024-01-23 Thread gene heskett
On 1/22/24 22:48, Stefan Monnier wrote: some sort of 2T SSD's that comes as a usb-c drive, skipping the sata convertor entirely at $27/copy. If it works as an 8T lvm with a 2T holding AFAIK 2T for $27 doesn't exist yet in the current real world. You can find a fair number of creatively sized US

Re: smartctl cannot access my storage, need syntax help

2024-01-23 Thread gene heskett
On 1/23/24 06:12, Gremlin wrote: On 1/23/24 06:04, gene heskett wrote: On 1/23/24 00:30, Karl Vogel wrote: On 1/22/24 11:31, gene heskett wrote: G> How does an 8T backup server sound for another $200 in hdwe?  Very G> enticing and I do have the sheckel's. https://www.amazon.com/dp/B07CQJBSQL

Re: smartctl cannot access my storage, need syntax help

2024-01-23 Thread Gremlin
On 1/23/24 06:04, gene heskett wrote: On 1/23/24 00:30, Karl Vogel wrote: On 1/22/24 11:31, gene heskett wrote: G> How does an 8T backup server sound for another $200 in hdwe?  Very G> enticing and I do have the sheckel's. https://www.amazon.com/dp/B07CQJBSQL Seagate Desktop 8TB external Hard

Re: smartctl cannot access my storage, need syntax help

2024-01-23 Thread gene heskett
On 1/23/24 02:31, David Christensen wrote: On 1/22/24 19:55, gene heskett wrote: On 1/22/24 21:59, David Christensen wrote: On 1/22/24 18:44, gene heskett wrote: On 1/22/24 18:46, David Christensen wrote: On 1/22/24 11:31, gene heskett wrote: How does an 8T backup server sound for another $20

Re: smartctl cannot access my storage, need syntax help

2024-01-23 Thread gene heskett
On 1/23/24 00:30, Karl Vogel wrote: On 1/22/24 11:31, gene heskett wrote: G> How does an 8T backup server sound for another $200 in hdwe? Very G> enticing and I do have the sheckel's. https://www.amazon.com/dp/B07CQJBSQL Seagate Desktop 8TB external Hard Drive, 3.5 Inch, USB 3.0 STGY8000400 $

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread David Christensen
On 1/22/24 19:55, gene heskett wrote: On 1/22/24 21:59, David Christensen wrote: On 1/22/24 18:44, gene heskett wrote: On 1/22/24 18:46, David Christensen wrote: On 1/22/24 11:31, gene heskett wrote: How does an 8T backup server sound for another $200 in hdwe?  Very enticing and I do have the

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread Karl Vogel
>> On 1/22/24 11:31, gene heskett wrote: G> How does an 8T backup server sound for another $200 in hdwe? Very G> enticing and I do have the sheckel's. https://www.amazon.com/dp/B07CQJBSQL Seagate Desktop 8TB external Hard Drive, 3.5 Inch, USB 3.0 STGY8000400 $168.18 What if you buy two, use one

Powered USB hub [was: Re: smartctl cannot access my storage, need syntax help]

2024-01-22 Thread Max Nikulin
On 23/01/2024 10:55, gene heskett wrote: hub: Purchasing a

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread gene heskett
On 1/22/24 21:59, David Christensen wrote: On 1/22/24 18:44, gene heskett wrote: On 1/22/24 18:46, David Christensen wrote: On 1/22/24 11:31, gene heskett wrote: How does an 8T backup server sound for another $200 in hdwe?  Very enticing and I do have the sheckel's. What hardware? I clicked

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread Stefan Monnier
> some sort of 2T SSD's that comes as a usb-c drive, skipping the sata > convertor entirely at $27/copy. If it works as an 8T lvm with a 2T holding AFAIK 2T for $27 doesn't exist yet in the current real world. You can find a fair number of creatively sized USB disks in that price range, but they a

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread David Christensen
On 1/22/24 18:44, gene heskett wrote: On 1/22/24 18:46, David Christensen wrote: On 1/22/24 11:31, gene heskett wrote: How does an 8T backup server sound for another $200 in hdwe?  Very enticing and I do have the sheckel's. What hardware? I clicked on place order, for a 7 port powered usb3 h

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread gene heskett
On 1/22/24 18:46, David Christensen wrote: On 1/22/24 11:31, gene heskett wrote: On 1/22/24 12:54, David Christensen wrote: Perhaps it is time to switch to another backup system, or build your own. .. That I'm contemplating, using a pi clone but still running the amanda I just installed all 3

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread David Christensen
On 1/22/24 11:31, gene heskett wrote: On 1/22/24 12:54, David Christensen wrote: Perhaps it is time to switch to another backup system, or build your own. .. That I'm contemplating, using a pi clone but still running the amanda I just installed all 3 debs of on a bananapi-m5. Okay. How do

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread Stefan Monnier
> That I'm contemplating, using a pi clone but still running the amanda I just > installed all 3 debs of on a bananapi-m5. How does an 8T backup server > sound for another $200 in hdwe? Very enticing and I do have the sheckel's. I remember Amanda fondly from the days when I was backing up a labs

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread gene heskett
On 1/22/24 12:54, David Christensen wrote: On 1/22/24 03:23, gene heskett wrote: On 1/22/24 04:46, David Christensen wrote: It appears Amanda has a script API for both the client and the server: https://manpages.debian.org/buster/amanda-common/amanda-scripts.7.en.html ... All this is possible

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread David Christensen
On 1/22/24 03:23, gene heskett wrote: On 1/22/24 04:46, David Christensen wrote: It appears Amanda has a script API for both the client and the server: https://manpages.debian.org/buster/amanda-common/amanda-scripts.7.en.html ... All this is possible David, but needs someone to do it. So far ou

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread gene heskett
On 1/22/24 04:46, David Christensen wrote: On 1/21/24 21:42, gene heskett wrote: On 1/21/24 18:29, David Christensen wrote: On 1/21/24 14:48, gene heskett wrote: On 1/21/24 16:13, David Christensen wrote: On 1/21/24 03:47, gene heskett wrote: On 1/21/24 01:33, David Christensen wrote: 3.  Fo

Re: smartctl cannot access my storage, need syntax help

2024-01-22 Thread David Christensen
On 1/21/24 21:42, gene heskett wrote: On 1/21/24 18:29, David Christensen wrote: On 1/21/24 14:48, gene heskett wrote: On 1/21/24 16:13, David Christensen wrote: On 1/21/24 03:47, gene heskett wrote: On 1/21/24 01:33, David Christensen wrote: 3.  For Amanda, either add more HDD's to the stora

Re: smartctl cannot access my storage, need syntax help

2024-01-21 Thread gene heskett
On 1/21/24 18:29, David Christensen wrote: On 1/21/24 14:48, gene heskett wrote: On 1/21/24 16:13, David Christensen wrote: On 1/21/24 03:47, gene heskett wrote: On 1/21/24 01:33, David Christensen wrote: I am still uncertain if those are internal SSD errors or SATA errors. Please check if yo

Re: smartctl cannot access my storage, need syntax help

2024-01-21 Thread David Christensen
On 1/21/24 14:48, gene heskett wrote: On 1/21/24 16:13, David Christensen wrote: On 1/21/24 03:47, gene heskett wrote: On 1/21/24 01:33, David Christensen wrote: I am still uncertain if those are internal SSD errors or SATA errors. Please check if you see matching errors in dmesg(1). There a

Re: smartctl cannot access my storage, need syntax help

2024-01-21 Thread gene heskett
On 1/21/24 16:13, David Christensen wrote: On 1/21/24 03:47, gene heskett wrote: On 1/21/24 01:33, David Christensen wrote: I am still uncertain if those are internal SSD errors or SATA errors. Please check if you see matching errors in dmesg(1). There aren't any. Those hours would very close

Re: smartctl cannot access my storage, need syntax help

2024-01-21 Thread David Christensen
On 1/21/24 03:47, gene heskett wrote: On 1/21/24 01:33, David Christensen wrote: I am still uncertain if those are internal SSD errors or SATA errors. Please check if you see matching errors in dmesg(1). There aren't any. Those hours would very closely correspond to my attempts to rsync and t

Re: smartctl cannot access my storage, need syntax help

2024-01-21 Thread gene heskett
On 1/21/24 04:35, Max Nikulin wrote: On 21/01/2024 03:23, gene heskett wrote: Right now nothing in the system is north of 32C, might get to 36C at the end of a 9 minute build of something in OpenSCAD. I would say that 53°C and even 44°C is well above 36°C you expected: On 21/01/2024 12:48,

Re: smartctl cannot access my storage, need syntax help

2024-01-21 Thread gene heskett
On 1/21/24 01:33, David Christensen wrote: On 1/20/24 21:48, gene heskett wrote: New -x version for this SSD attached > SMART Attributes Data Structure revision number: 1 > Vendor Specific SMART Attributes with Thresholds: > ID# ATTRIBUTE_NAME  FLAGS    VALUE WORST THRESH FAIL RAW_V

Re: smartctl cannot access my storage, need syntax help

2024-01-21 Thread Max Nikulin
On 21/01/2024 03:23, gene heskett wrote: Right now nothing in the system is north of 32C, might get to 36C at the end of a 9 minute build of something in OpenSCAD. I would say that 53°C and even 44°C is well above 36°C you expected: On 21/01/2024 12:48, gene heskett wrote: SCT Status Vers

Re: smartctl cannot access my storage, need syntax help

2024-01-20 Thread David Christensen
On 1/20/24 21:48, gene heskett wrote: New -x version for this SSD attached > SMART Attributes Data Structure revision number: 1 > Vendor Specific SMART Attributes with Thresholds: > ID# ATTRIBUTE_NAME FLAGSVALUE WORST THRESH FAIL RAW_VALUE > 5 Reallocated_Sector_Ct PO--CK 094

Re: smartctl cannot access my storage, need syntax help

2024-01-20 Thread gene heskett
On 1/21/24 00:30, Max Nikulin wrote: On 21/01/2024 03:23, gene heskett wrote: On 1/20/24 10:24, Max Nikulin wrote: On 19/01/2024 06:10, gene heskett wrote: ID# ATTRIBUTE_NAME  FLAG VALUE WORST THRESH TYPE UPDATED WHEN_FAILED RAW_VALUE 190 Airflow_Temperature_Cel 0x0032   071   04

Re: smartctl cannot access my storage, need syntax help

2024-01-20 Thread Max Nikulin
On 21/01/2024 03:23, gene heskett wrote: On 1/20/24 10:24, Max Nikulin wrote: On 19/01/2024 06:10, gene heskett wrote: ID# ATTRIBUTE_NAME  FLAG VALUE WORST THRESH TYPE UPDATED WHEN_FAILED RAW_VALUE 190 Airflow_Temperature_Cel 0x0032   071   049   000    Old_age Always   -   

Re: smartctl cannot access my storage, need syntax help

2024-01-20 Thread gene heskett
On 1/20/24 10:24, Max Nikulin wrote: On 19/01/2024 06:10, gene heskett wrote: SMART Attributes Data Structure revision number: 1 Vendor Specific SMART Attributes with Thresholds: ID# ATTRIBUTE_NAME  FLAG VALUE WORST THRESH TYPE UPDATED  WHEN_FAILED RAW_VALUE 179 Used_Rsvd_Blk_C

Re: smartctl cannot access my storage, need syntax help

2024-01-20 Thread Max Nikulin
On 19/01/2024 06:10, gene heskett wrote: SMART Attributes Data Structure revision number: 1 Vendor Specific SMART Attributes with Thresholds: ID# ATTRIBUTE_NAME FLAG VALUE WORST THRESH TYPE UPDATED WHEN_FAILED RAW_VALUE 179 Used_Rsvd_Blk_Cnt_Tot 0x0013 085 085 010P

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread David Christensen
On 1/19/24 21:34, gene heskett wrote: On 1/19/24 20:29, Felix Miata wrote: gene heskett composed on 2024-01-19 19:09 (UTC-0500): On 1/19/24 15:56, David Christensen wrote: https://www.cablematters.com/pc-187-156-3-pack-straight-60-gbps-sata-iii-cable.aspx Cheap enough at 18", ordered 4 pack

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread gene heskett
On 1/19/24 20:29, Felix Miata wrote: gene heskett composed on 2024-01-19 19:09 (UTC-0500): On 1/19/24 15:56, David Christensen wrote: No sign of that snipped stuff. https://www.cablematters.com/pc-187-156-3-pack-straight-60-gbps-sata-iii-cable.aspx Cheap enough at 18", ordered 4 packs o

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread Felix Miata
gene heskett composed on 2024-01-19 19:09 (UTC-0500): > On 1/19/24 15:56, David Christensen wrote: > No sign of that snipped stuff. > >> https://www.cablematters.com/pc-187-156-3-pack-straight-60-gbps-sata-iii-cable.aspx > Cheap enough at 18", ordered 4 packs of 3 for service & build stock, >

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread gene heskett
On 1/19/24 15:56, David Christensen wrote: No sign of that snipped stuff. https://www.cablematters.com/pc-187-156-3-pack-straight-60-gbps-sata-iii-cable.aspx Cheap enough at 18", ordered 4 packs of 3 for service & build stock, thanks David. I call that the "wiggle" test. So do I but I've

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread David Christensen
On 1/18/24 23:23, gene heskett wrote: On 1/19/24 00:55, David Christensen wrote: I am unclear if those errors are inside the SSD or if they are the SATA communications link between the SSD and the motherbaord or HBA port and/or main memory (?).  Does dmesg(1) show anything? I'm not sure what

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread David Christensen
On 1/19/24 00:03, Anssi Saari wrote: My only mdraid was on raw partitions but that never had any issues. I think zfs effectively does the same, no partitions. You can do it either way on ZFS. David

Re: To partition or not to partition MD arrays (Was Re: smartctl cannotaccess my storage, need syntax help)

2024-01-19 Thread Franco Martelli
On 19/01/24 at 20:14, Nicolas George wrote: Franco Martelli (12024-01-19): One case against using partitions on mdraid: if your array gets messed up, you get to recreate those partition tables yourself and that's just hilarious if you don't have a backup. Happened to a friend of mine, reason was

Re: To partition or not to partition MD arrays (Was Re: smartctl cannotaccess my storage, need syntax help)

2024-01-19 Thread Nicolas George
Franco Martelli (12024-01-19): > > One case against using partitions on mdraid: if your array gets messed > > up, you get to recreate those partition tables yourself and that's just > > hilarious if you don't have a backup. Happened to a friend of mine, > > reason was a UPS brownout. > How can I ge

Re: To partition or not to partition MD arrays (Was Re: smartctl cannotaccess my storage, need syntax help)

2024-01-19 Thread Franco Martelli
On 19/01/24 at 09:03, Anssi Saari wrote: One case against using partitions on mdraid: if your array gets messed up, you get to recreate those partition tables yourself and that's just hilarious if you don't have a backup. Happened to a friend of mine, reason was a UPS brownout. How can I get a

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread gene heskett
On 1/19/24 04:50, Thomas Schmitt wrote: Hi, Anssi Saari It does seem strange to me, even in MS-DOS era I was able to set a terminal scrollback to 5000 lines without issue, when RAM was maybe 4 MB and a DOS terminal program probably had access to way less than that. I have no problems with 130

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread gene heskett
On 1/19/24 03:12, Anssi Saari wrote: gene heskett writes: The OOM death of the system was the xfce4 terminal apparently being set for unlimited scrollback and that was eating the memory. Switching to Konsole with has the ability to control the scrollback to 200 lines, and its taken all 32G's a

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread Thomas Schmitt
Hi, Anssi Saari > It does seem strange to me, even in MS-DOS era I was able to set a > terminal scrollback to 5000 lines without issue, when RAM was maybe 4 MB > and a DOS terminal program probably had access to way less than that. I have no problems with 130 xterms of 10,000 lines each. > So d

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread Anssi Saari
gene heskett writes: > The OOM death of the system was the xfce4 terminal apparently being > set for unlimited scrollback and that was eating the memory. Switching > to Konsole with has the ability to control the scrollback to 200 > lines, and its taken all 32G's as .cache and 1536 1k blocks of s

Re: smartctl cannot access my storage, need syntax help

2024-01-19 Thread Anssi Saari
Franco Martelli writes: > I don't know if it is a good idea, in fact it exists a special > partition type for RAID array listed in fdisk, I used that for my > RAID: One case against using partitions on mdraid: if your array gets messed up, you get to recreate those partition tables yourself and

Re: smartctl cannot access my storage, need syntax help

2024-01-18 Thread gene heskett
On 1/19/24 00:55, David Christensen wrote: On 1/18/24 15:10, gene heskett wrote: On 1/18/24 16:08, David Christensen wrote: On 1/18/24 03:47, gene heskett wrote: I have issued a smartctl -tlong on all 4 drives, results in about 3 hours. A SMART long test should find and fix any read errors.

Re: smartctl cannot access my storage, need syntax help

2024-01-18 Thread David Christensen
On 1/18/24 15:10, gene heskett wrote: On 1/18/24 16:08, David Christensen wrote: On 1/18/24 03:47, gene heskett wrote: I have issued a smartctl -tlong on all 4 drives, results in about 3 hours. A SMART long test should find and fix any read errors. Which has now been done on all 4 SSD. but

Re: smartctl cannot access my storage, need syntax help

2024-01-18 Thread David Wright
On Thu 18 Jan 2024 at 00:57:07 (-0800), David Christensen wrote: > On 1/17/24 22:44, gene heskett wrote: > > One thing that bothers me is there is no way the installers parted > > shows partition names for non-raid disks. To me that is a serious > > bug. It appears from the help that it can LABEL a

Re: smartctl cannot access my storage, need syntax help

2024-01-18 Thread gene heskett
On 1/18/24 16:08, David Christensen wrote: On 1/18/24 03:47, gene heskett wrote: On 1/18/24 03:57, David Christensen wrote: The old /home RAID10 still has its metadata on disk.  I would install the "mdadm" package, edit /etc/fstab, copy and rework the old /home line (new mount point, add optio

Re: smartctl cannot access my storage, need syntax help

2024-01-18 Thread David Christensen
On 1/18/24 03:47, gene heskett wrote: On 1/18/24 03:57, David Christensen wrote: The old /home RAID10 still has its metadata on disk.  I would install the "mdadm" package, edit /etc/fstab, copy and rework the old /home line (new mount point, add option "ro"), create the mount point, and mount.

Re: To partition or not to partition MD arrays (Was Re: smartctl cannotaccess my storage, need syntax help)

2024-01-18 Thread Andy Smith
Hi, On Thu, Jan 18, 2024 at 10:28:30AM -0600, Nicholas Geovanis wrote: > Sounds like this group has finally achieved a long overdue consensus. How > many times since LVM was ready for root/boot volumes have I been told that > using partitions was necessary good practice. Even had that in job > int

Re: smartctl cannot access my storage, need syntax help

2024-01-18 Thread Curt
On 2024-01-17, Thomas Schmitt wrote: > Hi, > > Curt wrote: >> I discovered a couple of discussions of the phenomenon, the upshot of which >> were: >> 1) That's what you get when you purchase cheap SSDs. >> https://www.reddit.com/r/truenas/comments/s0rrpo/two_sata_ssds_with_identical_serial_numbers

normally start new xterms [was: Re: smartctl cannot access my storage, need syntax help]

2024-01-18 Thread Max Nikulin
On 18/01/2024 04:20, Thomas Schmitt wrote: I normally start new xterms by xterm -ls -geometry 80x24 -bg wheat -fg black -sl 1 +sb & Options may be put into ~/.Xresources xterm*vt100.saveLines: 1 xterm*VT100.background: wheat xterm*VT100.foreground: black ! etc Use xrdb to merge c

Re: To partition or not to partition MD arrays (Was Re: smartctl cannotaccess my storage, need syntax help)

2024-01-18 Thread Nicholas Geovanis
On Wed, Jan 17, 2024, 9:35 PM gene heskett wrote: > On 1/17/24 19:54, Steve McIntyre wrote: > > Andy Smith wrote: > ... > >> Then there will just be people going by taste. > >> > >> Personally I still put them directly on drives. If I ever get taken > >> out by one of those crappy motherboard

Re: To partition or not to partition MD arrays (Was Re: smartctl cannot access my storage, need syntax help)

2024-01-18 Thread Steve McIntyre
Hey Andy. Andy Smith wrote: > >On Thu, Jan 18, 2024 at 12:53:43AM +, Steve McIntyre wrote: >> I'm clearly a member of a third group of people,,, :-) > >Oh, I didn't mean to imply that those going by taste were in a >minority! Taste, or possibly, "just never thought about it" could >well be the

Re: To partition or not to partition MD arrays (Was Re: smartctl cannot access my storage, need syntax help)

2024-01-18 Thread Andy Smith
Hello, On Thu, Jan 18, 2024 at 12:53:43AM +, Steve McIntyre wrote: > I'm clearly a member of a third group of people,,, :-) Oh, I didn't mean to imply that those going by taste were in a minority! Taste, or possibly, "just never thought about it" could well be the biggest group. I was only ta

Re: smartctl cannot access my storage, need syntax help

2024-01-18 Thread gene heskett
On 1/18/24 03:57, David Christensen wrote: On 1/17/24 22:44, gene heskett wrote:>> On 1/18/24 00:50, David Christensen wrote: The migration took two passes because udev can't make up its alleged mind so I was finally forced to use the rescue mode to edit fstab to mount it by UUID and that worke

Re: smartctl cannot access my storage, need syntax help

2024-01-18 Thread David Christensen
On 1/17/24 22:44, gene heskett wrote:>> On 1/18/24 00:50, David Christensen wrote: The migration took two passes because udev can't make up its alleged mind so I was finally forced to use the rescue mode to edit fstab to mount it by UUID and that worked, I've got /home on the copy right now.

Re: smartctl cannot access my storage, need syntax help

2024-01-17 Thread Thomas Schmitt
Hi, gene heskett wrote: > > where did the extra 19.4G's come from? Can filesystem > > ext4's overhead account for that? In an earlier mail: > > > command line: rsync -a --bwlimit=10m --fsync --progress /home/ > > > /mnt/homevol David Christensen wrote: > Please RTFM rsync(1) to choose your opt

Re: smartctl cannot access my storage, need syntax help

2024-01-17 Thread Charles Curley
On Tue, 16 Jan 2024 21:10:28 -0500 gene heskett wrote: > gene@coyote:~/src/klipper-docs$ lsblk -d -o > NAME,MAJ:MIN,MODEL,SERIAL,WWN /dev/sd[hijkl] > NAME MAJ:MIN MODEL SERIAL WWN > sdh8:112 Gigastone SSD GSTD02TB230102 > sdi8:128 Gigastone SSD GST02TBG221146 > sdj8:

Re: smartctl cannot access my storage, need syntax help

2024-01-17 Thread gene heskett
On 1/18/24 00:50, David Christensen wrote: On 1/17/24 20:20, gene heskett wrote: On 1/17/24 19:58, David Christensen wrote: On 1/17/24 15:58, gene heskett wrote: Now the question is how did it make this: homevol s/b very close to /home  in size but: root@coyote:~# df && free Filesystem  1

Re: smartctl cannot access my storage, need syntax help

2024-01-17 Thread David Christensen
On 1/17/24 20:20, gene heskett wrote: On 1/17/24 19:58, David Christensen wrote: On 1/17/24 15:58, gene heskett wrote: Now the question is how did it make this: homevol s/b very close to /home  in size but: root@coyote:~# df && free Filesystem  1K-blocks  Used  Available Use% Mounted o

Re: smartctl cannot access my storage, need syntax help

2024-01-17 Thread gene heskett
On 1/17/24 19:58, David Christensen wrote: On 1/17/24 15:58, gene heskett wrote: Now the question is how did it make this: homevol s/b very close to /home  in size but: root@coyote:~# df && free Filesystem  1K-blocks  Used  Available Use% Mounted on udev 16327704 0  

Re: smartctl cannot access my storage, need syntax help

2024-01-17 Thread David Wright
On Wed 17 Jan 2024 at 15:34:09 (-0500), gene heskett wrote: > On 1/17/24 12:27, Thomas Schmitt wrote: > > David Christensen wrote: > > > I suspect the conflicting serial numbers are causing problems in the > > > kernel, > > > as indicated by the /dev/disk/by-id/* problems. > > > > That's not in t

Re: To partition or not to partition MD arrays (Was Re: smartctl cannotaccess my storage, need syntax help)

2024-01-17 Thread gene heskett
On 1/17/24 19:54, Steve McIntyre wrote: Andy Smith wrote: The newer set of people recommending partitions are mostly doing so because there's been a few incidents of "helpful" PC motherboards detecting on boot what they think is a corrupt GPT, and replacing it with a blank one, damaging the RAI

Re: smartctl cannot access my storage, need syntax help

2024-01-17 Thread David Christensen
On 1/17/24 15:58, gene heskett wrote: Now the question is how did it make this: homevol s/b very close to /home  in size but: root@coyote:~# df && free Filesystem  1K-blocks  Used  Available Use% Mounted on udev 16327704 0   16327704   0% /dev tmpfs 327268

Re: To partition or not to partition MD arrays (Was Re: smartctl cannot access my storage, need syntax help)

2024-01-17 Thread Steve McIntyre
Andy Smith wrote: > >The newer set of people recommending partitions are mostly doing so >because there's been a few incidents of "helpful" PC motherboards >detecting on boot what they think is a corrupt GPT, and replacing it >with a blank one, damaging the RAID. This is a real thing that has >happ

Re: smartctl cannot access my storage, need syntax help

2024-01-17 Thread gene heskett
On 1/17/24 16:45, David Christensen wrote: On 1/17/24 12:30, gene heskett wrote: By LABELing the partitions uniquely, that problem so far as I can see, is solved. Okay. So, are you confident that your motherboard ports, HBA ports, and SSD's are all working correctly now? The OOM death of

  1   2   3   4   5   6   7   8   9   >