Microservice

1namespace MyApp.Cloud.Serilog.MQSink
2{
3    public class MessageQueueSink: ILogEventSink
4    {
5        private readonly IMQProducer _MQProducerService;
6        public MessageQueueSink(IMQProducer mQProducerService)
7        {
8            _MQProducerService = mQProducerService;
9        }
10        public void Emit(LogEvent logEvent)
11        {
12            _MQProducerService.Produce<SendLog>(new SendLog() { LogEventJson = JsonConvert.SerializeObject(logEvent)});
13        }
14    }
15}
16        var configurationBuilder = new ConfigurationBuilder().AddJsonFile("appsettings.json").Build();
17        var appSettings = configurationBuilder.Get<AppSettings>();
18
19        configurationBuilder = new ConfigurationBuilder().AddJsonFile("ExtendedSettings.json").Build();
20
21            Host.CreateDefaultBuilder(args)
22                .UseMyAppCloudMQ(context => context.UseSettings(appSettings.MQSettings))
23                .UseSerilog((hostingContext, loggerConfiguration) => loggerConfiguration.ReadFrom.Configuration(hostingContext.Configuration))
24                .ConfigureServices((hostContext, services) =>
25                {
26                    services
27                        .AddHostedService<ExtendedProgService>()
28                        .Configure<MQSettings>(configurationBuilder.GetSection("MQSettings"))
29                })
30                .Build().Run();
31  "serilog": {
32    "Using": [ "Serilog.Sinks.File", "Serilog.Sinks.Console", "MyApp.Cloud.Serilog.MQSink" ],
33    "MinimumLevel": {
34      "Default": "Debug",
35      "Override": {
36        "Microsoft": "Warning",
37        "System": "Warning"
38      }
39    },
40    "Enrich": [ "FromLogContext", "WithMachineName", "WithProcessId" ],
41    "WriteTo": [
42      {
43        "Name": "MessageQueueSink",
44        "Args": {}
45        }
46    ]
47  }
48public static class MySinkExtensions
49    {
50        public static LoggerConfiguration MessageQueueSink(
51                  this Serilog.Configuration.LoggerSinkConfiguration loggerConfiguration,
52                  MyApp.Cloud.MQ.Interface.IMQProducer mQProducer = null)
53        {
54            return loggerConfiguration.Sink(new MyApp.Cloud.Serilog.MQSink.MessageQueueSink(mQProducer));
55        }
56    }
57Host.CreateDefaultBuilder(args)
58                    .UseMyAppCloudMQ(context => context.UseSettings(appSettings.MQSettings))
59                     .ConfigureServices((hostContext, services) =>
60                    {
61                        services
62                            .Configure<MQSettings>(configurationBuilder.GetSection("MQSettings"))
63                    })
64                    .UseSerilog((hostingContext, loggerConfiguration) => loggerConfiguration.ReadFrom.Configuration(hostingContext.Configuration).WriteTo.MessageQueueSink())
65                    .Build().Run();
66var host = Host.CreateDefaultBuilder(args)
67    // Register your services as usual
68    .UseSerilog()
69    .Build()
70    
71Log.Logger = new LoggerConfiguration()
72    .ReadFrom.Configuration(host.Services.GetRequiredService<IConfiguration>())
73    .WriteTo.MessageQueueSink(host.Services.GetRequiredService<IMQProducer>())
74    .CreateLogger();
75
76host.Run();
77

1$ gcloud auth application-default login
2from google.auth import impersonated_credentials
3from google.auth import default
4
5from google.cloud import storage
6
7target_scopes = ['https://www.googleapis.com/auth/devstorage.read_only']
8
9credentials, project = default(scopes=target_scopes)
10
11final_credentials = impersonated_credentials.Credentials(
12    source_credentials=credentials,
13    target_principal="foo@bar-271618.iam.gserviceaccount.com",
14    target_scopes=target_scopes
15)
16
17client = storage.Client(credentials=final_credentials)
18
19print(next(client.list_buckets()))
20from google.auth import impersonated_credentials
21from google.auth import default
22
23from google.cloud import storage
24
25target_scopes = ['https://www.googleapis.com/auth/devstorage.read_only']
26
27credentials, project = default(scopes=target_scopes)
28if env := os.getenv("RUNNING_ENVIRONMENT") == "local":
29    credentials = impersonated_credentials.Credentials(
30        source_credentials=credentials,
31        target_principal=os.environ["TARGET_PRINCIPAL"],
32        target_scopes=target_scopes
33    )
34
35client = storage.Client(credentials=credentials)
36print(next(client.list_buckets()))
37gcloud auth application-default login --impersonate-service-account=<SA email>
38

1public Mono<String> sendLogsToGraphQL(String logs){
2        return webClient
3                .post()
4                .uri("http://localhost:8080/logs/createEventLog")
5                .bodyValue(logs)
6                .retrieve()
7                .bodyToMono(String.class);
8    }  
9{
10    "hasError": false,
11    "message": "Hello There",
12    "sender": "Ali Ahmad",
13    "payload": {
14        "type": "String",
15        "title": "Topoic",
16        "description": "This is the demo description of the activemqq"
17    },
18    "serviceInfo":{
19        "version": "v1",
20        "date": "2021-05-18T08:44:17.8237608+05:00",
21        "serverStatus": "UP",
22        "serviceName": "IdentityService"
23    }
24}
25mutation($eventLog:EventLogInput){
26  createEventLog(eventLog: $eventLog){
27    hasError
28    message
29    payload{
30      title,
31      description
32    }
33  }
34}
35{
36  "eventLog": {
37    "hasError": false,
38    "message": "Hello There",
39    "sender": "Ali Ahmad",
40    "payload": {
41        "type": "String",
42        "title": "Topoic",
43        "description": "This is the demo description of the activemqq"
44    },
45    "serviceInfo":{
46        "version": "v1",
47        "date": "2021-05-18T08:44:17.8237608+05:00",
48        "serverStatus": "UP",
49        "serviceName": "IdentityService"
50    }
51}
52}
53@Component
54public class Consumer {
55    @Autowired
56    private AuditService auditService;
57
58    private final String MUTATION_QUERY = "mutation($eventLog: EventLogInput){\n" +
59            "createEventLog(eventLog: $eventLog){\n" +
60            "hasError\n" +
61            "}\n" +
62            "}";
63
64    @JmsListener(destination = "Audit.queue")
65    public void consumeLogs(String logs) {
66        Gson gson = new Gson();
67        Object jsonObject = gson.fromJson(logs, Object.class);
68        Map<String, Object> graphQlBody = new HashMap<>();
69        graphQlBody.put("query", MUTATION_QUERY);
70        graphQlBody.put("variables", "{eventLog: " + jsonObject+ "}");
71        auditService.sendLogsToGraphQL(graphQlBody);
72    }
73}
74public void sendLogsToGraphQL(Map<String, String> logs) {
75        log.info("Logs: {} ", logs);
76        Mono<String> stringMono = webClient
77                .post()
78                .uri("http://localhost:8080/graphql")
79                .bodyValue(BodyInserters.fromValue(logs))
80                .retrieve()
81                .bodyToMono(String.class);
82        log.info("StringMono: {}", stringMono);
83        return stringMono;
84    }
85graphQlBody = { "query" : mutation_query, "variables" : { "eventLog" : event_log_json } }
86

1public Mono<String> sendLogsToGraphQL(String logs){
2        return webClient
3                .post()
4                .uri("http://localhost:8080/logs/createEventLog")
5                .bodyValue(logs)
6                .retrieve()
7                .bodyToMono(String.class);
8    }  
9{
10    "hasError": false,
11    "message": "Hello There",
12    "sender": "Ali Ahmad",
13    "payload": {
14        "type": "String",
15        "title": "Topoic",
16        "description": "This is the demo description of the activemqq"
17    },
18    "serviceInfo":{
19        "version": "v1",
20        "date": "2021-05-18T08:44:17.8237608+05:00",
21        "serverStatus": "UP",
22        "serviceName": "IdentityService"
23    }
24}
25mutation($eventLog:EventLogInput){
26  createEventLog(eventLog: $eventLog){
27    hasError
28    message
29    payload{
30      title,
31      description
32    }
33  }
34}
35{
36  "eventLog": {
37    "hasError": false,
38    "message": "Hello There",
39    "sender": "Ali Ahmad",
40    "payload": {
41        "type": "String",
42        "title": "Topoic",
43        "description": "This is the demo description of the activemqq"
44    },
45    "serviceInfo":{
46        "version": "v1",
47        "date": "2021-05-18T08:44:17.8237608+05:00",
48        "serverStatus": "UP",
49        "serviceName": "IdentityService"
50    }
51}
52}
53@Component
54public class Consumer {
55    @Autowired
56    private AuditService auditService;
57
58    private final String MUTATION_QUERY = "mutation($eventLog: EventLogInput){\n" +
59            "createEventLog(eventLog: $eventLog){\n" +
60            "hasError\n" +
61            "}\n" +
62            "}";
63
64    @JmsListener(destination = "Audit.queue")
65    public void consumeLogs(String logs) {
66        Gson gson = new Gson();
67        Object jsonObject = gson.fromJson(logs, Object.class);
68        Map<String, Object> graphQlBody = new HashMap<>();
69        graphQlBody.put("query", MUTATION_QUERY);
70        graphQlBody.put("variables", "{eventLog: " + jsonObject+ "}");
71        auditService.sendLogsToGraphQL(graphQlBody);
72    }
73}
74public void sendLogsToGraphQL(Map<String, String> logs) {
75        log.info("Logs: {} ", logs);
76        Mono<String> stringMono = webClient
77                .post()
78                .uri("http://localhost:8080/graphql")
79                .bodyValue(BodyInserters.fromValue(logs))
80                .retrieve()
81                .bodyToMono(String.class);
82        log.info("StringMono: {}", stringMono);
83        return stringMono;
84    }
85graphQlBody = { "query" : mutation_query, "variables" : { "eventLog" : event_log_json } }
86public Mono<String> sendLogsToGraphQL(Map<String,Object> body){
87    return webClient
88            .post()
89            .uri("http://localhost:8080/logs/createEventLog")
90            .bodyValue(BodyInserters.fromValue(body))
91            .retrieve()
92            .bodyToMono(String.class);
93}  
94

1Exception in thread "main" java.lang.module.FindException: Module java.annotation not found, required by org.apache.tomcat.embed.core
2    at java.base/java.lang.module.Resolver.findFail(Resolver.java:893)
3    at java.base/java.lang.module.Resolver.resolve(Resolver.java:192)
4    at java.base/java.lang.module.Resolver.resolve(Resolver.java:141)
5    at java.base/java.lang.module.Configuration.resolve(Configuration.java:421)
6    at java.base/java.lang.module.Configuration.resolve(Configuration.java:255)
7    at jdk.jdeps/com.sun.tools.jdeps.JdepsConfiguration$Builder.build(JdepsConfiguration.java:564)
8    at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.buildConfig(JdepsTask.java:603)
9    at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.run(JdepsTask.java:557)
10    at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.run(JdepsTask.java:533)
11    at jdk.jdeps/com.sun.tools.jdeps.Main.main(Main.java:49)
12jdeps --ignore-missing-deps --multi-release 17 --module-path target/lib/* target/errorrr-*.jar
13jdeps --multi-release 16 --module-path target/lib/* target/errorrr-*.jar
14jdeps --ignore-missing-deps --multi-release 17 --class-path target/lib/* target/errorrr-*.jar
15#13 1.753 Exception in thread "main" java.lang.Error: java.util.concurrent.ExecutionException: com.sun.tools.jdeps.MultiReleaseException
16        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.DependencyFinder.waitForTasksCompleted(DependencyFinder.java:271)
17        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.DependencyFinder.parse(DependencyFinder.java:133)
18        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.DepsAnalyzer.run(DepsAnalyzer.java:129)
19        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.ModuleExportsAnalyzer.run(ModuleExportsAnalyzer.java:74)
20        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.JdepsTask$ListModuleDeps.run(JdepsTask.java:1047)
21        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.run(JdepsTask.java:574)
22        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.run(JdepsTask.java:533)
23        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.Main.main(Main.java:49)
24        #13 1.753 Caused by: java.util.concurrent.ExecutionException: com.sun.tools.jdeps.MultiReleaseException
25        #13 1.753       at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
26        #13 1.753       at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
27        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.DependencyFinder.waitForTasksCompleted(DependencyFinder.java:267)
28        #13 1.754       ... 7 more
29        #13 1.754 Caused by: com.sun.tools.jdeps.MultiReleaseException
30        #13 1.754       at jdk.jdeps/com.sun.tools.jdeps.VersionHelper.add(VersionHelper.java:62)
31        #13 1.754       at jdk.jdeps/com.sun.tools.jdeps.ClassFileReader$JarFileReader.readClassFile(ClassFileReader.java:360)
32        #13 1.754       at jdk.jdeps/com.sun.tools.jdeps.ClassFileReader$JarFileIterator.hasNext(ClassFileReader.java:402)
33        #13 1.754       at jdk.jdeps/com.sun.tools.jdeps.DependencyFinder.lambda$parse$5(DependencyFinder.java:179)
34        #13 1.754       at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
35        #13 1.754       at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
36        #13 1.754       at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
37        #13 1.754       at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
38        #13 1.754       at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
39        #13 1.754       at java.base/java.lang.Thread.run(Thread.java:833)
40   <?xml version="1.0" encoding="UTF-8"?>
41<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
42   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
43   <modelVersion>4.0.0</modelVersion>
44   <parent>
45       <groupId>org.springframework.boot</groupId>
46       <artifactId>spring-boot-starter-parent</artifactId>
47       <version>2.6.0</version>
48       <relativePath/> <!-- lookup parent from repository -->
49   </parent>
50   <groupId>com.example</groupId>
51   <artifactId>errorrr</artifactId>
52   <version>0.0.1-SNAPSHOT</version>
53   <name>errorrr</name>
54   <description>Demo project for Spring Boot</description>
55   <properties>
56       <java.version>17</java.version>
57   </properties>
58   <dependencies>
59       <dependency>
60           <groupId>org.springframework.boot</groupId>
61           <artifactId>spring-boot-starter-web</artifactId>
62       </dependency>
63
64       <dependency>
65           <groupId>org.springframework.boot</groupId>
66           <artifactId>spring-boot-starter</artifactId>
67       </dependency>
68
69       <dependency>
70           <groupId>org.springframework.boot</groupId>
71           <artifactId>spring-boot-starter-test</artifactId>
72           <scope>test</scope>
73       </dependency>
74
75   </dependencies>
76
77   <build>
78       <plugins>
79           <plugin>
80               <groupId>org.springframework.boot</groupId>
81               <artifactId>spring-boot-maven-plugin</artifactId>
82           </plugin>
83           <plugin>
84               <groupId>org.apache.maven.plugins</groupId>
85               <artifactId>maven-dependency-plugin</artifactId>
86               <executions>
87                   <execution>
88                       <id>copy-dependencies</id>
89                       <phase>package</phase>
90                       <goals>
91                           <goal>copy-dependencies</goal>
92                       </goals>
93                       <configuration>
94                           <outputDirectory>${project.build.directory}/lib</outputDirectory>
95                       </configuration>
96                   </execution>
97               </executions>
98           </plugin>
99       </plugins>
100   </build>
101
102</project>
103
104RUN jdeps \
105    --ignore-missing-deps \
106    -q \
107    --multi-release 17 \
108    --print-module-deps \
109    --class-path build/lib/* \
110    app.jar > deps.info
111
112RUN jlink --verbose \
113    --compress 2 \
114    --strip-java-debug-attributes \
115    --no-header-files \
116    --no-man-pages \
117    --output jre \
118    --add-modules $(cat deps.info)
119

1Exception in thread "main" java.lang.module.FindException: Module java.annotation not found, required by org.apache.tomcat.embed.core
2    at java.base/java.lang.module.Resolver.findFail(Resolver.java:893)
3    at java.base/java.lang.module.Resolver.resolve(Resolver.java:192)
4    at java.base/java.lang.module.Resolver.resolve(Resolver.java:141)
5    at java.base/java.lang.module.Configuration.resolve(Configuration.java:421)
6    at java.base/java.lang.module.Configuration.resolve(Configuration.java:255)
7    at jdk.jdeps/com.sun.tools.jdeps.JdepsConfiguration$Builder.build(JdepsConfiguration.java:564)
8    at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.buildConfig(JdepsTask.java:603)
9    at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.run(JdepsTask.java:557)
10    at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.run(JdepsTask.java:533)
11    at jdk.jdeps/com.sun.tools.jdeps.Main.main(Main.java:49)
12jdeps --ignore-missing-deps --multi-release 17 --module-path target/lib/* target/errorrr-*.jar
13jdeps --multi-release 16 --module-path target/lib/* target/errorrr-*.jar
14jdeps --ignore-missing-deps --multi-release 17 --class-path target/lib/* target/errorrr-*.jar
15#13 1.753 Exception in thread "main" java.lang.Error: java.util.concurrent.ExecutionException: com.sun.tools.jdeps.MultiReleaseException
16        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.DependencyFinder.waitForTasksCompleted(DependencyFinder.java:271)
17        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.DependencyFinder.parse(DependencyFinder.java:133)
18        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.DepsAnalyzer.run(DepsAnalyzer.java:129)
19        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.ModuleExportsAnalyzer.run(ModuleExportsAnalyzer.java:74)
20        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.JdepsTask$ListModuleDeps.run(JdepsTask.java:1047)
21        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.run(JdepsTask.java:574)
22        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.JdepsTask.run(JdepsTask.java:533)
23        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.Main.main(Main.java:49)
24        #13 1.753 Caused by: java.util.concurrent.ExecutionException: com.sun.tools.jdeps.MultiReleaseException
25        #13 1.753       at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
26        #13 1.753       at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
27        #13 1.753       at jdk.jdeps/com.sun.tools.jdeps.DependencyFinder.waitForTasksCompleted(DependencyFinder.java:267)
28        #13 1.754       ... 7 more
29        #13 1.754 Caused by: com.sun.tools.jdeps.MultiReleaseException
30        #13 1.754       at jdk.jdeps/com.sun.tools.jdeps.VersionHelper.add(VersionHelper.java:62)
31        #13 1.754       at jdk.jdeps/com.sun.tools.jdeps.ClassFileReader$JarFileReader.readClassFile(ClassFileReader.java:360)
32        #13 1.754       at jdk.jdeps/com.sun.tools.jdeps.ClassFileReader$JarFileIterator.hasNext(ClassFileReader.java:402)
33        #13 1.754       at jdk.jdeps/com.sun.tools.jdeps.DependencyFinder.lambda$parse$5(DependencyFinder.java:179)
34        #13 1.754       at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
35        #13 1.754       at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
36        #13 1.754       at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
37        #13 1.754       at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
38        #13 1.754       at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
39        #13 1.754       at java.base/java.lang.Thread.run(Thread.java:833)
40   <?xml version="1.0" encoding="UTF-8"?>
41<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
42   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
43   <modelVersion>4.0.0</modelVersion>
44   <parent>
45       <groupId>org.springframework.boot</groupId>
46       <artifactId>spring-boot-starter-parent</artifactId>
47       <version>2.6.0</version>
48       <relativePath/> <!-- lookup parent from repository -->
49   </parent>
50   <groupId>com.example</groupId>
51   <artifactId>errorrr</artifactId>
52   <version>0.0.1-SNAPSHOT</version>
53   <name>errorrr</name>
54   <description>Demo project for Spring Boot</description>
55   <properties>
56       <java.version>17</java.version>
57   </properties>
58   <dependencies>
59       <dependency>
60           <groupId>org.springframework.boot</groupId>
61           <artifactId>spring-boot-starter-web</artifactId>
62       </dependency>
63
64       <dependency>
65           <groupId>org.springframework.boot</groupId>
66           <artifactId>spring-boot-starter</artifactId>
67       </dependency>
68
69       <dependency>
70           <groupId>org.springframework.boot</groupId>
71           <artifactId>spring-boot-starter-test</artifactId>
72           <scope>test</scope>
73       </dependency>
74
75   </dependencies>
76
77   <build>
78       <plugins>
79           <plugin>
80               <groupId>org.springframework.boot</groupId>
81               <artifactId>spring-boot-maven-plugin</artifactId>
82           </plugin>
83           <plugin>
84               <groupId>org.apache.maven.plugins</groupId>
85               <artifactId>maven-dependency-plugin</artifactId>
86               <executions>
87                   <execution>
88                       <id>copy-dependencies</id>
89                       <phase>package</phase>
90                       <goals>
91                           <goal>copy-dependencies</goal>
92                       </goals>
93                       <configuration>
94                           <outputDirectory>${project.build.directory}/lib</outputDirectory>
95                       </configuration>
96                   </execution>
97               </executions>
98           </plugin>
99       </plugins>
100   </build>
101
102</project>
103
104RUN jdeps \
105    --ignore-missing-deps \
106    -q \
107    --multi-release 17 \
108    --print-module-deps \
109    --class-path build/lib/* \
110    app.jar > deps.info
111
112RUN jlink --verbose \
113    --compress 2 \
114    --strip-java-debug-attributes \
115    --no-header-files \
116    --no-man-pages \
117    --output jre \
118    --add-modules $(cat deps.info)
119jar {
120     manifest {
121          attributes "Main-Class": "com.demo.Application"
122     }
123     duplicatesStrategy = DuplicatesStrategy.INCLUDE
124     from {
125          configurations.default.collect { it.isDirectory() ? it : zipTree(it) 
126     }
127   }
128}
129

1Stopping service [Tomcat]
2Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
3***************************
4APPLICATION FAILED TO START
5***************************
6
7Description:
8
9Web server failed to start. Port 8080 was already in use.
10<parent>
11  <groupId>org.springframework.boot</groupId>
12  <artifactId>spring-boot-starter-parent</artifactId>
13  <version>2.5.4</version>
14  <relativePath/> <!-- lookup parent from repository -->
15</parent>
16...
17<dependency>
18  <groupId>org.springframework.boot</groupId>
19  <artifactId>spring-boot-starter-web</artifactId>
20</dependency>
21<dependency>
22  <groupId>org.springframework.kafka</groupId>
23  <artifactId>spring-kafka</artifactId>
24</dependency>
25@Component
26public class KafkaConsumer {
27
28  @KafkaListener(topics = "test", groupId = "test")
29  public void process(String message) {
30
31  }
32}
33spring:
34  kafka:
35    bootstrap-servers: kafka:9092
362021-12-17 11:12:24.955  WARN 29067 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Failed to start bean 'webServerStartStop'; nested exception is org.springframework.boot.web.server.PortInUseException: Port 8080 is already in use
372021-12-17 11:12:24.959  INFO 29067 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
382021-12-17 11:12:24.969  INFO 29067 --- [           main] ConditionEvaluationReportLoggingListener : 
39
40Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
412021-12-17 11:12:24.978 ERROR 29067 --- [           main] o.s.b.d.LoggingFailureAnalysisReporter   : 
42
43***************************
44APPLICATION FAILED TO START
45***************************
46
47Description:
48
49Web server failed to start. Port 8080 was already in use.
50
51Action:
52
53Identify and stop the process that's listening on port 8080 or configure this application to listen on another port.
54
552021-12-17 11:12:25.151  WARN 29067 --- [ntainer#0-0-C-1] org.apache.kafka.clients.NetworkClient   : [Consumer clientId=consumer-test-1, groupId=test] Error while fetching metadata with correlation id 2 : {test=LEADER_NOT_AVAILABLE}
562021-12-17 11:12:25.154  INFO 29067 --- [ntainer#0-0-C-1] org.apache.kafka.clients.Metadata        : [Consumer clientId=consumer-test-1, groupId=test] Cluster ID: NwbnlV2vSdiYtDzgZ81TDQ
572021-12-17 11:12:25.156  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Discovered group coordinator kafka:9092 (id: 2147483636 rack: null)
582021-12-17 11:12:25.159  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] (Re-)joining group
592021-12-17 11:12:25.179  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] (Re-)joining group
602021-12-17 11:12:27.004  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Successfully joined group with generation Generation{generationId=2, memberId='consumer-test-1-c5924ab5-afc8-4720-a5d7-f8107ace3aad', protocol='range'}
612021-12-17 11:12:27.009  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Finished assignment for group at generation 2: {consumer-test-1-c5924ab5-afc8-4720-a5d7-f8107ace3aad=Assignment(partitions=[test-0])}
622021-12-17 11:12:27.021  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Successfully synced group in generation Generation{generationId=2, memberId='consumer-test-1-c5924ab5-afc8-4720-a5d7-f8107ace3aad', protocol='range'}
632021-12-17 11:12:27.022  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Notifying assignor about the new Assignment(partitions=[test-0])
642021-12-17 11:12:27.025  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Adding newly assigned partitions: test-0
652021-12-17 11:12:27.029  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Found no committed offset for partition test-0
662021-12-17 11:12:27.034  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Found no committed offset for partition test-0
672021-12-17 11:12:27.040  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.SubscriptionState    : [Consumer clientId=consumer-test-1, groupId=test] Resetting offset for partition test-0 to position FetchPosition{offset=0, offsetEpoch=Optional.empty, currentLeader=LeaderAndEpoch{leader=Optional[kafka:9092 (id: 11 rack: null)], epoch=0}}.
682021-12-17 11:12:27.045  INFO 29067 --- [ntainer#0-0-C-1] o.s.k.l.KafkaMessageListenerContainer    : test: partitions assigned: [test-0]
69@RestController(
70public class HealtcheckController {
71
72  @Get("/monitoring")
73  public String getMonitoring() {
74    return "200: OK";
75  } 
76
77}
78

1Stopping service [Tomcat]
2Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
3***************************
4APPLICATION FAILED TO START
5***************************
6
7Description:
8
9Web server failed to start. Port 8080 was already in use.
10<parent>
11  <groupId>org.springframework.boot</groupId>
12  <artifactId>spring-boot-starter-parent</artifactId>
13  <version>2.5.4</version>
14  <relativePath/> <!-- lookup parent from repository -->
15</parent>
16...
17<dependency>
18  <groupId>org.springframework.boot</groupId>
19  <artifactId>spring-boot-starter-web</artifactId>
20</dependency>
21<dependency>
22  <groupId>org.springframework.kafka</groupId>
23  <artifactId>spring-kafka</artifactId>
24</dependency>
25@Component
26public class KafkaConsumer {
27
28  @KafkaListener(topics = "test", groupId = "test")
29  public void process(String message) {
30
31  }
32}
33spring:
34  kafka:
35    bootstrap-servers: kafka:9092
362021-12-17 11:12:24.955  WARN 29067 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Failed to start bean 'webServerStartStop'; nested exception is org.springframework.boot.web.server.PortInUseException: Port 8080 is already in use
372021-12-17 11:12:24.959  INFO 29067 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
382021-12-17 11:12:24.969  INFO 29067 --- [           main] ConditionEvaluationReportLoggingListener : 
39
40Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
412021-12-17 11:12:24.978 ERROR 29067 --- [           main] o.s.b.d.LoggingFailureAnalysisReporter   : 
42
43***************************
44APPLICATION FAILED TO START
45***************************
46
47Description:
48
49Web server failed to start. Port 8080 was already in use.
50
51Action:
52
53Identify and stop the process that's listening on port 8080 or configure this application to listen on another port.
54
552021-12-17 11:12:25.151  WARN 29067 --- [ntainer#0-0-C-1] org.apache.kafka.clients.NetworkClient   : [Consumer clientId=consumer-test-1, groupId=test] Error while fetching metadata with correlation id 2 : {test=LEADER_NOT_AVAILABLE}
562021-12-17 11:12:25.154  INFO 29067 --- [ntainer#0-0-C-1] org.apache.kafka.clients.Metadata        : [Consumer clientId=consumer-test-1, groupId=test] Cluster ID: NwbnlV2vSdiYtDzgZ81TDQ
572021-12-17 11:12:25.156  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Discovered group coordinator kafka:9092 (id: 2147483636 rack: null)
582021-12-17 11:12:25.159  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] (Re-)joining group
592021-12-17 11:12:25.179  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] (Re-)joining group
602021-12-17 11:12:27.004  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Successfully joined group with generation Generation{generationId=2, memberId='consumer-test-1-c5924ab5-afc8-4720-a5d7-f8107ace3aad', protocol='range'}
612021-12-17 11:12:27.009  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Finished assignment for group at generation 2: {consumer-test-1-c5924ab5-afc8-4720-a5d7-f8107ace3aad=Assignment(partitions=[test-0])}
622021-12-17 11:12:27.021  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.AbstractCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Successfully synced group in generation Generation{generationId=2, memberId='consumer-test-1-c5924ab5-afc8-4720-a5d7-f8107ace3aad', protocol='range'}
632021-12-17 11:12:27.022  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Notifying assignor about the new Assignment(partitions=[test-0])
642021-12-17 11:12:27.025  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Adding newly assigned partitions: test-0
652021-12-17 11:12:27.029  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Found no committed offset for partition test-0
662021-12-17 11:12:27.034  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.ConsumerCoordinator  : [Consumer clientId=consumer-test-1, groupId=test] Found no committed offset for partition test-0
672021-12-17 11:12:27.040  INFO 29067 --- [ntainer#0-0-C-1] o.a.k.c.c.internals.SubscriptionState    : [Consumer clientId=consumer-test-1, groupId=test] Resetting offset for partition test-0 to position FetchPosition{offset=0, offsetEpoch=Optional.empty, currentLeader=LeaderAndEpoch{leader=Optional[kafka:9092 (id: 11 rack: null)], epoch=0}}.
682021-12-17 11:12:27.045  INFO 29067 --- [ntainer#0-0-C-1] o.s.k.l.KafkaMessageListenerContainer    : test: partitions assigned: [test-0]
69@RestController(
70public class HealtcheckController {
71
72  @Get("/monitoring")
73  public String getMonitoring() {
74    return "200: OK";
75  } 
76
77}
78FROM ...
79
80ENTRYPOINT ...
81HEALTHCHECK localhost:8080/monitoring
82

1CREATE TABLE [dbo].[ManageServicesRequest]
2(
3    [ReferenceTransactionId]    INT                 NOT NULL,
4    [OrderDate]                 DATETIMEOFFSET(7)   NOT NULL,
5    [QueuePriority]             INT                 NOT NULL,
6    [Queued]                    DATETIMEOFFSET(7)   NULL,
7    CONSTRAINT [PK_ManageServicesRequest] PRIMARY KEY CLUSTERED ([ReferenceTransactionId]),
8)
9
10CREATE TABLE [dbo].[ServiceChange]
11(
12    [ReferenceTransactionId]    INT                 NOT NULL,
13    [ServiceId]                 VARCHAR(50)         NOT NULL,
14    [ServiceStatus]             CHAR(1)             NOT NULL,
15    [ValidFrom]                 DATETIMEOFFSET(7)   NOT NULL,
16    CONSTRAINT [PK_ServiceChange] PRIMARY KEY CLUSTERED ([ReferenceTransactionId],[ServiceId]),
17    CONSTRAINT [FK_ServiceChange_ManageServiceRequest] FOREIGN KEY ([ReferenceTransactionId]) REFERENCES [ManageServicesRequest]([ReferenceTransactionId]) ON DELETE CASCADE,
18    INDEX [IDX_ServiceChange_ManageServiceRequestId] ([ReferenceTransactionId]),
19    INDEX [IDX_ServiceChange_ServiceId] ([ServiceId])
20)
21
22CREATE TABLE [dbo].[ServiceChangeParameter]
23(
24    [ReferenceTransactionId]    INT                 NOT NULL,
25    [ServiceId]                 VARCHAR(50)         NOT NULL,
26    [ParamCode]                 VARCHAR(50)         NOT NULL,
27    [ParamValue]                VARCHAR(50)         NOT NULL,
28    [ParamValidFrom]            DATETIMEOFFSET(7)   NOT NULL,
29    CONSTRAINT [PK_ServiceChangeParameter] PRIMARY KEY CLUSTERED ([ReferenceTransactionId],[ServiceId],[ParamCode]),
30    CONSTRAINT [FK_ServiceChangeParameter_ServiceChange] FOREIGN KEY ([ReferenceTransactionId],[ServiceId]) REFERENCES [ServiceChange] ([ReferenceTransactionId],[ServiceId]) ON DELETE CASCADE,
31    INDEX [IDX_ServiceChangeParameter_ManageServiceRequestId] ([ReferenceTransactionId]),
32    INDEX [IDX_ServiceChangeParameter_ServiceId] ([ServiceId]),
33    INDEX [IDX_ServiceChangeParameter_ParamCode] ([ParamCode])
34)
35CREATE PROCEDURE [dbo].[spCreateManageServicesRequest]
36    @ReferenceTransactionId INT,
37    @OrderDate DATETIMEOFFSET,
38    @QueuePriority INT,
39    @Services ServiceChangeUdt READONLY,
40    @Parameters ServiceChangeParameterUdt READONLY
41AS
42BEGIN
43    SET NOCOUNT ON;
44
45    BEGIN TRY
46    /* VYTVOŘ NOVÝ REQUEST NA ZMĚNU SLUŽEB */
47
48        /*  INSERT REQUEST  */
49        INSERT INTO [dbo].[ManageServicesRequest]
50            ([ReferenceTransactionId]
51            ,[OrderDate]
52            ,[QueuePriority]
53            ,[Queued])
54        VALUES
55            (@ReferenceTransactionId
56            ,@OrderDate
57            ,@QueuePriority
58            ,NULL)
59
60        /*  INSERT SERVICES */
61        INSERT INTO [dbo].[ServiceChange]
62            ([ReferenceTransactionId]
63            ,[ServiceId]
64            ,[ServiceStatus]
65            ,[ValidFrom])
66        SELECT 
67             @ReferenceTransactionId AS [ReferenceTransactionId]
68            ,[ServiceId]
69            ,[ServiceStatus]
70            ,[ValidFrom]
71        FROM @Services AS [S]
72
73        /*  INSERT PARAMS   */
74        INSERT INTO [dbo].[ServiceChangeParameter]
75            ([ReferenceTransactionId]
76            ,[ServiceId]
77            ,[ParamCode]
78            ,[ParamValue]
79            ,[ParamValidFrom])
80        SELECT 
81            @ReferenceTransactionId AS [ReferenceTransactionId]
82            ,[ServiceId]
83            ,[ParamCode]
84            ,[ParamValue]
85            ,[ParamValidFrom]
86        FROM @Parameters AS [P]
87
88    END TRY
89    BEGIN CATCH
90        THROW
91    END CATCH
92END
93
94CREATE PROCEDURE [dbo].[spGetManageServicesRequest]
95    @ReferenceTransactionId INT
96AS
97BEGIN
98    SET NOCOUNT ON;
99
100    BEGIN TRY 
101        /* VRAŤ MANAGE SERVICES REQUEST PODLE ID */
102
103        SELECT 
104            [MR].[ReferenceTransactionId], 
105            [MR].[OrderDate], 
106            [MR].[QueuePriority], 
107            [MR].[Queued], 
108            
109            [SC].[ReferenceTransactionId], 
110            [SC].[ServiceId], 
111            [SC].[ServiceStatus], 
112            [SC].[ValidFrom],
113            
114            [SP].[ReferenceTransactionId], 
115            [SP].[ServiceId], 
116            [SP].[ParamCode], 
117            [SP].[ParamValue], 
118            [SP].[ParamValidFrom]
119
120        FROM [dbo].[ManageServicesRequest] AS [MR]
121        LEFT JOIN [dbo].[ServiceChange] AS [SC] ON [SC].[ReferenceTransactionId] = [MR].[ReferenceTransactionId]
122        LEFT JOIN [dbo].[ServiceChangeParameter] AS [SP] ON [SP].[ReferenceTransactionId] = [SC].[ReferenceTransactionId] AND [SP].[ServiceId] = [SC].[ServiceId]
123        WHERE [MR].[ReferenceTransactionId] = @ReferenceTransactionId
124
125    END TRY
126    BEGIN CATCH
127        THROW
128    END CATCH
129END
130public async Task Consume(ConsumeContext<CreateCommand> context)
131{
132    using (var sql = sqlFactory.Cip)
133    {
134        /*SAVE REQUEST TO DATABASE*/
135        sql.StartTransaction(System.Data.IsolationLevel.Serializable); <----- First transaction starts
136
137        /* Create id */
138        var transactionId = await GetNewId(context.Message.CorrelationId);
139
140        /* Create manage services request */
141        await sql.OrderingGateway.ManageServices.Create(transactionId,  context.Message.ApiRequest.OrderDate, context.Message.ApiRequest.Priority, services);
142
143        sql.Commit(); <----- First transaction ends
144        
145
146        /// .... Some other stuff ...
147
148        /* Fetch the same object you created in the first transaction */
149        Try
150        {
151            sql.StartTransaction(System.Data.IsolationLevel.Serializable);
152            
153            var request = await sql.OrderingGateway.ManageServices.Get(transactionId); <----- HERE BE THE DEADLOCK, 
154
155            request.Queued = DateTimeOffset.Now;
156            await sql.OrderingGateway.ManageServices.Update(request);
157
158            ... Here is a posting to a microservice queue ...
159        
160            sql.Commit();
161        }
162        catch (Exception)
163        {
164            sql.RollBack();
165        }
166        
167        /// .... Some other stuff ....
168}
169<deadlock>
170  <victim-list>
171    <victimProcess id="process1dbfa86c4e8" />
172  </victim-list>
173  <process-list>
174    <process id="process1dbfa86c4e8" taskpriority="0" logused="0" waitresource="KEY: 18:72057594046775296 (b42d8e559092)" waittime="2503" ownerId="33411557480" transactionname="user_transaction" lasttranstarted="2021-12-01T01:06:15.303" XDES="0x1ddd2df4420" lockMode="RangeS-S" schedulerid="20" kpid="23000" status="suspended" spid="55" sbid="2" ecid="0" priority="0" trancount="1" lastbatchstarted="2021-12-01T01:06:15.310" lastbatchcompleted="2021-12-01T01:06:15.300" lastattention="1900-01-01T00:00:00.300" clientapp="Core Microsoft SqlClient Data Provider" hostpid="11020" isolationlevel="serializable (4)" xactid="33411557480" currentdb="18" currentdbname="xxx" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
175      <executionStack>
176        <frame procname="xxx.dbo.spGetManageServicesRequest" line="10" stmtstart="356" stmtend="4256" sqlhandle="0x030012001374fc02f91433019aad000001000000000000000000000000000000000000000000000000000000"></frame>
177      </executionStack>
178    </process>
179    <process id="process1dbfa1c1c28" taskpriority="0" logused="1232" waitresource="KEY: 18:72057594046971904 (ffffffffffff)" waittime="6275" ownerId="33411563398" transactionname="user_transaction" lasttranstarted="2021-12-01T01:06:16.450" XDES="0x3d4e842c420" lockMode="RangeI-N" schedulerid="31" kpid="36432" status="suspended" spid="419" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-12-01T01:06:16.480" lastbatchcompleted="2021-12-01T01:06:16.463" lastattention="1900-01-01T00:00:00.463" clientapp="Core Microsoft SqlClient Data Provider"  hostpid="11020" isolationlevel="serializable (4)" xactid="33411563398" currentdb="18" currentdbname="xxx" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
180      <executionStack>
181        <frame procname="xxx.dbo.spCreateManageServicesRequest" line="40" stmtstart="2592" stmtend="3226" sqlhandle="0x03001200f01ab84aeb1433019aad000001000000000000000000000000000000000000000000000000000000"></frame>
182      </executionStack>
183    </process>
184  </process-list>
185  <resource-list>
186    <keylock hobtid="72057594046775296" dbid="18" objectname="xxx.dbo.ServiceChange" indexname="PK_ServiceChange" id="lock202ecfd0380" mode="X" associatedObjectId="72057594046775296">
187      <owner-list>
188        <owner id="process1dbfa1c1c28" mode="X" />
189      </owner-list>
190      <waiter-list>
191        <waiter id="process1dbfa86c4e8" mode="RangeS-S" requestType="wait" />
192      </waiter-list>
193    </keylock>
194    <keylock hobtid="72057594046971904" dbid="18" objectname="xxx.dbo.ServiceChangeParameter" indexname="PK_ServiceChangeParameter" id="lock27d3d371880" mode="RangeS-S" associatedObjectId="72057594046971904">
195      <owner-list>
196        <owner id="process1dbfa86c4e8" mode="RangeS-S" />
197      </owner-list>
198      <waiter-list>
199        <waiter id="process1dbfa1c1c28" mode="RangeI-N" requestType="wait" />
200      </waiter-list>
201    </keylock>
202  </resource-list>
203</deadlock>
204SELECT ...
205FROM [dbo].[ManageServicesRequest] AS [MR]
206  LEFT JOIN [dbo].[ServiceChange] AS [SC]  ON [SC].[ReferenceTransactionId] = [MR].[ReferenceTransactionId]
207

1CREATE TABLE [dbo].[ManageServicesRequest]
2(
3    [ReferenceTransactionId]    INT                 NOT NULL,
4    [OrderDate]                 DATETIMEOFFSET(7)   NOT NULL,
5    [QueuePriority]             INT                 NOT NULL,
6    [Queued]                    DATETIMEOFFSET(7)   NULL,
7    CONSTRAINT [PK_ManageServicesRequest] PRIMARY KEY CLUSTERED ([ReferenceTransactionId]),
8)
9
10CREATE TABLE [dbo].[ServiceChange]
11(
12    [ReferenceTransactionId]    INT                 NOT NULL,
13    [ServiceId]                 VARCHAR(50)         NOT NULL,
14    [ServiceStatus]             CHAR(1)             NOT NULL,
15    [ValidFrom]                 DATETIMEOFFSET(7)   NOT NULL,
16    CONSTRAINT [PK_ServiceChange] PRIMARY KEY CLUSTERED ([ReferenceTransactionId],[ServiceId]),
17    CONSTRAINT [FK_ServiceChange_ManageServiceRequest] FOREIGN KEY ([ReferenceTransactionId]) REFERENCES [ManageServicesRequest]([ReferenceTransactionId]) ON DELETE CASCADE,
18    INDEX [IDX_ServiceChange_ManageServiceRequestId] ([ReferenceTransactionId]),
19    INDEX [IDX_ServiceChange_ServiceId] ([ServiceId])
20)
21
22CREATE TABLE [dbo].[ServiceChangeParameter]
23(
24    [ReferenceTransactionId]    INT                 NOT NULL,
25    [ServiceId]                 VARCHAR(50)         NOT NULL,
26    [ParamCode]                 VARCHAR(50)         NOT NULL,
27    [ParamValue]                VARCHAR(50)         NOT NULL,
28    [ParamValidFrom]            DATETIMEOFFSET(7)   NOT NULL,
29    CONSTRAINT [PK_ServiceChangeParameter] PRIMARY KEY CLUSTERED ([ReferenceTransactionId],[ServiceId],[ParamCode]),
30    CONSTRAINT [FK_ServiceChangeParameter_ServiceChange] FOREIGN KEY ([ReferenceTransactionId],[ServiceId]) REFERENCES [ServiceChange] ([ReferenceTransactionId],[ServiceId]) ON DELETE CASCADE,
31    INDEX [IDX_ServiceChangeParameter_ManageServiceRequestId] ([ReferenceTransactionId]),
32    INDEX [IDX_ServiceChangeParameter_ServiceId] ([ServiceId]),
33    INDEX [IDX_ServiceChangeParameter_ParamCode] ([ParamCode])
34)
35CREATE PROCEDURE [dbo].[spCreateManageServicesRequest]
36    @ReferenceTransactionId INT,
37    @OrderDate DATETIMEOFFSET,
38    @QueuePriority INT,
39    @Services ServiceChangeUdt READONLY,
40    @Parameters ServiceChangeParameterUdt READONLY
41AS
42BEGIN
43    SET NOCOUNT ON;
44
45    BEGIN TRY
46    /* VYTVOŘ NOVÝ REQUEST NA ZMĚNU SLUŽEB */
47
48        /*  INSERT REQUEST  */
49        INSERT INTO [dbo].[ManageServicesRequest]
50            ([ReferenceTransactionId]
51            ,[OrderDate]
52            ,[QueuePriority]
53            ,[Queued])
54        VALUES
55            (@ReferenceTransactionId
56            ,@OrderDate
57            ,@QueuePriority
58            ,NULL)
59
60        /*  INSERT SERVICES */
61        INSERT INTO [dbo].[ServiceChange]
62            ([ReferenceTransactionId]
63            ,[ServiceId]
64            ,[ServiceStatus]
65            ,[ValidFrom])
66        SELECT 
67             @ReferenceTransactionId AS [ReferenceTransactionId]
68            ,[ServiceId]
69            ,[ServiceStatus]
70            ,[ValidFrom]
71        FROM @Services AS [S]
72
73        /*  INSERT PARAMS   */
74        INSERT INTO [dbo].[ServiceChangeParameter]
75            ([ReferenceTransactionId]
76            ,[ServiceId]
77            ,[ParamCode]
78            ,[ParamValue]
79            ,[ParamValidFrom])
80        SELECT 
81            @ReferenceTransactionId AS [ReferenceTransactionId]
82            ,[ServiceId]
83            ,[ParamCode]
84            ,[ParamValue]
85            ,[ParamValidFrom]
86        FROM @Parameters AS [P]
87
88    END TRY
89    BEGIN CATCH
90        THROW
91    END CATCH
92END
93
94CREATE PROCEDURE [dbo].[spGetManageServicesRequest]
95    @ReferenceTransactionId INT
96AS
97BEGIN
98    SET NOCOUNT ON;
99
100    BEGIN TRY 
101        /* VRAŤ MANAGE SERVICES REQUEST PODLE ID */
102
103        SELECT 
104            [MR].[ReferenceTransactionId], 
105            [MR].[OrderDate], 
106            [MR].[QueuePriority], 
107            [MR].[Queued], 
108            
109            [SC].[ReferenceTransactionId], 
110            [SC].[ServiceId], 
111            [SC].[ServiceStatus], 
112            [SC].[ValidFrom],
113            
114            [SP].[ReferenceTransactionId], 
115            [SP].[ServiceId], 
116            [SP].[ParamCode], 
117            [SP].[ParamValue], 
118            [SP].[ParamValidFrom]
119
120        FROM [dbo].[ManageServicesRequest] AS [MR]
121        LEFT JOIN [dbo].[ServiceChange] AS [SC] ON [SC].[ReferenceTransactionId] = [MR].[ReferenceTransactionId]
122        LEFT JOIN [dbo].[ServiceChangeParameter] AS [SP] ON [SP].[ReferenceTransactionId] = [SC].[ReferenceTransactionId] AND [SP].[ServiceId] = [SC].[ServiceId]
123        WHERE [MR].[ReferenceTransactionId] = @ReferenceTransactionId
124
125    END TRY
126    BEGIN CATCH
127        THROW
128    END CATCH
129END
130public async Task Consume(ConsumeContext<CreateCommand> context)
131{
132    using (var sql = sqlFactory.Cip)
133    {
134        /*SAVE REQUEST TO DATABASE*/
135        sql.StartTransaction(System.Data.IsolationLevel.Serializable); <----- First transaction starts
136
137        /* Create id */
138        var transactionId = await GetNewId(context.Message.CorrelationId);
139
140        /* Create manage services request */
141        await sql.OrderingGateway.ManageServices.Create(transactionId,  context.Message.ApiRequest.OrderDate, context.Message.ApiRequest.Priority, services);
142
143        sql.Commit(); <----- First transaction ends
144        
145
146        /// .... Some other stuff ...
147
148        /* Fetch the same object you created in the first transaction */
149        Try
150        {
151            sql.StartTransaction(System.Data.IsolationLevel.Serializable);
152            
153            var request = await sql.OrderingGateway.ManageServices.Get(transactionId); <----- HERE BE THE DEADLOCK, 
154
155            request.Queued = DateTimeOffset.Now;
156            await sql.OrderingGateway.ManageServices.Update(request);
157
158            ... Here is a posting to a microservice queue ...
159        
160            sql.Commit();
161        }
162        catch (Exception)
163        {
164            sql.RollBack();
165        }
166        
167        /// .... Some other stuff ....
168}
169<deadlock>
170  <victim-list>
171    <victimProcess id="process1dbfa86c4e8" />
172  </victim-list>
173  <process-list>
174    <process id="process1dbfa86c4e8" taskpriority="0" logused="0" waitresource="KEY: 18:72057594046775296 (b42d8e559092)" waittime="2503" ownerId="33411557480" transactionname="user_transaction" lasttranstarted="2021-12-01T01:06:15.303" XDES="0x1ddd2df4420" lockMode="RangeS-S" schedulerid="20" kpid="23000" status="suspended" spid="55" sbid="2" ecid="0" priority="0" trancount="1" lastbatchstarted="2021-12-01T01:06:15.310" lastbatchcompleted="2021-12-01T01:06:15.300" lastattention="1900-01-01T00:00:00.300" clientapp="Core Microsoft SqlClient Data Provider" hostpid="11020" isolationlevel="serializable (4)" xactid="33411557480" currentdb="18" currentdbname="xxx" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
175      <executionStack>
176        <frame procname="xxx.dbo.spGetManageServicesRequest" line="10" stmtstart="356" stmtend="4256" sqlhandle="0x030012001374fc02f91433019aad000001000000000000000000000000000000000000000000000000000000"></frame>
177      </executionStack>
178    </process>
179    <process id="process1dbfa1c1c28" taskpriority="0" logused="1232" waitresource="KEY: 18:72057594046971904 (ffffffffffff)" waittime="6275" ownerId="33411563398" transactionname="user_transaction" lasttranstarted="2021-12-01T01:06:16.450" XDES="0x3d4e842c420" lockMode="RangeI-N" schedulerid="31" kpid="36432" status="suspended" spid="419" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-12-01T01:06:16.480" lastbatchcompleted="2021-12-01T01:06:16.463" lastattention="1900-01-01T00:00:00.463" clientapp="Core Microsoft SqlClient Data Provider"  hostpid="11020" isolationlevel="serializable (4)" xactid="33411563398" currentdb="18" currentdbname="xxx" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
180      <executionStack>
181        <frame procname="xxx.dbo.spCreateManageServicesRequest" line="40" stmtstart="2592" stmtend="3226" sqlhandle="0x03001200f01ab84aeb1433019aad000001000000000000000000000000000000000000000000000000000000"></frame>
182      </executionStack>
183    </process>
184  </process-list>
185  <resource-list>
186    <keylock hobtid="72057594046775296" dbid="18" objectname="xxx.dbo.ServiceChange" indexname="PK_ServiceChange" id="lock202ecfd0380" mode="X" associatedObjectId="72057594046775296">
187      <owner-list>
188        <owner id="process1dbfa1c1c28" mode="X" />
189      </owner-list>
190      <waiter-list>
191        <waiter id="process1dbfa86c4e8" mode="RangeS-S" requestType="wait" />
192      </waiter-list>
193    </keylock>
194    <keylock hobtid="72057594046971904" dbid="18" objectname="xxx.dbo.ServiceChangeParameter" indexname="PK_ServiceChangeParameter" id="lock27d3d371880" mode="RangeS-S" associatedObjectId="72057594046971904">
195      <owner-list>
196        <owner id="process1dbfa86c4e8" mode="RangeS-S" />
197      </owner-list>
198      <waiter-list>
199        <waiter id="process1dbfa1c1c28" mode="RangeI-N" requestType="wait" />
200      </waiter-list>
201    </keylock>
202  </resource-list>
203</deadlock>
204SELECT ...
205FROM [dbo].[ManageServicesRequest] AS [MR]
206  LEFT JOIN [dbo].[ServiceChange] AS [SC]  ON [SC].[ReferenceTransactionId] = [MR].[ReferenceTransactionId]
207INSERT INTO [dbo].[ManageServicesRequest] 
208VALUES (26410821, GETDATE(), 1, GETDATE()), 
209       (26410822, GETDATE(), 1, GETDATE()), 
210       (26410823, GETDATE(), 1, GETDATE());
211
212INSERT INTO [dbo].[ServiceChange] 
213VALUES (26410821, 'X', 'X', GETDATE()), 
214       (26410822, 'X', 'X', GETDATE()), 
215       (26410823, 'X', 'X', GETDATE());
216
217INSERT INTO [dbo].[ServiceChangeParameter]  
218VALUES (26410821, 'X', 'P1','P1', GETDATE()), 
219       (26410823, 'X', 'P1','P1', GETDATE());
220

1CREATE TABLE [dbo].[ManageServicesRequest]
2(
3    [ReferenceTransactionId]    INT                 NOT NULL,
4    [OrderDate]                 DATETIMEOFFSET(7)   NOT NULL,
5    [QueuePriority]             INT                 NOT NULL,
6    [Queued]                    DATETIMEOFFSET(7)   NULL,
7    CONSTRAINT [PK_ManageServicesRequest] PRIMARY KEY CLUSTERED ([ReferenceTransactionId]),
8)
9
10CREATE TABLE [dbo].[ServiceChange]
11(
12    [ReferenceTransactionId]    INT                 NOT NULL,
13    [ServiceId]                 VARCHAR(50)         NOT NULL,
14    [ServiceStatus]             CHAR(1)             NOT NULL,
15    [ValidFrom]                 DATETIMEOFFSET(7)   NOT NULL,
16    CONSTRAINT [PK_ServiceChange] PRIMARY KEY CLUSTERED ([ReferenceTransactionId],[ServiceId]),
17    CONSTRAINT [FK_ServiceChange_ManageServiceRequest] FOREIGN KEY ([ReferenceTransactionId]) REFERENCES [ManageServicesRequest]([ReferenceTransactionId]) ON DELETE CASCADE,
18    INDEX [IDX_ServiceChange_ManageServiceRequestId] ([ReferenceTransactionId]),
19    INDEX [IDX_ServiceChange_ServiceId] ([ServiceId])
20)
21
22CREATE TABLE [dbo].[ServiceChangeParameter]
23(
24    [ReferenceTransactionId]    INT                 NOT NULL,
25    [ServiceId]                 VARCHAR(50)         NOT NULL,
26    [ParamCode]                 VARCHAR(50)         NOT NULL,
27    [ParamValue]                VARCHAR(50)         NOT NULL,
28    [ParamValidFrom]            DATETIMEOFFSET(7)   NOT NULL,
29    CONSTRAINT [PK_ServiceChangeParameter] PRIMARY KEY CLUSTERED ([ReferenceTransactionId],[ServiceId],[ParamCode]),
30    CONSTRAINT [FK_ServiceChangeParameter_ServiceChange] FOREIGN KEY ([ReferenceTransactionId],[ServiceId]) REFERENCES [ServiceChange] ([ReferenceTransactionId],[ServiceId]) ON DELETE CASCADE,
31    INDEX [IDX_ServiceChangeParameter_ManageServiceRequestId] ([ReferenceTransactionId]),
32    INDEX [IDX_ServiceChangeParameter_ServiceId] ([ServiceId]),
33    INDEX [IDX_ServiceChangeParameter_ParamCode] ([ParamCode])
34)
35CREATE PROCEDURE [dbo].[spCreateManageServicesRequest]
36    @ReferenceTransactionId INT,
37    @OrderDate DATETIMEOFFSET,
38    @QueuePriority INT,
39    @Services ServiceChangeUdt READONLY,
40    @Parameters ServiceChangeParameterUdt READONLY
41AS
42BEGIN
43    SET NOCOUNT ON;
44
45    BEGIN TRY
46    /* VYTVOŘ NOVÝ REQUEST NA ZMĚNU SLUŽEB */
47
48        /*  INSERT REQUEST  */
49        INSERT INTO [dbo].[ManageServicesRequest]
50            ([ReferenceTransactionId]
51            ,[OrderDate]
52            ,[QueuePriority]
53            ,[Queued])
54        VALUES
55            (@ReferenceTransactionId
56            ,@OrderDate
57            ,@QueuePriority
58            ,NULL)
59
60        /*  INSERT SERVICES */
61        INSERT INTO [dbo].[ServiceChange]
62            ([ReferenceTransactionId]
63            ,[ServiceId]
64            ,[ServiceStatus]
65            ,[ValidFrom])
66        SELECT 
67             @ReferenceTransactionId AS [ReferenceTransactionId]
68            ,[ServiceId]
69            ,[ServiceStatus]
70            ,[ValidFrom]
71        FROM @Services AS [S]
72
73        /*  INSERT PARAMS   */
74        INSERT INTO [dbo].[ServiceChangeParameter]
75            ([ReferenceTransactionId]
76            ,[ServiceId]
77            ,[ParamCode]
78            ,[ParamValue]
79            ,[ParamValidFrom])
80        SELECT 
81            @ReferenceTransactionId AS [ReferenceTransactionId]
82            ,[ServiceId]
83            ,[ParamCode]
84            ,[ParamValue]
85            ,[ParamValidFrom]
86        FROM @Parameters AS [P]
87
88    END TRY
89    BEGIN CATCH
90        THROW
91    END CATCH
92END
93
94CREATE PROCEDURE [dbo].[spGetManageServicesRequest]
95    @ReferenceTransactionId INT
96AS
97BEGIN
98    SET NOCOUNT ON;
99
100    BEGIN TRY 
101        /* VRAŤ MANAGE SERVICES REQUEST PODLE ID */
102
103        SELECT 
104            [MR].[ReferenceTransactionId], 
105            [MR].[OrderDate], 
106            [MR].[QueuePriority], 
107            [MR].[Queued], 
108            
109            [SC].[ReferenceTransactionId], 
110            [SC].[ServiceId], 
111            [SC].[ServiceStatus], 
112            [SC].[ValidFrom],
113            
114            [SP].[ReferenceTransactionId], 
115            [SP].[ServiceId], 
116            [SP].[ParamCode], 
117            [SP].[ParamValue], 
118            [SP].[ParamValidFrom]
119
120        FROM [dbo].[ManageServicesRequest] AS [MR]
121        LEFT JOIN [dbo].[ServiceChange] AS [SC] ON [SC].[ReferenceTransactionId] = [MR].[ReferenceTransactionId]
122        LEFT JOIN [dbo].[ServiceChangeParameter] AS [SP] ON [SP].[ReferenceTransactionId] = [SC].[ReferenceTransactionId] AND [SP].[ServiceId] = [SC].[ServiceId]
123        WHERE [MR].[ReferenceTransactionId] = @ReferenceTransactionId
124
125    END TRY
126    BEGIN CATCH
127        THROW
128    END CATCH
129END
130public async Task Consume(ConsumeContext<CreateCommand> context)
131{
132    using (var sql = sqlFactory.Cip)
133    {
134        /*SAVE REQUEST TO DATABASE*/
135        sql.StartTransaction(System.Data.IsolationLevel.Serializable); <----- First transaction starts
136
137        /* Create id */
138        var transactionId = await GetNewId(context.Message.CorrelationId);
139
140        /* Create manage services request */
141        await sql.OrderingGateway.ManageServices.Create(transactionId,  context.Message.ApiRequest.OrderDate, context.Message.ApiRequest.Priority, services);
142
143        sql.Commit(); <----- First transaction ends
144        
145
146        /// .... Some other stuff ...
147
148        /* Fetch the same object you created in the first transaction */
149        Try
150        {
151            sql.StartTransaction(System.Data.IsolationLevel.Serializable);
152            
153            var request = await sql.OrderingGateway.ManageServices.Get(transactionId); <----- HERE BE THE DEADLOCK, 
154
155            request.Queued = DateTimeOffset.Now;
156            await sql.OrderingGateway.ManageServices.Update(request);
157
158            ... Here is a posting to a microservice queue ...
159        
160            sql.Commit();
161        }
162        catch (Exception)
163        {
164            sql.RollBack();
165        }
166        
167        /// .... Some other stuff ....
168}
169<deadlock>
170  <victim-list>
171    <victimProcess id="process1dbfa86c4e8" />
172  </victim-list>
173  <process-list>
174    <process id="process1dbfa86c4e8" taskpriority="0" logused="0" waitresource="KEY: 18:72057594046775296 (b42d8e559092)" waittime="2503" ownerId="33411557480" transactionname="user_transaction" lasttranstarted="2021-12-01T01:06:15.303" XDES="0x1ddd2df4420" lockMode="RangeS-S" schedulerid="20" kpid="23000" status="suspended" spid="55" sbid="2" ecid="0" priority="0" trancount="1" lastbatchstarted="2021-12-01T01:06:15.310" lastbatchcompleted="2021-12-01T01:06:15.300" lastattention="1900-01-01T00:00:00.300" clientapp="Core Microsoft SqlClient Data Provider" hostpid="11020" isolationlevel="serializable (4)" xactid="33411557480" currentdb="18" currentdbname="xxx" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
175      <executionStack>
176        <frame procname="xxx.dbo.spGetManageServicesRequest" line="10" stmtstart="356" stmtend="4256" sqlhandle="0x030012001374fc02f91433019aad000001000000000000000000000000000000000000000000000000000000"></frame>
177      </executionStack>
178    </process>
179    <process id="process1dbfa1c1c28" taskpriority="0" logused="1232" waitresource="KEY: 18:72057594046971904 (ffffffffffff)" waittime="6275" ownerId="33411563398" transactionname="user_transaction" lasttranstarted="2021-12-01T01:06:16.450" XDES="0x3d4e842c420" lockMode="RangeI-N" schedulerid="31" kpid="36432" status="suspended" spid="419" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-12-01T01:06:16.480" lastbatchcompleted="2021-12-01T01:06:16.463" lastattention="1900-01-01T00:00:00.463" clientapp="Core Microsoft SqlClient Data Provider"  hostpid="11020" isolationlevel="serializable (4)" xactid="33411563398" currentdb="18" currentdbname="xxx" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
180      <executionStack>
181        <frame procname="xxx.dbo.spCreateManageServicesRequest" line="40" stmtstart="2592" stmtend="3226" sqlhandle="0x03001200f01ab84aeb1433019aad000001000000000000000000000000000000000000000000000000000000"></frame>
182      </executionStack>
183    </process>
184  </process-list>
185  <resource-list>
186    <keylock hobtid="72057594046775296" dbid="18" objectname="xxx.dbo.ServiceChange" indexname="PK_ServiceChange" id="lock202ecfd0380" mode="X" associatedObjectId="72057594046775296">
187      <owner-list>
188        <owner id="process1dbfa1c1c28" mode="X" />
189      </owner-list>
190      <waiter-list>
191        <waiter id="process1dbfa86c4e8" mode="RangeS-S" requestType="wait" />
192      </waiter-list>
193    </keylock>
194    <keylock hobtid="72057594046971904" dbid="18" objectname="xxx.dbo.ServiceChangeParameter" indexname="PK_ServiceChangeParameter" id="lock27d3d371880" mode="RangeS-S" associatedObjectId="72057594046971904">
195      <owner-list>
196        <owner id="process1dbfa86c4e8" mode="RangeS-S" />
197      </owner-list>
198      <waiter-list>
199        <waiter id="process1dbfa1c1c28" mode="RangeI-N" requestType="wait" />
200      </waiter-list>
201    </keylock>
202  </resource-list>
203</deadlock>
204SELECT ...
205FROM [dbo].[ManageServicesRequest] AS [MR]
206  LEFT JOIN [dbo].[ServiceChange] AS [SC]  ON [SC].[ReferenceTransactionId] = [MR].[ReferenceTransactionId]
207INSERT INTO [dbo].[ManageServicesRequest] 
208VALUES (26410821, GETDATE(), 1, GETDATE()), 
209       (26410822, GETDATE(), 1, GETDATE()), 
210       (26410823, GETDATE(), 1, GETDATE());
211
212INSERT INTO [dbo].[ServiceChange] 
213VALUES (26410821, 'X', 'X', GETDATE()), 
214       (26410822, 'X', 'X', GETDATE()), 
215       (26410823, 'X', 'X', GETDATE());
216
217INSERT INTO [dbo].[ServiceChangeParameter]  
218VALUES (26410821, 'X', 'P1','P1', GETDATE()), 
219       (26410823, 'X', 'P1','P1', GETDATE());
220Process 51 acquiring IS lock on OBJECT: 7:1557580587:0  (class bit2000000 ref1) result: OK
221
222Process 51 acquiring IS lock on OBJECT: 7:1509580416:0  (class bit2000000 ref1) result: OK
223
224Process 51 acquiring IS lock on OBJECT: 7:1477580302:0  (class bit2000000 ref1) result: OK
225
226Process 51 acquiring IS lock on PAGE: 7:1:600  (class bit2000000 ref0) result: OK
227
228Process 51 acquiring S lock on KEY: 7:72057594044940288 (1b148afa48fb) (class bit2000000 ref0) result: OK
229
230Process 51 acquiring IS lock on PAGE: 7:1:608  (class bit2000000 ref0) result: OK
231
232Process 51 acquiring RangeS-S lock on KEY: 7:72057594045005824 (a69d56b089b6) (class bit2000000 ref0) result: OK
233
234Process 51 acquiring IS lock on PAGE: 7:1:632  (class bit2000000 ref0) result: OK
235
236Process 51 acquiring RangeS-S lock on KEY: 7:72057594045202432 (c37d1982c3c9) (class bit2000000 ref0) result: OK
237
238Process 51 acquiring RangeS-S lock on KEY: 7:72057594045005824 (2ef5265f2b42) (class bit2000000 ref0) result: OK
239

1CREATE TABLE [dbo].[ManageServicesRequest]
2(
3    [ReferenceTransactionId]    INT                 NOT NULL,
4    [OrderDate]                 DATETIMEOFFSET(7)   NOT NULL,
5    [QueuePriority]             INT                 NOT NULL,
6    [Queued]                    DATETIMEOFFSET(7)   NULL,
7    CONSTRAINT [PK_ManageServicesRequest] PRIMARY KEY CLUSTERED ([ReferenceTransactionId]),
8)
9
10CREATE TABLE [dbo].[ServiceChange]
11(
12    [ReferenceTransactionId]    INT                 NOT NULL,
13    [ServiceId]                 VARCHAR(50)         NOT NULL,
14    [ServiceStatus]             CHAR(1)             NOT NULL,
15    [ValidFrom]                 DATETIMEOFFSET(7)   NOT NULL,
16    CONSTRAINT [PK_ServiceChange] PRIMARY KEY CLUSTERED ([ReferenceTransactionId],[ServiceId]),
17    CONSTRAINT [FK_ServiceChange_ManageServiceRequest] FOREIGN KEY ([ReferenceTransactionId]) REFERENCES [ManageServicesRequest]([ReferenceTransactionId]) ON DELETE CASCADE,
18    INDEX [IDX_ServiceChange_ManageServiceRequestId] ([ReferenceTransactionId]),
19    INDEX [IDX_ServiceChange_ServiceId] ([ServiceId])
20)
21
22CREATE TABLE [dbo].[ServiceChangeParameter]
23(
24    [ReferenceTransactionId]    INT                 NOT NULL,
25    [ServiceId]                 VARCHAR(50)         NOT NULL,
26    [ParamCode]                 VARCHAR(50)         NOT NULL,
27    [ParamValue]                VARCHAR(50)         NOT NULL,
28    [ParamValidFrom]            DATETIMEOFFSET(7)   NOT NULL,
29    CONSTRAINT [PK_ServiceChangeParameter] PRIMARY KEY CLUSTERED ([ReferenceTransactionId],[ServiceId],[ParamCode]),
30    CONSTRAINT [FK_ServiceChangeParameter_ServiceChange] FOREIGN KEY ([ReferenceTransactionId],[ServiceId]) REFERENCES [ServiceChange] ([ReferenceTransactionId],[ServiceId]) ON DELETE CASCADE,
31    INDEX [IDX_ServiceChangeParameter_ManageServiceRequestId] ([ReferenceTransactionId]),
32    INDEX [IDX_ServiceChangeParameter_ServiceId] ([ServiceId]),
33    INDEX [IDX_ServiceChangeParameter_ParamCode] ([ParamCode])
34)
35CREATE PROCEDURE [dbo].[spCreateManageServicesRequest]
36    @ReferenceTransactionId INT,
37    @OrderDate DATETIMEOFFSET,
38    @QueuePriority INT,
39    @Services ServiceChangeUdt READONLY,
40    @Parameters ServiceChangeParameterUdt READONLY
41AS
42BEGIN
43    SET NOCOUNT ON;
44
45    BEGIN TRY
46    /* VYTVOŘ NOVÝ REQUEST NA ZMĚNU SLUŽEB */
47
48        /*  INSERT REQUEST  */
49        INSERT INTO [dbo].[ManageServicesRequest]
50            ([ReferenceTransactionId]
51            ,[OrderDate]
52            ,[QueuePriority]
53            ,[Queued])
54        VALUES
55            (@ReferenceTransactionId
56            ,@OrderDate
57            ,@QueuePriority
58            ,NULL)
59
60        /*  INSERT SERVICES */
61        INSERT INTO [dbo].[ServiceChange]
62            ([ReferenceTransactionId]
63            ,[ServiceId]
64            ,[ServiceStatus]
65            ,[ValidFrom])
66        SELECT 
67             @ReferenceTransactionId AS [ReferenceTransactionId]
68            ,[ServiceId]
69            ,[ServiceStatus]
70            ,[ValidFrom]
71        FROM @Services AS [S]
72
73        /*  INSERT PARAMS   */
74        INSERT INTO [dbo].[ServiceChangeParameter]
75            ([ReferenceTransactionId]
76            ,[ServiceId]
77            ,[ParamCode]
78            ,[ParamValue]
79            ,[ParamValidFrom])
80        SELECT 
81            @ReferenceTransactionId AS [ReferenceTransactionId]
82            ,[ServiceId]
83            ,[ParamCode]
84            ,[ParamValue]
85            ,[ParamValidFrom]
86        FROM @Parameters AS [P]
87
88    END TRY
89    BEGIN CATCH
90        THROW
91    END CATCH
92END
93
94CREATE PROCEDURE [dbo].[spGetManageServicesRequest]
95    @ReferenceTransactionId INT
96AS
97BEGIN
98    SET NOCOUNT ON;
99
100    BEGIN TRY 
101        /* VRAŤ MANAGE SERVICES REQUEST PODLE ID */
102
103        SELECT 
104            [MR].[ReferenceTransactionId], 
105            [MR].[OrderDate], 
106            [MR].[QueuePriority], 
107            [MR].[Queued], 
108            
109            [SC].[ReferenceTransactionId], 
110            [SC].[ServiceId], 
111            [SC].[ServiceStatus], 
112            [SC].[ValidFrom],
113            
114            [SP].[ReferenceTransactionId], 
115            [SP].[ServiceId], 
116            [SP].[ParamCode], 
117            [SP].[ParamValue], 
118            [SP].[ParamValidFrom]
119
120        FROM [dbo].[ManageServicesRequest] AS [MR]
121        LEFT JOIN [dbo].[ServiceChange] AS [SC] ON [SC].[ReferenceTransactionId] = [MR].[ReferenceTransactionId]
122        LEFT JOIN [dbo].[ServiceChangeParameter] AS [SP] ON [SP].[ReferenceTransactionId] = [SC].[ReferenceTransactionId] AND [SP].[ServiceId] = [SC].[ServiceId]
123        WHERE [MR].[ReferenceTransactionId] = @ReferenceTransactionId
124
125    END TRY
126    BEGIN CATCH
127        THROW
128    END CATCH
129END
130public async Task Consume(ConsumeContext<CreateCommand> context)
131{
132    using (var sql = sqlFactory.Cip)
133    {
134        /*SAVE REQUEST TO DATABASE*/
135        sql.StartTransaction(System.Data.IsolationLevel.Serializable); <----- First transaction starts
136
137        /* Create id */
138        var transactionId = await GetNewId(context.Message.CorrelationId);
139
140        /* Create manage services request */
141        await sql.OrderingGateway.ManageServices.Create(transactionId,  context.Message.ApiRequest.OrderDate, context.Message.ApiRequest.Priority, services);
142
143        sql.Commit(); <----- First transaction ends
144        
145
146        /// .... Some other stuff ...
147
148        /* Fetch the same object you created in the first transaction */
149        Try
150        {
151            sql.StartTransaction(System.Data.IsolationLevel.Serializable);
152            
153            var request = await sql.OrderingGateway.ManageServices.Get(transactionId); <----- HERE BE THE DEADLOCK, 
154
155            request.Queued = DateTimeOffset.Now;
156            await sql.OrderingGateway.ManageServices.Update(request);
157
158            ... Here is a posting to a microservice queue ...
159        
160            sql.Commit();
161        }
162        catch (Exception)
163        {
164            sql.RollBack();
165        }
166        
167        /// .... Some other stuff ....
168}
169<deadlock>
170  <victim-list>
171    <victimProcess id="process1dbfa86c4e8" />
172  </victim-list>
173  <process-list>
174    <process id="process1dbfa86c4e8" taskpriority="0" logused="0" waitresource="KEY: 18:72057594046775296 (b42d8e559092)" waittime="2503" ownerId="33411557480" transactionname="user_transaction" lasttranstarted="2021-12-01T01:06:15.303" XDES="0x1ddd2df4420" lockMode="RangeS-S" schedulerid="20" kpid="23000" status="suspended" spid="55" sbid="2" ecid="0" priority="0" trancount="1" lastbatchstarted="2021-12-01T01:06:15.310" lastbatchcompleted="2021-12-01T01:06:15.300" lastattention="1900-01-01T00:00:00.300" clientapp="Core Microsoft SqlClient Data Provider" hostpid="11020" isolationlevel="serializable (4)" xactid="33411557480" currentdb="18" currentdbname="xxx" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
175      <executionStack>
176        <frame procname="xxx.dbo.spGetManageServicesRequest" line="10" stmtstart="356" stmtend="4256" sqlhandle="0x030012001374fc02f91433019aad000001000000000000000000000000000000000000000000000000000000"></frame>
177      </executionStack>
178    </process>
179    <process id="process1dbfa1c1c28" taskpriority="0" logused="1232" waitresource="KEY: 18:72057594046971904 (ffffffffffff)" waittime="6275" ownerId="33411563398" transactionname="user_transaction" lasttranstarted="2021-12-01T01:06:16.450" XDES="0x3d4e842c420" lockMode="RangeI-N" schedulerid="31" kpid="36432" status="suspended" spid="419" sbid="2" ecid="0" priority="0" trancount="2" lastbatchstarted="2021-12-01T01:06:16.480" lastbatchcompleted="2021-12-01T01:06:16.463" lastattention="1900-01-01T00:00:00.463" clientapp="Core Microsoft SqlClient Data Provider"  hostpid="11020" isolationlevel="serializable (4)" xactid="33411563398" currentdb="18" currentdbname="xxx" lockTimeout="4294967295" clientoption1="673185824" clientoption2="128056">
180      <executionStack>
181        <frame procname="xxx.dbo.spCreateManageServicesRequest" line="40" stmtstart="2592" stmtend="3226" sqlhandle="0x03001200f01ab84aeb1433019aad000001000000000000000000000000000000000000000000000000000000"></frame>
182      </executionStack>
183    </process>
184  </process-list>
185  <resource-list>
186    <keylock hobtid="72057594046775296" dbid="18" objectname="xxx.dbo.ServiceChange" indexname="PK_ServiceChange" id="lock202ecfd0380" mode="X" associatedObjectId="72057594046775296">
187      <owner-list>
188        <owner id="process1dbfa1c1c28" mode="X" />
189      </owner-list>
190      <waiter-list>
191        <waiter id="process1dbfa86c4e8" mode="RangeS-S" requestType="wait" />
192      </waiter-list>
193    </keylock>
194    <keylock hobtid="72057594046971904" dbid="18" objectname="xxx.dbo.ServiceChangeParameter" indexname="PK_ServiceChangeParameter" id="lock27d3d371880" mode="RangeS-S" associatedObjectId="72057594046971904">
195      <owner-list>
196        <owner id="process1dbfa86c4e8" mode="RangeS-S" />
197      </owner-list>
198      <waiter-list>
199        <waiter id="process1dbfa1c1c28" mode="RangeI-N" requestType="wait" />
200      </waiter-list>
201    </keylock>
202  </resource-list>
203</deadlock>
204SELECT ...
205FROM [dbo].[ManageServicesRequest] AS [MR]
206  LEFT JOIN [dbo].[ServiceChange] AS [SC]  ON [SC].[ReferenceTransactionId] = [MR].[ReferenceTransactionId]
207INSERT INTO [dbo].[ManageServicesRequest] 
208VALUES (26410821, GETDATE(), 1, GETDATE()), 
209       (26410822, GETDATE(), 1, GETDATE()), 
210       (26410823, GETDATE(), 1, GETDATE());
211
212INSERT INTO [dbo].[ServiceChange] 
213VALUES (26410821, 'X', 'X', GETDATE()), 
214       (26410822, 'X', 'X', GETDATE()), 
215       (26410823, 'X', 'X', GETDATE());
216
217INSERT INTO [dbo].[ServiceChangeParameter]  
218VALUES (26410821, 'X', 'P1','P1', GETDATE()), 
219       (26410823, 'X', 'P1','P1', GETDATE());
220Process 51 acquiring IS lock on OBJECT: 7:1557580587:0  (class bit2000000 ref1) result: OK
221
222Process 51 acquiring IS lock on OBJECT: 7:1509580416:0  (class bit2000000 ref1) result: OK
223
224Process 51 acquiring IS lock on OBJECT: 7:1477580302:0  (class bit2000000 ref1) result: OK
225
226Process 51 acquiring IS lock on PAGE: 7:1:600  (class bit2000000 ref0) result: OK
227
228Process 51 acquiring S lock on KEY: 7:72057594044940288 (1b148afa48fb) (class bit2000000 ref0) result: OK
229
230Process 51 acquiring IS lock on PAGE: 7:1:608  (class bit2000000 ref0) result: OK
231
232Process 51 acquiring RangeS-S lock on KEY: 7:72057594045005824 (a69d56b089b6) (class bit2000000 ref0) result: OK
233
234Process 51 acquiring IS lock on PAGE: 7:1:632  (class bit2000000 ref0) result: OK
235
236Process 51 acquiring RangeS-S lock on KEY: 7:72057594045202432 (c37d1982c3c9) (class bit2000000 ref0) result: OK
237
238Process 51 acquiring RangeS-S lock on KEY: 7:72057594045005824 (2ef5265f2b42) (class bit2000000 ref0) result: OK
239SELECT ...
240FROM [dbo].[ManageServicesRequest] AS [MR]
241  LEFT JOIN [dbo].[ServiceChange] AS [SC]  ON [SC].[ReferenceTransactionId] = [MR].[ReferenceTransactionId]
242  LEFT HASH JOIN [dbo].[ServiceChangeParameter] AS [SP] ON [SP].[ReferenceTransactionId] = [MR].[ReferenceTransactionId] AND [SP].[ServiceId] = [SC].[ServiceId]
243  WHERE [MR].[ReferenceTransactionId] = @ReferenceTransactionId
244

1apiVersion: apps/v1
2kind: Deployment
3metadata:
4  name: service-b
5spec:
6  selector:
7    matchLabels:
8      run: service-b
9  replicas: 1
10  template:
11    metadata:
12      labels:
13        run: service-b
14    spec:
15      containers:
16        - name: service-b
17          image: nginx
18          ports:
19            - containerPort: 80
20              name: web
21---
22apiVersion: v1
23kind: Service
24metadata:
25  name: service-b
26  labels:
27    run: service-b
28spec:
29  ports:
30    - port: 8080
31      protocol: TCP
32      targetPort: 80
33      name: service-b
34  selector:
35    run: service-b
36
37---
38apiVersion: apps/v1
39kind: Deployment
40metadata:
41  name: service-a
42spec:
43  selector:
44    matchLabels:
45      run: service-a
46  replicas: 1
47  template:
48    metadata:
49      labels:
50        run: service-a
51    spec:
52      containers:
53        - name: service-a
54          image: nginx
55          ports:
56            - containerPort: 80
57              name: web
58---
59apiVersion: v1
60kind: Service
61metadata:
62  name: service-a
63  labels:
64    run: service-a
65spec:
66  ports:
67    - port: 8081
68      protocol: TCP
69      targetPort: 80
70      name: service-a
71  selector:
72    run: service-a
73
74root@service-a-d44f55d8c-8cp8m:/# curl -v service-b:8080
75
76< HTTP/1.1 200 OK
77< server: envoy
78
79root@service-a-d44f55d8c-8cp8m:/# curl -v service-x:7777
80apiVersion: v1
81kind: Service
82metadata:
83  name: service-x
84  labels:
85    run: service-x
86spec:
87  ports:
88    - port: 7777
89      protocol: TCP
90      targetPort: 80
91      name: service-x
92  selector:
93    run: service-b
94

1apiVersion: apps/v1
2kind: Deployment
3metadata:
4  name: service-b
5spec:
6  selector:
7    matchLabels:
8      run: service-b
9  replicas: 1
10  template:
11    metadata:
12      labels:
13        run: service-b
14    spec:
15      containers:
16        - name: service-b
17          image: nginx
18          ports:
19            - containerPort: 80
20              name: web
21---
22apiVersion: v1
23kind: Service
24metadata:
25  name: service-b
26  labels:
27    run: service-b
28spec:
29  ports:
30    - port: 8080
31      protocol: TCP
32      targetPort: 80
33      name: service-b
34  selector:
35    run: service-b
36
37---
38apiVersion: apps/v1
39kind: Deployment
40metadata:
41  name: service-a
42spec:
43  selector:
44    matchLabels:
45      run: service-a
46  replicas: 1
47  template:
48    metadata:
49      labels:
50        run: service-a
51    spec:
52      containers:
53        - name: service-a
54          image: nginx
55          ports:
56            - containerPort: 80
57              name: web
58---
59apiVersion: v1
60kind: Service
61metadata:
62  name: service-a
63  labels:
64    run: service-a
65spec:
66  ports:
67    - port: 8081
68      protocol: TCP
69      targetPort: 80
70      name: service-a
71  selector:
72    run: service-a
73
74root@service-a-d44f55d8c-8cp8m:/# curl -v service-b:8080
75
76< HTTP/1.1 200 OK
77< server: envoy
78
79root@service-a-d44f55d8c-8cp8m:/# curl -v service-x:7777
80apiVersion: v1
81kind: Service
82metadata:
83  name: service-x
84  labels:
85    run: service-x
86spec:
87  ports:
88    - port: 7777
89      protocol: TCP
90      targetPort: 80
91      name: service-x
92  selector:
93    run: service-b
94# curl -vI service-b:8080
95
96*   Trying xx.xx.xx.xx:8080...
97* Connected to service-b (xx.xx.xx.xx) port 8080 (#0)
98> Host: service-b:8080
99< HTTP/1.1 200 OK
100< server: envoy
101

1apiVersion: apps/v1
2kind: Deployment
3metadata:
4  name: service-b
5spec:
6  selector:
7    matchLabels:
8      run: service-b
9  replicas: 1
10  template:
11    metadata:
12      labels:
13        run: service-b
14    spec:
15      containers:
16        - name: service-b
17          image: nginx
18          ports:
19            - containerPort: 80
20              name: web
21---
22apiVersion: v1
23kind: Service
24metadata:
25  name: service-b
26  labels:
27    run: service-b
28spec:
29  ports:
30    - port: 8080
31      protocol: TCP
32      targetPort: 80
33      name: service-b
34  selector:
35    run: service-b
36
37---
38apiVersion: apps/v1
39kind: Deployment
40metadata:
41  name: service-a
42spec:
43  selector:
44    matchLabels:
45      run: service-a
46  replicas: 1
47  template:
48    metadata:
49      labels:
50        run: service-a
51    spec:
52      containers:
53        - name: service-a
54          image: nginx
55          ports:
56            - containerPort: 80
57              name: web
58---
59apiVersion: v1
60kind: Service
61metadata:
62  name: service-a
63  labels:
64    run: service-a
65spec:
66  ports:
67    - port: 8081
68      protocol: TCP
69      targetPort: 80
70      name: service-a
71  selector:
72    run: service-a
73
74root@service-a-d44f55d8c-8cp8m:/# curl -v service-b:8080
75
76< HTTP/1.1 200 OK
77< server: envoy
78
79root@service-a-d44f55d8c-8cp8m:/# curl -v service-x:7777
80apiVersion: v1
81kind: Service
82metadata:
83  name: service-x
84  labels:
85    run: service-x
86spec:
87  ports:
88    - port: 7777
89      protocol: TCP
90      targetPort: 80
91      name: service-x
92  selector:
93    run: service-b
94# curl -vI service-b:8080
95
96*   Trying xx.xx.xx.xx:8080...
97* Connected to service-b (xx.xx.xx.xx) port 8080 (#0)
98> Host: service-b:8080
99< HTTP/1.1 200 OK
100< server: envoy
101# curl -vI service-x:7777
102
103*   Trying yy.yy.yy.yy:7777...
104* Connected to service-x (yy.yy.yy.yy) port 7777 (#0)
105> Host: service-x:7777
106< HTTP/1.1 200 OK
107< server: envoy
108

1apiVersion: apps/v1
2kind: Deployment
3metadata:
4  name: service-b
5spec:
6  selector:
7    matchLabels:
8      run: service-b
9  replicas: 1
10  template:
11    metadata:
12      labels:
13        run: service-b
14    spec:
15      containers:
16        - name: service-b
17          image: nginx
18          ports:
19            - containerPort: 80
20              name: web
21---
22apiVersion: v1
23kind: Service
24metadata:
25  name: service-b
26  labels:
27    run: service-b
28spec:
29  ports:
30    - port: 8080
31      protocol: TCP
32      targetPort: 80
33      name: service-b
34  selector:
35    run: service-b
36
37---
38apiVersion: apps/v1
39kind: Deployment
40metadata:
41  name: service-a
42spec:
43  selector:
44    matchLabels:
45      run: service-a
46  replicas: 1
47  template:
48    metadata:
49      labels:
50        run: service-a
51    spec:
52      containers:
53        - name: service-a
54          image: nginx
55          ports:
56            - containerPort: 80
57              name: web
58---
59apiVersion: v1
60kind: Service
61metadata:
62  name: service-a
63  labels:
64    run: service-a
65spec:
66  ports:
67    - port: 8081
68      protocol: TCP
69      targetPort: 80
70      name: service-a
71  selector:
72    run: service-a
73
74root@service-a-d44f55d8c-8cp8m:/# curl -v service-b:8080
75
76< HTTP/1.1 200 OK
77< server: envoy
78
79root@service-a-d44f55d8c-8cp8m:/# curl -v service-x:7777
80apiVersion: v1
81kind: Service
82metadata:
83  name: service-x
84  labels:
85    run: service-x
86spec:
87  ports:
88    - port: 7777
89      protocol: TCP
90      targetPort: 80
91      name: service-x
92  selector:
93    run: service-b
94# curl -vI service-b:8080
95
96*   Trying xx.xx.xx.xx:8080...
97* Connected to service-b (xx.xx.xx.xx) port 8080 (#0)
98> Host: service-b:8080
99< HTTP/1.1 200 OK
100< server: envoy
101# curl -vI service-x:7777
102
103*   Trying yy.yy.yy.yy:7777...
104* Connected to service-x (yy.yy.yy.yy) port 7777 (#0)
105> Host: service-x:7777
106< HTTP/1.1 200 OK
107< server: envoy
108apiVersion: v1
109kind: Service
110metadata:
111  name: service-x
112  labels:
113    run: service-x
114spec:
115  ports:
116    - port: 7777
117      protocol: TCP
118      targetPort: 80
119      name: service-x
120

1apiVersion: apps/v1
2kind: Deployment
3metadata:
4  name: service-b
5spec:
6  selector:
7    matchLabels:
8      run: service-b
9  replicas: 1
10  template:
11    metadata:
12      labels:
13        run: service-b
14    spec:
15      containers:
16        - name: service-b
17          image: nginx
18          ports:
19            - containerPort: 80
20              name: web
21---
22apiVersion: v1
23kind: Service
24metadata:
25  name: service-b
26  labels:
27    run: service-b
28spec:
29  ports:
30    - port: 8080
31      protocol: TCP
32      targetPort: 80
33      name: service-b
34  selector:
35    run: service-b
36
37---
38apiVersion: apps/v1
39kind: Deployment
40metadata:
41  name: service-a
42spec:
43  selector:
44    matchLabels:
45      run: service-a
46  replicas: 1
47  template:
48    metadata:
49      labels:
50        run: service-a
51    spec:
52      containers:
53        - name: service-a
54          image: nginx
55          ports:
56            - containerPort: 80
57              name: web
58---
59apiVersion: v1
60kind: Service
61metadata:
62  name: service-a
63  labels:
64    run: service-a
65spec:
66  ports:
67    - port: 8081
68      protocol: TCP
69      targetPort: 80
70      name: service-a
71  selector:
72    run: service-a
73
74root@service-a-d44f55d8c-8cp8m:/# curl -v service-b:8080
75
76< HTTP/1.1 200 OK
77< server: envoy
78
79root@service-a-d44f55d8c-8cp8m:/# curl -v service-x:7777
80apiVersion: v1
81kind: Service
82metadata:
83  name: service-x
84  labels:
85    run: service-x
86spec:
87  ports:
88    - port: 7777
89      protocol: TCP
90      targetPort: 80
91      name: service-x
92  selector:
93    run: service-b
94# curl -vI service-b:8080
95
96*   Trying xx.xx.xx.xx:8080...
97* Connected to service-b (xx.xx.xx.xx) port 8080 (#0)
98> Host: service-b:8080
99< HTTP/1.1 200 OK
100< server: envoy
101# curl -vI service-x:7777
102
103*   Trying yy.yy.yy.yy:7777...
104* Connected to service-x (yy.yy.yy.yy) port 7777 (#0)
105> Host: service-x:7777
106< HTTP/1.1 200 OK
107< server: envoy
108apiVersion: v1
109kind: Service
110metadata:
111  name: service-x
112  labels:
113    run: service-x
114spec:
115  ports:
116    - port: 7777
117      protocol: TCP
118      targetPort: 80
119      name: service-x
120# curl -vI service-x:7777
121
122*   Trying yy.yy.yy.yy:7777...
123* Connected to service-x (yy.yy.yy.yy) port 7777 (#0)
124> Host: service-x:7777
125< HTTP/1.1 503 Service Unavailable
126< server: envoy
127

1apiVersion: apps/v1
2kind: Deployment
3metadata:
4  name: service-b
5spec:
6  selector:
7    matchLabels:
8      run: service-b
9  replicas: 1
10  template:
11    metadata:
12      labels:
13        run: service-b
14    spec:
15      containers:
16        - name: service-b
17          image: nginx
18          ports:
19            - containerPort: 80
20              name: web
21---
22apiVersion: v1
23kind: Service
24metadata:
25  name: service-b
26  labels:
27    run: service-b
28spec:
29  ports:
30    - port: 8080
31      protocol: TCP
32      targetPort: 80
33      name: service-b
34  selector:
35    run: service-b
36
37---
38apiVersion: apps/v1
39kind: Deployment
40metadata:
41  name: service-a
42spec:
43  selector:
44    matchLabels:
45      run: service-a
46  replicas: 1
47  template:
48    metadata:
49      labels:
50        run: service-a
51    spec:
52      containers:
53        - name: service-a
54          image: nginx
55          ports:
56            - containerPort: 80
57              name: web
58---
59apiVersion: v1
60kind: Service
61metadata:
62  name: service-a
63  labels:
64    run: service-a
65spec:
66  ports:
67    - port: 8081
68      protocol: TCP
69      targetPort: 80
70      name: service-a
71  selector:
72    run: service-a
73
74root@service-a-d44f55d8c-8cp8m:/# curl -v service-b:8080
75
76< HTTP/1.1 200 OK
77< server: envoy
78
79root@service-a-d44f55d8c-8cp8m:/# curl -v service-x:7777
80apiVersion: v1
81kind: Service
82metadata:
83  name: service-x
84  labels:
85    run: service-x
86spec:
87  ports:
88    - port: 7777
89      protocol: TCP
90      targetPort: 80
91      name: service-x
92  selector:
93    run: service-b
94# curl -vI service-b:8080
95
96*   Trying xx.xx.xx.xx:8080...
97* Connected to service-b (xx.xx.xx.xx) port 8080 (#0)
98> Host: service-b:8080
99< HTTP/1.1 200 OK
100< server: envoy
101# curl -vI service-x:7777
102
103*   Trying yy.yy.yy.yy:7777...
104* Connected to service-x (yy.yy.yy.yy) port 7777 (#0)
105> Host: service-x:7777
106< HTTP/1.1 200 OK
107< server: envoy
108apiVersion: v1
109kind: Service
110metadata:
111  name: service-x
112  labels:
113    run: service-x
114spec:
115  ports:
116    - port: 7777
117      protocol: TCP
118      targetPort: 80
119      name: service-x
120# curl -vI service-x:7777
121
122*   Trying yy.yy.yy.yy:7777...
123* Connected to service-x (yy.yy.yy.yy) port 7777 (#0)
124> Host: service-x:7777
125< HTTP/1.1 503 Service Unavailable
126< server: envoy
127apiVersion: networking.istio.io/v1beta1
128kind: VirtualService
129metadata:
130  name: service-x-to-b
131spec:
132  hosts:
133  - service-x
134  http:
135  - route:
136    - destination:
137        host: service-b
138        port:
139          number: 8080
140

1apiVersion: apps/v1
2kind: Deployment
3metadata:
4  name: service-b
5spec:
6  selector:
7    matchLabels:
8      run: service-b
9  replicas: 1
10  template:
11    metadata:
12      labels:
13        run: service-b
14    spec:
15      containers:
16        - name: service-b
17          image: nginx
18          ports:
19            - containerPort: 80
20              name: web
21---
22apiVersion: v1
23kind: Service
24metadata:
25  name: service-b
26  labels:
27    run: service-b
28spec:
29  ports:
30    - port: 8080
31      protocol: TCP
32      targetPort: 80
33      name: service-b
34  selector:
35    run: service-b
36
37---
38apiVersion: apps/v1
39kind: Deployment
40metadata:
41  name: service-a
42spec:
43  selector:
44    matchLabels:
45      run: service-a
46  replicas: 1
47  template:
48    metadata:
49      labels:
50        run: service-a
51    spec:
52      containers:
53        - name: service-a
54          image: nginx
55          ports:
56            - containerPort: 80
57              name: web
58---
59apiVersion: v1
60kind: Service
61metadata:
62  name: service-a
63  labels:
64    run: service-a
65spec:
66  ports:
67    - port: 8081
68      protocol: TCP
69      targetPort: 80
70      name: service-a
71  selector:
72    run: service-a
73
74root@service-a-d44f55d8c-8cp8m:/# curl -v service-b:8080
75
76< HTTP/1.1 200 OK
77< server: envoy
78
79root@service-a-d44f55d8c-8cp8m:/# curl -v service-x:7777
80apiVersion: v1
81kind: Service
82metadata:
83  name: service-x
84  labels:
85    run: service-x
86spec:
87  ports:
88    - port: 7777
89      protocol: TCP
90      targetPort: 80
91      name: service-x
92  selector:
93    run: service-b
94# curl -vI service-b:8080
95
96*   Trying xx.xx.xx.xx:8080...
97* Connected to service-b (xx.xx.xx.xx) port 8080 (#0)
98> Host: service-b:8080
99< HTTP/1.1 200 OK
100< server: envoy
101# curl -vI service-x:7777
102
103*   Trying yy.yy.yy.yy:7777...
104* Connected to service-x (yy.yy.yy.yy) port 7777 (#0)
105> Host: service-x:7777
106< HTTP/1.1 200 OK
107< server: envoy
108apiVersion: v1
109kind: Service
110metadata:
111  name: service-x
112  labels:
113    run: service-x
114spec:
115  ports:
116    - port: 7777
117      protocol: TCP
118      targetPort: 80
119      name: service-x
120# curl -vI service-x:7777
121
122*   Trying yy.yy.yy.yy:7777...
123* Connected to service-x (yy.yy.yy.yy) port 7777 (#0)
124> Host: service-x:7777
125< HTTP/1.1 503 Service Unavailable
126< server: envoy
127apiVersion: networking.istio.io/v1beta1
128kind: VirtualService
129metadata:
130  name: service-x-to-b
131spec:
132  hosts:
133  - service-x
134  http:
135  - route:
136    - destination:
137        host: service-b
138        port:
139          number: 8080
140# curl -vI service-x:7777
141
142*   Trying yy.yy.yy.yy:7777...
143* Connected to service-x (yy.yy.yy.yy) port 7777 (#0)
144> Host: service-x:7777
145< HTTP/1.1 200 OK
146< server: envoy
147

1curl -XGET 'http://localhost:36001/api/operability/list'
2[global]
3  checkNewVersion = false
4  sendAnonymousUsage = false
5
6[entryPoints]
7    [entryPoints.web]
8    address = ":8090"
9
10    [entryPoints.traefik]
11    address = ":8091"
12
13[log]
14    level = "DEBUG"
15    filePath = "logs/traefik.log"
16[accessLog]
17    filePath = "logs/access.log"
18
19[api]
20    insecure = true
21    dashboard = true
22
23[providers]
24  [providers.file]
25    filename = "traefik.toml"
26
27# dynamic conf
28[http]
29    [http.routers]
30        [http.routers.my-router]
31            rule = "Path(`/proxy`)"
32            service = "my-service"
33            entryPoints = ["web"]
34    [http.services]
35        [http.services.my-service.loadBalancer]
36            [[http.services.my-service.loadBalancer.servers]]
37                url = "http://localhost:36001"
38traefik --configFile=traefik.toml
39curl -XGET 'http://localhost:8090/proxy/api/operability/list'
40traefik version
41Version:      2.4.9
42Codename:     livarot
43Go version:   go1.16.5
44Built:        2021-06-21T16:17:58Z
45OS/Arch:      windows/amd64
46package main
47
48import (
49    "fmt"
50    "log"
51    "net/http"
52)
53
54func handler(w http.ResponseWriter, r *http.Request) {
55    fmt.Fprintf(w, "{\"message\": \"ping 123\"}")
56}
57
58func main() {
59    http.HandleFunc("/operability/list", handler)
60    log.Fatal(http.ListenAndServe(":36001", nil))
61}
62

1curl -XGET 'http://localhost:36001/api/operability/list'
2[global]
3  checkNewVersion = false
4  sendAnonymousUsage = false
5
6[entryPoints]
7    [entryPoints.web]
8    address = ":8090"
9
10    [entryPoints.traefik]
11    address = ":8091"
12
13[log]
14    level = "DEBUG"
15    filePath = "logs/traefik.log"
16[accessLog]
17    filePath = "logs/access.log"
18
19[api]
20    insecure = true
21    dashboard = true
22
23[providers]
24  [providers.file]
25    filename = "traefik.toml"
26
27# dynamic conf
28[http]
29    [http.routers]
30        [http.routers.my-router]
31            rule = "Path(`/proxy`)"
32            service = "my-service"
33            entryPoints = ["web"]
34    [http.services]
35        [http.services.my-service.loadBalancer]
36            [[http.services.my-service.loadBalancer.servers]]
37                url = "http://localhost:36001"
38traefik --configFile=traefik.toml
39curl -XGET 'http://localhost:8090/proxy/api/operability/list'
40traefik version
41Version:      2.4.9
42Codename:     livarot
43Go version:   go1.16.5
44Built:        2021-06-21T16:17:58Z
45OS/Arch:      windows/amd64
46package main
47
48import (
49    "fmt"
50    "log"
51    "net/http"
52)
53
54func handler(w http.ResponseWriter, r *http.Request) {
55    fmt.Fprintf(w, "{\"message\": \"ping 123\"}")
56}
57
58func main() {
59    http.HandleFunc("/operability/list", handler)
60    log.Fatal(http.ListenAndServe(":36001", nil))
61}
62[global]
63  checkNewVersion = false
64  sendAnonymousUsage = false
65
66[entryPoints]
67    [entryPoints.web]
68    address = ":36000"
69
70    [entryPoints.traefik]
71    address = ":8091"
72
73[log]
74    level = "DEBUG"
75    filePath = "logs/traefik.log"
76[accessLog]
77    filePath = "logs/access.log"
78
79[api]
80    insecure = true
81    dashboard = true
82
83[providers]
84  [providers.file]
85    debugLogGeneratedTemplate = true
86    # Point this same file for dynamic configuration
87    filename = "config.toml"
88    watch = true
89
90[http]
91    [http.middlewares]
92        [http.middlewares.test-replacepathregex.replacePathRegex]
93            # We need middleware to replace all "/proxy/" with "/api/"
94            regex = "(?:^|\\W)proxy(?:$|\\W)"
95            replacement = "/api/"
96
97    [http.routers]
98        [http.routers.my-router]
99            # We need to handle all request with pathes defined as "/proxy/*"
100            rule = "PathPrefix(`/proxy/`)"
101            service = "my-service"
102            entryPoints = ["web"]
103            # Use of defined middleware for path replacement
104            middlewares = ["test-replacepathregex"]
105
106    [http.services]
107        [http.services.my-service.loadBalancer]
108            [[http.services.my-service.loadBalancer.servers]]
109                url = "http://localhost:36001/"
110

1curl -XGET 'http://localhost:36001/api/operability/list'
2[global]
3  checkNewVersion = false
4  sendAnonymousUsage = false
5
6[entryPoints]
7    [entryPoints.web]
8    address = ":8090"
9
10    [entryPoints.traefik]
11    address = ":8091"
12
13[log]
14    level = "DEBUG"
15    filePath = "logs/traefik.log"
16[accessLog]
17    filePath = "logs/access.log"
18
19[api]
20    insecure = true
21    dashboard = true
22
23[providers]
24  [providers.file]
25    filename = "traefik.toml"
26
27# dynamic conf
28[http]
29    [http.routers]
30        [http.routers.my-router]
31            rule = "Path(`/proxy`)"
32            service = "my-service"
33            entryPoints = ["web"]
34    [http.services]
35        [http.services.my-service.loadBalancer]
36            [[http.services.my-service.loadBalancer.servers]]
37                url = "http://localhost:36001"
38traefik --configFile=traefik.toml
39curl -XGET 'http://localhost:8090/proxy/api/operability/list'
40traefik version
41Version:      2.4.9
42Codename:     livarot
43Go version:   go1.16.5
44Built:        2021-06-21T16:17:58Z
45OS/Arch:      windows/amd64
46package main
47
48import (
49    "fmt"
50    "log"
51    "net/http"
52)
53
54func handler(w http.ResponseWriter, r *http.Request) {
55    fmt.Fprintf(w, "{\"message\": \"ping 123\"}")
56}
57
58func main() {
59    http.HandleFunc("/operability/list", handler)
60    log.Fatal(http.ListenAndServe(":36001", nil))
61}
62[global]
63  checkNewVersion = false
64  sendAnonymousUsage = false
65
66[entryPoints]
67    [entryPoints.web]
68    address = ":36000"
69
70    [entryPoints.traefik]
71    address = ":8091"
72
73[log]
74    level = "DEBUG"
75    filePath = "logs/traefik.log"
76[accessLog]
77    filePath = "logs/access.log"
78
79[api]
80    insecure = true
81    dashboard = true
82
83[providers]
84  [providers.file]
85    debugLogGeneratedTemplate = true
86    # Point this same file for dynamic configuration
87    filename = "config.toml"
88    watch = true
89
90[http]
91    [http.middlewares]
92        [http.middlewares.test-replacepathregex.replacePathRegex]
93            # We need middleware to replace all "/proxy/" with "/api/"
94            regex = "(?:^|\\W)proxy(?:$|\\W)"
95            replacement = "/api/"
96
97    [http.routers]
98        [http.routers.my-router]
99            # We need to handle all request with pathes defined as "/proxy/*"
100            rule = "PathPrefix(`/proxy/`)"
101            service = "my-service"
102            entryPoints = ["web"]
103            # Use of defined middleware for path replacement
104            middlewares = ["test-replacepathregex"]
105
106    [http.services]
107        [http.services.my-service.loadBalancer]
108            [[http.services.my-service.loadBalancer.servers]]
109                url = "http://localhost:36001/"
110go run main.go
111

1curl -XGET 'http://localhost:36001/api/operability/list'
2[global]
3  checkNewVersion = false
4  sendAnonymousUsage = false
5
6[entryPoints]
7    [entryPoints.web]
8    address = ":8090"
9
10    [entryPoints.traefik]
11    address = ":8091"
12
13[log]
14    level = "DEBUG"
15    filePath = "logs/traefik.log"
16[accessLog]
17    filePath = "logs/access.log"
18
19[api]
20    insecure = true
21    dashboard = true
22
23[providers]
24  [providers.file]
25    filename = "traefik.toml"
26
27# dynamic conf
28[http]
29    [http.routers]
30        [http.routers.my-router]
31            rule = "Path(`/proxy`)"
32            service = "my-service"
33            entryPoints = ["web"]
34    [http.services]
35        [http.services.my-service.loadBalancer]
36            [[http.services.my-service.loadBalancer.servers]]
37                url = "http://localhost:36001"
38traefik --configFile=traefik.toml
39curl -XGET 'http://localhost:8090/proxy/api/operability/list'
40traefik version
41Version:      2.4.9
42Codename:     livarot
43Go version:   go1.16.5
44Built:        2021-06-21T16:17:58Z
45OS/Arch:      windows/amd64
46package main
47
48import (
49    "fmt"
50    "log"
51    "net/http"
52)
53
54func handler(w http.ResponseWriter, r *http.Request) {
55    fmt.Fprintf(w, "{\"message\": \"ping 123\"}")
56}
57
58func main() {
59    http.HandleFunc("/operability/list", handler)
60    log.Fatal(http.ListenAndServe(":36001", nil))
61}
62[global]
63  checkNewVersion = false
64  sendAnonymousUsage = false
65
66[entryPoints]
67    [entryPoints.web]
68    address = ":36000"
69
70    [entryPoints.traefik]
71    address = ":8091"
72
73[log]
74    level = "DEBUG"
75    filePath = "logs/traefik.log"
76[accessLog]
77    filePath = "logs/access.log"
78
79[api]
80    insecure = true
81    dashboard = true
82
83[providers]
84  [providers.file]
85    debugLogGeneratedTemplate = true
86    # Point this same file for dynamic configuration
87    filename = "config.toml"
88    watch = true
89
90[http]
91    [http.middlewares]
92        [http.middlewares.test-replacepathregex.replacePathRegex]
93            # We need middleware to replace all "/proxy/" with "/api/"
94            regex = "(?:^|\\W)proxy(?:$|\\W)"
95            replacement = "/api/"
96
97    [http.routers]
98        [http.routers.my-router]
99            # We need to handle all request with pathes defined as "/proxy/*"
100            rule = "PathPrefix(`/proxy/`)"
101            service = "my-service"
102            entryPoints = ["web"]
103            # Use of defined middleware for path replacement
104            middlewares = ["test-replacepathregex"]
105
106    [http.services]
107        [http.services.my-service.loadBalancer]
108            [[http.services.my-service.loadBalancer.servers]]
109                url = "http://localhost:36001/"
110go run main.go
111traefik --configFile config.toml
112