--- Log opened Fri Nov 15 00:00:09 2019 00:13 -!- kabaum [~kabaum@2001:9b1:efd:9b00::281] has joined #c-lightning 00:35 < m-schmoock> cdecker: the assert we added yesterday causes troubles wallet.c +3468 => assert(!db_column_is_null(stmt, 2) && !db_column_is_null(stmt, 3)); 00:35 < m-schmoock> I have some transactions in my DB that have a tx index without having a blockheight 00:38 < m-schmoock> for example testnet transaction 592d3645139056365394308c50acc1cd91e15c6163ed133395f13edbb524f864 is actually in block 1518215 but my lightningd does not have a blockheit for it 00:38 < m-schmoock> but whats really fishy is, it knows the tx index (16) 00:39 < m-schmoock> so the assert can fail since at least my node has corrupt data in sqlite? 00:41 < m-schmoock> after doing dev-rescan-outputs this is restored 00:41 < m-schmoock> but we have an issue somewhere else ... 00:45 < m-schmoock> nah, dev-rescan-outputs didnt help 00:45 < m-schmoock> (i commented out the assert) 00:45 < m-schmoock> it still has an txindex without a blockheight 00:48 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 245 seconds] 00:53 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 00:53 < m-schmoock> or we had a problem in the past and my database state is no good, in any case thats not good 00:54 < m-schmoock> sqlite> SELECT HEX(t.id), t.blockheight, t.txindex FROM transactions t WHERE t.txindex = 16; 00:54 < m-schmoock> 64F824B5DB3EF1953313ED63615CE191CDC1AC508C3094533656901345362D59||16 00:56 < m-schmoock> we could address that by adding functionality like dev-rescan-transactions and call it proactively when we detect transactions having partial information 00:59 < m-schmoock> sqlite> SELECT HEX(t.id), t.blockheight, t.txindex FROM transactions t WHERE t.txindex > 0 and t.blockheight IS NULL; 00:59 < m-schmoock> 6DBC6AF797A52DF98F6B9B4657E464ECD360C3480A57CA2645CBBE301F5F5285||11 00:59 < m-schmoock> 64F824B5DB3EF1953313ED63615CE191CDC1AC508C3094533656901345362D59||16 01:00 < m-schmoock> also on my mainnet node: 01:00 < m-schmoock> SELECT HEX(t.id), t.blockheight, t.txindex FROM transactions t WHERE t.txindex > 0 and t.blockheight IS NULL; 01:00 < m-schmoock> CB785ABCC3971F94607A270009D161460D1D63C8E915CFEC933320DF37ED372F||1663 01:00 < m-schmoock> 5E35A558D3061E6EC6D91A89346639DEDAAA704281A4F7B597D63EB6591307B8||855 01:08 < m-schmoock> I added an issue: https://github.com/ElementsProject/lightning/issues/3265 01:43 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 265 seconds] 01:45 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 01:51 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-nfufoseoysnzgsxq] has left #c-lightning [] 01:51 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-nfufoseoysnzgsxq] has joined #c-lightning 01:54 -!- kristapsk [~KK@gateway/tor-sasl/kristapsk] has quit [Remote host closed the connection] 02:04 -!- kexkey [~kexkey@37.120.205.233] has quit [Ping timeout: 265 seconds] 02:05 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 250 seconds] 02:12 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 02:22 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 250 seconds] 02:25 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 02:50 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 245 seconds] 02:52 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 02:59 < sword_smith> Is the dust limit different than 546 when sending to a segwit address? 03:10 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 240 seconds] 03:13 -!- cubancorona2 [~cubancoro@pool-72-77-31-161.pitbpa.ftas.verizon.net] has joined #c-lightning 03:15 -!- cubancorona [~cubancoro@pool-72-77-31-161.pitbpa.ftas.verizon.net] has quit [Ping timeout: 246 seconds] 03:16 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 03:36 -!- jonatack [~jon@2a01:e35:8aba:8220:6627:dad:d967:649d] has quit [Ping timeout: 276 seconds] 03:52 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 276 seconds] 03:56 -!- jb55 [~jb55@gateway/tor-sasl/jb55] has quit [Remote host closed the connection] 03:59 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 03:59 -!- jb55 [~jb55@gateway/tor-sasl/jb55] has joined #c-lightning 04:26 -!- bitdex [~bitdex@gateway/tor-sasl/bitdex] has quit [Ping timeout: 260 seconds] 04:28 -!- bitdex [~bitdex@gateway/tor-sasl/bitdex] has joined #c-lightning 04:51 -!- jonatack [~jon@213.152.161.234] has joined #c-lightning 04:51 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 245 seconds] 04:56 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 05:42 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 246 seconds] 05:46 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 05:56 -!- bitdex [~bitdex@gateway/tor-sasl/bitdex] has quit [Quit: = ""] 05:59 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 276 seconds] 06:04 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 06:07 -!- kexkey [~kexkey@37.120.205.233] has joined #c-lightning 06:58 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 250 seconds] 07:07 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 07:35 -!- mdunnio [~mdunnio@38.126.31.226] has joined #c-lightning 08:38 -!- jonatack [~jon@213.152.161.234] has quit [Read error: Connection reset by peer] 08:43 -!- jonatack [~jon@54.76.13.109.rev.sfr.net] has joined #c-lightning 08:45 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 252 seconds] 08:51 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 09:23 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 240 seconds] 09:29 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 09:43 -!- mdunnio [~mdunnio@38.126.31.226] has quit [Remote host closed the connection] 09:54 -!- jonatack [~jon@54.76.13.109.rev.sfr.net] has quit [Ping timeout: 240 seconds] 10:03 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-nfufoseoysnzgsxq] has left #c-lightning [] 10:03 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-nfufoseoysnzgsxq] has joined #c-lightning 10:04 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 250 seconds] 10:11 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 10:26 -!- mdunnio [~mdunnio@38.126.31.226] has joined #c-lightning 10:26 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 246 seconds] 10:30 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 10:50 -!- queip [~queip@unaffiliated/rezurus] has quit [Ping timeout: 240 seconds] 10:57 -!- queip [~queip@unaffiliated/rezurus] has joined #c-lightning 11:13 -!- mdunnio [~mdunnio@38.126.31.226] has quit [Remote host closed the connection] 11:16 -!- mdunnio [~mdunnio@38.126.31.226] has joined #c-lightning 11:31 -!- jonatack [~jon@2a01:e35:8aba:8220:6627:dad:d967:649d] has joined #c-lightning 11:49 -!- mdunnio [~mdunnio@38.126.31.226] has quit [Remote host closed the connection] 11:58 -!- mdunnio [~mdunnio@38.126.31.226] has joined #c-lightning 12:41 -!- reallll [~belcher@unaffiliated/belcher] has joined #c-lightning 12:44 -!- belcher [~belcher@unaffiliated/belcher] has quit [Ping timeout: 245 seconds] 12:45 -!- reallll is now known as belcher 12:49 -!- justan0theruser [~justanoth@unaffiliated/justanotheruser] has quit [Ping timeout: 250 seconds] 13:04 -!- mdunnio [~mdunnio@38.126.31.226] has quit [Remote host closed the connection] 13:07 -!- justan0theruser [~justanoth@unaffiliated/justanotheruser] has joined #c-lightning 15:00 -!- ctrlbreak_MAD [~ctrlbreak@142.134.84.46] has quit [Read error: Connection reset by peer] 15:03 -!- rusty [~rusty@pdpc/supporter/bronze/rusty] has joined #c-lightning 15:17 < sword_smith> Sorry. That was meant for #bitcoin. 15:19 < jb55> rusty: did that fund-a-friend feature ever come about 15:21 < jb55> might have some spare hacking cycles soon 16:07 -!- rusty [~rusty@pdpc/supporter/bronze/rusty] has quit [Quit: Leaving.] 16:11 -!- jb55 [~jb55@gateway/tor-sasl/jb55] has quit [Ping timeout: 260 seconds] 16:20 -!- jb55 [~jb55@gateway/tor-sasl/jb55] has joined #c-lightning 17:09 -!- rusty [~rusty@pdpc/supporter/bronze/rusty] has joined #c-lightning 17:18 -!- rusty [~rusty@pdpc/supporter/bronze/rusty] has quit [Quit: Leaving.] 17:23 -!- kristapsk [~KK@gateway/tor-sasl/kristapsk] has joined #c-lightning 17:48 -!- rusty [~rusty@pdpc/supporter/bronze/rusty] has joined #c-lightning 17:56 -!- rusty [~rusty@pdpc/supporter/bronze/rusty] has quit [Quit: Leaving.] 18:17 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-nfufoseoysnzgsxq] has left #c-lightning [] 18:17 -!- blockstream_bot [blockstrea@gateway/shell/sameroom/x-nfufoseoysnzgsxq] has joined #c-lightning 19:32 -!- m-schmoock [~will@schmoock.net] has quit [Remote host closed the connection] 19:50 -!- StopAndDecrypt [~StopAndDe@unaffiliated/stopanddecrypt] has quit [Ping timeout: 240 seconds] 21:34 -!- Victorsueca [~Victorsue@unaffiliated/victorsueca] has quit [Ping timeout: 240 seconds] 21:34 -!- Victorsueca [~Victorsue@unaffiliated/victorsueca] has joined #c-lightning 23:58 -!- jonatack [~jon@2a01:e35:8aba:8220:6627:dad:d967:649d] has quit [Quit: jonatack] --- Log closed Sat Nov 16 00:00:10 2019