Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL transaction deadlock #269

Open
JuliusHenke opened this issue May 20, 2024 · 0 comments
Open

SQL transaction deadlock #269

JuliusHenke opened this issue May 20, 2024 · 0 comments
Labels
backend bug Something isn't working

Comments

@JuliusHenke
Copy link
Member

JuliusHenke commented May 20, 2024 •
edited
Loading 

2024-05-20 04:10:41,677 INFO org.tormap.service.DescriptorCoordinationService [task-73] Finished 2024-05-19-12-05-00-server-descriptors with 0 errors
2024-05-20 04:10:41,853 INFO org.tormap.service.RelayDetailsUpdateService [task-62] ... Updating relay families for months: 2024-05
2024-05-20 04:10:41,859 INFO org.tormap.service.RelayDetailsUpdateService [task-73] ... Updating relay families for months: 2024-05
2024-05-20 04:25:39,397 INFO org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl [task-62] HHH000010: On release of batch it still contained JDBC statements
2024-05-20 04:25:39,425 ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch [task-62] HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 1 update relay_details set address=('204.8.96.111'), allow_single_hop_exits=('FALSE'::boolean), autonomous_system_name=('QUINTEX'), autonomous_system_number=('62744'::int4), bandwidth_burst=('1073741824'::int4), bandwidth_observed=('14206093'::int4), bandwidth_rate=('1073741824'::int4), caches_extra_info=('FALSE'::boolean), circuit_protocol_versions=(NULL), contact=('email:john[]quintex.com url:https://www.quintex.com proof:uri-rsa abuse:john[]quintex.com keybase:aquintex twitter:aquintex hoster:Quintex Alliance Consulting uplinkbw:10000 btc:1Ab93nZzqBhhoTetUfzjXxpNjUoEQ84Jrt dnslocation:sameas dnsqname:y dnssec:y ...'), day=('2024-05-19 +00'), family_entries=('$0077BCBA7244DB3E6A5ED2746E86170066684887, $00DCAEAE3E54C32809E7F7CC4BF2A6FC68FC552F, $00EB3A12C77E70F19F66A7BBD094D62969AF350D, $041646640AB306EA74B001966E86169B04CC88D2, $139C86C4C9BC94E89BAF79B15EBFDF9396DD5BB0, $155D6F57425F16C0624D77777641E4EB1B47C6F0, $18E753214CD827244280BBD36AAC4F8E70B3EE8D, $1AE949967F82BBE7534A3D6BA77A7EBE1CED4369, $1BBCAEB763CA46DEB565A7251FAA6AC79A388ADD, $1DB25DF59DAA01B5BE3D3CEB8AFED115940EBE8B, $1E5136DDC52FAE1219208F0A6BADB0BA62587EE6, $21187DDD552605957B2EE5ABCBDA0E19251293ED, $2ED4D25766973713EB8C56A290BF07E06B85BF12, $2F81DA22A649EBB0CCD20A97527207E2E841F5F6, $30C55C496F5C7B9868E0BC6349A1CD5623F0B75F, $320D73AF6CC78987E710789847BFB8D61C31BD4B, $3268B4C7DC8D31C30FF14480409DD6D6B0702C9E, $3687FEC7E73F61AC66F7AE251E7DEE6BBD8C0252, $36D68478366CB8627866757EBCE7FB3C17FC1CB8, $3A1BC65DF03ECD50FDF7CFF9C5A4E049FCB9C1AF, $3CA0D15567024D2E0B557DC0CF3E962B37999A79, $3F91F384ABF6D115080638E52381231D1BFBFC84, $40E7D6CE5085E4CDDA31D51A29D1457EB53F12AD, $4316866D578B06DC79728883C8E5C9609F8311D8, $43209F6D50C657A56FE79AF01CA69F9EF19BD338, $4673A9741D2B7CF367CE3A6CE90C30E1820AAF9E, $4EBF459880000DAB6FDDAF0AE5122D0149097559, $4EE488AC0742BC6B747BB637A5635CE14E877F39, $501F5C4AACABEBFDC6A23543379F19B066396946, $521C30A968743B13E17E22E39BE52DA020FB92E1, $54A4820B46E65509BF3E2B892E66930A41759DE9, $5649CB2158DA94FB747415F26628BEC07FA57616, $5F4CD12099AF20FAF9ADFDCEC65316A376D0201C, $60D3667F56AEC5C69CF7E8F557DB21DDF6C36060, $654D634FC4281B16FAB7217BABDC3F179A8F2D29, $66E19E8C4773086F669A1E06A3F8C23B6C079129, $6748BA531097A930776F90E20B6EFBA3519A23C0, $7070199EF60B5B1AE4EA2EFB4881F9F90B6FA9EF, $764BF8A03868F84C8F323C1A676AA254B80DC3BF, $7A3DD280EA4CD4DD16EF8C67B93D9BDE184D1A81, $7B046CEA50092F9AB2F712D84F52E8FA00D83877, $7E6E9A6FDDB8DC7C92F0CFCC3CBE76C29F061799, $7FA8E7E44F1392A4E40FFC3B69DB3B00091B7FD3, $891F75C9EA906010BE9097D9573F72F462D88A19, $8A63E4CC86E4AFF54E07AF9D2340DFDFB8674312, $8B80169BEF71450FC4069A190853523B7AEA45E1, $90BF7147B422A1BABEFA503656EBD17987424441, $9314BD9503B9014261A65C221D77E57389DBCCC1, $9370F55D4BBF72FBDF13C41D65C8B814B4300CC8, $9C1E7D92115D431385B8CAEA6A7C15FB89CE236B, $9C2232ADECCEC6AE0C457D2ED3AE63425540C596, $9D21F034C3BFF4E7737D08CF775DC1745706801F, $9E2D7C6981269404AA1970B53891701A20424EF8, $9F2856F6D2B89AD4EF6D5723FAB167DB5A53519A, $A0DB820FEC87C0405F7BF05DEE5E4ADED2BB9904, $A2C3CB1520C75BEDB21244FD1DF1C371C26E959E, $A389C523BE3B29EA59C75AC557BF5CFB69586DCB, $A4A393FEF48640961AACE92D041934B55348CEF9, $A868303126987902D51F2B6F06DD90038C45B119, $A8AC5C1BA09DB94123E2BB990984B8A89E2896B0, $A8B887B3DC8B864E2F0B58F92B0C10D493B5AFFE, $A8BEB150F4BAD51BC6309ED93BFD40022A72A618, $A91F3E4D2CCD81F5C865E143525F92A790CDF17E, $AF57275D067ACF1EADE51E32860C8E569190BB24, $B028707969D8ED84E6DEA597A884F78AAD471971, $B0CD9F9B5B60651ADC5919C0F1EAA87DBA1D9249, $B2197C23A4FF5D1C49EE45BA7688BA8BCCD89A0B, $B6320E44A230302C7BF9319E67597A9B87882241, $B7047FBDE9C53C39011CA84E5CB2A8E3543066D0, $B7ECD9C6A910A170B55165742049CBCC777494F2, $C5A53BCC174EF8FD0DCB223E4AA929FA557DEDB2, $C78AFFEEE320EA0F860961763E613FD2FAC855F5, $CB7C0D841FE376EF43F7845FF201B0290C0A239E, $CC14C97F1D23EE97766828FC8ED8582E21E11665, $CC4A3AE960E3617F49BF9887B79186C14CBA6813, $D25210CE07C49F2A4F2BC7A506EB0F5EA7F5E2C2, $D33292FEDE24DD40F2385283E55C87F85C0943B6, $D3A1B7DEF370CBC6055F3FC540A518C8576D7570, $D4E585CE0E37A8B34F0D534CA396B97238B12BFA, $D6FF2697CEA5C0C7DA84797C2E71163814FC2466, $DA5C9A58DBD49E83821BC56FCBC8AD9209680CA3, $DA77AAFE0CC38DB958432B45910F47714D614AA8, $DAC0FD4D1A6D18ABF95AF248935EC56F46E5A921, $DAE94877199B925D5F79C2B00D7B834D16993AF9, $DD9849BD5CF3DC769FA2AEDBF9F15BF5B96A6957, $DE4F7A7B2DF8689B1F8D23ABA9E320D17638EAFD, $DF20497E487A979995D851A5BCEC313DF7E5BC51, $E3A491D490DC1C3832D7F68615EEB4508C857D8B, $E480D577F58E782A5BC4FA6F49A6650E9389302F, $EA7D575C91BB1F53C25510FBF91B87D81AE14646, $EABC2DD0D47B5DB11F2D37EB3C60C2A4D91C10F2, $EC15DB62D9101481F364DE52EB8313C838BDDC29, $EDCDF42475CD60A8EBDFA7CFE64B5006AB9FA783, $F0B60D25C2E83EA707C2886CFA59CDFE026A0D59, $F21DE9C7DE31601D9716781E17E24380887883D1, $F664E5E50B4D216E5940DA7E9CF653F5F9DC561B, $F7447E99EB5CBD4D5EB913EE0E35AC642B5C1EF3, $FAB96E0069596CACADCF1FCBA2407FCE505ED06D, $FDD700C791CC6BB0AC1C2099A82CBC367AD4B764, $FE00A3A835680E67FBBC895A724E2657BB253E97'), family_id=('40188730'::int8), fingerprint=('B0CD9F9B5B60651ADC5919C0F1EAA87DBA1D9249'), is_hibernating=('FALSE'::boolean), is_hidden_service_dir=('TRUE'::boolean), link_protocol_versions=(NULL), month=('2024-05'), nickname=('QuintexColinNSarah'), platform=('Tor 0.4.8.10 on Linux'), protocols=('Conflux (1), Cons (1, 2), Desc (1, 2), DirCache (2), FlowCtrl (1, 2), HSDir (2), HSIntro (4, 5), HSRend (1, 2), Link (1, 2, 3, 4, 5), LinkAuth (1, 3), Microdesc (1, 2), Padding (2), Relay (1, 2, 3, 4)'), tunnelled_dir_server=('TRUE'::boolean), uptime=('2721745'::int8) where id=('39686119'::int8) was aborted: ERROR: deadlock detected
  Detail: Process 10749 waits for ShareLock on transaction 12475738; blocked by process 10750.
Process 10750 waits for ShareLock on transaction 12475739; blocked by process 10749.
  Hint: See server log for query details.
  Where: while updating tuple (88028,73) in relation "relay_details"  Call getNextException to see other errors in the batch.], SQL: update relay_details set address=?, allow_single_hop_exits=?, autonomous_system_name=?, autonomous_system_number=?, bandwidth_burst=?, bandwidth_observed=?, bandwidth_rate=?, caches_extra_info=?, circuit_protocol_versions=?, contact=?, day=?, family_entries=?, family_id=?, fingerprint=?, is_hibernating=?, is_hidden_service_dir=?, link_protocol_versions=?, month=?, nickname=?, platform=?, protocols=?, tunnelled_dir_server=?, uptime=? where id=?
2024-05-20 04:25:39,426 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper [task-62] SQL Error: 0, SQLState: 40P01
2024-05-20 04:25:39,426 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper [task-62] Batch entry 1 update relay_details set address=('204.8.96.111'), allow_single_hop_exits=('FALSE'::boolean), autonomous_system_name=('QUINTEX'), autonomous_system_number=('62744'::int4), bandwidth_burst=('1073741824'::int4), bandwidth_observed=('14206093'::int4), bandwidth_rate=('1073741824'::int4), caches_extra_info=('FALSE'::boolean), circuit_protocol_versions=(NULL), contact=('email:john[]quintex.com url:https://www.quintex.com proof:uri-rsa abuse:john[]quintex.com keybase:aquintex twitter:aquintex hoster:Quintex Alliance Consulting uplinkbw:10000 btc:1Ab93nZzqBhhoTetUfzjXxpNjUoEQ84Jrt dnslocation:sameas dnsqname:y dnssec:y ...'), day=('2024-05-19 +00'), family_entries=('$0077BCBA7244DB3E6A5ED2746E86170066684887, $00DCAEAE3E54C32809E7F7CC4BF2A6FC68FC552F, $00EB3A12C77E70F19F66A7BBD094D62969AF350D, $041646640AB306EA74B001966E86169B04CC88D2, $139C86C4C9BC94E89BAF79B15EBFDF9396DD5BB0, $155D6F57425F16C0624D77777641E4EB1B47C6F0, $18E753214CD827244280BBD36AAC4F8E70B3EE8D, $1AE949967F82BBE7534A3D6BA77A7EBE1CED4369, $1BBCAEB763CA46DEB565A7251FAA6AC79A388ADD, $1DB25DF59DAA01B5BE3D3CEB8AFED115940EBE8B, $1E5136DDC52FAE1219208F0A6BADB0BA62587EE6, $21187DDD552605957B2EE5ABCBDA0E19251293ED, $2ED4D25766973713EB8C56A290BF07E06B85BF12, $2F81DA22A649EBB0CCD20A97527207E2E841F5F6, $30C55C496F5C7B9868E0BC6349A1CD5623F0B75F, $320D73AF6CC78987E710789847BFB8D61C31BD4B, $3268B4C7DC8D31C30FF14480409DD6D6B0702C9E, $3687FEC7E73F61AC66F7AE251E7DEE6BBD8C0252, $36D68478366CB8627866757EBCE7FB3C17FC1CB8, $3A1BC65DF03ECD50FDF7CFF9C5A4E049FCB9C1AF, $3CA0D15567024D2E0B557DC0CF3E962B37999A79, $3F91F384ABF6D115080638E52381231D1BFBFC84, $40E7D6CE5085E4CDDA31D51A29D1457EB53F12AD, $4316866D578B06DC79728883C8E5C9609F8311D8, $43209F6D50C657A56FE79AF01CA69F9EF19BD338, $4673A9741D2B7CF367CE3A6CE90C30E1820AAF9E, $4EBF459880000DAB6FDDAF0AE5122D0149097559, $4EE488AC0742BC6B747BB637A5635CE14E877F39, $501F5C4AACABEBFDC6A23543379F19B066396946, $521C30A968743B13E17E22E39BE52DA020FB92E1, $54A4820B46E65509BF3E2B892E66930A41759DE9, $5649CB2158DA94FB747415F26628BEC07FA57616, $5F4CD12099AF20FAF9ADFDCEC65316A376D0201C, $60D3667F56AEC5C69CF7E8F557DB21DDF6C36060, $654D634FC4281B16FAB7217BABDC3F179A8F2D29, $66E19E8C4773086F669A1E06A3F8C23B6C079129, $6748BA531097A930776F90E20B6EFBA3519A23C0, $7070199EF60B5B1AE4EA2EFB4881F9F90B6FA9EF, $764BF8A03868F84C8F323C1A676AA254B80DC3BF, $7A3DD280EA4CD4DD16EF8C67B93D9BDE184D1A81, $7B046CEA50092F9AB2F712D84F52E8FA00D83877, $7E6E9A6FDDB8DC7C92F0CFCC3CBE76C29F061799, $7FA8E7E44F1392A4E40FFC3B69DB3B00091B7FD3, $891F75C9EA906010BE9097D9573F72F462D88A19, $8A63E4CC86E4AFF54E07AF9D2340DFDFB8674312, $8B80169BEF71450FC4069A190853523B7AEA45E1, $90BF7147B422A1BABEFA503656EBD17987424441, $9314BD9503B9014261A65C221D77E57389DBCCC1, $9370F55D4BBF72FBDF13C41D65C8B814B4300CC8, $9C1E7D92115D431385B8CAEA6A7C15FB89CE236B, $9C2232ADECCEC6AE0C457D2ED3AE63425540C596, $9D21F034C3BFF4E7737D08CF775DC1745706801F, $9E2D7C6981269404AA1970B53891701A20424EF8, $9F2856F6D2B89AD4EF6D5723FAB167DB5A53519A, $A0DB820FEC87C0405F7BF05DEE5E4ADED2BB9904, $A2C3CB1520C75BEDB21244FD1DF1C371C26E959E, $A389C523BE3B29EA59C75AC557BF5CFB69586DCB, $A4A393FEF48640961AACE92D041934B55348CEF9, $A868303126987902D51F2B6F06DD90038C45B119, $A8AC5C1BA09DB94123E2BB990984B8A89E2896B0, $A8B887B3DC8B864E2F0B58F92B0C10D493B5AFFE, $A8BEB150F4BAD51BC6309ED93BFD40022A72A618, $A91F3E4D2CCD81F5C865E143525F92A790CDF17E, $AF57275D067ACF1EADE51E32860C8E569190BB24, $B028707969D8ED84E6DEA597A884F78AAD471971, $B0CD9F9B5B60651ADC5919C0F1EAA87DBA1D9249, $B2197C23A4FF5D1C49EE45BA7688BA8BCCD89A0B, $B6320E44A230302C7BF9319E67597A9B87882241, $B7047FBDE9C53C39011CA84E5CB2A8E3543066D0, $B7ECD9C6A910A170B55165742049CBCC777494F2, $C5A53BCC174EF8FD0DCB223E4AA929FA557DEDB2, $C78AFFEEE320EA0F860961763E613FD2FAC855F5, $CB7C0D841FE376EF43F7845FF201B0290C0A239E, $CC14C97F1D23EE97766828FC8ED8582E21E11665, $CC4A3AE960E3617F49BF9887B79186C14CBA6813, $D25210CE07C49F2A4F2BC7A506EB0F5EA7F5E2C2, $D33292FEDE24DD40F2385283E55C87F85C0943B6, $D3A1B7DEF370CBC6055F3FC540A518C8576D7570, $D4E585CE0E37A8B34F0D534CA396B97238B12BFA, $D6FF2697CEA5C0C7DA84797C2E71163814FC2466, $DA5C9A58DBD49E83821BC56FCBC8AD9209680CA3, $DA77AAFE0CC38DB958432B45910F47714D614AA8, $DAC0FD4D1A6D18ABF95AF248935EC56F46E5A921, $DAE94877199B925D5F79C2B00D7B834D16993AF9, $DD9849BD5CF3DC769FA2AEDBF9F15BF5B96A6957, $DE4F7A7B2DF8689B1F8D23ABA9E320D17638EAFD, $DF20497E487A979995D851A5BCEC313DF7E5BC51, $E3A491D490DC1C3832D7F68615EEB4508C857D8B, $E480D577F58E782A5BC4FA6F49A6650E9389302F, $EA7D575C91BB1F53C25510FBF91B87D81AE14646, $EABC2DD0D47B5DB11F2D37EB3C60C2A4D91C10F2, $EC15DB62D9101481F364DE52EB8313C838BDDC29, $EDCDF42475CD60A8EBDFA7CFE64B5006AB9FA783, $F0B60D25C2E83EA707C2886CFA59CDFE026A0D59, $F21DE9C7DE31601D9716781E17E24380887883D1, $F664E5E50B4D216E5940DA7E9CF653F5F9DC561B, $F7447E99EB5CBD4D5EB913EE0E35AC642B5C1EF3, $FAB96E0069596CACADCF1FCBA2407FCE505ED06D, $FDD700C791CC6BB0AC1C2099A82CBC367AD4B764, $FE00A3A835680E67FBBC895A724E2657BB253E97'), family_id=('40188730'::int8), fingerprint=('B0CD9F9B5B60651ADC5919C0F1EAA87DBA1D9249'), is_hibernating=('FALSE'::boolean), is_hidden_service_dir=('TRUE'::boolean), link_protocol_versions=(NULL), month=('2024-05'), nickname=('QuintexColinNSarah'), platform=('Tor 0.4.8.10 on Linux'), protocols=('Conflux (1), Cons (1, 2), Desc (1, 2), DirCache (2), FlowCtrl (1, 2), HSDir (2), HSIntro (4, 5), HSRend (1, 2), Link (1, 2, 3, 4, 5), LinkAuth (1, 3), Microdesc (1, 2), Padding (2), Relay (1, 2, 3, 4)'), tunnelled_dir_server=('TRUE'::boolean), uptime=('2721745'::int8) where id=('39686119'::int8) was aborted: ERROR: deadlock detected
  Detail: Process 10749 waits for ShareLock on transaction 12475738; blocked by process 10750.
Process 10750 waits for ShareLock on transaction 12475739; blocked by process 10749.
  Hint: See server log for query details.
  Where: while updating tuple (88028,73) in relation "relay_details"  Call getNextException to see other errors in the batch.
2024-05-20 04:25:39,426 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper [task-62] ERROR: deadlock detected
  Detail: Process 10749 waits for ShareLock on transaction 12475738; blocked by process 10750.
Process 10750 waits for ShareLock on transaction 12475739; blocked by process 10749.
  Hint: See server log for query details.
  Where: while updating tuple (88028,73) in relation "relay_details"
2024-05-20 04:25:39,554 ERROR org.tormap.service.RelayDetailsUpdateService [task-62] Could not update relay families for month 2024-05! could not execute batch; SQL [update relay_details set address=?, allow_single_hop_exits=?, autonomous_system_name=?, autonomous_system_number=?, bandwidth_burst=?, bandwidth_observed=?, bandwidth_rate=?, caches_extra_info=?, circuit_protocol_versions=?, contact=?, day=?, family_entries=?, family_id=?, fingerprint=?, is_hibernating=?, is_hidden_service_dir=?, link_protocol_versions=?, month=?, nickname=?, platform=?, protocols=?, tunnelled_dir_server=?, uptime=? where id=?]; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute batch
2024-05-20 04:25:39,554 INFO org.tormap.service.RelayDetailsUpdateService [task-62] Finished updating relay families
2024-05-20 04:25:39,554 INFO org.tormap.service.RelayDetail

2024-05-20 06:12:42,989 INFO org.tormap.service.RelayDetailsUpdateService [task-68] ... Updating ASs for month: 2024-03
2024-05-20 06:12:43,060 INFO org.tormap.service.RelayDetailsUpdateService [task-68] Determined the AS of 0 / 152 relays for month 2024-03
2024-05-20 06:13:26,630 WARN com.zaxxer.hikari.pool.PoolBase [task-68] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@2d834f53 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2024-05-20 06:13:26,636 WARN com.zaxxer.hikari.pool.PoolBase [task-68] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@76bf0724 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2024-05-20 06:13:26,646 WARN com.zaxxer.hikari.pool.PoolBase [task-68] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@7be348f8 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2024-05-20 06:13:58,770 WARN com.zaxxer.hikari.pool.PoolBase [task-68] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@46419af5 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2024-05-20 06:13:58,775 WARN com.zaxxer.hikari.pool.PoolBase [task-68] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@63a66859 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2024-05-20 06:13:58,782 WARN com.zaxxer.hikari.pool.PoolBase [task-68] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@3be43cd4 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2024-05-20 06:13:58,788 WARN com.zaxxer.hikari.pool.PoolBase [task-68] HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@71389f6f (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2024-05-20 06:14:00,130 INFO org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl [task-62] HHH000010: On release of batch it still contained JDBC statements
2024-05-20 06:14:00,133 ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch [task-62] HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 1 update relay_details set address=('202.59.9.238'), allow_single_hop_exits=('FALSE'::boolean), autonomous_system_name=('Gigabit Hosting Sdn Bhd'), autonomous_system_number=('55720'::int4), bandwidth_burst=('1073741824'::int4), bandwidth_observed=('807677'::int4), bandwidth_rate=('1073741824'::int4), caches_extra_info=('FALSE'::boolean), circuit_protocol_versions=(NULL), contact=(NULL), day=('2024-05-19 +00'), family_entries=('$1AE1CBDAAC8DF7130743710D8A0E598157873ED5, $4080222C8B944201B516AC5B145275E6ECEE4700, $9F3534DDA4865C0A88F3EF84BB5F1E6C35854379'), family_id=('40199178'::int8), fingerprint=('4080222C8B944201B516AC5B145275E6ECEE4700'), is_hibernating=('FALSE'::boolean), is_hidden_service_dir=('TRUE'::boolean), link_protocol_versions=(NULL), month=('2024-05'), nickname=('uknc'), platform=('Tor 0.4.8.11 on Linux'), protocols=('Conflux (1), Cons (1, 2), Desc (1, 2), DirCache (2), FlowCtrl (1, 2), HSDir (2), HSIntro (4, 5), HSRend (1, 2), Link (1, 2, 3, 4, 5), LinkAuth (1, 3), Microdesc (1, 2), Padding (2), Relay (1, 2, 3, 4)'), tunnelled_dir_server=('TRUE'::boolean), uptime=('518467'::int8) where id=('39683341'::int8) was aborted: ERROR: deadlock detected
  Detail: Process 10902 waits for ShareLock on transaction 12487314; blocked by process 10906.
Process 10906 waits for ShareLock on transaction 12487317; blocked by process 10902.
  Hint: See server log for query details.
  Where: while updating tuple (90855,47) in relation "relay_details"  Call getNextException to see other errors in the batch.], SQL: update relay_details set address=?, allow_single_hop_exits=?, autonomous_system_name=?, autonomous_system_number=?, bandwidth_burst=?, bandwidth_observed=?, bandwidth_rate=?, caches_extra_info=?, circuit_protocol_versions=?, contact=?, day=?, family_entries=?, family_id=?, fingerprint=?, is_hibernating=?, is_hidden_service_dir=?, link_protocol_versions=?, month=?, nickname=?, platform=?, protocols=?, tunnelled_dir_server=?, uptime=? where id=?
2024-05-20 06:14:00,133 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper [task-62] SQL Error: 0, SQLState: 40P01
2024-05-20 06:14:00,133 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper [task-62] Batch entry 1 update relay_details set address=('202.59.9.238'), allow_single_hop_exits=('FALSE'::boolean), autonomous_system_name=('Gigabit Hosting Sdn Bhd'), autonomous_system_number=('55720'::int4), bandwidth_burst=('1073741824'::int4), bandwidth_observed=('807677'::int4), bandwidth_rate=('1073741824'::int4), caches_extra_info=('FALSE'::boolean), circuit_protocol_versions=(NULL), contact=(NULL), day=('2024-05-19 +00'), family_entries=('$1AE1CBDAAC8DF7130743710D8A0E598157873ED5, $4080222C8B944201B516AC5B145275E6ECEE4700, $9F3534DDA4865C0A88F3EF84BB5F1E6C35854379'), family_id=('40199178'::int8), fingerprint=('4080222C8B944201B516AC5B145275E6ECEE4700'), is_hibernating=('FALSE'::boolean), is_hidden_service_dir=('TRUE'::boolean), link_protocol_versions=(NULL), month=('2024-05'), nickname=('uknc'), platform=('Tor 0.4.8.11 on Linux'), protocols=('Conflux (1), Cons (1, 2), Desc (1, 2), DirCache (2), FlowCtrl (1, 2), HSDir (2), HSIntro (4, 5), HSRend (1, 2), Link (1, 2, 3, 4, 5), LinkAuth (1, 3), Microdesc (1, 2), Padding (2), Relay (1, 2, 3, 4)'), tunnelled_dir_server=('TRUE'::boolean), uptime=('518467'::int8) where id=('39683341'::int8) was aborted: ERROR: deadlock detected
  Detail: Process 10902 waits for ShareLock on transaction 12487314; blocked by process 10906.
Process 10906 waits for ShareLock on transaction 12487317; blocked by process 10902.
  Hint: See server log for query details.
  Where: while updating tuple (90855,47) in relation "relay_details"  Call getNextException to see other errors in the batch.
2024-05-20 06:14:00,133 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper [task-62] ERROR: deadlock detected
  Detail: Process 10902 waits for ShareLock on transaction 12487314; blocked by process 10906.
Process 10906 waits for ShareLock on transaction 12487317; blocked by process 10902.
  Hint: See server log for query details.
  Where: while updating tuple (90855,47) in relation "relay_details"
2024-05-20 06:14:00,134 ERROR org.tormap.service.RelayDetailsUpdateService [task-62] Could not update relay families for month 2024-05! could not execute batch; SQL [update relay_details set address=?, allow_single_hop_exits=?, autonomous_system_name=?, autonomous_system_number=?, bandwidth_burst=?, bandwidth_observed=?, bandwidth_rate=?, caches_extra_info=?, circuit_protocol_versions=?, contact=?, day=?, family_entries=?, family_id=?, fingerprint=?, is_hibernating=?, is_hidden_service_dir=?, link_protocol_versions=?, month=?, nickname=?, platform=?, protocols=?, tunnelled_dir_server=?, uptime=? where id=?]; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute batch
2024-05-20 06:14:00,134 INFO org.tormap.service.RelayDetailsUpdateService [task-62] Finished updating relay families
@JuliusHenke JuliusHenke added bug Something isn't working backend labels May 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
backend bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@JuliusHenke